SQLConnection bringing data to TextBox

Question

I know this looks really simple but i've been looking for an answer for hours with no luck.

I want to fill my row values into a bunch of textboxes. How can I specify that [CompanyName] is going to be used by the companyName textbox? Please keep it as simple as possible (beginner level).

string customerUniqueID = "test";

string constr = ConfigurationManager.ConnectionStrings["SQLConnection"].ToString(); // connection string
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand com = new SqlCommand("SELECT * FROM [Customers] WHERE [UniqueID] = @UniqueID", con); // table name 
com.Parameters.Add("@UniqueID", SqlDbType.Int);
com.Parameters["@UniqueID"].Value = customerUniqueID;
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
companyName.Text = ?????????

[CompanyName] is from database ? and can there be multiple rows for WHERE [UniqueID] = @UniqueID ? if so will it be okay to set first row's data into textbox ? — Amit
– Amit, Commented May 29, 2018 at 12:42
@ConstantinosTillits have you successfully query into database ? — Amit
– Amit, Commented May 29, 2018 at 12:45
there are 10 columns in my table and 10 textboxes on my page and i would like to use them all... i was thinking about filling my textboxes one by one repeating the companyName textbox process 10 times — Frosty
– Frosty, Commented May 29, 2018 at 12:47

mbadeveloper · Accepted Answer · 2018-05-29 12:45:07Z

1

string customerUniqueID = "test";

string constr = ConfigurationManager.ConnectionStrings["SQLConnection"].ToString(); // connection string
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand com = new SqlCommand("SELECT * FROM [Customers] WHERE [UniqueID] = @UniqueID", con); // table name 
com.Parameters.Add("@UniqueID", SqlDbType.Int);
com.Parameters["@UniqueID"].Value = customerUniqueID;
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds, "Customers");

companyName.Text = ds.Tables[0].Rows[0]["CompanyName"].ToString();

answered May 29, 2018 at 12:45

mbadeveloper

1,2709 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SᴇM · Accepted Answer · 2018-05-29 13:02:09Z

I will recommend some changes in your code:

Your sql query returning result from one set, so you can use DataTabe instead of DataSet.
To fill results from DB to your DataTable you can use SqlAdapter.Fill() method.
Use Field() generic method (more examples of Field()) to get values from your DataTable.
Use using blocks for disposable objects, or at least make sure you've closed them after.
There is no need of con.Open() to open connection when using Fill() method, because from MSDN:

The Fill method implicitly opens the Connection that the DataAdapter is using if it finds that the connection is not already open. If Fill opened the connection, it will also close the connection when Fill is finished. This can simplify your code when dealing with a single operation such as a Fill or an Update.

string customerUniqueID = "test";
string constr = ConfigurationManager.ConnectionStrings["SQLConnection"].ToString(); // connection string
using(SqlConnection con = new SqlConnection(constr))
{
    SqlCommand com = con.CreateCommand();
    com.CommandText = "SELECT * FROM [Customers] WHERE [UniqueID] = @UniqueID";
    com.Parameters.Add("@UniqueID", SqlDbType.Int);
    com.Parameters["@UniqueID"].Value = customerUniqueID;
    using(SqlDataAdapter da = new SqlDataAdapter(com))
    {
        DataTable dt = new DataTable();
        da.Fill(dt);
        companyName.Text = dt.Rows[0].Field<string>("CompanyName");
    }
}

Please feel free to comment, if I missed something.

Collectives™ on Stack Overflow

SQLConnection bringing data to TextBox

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related