About Me

My photo
Dhaka, Bangladesh
I am B.S.C Engineer,CSE,SUST and Ex-Cadet of Mirzapur Cadet College.

Saturday, July 5, 2008

ASP/MY-SQL Connection

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();
}
}

No comments: