im binding the values in the grid , rows and columns are autogenerated depending upon the values. i generated dropdownlist depending upon the values and exactly beside the number of rows created with 3 list item. i passed the value of the dropdownlist
selected as parameter. now for each row in the grid a query is executed inside for loop but the query is not executed second time can anybody please help.
shobana raja
Member
122 Points
228 Posts
Sql query
May 07, 2012 11:11 AM|LINK
im binding the values in the grid , rows and columns are autogenerated depending upon the values. i generated dropdownlist depending upon the values and exactly beside the number of rows created with 3 list item. i passed the value of the dropdownlist selected as parameter. now for each row in the grid a query is executed inside for loop but the query is not executed second time can anybody please help.
shivalthakur
Participant
1859 Points
540 Posts
Re: Sql query
May 07, 2012 11:15 AM|LINK
CODE please.
Response.Write("Success");
Best Of Luck
Shival Thakur
shobana raja
Member
122 Points
228 Posts
Re: Sql query
May 07, 2012 11:21 AM|LINK
foreach (GridViewRow grdRow in GridView1.Rows)
{
using (SqlConnection conn = (SqlConnection)provider.CreateConnection())
{
conn.ConnectionString = connString;
using (SqlCommand cmd = new SqlCommand())
{
DropDownList NewsType;
NewsType = (DropDownList)(GridView1.Rows[grdRow.RowIndex].FindControl("NewsletterType"));
string Newslettertype = NewsType.SelectedItem.Text;
string title = GridView1.Rows[grdRow.RowIndex].Cells[1].Text;
string sqlQuerry = "Update Newsletter set NewsletterType='" + Newslettertype + "', " +
"ModifiedDate='" + DateTime.Now + "', ModifiedBy = '" + Page.User.Identity.Name + "' where Title='" + title + "' ";
cmd.CommandText = sqlQuerry;
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
}
}
sriramabi
Contributor
4351 Points
1277 Posts
Re: Sql query
May 07, 2012 12:52 PM|LINK
pls change u r query
string sqlQuerry = "Update Newsletter set NewsletterType='" + Newslettertype + "', ModifiedDate='" + DateTime.Now + "', ModifiedBy = '" + Page.User.Identity.Name + "' where Title='" + title + "' ";
thank u
Mastan Oli
Contributor
5100 Points
999 Posts
Re: Sql query
May 07, 2012 02:06 PM|LINK
modify your code like,
using (SqlConnection conn = (SqlConnection)provider.CreateConnection()) { conn.ConnectionString = connString; conn.Open(); foreach (GridViewRow grdRow in GridView1.Rows) { using (SqlCommand cmd = new SqlCommand()) { DropDownList NewsType; NewsType = (DropDownList)(GridView1.Rows[grdRow.RowIndex].FindControl("NewsletterType")); string Newslettertype = NewsType.SelectedItem.Text; string title = GridView1.Rows[grdRow.RowIndex].Cells[1].Text; string sqlQuerry = "Update Newsletter set NewsletterType='" + Newslettertype + "', " + "ModifiedDate='" + DateTime.Now + "', ModifiedBy = '" + Page.User.Identity.Name + "' where Title='" + title + "' "; cmd.CommandText = sqlQuerry; cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.ExecuteNonQuery(); } } }playingOOPS | மெய்ப்பொருள் காண்பதறிவு
Mark as Answer If you find helpful
shobana raja
Member
122 Points
228 Posts
Re: Sql query
May 10, 2012 09:38 AM|LINK
Im getting error
Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' '.
sriramabi
Contributor
4351 Points
1277 Posts
Re: Sql query
May 10, 2012 09:45 AM|LINK
u try my query?
string sqlQuerry = "Update Newsletter set NewsletterType='" + Newslettertype + "', ModifiedDate='" + DateTime.Now + "', ModifiedBy = '" + Page.User.Identity.Name + "' where Title='" + title + "' ";
its not sole if ...
pls post u r query....