internal static int GetApplicationID(OleDbConnection connection, string applicationName, bool createIfNeeded) { OleDbCommand lookupCommand = new OleDbCommand("SELECT ApplicationId FROM aspnet_Applications WHERE ApplicationName = @AppName", connection); lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName)); object lookupResult = lookupCommand.ExecuteScalar(); if ((lookupResult != null) && (lookupResult is int)) { return (int)lookupResult; } if (createIfNeeded) { OleDbCommand createCommand = new OleDbCommand("INSERT INTO aspnet_Applications (ApplicationName) VALUES (@AppName)", connection); createCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName)); if (createCommand.ExecuteNonQuery() != 0) { lookupResult = lookupCommand.ExecuteScalar(); if ((lookupResult != null) && (lookupResult is int)) { return (int)lookupResult; } } } return 0; }
public bool DoLogin(string username, string password, bool IsAdmin) { OleDbCommand com = new OleDbCommand("", MySchool.SLConnection); bool ReturnMe = false; if (IsAdmin) com.CommandText = "select UID, UPass from LoginInfo where UName = '" + username + "' and UPass = '" + password + "'"; else com.CommandText = "select UID, pass from UserInfo where UserName = '" + username + "' and Pass ='" + password + "'"; com.Connection.Open(); if (com.ExecuteScalar() != null) { if (IsAdmin) { TheSessions.EmploeeID = com.ExecuteScalar().ToString(); TheSessions.EmploeeName = username; TheSessions.IsAdmin = true; } else { TheSessions.StudentID = com.ExecuteScalar().ToString(); TheSessions.StudentName = username; TheSessions.IsAdmin = false; } ReturnMe = true; } else ReturnMe = false; com.Connection.Close(); return ReturnMe; }
public static bool FormsAuthenticate(string userName, string password) { bool authenticated = false; switch (Mode) { case AuthenticationMode.None: authenticated = FormsAuthentication.Authenticate(userName, password); break; case AuthenticationMode.Database: using (OleDbConnection connection = AppContext.GetDatabaseConnection()) { string format = String.Format("select count(*) from {0}User where UserName = '{1}' and Password = '{{0}}' and Active = 1", AppSettings.ConfigurationTablePrefix, userName); using (OleDbCommand command = new OleDbCommand(String.Format(format, password), connection)) { authenticated = Convert.ToInt32(command.ExecuteScalar()) > 0; if (!authenticated) { command.CommandText = String.Format(format, HashPassword(password)); authenticated = Convert.ToInt32(command.ExecuteScalar()) > 0; } } } break; } return authenticated; }
protected void Page_Load(object sender, EventArgs e) { //TheSessions.StudentID = "494108"; DataTable DT = new DataTable("ReadedBooks"); OleDbConnection AccessCon = MySchool.LibraryCodeConnection; OleDbCommand AccessCMD = new OleDbCommand("", AccessCon); try { if (TheSessions.StudentID != null) { OleDbDataAdapter AccessDA = new OleDbDataAdapter("SELECT motaraded.[number], book.name_book, motaraded.[date], book.code_printl, '' As name_printl, book.code_fari, '' As name_fari, book.code_tahasos, '' As name_tahasos, book.code_alnasher, '' As name_alnasher, (SELECT TOP 1 fm1 + ' ' + lm1 AS msl FROM masol WHERE ([number] = book.[number]) AND (k1 = 'مؤلف')) As masol FROM (motaraded INNER JOIN book ON motaraded.[number] = book.[number]) WHERE (motaraded.code_name = " + TheSessions.StudentID + ")", MySchool.LibraryConnection); AccessDA.Fill(DT); } AccessCon.Open(); foreach (DataRow DR in DT.Rows) { if (DR["code_printl"].ToString() != string.Empty) { AccessCMD.CommandText = "Select name_printl from printl Where code_printl = " + DR["code_printl"].ToString(); DR["name_printl"] = AccessCMD.ExecuteScalar(); } else { DR["name_printl"] = string.Empty; } if (DR["code_fari"].ToString() != string.Empty) { AccessCMD.CommandText = "Select name_fari from fari Where code_fari = " + DR["code_fari"].ToString(); DR["name_fari"] = AccessCMD.ExecuteScalar(); } else { DR["name_fari"] = string.Empty; } if (DR["code_tahasos"].ToString() != string.Empty) { AccessCMD.CommandText = "Select name_tahasos from tahasos Where code_tahasos = " + DR["code_tahasos"].ToString(); DR["name_tahasos"] = AccessCMD.ExecuteScalar(); } else { DR["name_tahasos"] = string.Empty; } if (DR["code_alnasher"].ToString() != string.Empty) { AccessCMD.CommandText = "Select name_alnasher from alnasher Where code_alnasher = " + DR["code_alnasher"].ToString(); DR["name_alnasher"] = AccessCMD.ExecuteScalar(); } else { DR["name_alnasher"] = string.Empty; } } AccessCon.Close(); GridViewReadedBooks.DataSource = DT; ViewState["ReadedBooksTable"] = DT; GridViewReadedBooks.DataBind(); } catch (Exception ex) { Response.Write(ex.Message.ToString()); } }
protected void Button1_Click(object sender, EventArgs e) { try { System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft Office 12.0 Access Database Engine OLE DB Provider;" + @"Data source= C:\Users\Ahmed Kamel Taha\Documents\Visual Studio 2015\Projects\ASP Training\bns.accdb"; conn.Open(); string q = "select count(*) from users where name='" + TextBox1.Text + "' And password='"+ TextBox2.Text+"';"; OleDbCommand comm = new OleDbCommand(q, conn); if (Convert.ToInt32(comm.ExecuteScalar().ToString()) == 1) { Session["user"] = TextBox1.Text; Response.Redirect("index.aspx"); } else { Response.Write("<script> alert(\"wrong pass or user\"); </script>"); } conn.Close(); }catch(Exception ex) { Response.Write(ex.ToString()); } }
public static int InsertIntoOringalTransaction(BankAccount bankAccount, Transaction transaction, string categoryName) { string cmdText = "INSERT INTO tblOrginalTransaction("; cmdText += "Verified, TransactionID, TransactionDate, TransactionAmount, Merchant, BankMemo, BankAccountId, TransactionType"; if (!string.IsNullOrEmpty(transaction.CheckNumber)) cmdText += ", CheckNumber"; if (categoryName != "") cmdText += ", CategoryName"; cmdText += ") Values("; cmdText += "false"; cmdText += ", '" + transaction.TransactionID + "'"; cmdText += ", #" + Convert.ToString(transaction.TransactionDate) + "#"; cmdText += ", " + Convert.ToString(transaction.TransactionAmount); cmdText += ", '" + transaction.MerchantName.Replace(@"'", "''") + "'"; cmdText += ", '" + transaction.BankMemo.Replace(@"'", "''") + "'"; cmdText += ", " + Convert.ToString(bankAccount.BankAccountID); cmdText += ", '" + transaction.TransactionType + "'"; if (!string.IsNullOrEmpty(transaction.CheckNumber)) cmdText += ", '" + transaction.CheckNumber + "'"; if (categoryName != "") cmdText += ", '" + categoryName + "'"; cmdText += ")"; string identity = " SELECT @@Identity"; int orginalTransactionID; using (OleDbConnection myConnection = new OleDbConnection( ConfigurationManager.ConnectionStrings["BeanCounterDB"].ToString())) { myConnection.Open(); using (OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection)) myCommand.ExecuteNonQuery(); using (OleDbCommand myCommand = new OleDbCommand(identity, myConnection)) orginalTransactionID = Convert.ToInt32(myCommand.ExecuteScalar().ToString()); } return orginalTransactionID; }
protected void Page_Load(object sender, EventArgs e) { string query = this.Request.QueryString.ToString(); int index = query.IndexOf('='); query = query.Substring(index + 1); int FlatID = Convert.ToInt32(query); string UserName; OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["RealEstate"].ConnectionString); OleDbCommand cmd = new OleDbCommand(String.Format("SELECT UserName FROM Flats WHERE FlatID = {0}", FlatID), conn); cmd.Connection = conn; conn.Open(); UserName = cmd.ExecuteScalar().ToString(); conn.Close(); if (this.User.Identity.Name == UserName || this.User.IsInRole("Manager") || this.User.IsInRole("Operator")) { this.ButtonDeleteRecord.Visible = true; } else { this.ButtonDeleteRecord.Visible = false; } }
public static int? isStudentRegistered(int? sessionID, int? year, int? term, int? stdID) { OleDbConnection connection = new OleDbConnection(global::ResultManagement.Properties.Settings.Default.ConnectionString); int? Registered_Session_ID = null; string cmdStr = @"SELECT Registered_Session.ID FROM Registered_Session WHERE Std_ID = @Std_ID AND Sess_ID = @Sess_ID AND Reg_Year = @Reg_Year AND Reg_Term = @Reg_Term"; OleDbCommand cmd = new OleDbCommand(cmdStr, connection); cmd.Parameters.Add("@Std_ID", OleDbType.Integer).Value = stdID; cmd.Parameters.Add("@Sess_ID", OleDbType.Integer).Value = sessionID; cmd.Parameters.Add("@Reg_Year", OleDbType.Integer).Value = year; cmd.Parameters.Add("@Reg_Term", OleDbType.Integer).Value = term; try { connection.Open(); Registered_Session_ID = (int?)cmd.ExecuteScalar(); } finally { connection.Close(); } return Registered_Session_ID; }
public void run() { OleDbConnection con = null; OleDbTransaction txn; Exception exp = null; try { BeginCase("OleDbTransaction Rollback"); // //prepare data base.PrepareDataForTesting(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString); string Result = ""; con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString); con.Open(); txn = con.BeginTransaction(); OleDbCommand cmd = new OleDbCommand("Update Employees Set LastName = 'StamLastName' Where EmployeeID = 100", con, txn); cmd.ExecuteNonQuery(); txn.Rollback(); // // cmd = new OleDbCommand("Select LastName From Employees Where EmployeeID = 100", con); Result = cmd.ExecuteScalar().ToString(); Compare(Result,"Last100" ); this.Log(Result); } catch(Exception ex){exp = ex;} finally{EndCase(exp); exp = null;} if (con.State == ConnectionState.Open) con.Close(); }
private static string GetRole(OleDbConnection connection) { IPrincipal user = HttpContext.Current.User; string role = "public"; if (user.Identity != null && user.Identity.IsAuthenticated) { if (AppAuthentication.Mode == AuthenticationMode.None) { role = "admin"; } else { string sql = String.Format("select Role from {0}User where UserName = '{1}' and Role is not null", AppSettings.ConfigurationTablePrefix, user.Identity.Name); OleDbCommand command = new OleDbCommand(sql, connection); role = command.ExecuteScalar() as string; if (String.IsNullOrEmpty(role)) { role = "private"; } } } return role; }
public string LoadContain() { if (QAMainMenu.SelectedValue == "") { return ""; } string ThePath = string.Empty; string RetData = string.Empty; OleDbConnection Con = MySchool.QAConnection; OleDbCommand CMD = new OleDbCommand("SELECT Data_Path FROM QAMenu WHERE (QAID = " + QAMainMenu.SelectedValue.ToString() + ")", Con); try { Con.Open(); ThePath = CMD.ExecuteScalar().ToString(); if (ThePath != string.Empty) { ThePath = MapPath(ThePath); } if (File.Exists(ThePath)) { TextReader TR = new StreamReader(ThePath); RetData = TR.ReadToEnd(); } } catch (Exception ex) { RetData = ex.Message; } Con.Close(); return RetData; }
public static int Add(SachDto sach) { OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Insert into Sach(TenSach,LoaiSach,TacGia,TrangThai,SoTrang,NgonNgu) values (?,?,?,?,?,?)"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@TenSach", OleDbType.WChar); cmd.Parameters.Add("@LoaiSach", OleDbType.Integer); cmd.Parameters.Add("@TacGia", OleDbType.WChar); cmd.Parameters.Add("@TrangThai", OleDbType.Boolean); cmd.Parameters.Add("@SoTrang", OleDbType.Integer); cmd.Parameters.Add("@NgonNgu", OleDbType.Integer); cmd.Parameters["@TenSach"].Value = sach.TenSach; cmd.Parameters["@LoaiSach"].Value = sach.LoaiSach; cmd.Parameters["@TacGia"].Value = sach.TacGia; cmd.Parameters["@TrangThai"].Value = sach.TrangThai; cmd.Parameters["@SoTrang"].Value = sach.SoTrang; cmd.Parameters["@NgonNgu"].Value = sach.NgonNgu; cmd.ExecuteNonQuery(); strSQL = "Select @@IDENTITY"; cmd = new OleDbCommand(strSQL, cn); sach.MSach = (int)cmd.ExecuteScalar(); cn.Close(); return sach.MSach; }
public string ExecuteScalar(string sql) { try { using (OleDbConnection connection = new OleDbConnection(_ConnectionString)) { WriteLog(sql); connection.Open(); var cmd = new OleDbCommand(sql, connection); object o = cmd.ExecuteScalar(); string s = null; if (o != null && Object.Equals(o, System.DBNull.Value) == false) { s = o.ToString(); } WriteLog("查询结果:" + s); return s; } } catch (Exception ex) { if (AfterExceptionThrow != null) AfterExceptionThrow(ex); else throw ex; return null; } }
public static long fcnGetIRRegCount() { //get current count of web registrations string strSQL; long lngRes = 0; using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn)) { conDB.Open(); strSQL = "SELECT Count(lngRegistrationWebID) AS lngRegCount " + "FROM tblWebIndRegistrations;"; using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB)) { try { lngRes = Convert.ToInt32(cmdDB.ExecuteScalar()); } catch { lngRes = 0; } } conDB.Close(); } return lngRes; }
public static int GetCount() { OleDbConnection dbConnection; OleDbCommand dbCommand; object obj; string buff; int result = 0; try { dbConnection = new OleDbConnection(ConnectionStringsManager.GetConnectionString()); dbCommand = new OleDbCommand(_SELECT_COUNT, dbConnection); dbConnection.Open(); try { obj = dbCommand.ExecuteScalar(); buff = obj.ToString(); Int32.TryParse(buff, out result); } finally { dbConnection.Close(); } } catch (Exception ex) { throw new Exception(ex.Message); } return result; }
public string selectOne(string q) { OleDbCommand cmd = new OleDbCommand(q, connection); object o = cmd.ExecuteScalar(); if (o == null) return ""; else return o.ToString(); }
public int getid() { int z=0; OleDbCommand cmd = new OleDbCommand("Select max(t_id) from [transaction]",con); try { con.Open(); object a = cmd.ExecuteScalar(); if (a == DBNull.Value) { z = 1; } else { z = (int)a + 1; } } catch (Exception) { return -1; } finally { con.Close(); } return z; }
public void AccessGuideJoinExcel(string Access, string AccTable, string Excel) { try { string tem_sql = "";//定义字符串 string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Access + ";Persist Security Info=True";//记录连接Access的语句 System.Data.OleDb.OleDbConnection tem_conn = new System.Data.OleDb.OleDbConnection(connstr);//连接Access数据库 System.Data.OleDb.OleDbCommand tem_comm;//定义OleDbCommand类 tem_conn.Open();//打开连接的Access数据库 tem_sql = "select Count(*) From " + AccTable;//设置SQL语句,获取记录个数 tem_comm = new System.Data.OleDb.OleDbCommand(tem_sql, tem_conn);//实例化OleDbCommand类 int RecordCount = (int)tem_comm.ExecuteScalar();//执行SQL语句,并返回结果 //每个Sheet只能最多保存65536条记录。 tem_sql = @"select top 65535 * into [Excel 8.0;database=" + Excel + @".xls].[Sheet2] from 帐目";//记录连接Excel的语句 tem_comm = new System.Data.OleDb.OleDbCommand(tem_sql, tem_conn);//实例化OleDbCommand类 tem_comm.ExecuteNonQuery();//执行SQL语句,将数据表的内容导入到Excel中 tem_conn.Close();//关闭连接 tem_conn.Dispose();//释放资源 tem_conn = null; MessageBox.Show("导入完成"); } catch(Exception ex) { MessageBox.Show(ex.Message,"提示!"); } }
public frmCollectRefundAmt(long _lngGGCCRegistrationWebID) { InitializeComponent(); string strSQL = ""; using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn)) { conDB.Open(); strSQL = "SELECT curDeposit " + "FROM tblWebGGCCRegistrations " + "WHERE lngGGCCRegistrationWebID=" + _lngGGCCRegistrationWebID.ToString(); using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB)) { decimal decDeposit = 0; try { decDeposit = Convert.ToDecimal(cmdDB.ExecuteScalar()); } catch { decDeposit = 0; } lblDeposit.Text = decDeposit.ToString("C"); txtAmt.Text = decDeposit.ToString(); } conDB.Close(); } }
public BL.Domain.Ticket CreateTicket(BL.Domain.Ticket ticket) { string insertStatement = "INSERT INTO Ticket(AccountId, [Text],DateOpened, State, DeviceName) VALUES(@accountId, @text, @dateOpened, @state,@deviceName)"; using (var connection = this.GetConnection()) { OleDbCommand command = new OleDbCommand(insertStatement, connection); command.Parameters.AddWithValue("@accountId", ticket.AccountId); command.Parameters.AddWithValue("@text", ticket.Text); command.Parameters.AddWithValue("@dateOpened", ticket.DateOpened.ToString("yyyy-MM-dd HH:mm:ss")); command.Parameters.AddWithValue("@state", (byte)ticket.State); if (ticket is HardwareTicket) command.Parameters.AddWithValue("@deviceName", ((HardwareTicket)ticket).DeviceName); else command.Parameters.AddWithValue("@deviceName", DBNull.Value); connection.Open(); command.ExecuteNonQuery(); string retrievalQuery = "Select @@Identity"; OleDbCommand retrievalOfNewNbrCommand = new OleDbCommand(retrievalQuery, connection); ticket.TicketNumber = Convert.ToInt32(retrievalOfNewNbrCommand.ExecuteScalar()); connection.Close(); } return ticket; }
public static object ExecuteScalar(string sql) { if (myOleDbConnection == null) Connect(); OleDbCommand myOleDbCommand = new OleDbCommand(sql, myOleDbConnection); return myOleDbCommand.ExecuteScalar(); }
public string LoadContain() { if (Request.QueryString["CourseId"] == null) { return string.Empty; } string ThePath = string.Empty; string RetData = string.Empty; using (OleDbConnection Con = new OleDbConnection(constr)) { OleDbCommand cmd = new OleDbCommand(String.Format("SELECT TOP 1 DataPath FROM CoursenotimeDataPath WHERE CourseId = {0}", Request.QueryString["CourseId"]), Con); try { Con.Open(); ThePath = cmd.ExecuteScalar().ToString(); //if (ThePath != string.Empty) // ThePath = MapPath(DB.CourseNoTimeFileDir + ThePath); ThePath = DB.CourseNoTimeFileDir + ThePath; TextReader TR = new StreamReader(ThePath); RetData = TR.ReadToEnd(); TR.Close(); TR.Dispose(); } catch (Exception ex) { RetData = ex.Message; } Con.Close(); } return HttpUtility.HtmlDecode(RetData); }
//返回一个单值,一般用select操作 public string ExecScalar(OleDbCommand myCmd) { string strSql; try { if (myCmd.Connection.State != ConnectionState.Open) { myCmd.Connection.Open(); } strSql=Convert.ToString(myCmd.ExecuteScalar()); return strSql ; } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { if (myCmd.Connection.State == ConnectionState.Open) { myCmd.Connection.Close(); } } }
public static string fcnDecrypt(string _strTextToDecrypt) { string strRes = ""; string strPassphrase = ""; using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn)) { conDB.Open(); string strSQL = "SELECT strEncPassPhrase " + "FROM tblCampDefaults"; using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB)) strPassphrase = cmdDB.ExecuteScalar().ToString(); conDB.Close(); } try { strRes = fcnDecrypt(_strTextToDecrypt, strPassphrase); } catch { } if (strRes == "") strRes = _strTextToDecrypt; return strRes; }
public string LoadPage() { string Path = string.Empty; OleDbConnection Con = new OleDbConnection(constr); OleDbCommand CMD = new OleDbCommand("SELECT Data_Path FROM MenuItem Where ItemID = " + MainMenu.SelectedValue.ToString(), Con); try { Con.Open(); Path = CMD.ExecuteScalar().ToString(); } catch { } Con.Close(); if (Path == string.Empty) { //HtmlEditorQA.Html = string.Empty; return string.Empty; } Path = MapPath(Path); if (!File.Exists(Path)) { return string.Empty; } else { TextReader TR = new StreamReader(Path); string tt = TR.ReadToEnd().ToString(); TR.Close(); TR.Dispose(); return tt; } }
//--function for returning a value queried by the user witht the help of an datareader---> public string execute_scalar(string s) { this.connect(); OleDbCommand cmd = new OleDbCommand(s, this.con); return_result = Convert.ToString(cmd.ExecuteScalar()); this.disconnect(); return return_result; }
public BL.Domain.TicketResponse CreateTicketResponse(BL.Domain.TicketResponse response) { if (response.Ticket != null) { string insertStatement = "INSERT INTO TicketResponse([Text], [Date], IsClientResponse" + ", Ticket_TicketNumber) VALUES (@text, @date" + ", @isClientResponse, @tickedNumber)"; using (var connection = this.GetConnection()) { OleDbCommand command = new OleDbCommand(insertStatement, connection); command.Parameters.AddWithValue("@text", response.Text); command.Parameters.AddWithValue("@date", response.Date.ToString("yyyy-MM-dd HH:mm:ss")); command.Parameters.AddWithValue("@isClientResponse", response.IsClientResponse); command.Parameters.AddWithValue("@tickedNumber", response.Ticket.TicketNumber); connection.Open(); command.ExecuteNonQuery(); // Retrieve primary key ‘Id' of inserted ticketresponse //When retrieving this data from Access, we must create and execute 2 commands string retrievalQuery = "Select @@Identity"; OleDbCommand retrievalOfNewNbrCommand = new OleDbCommand(retrievalQuery, connection); response.Id = Convert.ToInt32(retrievalOfNewNbrCommand.ExecuteScalar()); connection.Close(); // good practice! } return response; } else throw new ArgumentException("The ticketresponse has no ticket attached to it"); }
public string LoadPage() { LblError.Visible = false; //Load data from file to RadEditor string Path = string.Empty; OleDbConnection Con = MySchool.QAConnection; OleDbCommand CMD = new OleDbCommand("SELECT Data_Path FROM QAMenu Where QAID = " + QAMainMenu.SelectedValue.ToString(), Con); try { Con.Open(); Path = CMD.ExecuteScalar().ToString(); } catch { } Con.Close(); if (Path == string.Empty) { //HtmlEditorQA.Html = string.Empty; return string.Empty; } Path = MapPath(Path); if (!File.Exists(Path)) { return string.Empty; } else { TextReader TR = new StreamReader(Path); return TR.ReadToEnd().ToString(); } }
public int EnterToSite(UserDetails userDetails)//בודק על פי האימייל והסיסמא האם המשתשמש שמנסה להיכנס לאתר קיים או לא { OleDbCommand myCmd = new OleDbCommand("CheckIfUserExist", myConnection); myCmd.CommandType = CommandType.StoredProcedure; OleDbParameter objParam; objParam = myCmd.Parameters.Add("@Email", OleDbType.BSTR); objParam.Direction = ParameterDirection.Input; objParam.Value = userDetails.email; objParam = myCmd.Parameters.Add("@Password", OleDbType.BSTR); objParam.Direction = ParameterDirection.Input; objParam.Value = userDetails.password; int x = 0; try { myConnection.Open(); x = (int)myCmd.ExecuteScalar(); } catch (Exception ex) { throw ex; } finally { myConnection.Close(); } return x; }
protected void LinkButton2_Click(object sender, EventArgs e) { try { connection.Open(); string qry1 = "select Upload from FilesTable where Number=" + 2 + ""; OleDbCommand cmd = new OleDbCommand(qry1, connection); cmd.ExecuteNonQuery(); string fileName = cmd.ExecuteScalar().ToString(); string fileExtension = ".txt/.jpg/.pdf/.docx/.xls"; // Set Response.ContentType Response.ContentType = GetContentType(fileExtension); // Append header Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName); // Write the file to the Response Response.TransmitFile(Server.MapPath("~/Files/" + fileName)); Response.End(); } catch { } finally { connection.Close(); } }