what is clustered index?why is it created?
Answers were Sorted based on User's Feedback
clustered index is a type oof index this is a physical
component used to to resorted the data in a table. U can use
only one clustered index for a Table.
| Is This Answer Correct ? | 14 Yes | 2 No |
Clustring is a method for storing the tables in same block
that are related.
Cluster index are used to achive this object.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / kuldeep kumawat
clustered index make physical table of the underline base table like (PhonBook,Discretionary)
and
Non clustered index is a reference table key of base table.
nonclusterd index has reference key to point a main table record
(like our not book we have index at first page and page number )
Example blow here ..
topics page no
class 20
object 30
asp.net 300
practices Example 330
| Is This Answer Correct ? | 0 Yes | 0 No |
What is ado.net tutorial?
What is Pooling? what is data pooling? what is sql pooling?
what is type dataset?
What you mean by filtering of data?
What we do with the object of ado.net dataset after using it?
How do you update a dataset in ado.net?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Which type of database is used while processing dynamic 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();
how to keep track of index in listbox items.
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?
List the 4 common ado.net namespaces?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)