hi!
Please help me i have a fuction that will check that, if there is any value exist in table
as input given.
the fuction i have written is like this but not working:

private int GetShopID(string ShopName)
{
    string connectionString = ConfigurationSettings.AppSettings["conStr"];
    string qry ="SELECT ShopID FROM tblShopInformation where ShopName=@ShopName";
    SqlConnection con= new SqlConnection(connectionString);
    SqlCommand cmd= new SqlCommand(qry,con);
    cmd.Parameters.Add("@ShopName",SqlDbType.NVarChar, 50).Value = ShopName;
    string Shop_ID=qry;
    int ShopID=Convert.ToInt16("Shop_ID");
    if(ShopID>=1)
    {
    Label1.Text="value exist";
    }
    return 0;
}


private void Page_Load(object sender, System.EventArgs e)
        {

            GetShopID("abc");
        }


If there is any other method to check the value in the sql table please
make this kind of fuction for me ..i'll be thankfull.

ashfaq

__________________
Baby Prgrammer

Dim bResult As Boolean = False
Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings( "conStr"))
Dim strSQL As String
Dim strTestValue As String
Dim objCommand As New OleDbCommand

objCommand.Connection = objConn
strSQL = String.Format("SELECT shopid FROM tblShopInformation WHERE (ShopName='{0}');", ShopName)
objCommand.CommandText = strSQL
objCommand.CommandType = CommandType.Text

objConn.Open()
strTestValue = CType(objCommand.ExecuteScalar, String)
objConn.Close()

If Not strTestValue Is Nothing Then
    If strTestValue = ShopName Then
        bResult = True

Sorry for the VB code.