62,046
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
breezem 2003-08-12
- 打赏
- 举报
这不用多讲了吧？你最好自己装个quickstart看看先，别人讲的不如自己看的印象深刻
mengzhumeng 2003-08-12
- 打赏
- 举报
luckycrazy() 你呢?也给我说说好吗?谢谢!我是个初学者!
mengzhumeng 2003-08-12
- 打赏
- 举报
breezem(夜空幽灵)你可以给我讲讲吗?
luckycrazy 2003-08-12
- 打赏
- 举报
using system.data.sqlClient
SqlConnection con = new SqlConnection("workstation id=DUANEYE;packet size=4096;user id=sa;data source=DUANEYE;persist security info=False;initial catalog=Northwind");
SqlDataAdapter adp = new SqlDataAdapter("SELECT CategoryID, CategoryName, Description, Picture FROM Categories",con);
DataSet ds = new DataSet();
adp.Fill(ds);
SqlConnection con = new SqlConnection("workstation id=DUANEYE;packet size=4096;user id=sa;data source=DUANEYE;persist security info=False;initial catalog=Northwind");
SqlDataAdapter adp = new SqlDataAdapter("SELECT CategoryID, CategoryName, Description, Picture FROM Categories",con);
DataSet ds = new DataSet();
adp.Fill(ds);
breezem 2003-08-12
- 打赏
- 举报
public void InsertRow(string myConnectionString)
{
// If the connection string is null, use a default.
if(myConnectionString == "")
{
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
}
SqlConnection myConnection = new SqlConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
{
// If the connection string is null, use a default.
if(myConnectionString == "")
{
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
}
SqlConnection myConnection = new SqlConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
