Binding dataset data to textbox

Question

0.00/5 (No votes)

See more:

can anyone just tell me what is the syntax to bind dataset data to textboxs in c# windows form.

C#

int temp = Form2.variable1;
           string s = System.Configuration.ConfigurationSettings.AppSettings.Get("Conn");
           SqlConnection connection = new SqlConnection(s);
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = connection;
           cmd.CommandType = CommandType.StoredProcedure;
           connection.Open();
           cmd.CommandText = "ssp_AgriShowdata";
           cmd.Parameters.AddWithValue("@temp", temp);
          SqlDataAdapter adapt = new SqlDataAdapter(cmd);

           DataSet ds = new DataSet();
           adapt.Fill(ds);

I am using this syntax to bind dataset value to textbox but it showing some exception.

C#

cFirstName.DataBindings.Add("Text", ds.Tables["Cultivator_tbl"], "c_FirstName");

ERROr:Value cannot be null.
Parameter name: dataSource

Posted 29-Jul-13 22:45pm

Rakhil Naik

Updated 29-Jul-13 22:49pm

Sushil Mate

v2

Add a Solution

6 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jackspero18 · Answer 1 · 2013-07-29T22:48:00

Solution 1

C#

sconn.Open();
               string query = "select * from Student";
               SqlCommand cmd = new SqlCommand(query, sconn);
               SqlDataReader dr = cmd.ExecuteReader();

               DataTable dt = new DataTable();
               dt.Load(dr);
               txtFirstName.Text = dt.Rows[0][2].ToString();
               cmd.ExecuteReader();
               sconn.Close();

Posted 29-Jul-13 22:48pm

jackspero18

Comments

Rakhil Naik 30-Jul-13 4:51am

thanks
I am using this syntax
cFirstName.DataBindings.Add("Text", ds.Tables["Cultivator_tbl"], "c_FirstName");
is there any other syntax?

Winston Madiano · Answer 2 · 2013-07-29T22:49:00

Solution 2

Set the last FormattingEnabled Overload to true

C#

cFirstName.DataBindings.Add("Text", ds.Tables["Cultivator_tbl"], "c_FirstName",True);

Posted 29-Jul-13 22:49pm

Winston Madiano

Updated 29-Jul-13 22:58pm

v4

Comments

Rakhil Naik 30-Jul-13 4:59am

thanks
but still it showing same Exception
ERROr:Value cannot be null.
Parameter name: dataSource

Thanks7872 · Answer 3 · 2013-07-29T22:54:00

It will be easy and better if you modify these lines

C#

SqlDataAdapter adapt = new SqlDataAdapter(cmd);            
DataSet ds = new DataSet();
adapt.Fill(ds);

with this one

C#

SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
    string temp=dr.GetValue(0).ToString();
    dr.Close();
}

Regards..:laugh:

**NAGARAJ N MACHAKNUR** · Answer 4 · 2013-07-30T00:24:00

int temp = Form2.variable1;
string s = System.Configuration.ConfigurationSettings.AppSettings.Get("Conn");
SqlConnection connection = new SqlConnection(s);
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
cmd.CommandText = "ssp_AgriShowdata";
cmd.Parameters.AddWithValue("@temp", temp);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();
adapt.Fill(ds);

//Use this code
if(ds!=null)
{
if(ds.Tables.Count>0)
{
if(ds.Tables["TableName"]!=null AND ds.Tables["TableName"].Rows.COunt>0)
{
TextBoxID=ds.Tables["TableName"].Rows[0]["ColumnName"].ToString();
}
}
}

Member 9762654 · Answer 5 · 2013-07-30T00:30:00

try this

C#

objCon.Open();
              strQuery = "select intDataId from tbtrnTranscriptDataNew where vchEventId='" + strEventId + "' and intPartno=" + intPartno + " and intPos=" + intPos + " and intSection=" + intSection;
              SqlDataAdapter da1 = new SqlDataAdapter(strQuery, objCon);

              DataTable DataTabledata = new DataTable("data");
              da1.Fill(DataTabledata);

              DataColumn dc2 = DataTabledata.Columns["intDataId"];
              if (DataTabledata.Rows.Count > 0)
              {
                  foreach (DataRow row in DataTabledata.Rows)
                  {
                      txttextbox.text=row[dc2].tostring();
                  }

              }

              objCon.Close();

venkateshCST · Answer 6 · 2013-07-30T00:38:00

Solution 6

if(ds.tables["Cultivator_tbl"].rows.count>0
textbox.text=ds.tables["Cultivator_tbl"].Rows[0]["c_FirstName"].tostring();

It will help you

Posted 30-Jul-13 0:38am

venkateshCST

Binding dataset data to textbox

6 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Add your solution here

Preview 0

Binding dataset data to textbox

6 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us