Clear DataGrid for new search result in c#
up vote
0
down vote
favorite
I was trying to clear the DataGrid for new result view but I couldn't. Is there any problem of my writing those code or anything else? Please help me on this. Here is the code:
private void btnsearch_Click(object sender, EventArgs e)
{
string sid = txtsid.Text;
string subject = cmbsubject.Text;
string term = txtterm.Text;
string year = cmbyear.Text;
string stclass = cmbclass.Text;
string connection = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:sms.mdf;Integrated Security=True";
string queryAll = "SELECT * FROM Result WHERE sid='"+sid+"' OR term='"+term+"' OR subject='"+subject+"' OR class='"+stclass+"' OR year = '"+year+"'";
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand(queryAll, con);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dataset = new DataTable();
sda.Fill(dataset);
BindingSource bs = new BindingSource();
bs.DataSource = dataset;
// dgResult is the changed name of the DataGridView
dgResult.DataSource = bs;
sda.Update(dataset);
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
finally
{
con.Close();
}
}
c# asp.net
asked Nov 18 at 20:14
Aneek Siddiki
12
add a comment |
up vote
0
down vote
favorite
I was trying to clear the DataGrid for new result view but I couldn't. Is there any problem of my writing those code or anything else? Please help me on this. Here is the code:
private void btnsearch_Click(object sender, EventArgs e)
{
string sid = txtsid.Text;
string subject = cmbsubject.Text;
string term = txtterm.Text;
string year = cmbyear.Text;
string stclass = cmbclass.Text;
string connection = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:sms.mdf;Integrated Security=True";
string queryAll = "SELECT * FROM Result WHERE sid='"+sid+"' OR term='"+term+"' OR subject='"+subject+"' OR class='"+stclass+"' OR year = '"+year+"'";
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand(queryAll, con);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dataset = new DataTable();
sda.Fill(dataset);
BindingSource bs = new BindingSource();
bs.DataSource = dataset;
// dgResult is the changed name of the DataGridView
dgResult.DataSource = bs;
sda.Update(dataset);
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
finally
{
con.Close();
}
}
c# asp.net
asked Nov 18 at 20:14
Aneek Siddiki
12
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
dgResult.DataSource = null?
– Miamy
Nov 18 at 20:42
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in ausingblock. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.
– Richardissimo
Nov 18 at 21:35
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I was trying to clear the DataGrid for new result view but I couldn't. Is there any problem of my writing those code or anything else? Please help me on this. Here is the code:
private void btnsearch_Click(object sender, EventArgs e)
{
string sid = txtsid.Text;
string subject = cmbsubject.Text;
string term = txtterm.Text;
string year = cmbyear.Text;
string stclass = cmbclass.Text;
string connection = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:sms.mdf;Integrated Security=True";
string queryAll = "SELECT * FROM Result WHERE sid='"+sid+"' OR term='"+term+"' OR subject='"+subject+"' OR class='"+stclass+"' OR year = '"+year+"'";
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand(queryAll, con);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dataset = new DataTable();
sda.Fill(dataset);
BindingSource bs = new BindingSource();
bs.DataSource = dataset;
// dgResult is the changed name of the DataGridView
dgResult.DataSource = bs;
sda.Update(dataset);
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
finally
{
con.Close();
}
}
c# asp.net
asked Nov 18 at 20:14
Aneek Siddiki
12
I was trying to clear the DataGrid for new result view but I couldn't. Is there any problem of my writing those code or anything else? Please help me on this. Here is the code:
private void btnsearch_Click(object sender, EventArgs e)
{
string sid = txtsid.Text;
string subject = cmbsubject.Text;
string term = txtterm.Text;
string year = cmbyear.Text;
string stclass = cmbclass.Text;
string connection = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:sms.mdf;Integrated Security=True";
string queryAll = "SELECT * FROM Result WHERE sid='"+sid+"' OR term='"+term+"' OR subject='"+subject+"' OR class='"+stclass+"' OR year = '"+year+"'";
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand(queryAll, con);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dataset = new DataTable();
sda.Fill(dataset);
BindingSource bs = new BindingSource();
bs.DataSource = dataset;
// dgResult is the changed name of the DataGridView
dgResult.DataSource = bs;
sda.Update(dataset);
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
finally
{
con.Close();
}
}
c# asp.net
c# asp.net
asked Nov 18 at 20:14
Aneek Siddiki
12
asked Nov 18 at 20:14
Aneek Siddiki
12
edited Nov 18 at 20:18
asked Nov 18 at 20:14
Aneek Siddiki
12
asked Nov 18 at 20:14
Aneek Siddiki
12
asked Nov 18 at 20:14
Aneek Siddiki
12
12
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
dgResult.DataSource = null?
– Miamy
Nov 18 at 20:42
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in ausingblock. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.
– Richardissimo
Nov 18 at 21:35
add a comment |
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
dgResult.DataSource = null?
– Miamy
Nov 18 at 20:42
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in ausingblock. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.
– Richardissimo
Nov 18 at 21:35
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
dgResult.DataSource = null ?– Miamy
Nov 18 at 20:42
dgResult.DataSource = null ?– Miamy
Nov 18 at 20:42
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in a
using block. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.– Richardissimo
Nov 18 at 21:35
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in a
using block. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.– Richardissimo
Nov 18 at 21:35
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53365007%2fclear-datagrid-for-new-search-result-in-c-sharp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
stackoverflow.com/a/3745070/4180382
– Ole EH Dufour
Nov 18 at 20:17
@OleEHDufour I have already tried those. But no results. Previous result still remains on the data grid
– Aneek Siddiki
Nov 18 at 20:21
dgResult.DataSource = null?– Miamy
Nov 18 at 20:42
Unrelated tips: SqlConnection SqlCommand and SqlDataReader are all IDisposable so each should be in a
usingblock. Once you've done that, you don't need to Close the connection because it will be closed by the implicit Dispose as it exits the block. Your code is vulnerable to SQL injection attacks: avoid using string concatenation to create queries, use parameters.– Richardissimo
Nov 18 at 21:35