User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 456,578 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,617 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C# advertiser: Programming Forums
Views: 694 | Replies: 1
Reply
Join Date: Sep 2006
Posts: 95
Reputation: scorpionz is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster in Training

help in Coding required of ASP.net

  #1  
Nov 4th, 2007
Hi its scorpionz i have some little Problem in Coding i want to
Develop an asp.net application that retrieve records from a table of ms access and display on a page in a grid or html table. Make sure the table has two fields [EmpName, EmpQualification]. The page should provide searching facility of records by EmpName as well as be EmpQualification.
Can please any one help me in how to code this
and also in linking code wih Database of Access
Thanks in Advanced
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Location: Seattle
Posts: 10
Reputation: jquick is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 3
jquick's Avatar
jquick jquick is offline Offline
Newbie Poster

Re: help in Coding required of ASP.net

  #2  
Nov 4th, 2007
Hi,

That is a pretty vauge question. The best way to get started with data access in .net is to use the Microsoft Data Access Application blocks:

http://www.microsoft.com/downloads/d...displaylang=en

Once you download and add these to your app you can perform data access on a access database like this:

  1. public DataSet GetItems(int itemId)
  2. {
  3. return Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(
  4. "MyAccessDatabaseConnectionString", CommandType.CommandText,
  5. "SELECT * FROM THE TABLES",
  6. new SqlParameter("@playlistId", itemId));
  7. }




This function will return a dataset. You can then bind it to a gridview control or datalist.

<asp:datalist id="myDataList" runat="server" />

<%
myDataList.DataSource = GetItems(5);
myDataList.DataBind();
%>

jenni
Last edited by jquick : Nov 4th, 2007 at 1:15 pm.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb C# Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the C# Forum

All times are GMT -4. The time now is 6:21 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC