protected void btnConfirm_OTP_Click(object sender, EventArgs e) { try { String match_OTP = enter_OTP.Value; using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "SELECT * FROM VP_OTP WHERE EMAIL = :email AND OTP = :match_OTP AND VALIDITY=:YES"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("email", Session["Otp_email"]); command.Parameters.AddWithValue("match_OTP", match_OTP); command.Parameters.AddWithValue("YES", "YES"); using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); HttpContext.Current.Response.Redirect("ResetPassword.aspx", false); } else { lblError.Text = "Check Your OTP!"; } } } } catch (Exception ex) { } }
protected override ExeResEdm SqlCMD_DT(string cmdText, CommandType commandType, Func <DbDataAdapter, int> fun, params DbParameter[] parameters) { ExeResEdm dBResEdm = new ExeResEdm(); try { parameters = ParameterPrepare(parameters); using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr)) { conn.Open(); System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = cmdText; cmd.CommandType = commandType; if (parameters != null && parameters.Length > 0) { cmd.Parameters.AddRange((parameters)); } var da = new System.Data.OracleClient.OracleDataAdapter(cmd); var res = fun(da); dBResEdm.ExeNum = res; } } catch (Exception ex) { dBResEdm.Module = "SqlCMD_DT 方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } return(dBResEdm); }
protected override ExeResEdm SqlCMD(string sql, Func <DbCommand, object> fun, params DbParameter[] pms) { ExeResEdm dBResEdm = new ExeResEdm(); try { pms = ParameterPrepare(pms); using (System.Data.OracleClient.OracleConnection con = new System.Data.OracleClient.OracleConnection(connstr)) { using (System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, con)) { con.Open(); if (pms != null && pms.Length > 0) { cmd.Parameters.AddRange((pms)); } var res = fun(cmd); dBResEdm.ExeModel = res; return(dBResEdm); } } } catch (Exception ex) { dBResEdm.Module = "SqlCMD方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } }
/// <summary> /// 返回指定Sql语句的DbDataReader /// 方法关闭数据库连接 /// </summary> /// <param name="sqlstr">传入的Sql语句</param> /// <returns>DBDataReader对象</returns> public virtual DbDataReader GetDataReader(string sqlstr) { //程序不能返回抽象类,故用分数据访问分工来生成DataReader对象 if (databaseType == "Oracle") { System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); System.Data.OracleClient.OracleDataReader oraDr = cmd.ExecuteReader(); return(oraDr); } else if (databaseType == "SqlServer") { System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); System.Data.SqlClient.SqlDataReader sqlDr = cmd.ExecuteReader(); return(sqlDr); } else if (databaseType == "Sybase") { System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(); System.Data.OleDb.OleDbDataReader oleDr = cmd.ExecuteReader(); return(oleDr); } else { System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(); System.Data.Odbc.OdbcDataReader odbcDr = cmd.ExecuteReader(); return(odbcDr); } }
protected override ExeResEdm UpdateDtToDB(DataTable dtInfos, string strComFields = "*") { ExeResEdm dBResEdm = new ExeResEdm(); string strTableName = dtInfos.TableName; try { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr)) { conn.Open(); System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = GetColumnsNameSql(strTableName, strComFields); System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd); adapter.UpdateCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetUpdateCommand(); adapter.Update(dtInfos.GetChanges()); dtInfos.AcceptChanges(); } } catch (Exception ex) { dBResEdm.Module = "UpdateDtToDB方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } return(dBResEdm); }
protected override ExeResEdm ExecuteNonQueryFromSqlContianer(List <SqlContianer> ltSqls) { ExeResEdm dBResEdm = new ExeResEdm(); string curSQL = ""; try { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr)) { conn.Open(); System.Data.OracleClient.OracleTransaction oraOprate = conn.BeginTransaction(); try { System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.Transaction = oraOprate; foreach (SqlContianer objOraSqlCon in ltSqls) { cmd.CommandText = objOraSqlCon.strSqlTxt; curSQL = objOraSqlCon.strSqlTxt; cmd.Parameters.Clear(); cmd.Parameters.AddRange(objOraSqlCon.ltOraParams.ToArray()); int intRes = cmd.ExecuteNonQuery(); dBResEdm.ExeNum += intRes; if (objOraSqlCon.intExpectNums >= 0) { if (intRes != objOraSqlCon.intExpectNums) { throw new Exception("Update records not match the expect nums"); } } else if (objOraSqlCon.intExpectNums != Int16.MinValue) { if (intRes != 0 && intRes != objOraSqlCon.intExpectNums * -1) { throw new Exception("Update records not match the expect nums"); } } } oraOprate.Commit(); } catch (Exception ex) { oraOprate.Rollback(); dBResEdm.Module = "ExecuteNonQueryFromSqlContianer方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } } } catch (Exception ex) { dBResEdm.Module = "ExecuteNonQueryFromSqlContianer方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } return(dBResEdm); }
private string GetDDLForTable(string tableName, string owner) { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(strCon1)) { System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format("select SYS.DBMS_METADATA.GET_DDL('TABLE','{0}','{1}') from dual", tableName, owner); conn.Open(); object result = cmd.ExecuteScalar(); return(result.ToString()); } }
public void InsertRecord(string SQLStatement) { if (SQLStatement.Length > 0) { if (connOracle.State.ToString().Equals("Open")) { sqlCommandOracle = new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle); sqlCommandOracle.ExecuteScalar(); } } }
/// <summary> /// 执行sql /// </summary> /// <param name="strSql"></param> /// <param name="strDataSet"></param> /// <param name="strXSLFileName"></param> /// <param name="SettingXml"></param> /// <returns></returns> public int ExecQuery(string strSql, ref string strDataSet, string strXSLFileName, string SettingXml) { System.Data.OracleClient.OracleConnection con = new System.Data.OracleClient.OracleConnection(strConn); System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(); command.Connection = con; command.CommandType = System.Data.CommandType.Text; command.Parameters.Clear(); command.CommandText = strSql + ""; try { System.Data.OracleClient.OracleDataReader TempReader1; TempReader1 = command.ExecuteReader(); XmlDocument doc = new XmlDocument(); XmlNode root; XmlElement node, row; doc.AppendChild(doc.CreateXmlDeclaration("1.0", "GB2312", "")); if (strXSLFileName != null && strXSLFileName != "") { string PI = "type='text/xsl' href='" + strXSLFileName + "'"; System.Xml.XmlProcessingInstruction xmlProcessingInstruction = doc.CreateProcessingInstruction("xml-stylesheet", PI); doc.AppendChild(xmlProcessingInstruction); } string Header = doc.OuterXml + "\n<DataSet>\n" + SettingXml; doc = new XmlDocument(); root = doc.CreateElement("Table"); doc.AppendChild(root); while (TempReader1.Read()) { row = doc.CreateElement("Row"); for (int i = 0; i < TempReader1.FieldCount; i++) { node = doc.CreateElement("Column"); node.SetAttribute("Name", TempReader1.GetName(i).ToString()); node.InnerText = TempReader1[i].ToString() + ""; row.AppendChild(node); } root.AppendChild(row); } strDataSet = Header + "\n" + doc.OuterXml + "\n</DataSet>"; TempReader1.Close(); } catch (Exception ex) { this.Err = "执行语句产生错误!" + ex.Message; this.ErrorException = ex.InnerException + "+ " + ex.Source; this.ErrCode = strSql; this.WriteErr(); return(-1); } WriteDebug("执行查询sql语句!" + strSql); return(0); }
//Value which you want to pass public void btnGet_OTP_Click(object sender, EventArgs e) { try { // to save the Email_id and OTP in database String email = send_otp.Value; Session["Otp_email"] = email; string strNewOtp = GenerateOtp().ToString(); using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "update VP_OTP SET VALIDITY =:NO WHERE EMAIL = :email AND VALIDITY= :YES "; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("email", email); command.Parameters.AddWithValue("YES", "YES"); command.Parameters.AddWithValue("NO", "NO"); int rowsUpdated = command.ExecuteNonQuery(); string QueryString = "insert into VP_OTP (EMAIL,OTP, VALIDITY) values (:email,:OTP,:VALIDITY)"; System.Data.OracleClient.OracleCommand Command = new System.Data.OracleClient.OracleCommand(QueryString, connection); Command.Parameters.AddWithValue("email", email); Command.Parameters.AddWithValue("OTP", strNewOtp); Command.Parameters.AddWithValue("VALIDITY", "YES"); int RowsUpdated = Command.ExecuteNonQuery(); HttpContext.Current.Response.Redirect("OTP.aspx", false); } // to send the random OTP in email // MailMessage msg = new MailMessage(); // msg.From = new MailAddress("*****@*****.**"); // msg.To.Add(email); // msg.Body = "Dear " + email + ", <br/><br/> Your OTP is " + strNewOtp + " for Vendor Registration for RCF. <br/> Kindly ignore this email if already submitted. <br/><br/>This is system generated mail.<br/>Please do not reply.<br/><br/>Regards,<br/>RCF Ltd."; //Response.Write(msg.Body); // msg.IsBodyHtml = true; // msg.Subject = "OTP for Verification for Grievance Monitoring System"; /// SmtpClient smt = new SmtpClient("webmail.rcfltd.com"); // smt.Port = 25; // smt.Credentials = new NetworkCredential("*****@*****.**", "asdfgh@123"); //smt.EnableSsl = true; // smt.Send(msg); //string script = "<script>alert('Mail Sent Successfully');self.close();</script>"; //this.ClientScript.RegisterClientScriptBlock(this.GetType(), "sendMail", script); } catch (Exception ex) { } }
/// <summary> /// There are no comments for COMP_BIOSUM_VOLS_BY_UPDATE in the schema. /// </summary> public virtual void COMP_BIOSUM_VOLS_BY_UPDATE() { m_intError = 0; m_strError = ""; bool bCloseConnection = false; if (_OracleADO.ConnectionDisposed || _OracleADO.m_Connection == null || (_OracleADO.m_Connection != null && _OracleADO.m_Connection.State != ConnectionState.Open)) { OracleConnect(); bCloseConnection = true; } if (_OracleADO.m_intError == 0) { try { //using (Oracle.DataAccess.Client.OracleCommand command = new Oracle.DataAccess.Client.OracleCommand()) using (System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand()) { command.Connection = _OracleADO.m_Connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = FCSOracle.FCSSchema + ".COMPUTE_BIOSUM_VOLUMES_PKG.COMP_BIOSUM_VOLS_BY_UPDATE"; command.ExecuteNonQuery(); } } catch (Exception e) { m_intError = -1; m_strError = e.Message; if (DisplayErrors) { MessageBox.Show("!!Error!! \n" + "Module - FCSEntities:COMP_BIOSUM_VOLS_BY_UPDATE \n" + "Err Msg - " + e.Message.ToString().Trim(), "BIOSUM", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation); } } finally { if (bCloseConnection) { //close connection and release resources OracleADO.CloseAndDisposeConnection(_OracleADO.m_Connection, false); } } } }
//Connection to Oracle database public System.Data.DataTable OracOLEds(string SqlString, string constring, int rowlimit) { DataTable dt = new DataTable(); if (rowlimit > 0) { try { using (System.Data.OracleClient.OracleConnection OracConnect = new System.Data.OracleClient.OracleConnection(constring)) { OracConnect.Open(); System.Data.OracleClient.OracleCommand OraCmd = new System.Data.OracleClient.OracleCommand(SqlString, OracConnect); System.Data.OracleClient.OracleDataReader Oraxreader = OraCmd.ExecuteReader(); DataSet ds = new DataSet(); ds.Load(Oraxreader, LoadOption.OverwriteChanges, "Result"); var ddt = ds.Tables[0].AsEnumerable().Take(rowlimit); dt = ddt.CopyToDataTable <DataRow>(); Oraxreader.Close(); OracConnect.Close(); } } catch (Exception exOrac) { var ex1 = exOrac.Message; } } else { try { using (System.Data.OracleClient.OracleConnection OracConnect = new System.Data.OracleClient.OracleConnection(constring)) { OracConnect.Open(); System.Data.OracleClient.OracleCommand OraCmd = new System.Data.OracleClient.OracleCommand(SqlString, OracConnect); System.Data.OracleClient.OracleDataReader Oraxreader = OraCmd.ExecuteReader(); DataSet ds = new DataSet(); ds.Load(Oraxreader, LoadOption.OverwriteChanges, "Result"); dt = ds.Tables[0]; Oraxreader.Close(); OracConnect.Close(); } } catch (Exception exOrac) { var ex1 = exOrac.Message; } } return(dt); }
protected void GrdViewDocs_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Select") { GridDataItem dataitem = e.Item as GridDataItem; //DataTable dtcon = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now); //grdRequest.DataSource = dtcon; //grdRequest.DataBind(); // int idx = dataitem["REQUEST_ID"].Text; // Label lbl = dataitem["ID"].Text; System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(ConfigurationManager.ConnectionStrings["CGConnectionString"].ToString()); System.Data.OracleClient.OracleCommand myCommand = new System.Data.OracleClient.OracleCommand("SELECT * FROM wf_cm_docs_jobwise_blob WHERE ID = '" + dataitem["ID"].Text + "'", conn); conn.Open(); System.Data.OracleClient.OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default); try { while (myReader.Read()) { System.Data.OracleClient.OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("DOCUMENT")); if (!myLob.IsNull) { string FN = myReader.GetString(myReader.GetOrdinal("DOCUMENT_NAME")); //Use buffer to transfer data byte[] b = new byte[myLob.Length]; //Read data from database myLob.Read(b, 0, (int)myLob.Length); Response.AddHeader("content-disposition", "attachment;filename=" + FN); Response.ContentType = "application/octectstream"; Response.BinaryWrite(b); Response.End(); } } } finally { myReader.Close(); conn.Close(); } } }
private void DisplayDataForQuery() { dataGridView1.DataSource = null; if (queryBuilder.MetadataProvider != null && queryBuilder.MetadataProvider.Connected) { if (queryBuilder.MetadataProvider is OracleMetadataProvider) { System.Data.OracleClient.OracleCommand command = (System.Data.OracleClient.OracleCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); command.CommandText = queryBuilder.SQL; // handle the query parameters if (queryBuilder.Parameters.Count > 0) { for (int i = 0; i < queryBuilder.Parameters.Count; i++) { if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) { System.Data.OracleClient.OracleParameter parameter = new System.Data.OracleClient.OracleParameter(); parameter.ParameterName = queryBuilder.Parameters[i].FullName; parameter.DbType = queryBuilder.Parameters[i].DataType; command.Parameters.Add(parameter); } } using (QueryParametersForm qpf = new QueryParametersForm(command)) { qpf.ShowDialog(); } } System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(command); DataSet dataset = new DataSet(); try { adapter.Fill(dataset, "QueryResult"); dataGridView1.DataSource = dataset.Tables["QueryResult"]; } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL query error"); } } //end oracle (ms) } //end check if connected } //end method
protected void btnSignUp_Click(object sender, EventArgs e) { try { String username = user_name.Value; String email = user_email.Value; String password = user_password.Value; using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "SELECT * FROM VP_LOGIN WHERE EMAIL_ID = :useremail"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("useremail", email); using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); lblError_email.Text = "Email already exist!"; } else { string QueryString = "insert into VP_LOGIN (NAME,EMAIL_ID,PASSWORD) values (:username,:email,:password)"; System.Data.OracleClient.OracleCommand Command = new System.Data.OracleClient.OracleCommand(QueryString, connection); Command.Parameters.AddWithValue("username", username); Command.Parameters.AddWithValue("email", email); Command.Parameters.AddWithValue("password", password); int rowsUpdated = Command.ExecuteNonQuery(); if (rowsUpdated == 0) { Response.Write("Record not inserted"); } else { HttpContext.Current.Response.Redirect("Login.aspx", false); } } } } } catch (Exception ex) { lblError.Text = "Something Went Wrong!"; } }
public void InsertCLOB(string SQLStatement, string str) { if (SQLStatement.Length > 0) { if (connOracle.State.ToString().Equals("Open")) { byte[] newvalue = System.Text.Encoding.Unicode.GetBytes(str); sqlCommandOracle = new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle); rstOracle = sqlCommandOracle.ExecuteReader(); rstOracle.Read(); txn = connOracle.BeginTransaction(); clob = rstOracle.GetOracleLob(0); clob.Write(newvalue, 0, newvalue.Length); txn.Commit(); } } }
private TB_Dzsrcdel GetDzsrcdel(string sono, int entryid, System.Data.OracleClient.OracleCommand cmd) { TB_Dzsrcdel model = new TB_Dzsrcdel() { Fjde_sono = sono, FsoentryID = entryid }; string sql = DbUtils.GetSqlWithObject(model, Operate.Select); sql += "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID"; cmd.CommandText = sql; cmd.Parameters.AddWithValue("Fjde_sono", model.Fjde_sono); cmd.Parameters.AddWithValue("FsoentryID", model.FsoentryID); System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd); System.Data.DataTable table = new System.Data.DataTable(); da.Fill(table); if (table.Rows.Count == 1) { var t = model.GetType(); var pis = t.GetProperties().ToList(); var row = table.Rows[0]; pis.ForEach(p => { var value = row[p.Name]; if (value != null && DBNull.Value != value) { p.SetValue(model, value, null); } }); return(model); } if (table.Rows.Count > 1) { throw new Exception(string.Format("TB_DZsrcdel表中存在多条符合条件【Fjde_sono={0} AND FsoentryID={1}】的记录", sono, entryid)); } return(null); }
protected void btnResetPassword_Click(object sender, EventArgs e) { try { String newpassword = New_password.Value; using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "update VP_LOGIN SET PASSWORD =:New_password WHERE EMAIL_ID = :email"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("email", Session["Otp_email"]); command.Parameters.AddWithValue("New_password", newpassword); int rowsUpdated = command.ExecuteNonQuery(); Response.Redirect("Login.aspx"); } } catch (Exception ex) { Response.Write("pm"); } }
protected void DataList2_SelectedIndexChanged(object sender, EventArgs e) { int idx = DataList2.SelectedIndex; Label lbl = (Label)DataList2.Items[idx].FindControl("Label2"); System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(ConfigurationManager.ConnectionStrings["CGConnectionString"].ToString()); System.Data.OracleClient.OracleCommand myCommand = new System.Data.OracleClient.OracleCommand("SELECT * FROM wf_it_images WHERE ID = '" + lbl.Text + "'", conn); conn.Open(); System.Data.OracleClient.OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default); try { while (myReader.Read()) { System.Data.OracleClient.OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("IMAGE")); if (!myLob.IsNull) { string FN = myReader.GetString(myReader.GetOrdinal("IMAGE_NAME")); //Use buffer to transfer data byte[] b = new byte[myLob.Length]; //Read data from database myLob.Read(b, 0, (int)myLob.Length); Response.AddHeader("content-disposition", "attachment;filename=" + FN); Response.ContentType = "application/octectstream"; Response.BinaryWrite(b); Response.End(); } } } finally { myReader.Close(); conn.Close(); } }
// https://social.msdn.microsoft.com/Forums/en-US/dc1b053d-f0d5-48f8-ad82-fb6d96d27f80/how-to-insert-or-update-blob-data-for-sqlserver-based-on-buffersize?forum=adodotnetdataproviders public void WriteLargeFileChunckedOracle(string path) { byte[] buffer = new byte[1024]; using (System.Data.OracleClient.OracleCommand cmd = null) { using (System.Data.OracleClient.OracleDataReader dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { // this code segment works well for Oracle database System.Data.OracleClient.OracleLob lob = dataReader.GetOracleLob(1); using (System.IO.Stream fileStream = System.IO.File.OpenRead(path)) { lob.SetLength(0); int readBytes = 0; while ((readBytes = fileStream.Read(buffer, 0, buffer.Length)) > 0) { lob.Write(buffer, 0, readBytes); } // Whend } // End Using fileStream } // End Using dataReader } // End Using cmd } // End Sub WriteLargeFileChunckedOracle
protected void btnLogin_Click(object sender, EventArgs e) { try { String useremail = txtemail.Value; Session["Login_email"] = useremail; String password = txtpassword.Value; using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "SELECT * FROM VP_LOGIN WHERE EMAIL_ID = :useremail AND PASSWORD = :password"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("useremail", useremail); command.Parameters.AddWithValue("password", password); using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); /*Session["username"] = Convert.ToString(reader["EMAIL_ID"]); * Session["name"] = Convert.ToString(reader["NAME"]); * Session["contact"] = Convert.ToString(reader["CONTACT"]);*/ HttpContext.Current.Response.Redirect("VendorRegistration.aspx", false); } else { lblError.Text = "Check Your User Name and Password!"; } } } } catch (Exception ex) { lblError.Text = "Something Went Wrong!"; } }
//total marks //procedure private void button1_Click(object sender, EventArgs e) { try { String oradb = "Data Source=DESKTOP-K6AG53J;Persist Security Info=True;User ID=system;Password=student;"; System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(oradb); //conn.Open(); System.Data.OracleClient.OracleCommand comm = new System.Data.OracleClient.OracleCommand(); comm.Connection = conn; comm.CommandText = "tot_marks"; comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add("s_id", System.Data.OracleClient.OracleType.Number).Value = s1; comm.Parameters.Add("co_id", System.Data.OracleClient.OracleType.Number).Value = comboBox1.Text; comm.Parameters.Add("cout", System.Data.OracleClient.OracleType.Number).Direction = ParameterDirection.Output; conn.Open(); comm.ExecuteNonQuery(); textBox1.Text = (comm.Parameters["cout"].Value).ToString(); conn.Close(); } catch (IndexOutOfRangeException ex) { MessageBox.Show("Invalid Details!"); } }
public DataResult Forder_delivery(List <Forder_delivery_Input> input) { string sql = ""; string where = "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID"; int count = 0; DataResult result = new DataResult() { errCode = 0 }; System.Data.OracleClient.OracleCommand cmd = null; try { if (input == null || input.Count == 0) { throw new Exception("传入参数不能为空"); } TB_Dzsrcdel model = null; cmd = DbUtils.GetCommand(model, Operate.Insert); input.ForEach(p => { DataChecker.CheckObj(p); //根据Fjde_sono和FsoentryID获取底表记录FID var manuscript = GetManuscript_By_SonoAnd_EntryID(p.Fjde_sono, p.FsoentryID, cmd); model = GetDzsrcdel(p.Fjde_sono, p.FsoentryID, cmd); Operate insertOrupdate = Operate.Update; if (model == null) { insertOrupdate = Operate.Insert; model = new TB_Dzsrcdel(); model.FmanuscriptID = manuscript.FID; model.Fjde_sono = p.Fjde_sono; model.FsoentryID = p.FsoentryID; model.Fsrcbillno = p.Fsrcbillno; model.fsrcdelno = p.Fsrcdelno; model.fdeldate = p.Fdeldate; model.Fproductcode = p.Fproductcode; } model.fdelqty = p.Fdelqty; model.Fcasecode = p.Fcasecode; model.Fisdelover = p.Fisdelover; model.Fbuttstatus3 = p.Fbuttstatus3; model.Fremark1 = p.Fremark2; model.FTime = DateTime.Now; //插入或更新子表记录 sql = DbUtils.GetSqlWithObject(model, insertOrupdate); sql = insertOrupdate == Operate.Update ? sql += where:sql; cmd.CommandText = sql; DbUtils.GetParams(model, cmd); count += cmd.ExecuteNonQuery(); }); //按销售单号,行号进行汇总求和发货数量 var group = input.GroupBy(p => new { p.Fjde_sono, p.FsoentryID }) .Select(p => new { Fjde_sono = p.Key.Fjde_sono, FsoentryID = p.Key.FsoentryID, Fdelqty_total = p.Sum(item => item.Fdelqty) }) .ToList(); //更新WHERE语句,根据销售单号和行号更新发货数量 where = "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID"; group.ForEach(p => { // 更新底表发货数量 sql = string.Format("UPDATE TB_DZmanuscript SET Fdelqty_total={0} WHERE Fjde_sono={1} AND FsoentryID={2}", p.Fdelqty_total, p.Fjde_sono, p.FsoentryID); cmd = DbUtils.GetCommand(new TB_DZmanuscript(), Operate.Update); cmd.CommandText = sql; count += cmd.ExecuteNonQuery(); }); cmd.Transaction.Commit(); cmd.Connection.Close(); if (count == 0) { throw new Exception("同步失败,插入了0条数据"); } return(result); } catch (Exception ex) { LogHelper.WriteLog(ex); LogHelper.WriteLog("Input: " + JsonHelper.ToJson(input)); LogHelper.WriteLog("SQL: " + sql); result.errMsg = ex.Message; result.errCode = -1; if (cmd != null) { cmd.Transaction.Rollback(); cmd.Connection.Close(); } return(result); } }
public void RunSQl(object dbmodel) { DbModel model = (DbModel)dbmodel; if (string.IsNullOrEmpty(model.Conn)) return; string sql = this.txtsql.Text.Trim(); string conn = model.Conn; RichTextBox ctl = null; if (model.TextBoxName == "rtxtCtosut") { ctl = this.rtxtCtosut; } else { ctl = this.rtxtCtosdemo; } Stopwatch sw = Stopwatch.StartNew(); sw.Restart(); StringBuilder sb = new StringBuilder(); DataSet ds = new DataSet(); string dbname = null; try { if (model.isOdp) { using (OracleConnection oraconn = new OracleConnection(conn)) { oraconn.Open(); dbname = oraconn.ServiceName; OracleCommand cmd = new OracleCommand(sql, oraconn); OracleDataAdapter oda = new OracleDataAdapter(cmd); int x = oda.Fill(ds); sw.Stop(); } } else { using (System.Data.OracleClient.OracleConnection oraconn = new System.Data.OracleClient.OracleConnection(conn)) { oraconn.Open(); dbname = oraconn.DataSource; System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, oraconn); System.Data.OracleClient.OracleDataAdapter oda = new System.Data.OracleClient.OracleDataAdapter(cmd); int x = oda.Fill(ds); sw.Stop(); } } DataTable dt = ds.Tables[0]; sb.AppendFormat("#{3}, server: {4}, Return {0} rows with {1} columns, cost: {2}ms", dt.Rows.Count, dt.Columns.Count, sw.ElapsedMilliseconds, Thread.CurrentThread.ManagedThreadId, dbname); if (dt.Rows.Count == 1) { sb.AppendLine(); foreach (DataColumn dc in dt.Columns) { sb.AppendFormat("Column {0}; Type {1}; Value {2};", dc.ColumnName.PadLeft(20), dc.DataType.ToString().PadLeft(20), dt.Rows[0][dc].ToString().PadLeft(20)); sb.AppendLine(); } } } catch (Exception ex) { sb.AppendFormat("Error: {0}" , ex.Message); } sb.AppendLine(); if (this.rtxtCtosut.InvokeRequired) { Invoke(new SetContrlValueDelegate(SetTextboxValue), ctl, sb.ToString()); } else { ctl.Text += sb.ToString(); SetState(); } }
protected override ExeResEdm GetDataSets(List <SqlContianer> ltSqls) { ExeResEdm dBResEdm = new ExeResEdm(); DataSet ds = new DataSet(); try { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr)) { conn.Open(); System.Data.OracleClient.OracleTransaction tsOprate = conn.BeginTransaction(); try { System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.Transaction = tsOprate; List <string> tbNames = new List <string>(); foreach (var objOraSqlCon in ltSqls) { DataTable dt = new DataTable(); if (!string.IsNullOrEmpty(objOraSqlCon.tableName)) { dt.TableName = objOraSqlCon.tableName; } else { string tb = GetTableNameFromSelectSql(objOraSqlCon.strSqlTxt); if (!string.IsNullOrEmpty(tb)) { dt.TableName = tb; } } if (tbNames.Contains(dt.TableName)) { dt.TableName = dt.TableName + "_" + (tbNames.Count() + 1); } tbNames.Add(dt.TableName); cmd.CommandText = objOraSqlCon.strSqlTxt; cmd.Parameters.Clear(); if (objOraSqlCon.ltOraParams != null && objOraSqlCon.ltOraParams.Count > 0) { cmd.Parameters.AddRange(objOraSqlCon.ltOraParams.ToArray()); } System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd); adapter.Fill(dt); ds.Tables.Add(dt); } tsOprate.Commit(); } catch (Exception ex) { tsOprate.Rollback(); dBResEdm.Module = "GetDataSets方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } } } catch (Exception ex) { dBResEdm.Module = "GetDataSets方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } dBResEdm.ExeModel = ds; return(dBResEdm); }
public ComCommand(string cmdText, ComConnection con, ComTransaction trans) { _cmd = new System.Data.OracleClient.OracleCommand(cmdText, con.Connection, trans.Transaction); }
protected override ExeResEdm UpdateDsToDB(DataSet dsTables, Dictionary <string, string> dicDtMainFields = null) { ExeResEdm dBResEdm = new ExeResEdm(); int n = 0; try { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr)) { conn.Open(); System.Data.OracleClient.OracleTransaction tsOprate = conn.BeginTransaction(); try { System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.Transaction = tsOprate; foreach (DataTable dtTemp in dsTables.Tables) { string strComFields = "*"; if (dicDtMainFields != null && dicDtMainFields.Count > 0 && dicDtMainFields.ContainsKey(dtTemp.TableName)) { strComFields = !string.IsNullOrEmpty(dicDtMainFields[dtTemp.TableName]) ? dicDtMainFields[dtTemp.TableName]: strComFields; } cmd.CommandText = GetColumnsNameSql(dtTemp.TableName, strComFields); System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd); var dtChanges = dtTemp.GetChanges(); adapter.FillSchema(dtChanges, SchemaType.Mapped); //new added if (dtChanges != null) //是添加或更新 { adapter.UpdateCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetUpdateCommand(); n += adapter.Update(dtChanges); dtTemp.AcceptChanges(); } else //是删除 { adapter.DeleteCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetDeleteCommand(); for (int i = dtTemp.Rows.Count - 1; i >= 0; i--) { dtTemp.Rows[i].Delete(); } n += adapter.Update(dtTemp); } } dsTables.AcceptChanges(); tsOprate.Commit(); } catch (Exception ex) { tsOprate.Rollback(); dBResEdm.Module = "UpdateDsToDB方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } } } catch (Exception ex) { dBResEdm.Module = "UpdateDsToDB方法"; dBResEdm.ExBody = ex; dBResEdm.ErrCode = 1; return(dBResEdm); } dBResEdm.ExeNum = n; return(dBResEdm); }
private void DisplayDataForQuery() { //AppGlobals.AppMessages.DisplayAlertMessage("DisplayDataForQuery"); dataGridView1.DataSource = null; if (queryBuilder.MetadataProvider != null && queryBuilder.MetadataProvider.Connected) { if (queryBuilder.MetadataProvider is MSSQLMetadataProvider) { SqlCommand command = (SqlCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); command.CommandText = queryBuilder.SQL; // handle the query parameters if (queryBuilder.Parameters.Count > 0) { for (int i = 0; i < queryBuilder.Parameters.Count; i++) { if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) { SqlParameter parameter = new SqlParameter(); parameter.ParameterName = queryBuilder.Parameters[i].FullName; parameter.DbType = queryBuilder.Parameters[i].DataType; command.Parameters.Add(parameter); } } using (QueryParametersForm qpf = new QueryParametersForm(command)) { qpf.ShowDialog(); } } SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); try { adapter.Fill(dataset, "QueryResult"); dataGridView1.DataSource = dataset.Tables["QueryResult"]; } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL query error"); } }//end sql server //if (queryBuilder.MetadataProvider is MSSQLCEMetadataProvider) //{ // SqlCeCommand command = (SqlCeCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); // command.CommandText = queryBuilder.SQL; // // handle the query parameters // if (queryBuilder.Parameters.Count > 0) // { // for (int i = 0; i < queryBuilder.Parameters.Count; i++) // { // if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) // { // SqlCeParameter parameter = new SqlCeParameter(); // parameter.ParameterName = queryBuilder.Parameters[i].FullName; // parameter.DbType = queryBuilder.Parameters[i].DataType; // command.Parameters.Add(parameter); // } // } // using (QueryParametersForm qpf = new QueryParametersForm(command)) // { // qpf.ShowDialog(); // } // } // SqlCeDataAdapter adapter = new SqlCeDataAdapter(command); // DataSet dataset = new DataSet(); // try // { // adapter.Fill(dataset, "QueryResult"); // dataGridView1.DataSource = dataset.Tables["QueryResult"]; // } // catch (Exception ex) // { // MessageBox.Show(ex.Message, "SQL query error"); // } //}//end sql server ce if (queryBuilder.MetadataProvider is OLEDBMetadataProvider) { //AppGlobals.AppMessages.DisplayAlertMessage("for OLEDBMetadataProvider"); OleDbCommand command = (OleDbCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); command.CommandText = queryBuilder.SQL; // handle the query parameters if (queryBuilder.Parameters.Count > 0) { for (int i = 0; i < queryBuilder.Parameters.Count; i++) { if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) { OleDbParameter parameter = new OleDbParameter(); parameter.ParameterName = queryBuilder.Parameters[i].FullName; parameter.DbType = queryBuilder.Parameters[i].DataType; command.Parameters.Add(parameter); } } using (QueryParametersForm qpf = new QueryParametersForm(command)) { qpf.ShowDialog(); } } OleDbDataAdapter adapter = new OleDbDataAdapter(command); DataSet dataset = new DataSet(); try { adapter.Fill(dataset, "QueryResult"); dataGridView1.DataSource = dataset.Tables["QueryResult"]; } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL query error"); } //AppGlobals.AppMessages.DisplayAlertMessage("end for OLEDBMetadataProvider"); }//end ole schemaRoot if (queryBuilder.MetadataProvider is ODBCMetadataProvider) { OdbcCommand command = (OdbcCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); command.CommandText = queryBuilder.SQL; // handle the query parameters if (queryBuilder.Parameters.Count > 0) { for (int i = 0; i < queryBuilder.Parameters.Count; i++) { if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) { OdbcParameter parameter = new OdbcParameter(); parameter.ParameterName = queryBuilder.Parameters[i].FullName; parameter.DbType = queryBuilder.Parameters[i].DataType; command.Parameters.Add(parameter); } } using (QueryParametersForm qpf = new QueryParametersForm(command)) { qpf.ShowDialog(); } } OdbcDataAdapter adapter = new OdbcDataAdapter(command); DataSet dataset = new DataSet(); try { adapter.Fill(dataset, "QueryResult"); dataGridView1.DataSource = dataset.Tables["QueryResult"]; } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL query error"); } }//end odbc if (queryBuilder.MetadataProvider is OracleMetadataProvider) { System.Data.OracleClient.OracleCommand command = (System.Data.OracleClient.OracleCommand)queryBuilder.MetadataProvider.Connection.CreateCommand(); command.CommandText = queryBuilder.SQL; // handle the query parameters if (queryBuilder.Parameters.Count > 0) { for (int i = 0; i < queryBuilder.Parameters.Count; i++) { if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName)) { System.Data.OracleClient.OracleParameter parameter = new System.Data.OracleClient.OracleParameter(); parameter.ParameterName = queryBuilder.Parameters[i].FullName; parameter.DbType = queryBuilder.Parameters[i].DataType; command.Parameters.Add(parameter); } } using (QueryParametersForm qpf = new QueryParametersForm(command)) { qpf.ShowDialog(); } } System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(command); DataSet dataset = new DataSet(); try { adapter.Fill(dataset, "QueryResult"); dataGridView1.DataSource = dataset.Tables["QueryResult"]; } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL query error"); } } //end oracle (ms) } //end check if connected } //end method
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("ÕýÔÚ¼ìË÷"); Application.DoEvents(); Neusoft.FrameWork.Management.Connection.Instance = new System.Data.OracleClient.OracleConnection(Neusoft.FrameWork.Management.Connection.Instance.ConnectionString); Neusoft.FrameWork.Management.Connection.Instance.Open(); Neusoft.FrameWork.Management.DataBaseManger m = new Neusoft.FrameWork.Management.DataBaseManger(); DataSet ds = new DataSet(); if (m.ExecQuery("select id,name from com_sql", ref ds) == -1) { Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(m.Err); return; } //Neusoft.FrameWork.Management.Connection.Instance.Close(); //Neusoft.FrameWork.Management.Connection.Instance = new Oracle.DataAccess.Client.OracleConnection(Neusoft.FrameWork.Management.Connection.Instance.ConnectionString); //Neusoft.FrameWork.Management.Connection.Instance.Open(); Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); m.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); //t.BeginTransaction(); //m.SetTrans(t.Trans); foreach (DataRow dr in ds.Tables[0].Rows) { string s = "update com_sql set name1 = :a where id='" + dr[0].ToString() + "'"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(s); command.Connection = Neusoft.FrameWork.Management.Connection.Instance as System.Data.OracleClient.OracleConnection; command.CommandText = s; command.CommandType = System.Data.CommandType.Text; command.Transaction = Neusoft.FrameWork.Management.PublicTrans.Trans as System.Data.OracleClient.OracleTransaction; System.Data.OracleClient.OracleParameter param = command.Parameters.Add("a", System.Data.OracleClient.OracleType.Clob); param.Direction = System.Data.ParameterDirection.Input; // Assign Byte Array to Oracle Parameter param.Value = dr[1].ToString(); // Step 5 // Execute the Anonymous PL/SQL Block try { if (command.ExecuteNonQuery() == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(m.Err); return; } } catch (Exception ex) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(ex.Message); return; } //if (m.InputBlob(s, b)== -1) //{ // t.RollBack(); // Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); // MessageBox.Show(m.Err); // return; //} Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(dr[0].ToString() + "\n" + dr[1].ToString()); Application.DoEvents(); } Neusoft.FrameWork.Management.PublicTrans.Commit(); Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show("³É¹¦£¡"); }
private TB_DZmanuscript GetManuscript_By_SonoAnd_EntryID(string sono, int entryid, System.Data.OracleClient.OracleCommand cmd) { TB_DZmanuscript model = new TB_DZmanuscript() { Fjde_sono = sono, FsoentryID = entryid }; string sql = DbUtils.GetSqlWithObject(model, Operate.Select); sql += "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID"; cmd.CommandText = sql; DbUtils.GetParams(model, cmd); System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd); System.Data.DataTable table = new System.Data.DataTable(); da.Fill(table); if (table.Rows.Count == 1) { var t = model.GetType(); var pis = t.GetProperties().ToList(); var row = table.Rows[0]; model.FID = row["FID"].ToString(); return(model); } if (table.Rows.Count > 1) { throw new Exception(string.Format("{2}表中存在多条符合条件【Fjde_sono={0} AND FsoentryID={1}】的记录", sono, entryid, table.TableName)); } throw new Exception("未找到相关的底表记录"); }
protected void btnFormSubmit_Click(object sender, EventArgs e) { try { String selectp = Request.Form.Get("title"); String Fname = fname.Value; String Mname = mname.Value; String Lname = lname.Value; String Username = selectp + " " + Fname + " " + Mname + " " + Lname; String House_no = house_no.Value; String Street = street.Value; String City_code = city_code.Value; String City = city.Value; String State = state.Value; String PIN = pin.Value; String Country = country.Value; String Address = House_no + ", " + Street + ", " + City_code + ", " + City + ", " + State + ", " + PIN + ", " + Country; String Contact_person = contact_person.Value; String Telephone_no = telephone_no.Value; String Mobile_no = mobile_no.Value; String Fax = fax.Value; //String Email = email_id.Value; String Pan = pan_no.Value; String Gst_no = gst_no.Value; String Industry = industry.Value; String Micro = micro.Value; using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST)) { connection.Open(); string queryString = "insert into VP_REGISTRATION (NAME, ADDRESS, CONTACT_PERSON,EMAIL,FAX, GST_NO, INDUSTRY, MICRO_OR_SSI_STATUS, MOBILE_NO, PAN_NO, TELEPHONE_NO_EXT) values (:username , :Address, :C_person, :Email, :Fax, :Gst, :Industry, :Micro, :Mob_no, :Pan_no, :Telephone_no)"; System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection); command.Parameters.AddWithValue("username", Username); command.Parameters.AddWithValue("Address", Address); command.Parameters.AddWithValue("C_person", Contact_person); command.Parameters.AddWithValue("Email", Session["Login_email"]); command.Parameters.AddWithValue("Fax", Fax); command.Parameters.AddWithValue("Gst", Gst_no); command.Parameters.AddWithValue("Industry", Industry); command.Parameters.AddWithValue("Micro", Micro); command.Parameters.AddWithValue("Mob_no", Mobile_no); command.Parameters.AddWithValue("Pan_no", Pan); command.Parameters.AddWithValue("Telephone_no", Telephone_no); int rowsUpdated = command.ExecuteNonQuery(); if (rowsUpdated == 0) { Response.Write("Record not inserted"); } else { HttpContext.Current.Response.Redirect("Login.aspx", false); } } } catch (Exception ex) { lblError.Text = "Something Went Wrong!"; } }