tag:blogger.com,1999:blog-23372196938896077092011-04-21T14:35:25.144-07:00.Net 3.5 for BegginersNidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.comBlogger51100tag:blogger.com,1999:blog-2337219693889607709.post-30437741247486191222008-12-01T15:03:00.000-08:002008-12-01T16:54:09.475-08:00Efficient Paging in GridViewIn this post we will follow simple steps to implement efficient paging in gridview using ObjectDataSource. By default when we use ObjectDataSource with GridView to achieve paging, ObjectDataSource retrieves all the rows from the datasource, only displaying the rows for the current page while discarding all the remaining rows. In this post we will see how we can improve the process of paging by Nidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.com0tag:blogger.com,1999:blog-2337219693889607709.post-43826839648457256452008-11-19T13:48:00.000-08:002008-11-23T00:56:24.569-08:00MARS ( Multiple Active Result Sets)ADO.NET 3.5 supports Multiple Active Result Sets meaning that we can execute multiple batches on a single connection.Before that If we wanted to execute two command objects against a database using a single connection object, we would open the connection object, execute first command object against it and then close the connection object. Then we would open the connection object again to execute Nidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.com0tag:blogger.com,1999:blog-2337219693889607709.post-40011570472976046092008-11-17T16:13:00.000-08:002008-11-19T16:37:45.446-08:00Walkthrough for creating, managing and using connection string in ADO.NETIn my previous two posts i discuss about best practices for managing connection string to connect to SQL Server in ADO.NET and different authentication modes used for connecting to SQL Server.In this post i will simply summarize the discussion from previous posts and follow the simple steps for creating and using connection string to connect to SQL Server in ADO.NET 3.5Walk through for creating Nidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.com0tag:blogger.com,1999:blog-2337219693889607709.post-615754444618815912008-11-17T13:04:00.000-08:002008-11-23T01:52:03.536-08:00Connect to SQL Server using Windows Authentication or SQL Server AuthenticationWe can either use Windows authentication or SQL Server authentication for connecting to SQL Server using ADO.NET. In this post we will discuss Windows authentication and SQL Server authentication in detail.We will see how these two modes of authentication works and what is the benefit of each authentication mode over the other?Windows AuthenticationWhen you use windows authentication to connect Nidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.com0tag:blogger.com,1999:blog-2337219693889607709.post-12916786214316545792008-11-16T12:43:00.000-08:002008-11-17T16:09:56.497-08:00Best Practices For Managing Connection String In ADO.NETIn this post we will examine step by step how to create simple connection string for connecting with SQL Server and what are the best practices to create and manage connection string for connecting with SQL Server in ADO.Net.Syntax of connection stringConnection string consists of key\value pairs where each key\value pair is separated by other key\value pair through semicolon. Each key\value pairNidahttp://www.blogger.com/profile/11249958515332631414noreply@blogger.com0