Syntax:
INSERT INTO table name(column name,column name,column
name)values(values,values,values);
Example:
INSERT INTO
employee(Name,emp_id,designation)values('"+textbox1.text+"',"+textbox2.text+",'"+textbox3.text+"');
..................if u use Html control we must use
textbox1.value ..if u use asp.net controls we have to use
textbox1.text........
in asp.net webform,
first assign namespace like using system.data.sqlclient;
insert coding
sqlcommand cmd = new sqlcommand("insert into address values
('"+ textbox1.text +"', "+ textbox2.text +")",
connectionstring);
note:
I have a datagrid of 10 rows and I am updating the fifth
row using template column edit. How wil u know that the row
is updated, so that it can be send to database for updating
the respective table?
What definition correctly defines a label server control
with the name set to lblHoop?
a) <asp:Label name=?lblHoop? runat=?server? />
b) <Label id=?lblHoop? runat=?server? />
c) <asp:Label id=?lblHoop? runat=?server? />
d) <server label name=?lblHoop? runat=?asp? />