privateDataTable GetData() { DataTable dt =newDataTable(); using(SqlConnection connection =newSqlConnection("ConnectionString")) using(SqlCommand command =newSqlCommand()) { command.Connection = connection; command.CommandText ="SELECT * FROM Customers"; connection.Open(); using(SqlDataReader reade...
1publicIList GetModelList(stringtablename,stringwhere)2{3IList list =null;4DataTable dataTable =newDataTable();5stringsql ="select * from"+tablename;6if(where!="")7{8sql +="Where"+where;9}10try11{12System.Data.SqlClient.SqlDataReader dr =DbHelperSQL.ExcuteReader(sql);13for(inti =0...
myDataColumn.DataType = myRow["DataTypeName"].GetType(); myDataColumn.ColumnName = myRow[0].ToString(); datatable.Columns.Add(myDataColumn); } //添加数据 while (dataReader.Read()) { DataRow myDataRow = datatable.NewRow(); for (int i = 0; i < schemaTable.Rows.Count; i++) { ...
SqlDataReader”隐式转换... 因为你用的是SQL数据库,把OleDbDataReader read = DBFun.dataReader(sql);改成System.Data.SqlClient.SqlDataReader read = DBFun.dataReader(sql);如果你用的是ACCESS,则... System.Data.DataTable dt = new System.Data.DataTable();请IT达人详细地翻译一下 System.Data.DataT...
将SqlDataReader转换为DataTable(转) 将SqlDataReader转换为DataTable(转) 2009-12-29 10:16:05| 分类:net|字号订阅 代码一: private void Form1_Load(object sender, EventArgs e) { dataGridView1.DataSource = GetData(); } private DataTable GetData() { DataTable dt = new DataTable(); using (...
using (SqlDataReader reader = command.ExecuteReader (CommandBehavior.CloseConnection)) { dt.Load(reader); } } return dt; } 代码二: private void Form1_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Load(GetReader()); ...