如何从数据库中读取数据的值? [英] how can I read values of fields from database with data ?
本文介绍了如何从数据库中读取数据的值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
string strDSN = @ Provider = Microsoft.Jet.OLEDB.4.0; Data Source = d:\ diyy.mdb;
string strSQL = SELECT * FROM project其中ID =' + dbProjID + ';
// 创建ADOConnection对象和ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL,myConn);
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, Developer);
DataTable dTable = dtSet.Tables [ 0 ];
foreach (DataRow dtRow in dTable.Rows)
{
table.AddCell(dtRow [i] .ToString());
}
解决方案
HI,因为您现在获取数据表中的值以获取数据字段,您必须如下所示:
if (dt.Rows.Count > 0 ) // 检查DataTable是否从数据库返回任何数据
{
string val = dt.Rows [ 0 ] [ FieldName< /跨度>]的ToString(); // 其中Fieldname是您要获取的数据库中的字段名称
}
string strDSN = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\diy.mdb";
string strSQL = "SELECT * FROM project where ID='" + dbProjID + "'";
// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter(strSQL, myConn);
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill(dtSet, "Developer");
DataTable dTable = dtSet.Tables[0];
foreach (DataRow dtRow in dTable.Rows)
{
table.AddCell(dtRow[i].ToString());
}
解决方案
HI as you get the values in datatable now to get data field wise you have to fetch like this below:
if (dt.Rows.Count > 0) // Check if the DataTable returns any data from database { string val = dt.Rows[0]["FieldName"].ToString(); // Where Fieldname is the name of fields from your database that you want to get }
这篇关于如何从数据库中读取数据的值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文