nefrat
جمعه 08 اردیبهشت 1391, 17:46 عصر
سلام
میشه در رفع اشکالات برنامه ام من رو کمک کنید؟
یه برنامه دارم میخوام اطلاعات دانشجو ها رو ثبت کنم :
این کد رو داخل دکمه ثبت گذاشتم :
private void button1_Click(object sender, EventArgs e)
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.InsertCommand = new SqlCommand();
SqlConnection sc = new SqlConnection(@"Data Source=NEGAR-PC;;Initial Catalog=Uni;Integrated Security=True");
if (sc.State != ConnectionState.Closed) { sc.Close(); }
sc.Open();
sda.InsertCommand.Connection = sc;
sda.InsertCommand.CommandType = CommandType.StoredProcedure;
sda.InsertCommand.CommandText = "SP_INSERT";
sda.InsertCommand.Parameters.AddWithValue("@NAME", txtname.Text);
sda.InsertCommand.Parameters.AddWithValue("@FAMILY", txtfamily.Text);
sda.InsertCommand.Parameters.AddWithValue("@SHSH", txtshsh.Text);
sda.InsertCommand.Parameters.AddWithValue("@SODUR", txtsodur.Text );
sda.InsertCommand.Parameters.AddWithValue("@MCODE", txtmcode.Text);
sda.InsertCommand.Parameters.AddWithValue("@BDAY", txtbday.Text);
sda.InsertCommand.Parameters.AddWithValue("@BMOUNTH", txtbmounth.Text);
sda.InsertCommand.Parameters.AddWithValue("@BYEAR", txtyear.Text );
sda.InsertCommand.Parameters.AddWithValue("@BCITY", txtbcity.Text );
sda.InsertCommand.Parameters.AddWithValue("@FANAME", txtfaname.Text);
sda.InsertCommand.Parameters.AddWithValue("@PHONE", txtphone.Text);
sda.InsertCommand.Parameters.AddWithValue("@MOBILE", txtmobile.Text);
sda.InsertCommand.Parameters.AddWithValue("@RESHTE", txtreshteh.Text);
sda.InsertCommand.Parameters.AddWithValue("@MAGHTA", txtmaghta.Text);
sda.InsertCommand.ExecuteNonQuery();
sda.SelectCommand = new SqlCommand();
sda.SelectCommand.CommandType = CommandType.Text;
sda.SelectCommand.CommandText = "SELECT * FROM [STUDENT]";
sda.SelectCommand.Connection = sc;
DataSet DS = new DataSet();
sda.Fill(DS);
GRID.DataSource = DS.Tables[0];
DataTableReader DR = new DataTableReader(DS.Tables[0]);
while (DR.Read())
{
//treeView1.Nodes.Add(DR["NAME"].ToString());
//comboBox1.Items.Add(DR["ID"].ToString());
}
sc.Close();
}
و داخل sql این کد رو گذاشتم »
USE [Uni]
GO
CREATE PROCEDURE SP_INSERT
@NAME AS NVARCHAR(50)
,@FAMILY AS NVARCHAR(80)
,@SHSH AS INT
,@SODUR AS NVARCHAR(50)
,@MCODE AS INT
,@BDAY AS NVARCHAR(2)
,@BMOUNTH AS NVARCHAR(2)
,@BYEAR AS NVARCHAR (4)
,@BCITY AS NVARCHAR (50)
,@FANAME AS NVARCHAR (50)
,@PHONE AS NVARCHAR(11)
,@MOBILE AS NVARCHAR (11)
,@RESHTE AS NVARCHAR (50)
,@MAGHTA AS NVARCHAR (50)
AS
BEGIN
INSERT INTO [STUDENT]
([NAME],[FAMILY],[SHSH],[SODUR],[MCODE],[BDAY] ,[BYEAR] ,[BCITY] ,[FANAME] ,[PHONE] ,[MOBILE] ,[RESHTE] ,[MAGHTA],[BMOUNTH] )
VALUES
(@NAME,@FAMILY,@SHSH,@SODUR,@MCODE,@BDAY,@BMOUNTH, @BYEAR,@BCITY,@FANAME,@PHONE,@MOBILE,@RESHTE,@MAGH TA)
END
GO
اما موقعی که اطلاعات رو میریزم و ثبت و میزنم ... خطا میده
http://img4up.com/up2/10881821281730226660.jpg
میشه در رفع اشکالات برنامه ام من رو کمک کنید؟
یه برنامه دارم میخوام اطلاعات دانشجو ها رو ثبت کنم :
این کد رو داخل دکمه ثبت گذاشتم :
private void button1_Click(object sender, EventArgs e)
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.InsertCommand = new SqlCommand();
SqlConnection sc = new SqlConnection(@"Data Source=NEGAR-PC;;Initial Catalog=Uni;Integrated Security=True");
if (sc.State != ConnectionState.Closed) { sc.Close(); }
sc.Open();
sda.InsertCommand.Connection = sc;
sda.InsertCommand.CommandType = CommandType.StoredProcedure;
sda.InsertCommand.CommandText = "SP_INSERT";
sda.InsertCommand.Parameters.AddWithValue("@NAME", txtname.Text);
sda.InsertCommand.Parameters.AddWithValue("@FAMILY", txtfamily.Text);
sda.InsertCommand.Parameters.AddWithValue("@SHSH", txtshsh.Text);
sda.InsertCommand.Parameters.AddWithValue("@SODUR", txtsodur.Text );
sda.InsertCommand.Parameters.AddWithValue("@MCODE", txtmcode.Text);
sda.InsertCommand.Parameters.AddWithValue("@BDAY", txtbday.Text);
sda.InsertCommand.Parameters.AddWithValue("@BMOUNTH", txtbmounth.Text);
sda.InsertCommand.Parameters.AddWithValue("@BYEAR", txtyear.Text );
sda.InsertCommand.Parameters.AddWithValue("@BCITY", txtbcity.Text );
sda.InsertCommand.Parameters.AddWithValue("@FANAME", txtfaname.Text);
sda.InsertCommand.Parameters.AddWithValue("@PHONE", txtphone.Text);
sda.InsertCommand.Parameters.AddWithValue("@MOBILE", txtmobile.Text);
sda.InsertCommand.Parameters.AddWithValue("@RESHTE", txtreshteh.Text);
sda.InsertCommand.Parameters.AddWithValue("@MAGHTA", txtmaghta.Text);
sda.InsertCommand.ExecuteNonQuery();
sda.SelectCommand = new SqlCommand();
sda.SelectCommand.CommandType = CommandType.Text;
sda.SelectCommand.CommandText = "SELECT * FROM [STUDENT]";
sda.SelectCommand.Connection = sc;
DataSet DS = new DataSet();
sda.Fill(DS);
GRID.DataSource = DS.Tables[0];
DataTableReader DR = new DataTableReader(DS.Tables[0]);
while (DR.Read())
{
//treeView1.Nodes.Add(DR["NAME"].ToString());
//comboBox1.Items.Add(DR["ID"].ToString());
}
sc.Close();
}
و داخل sql این کد رو گذاشتم »
USE [Uni]
GO
CREATE PROCEDURE SP_INSERT
@NAME AS NVARCHAR(50)
,@FAMILY AS NVARCHAR(80)
,@SHSH AS INT
,@SODUR AS NVARCHAR(50)
,@MCODE AS INT
,@BDAY AS NVARCHAR(2)
,@BMOUNTH AS NVARCHAR(2)
,@BYEAR AS NVARCHAR (4)
,@BCITY AS NVARCHAR (50)
,@FANAME AS NVARCHAR (50)
,@PHONE AS NVARCHAR(11)
,@MOBILE AS NVARCHAR (11)
,@RESHTE AS NVARCHAR (50)
,@MAGHTA AS NVARCHAR (50)
AS
BEGIN
INSERT INTO [STUDENT]
([NAME],[FAMILY],[SHSH],[SODUR],[MCODE],[BDAY] ,[BYEAR] ,[BCITY] ,[FANAME] ,[PHONE] ,[MOBILE] ,[RESHTE] ,[MAGHTA],[BMOUNTH] )
VALUES
(@NAME,@FAMILY,@SHSH,@SODUR,@MCODE,@BDAY,@BMOUNTH, @BYEAR,@BCITY,@FANAME,@PHONE,@MOBILE,@RESHTE,@MAGH TA)
END
GO
اما موقعی که اطلاعات رو میریزم و ثبت و میزنم ... خطا میده
http://img4up.com/up2/10881821281730226660.jpg