连接问题 [英] problem in connecting

问题描述

sql连接

推荐答案

Google是您的朋友.

试试这个.
http://en.kioskea.net/forum/affich-61898-how-to-make-make-database-connectivity-in-asp-net [

Google is your friend.

Try this.
http://en.kioskea.net/forum/affich-61898-how-to-make-database-connectivity-in-asp-net[^]

下面是一个简单的连接示例:

注意:在SQL Server Management Studio中创建表.

Here is a simple example of connectivity :

Note : Make the tables in SQL Server Management Studio.

protected void btnsubmit_Click(object sender, EventArgs e)
    {
           SqlConnection CON;
           SqlCommand COM;
       CON = new SqlConnection(ConfigurationManager.ConnectionStrings["Database_Name"].ConnectionString);
      COM = new SqlCommand("INSERT INTO TableName (ID, Name, Address) VALUES (@ID, @Name, @Address)", CON);
            COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar,10);
            COM.Parameters["@ID"].Value = txtid.Text;
            COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar,50);
            COM.Parameters["@Name"].Value = txtname.Text;
            COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar,100);        
            COM.Parameters["@Address"].Value = txtaddress.Text;       
            CON.Open();    
        COM.ExecuteNonQuery();
        Response.Redirect("Default.aspx");       
        //CON.Close();

    }
    protected void btnupdate_Click(object sender, EventArgs e)
    {
          SqlConnection CON;
           SqlCommand COM;
       CON = new SqlConnection(ConfigurationManager.ConnectionStrings["Database_Name"].ConnectionString);
      //COM = new SqlCommand("update TableName set id=''"+txtid.Text+"'',Name=''"+txtname.Text+"'',Address=''"+txtaddress.Text+"''");
       COM = new SqlCommand("Update <b>TableName</b>set Name=@Name,Address=@Address where ID=@Id",CON);
       COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar, 10);
       COM.Parameters["@ID"].Value = txtid.Text;
       COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar, 50);
       COM.Parameters["@Name"].Value = txtname.Text;
       COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar, 100);
       COM.Parameters["@Address"].Value = txtaddress.Text;
       CON.Open();
       COM.ExecuteNonQuery();
       Response.Redirect("Default.aspx");
       CON.Close();
        
      }
    protected void btndelete_Click(object sender, EventArgs e)
    {
        SqlConnection CON;
        SqlCommand COM;
        CON = new SqlConnection(ConfigurationManager.ConnectionStrings["DataBaseName"].ConnectionString);
        COM = new SqlCommand("Delete from TableName where ID=@ID",CON);
        COM.Parameters.Add("@ID", System.Data.SqlDbType.NChar, 10);
        COM.Parameters["@ID"].Value = txtid.Text;
        COM.Parameters.Add("@Name", System.Data.SqlDbType.NChar, 50);
        COM.Parameters["@Name"].Value = txtname.Text;
        COM.Parameters.Add("@Address", System.Data.SqlDbType.NChar, 100);
        COM.Parameters["@Address"].Value = txtaddress.Text;
        CON.Open();
        COM.ExecuteNonQuery();
        Response.Redirect("Default.aspx");
        CON.Close();
    }

在Web.Config中添加连接字符串

Add a connection String in Web.Config

<connectionStrings>
        <add name="DataBaseName" connectionString="Server=ADMIN-PC;Database=DataBaseName;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>

您是否在互联网上搜索?我发现了很多您可以开始使用的链接.或者最好开始阅读有关ASP.Net DB Connectivity的书.

我找到的一些链接-
http://www.w3schools.com/aspnet/aspnet_dbconnection.asp [ http://msdn.microsoft.com/en-us/library/ff648340.aspx [ ^ ]

Did you search on the internet? I found a huge number of links that you could start with. Or better start reading a book on ASP.Net DB Connectivity.

Some links that I found -
http://www.w3schools.com/aspnet/aspnet_dbconnection.asp[^]
http://msdn.microsoft.com/en-us/library/ff648340.aspx[^]

这篇关于连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！