<div>
For DB connection, why you are not using web.config to store the connection string.<br />
Please read this article for more information about the web.config<br />
<a href="http://msdn.microsoft.com/en-us/library/ms178411.aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/ms1784<wbr />11.aspx</a> <br />
Let me know if you have any question.<br />
<br />
Thanks<br />
Ganesh<br />

</div>


For DB connection, why you are not using web.config to store the connection string.
Please read this article for more information about the web.config
http://msdn.microsoft.com/en-us/library/ms178411.aspx [http://msdn.microsoft.com/en-us/library/ms178411.aspx]
Let me know if you have any question.

Thanks
Ganesh


<div>
used a copy of Microsoft.ApplicationBlock<wbr />s.Data.dll<wbr /> from a coworker and app works fine. Thank you all....
</div>


used a copy of Microsoft.ApplicationBlocks.Data.dll from a coworker and app works fine. Thank you all....

<div>
<div class="content wysiwyg-content">
Hello Community -- I have a .NET 2003 app that I converted to .NET 2005. I'm receiving an error message &quot;System.NullReferenceExcep<wbr />tion&quot; when I complie. Here's the code -- Thank you in advance.<br />
<br />
private DataTable GetWeekDays(){<br />
&nbsp;string query = &quot;SELECT * from dbo.fnGetWeekDay('&quot; + selection.ToShortDateStrin<wbr />g() + &quot;') order by Seq&quot;;<br />
<br />
DataSet ds = SqlHelper.ExecuteDataset(A<wbr />pplication<wbr />[&quot;DBConn&quot;]<wbr />.ToString(<wbr />), CommandType.Text, query);<br />
return ds.Tables[0];<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}//GetWeekDays() 
</div>
</div>


Hello Community -- I have a .NET 2003 app that I converted to .NET 2005. I'm receiving an error message "System.NullReferenceException" when I complie. Here's the code -- Thank you in advance.

private DataTable GetWeekDays(){
 string query = "SELECT * from dbo.fnGetWeekDay('" + selection.ToShortDateString() + "') order by Seq";

DataSet ds = SqlHelper.ExecuteDataset(Application["DBConn"].ToString(), CommandType.Text, query);
return ds.Tables[0];
		}//GetWeekDays() 

System.NullReferenceException

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.