ASP.NET

string str1 = "Select MAX(PID) From Product";
       OleDbCommand cmd = new OleDbCommand(str1, conn);
       conn.Open();
       string max= cmd.ExecuteScalar().ToString();
       if (max == "")
       {
           max = "PID" + 1;
       }
       else
       {
       int i= Convert.ToInt32(max) + 1;
       string s1=Convert.ToString(i);
       max = "PID" + s1;
       }
       conn.Close();
       string str = "Insert Into Product(ProductID,ProductName,ProductDescription,ProductPrice)Values('"+max+"','" + txtprdtname.Text + "','" + txtprdtdescrp.Text + "','" + txtprdtprice.Text + "')";
       cmd = new OleDbCommand(str, conn);
       conn.Open();
       cmd.ExecuteNonQuery();
       conn.Close();
       str = "Select * From Product";
       cmd = new OleDbCommand(str, conn);
       OleDbDataReader dr1 = null;
       conn.Open();
       dr1 = cmd.ExecuteReader();
       DropDownList2.DataSource = dr1;
       DropDownList2.DataTextField = "ProductID";
       DropDownList2.DataValueField = "ProductID";
       DropDownList2.DataBind();
       conn.Close();

Christian Graus wrote:

I assume no-one is paying for this code, if they are, you are a liar and a thief.

KhandelwalA wrote:

Is it possible to call onClientClick event on a specific condition at server side.....

sashidhar wrote:

If this is not ur answer sry