how to display the data from the database in windows form

Question

0.00/5 (No votes)

See more:

I am new to c#.

I have return the following code to add data to the Datatable.

C#

private void addbtn_Click(object sender, EventArgs e)
       {
          SqlCommand cmd;
           SqlConnection con=new SqlConnection("Data Source=name;Initial Catalog=month;Integrated Security=True");

           con.Open();
           cmd=new SqlCommand("Insert into grossarynames values(' "+glisttxt.Text+" ')",con);
           cmd.ExecuteNonQuery();

       }

It is adding the values to the database.

But the data is not displayed in the DataGrid view please tell the code to display the data to the database.

Posted 22-Dec-11 18:26pm

kamath2012

Updated 22-Dec-11 19:36pm

RaisKazi

v2

Add a Solution

Comments

Sandeep Mewara 23-Dec-11 1:37am

What datagridview? In current code, there is no mention of any datagrid! Please update the question and add more details.

Scubapro 23-Dec-11 1:44am

Off course it's not displayed. If you have a data-bounded datagridview, you'll have to perform a requery (database) and refresh your datagridview.

kamath2012 23-Dec-11 2:03am

in the windows form if i get the grid view task and click priview data the table entries are shown.But it is not displayed in the gridview? how to code that?

kamath2012 23-Dec-11 1:57am

how to get the databounded datagridview?

kamath2012 23-Dec-11 2:01am

in the windows form if i get the grid view task and click priview data the table entries are shown.But it is not displayed in the gridview? how to code that?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

nishantcomp2512 · Answer 1 · 2011-12-27T02:01:00

C#

private void addbtn_Click(object sender, EventArgs e)
        {
            SqlCommand cmd,read1;
            SqlConnection con=new SqlConnection("Data Source=name;Initial Catalog=month;Integrated Security=True");
            con.Open();
            cmd=new SqlCommand("Insert into grossarynames values(' "+glisttxt.Text+" ')",con);
            cmd.ExecuteNonQuery();
            read1=new SqlCommand("Select * from grossarynames,con);
            SqlDataReader dr=read1.executeReader();
            DataTable dt=new Datatable();
            dt.Load(dr);
            datagridview.source=dt;
        }

check code

RaviRanjanKr · Answer 2 · 2011-12-27T02:09:00

Try

C#

SqlCommand myCommand = new SqlCommand("your SELECT command");
SqlDataAdapter oAdapter = new SqlDataAdapter(myCommand); // You have a sqlDataAdapter which executes your command
dataset ds = new dataset();
oAdapter.Fill(ds);
myGridview.datasource = ds;
myGriview.databind();  // and then finally bind it to your GridView in your UI layer like this

More Reference Link :- http://www.dotnetperls.com/datagridview-tutorial[^]

Sarvesh Kumar Gupta · Answer 3 · 2011-12-27T02:14:00

use below code to display the data:

C#

SqlCommand cmd;
            SqlConnection con=new SqlConnection("Data Source=name;Initial Catalog=month;Integrated Security=True");
 
            con.Open();
            cmd=new SqlCommand("Select * from grossarynames",con);
SqlDataAdapter da = new SqlDataAdapter(cmd); 
            cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds
DataGrid1.DataMember = "grossarynames";

Lakhan Aanjana · Answer 4 · 2011-12-27T03:47:00

Try it

C#

if (ca.con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            ca.da = new SqlDataAdapter("SELECT * from newproduct ", con);
            DataSet ds = new DataSet();
            ca.da.Fill(ds,"newproduct");
            dataGridView1 .DataSource =ds.Tables ["newproduct"];
            con.Close();
}

how to display the data from the database in windows form

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0