data table to gridview

Question

In my project,
I check the condition and stored the data from database to data table and bind that to grid view..

problem is in grid view they bind the last row only , previous row are overwrite , What is the problem
HELP ME

selva kumar · Answer

i can't able to understand your needs.Even i give the reference.If you explain briefly means,i will give correct reference... here is sample.. DataTable Dt = new DataTable(); Con.Open(); Sdap = new SqlDataAdapter("Select Query", Con); Sdap.Fill(Dt); Con.Close(); foreach (DataRow row in Dt.Rows) { for (int i = 0; i { string assignname= Dt.Rows[i]["columnname"].ToString(); . . . Gridview binding goes here... } } For more details u should upload ur source code..then only i can solve ur problem...

Laxmikant · Answer

can you post your code.... I guess you are adding just one row in datatable

Fathima tasleem · Answer

protected void Page_Load(object sender, EventArgs e) { } DataTable dt; string sql; protected void Button1_Click(object sender, EventArgs e) { try { string ConStr = "Data source=localhost; database=trainroute; Integrated Security=SSPI;"; SqlConnection con = new SqlConnection(ConStr); con.Open(); string source = TextBox1.Text; string des = TextBox2.Text; string query = " select * from split"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { string trno = dr[0].ToString(); string trname = dr[1].ToString(); string source_db = dr[2].ToString(); string route_db = dr[3].ToString(); string destination_db = dr[4].ToString(); // search via source and destination if ((source.ToString().Trim() == source_db.ToString().Trim()) && (des == destination_db)) { sql="select * from split where train_no='"+trno+"';"; dt = getdata(sql); GridView1.DataSource = dt; GridView1.DataBind(); } // Split string on spaces. This will separate all the words in a string // search via source and destination(route) if (source.ToString() == source_db.ToString()) { string[] words = route_db.Split(' '); foreach (string word in words) { if (des == word.ToString()) { sql = @"select * from split where train_no='" + trno + "';"; dt = getdata(sql); GridView1.DataSource = dt; GridView1.DataBind(); } } } //search via source(route ) and destination if (des.ToString() == destination_db.ToString()) { string[] words = route_db.Split(' '); foreach (string word in words) { if (source == word.ToString()) { sql = @"select * from split where train_no='" + trno + "';"; dt = getdata(sql); GridView1.DataSource = dt; GridView1.DataBind(); } } } // Search via source and destination in routes string[] words1 = route_db.Split(' '); int flag = 0; foreach (string word in words1) { if (source == word.ToString() && flag == 0) { flag = 1; } if (des.ToString() == word.ToString() && flag == 1) { sql = @"select * from split where train_no='" + trno + "';"; dt = getdata(sql); GridView1.DataSource = dt; GridView1.DataBind(); } } } } con.Close(); } catch (Exception exp) { err.Text = exp.ToString(); } } public DataTable getdata(string sql1) { DataTable dt1 = new DataTable(); try { using (SqlConnection con = new SqlConnection("Data source=localhost; database=Busroute; Integrated Security=SSPI;")) { SqlDataAdapter da = new SqlDataAdapter(sql1, con); da.Fill(dt1); } } catch (Exception ex) { err2.Text = ex.ToString(); } return dt1; } } Db Structure: tr_no, tr_name, source, route, destination this is my code , I'm new asp.net(c#), so help me sir.. Thank You

data table to gridview

Answers (3)