try
            {
                //myConn = new System.Data.Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;;Database=krisancust;User=root;Password=linuxhost;");
                myConn = new System.Data.Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=p50mysql99.secureserver.net;PORT=3306;Database=KrisanCust;User=KrisanCust;Password=Shayan03;OPTION=0;");
                myConn.Open();
                string sql1 = "select max(product_id)+1  from tbl_product;";
               
               
                System.Data.Odbc.OdbcCommand cmd = new                 System.Data.Odbc.OdbcCommand(sql1,myConn);
                Response.Write(sql1);
                MyReader = cmd.ExecuteReader();
                while (MyReader.Read())
                {
                    string thisrow = "";
                    for (int i = 0; i < MyReader.FieldCount; i++)
                        thisrow = MyReader.GetValue(i).ToString();
                    id = int.Parse(thisrow);
                    page_url = "subscribe.aspx?id=" + id.ToString();
                    Response.Write("Thisrow: "+thisrow);
                    Response.Write("ID: "+id);
                    Response.Write("page_url= "+ page_url);
                    TextBox5.Visible = true;
                    TextBox5.Enabled = false;
                    TextBox5.Text = id.ToString();
                    //Response.Write(TextBox5.Text);
                }
                string sql = "insert into tbl_product (product_id,product_url,whitepaper_url,manual_url,name,lifecycle,price,page_url) values" + "(" + id + "," + "'" + installerURL + "'" + "," + "'" + whitePaperURL + "'" + "," + "'" + manualURL + "'" + "," + "'" + name + "'" + "," + "'" + lifeTime + "'" + "," + "'" + price + "'" +","+"'"+page_url+"'"+ ");";
                System.Data.Odbc.OdbcCommand cmd1 = new System.Data.Odbc.OdbcCommand(sql, myConn);
                Response.Write(sql);
                MyReader = cmd1.ExecuteReader();
                MyReader.Close();
               
            }
            catch (Exception ee)
            {
                Response.Write("Mysql Error" + ee);
            }
            finally
            {
                if (MyReader != null && !MyReader.IsClosed)
                {
                    MyReader.Close();
                }
                if (myConn != null && myConn.State == System.Data.ConnectionState.Open)
                {
                    myConn.Close();
                }
            }
About Me
- Redwan
- Dhaka, Bangladesh
- I am B.S.C Engineer,CSE,SUST and Ex-Cadet of Mirzapur Cadet College.
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment