How to get the count of items in a dataReader
VB.NET Dim mycn As New SqlConnection(‘server=localhost;uid=sa;password=;database=northwind;’) Dim mycmd As New SqlCommand(‘Select * from Products’, mycn) mycn.Open() Dim dr As SqlDataReader = mycmd.ExecuteReader Dim i As Integer While dr.Read i += 1 End While Response.Write(‘Count of Records : ‘ & i) C# SqlConnection mycn =new SqlConnection(‘server=localhost;uid=sa;password=;database=northwind;’); SqlCommand mycmd = new SqlCommand (‘Select * from Products’, mycn); mycn.Open(); SqlDataReader dr = mycmd.ExecuteReader(); int i=0; while(dr.Read()) { i+=1; } Response.Write(‘Count of Records : ‘ + i.ToString());
How to display multiple records using DataTable.Select
Use namespace System.Data.OleDb VB.NET Dim myConnection As New OleDbConnection(‘Provider=SQLOLEDB.1;Data Source=localhost;database=northwind;User Id=sa;Password=;’) Dim myda As New OleDbDataAdapter(‘Select * from Orders’, myConnection) Dim ds = New DataSet myda.Fill(ds, ‘table’) Dim dr() As DataRow Dim id As String = ‘ROMEY’ ’ ‘Field with id ROMEY has more than one records found Dim sel As String = ‘customerid=’’ + id + ‘’’ dr = ds.Tables(0).Select(sel) Dim i As Integer For i = 0 To (dr.GetUpperBound(0)) – 1 Response.Write((dr(i)(‘Orderid’).ToString() + ControlChars.Tab + dr(i)(‘Customerid’).ToString() + ControlChars.Tab + dr(i)(‘Freight’).ToString() + ‘ ‘)) Next C# OleDbConnection myConnection = new OleDbConnection(‘Provider=SQLOLEDB.1;Data Source=localhost;database=northwind;User Id=sa;Password=;’); OleDbDataAdapter myda= new OleDbDataAdapter (‘Select * from Orders’, myConnection); System.Data.DataSet ds= new DataSet (); myda.Fill (ds,’table’); DataRow[] dr ; string id =’ROMEY’;// ‘Field with id ROMEY has more than one records found string sel =’customerid=’’+ id + ‘’’; dr = ds.Tables [0].Select (sel); int i; for(i=0;i<dr.getupperbound(0);i++) {=”” response.write=”” (dr[i][‘orderid’].tostring()=”” +=”” ‘\t’=”” dr[i][‘customerid’].tostring()=”” dr[i][‘freight’].tostring=”” ()=”” ‘<br=””>’); } </dr.getupperbound(0);i++)>
I installed Windows 2003 Standard Edition, then VS.NET and SQL Server 2K with SP3. When I build web project connecting to the database in VS.NET, the compiler gives me the following error:Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’,why?
Add NT AUTHORITY\NETWORK SERVICE account to SQL Server , which will be in the local group. Make sure to give it the required database access and permissions
I get error message at runtime ‘Value null was found where an instance of an object was required’ when using Application state variables. why?
Application State variables must be initialized in C# before any operation is performed on them. For example.: You need to assign value to Counter state variable before performing the case (int)Session[‘Counter’].
Why do I get error message ‘System.Threading.ThreadAbortException: Thread was being aborted’ while using Response.Redirect
Response.Redirect will cause a ThreadAbort exception. To resolve this use VB.NET Response.Redirect(url,false) C# Response.Redirect(url,false) ;