yuttrim20
چهارشنبه 07 تیر 1391, 00:58 صبح
با سلام من کد زیر رو برای دکمه ثبت کنترل GridView نوشتم حالا میخوام اگه از گزینه های موجود یکی انتخاب شد و دکمه ثبت زده شد اول چک بشه اگه موجود نبود بعد ثبت بشه!
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Add")
{
int index = Convert.ToInt32(e.CommandArgument);
DropDownList dd = GridView1.Rows[index].Cells[1].FindControl("dd") as DropDownList;
DropDownList dd1 = GridView1.Rows[index].Cells[2].FindControl("dd1") as DropDownList;
SqlDataReader reader;
if (dd != null)
{
SqlConnection conn = new SqlConnection(Connection.GetConnection());
SqlCommand com = new SqlCommand();
string query = "SELECT id FROM [movie] WHERE (name=@name)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@name", GridView1.Rows[index].Cells[0].Text);
conn.Open();
int movie = Convert.ToInt32(com.ExecuteScalar());
query = "SELECT id FROM [sans] WHERE (sans=@sans)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@sans", dd1.Text);
int sans1 = Convert.ToInt32(com.ExecuteScalar());
query = "SELECT id FROM [salon] WHERE (name=@name1)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@name1", dd.Text);
int salon = Convert.ToInt32(com.ExecuteScalar());
conn.Close();
query = "insert into [barname salonha] values(@srl_sans,@srl_salon,@srl_movie)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@srl_salon", salon);
com.Parameters.AddWithValue("@srl_sans", sans1);
com.Parameters.AddWithValue("@srl_movie", movie);
conn.Open();
reader = com.ExecuteReader();
if (reader.HasRows)
{
reader.Close();
conn.Close();
Response.Write("<script> alert('قبلا ثبت شده') </script>");
}
//conn.Close();
//Response.Write("<script> alert('فیلم مورد نظر ثبت شد') </script>");
//Response.Write("<script> location.href = 'صفحه اصلی3.aspx' </script>");
//dd1.Se=;
}
نمیدونم چه تغییری باید بدم لطفا راهنمایی بفرمایید!!!
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Add")
{
int index = Convert.ToInt32(e.CommandArgument);
DropDownList dd = GridView1.Rows[index].Cells[1].FindControl("dd") as DropDownList;
DropDownList dd1 = GridView1.Rows[index].Cells[2].FindControl("dd1") as DropDownList;
SqlDataReader reader;
if (dd != null)
{
SqlConnection conn = new SqlConnection(Connection.GetConnection());
SqlCommand com = new SqlCommand();
string query = "SELECT id FROM [movie] WHERE (name=@name)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@name", GridView1.Rows[index].Cells[0].Text);
conn.Open();
int movie = Convert.ToInt32(com.ExecuteScalar());
query = "SELECT id FROM [sans] WHERE (sans=@sans)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@sans", dd1.Text);
int sans1 = Convert.ToInt32(com.ExecuteScalar());
query = "SELECT id FROM [salon] WHERE (name=@name1)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@name1", dd.Text);
int salon = Convert.ToInt32(com.ExecuteScalar());
conn.Close();
query = "insert into [barname salonha] values(@srl_sans,@srl_salon,@srl_movie)";
com.CommandText = query;
com.Connection = conn;
com.Parameters.AddWithValue("@srl_salon", salon);
com.Parameters.AddWithValue("@srl_sans", sans1);
com.Parameters.AddWithValue("@srl_movie", movie);
conn.Open();
reader = com.ExecuteReader();
if (reader.HasRows)
{
reader.Close();
conn.Close();
Response.Write("<script> alert('قبلا ثبت شده') </script>");
}
//conn.Close();
//Response.Write("<script> alert('فیلم مورد نظر ثبت شد') </script>");
//Response.Write("<script> location.href = 'صفحه اصلی3.aspx' </script>");
//dd1.Se=;
}
نمیدونم چه تغییری باید بدم لطفا راهنمایی بفرمایید!!!