Dataset row value to textbox

Sujay Anand

6y3.5kLearn iOS Programming

How to get the dataset row value in single textbox based on condition

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonu Gupta6y ago
Hi try this -

SqlConnection con = new SqlConnection(@"put your connection string");
SqlCommand cmd = new SqlCommand("select cityName from tblCity where cityId=1", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
txtCity.Text = ds.Tables[0].Rows[0]["cityName"].ToString();
}
0
Rupesh Kahane6y ago
Try below methods
1)
You can set particular cell value of dataset into variable. like this
string name= Convert.ToString(ds.Tables[0].Rows[0]["name"]);
or
string firstrowvalue = ds.Tables[0].Rows[0][0].ToString();

string secondrowvalue = ds.Tables[0].Rows[1][0].ToString();

string thirdrowvalue = ds.Tables[0].Rows[2][0].ToString();
using loop you can iterate values in the variable or if you are binding values into data binding control then also do the same :
int value=0;
for(i=0;i
{
int value=value + Convert.ToInt32(ds.Tables[0].Rows[0]["value"]);
}
2)
// Create a table
DataTable table = new DataTable("users");
table.Columns.Add(new DataColumn("Id", typeof(int)));
table.Columns.Add(new DataColumn("Name", typeof(string)));

table.Rows.Add(1, "abc");
table.Rows.Add(2, "ddd");
table.Rows.Add(3, "fff");
table.Rows.Add(4, "hhh d");
table.Rows.Add(5, "hkf ds");

// Search for given id e.g here 1

DataRow[] result = table.Select("Id = 1"); // this will return one row for above data
foreach (DataRow row in result)
{
    Console.WriteLine("{0}, {1}", row[0], row[1]);
}
0
Mageshwaran R6y ago
Hi,
try this code:
using(sqlconnection sqlcon=new sqlconnection(connectionstring))
{
sqlcon.open();
sqlcommnand sqlcmnd=new sqlcommand("select *from tb_name",sqlcon);
sqlcmnd.exectenonquery();
sqlDataadapter sqladapter=new sqldataadapter(sqlcmnd);
dataset ds=new dataset();
sqladpapter.fill(ds);
if(ds.rows.count>0)
{
  txtname.text=ds.tables[0].rows[0][0].Tostring();


}


}
0