Monday, April 26, 2010

Insert data using sqlcommand

Insert data using sqlcommand,usingsimple,datasqlclassusing,sqlcommand,simpledatausing,datasqlcommand,usingsqlcommand,sqlcommandsqlclass,simplesqlclasssimple,sqlcommandusing,datasqlcommandsimple,sqlclassdata,simplesqlclasssqlcommand,simplesqlcommand,datasimple,sqlcommanddatasimple,usingdatasqlcommand,simplesqlclassusing,sqlcommanddatausing,usingsqlcommandsqlclass,

It is step3 procedure

Insert data using sqlcommand

Save button event
protected void btninsert_Click(object sender, EventArgs e)
first f = new first(); = Convert.ToInt32(TextBox1.Text); = TextBox2.Text;
f.course = TextBox3.Text;
f.fee = Convert.ToInt32(TextBox4.Text);

datac c=new datac();
Label1.Text = "record inserted";

It is step4 procedure

Variable class

public class first
public int id{get;set;}

public string name { get; set; }
public string course { get; set; }
public int fee { get; set; }

It is step5 procedure

Data class

Public void insertmain(first f)
string s= "insert into student values(" + + ",'" + + "','" + f.course + "'," + f.fee + ")";

string constring = "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True ";

SqlConnection cn = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand(cmd, cn);


Ahmad Elayyan said...

thank you shayma, but a little bit, try to use stored procedure instead of ad-hoc statement to generate a sql statement.

like the following :

Create Procedure dbo.StudentInsert
@id int,
@name nvarchar(30),
@course nvarchar(30), -- change it to decimal
@fee varchar(8000)-- change it into decimal.
Begin Try
insert into student (id, name, course, fee)
values(@id , @name, @course, @fee)

End Try
Begin Catch

ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage;

End Catch

shyam parmar said...

I will upload data for stored procedure and linq also

due to lake of time i cant do that

keep watching i will upload soon....

Shyam Parmar