How to check if a datareader is closed or opened ?
IsClosed() Read more »
‘ASP.Net Interview Questions’ - KyaPoocha.com
In how many ways we can retrieve table records count? How to find the count of records in a dataset ?
foreach(DataTable thisTable in myDataSet.Tables){ // For each row, print the values of each column. foreach(DataRow myRow in thisTable.Rows){ Read more »
What happens when we issue Dataset.ReadXml command ?
Reads XML schema and data into the DataSet. Read more »
Explain different methods and Properties of DataReader which you have used in your project ?
Read GetString GetInt32 while (myReader.Read()) Console.WriteLine(”\t{0}\t{1}”, myReader.GetInt32(0), myReader.GetString(1)); myReader.Close(); Read more »
Difference between DataReader and DataAdapter / DataSet and DataAdapter?
You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application performance... Read more »
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database ?
• System.Data.OleDb – classes that make up the .NET Framework Data Provider for OLE DB-compatible data sources. These classes allow you to connect to an... Read more »
Difference between OLEDB Provider and SqlClient ?
SQLClient .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is fast. It’s faster... Read more »
What are relation objects in dataset and how & where to use them ?
In a DataSet that contains multiple DataTable objects, you can use DataRelation objects to relate one table to another, to navigate through the tables, and to return... Read more »
How would u connect to database using .NET ?
SqlConnection nwindConn = new SqlConnection(”Data Source=localhost; Integrated Security=SSPI;” + “Initial Catalog=northwind”); nwindConn.Open(); Read more »
Advantage of ADO.Net ?
o ADO.NET Does Not Depend On Continuously Live Connections o Database Interactions Are Performed Using Data Commands o Data Can Be Cached in Datasets o ... Read more »
What is the different between ASP.NET and VB.NET?
ASP.Net is an “environment”, and VB.Net is a programming language. You can write ASP.Net pages (called “Web Forms” by Microsoft) using VB.Net... Read more »
How can we create custom controls in ASP.NET?
Custom Controls can be created in either of the following 3 methods. 1. Creating as a composite control : This method uses and combines the existing controls to... Read more »
How many types of validation controls are provided by ASP.NET ?
RequiredField Validator Control,Range Validator Control, RegularExpression Validator Control,Custom Validator Control and Validation Summary Control are provided... Read more »
Can you explain what is “AutoPostBack” feature in ASP.NET ?
AutoPostBack is built into the form-based server controls, and when enabled, automatically posts the page back to the server whenever the value of the control in... Read more »
How can you enable automatic paging in DataGrid ?
Using the Built-In Paging Controls To use default paging, you set properties to enable paging, set the page size, and specify the style of the paging controls. Paging... Read more »