且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

连接Web应用程序中的数据库

更新时间: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[^]