using System;
using System.Data;
using System.Data.SqlClient;namespace Northwind
{
class Program
{
static void Main(string[] args)
{
SqlConnection sqlConn = null;
try
{
//创建连接对象,使用集成安全方式连接,更安全
sqlConn = new SqlConnection(@"server=localhost;database=northwind;uid=sa;pwd=tianshi520");
//打开数据库
sqlConn.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(
"select CategoryID, CategoryName form Categories", sqlConn); sqlDataAdapter.UpdateCommand = new SqlCommand(
"update Categories set CategoryName=@CategoryCame" +
"where CategoryID=@CategoryID", sqlConn);
sqlDataAdapter.UpdateCommand.Parameters.Add("@CategoryName",
SqlDbType.NVarChar, 15, "CategoryName"); SqlParameter workParm = sqlDataAdapter.UpdateCommand.Parameters.Add(
"@CategoryID", SqlDbType.Int);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds, "Categories"); DataRow row = ds.Tables["Categories"].Rows[0];
row["CategoryName"] = "New Category"; sqlDataAdapter.Update(ds); foreach (DataRow dr in ds.Tables["Categories"].Rows)
{
Console.WriteLine("{0, -15}{1, -15}",
dr["CategoryID"], dr["CategoryName"]);
}
}
catch (System.Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.Source);
}
finally
{
//断开数据库连接
sqlConn.Close();
} }
}
}
帮看看哪里出错,我们明白!
using System.Data;
using System.Data.SqlClient;namespace Northwind
{
class Program
{
static void Main(string[] args)
{
SqlConnection sqlConn = null;
try
{
//创建连接对象,使用集成安全方式连接,更安全
sqlConn = new SqlConnection(@"server=localhost;database=northwind;uid=sa;pwd=tianshi520");
//打开数据库
sqlConn.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(
"select CategoryID, CategoryName form Categories", sqlConn); sqlDataAdapter.UpdateCommand = new SqlCommand(
"update Categories set CategoryName=@CategoryCame" +
"where CategoryID=@CategoryID", sqlConn);
sqlDataAdapter.UpdateCommand.Parameters.Add("@CategoryName",
SqlDbType.NVarChar, 15, "CategoryName"); SqlParameter workParm = sqlDataAdapter.UpdateCommand.Parameters.Add(
"@CategoryID", SqlDbType.Int);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;
DataSet ds = new DataSet();
sqlDataAdapter.Fill(ds, "Categories"); DataRow row = ds.Tables["Categories"].Rows[0];
row["CategoryName"] = "New Category"; sqlDataAdapter.Update(ds); foreach (DataRow dr in ds.Tables["Categories"].Rows)
{
Console.WriteLine("{0, -15}{1, -15}",
dr["CategoryID"], dr["CategoryName"]);
}
}
catch (System.Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.Source);
}
finally
{
//断开数据库连接
sqlConn.Close();
} }
}
}
帮看看哪里出错,我们明白!
from写成了 form