用c#窗体程序实现从数据库读出某一行数据并能对其进行修改保存

Question

如题...大神们帮帮忙吧

Answer 1

private string ConnStr = "数据库路径";
protected OleDbConnection conn = new OleDbConnection();
protected OleDbCommand comm = new OleDbCommand(); conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + ConnStr;//
comm.Connection = conn; conn.Open(); string sqlstr=“查询语句"; DataTable tmptable=dataTable(sqlstr);foreach(DataRow dr in tmptable.Rows){ sqlstr="修改语句";excuteSql(sqlstr);} private DataTable dataTable(string sqlstr)
{
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter();
try
{
openConnection();
comm.CommandType = CommandType.Text;
comm.CommandText = sqlstr;
da.SelectCommand = comm;
da.Fill(dt);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
return dt;
}//返回指定sql语句的datatable private string excuteSql(string sqlstr)
{
try
{
openConnection();
comm.CommandType = CommandType.Text;
comm.CommandText = sqlstr;
comm.ExecuteNonQuery();
}
catch (Exception e)
{
return e.Message.ToString();
}
finally
{ closeConnection(); }
return "";
}//执行sql语句

Answer 2

连接数据库读出你要进行修改的数据保存到datatable中在页面进行修改将修改的数据传入update语句执行就行了。

Answer 3

用 System.Data.SqlClient.SqlCommandBuilder 可以实现你要的效果 在baidu里面 搜索 C# SqlCommandBuilder 随便点开一点 就是你想要的效果