Populate value in textboxes

[hardik_088]

hi guys,
I have budget table in my sql database and there are some field like budgetYear,Long-term,short-term etc.. and I have textboxes and i want to get value from textbox. so how can i get? can you guys please help me.


Thanks a lot

[Cimperiali]

So you have a sql db and a form and would like to bind some controls to some fields.

Have you at least decided how your software will deal with db?
are you going for Entity Framework?
are you going for Linq to Sql?
are you going for a custom Dal with Objects to map your tables?
are you going for strongly typed DataSet?
are you going for simple DataTables?
?

[foamy]

That was hardly a useful reply, as the OP will obviously not be able to answer those questions.

I would suggest looking at the SqlDataReader class.

This sample should get you started (modified from MSDN)

private static void ReadOrderData(string connectionString)
{
    string queryString = "SELECT whatever FROM some_table";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using SqlCommand command = new SqlCommand(queryString, connection))
        {
            command.Connection.Open();

            using(SqlDataReader reader = command.ExecuteReader())
            {

                // Call Read before accessing data.
                while (reader.Read())
                {
                    textBox1.Text = reader["column_name"].ToString();
                }

            }
        }
    }
}

EDIT: I might have misunderstood, and you want to save the textbox values to your database? If that's the case, let me know and I'll help out as best I can

[hardik_088]

hi guys,
I have textboxes and I want to display a last row from database table.
I also have add button ,it will insert data in databse table.
So when user update table every time I want to display last row only.

what should I do?


Thanks