Filling data from SQL 2005 in ASP.NET

Hot Topic

RenderMode default style different in Express?
Remotely Creating community with READ_CREATE rights and adding an IP in trap destination
How do I display images in my embedded HTML?
Is it possible to embed a command prompt (cmd.exe) as a control on a Windows Form?
ListBox is really slow on adding about 64000 items
SQLExpress can't attach Database using ClickOnce
Design patterns
Assembly.LoadFrom
Updates with clickonce and myapp.exe.config
I need .NET Graphing Component

Windows Forms

Host Controls in Windows Forms DataGridView Cells
Landscape and Paper size in CR Design mode
Form Resize incorrectly
How to retrieve data from a datagrid?
Image is distorted in the picture box
Problem with Windows Forms Inheritance in designer
Background image resources cause VS error
Window / Form refreshing issue
Dual threaded image creation...Reposted to be more readbale??...
ListView column order confusion

Filling data from SQL 2005 in ASP.NET

Hello,

I am working with my first ASP.NET project, and I have a question. I have successfully connected my asp.net project to my SQL2005 DB, and have bound all of the controls to their respective data, but what code do I need to make all of the controls fill with the appropriate data once the record is selected that is the primary key

Thanks!

Answer this question

Filling data from SQL 2005 in ASP.NET

  • Jasonval2005

    assuming you are using a table adapter, you need to fill the table adapter in the page load event with the relevant record (air code):

    string primaryKey = somevalue;

    this.TableAdapter.FillByID(this.DataSet.DataTable, primaryKey.ToString());

    Your table adapter query (named FillByID for this example) should use a parameter like:

    select * from table where primaryKeyID=@primaryKeyID
  • Filling data from SQL 2005 in ASP.NET
Answer this question