OK.
I am using Visual Web Developer 2005 Express, I am using VB.NET for the programming language, and Access for the database.

Here is an overview of what I am trying to do :

I have an access database with 13 different columns, the first column has names that identify the other 12 columns and is the primary key.

I have the primary key displayed in a drop down menu.

I want to populate 12 text boxes with the values of the 12 columns in the database, but I want them populated according to what is selected in the drop down menu. Text boxes are necessary because the part of the equation that they control may be different from the values I have stored in the database.

I am an extreme newbie at databases and sql, can anyone help me here?

 Dear friend i have solution but it not possible to put it here as that i have coded the application to fetch the record from databse for selected value which is primary kay.

samir

Still if you want then here is code:
        Dim connectionString As String = "Driver={Microsoft Access Driver (*.mdb)};DBQ=\\Comp215\Database\Attendance.mdb"

 Dim queryString1 As String = "SELECT Status,Work_Hour,Day_Status,Emp_Id,Cur_Date from Emp_Attend where Cur_date BETWEEN " & "#" & Date1 & "# " & "AND " & "#" & Date2 & "#" & " And " & "Emp_Id = " & ID & " ORDER BY Emp_ID, Cur_Date "

        Using connection As New OdbcConnection(connectionString)

            Dim command1 As New OdbcCommand(queryString1, connection)
            connection.Open()
            Dim Emp_Attend As OdbcDataReader = command1.ExecuteReader()
            While Emp_Attend.Read()
                Textbox1.text = Emp_Attend(0)
                Textbox2.text = Emp_Attend(1)
                Textbox3.text = Emp_Attend(2)
                Textbox4.text = Emp_Attend(3)
                  :
                Textbox12.text = Emp_Attend(12)

 End While
            Emp_Attend.Close()
        End Using


================================================== =
Place these line top of code window in general declaration::

Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.Odbc

samir

Thank you, I will be trying this soon :)