Click here to Skip to main content
12,954,601 members (54,456 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
how to bind the data in the datagridview !
Posted 12-Jan-13 7:27am
Comments
tusharkaushik 14-Jan-13 3:45am
   
PLease consider this code written by me :
private void btnSave_Click(object sender, EventArgs e)
{
try
{

conn = new SqlConnection("Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123");
conn.Open();
sqlcmd = new SqlCommand("insert into tasks values(" + txtT_id + ",'" + txtname.Text + "','" + cbopriority.Text + "','" + cboStatus.Text + "','" + txtcomments.Text + "','" + dtpdue_date + "','" + dtpcompletiondate + "')");
sqlcmd.ExecuteNonQuery();
da = new SqlDataAdapter("tasks", conn);
da.SelectCommand.CommandType = CommandType.Text;
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);

MessageBox.Show("Data has been successfully saved in the database", "Data Save Intimation", MessageBoxButtons.OK);
conn.Close();
txtT_id.Text = " ";
txtname.Text = " ";
cbopriority.Text = " ";
cboStatus.Text = " ";
txtcomments.Text = " ";
dtpdue_date.Text = " ";
dtpcompletiondate.Text = "";
}
}
I've written this code for the recording of tasks to show the detials in the datagridview!
but it is showing exceptions that "connection property is not intialised."
Please help me.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Drag and drop one datagridview contol to the form and do like this-

 

            private void ShowDetails_Load(object sender, EventArgs e)
        {
            try
            {
                SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=windowform;integrated security=true");
                SqlDataAdapter da = new SqlDataAdapter("show", sqlconn);
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                DataSet ds = new DataSet();
                da.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];
            }
            catch(Exception ex)
            {
 
                MessageBox.Show(ex.Message);
            }
        }
 
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,539
CHill60 3,490
Maciej Los 3,153
ppolymorphe 2,030
Jochen Arndt 1,975


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 14 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100