62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable dt=ViewData["datasource"] as DataTable;
foreach(DataRow row in dt)
{
//这里写Html,可以是<ul><li>,也可以是 <tr><td>,具体怎么布局自己选择吧
//例如:
<tr>
<td>产品名称<td>
<td>产品类别<td>
</tr>
<tr>
<td>row["ProductName"]<td>
<td>row["ProductTypeName"]<td>
</tr>
}
public ActionResult Index()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("id", typeof(int)));
dt.Columns.Add(new DataColumn("name", typeof(string)));
DataRow dr = dt.NewRow();
dr[0] = 1;
dr[1] = "a";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = 2;
dr[1] = "b";
dt.Rows.Add(dr);
ViewBag.Message = dt;
return View();
}
@{
ViewBag.Title = "Home Page";
System.Data.DataTable dt = (System.Data.DataTable)ViewBag.Message;
for (int i = 0, c = dt.Rows.Count; i < c; i++)
{
@dt.Rows[i]["Name"]
}
}
private static SqlConnection cn; //创建SQL连接
private static SqlDataAdapter sda; //创建SQL数据适配器
private static SqlDataReader sdr; //创建SQL数据读取器
private static SqlCommand cmd; //创建SQL命令对象
private static SqlParameter param; //创建SQL参数
private static DataSet ds; //创建数据集
private static DataView dv; //创建视图
/// <summary>
/// 打开数据库连接
/// </summary>
private static void Open()
{
#region
var db = new DBServer
{
DBName = "FiberPDR",
//DBName = "ZTAM_PIMSDB_TEST",
DBPWD = @"#zfoc@data*",
DBUser = "sa",
ServerIP = "192.168.2.1"
};
cn = new SqlConnection(db.ConnString());
cn.Open();
#endregion
}
/// <summary>pxoenix
///
/// 关闭数据库连接
/// </summary>
private static void Close()
{
#region
if (cn != null)
{
cn.Close();
cn.Dispose();
}
#endregion
}
/// <summary>
/// 创建参数数组
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public static SqlParameter[] CreateParams(int count)
{
return new SqlParameter[count];
}
/// <summary>
/// 获得DataTable对象,返回最后一个表
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <param name="ps"></param>
/// <returns></returns>
public static DataTable GetDt(string strSql, SqlParameter[] ps)
{
#region
var ds = GetDs(strSql, ps);
var i = ds.Tables.Count - 1;
cmd.Parameters.Clear();
return ds.Tables[i];
#endregion
}