Most Valuable Employee: Developers Blogs

Most Valuable Employee: Developers Blogs: "Hi Friends , This blog will help you to resolve the common problem which u face in developing the ASP.NET First Series of MVP. 1. object r..."

Developers Blogs

Hi Friends ,

This blog will help you to resolve the common problem which u face in developing the ASP.NET

First Series of MVP.
1. object reference not set to an instant of an object.
Usually, This problem occur when object reference naming should be wrong.
For eg. Make Query
String Str="Select * from table1";
Dataset ds=new Dataset();
Sqldataadapter da=new SqlDataAdapter(str, connection.obj);
da.fill(ds1, "TableName");
Now u get the error because the Da filling the wrong dataset.

2. Always use the SP instead of inline query it improve the performance
SP naming convention is important when u implementing the 3 tire architecture
for eg. if u r SP is SP_Test
Then SQL Server 2008 R2 first curb the sys_Sp then the normal naming convection sp like the Test Finally SP_Test it affects the performance time, Hence always named the sp like the normal naming convention eg Test don't use the Prefix SP when creating the Stored Procedure.

3.When Calling the SP normal error occur
Error Converting the Varchar to Numeric
ASP developer first print the sp u then u would get the solutions.