Binding database data to the GridView in ASP.Net

Question

I try to bind database data to the gridview in c# and asp.net. But I couldn't see the datas in the gridview.Rows are added to the gridview but they are empty. When I run that query in SQLServer, it gives the correct result.I didn't add or change any code to the asp part.Should I? I couldn't find where is the problem :( please help..

myConnection = WebConfigurationManager.ConnectionStrings["KutuphaneConnectionString"].ConnectionString;
connect = new SqlConnection(myConnection);
command = new SqlCommand();
connect.Open();
command.Connection = connect;

 string komut = "SELECT K.ad,K.yazar,K.baskiNo,O.sonTeslimTarihi FROM OduncIslemleri O,Kitap K WHERE O.kullaniciId=" + Session["id"] + " AND O.kitapId = K.id;";
        try
        {
            SqlCommand sqlCommand = new SqlCommand();

                sqlCommand = connect.CreateCommand();
                sqlCommand.CommandText = komut;
                SqlDataAdapter sda = new SqlDataAdapter(sqlCommand.CommandText, connect);
                SqlCommandBuilder scb = new SqlCommandBuilder(sda);
                //Create a DataTable to hold the query results.
                DataTable dTable = new DataTable();
                //Fill the DataTable.
                sda.Fill(dTable);
                GridView1.DataSource = dTable;
                GridView1.DataBind();

        }
        catch (SqlException)
        {
            //Console.WriteLine(e.StackTrace);
        }

reader.Close();
connect.Close();

You should provide the aspx-part of the GridView. Are you AutoGenerateColumns? Besides, remember not to rebind the GridView from Page_Load in Postbacks. So always check for !Page.IsPostback before you DataBind the Grid. — Tim Schmelter
– Tim Schmelter, Commented May 13, 2011 at 23:15
first complete with the missing aspx-part in your question. And what part would you like to be explained? The GridView-property AutoGenerateColumns is selfexplaining, besides i've provided a link. The postback-check is also simple. — Tim Schmelter
– Tim Schmelter, Commented May 13, 2011 at 23:31

Amar Palsapure · Accepted Answer · 2012-02-09 05:18:48Z

4

Here is the correct answer :

myConnection = WebConfigurationManager.ConnectionStrings["KutuphaneConnectionString"].ConnectionString;
connect = new SqlConnection(myConnection);
string sorgu = "select K.ad,K.yazar,K.baskiNo,O.sonTeslimTarihi from Kitap K, OduncIslemleri O where O.kitapId = K.id and O.kullaniciId = "+ Session["id"];
SqlDataAdapter sadp = new SqlDataAdapter(sorgu, connect);
DataSet ds = new DataSet();
sadp.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
connect.Close();

I also used template fields in Gridview. Also autogeneratedFields should be true. I hope this helps to the people who have the same problem

edited Feb 9, 2012 at 5:18

Amar Palsapure

9,6561 gold badge29 silver badges46 bronze badges

answered May 14, 2011 at 9:17

dnur

7193 gold badges13 silver badges21 bronze badges

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

Comments

Oscar Cabrero · Accepted Answer · 2011-05-13 23:04:41Z

0

watch for another event triggered after the bind that could be clearing the rows

answered May 13, 2011 at 23:04

Oscar Cabrero

4,1698 gold badges33 silver badges49 bronze badges

1 Comment

dnur Over a year ago

I don't think so.. I wrote it page_load class and they are te last sentences than page is shown.

Will A · Accepted Answer · 2011-05-13 23:07:20Z

0

Try creating a DataSet and populate that using Fill instead. I've never seen Fill used on a DataTable - and can't find that particular overload on MSDN. My suspicion is, though, that such an overload would not modify the existing schema of the DataTable (which, since it's only just been created prior to use in your example, would mean that it has no columns).

answered May 13, 2011 at 23:07

Will A

25k5 gold badges54 silver badges61 bronze badges

2 Comments

dnur Over a year ago

I tried this but it gave also same result : string komut = "SELECT K.ad,K.yazar,K.baskiNo,O.sonTeslimTarihi FROM OduncIslemleri O,Kitap K WHERE O.kullaniciId=" + Session["id"] + " AND O.kitapId = K.id;"; SqlCommand cmd = new SqlCommand(komut, connect); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds, "Kitap"); GridView1.DataSource = ds; GridView1.DataBind();

Will A Over a year ago

How about with GridView1.DataSource = ds.Tables(0); ?

Robbie Tapping · Accepted Answer · 2011-05-13 23:56:06Z

0

I think you have to use a BindingSource Control, you set the DataSource of it to the DataTable, and then set the GridView's DataSource to the BindingSource.

answered May 13, 2011 at 23:56

Robbie Tapping

2,5561 gold badge17 silver badges18 bronze badges

Collectives™ on Stack Overflow

Binding database data to the GridView in ASP.Net

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related