Dataset row value to textbox

Question

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

Sonu Gupta · Answer

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(); }

Rupesh Kahane · Answer

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]); }

Mageshwaran R · Answer

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(); } }