如果,你使用的是SQL SERVER数据库你可以使用system.data.sqlclient中的类基本方法有两中,第一你可以使用command+datareader
第二你可以使用dataset+dataAdpater关于.NET中的数据操作参考:ms-help://MS.VSCC/MS.MSDNVS.2052/Vbcon/html/vboriIntegratingDataVB.htm
第二你可以使用dataset+dataAdpater关于.NET中的数据操作参考:ms-help://MS.VSCC/MS.MSDNVS.2052/Vbcon/html/vboriIntegratingDataVB.htm
dsCommand.SelectCommand = new SqlCommand( "select * from Table where a = 11", connection );
DataSet dataSet = new DataSet();
dsCommand.Fill( dataSet );
******************************
this.dataGrid.DataSource = this.dataSet.Tables[0].DefaultView;
SqlConnection myConn = new System.Data.SqlClient.SqlConnection(strConnString);
myConn.Open();
SqlDataAdapter MyAdapter = new SqlDataAdapter(str,myConn);
DataSet ds = new DataSet();
MyAdapter.Fill(ds,"Table");
DataTable datatable = ds.Tables[0];
怎么用foreach遍历Rows集合,比方说Rows集合包含题目中的4个字段。我是菜菜鸟,不要笑话俺哦,谢谢~~~
{
row[0]......
}
能不能把你的要求些具体点~~
{
Console.WriteLine(); //这句该如何写?
}请问语句怎么写?谢谢
// Use the MakeTable function below to create a new table.
DataTable myTable;
myTable = MakeNamesTable();
// Once a table has been created, use the NewRow to create a DataRow.
DataRow myRow;
myRow = myTable.NewRow();
// Then add the new row to the collection.
myRow["fName"] = "John";
myRow["lName"] = "Smith";
myTable.Rows.Add(myRow);
foreach(DataColumn dc in myTable.Columns)
Console.WriteLine(dc.ColumnName); !!!!!!!!!!!!!!!!!!!!!!!!!!!!
dataGrid1.DataSource=myTable;
}
private DataTable MakeNamesTable(){
// Create a new DataTable titled 'Names.'
DataTable namesTable = new DataTable("Names");
// Add three column objects to the table.
DataColumn idColumn = new DataColumn();
idColumn.DataType = System.Type.GetType("System.Int32");
idColumn.ColumnName = "id";
idColumn.AutoIncrement = true;
namesTable.Columns.Add(idColumn);
DataColumn fNameColumn = new DataColumn();
fNameColumn.DataType = System.Type.GetType("System.String");
fNameColumn.ColumnName = "Fname";
fNameColumn.DefaultValue = "Fname";
namesTable.Columns.Add(fNameColumn);
DataColumn lNameColumn = new DataColumn();
lNameColumn.DataType = System.Type.GetType("System.String");
lNameColumn.ColumnName = "LName";
namesTable.Columns.Add(lNameColumn);
// Create an array for DataColumn objects.
DataColumn [] keys = new DataColumn [1];
keys[0] = idColumn;
namesTable.PrimaryKey = keys;
// Return the new DataTable.
return namesTable;
}
上面的东西对你可能有用!
{
String a = dataRow[0].ToString();
String b = dataRow[1].ToString();
String c = dataRow[2].ToString();
String d = dataRow[3].ToString();
Console.WriteLine( "a is " + a.....
}
不知是不是你要得?~~