C# Source Code Viewer

C# Source Code Viewer

View C# Source Code

Article Categories:
.Net Framework .Net Framework 1.1 ADO.NET ASP.NET Assemblies Asynchronous Methods C# Collections Delegates Events Pocket PC Regular Expressions Smart Devices SQL Server Visual C# Visual Studio .NET Visual Studio .NET 2003 Windows Forms XML

C# .Net Fun Menu
View Current Page's ASP.NET Source Code C# Reference C# Study Flash Cards Valuable Links Contact Us Site Map Mike's Portfolio

C# Reference Search:

Full Text Search:

Articles by Author:

Code Examples (zipped):

C# .Net Source Code for /Articles/WindowsForms/MSDEWinFormApplication.aspx

This ASP.NET page was written by Mike Gonzalez.
<% @ Page Language="C#" Debug="True" %>
<% @ Register TagPrefix="DotNetFun" TagName="Header" Src="/Header.ascx" %>
<% @ Register TagPrefix="DotNetFun" TagName="Footer" Src="/Footer.ascx" %>
<script language="C#" runat="Server">
	private void Page_Load() {
		ltrCategories.Text = CtrlHeader.ArticleCategory1 + "|" + CtrlHeader.ArticleCategory2 + "|" + 
			CtrlHeader.ArticleCategory3 + "|" + CtrlHeader.ArticleCategory4;
		ltrCategories.Text = DotNetFun.Common.AddCommas(ltrCategories.Text, '|');
	}
</script>
<dotnetfun:header id="CtrlHeader" runat="Server" enableviewstate="False" allowrobotindex="true" pagetitle="Build Data-centric Windows Forms Apps. without MS SQL Server or MS Access Databases" pagedescription="Learn how to build Windows Forms Apps. with a MSDE Data Tier and Visual Studio .NET." pagekeywords="learn, build, windows forms, msde, data tier, vs.net, visual studio .net" authorname="Mike Gonzalez" authordate="5-30-2003" articlecategory1="Windows Forms" articlecategory2="Visual Studio .NET" articlecategory3="" articlecategory4="" articletitle="Build Data-centric Windows Forms Apps. without MS SQL Server or MS Access Databases" articledescription="Learn how to build Windows Forms Apps. with a MSDE Data Tier and Visual Studio .NET." allowviewsource="true"/>
<h2>
	<%# CtrlHeader.ArticleTitle %>
</h2>

	<%# CtrlHeader.ArticleDescription %> 
	Category: <asp:literal id="ltrCategories" runat="Server" enableviewstate="False"/> 
	Posted <%# CtrlHeader.AuthorDate.ToShortDateString() %>, 
	By <%# CtrlHeader.AuthorName %> 

<hr noshade="true" size="5" color="<%# CtrlHeader.SiteDataSet.Tables[0].Rows[0][" navbackgroundcolor"] %>" />

If you need to build data-centric, transaction-based Windows Forms applications 
where a significant amount of data is to be manipulated then this is the tutorial 
for you. 
In this tutorial you will learn how to use VS.NET and MSDE 2000 for VS.NET Developers 
to build a simple Windows Form that consumes data from tables stored in the MSDE 2000 
engine without the use of the Microsoft SQL Server or Microsoft Access products.
<ul>Prerequisites:
	<li><a href="/">
		MSDE 2000 for Developers using Visual Studio .NET.</a> Click 
		<a href="http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp">
		here</a> for more information regarding MSDE 2000.</li>
	<li>Visual Studio .NET 2003 (you can use 2002 but this tutorial uses 2003).</li>
</ul>
<ol>Tutorial Steps:
	<ol>
	Setup MSDE 2000 for Developers using VS.NET 
	<li>Install MSDE 2002 for VS.NET Developers if it's not already installed.</li>
	<li>The MSDE 2002 for VS.NET Developers installation creates an SQL Server 
		2000 instance service called MSSQL$VSDOTNET where VSDOTNET is 
		the name of the instance.</li>
	<li>Check to make sure the VSDOTNET instance is started by running 
		sqlmangr.exe. If it's not, start it. 
		<img alt="MSDE Win. Form App SQL Service Manager" src="images/MSDEWinFormApp_SQLServiceManager.gif" border="0"/>
	</li>
	 Create MSDE tables and populating them with data
	<li>Open up VS.NET and create a new Windows Application 
		project called MSDEWinFormApp.</li>
	<li>Open up the Server Explorer by going to View menu list.</li>
	 Creating an MSDE 2000 Database 
	<li>Expand the Servers node then expand the name of the computer then 
		expand the SQL Servers node then expand the MSDE-installed instance 
		(in the form computer_name\instance_name). 
		<img alt="MSDE Win. Form App Server Explorer" src="images/MSDEWinFormApp_ServerExplorer.gif" border="0"/>	
	</li>
	<li>Right-click on the VSDOTNET instance and choose New Database.</li>
	<li>Enter MSDEWinFormApp as the database name and choose 
		Windows NT Integrated Security.</li>
	<li>Expand the MSDEWinFormApp database node in the Server Explorer 
		then expand the Tables node.</li>
	<li>Right-click on the Tables node then choose New Table.</li>
	<li>For the first row of the Column Name column enter FirstName and 
		set the Data Type to varchar and the Length to 64.</li>
	<li>Do the same for the second row but call the field LastName. 
		<img alt="MSDE Win. Form App. New Table" src="images/MSDEWinFormApp_NewTable.gif" border="0"/>
	</li>
	<li>Press [Ctrl]+[S] to save the table.</li>
	<li>Enter tblMyNames for the table name then click on OK.</li>
	<li>In the Server Explorer right-click on the tblMyNames table 
		and choose Retrieve Data from Table.</li>
	<li>Start entering random names of people you know or have heard of in the grid 
		(I entered Bill Gates, Steve Ballmer and Coby Briant).</li>
	 Creating a Typed Dataset 
	<li>From the Project menu choose Add New Item then choose Data Set.</li>
	<li>Called the Data Set dsNames.xsd.</li>
	<li>Go the Server Explorer the drag-and-drop the tblMyNames table onto 
		the dsNames.xsd design window. 
		<img alt="MSDE Win. Form App. DataSet" src="images/MSDEWinFormApp_DataSet.gif" border="0"/>	
	</li>
	<li>Press [Ctrl]+[Shift]+[S] to save all of the project files.</li>
	 Adding controls to the Windows Form 
	<li>Open up Form1.cs from the Solution Explorer window.</li>
	<li>Drag-and-drop a DataGrid and Button control from the 
		Toolbox window to Form1.cs. 
		<img alt="MSDE Win. Form App. Form1" src="images/MSDEWinFormApp_Form1.gif" border="0"/>	
	</li>
	<li>Set the button's (Button1) Text property to Fill DataGrid with Names.</li>
	<li>Right-click on Form1.cs in the Solution Explorer window and choose 
		View Code.</li>
	<li>Go to the very top of the code window and enter the following:
		<xmp style="background-color:#FFFFDD; font-size:10pt">
using System.Data;
using System.Data.SqlClient;
		</xmp>
	</li>
	<li>Open up the Form1.cs form again from the Solution Explorer window.</li>
	<li>Double-click on the button (Button1) to create a Click event handler.</li>
	<li>In the code window type in the following code:
		<xmp style="background-color:#FFFFDD; font-size:10pt">
// replace the underline below with the name f your computer:
SqlConnection sqlConn = new SqlConnection("Data Source=____\\VSDOTNET; " + 
	"Integrated Security=SSPI; Initial Catalog=MSDEWinFormApp");
try 
{
	SqlDataAdapter sqlAdp = new SqlDataAdapter("SELECT * FROM tblMyNames", 
		sqlConn);
	dsNames ds = new dsNames();
	sqlAdp.Fill(ds, "tblMyNames");
	sqlAdp.Dispose();
	dataGrid1.DataSource = ds.tblMyNames;
}
catch (Exception err) 
{
	MessageBox.Show(err.Message + "\r\n" + err.StackTrace);
}
finally 
{
	sqlConn.Close();
	sqlConn.Dispose();
}
		</xmp>
	</li>
	 That's it - now its time to test the application: 
	<li>Press the [F5] key to debug your application.</li>
	<li>Click on the button on the form to fill the DataGrid with the data of names. 
		<img alt="MSDE Win. Form App. Start" src="images/MSDEWinFormApp_Start.gif" border="0"/>
	</li>
</ol>

<dotnetfun:footer id="CtrlFooter" runat="Server" enableviewstate="False"/>