-
Retrieve two tables of data at a time by using data reader
One interview I faced a Q: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 timepeeyush Mishra
- Dec 20th, 2009
SqlCommand myCmd=new SqlCommand("Select Column1,Column2 From Table1;" + ...
vksingh24
- Nov 16th, 2009
This is possible to retrieve data from two tables using datareader.SqlDataReader rd=Command.ExecuteReader("SELECT * FROM Employee | Select * From Order");This will fetch the record from two tables Employee and Order
-
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.
-
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.
-
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 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.
-
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 difference in Record set and Dataset
Recordset provides data one row at a time.Dataset is a data structure which represents the complete table data at same time.Recordset has the logic to update and manipulate dataDataset is just a data store and manipulation is done through DataAdapters in .NET.
veluworld
- Aug 28th, 2008
Recordset is the Read only & forward only mechanism. But Dataset is the Editable. Recordset is connection oriented and Dataset need connection once to dump the data from the data base. Dataset holds more than one table at a time?but recordset holds only one.
ramakrishnag1982
- Aug 12th, 2007
1) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.2) A DataSet is designed to work without any continuing connection t...
-
What is Pull Model and Push Model in ADO.Net? What are the situations when we use one over the other?
sudheer27in
- Jun 6th, 2008
Pull Method: when we directely interact with the data through data drivers this method is used. ADO COMPONENT <--------> DATABASEPush Method...
bornToLose
- Sep 22nd, 2007
Pull model is used to take out the element/object from Database.Push model is used to insert the element at top position in table to database through object.If we want to delete the top most record pull method is used over push. Similar to stack operation
-
Differences between OLEDB SQL SERVER , OLEDBDOTNET PROVIDER ?
ynvpavan
- Apr 18th, 2008
u just have a look over the fig 2 in this link and u can get somne info, i think...http://msdn2.microsoft.com/en-us/magazine/cc163933.aspxAnd also, the OLEDBSQL Provider posses native drivers to inter...
Ashish Misra
- Apr 15th, 2006
OleDBDotNet Provider can be used to connect to any DataSource but OleDb SQL SERVER can be used to connect only to a SQL Server DataSource.
-
Add a field at run time to a table in ado.net
Imports System.Data.SqlClientPublic Class Form1Dim cn As New SqlConnection("server=.;database=atten;uid=sa;pwd=sa;")Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click'savecn.Open()Dim query, query1, query2 As StringDim regnum As Integerquery1 = "select max(reg) from sdetail"Dim cmd1 As New SqlCommand(query1, cn)regnum = cmd1.ExecuteScalarTextBox1.Text...
-
Explain about rowstate in a dataset table?
Lavanyaaru
- Jan 30th, 2008
contd...A newly created DataRow has its RowState set to Detached until it is added to the DataRowCollection via the DataRowcollection::Add method. The RowState is initialized to Added until ...
Lavanyaaru
- Jan 30th, 2008
It is the current state of the row w.r.t. its relationship to the DataRowCollection.THe value of Rowstate is dependent on the method DataRow.AcceptChanges
-
-
-
-
-
What is the Best Practice for binding Controls [Data in the data grid is to be binded with the controls of some form ] ?
rashid
- Mar 27th, 2006
Some user controls are entirely self contained, for example, a user control displaying current stock quotes does not need to interact with any other content on the page. Other user controls will...
rashid
- Mar 27th, 2006
public partial class UseDataList : System.Web.UI.Page{ protected DataTable GetInventory() { String strConnection = &nb...
-
What are the Advantages of ADO.Net?
ADO.NET Does Not Depend On Continuously Live ConnectionsDatabase Interactions Are Performed Using Data CommandsData Can Be Cached in DatasetsDatasets Are Independent of Data SourcesData Is Persisted as XMLSchemas Define Data Structures
ADO.NET Interview Questions
Ans