binding sql dataset using

Question

0.00/5 (No votes)

See more:

sir!
I have written the code for the insert query for the sql dataset.
and i want to show the same data in datagridview. pls consider this code:

C#

private void btnSave_Click(object sender, EventArgs e)
      {
          string s = dtpdue_date.Value.ToString();
          string s1 = dtpcompletiondate.Value.ToString();

          string connectionstr = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
          string sql = "Insert into tasks(t_id,Name,Priority,status,Due_date,description,date of completion)"+txtT_id.Text+",'"+txtname.Text+"','"+cbopriority.Text+",'"+cboStatus.Text+"','"+ s+"','"+txtcomments.Text+"'.'"+s1+"')";
          da = new SqlDataAdapter(sql,connectionstr);
          ds = new DataSet();
          connectionstr.Close();
              txtT_id.Text = " ";
              txtname.Text = " ";
              cbopriority.Text = " ";
              cboStatus.Text = " ";
              txtcomments.Text = " ";
              dtpdue_date.Text = " ";
              dtpcompletiondate.Text = "";


          }
      }

Posted 14-Jan-13 5:13am

tusharkaushik

Updated 14-Jan-13 5:14am

DinoRondelly

v2

Add a Solution

Comments

Richard C Bishop 14-Jan-13 11:22am

Just set the DataSource of the datagrid equal to your dataset.

tusharkaushik 14-Jan-13 12:30pm

but how !
is there any code for doing it!

tusharkaushik 14-Jan-13 12:34pm

sir ! i've modified the code code given below!
string s = dtpdue_date.Value.ToString();
string s1 = dtpcompletiondate.Value.ToString();
string connectionstr = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
conn = new SqlConnection(connectionstr);
string sql = "Insert into tasks(t_id,Name,Priority,status,Due_date,description,date of completion)" + txtT_id.Text + ",'" + txtname.Text + "','" + cbopriority.Text + ",'" + cboStatus.Text + "','" + s + "','" + txtcomments.Text + "'.'" + s1 + "')";
da = new SqlDataAdapter(sql, connectionstr);
conn.Open();
ds = new DataSet();
commandbuilder = new SqlCommandBuilder(da);
da.Fill(ds, "tasks");
bsource.DataSource = ds.Tables["tasks"];
dataGridView1.DataSource = bsource;
please consider this code:
this shows the exception "connection property".
what's the another solution!

tusharkaushik 14-Jan-13 12:44pm

is there any code!

1 solution

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)

Jibesh · Answer 1 · 2013-01-14T09:37:00

Solution 2

Update your code like this

C#

private void btnSave_Click(object sender, EventArgs e)
{
  string s = dtpdue_date.Value.ToString();
  string s1 = dtpcompletiondate.Value.ToString();
           
  string connectionstr = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
  string sql = "Insert into tasks(t_id,Name,Priority,status,Due_date,description,date of completion) values('"+txtT_id.Text+"','"+txtname.Text+"','"+cbopriority.Text+",'"+cboStatus.Text+"','"+ s+"','"+txtcomments.Text+"'.'"+s1+"')";
    
 DataSet dataSet = new DataSet();
 using (SqlConnection connection =
        new SqlConnection(connectionstr))
    {
        SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = new SqlCommand(
            sql, connection);
        adapter.Fill(dataset);
        dataGridView1.DataSource = dataset;
    }
}

make sure that your connection string is in proper order.

Posted 14-Jan-13 9:37am

Jibesh

Updated 15-Jan-13 6:39am

v2

Comments

tusharkaushik 15-Jan-13 12:36pm

where is the querystring in this coding.

Jibesh 15-Jan-13 12:39pm

oops sorry you should replace the querystring with the variable sql in your code. Check my updated solution

tusharkaushik 15-Jan-13 12:52pm

This code is giving error . i couldn't understand the code.

Jibesh 15-Jan-13 12:55pm

what error you are getting. there isnt much in this code:
Create a Connection object using SqlConnection, usage of Using clause is to close the connection automatically when the execution leaves the scope
Creating a dataAdapter instance to fill the data using new SqlDataAdapter

what error you are getting?

tusharkaushik 16-Jan-13 1:11am

but in my c# book i have read connection.open statement in disconnected environment.

Jibesh 16-Jan-13 1:46am

what error you are getting when runing the above code?

tusharkaushik 16-Jan-13 5:21am

incoorrect connection property.

tusharkaushik 16-Jan-13 14:08pm

private void btnSave_Click(object sender, EventArgs e)
{
// try
// {
string s1 = dtpdue_date.Value.ToString();
string s2 = dtpcompletiondate.Value.ToString();
string querystring = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
string sqlquery = "insert into tasks(T_id ,name,status,Priority,Description,Due_date,comletion_date)" + "values(" + txtT_id.Text + ",'" + txtname.Text + "','" + cboStatus.Text + "','" + cbopriority.Text + "'," + txtcomments.Text + "'," + s1 + "," + s2 + ")";
callcenterDataSet calldataset = new callcenterDataSet();
//}
using (SqlConnection conn = new SqlConnection(querystring))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(querystring, conn);
adapter.Fill(calldataset);
dataGridView1.DataSource = calldataset;

}
}
when i run this code , the exception occured showing the error "incorrect syntax near "=". pointing the line where : adapter.Fill(calldataset);
dataGridView1.DataSource = calldataset;

Jibesh 16-Jan-13 14:16pm

Do you know how to debug your application if yes? could you please put a break poinht at the line 'SqlDataAdapter adapter = new SqlDataAdapter();' and copy paste the contents of querystgring and sqlquery. I doubt the querystring or the sqlquery prepared has some error.

also if possible please copy the exception stack fully rather the message alone. i.e exception.ToString() will return whole stack.

Jibesh 16-Jan-13 14:29pm

Ok.. i tried to format your sqlQuery and found that you forgot enlose the txtcomments.text with single quote. it should be

string sqlquery = "insert into tasks(T_id ,name,status,Priority,Description,Due_date,comletion_date)" + "values(" + txtT_id.Text + ",'" + txtname.Text + "','" + cboStatus.Text + "','" + cbopriority.Text + "','" + txtcomments.Text + "'," + s1 + "," + s2 + ")";

this part modified
"','" + txtcomments.Text

tusharkaushik 20-Jan-13 13:20pm

but it's still not working:
I' m copying the code below:
private void btnSave_Click(object sender, EventArgs e)
{
string s = dtpdue_date.Value.ToString();
string s1 = dtpcompletiondate.Value.ToString();
string querystring = "Data Source=TUSHAR-PC;Initial Catalog=callcenter;Persist Security Info=True;User ID=sa;Password=password@123";
string sqlquery = "insert into tasks(T_id,name,status,Priority,Description,Due_date,completion_date)" + "values(" + txtT_id.Text + ",'" + txtname.Text + "','" + cbopriority.Text + "','" + cboStatus.Text + "','" + txtcomments.Text + "'," + s + "," + s1 + ")";
callcenterDataSet ds = new callcenterDataSet();
using (SqlConnection connection = new SqlConnection(querystring))
{
SqlDataAdapter sqladapter = new SqlDataAdapter();
sqladapter.SelectCommand = new SqlCommand(sqlquery, connection);
sqladapter.Fill(ds);
dataGridView1.DataSource = ds;
}
}
it show the exception "incorrect synta near 1 " when it reaches the statement:
SqlDataAdapter sqladapter = new SqlDataAdapter();
sqladapter.SelectCommand = new SqlCommand(sqlquery, connection);
sqladapter.Fill(ds);
dataGridView1.DataSource = ds;
}

Jibesh 21-Jan-13 0:02am

can you copy paste the exception stack fully.