Loading

C# code to drop a table?

Ankita Ankita

In following if condition is getting false n control jumps to else. Is my condition wrong? I get o/p as "Table is not dropped". what value is returned by executenonquery method for drop table?

con is object of sqlconnection.
cmd is object of sqlcommand

con.open();
string str=" Drop table temp";
cmd= new SqlCommand(str,con);
int r=cmd.executenonquery();
if(r>0)
{

messagebox.show("Table is dropped");

}
else
{

messagebox.show("Table is not dropped");
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinitha T4y ago
Alternate way:

class Program{
public static void Main(string[] args){
SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=DbName; Integrated Security=True");
string query = "DROP TABLE temp";
SqlCommand cmd = new SqlCommand(query, con);
try{
con.Open();
cmd.ExecuteNonQuery();
Console.WriteLine("Table Dropped");
}
catch( SqlException e){
Console.WriteLine("Error Generated. Details: " + e.ToString());
}
finally{
con.close();
}
}
}
0
Senthilkumar14y ago
The ExecuteNonQuery() method in the SqlCommand object returns the number of rows affected.

con.open();
string str=" Drop table temp";
cmd= new SqlCommand(str,con);
int r=cmd.executenonquery();
if(r<0)
{

messagebox.show("Table is dropped");

}
else
{

messagebox.show("Table is not dropped");
}

Please check it out and if it is useful then mark it as Accept Answer
0