Data Access and ObjectDataSource Control

Re: Fetching Data from existing tables into the textboxes

vinz — Sat, 04 Jul 2009 10:17:59 GMT

Learning++:
Hello vinz

Can you please tell me where to initialise ddldropdownlist1. Is it converting the fields in the column into the dropdown.

Just grab a DropDownList from the Visual Studio toolbox and then put it in the WebForm.. from there you can generate the SelectedIndexChanged event by double clicking on the DropDownList..

Also, I would suggest you to refer to the links that I have provided above and I'm sure you will get some useful information there..

You may check this example below:

Binding DropDownList, ListBox and CheckBoxList Control the ADO.NET way.

Re: Fetching Data from existing tables into the textboxes

mudassarkhan — Fri, 03 Jul 2009 16:03:53 GMT

See if you can get something from here

It has both Dropdown and TextBox

http://www.aspsnippets.com/post/2009/06/07/DataBinding-DropDownList-Label-and-Textbox-Controls-in-ASPNet.aspx

Re: Fetching Data from existing tables into the textboxes

hans_v — Fri, 03 Jul 2009 15:46:08 GMT

You can do this easy with no code at all!!!

Recently, I answered on a similir question with a a complete example:

http://forums.asp.net/t/1441766.aspx#3267613

Re: Fetching Data from existing tables into the textboxes

Learning++ — Fri, 03 Jul 2009 11:34:42 GMT

protected void ddldropdownlist1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GetData(ddldropdownlist1.SelectedItem.Value);
    }

Hello vinz

Can you please tell me where to initialise ddldropdownlist1. Is it converting the fields in the column into the dropdown. If it is so, where to initialise it.

below is my code:

.aspx :

<asp:TextBox ID="txtVendorID"  MaxLength="100" runat="server" SkinID="TextBox" ></asp:TextBox>

.cs :

private void GetData(string vendorID)
    {
        DataTable dt = new DataTable();
        using (SqlConnection Connection = new SqlConnection(@"Data Source=.;Initial Catalog=VendorDatabaseAdministration;User Id=ADMIN;pwd=0000"))
        {
            Connection.Open();
            SqlCommand sqlCmd = new SqlCommand("SELECT * FROM VendorGeneralDescription WHERE [Vendor ID]= @VendorID", Connection);
            SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
            sqlCmd.Parameters.AddWithValue("@VendorID", txtVendorID.Text);
            sqlDa.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                txtVendorID.Text = dt.Rows[0]["[Vendor ID]"].ToString(); //Where ColumnName is the Field from the DB that you want to display
            }
            Connection.Close();
        }
    }

    protected void ddldropdownlist1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GetData(ddldropdownlist1.SelectedItem.Value);
    }

Re: Fetching Data from existing tables into the textboxes

vinz — Fri, 03 Jul 2009 11:14:35 GMT

Learning++:
I am using Webforms. How can i apply this in it.

You can put the codes that I have provided above in the Code Behind ASPX.CS or ASPX.VB file of the WebForm (ASPX)...

If you are new to ASP.NET then I would suggest you to start looking at these links below:

Get Started:   http://www.asp.net/get-started/
Learn:            http://www.asp.net/learn/
Videos:          http://www.asp.net/learn/videos/
Data Access: http://www.asp.net/learn/data-access/

Re: Fetching Data from existing tables into the textboxes

Learning++ — Fri, 03 Jul 2009 10:58:23 GMT

Hello Vinz

Thanks for replying !

I am using Webforms. How can i apply this in it.

Re: Fetching Data from existing tables into the textboxes

vinz — Fri, 03 Jul 2009 10:50:13 GMT

Here's an example using the ADO.NET way with DataTable:

C#:

private void GetData(string vendorID)
{
    DataTable dt = new DataTable();
    SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");
    connection.Open();
    SqlCommand sqlCmd = new SqlCommand("SELECT * FROM TABLE1 WHERE VendorID= @VendorID", connection);
    SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
    sqlCmd.Parameters.AddWithValue("@VendorID",vendorID);
    sqlDa.Fill(dt);
    if (dt.Rows.Count > 0)
    {
           TextBox1.Text = dt.Rows[0]["ColumnName1"].ToString(); //Where ColumnName is the Field from the DB that you want to display
    }
        connection.Close();
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
        GetData(DropDownList1.SelectedItem.Value);
}

VB.NET:

Private Sub GetData(ByVal vendorID As String)
    Dim dt As New DataTable()
    Dim connection As New SqlConnection("YOUR CONNECTION STRING HERE")
    connection.Open()
    Dim sqlCmd As New SqlCommand("SELECT * FROM TABLE1 WHERE VendorID= @VendorID", connection)
    Dim sqlDa As New SqlDataAdapter(sqlCmd)
    sqlCmd.Parameters.AddWithValue("@VendorID", vendorID)
    sqlDa.Fill(dt)
    If dt.Rows.Count > 0 Then
            'Where ColumnName is the Field from the DB that you want to display
        TextBox1.Text = dt.Rows(0)("ColumnName1").ToString()
    End If
    connection.Close()
End Sub

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
    GetData(DropDownList1.SelectedItem.Value)
End Sub

Fetching Data from existing tables into the textboxes

Learning++ — Fri, 03 Jul 2009 07:54:28 GMT

Hello Friends

Please help me on this. I need to fetch data into empty text boxes from a database. Lets say, I have a vendor general info. table, where Vendor ID. is the primary key. first i have to choose a Vendor ID( may be dropdown list, which is also coming from database). As soon as i choose a ID, the values in the other user controls(text boxes) on the page, like Vendor First Name, Last Name are updated from the database.

Thanks in Advance !