Answer / ruchi

A view is a virtual table that consists of columns from one
or more tables. Though it is similar to a table, it is
stored in the database. It is a query stored as an object.
Hence, a view is an object that derives its data from one or
more tables. These tables are referred to as base or
underlying tables.

Once you have defined a view, you can reference it like any
other table in a database.
CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]
Where:


A stored procedure is nothing more than prepared SQL code
that you save so you can reuse the code over and over again.
So if you think about a query that you write over and over
again, instead of having to write that query each time you
would save it as a stored procedure and then just call the
stored procedure to execute the SQL code that you saved as
part of the stored procedure.

Answer / asif aslam

In views we can access data with a page,not like session b/w
the pages.
Stored Procedure use for Database communication...
For Example: add,remove,update etc any record from database.

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

How do you filter the data in datagrid?

2 Answers   Apps Lab, Choice Solutions,

---

What is data view and variable view?

0 Answers  

---

can u tell me the how to get the print for the form

2 Answers   Crea,

---

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

0 Answers  

---

How do you update a dataset in ado.net?

0 Answers  

---

How to retrieve the user id which is provided while windows authentication?

0 Answers   Cap Gemini,

---

Define ado.net?

0 Answers  

---

What are the 4 types of classes in ADO.NET?

5 Answers  

---

What are all the commands used with Data Adapter?

0 Answers  

---

What is row state?

0 Answers  

---

What is ado full form?

0 Answers  

---