INTERVIEW QUESTIONS MICROSOFT DATAGRID DETAILS

Question: How to insert value in the combo box cell of dataGridView using insert query in C#?How to handle the data error event?

Answer: we can insert details by two types
1.commandtype=command.Text
2.commandType=Command.Storedprocedure

mostly we use stored procedure.
so we have to create insert query in database.

create database emp
create table empdetails
(
empid int,
name varchar(20),
salary money
)

create proc insertdata
(@empid int,@name varchar (20),@salary money)
AS
insert into empdetails
values empid=@empid,name=@name,salary=@salary
exec insertdata



protected void button_clik event.....
{
sqlconnection con=new sqlconnection("database=emp";server=.;integrated security="true");

sqlcommand cmd= new sqlcommand();
cmd.commandtext="insertdata";
cmd.commandtype=commandtype.storedprocedure;
cmd.connection=con;

con.open();
cmd.parameters.add("@empid",sqlDbtype.int).value=txtempid.text;

cmd.parameters.add("@name",sqlDbtype.varchar).value=txtname.text;

cmd.parameters.add("@salary",sqlDbtype.money).value=txtsalary.text;
cmd.executenonquery();
con.close();
}
}

we can insert details by two types
1.commandtype=command.Text
2.commandType=Command.Storedprocedure

mostly we use stored procedure.
so we have to create insert query in database.

create database emp
create table empdetails
(
empid int,
name varchar(20),
salary money
)

create proc insertdata
(@empid int,@name varchar (20),@salary money)
AS
insert into empdetails
values empid=@empid,name=@name,salary=@salary
exec insertdata



protected void button_clik event.....
{
sqlconnection con=new sqlconnection("database=emp";server=.;integrated security="true");

sqlcommand cmd= new sqlcommand();
cmd.commandtext="insertdata";
cmd.commandtype=commandtype.storedprocedure;
cmd.connection=con;

con.open();
cmd.parameters.add("@empid",sqlDbtype.int).value=txtempid.text;

cmd.parameters.add("@name",sqlDbtype.varchar).value=txtname.text;

cmd.parameters.add("@salary",sqlDbtype.money).value=txtsalary.text;
cmd.executenonquery();
con.close();
}
} Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question