连接Web应用程序中的数据库 [英] connect database in web application

问题描述

这里我的工作非常简单....



我想在c＃web应用程序中连接数据库SQL server 2008。我只想在该数据库中插入一些值。



我在谷歌搜索但这不适合初学者，因为我是初学者。这意味着我想要更清楚。







请详细说明。提前谢谢

Here I am for very simple work....

I want to connect database SQL server 2008 in c# web application. I just want to insert some value in that database.

I searched in Google but that is not for very beginner as i am very beginner. that means i want to be more clear about that.



please give details. thanks in advance

推荐答案

参考

初学者指南，通过C＃访问SQL Server [ ^ ]



http://msdn.microsoft.com/en-us/library/s4yys16a（v = vs.90）.aspx [ ^ ]



否则，请观看此管上的视频

https://www.youtube.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.youtube.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 [ ^ ] < br $>




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[^]

这篇关于连接Web应用程序中的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！