the error shows that cannot implicit int type to bool value

[umabaskar]

the error shows that cannot implicit convert type 'System.Data.Sq lClient.SqlPara meter' to 'bool'..

here is my code ...


code:


protected void GridView1_Selec tedIndexChangin g(object sender, GridViewSelectE ventArgs e)
{
cmd.CommandType = CommandType.Tab leDirect;
DropDownList id = (DropDownList)s ender;

// e.NewSelectedIn dex["Status"] = (Convert.ToStri ng()id.Selected Value;

// GridViewRow row = GridView1.Rows[GridView1.EditI ndex];
GridViewRow row = GridView1.Rows[GridView1.Selec tedIndex];

cmd.CommandType = CommandType.Tab leDirect;
if(cmd.Paramete rs.AddWithValue ("@Status", txtslry.Text))
{
txtslry.Text = "Yes";

if (id.SelectedVal ue == "Yes")
{
TextBox column1 = (TextBox)row.Fi ndControl("Colu mn1ID");
column1.Visible = true;
TextBox column2 = (TextBox)row.Fi ndControl("Colu mn2ID");
column2.Visible = true;
TextBox column3 = (TextBox)row.Fi ndControl("Colu mn3ID");
column3.Visible = true;
TextBox column4 = (TextBox)row.Fi ndControl("Colu mn4ID");
column4.Visible = true;
TextBox column5 = (TextBox)row.Fi ndControl("Colu mn5ID");
column5.Visible = true;



}

else if (cmd.Parameters .AddWithValue(" @Status", txtslry.Text))
{
txtslry.Text = "No";
}
else if (id.SelectedVal ue == "No")
{
TextBox column1 = (TextBox)row.Fi ndControl("Colu mn1ID");
column1.Visible = false;
TextBox column2 = (TextBox)row.Fi ndControl("Colu mn2ID");
column2.Visible = false;
TextBox column3 = (TextBox)row.Fi ndControl("Colu mn3ID");
column3.Visible = false;
TextBox column4 = (TextBox)row.Fi ndControl("Colu mn4ID");
column4.Visible = false;
TextBox column5 = (TextBox)row.Fi ndControl("Colu mn5ID");
column5.Visible = false;


}

[Monomachus]

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

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