-
Data Table in ADO.NET
What is Data table in .net and how it is different from table in database (sqlserver)
nikhiljain27
- Jul 13th, 2013
Datatable is one table collection of Rows and columns in ADO.Net. It is a member of the System.Data namespace in the .NET Framework. DataSet is also a combination of multiple DataTable. It works in Disconnected environment. You can Add/ update/ delete records in the Datatable at runtime.
Trapti
- Sep 14th, 2011
The DataTable class is a member of the System.Data namespace within the .NET Framework class library. You can create and use a DataTable independently or as a member of a DataSet, and DataTable object...
-
How to find the given query is optimised one or not?
Read Best Answer
Editorial / Best Answer
Answered by: Vishal
- Apr 5th, 2006
You can use Execution Plan in SQL server to see the cost of your querry.By this you can optimised your query.
Pendurti
- Sep 11th, 2008
There is something called Query analyzer that u can make use of to find out whether the given query is optimized or not.
sahu
- Mar 29th, 2007
Hi, First Excute Sql Quries in Query Analzer,see How much time 2 take Excute , if Less then the ur desired Time, then it will Optimize query
-
-
How can we retrieve the value which was selected from a combo box in a datagrid view.
The grid view consists of 3 columns which are combo Boxes. I want the string in the 1st column.
Read Best Answer
Editorial / Best Answer
veluworld- Member Since Jul-2007 | Aug 28th, 2008
((DropDownList)GV_chart.Rows[e.RowIndex].FindControl("Dcity1"));
Here GV_Chart is the id of Grid View And DCity is the Name of the dropdown listveluworld
- Aug 28th, 2008
((DropDownList)GV_chart.Rows[e.RowIndex].FindControl("Dcity1"));Here GV_Chart is the id of Grid View And DCity is the Name of the dropdown list
amitrms
- Jul 14th, 2008
Use this for fetching the values from combo boxfor (int i = 0; i < dataGridView1.Rows.Count; i++) &nbs...
-
How to update a column in DataGrid using C#
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];...
ponss
- Jun 1st, 2009
int varid = (int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm = (TextBox)e.Item.Cells[2].Controls[0]; st...
sureshnaspuri
- Jul 10th, 2008
After seeing ur code i understood that u haven't call the bind method.gridview1.EditItemIndex = -1;after this u call the bind method .gridview1.databind();//in this place u call the grid bind method n try it once.
-
Where query string is stored
jnaneswarisd
- Jun 9th, 2009
A query string is the part of a Uniform Resource Locator (URL) that contains data to be passed to web applications.
-
Does SQLClient and OLEdb class share the same functionality
Varung5
- Jun 15th, 2010
SQLClient: 1. It does not use translation layer. So providing high performance. 2. This is only to connect with SQL server. OleDB: 1. We can connect with any database using OLEDB. 2. There is a transl...
ynvpavan
- Jul 10th, 2008
sqldata provider is a native provider for the sqlserver developed by micrsoft, it contains all native drivers that gets connected to the sqlserver. Where as, oledbprovider is to make access to any dat...
-
Explain the differences between ADO and ADO.NET, ASP and ASP.NET , VB and VB.NET
Read Best Answer
Editorial / Best Answer
ramakrishnag1982- Member Since Nov-2006 | Dec 12th, 2007
Asp:
* ASP is Interpreted language based on scripting languages like Jscript or VBScript.
* ASP has Mixed HTML and coding logic.
* Limited development and debugging tools available.
* Limited OOPS support.
* Limited session and application state management.
* Poor Error handling system.
* No in-built support for XML.
* No fully distributed data source support.
Asp.Net:
* ASP.Net is supported by compiler and has compiled language support.
* Separate code and design logic possible.
* Variety of compilers and tools available including the Visual studio.Net.
* Completely Object Oriented.
* Complete session and application state management.
* ?Full proof error handling possible.
* Full XML Support for easy data exchange.
* Fully distributed data source support.ramakrishnag1982
- Dec 12th, 2007
Asp:* ASP is Interpreted language based on scripting languages like Jscript or VBScript. * ASP has Mixed HTML and coding logic. * Limited development and debugging tools available. * Limited OOPS supp...
Guest
- Jan 4th, 2007
ADO1. This object model could be used even for non RDBMS products. We can read data from xml, excel, csv files also.2. ADO objects are dependent on OLEDB providers and OLEDB provider...
-
What is the difference between server.transfer and response.redirect
priyansh rawal
- Apr 22nd, 2010
Server.transfer: Method ends the current webform and will executes the next webform.Response.redirect: it helps to navigate between the webforms through code and this is equal to clicking a hyperlink..
adib4u2000
- Dec 2nd, 2008
One more thing...Server.Transfer supports only ASPX pages but Response.Redirect applies even HTML pages
-
Transaction Processing Namespace
What is the namespace within the Microsoft .Net framework which provides the functionality to implement transaction processing called as?
neeraj
- Mar 14th, 2015
System.data
AndrewMcAlister
- Aug 8th, 2010
There are at least 4 transaction namespaces.System.Transactions for scope type transactions, and for database specific transactions under System.Data.SqlClient, System.Data.OracleClient and System.Data.ODBCClient
-
Why can't we use Multiple inheritance and garbage collector parallelly in .net
Read Best Answer
Editorial / Best Answer
Pendurti- Member Since Sep-2008 | Sep 11th, 2008
Well C# doesn't support multiple inheritance through classes.
If you want to have multiple inheritance in your program, you need to make use of interfaces. A class cannot inherit from more than one class but a class can inherit from more than one interfaces. So C# supports multiple inheritance through interfaces.And multiple inheritance and garbage collection can work independent of each other because, in .NET framework, garbage collection is taken care of by CLR. We can also manually invoke garbage collector using gc.collect().Pendurti
- Sep 11th, 2008
Well C# doesn't support multiple inheritance through classes.If you want to have multiple inheritance in your program, you need to make use of interfaces. A class cannot inherit from mor...
Mob: +91 9849255958
- Jan 4th, 2007
Actually, GC is a low-level thread. When it gets activated, all other threads in the applications are put on hold.
-
What is the difference between .Net framework and .Net Compact Framework?
Read Best Answer
Editorial / Best Answer
bb.geetha- Member Since May-2008 | Jun 12th, 2008
The .NET Compact Framework is a subset of the .NET Framework designed for small-footprint devices. It includes most, but not all of the base class library available in the full framework.
samina naaz
- Jun 30th, 2010
The .NET Compact Framework is a subset of the .NET Framework designed for small-footprint devices.
ptharak
- Oct 20th, 2008
DataREader is ued for readonly and forward .Dataset is used to either read and WriteWhenever sequential is read needed then you can go for DtaREader , it gives better performance than DataSEt.Using DataSEt you can get entire relationship of the tables and schema.
-
What is the difference between data reader & data set
Pendurti
- Sep 15th, 2008
Data ReaderThis is Connection oriented and can read only one record at a time. It has got no capability of reading multiple tables at a time. This needs a live connection all the time. Data SetTh...
sureshnaspuri
- Jul 10th, 2008
data reader:1.It uses the connected architecture.2.It can be used as Read n forward only3.Updations are not possible4.It fectches only one record at a time.5.It is faster compare to data set.Data Set:...
-
What is the basic difference between Dataset and Typed Dataset ?
When would you use Typed dataset?
albu77
- Jun 1st, 2009
With normal dataset you have to always have in mind the schema of your source of data.Typed dataset are a generated class derived from the dataset and in which every thing from the schema is included ...
syed1ahmad
- Jul 12th, 2008
Typed dataset is design time concept and it is type safe mechanish.typed dataset field can be accessed as properties programatically.Typed Dataset is more faster as compated to the normal dataset 'coz of the type casting is not required.
-
What is difference in an Abstract Class and an Interface.
Abstract class can contain method definations also.Interfaces are essentially having all method prototypes no definitionIn short Interface is a abstract class having all methods abstract
ajayms2000
- Mar 2nd, 2009
Besides the rules difference between of interfaces and abstract class, keep this also in mind.Abstract classes promotes high cohesion, while interfaces provides loose coupling. High cohesion and loose coupling are considered as the best design strategy for complex software designs.
Priestly George Varghese
- Oct 9th, 2007
Interface All methods are abstract and there is no implementation. No access modifiers are allowed. Interfaces are essentially having all method prototypes no definition We can achieve multipl...
-
How do you connect to SQL Server Database without using sqlclient
Read Best Answer
Editorial / Best Answer
knreddy221- Nov 11th, 2006
Using System.Oledb;OledbConnection con= new OledbConnection ("Provider=SQLOLEDB.1;User Id=sa;Database=Northwind");OledbCommand cmd= new OledbCommand ("select * from table1",con);oledbdatareader dr= new oledbdatareader ();dr= cmd.ExecuteReader();datagrid1.datasource=dr;datagrid1.databind();
lata negi
- Nov 4th, 2011
We have 4 Data Providers to connect to our database: SqlClient = Used only for Sql Server database. OracleClient = Used only for Oracle database. Oledb = Used for any kind of databases either new or o...
Kamal Kant Verma
- Dec 18th, 2006
You can connect sql using oledbname space .
-
How we can show image from database to our web form
parshu_mail
- Jun 18th, 2010
All the answers are refering to storing the file in a physical file system. but, we do have the Blog and CBlog datatypes to store the binary informaiton into the DB and retrieve the same and use them.
-
How do you bind columns manually in datagrid ?
lata negi
- Nov 4th, 2011
Code- asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
- runat="server">
- <Columns>
- <asp:BoundField HeaderText="ID" DataField="au_id" ReadOnly="true"/>
- <asp:BoundField HeaderText="Last Name" DataField="au_lname"/>
- <asp:BoundField HeaderText="First Name" DataField="au_fname"/>
- <asp:BoundField HeaderText="Phone" DataField="phone"/>
- <asp:BoundField HeaderText="Address" DataField="address"/>
- </Columns>
- </asp:GridView>
-
How can we add a check box or a dropdown list to a column in a datagrid?
Post your answer
ali1dc
- Dec 17th, 2008
you can use the same thing for different control:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"> <Columns> &l...
lohanigeit
- Oct 3rd, 2007
Add the checkbox or drop down in ur itemtemplate column & access it through it's ID.
-
How many records can take clustured index in sql server
Read Best Answer
Editorial / Best Answer
vvijaychandra- Jun 22nd, 2006
a clustered index is a special type of index that reorders the way the records in the table are physically stored . therefore the table can have only one clustered index.
Pendurti
- Sep 15th, 2008
FYI..Clustered index is something that deals with the columns but not the records.These define the physical sorting of the rows in the database in the storage media.A database table can have utmost on...
ushalakshmi
- Apr 17th, 2008
A clustered index is a special type of index that reorders the way records in the table are physically stored. Clustered index is created by default when we create a primary key on a column.Everyone k...
ADO.NET Interview Questions
Read Best Answer
Ans