مهسا نوروزي
چهارشنبه 12 خرداد 1389, 09:54 صبح
سلام به دوستان
من sql 2000و visual studio 2005 روي سيستمم نصب كردم ودو تا جدول توي بانكم گذاشتم
و در vs دوتا textbox و يك buttion قرار دادم ميخوام وقتي دكمه فشرده ميشه اطلاعات textbox ها وارد بانكم بشه با اين كد :
SqlConnection con1 = new SqlConnection
("server=(TIRAGE-PC2);uid=sa;pwd=database=DBtest");
SqlDataAdapter da1 = new SqlDataAdapter("select * from user",con1);
string str1 = "INSERT INTO TABLE user(id,pass) VALUES(@id,@pass)";
SqlCommand sc1 = new SqlCommand(str1,con1);
sc1.Parameters.Add("@id",SqlDbType.NChar);
sc1.Parameters["@id"].Value = TextBox1.Text;
sc1.Parameters.Add("@pass", SqlDbType.NChar);
sc1.Parameters["@pass"].Value = TextBox2.Text;
sc1.Connection.Open();
sc1.ExecuteNonQuery();
sc1.Connection.Close();
DataSet ds1 = new DataSet();
da1.Fill(ds1,"user");
DataGrid1.DataSource = ds1.Tables["user"].DefaultView;
DataGrid1.DataBind();
DataGrid1.Visible = true;
اسم server group من TIRAGE-PC2\TIRAGEPANEL هست ولي وقتي اسمش رو مينويسم خطا ميگيره
وقتي اجرا ميكنم اين خطا رو ميده:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
من sql 2000و visual studio 2005 روي سيستمم نصب كردم ودو تا جدول توي بانكم گذاشتم
و در vs دوتا textbox و يك buttion قرار دادم ميخوام وقتي دكمه فشرده ميشه اطلاعات textbox ها وارد بانكم بشه با اين كد :
SqlConnection con1 = new SqlConnection
("server=(TIRAGE-PC2);uid=sa;pwd=database=DBtest");
SqlDataAdapter da1 = new SqlDataAdapter("select * from user",con1);
string str1 = "INSERT INTO TABLE user(id,pass) VALUES(@id,@pass)";
SqlCommand sc1 = new SqlCommand(str1,con1);
sc1.Parameters.Add("@id",SqlDbType.NChar);
sc1.Parameters["@id"].Value = TextBox1.Text;
sc1.Parameters.Add("@pass", SqlDbType.NChar);
sc1.Parameters["@pass"].Value = TextBox2.Text;
sc1.Connection.Open();
sc1.ExecuteNonQuery();
sc1.Connection.Close();
DataSet ds1 = new DataSet();
da1.Fill(ds1,"user");
DataGrid1.DataSource = ds1.Tables["user"].DefaultView;
DataGrid1.DataBind();
DataGrid1.Visible = true;
اسم server group من TIRAGE-PC2\TIRAGEPANEL هست ولي وقتي اسمش رو مينويسم خطا ميگيره
وقتي اجرا ميكنم اين خطا رو ميده:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)