ليلا اسدي
سه شنبه 26 شهریور 1387, 14:12 عصر
من براي وصل شدن به پايگاه داده ام اين كد را نوشته ام:
protected void btn_sabtkala_Click(object sender, EventArgs e)
{
SqlConnection sc = new SqlConnection("server=(local);uid=;pwd=;database=anbar");
SqlDataAdapter sda = new SqlDataAdapter("select nrow,kalaname,number,price,entireprice,inputyear,i nputmonth,inputday,givername,categori,kharidar,bil lnum,billyear,billmonth,billday,inputtype,from,acc ount,entity,ordernum,orderyear,ordermonth,orderday ,usetype,holder,holdunit,holdyear,holdmonth,holdda y,description,billr,orderr,requestr", sc);
string insertcmd="INSERT INTO tsabt(nrow,kalaname,number,price,entireprice,input year,inputmonth,billr,orderr,requestr) VALUES ("+"0,"+kalaname.Text.Trim()+","+number.Text.Trim()+","+price.Text.Trim"+entireprice.Text.Trim()+","+inputyear.Text.Trim()+","+inputmonth.Text.Trim()+","+inputday.Text.Trim()+","+givername.Text.Trim()+","+billr.Checked+","+orderr.Checked+")";
SqlCommand scf=new SqlCommand(insertcmd,sc);
// DataSet ds = new DataSet();
scf.Connection.Open();
scf.ExecuteNonQuery();
scf.Connection.Close();
اما اين خطا را ميدهد:
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL Server connection.
حالا بايد چه كنم؟
تو رو خدا زودتر جوابم رو بدين كه از هر چي connection stringb هست كلافه شدم:عصبانی++:
protected void btn_sabtkala_Click(object sender, EventArgs e)
{
SqlConnection sc = new SqlConnection("server=(local);uid=;pwd=;database=anbar");
SqlDataAdapter sda = new SqlDataAdapter("select nrow,kalaname,number,price,entireprice,inputyear,i nputmonth,inputday,givername,categori,kharidar,bil lnum,billyear,billmonth,billday,inputtype,from,acc ount,entity,ordernum,orderyear,ordermonth,orderday ,usetype,holder,holdunit,holdyear,holdmonth,holdda y,description,billr,orderr,requestr", sc);
string insertcmd="INSERT INTO tsabt(nrow,kalaname,number,price,entireprice,input year,inputmonth,billr,orderr,requestr) VALUES ("+"0,"+kalaname.Text.Trim()+","+number.Text.Trim()+","+price.Text.Trim"+entireprice.Text.Trim()+","+inputyear.Text.Trim()+","+inputmonth.Text.Trim()+","+inputday.Text.Trim()+","+givername.Text.Trim()+","+billr.Checked+","+orderr.Checked+")";
SqlCommand scf=new SqlCommand(insertcmd,sc);
// DataSet ds = new DataSet();
scf.Connection.Open();
scf.ExecuteNonQuery();
scf.Connection.Close();
اما اين خطا را ميدهد:
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL Server connection.
حالا بايد چه كنم؟
تو رو خدا زودتر جوابم رو بدين كه از هر چي connection stringb هست كلافه شدم:عصبانی++: