Comments by Somesh Dhal (Top 11 by date)

both are in my database

int count;
string myScalarQuery = "SHOW TABLES LIKE 'table1';";

MySqlCommand myCommand = new MySqlCommand(myScalarQuery, conn);
conn.Open();
count = (int)myCommand.ExecuteNonQuery();
conn.Close();
if (count == 0)
Response.Write("no such table exists");
else
Response.Write(" "+ count );
even this gives the same result "no such table exists" even if it exists...

i changed the code to following...

int count;
string myScalarQuery = "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'test' AND table_name = 'login';";

MySqlCommand myCommand = new MySqlCommand(myScalarQuery, conn);
conn.Open();
count = (int)myCommand.ExecuteNonQuery();
conn.Close();
if (count == 0)
Response.Write("no such table exists");
else
Response.Write(" "+ count );
still i i always get the error saying no such table exists even if the table 'login' exists..what to do?

i wanna see if it results any rows so that i can i can check whether a table with the same name already exists..how to solve this?

Thank You....it solved my problem...i was confused between the ' and `...

I HAVE DONE As u said bt same error saying ..
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''btechstudent_academics' set Tenth=@Tenth Where Regd_no=@Regd_no' at line 1"
the code-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.IO;

public partial class BtechSrtudentUpdate : System.Web.UI.Page
{
MySqlConnection conn1 = new MySqlConnection("Server=localhost;Database=test;Uid=root;Pwd=1234");

string r=" ";
protected void Page_Load(object sender, EventArgs e)
{

TextBoxtRegd.Text = Request.QueryString["regd"];

TextBoxTenth.Text = Request.QueryString["Tenth"];


}
protected void Button1_Click(object sender, EventArgs e)
{
string Regd_no;
Double Tenth;
Regd_no = TextBoxtRegd.Text;
Tenth = Convert.ToDouble(TextBoxTenth.Text);

conn1.Open();
string sql2 = "UPDATE 'btechstudent_academics' set Tenth=@Tenth" + " Where Regd_no=@Regd_no;";
MySqlCommand cmd2 = new MySqlCommand(sql2, conn1);
MySqlParameter param = new MySqlParameter("@Tenth",MySqlDbType.Double );
param.Value = Tenth;
cmd2.Parameters.Add(param );
MySqlParameter param1 = new MySqlParameter("@Regd_no", MySqlDbType.VarChar,10);
param.Value = Regd_no ;
cmd2.Parameters.Add(param1);

try
{
Response.Write("HI");
cmd2.ExecuteNonQuery();

Response.Write("HI2");
}
catch (Exception x)
{ Label1.Text = " " + x.Message; }
finally
{
conn1.Close();
}

}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{

}
protected void TextBoxBacklog_TextChanged(object sender, EventArgs e)
{

}
protected void TextBoxTenth_TextChanged(object sender, EventArgs e)
{

}
protected void TextBox9_TextChanged(object sender, EventArgs e)
{

}
}