DataView与DataRowView的用法
来源：
|
时间：2011/3/15 14:24:42
|
- <PRE class=c# name="code"><PRE class=c# name="code">public void getData()
- {
- SqlConnetion con=new SqlConnection"sever=.;database=;uid=;pwd=;")
- SqlCommand cmd=con.CreateCommand();
- cmd.CmdText="";
- DataSet ds=new DataSet();
- DataAdapter da=new DataAdapter(cmd);
- da.Fill(ds);
-
- string text=ds.tables[0].Rows[0][1].ToString();
-
- DataTable dt=ds.tables[0];
- string text=dt.Rows[0][1].ToString();
-
- DataTable dt=new DataTable();
- dt.Load(ds);
- string text=dt.Rows[0][1].ToString();
- }
- </PRE>
- DataRowView drv = bindPhoto().DefaultView[0];
- Response.Write(drv.Row["photoUrl"].ToString());
- DataView dv = new DataView(bindPhoto());
- Response.Write(dv.Table.Rows[0][1].ToString());
- DataRow[] dr = bindPhoto().Select();
- foreach (DataRow r in dr)
- {
- Response.Write(r["photoUrl"].ToString());
- } </PRE>
-
- DataTable total=new DataTable();
-
- total.Columns.Add(new DataColumn("班组",typeof(string)));
- total.Columns.Add(new DataColumn("姓名",typeof(string)));
- total.Columns.Add(new DataColumn("学科",typeof(string)));
- total.Columns.Add(new DataColumn("成绩",typeof(int)));
-
- DataRow dr=total.NewRow();
-
- dr["班组"]= "一班";
- dr["姓名"]= " 李宏";
- dr["学科"]= "
