更新时间:2022-12-21 18:09:06
参考
初学者指南,通过C#访问SQL Server [ ^ ]
http://msdn.microsoft.com/en-us/library/s4yys16a(v = vs.90).aspx [ ^ ]
否则,请观看此管上的视频
https://www.***.com/watch?v=ZNObiptSMSI&list=TLltsNNCVzkJlKn-iT-dmiKAaj0MujY57f [ ^ ]
Refer
Beginners guide to accessing SQL Server through C#[^]
http://msdn.microsoft.com/en-us/library/s4yys16a(v=vs.90).aspx[^]
Otherwise watch this video on you tube
https://www.***.com/watch?v=ZNObiptSMSI&list=TLltsNNCVzkJlKn-iT-dmiKAaj0MujY57f[^]
试试这种方式
public int InsertData()
{
SqlConnection con = new SqlConnection();
con.Open();
con.ConnectionString =Data Source = USER-PC\USER;初始目录= db_Test;集成安全性= SSPI;
字符串查询=插入Persons_info(perID,latinName,性别)值('+ txtID.Text +','+ txtLatinName.Text +', '+ cbGender.Text +');
SqlCommand cmd = new SqlCommand(query,con);
返回cmd .ExecuteNonQuery();
}
http://aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx [ ^ ]
http://programmingposts.blogspot.in/2013/09/simple-registration-form-in-aspnet.html [ ^ ]
Try this way
public int InsertData()
{
SqlConnection con=new SqlConnection();
con.Open();
con.ConnectionString="Data Source=USER-PC\USER; Initial Catalog=db_Test; Integrated Security=SSPI";
string query="insert into Persons_info(perID, latinName, gender) values('" + txtID.Text + "','" + txtLatinName.Text + "','" + cbGender.Text + "'" )";
SqlCommand cmd=new SqlCommand(query,con);
return cmd.ExecuteNonQuery();
}
http://aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx[^]
http://programmingposts.blogspot.in/2013/09/simple-registration-form-in-aspnet.html[^]