the error shows that cannot implicit int type to bool value

[umabaskar]

the error shows that cannot implicit convert type 'System.Data.SqlClient.SqlParameter' to 'bool'..

here is my code ...


code:


protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
cmd.CommandType = CommandType.TableDirect;
DropDownList id = (DropDownList)sender;

// e.NewSelectedIndex["Status"] = (Convert.ToString()id.SelectedValue;

// GridViewRow row = GridView1.Rows[GridView1.EditIndex];
GridViewRow row = GridView1.Rows[GridView1.SelectedIndex];

cmd.CommandType = CommandType.TableDirect;
if(cmd.Parameters.AddWithValue("@Status", txtslry.Text))
{
txtslry.Text = "Yes";

if (id.SelectedValue == "Yes")
{
TextBox column1 = (TextBox)row.FindControl("Column1ID");
column1.Visible = true;
TextBox column2 = (TextBox)row.FindControl("Column2ID");
column2.Visible = true;
TextBox column3 = (TextBox)row.FindControl("Column3ID");
column3.Visible = true;
TextBox column4 = (TextBox)row.FindControl("Column4ID");
column4.Visible = true;
TextBox column5 = (TextBox)row.FindControl("Column5ID");
column5.Visible = true;



}

else if (cmd.Parameters.AddWithValue("@Status", txtslry.Text))
{
txtslry.Text = "No";
}
else if (id.SelectedValue == "No")
{
TextBox column1 = (TextBox)row.FindControl("Column1ID");
column1.Visible = false;
TextBox column2 = (TextBox)row.FindControl("Column2ID");
column2.Visible = false;
TextBox column3 = (TextBox)row.FindControl("Column3ID");
column3.Visible = false;
TextBox column4 = (TextBox)row.FindControl("Column4ID");
column4.Visible = false;
TextBox column5 = (TextBox)row.FindControl("Column5ID");
column5.Visible = false;


}

[Monomachus]

The problem is in your ifs statements cmd.Parameters.AddWithValue will return a System.Data.SqlClient.SqlParameter, but you want somehow to decide base on it (meaning you want to see a boolean ? ).
Check more about SqlParameter.AddWithValue in http://msdn.microsoft.com/en-us/libr...withvalue.aspx

if(cmd.Parameters.AddWithValue("@Status", txtslry.Text))
{