•
•
•
•
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
![]() |
•
•
Join Date: Sep 2006
Posts: 95
Reputation:
Rep Power: 3
Solved Threads: 0
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
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
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:
This function will return a dataset. You can then bind it to a gridview control or datalist.
jenni
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:
C# Syntax (Toggle Plain Text)
public DataSet GetItems(int itemId) { return Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset( "MyAccessDatabaseConnectionString", CommandType.CommandText, "SELECT * FROM THE TABLES", new SqlParameter("@playlistId", itemId)); }
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.
![]() |
•
•
•
•
•
•
•
•
DaniWeb C# Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
.net .net framework 3.0 access ajax asp code coding combo competition compilers computer custom data developer developers development dom dropdownlist errors feed google languages microsoft module msdn net office programming reader reuse sans search security skin software sql theme vista weather web windows workflow xml xoap
- Simple ASP.Net Login Page using C# (C#)
- Updated : Simple ASP.Net Login Page (ASP.NET)
- I Need Sample ASP.NET Code (ASP.NET)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- ASP.NET / C# Dynamic Control (ASP.NET)
- Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) (ASP.NET)
Other Threads in the C# Forum
- Previous Thread: simple 'if statement' issue
- Next Thread: Changing a datagridview's combobox items based on another combobox


Linear Mode