C#

SqlConnection con = new SqlConnection("your connection string");
SqlDataReader dr;
string str = "your query";
SqlCommand cmd = new SqlCommand(str, con);
dr = cmd.ExecuteReader();
if (dr.HasRows== false)
{
    //insert new row
}

odbcConnection con = new odbcConnection("your connection string");
odbcDataReader dr;
string str = "your query";
odbcCommand cmd = new odbcCommand(str, con);
dr = cmd.ExecuteReader();
if (dr.HasRows== false)
{
    //insert new row
}

if (dr.HasRows == false)
{
    //insert new row
}

if (!dr.Read())
{
    MessageBox.Show("No records");
}
else
{
    MessageBox.Show("Records Found");
}

mjawadkhatri wrote:

No I not tried to implement any thing.

switch(button.parent.tag){
// cases according to the tag
}

public event EventHandler OkButtonClick;

 protected void OnOKButtonClick(EventArgs e) {
   if (OkButtonClick != null) {
     OkButtonClick(this, e);
   }
 }

 protected void ClickOKButton(object sender, EventArgs e) {
   OnOKButtonClick(e);
 }

YourUserControl.OKButtonclick += new EventHandler(SomeMethod);

SqlCommand cmd = new  SqlCommand();

321Markus123 wrote:

Wrox - Professional C# 2008