protected void btnSignIn_Click(object sender, ImageClickEventArgs e) { if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "") lblMessage.Text = "Both fields are required"; else { query = "select usertype from Login where username='******' AND Password='******'"; reader = db.data_read(query); if (reader.Read()) { if (reader.GetString(0).Trim() == "Employee") // Go to employee's home page { Session["username"] = txtUsername.Text; reader.Close(); Response.Redirect("~/employee/EmployeeHome.aspx"); } else if (reader.GetString(0).Trim() == "Employer")// Go to employer's home page { Session["username"] = txtUsername.Text; reader.Close(); Response.Redirect("~/employer/EmployerHome.aspx"); } else // Go to admin's home page { Session["username"] = txtUsername.Text; Response.Redirect("~/admin/Home.aspx"); } } else { lblMessage.Text = "Invalid Username/Password or no such user exists"; } } }
public User getUser(string _username, string _pass) { User user = null; try { conn = db.openConn(); sb = new StringBuilder(); sb.Remove(0, sb.Length); sb.Append(" SELECT ID,UserName,Password,Ulevel FROM tbUser "); sb.Append(" WHERE (UserName='******')"); sb.Append(" AND (Password='******')"); string sql; sql = sb.ToString(); comm = new SqlCommand(); comm.CommandText = sql; comm.CommandType = CommandType.Text; comm.Connection = conn; dr = comm.ExecuteReader(); if (dr.HasRows) { DataTable dt = new DataTable(); dt.Load(dr); int index = 1; foreach (DataRow drw in dt.Rows) { user = new User(); user.UID = drw["ID"].ToString(); user.UserName = drw["UserName"].ToString(); user.Password = drw["Password"].ToString(); user.level = drw["Ulevel"].ToString(); } } dr.Close(); } catch (Exception ex) { dr.Close(); conn.Close(); return null; throw ex; } finally { conn.Close(); } return user; }
protected void btnSubmit_Click(object sender, EventArgs e) { try { conn.Open(); com.Connection = conn; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@UserName", tbxUserName.Text); com.Parameters.AddWithValue("@Email", tbxEmail.Text); com.CommandText = "CheckUsers"; //string checkUsers = "SELECT UserName from UserTbl where UserName = @UserName OR Email = @Email"; //SqlCommand checkCom = new SqlCommand(checkUsers, conn); //checkCom.Parameters.AddWithValue("@UserName", tbxUserName.Text); //checkCom.Parameters.AddWithValue("@Email", tbxEmail.Text); reader = com.ExecuteReader(); if (reader.Read()) { lblError.Text = "User name or Email is unavailable"; reader.Close(); } else { reader.Close(); com.Connection = conn; com.CommandType = CommandType.StoredProcedure; com.CommandText = "RegisterUser"; com.Parameters.Clear(); com.Parameters.AddWithValue("@UserName", tbxUserName.Text); com.Parameters.AddWithValue("@Email", tbxEmail.Text); com.Parameters.AddWithValue("@Password", Utilities.GetMD5Hash(tbxPassword.Text)); com.Parameters.AddWithValue("@DOB", tbxDOB.Text); com.Parameters.AddWithValue("@ContactNo", tbxContactNum.Text); com.ExecuteNonQuery(); reader = com.ExecuteReader(); Response.Redirect("LogIn.aspx"); } } catch(Exception ex) { Response.Write("Error: " + ex.ToString()); } finally { reader.Close(); conn.Close(); } }
internal static string GetCampaignContent(Guid campaignId, Guid objectId, UserDataContext udc, string word, string type) { string campaignContent = ""; float costPerPopupView = 0; SqlConnectionHelper sqlConnection = new SqlConnectionHelper(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandType = CommandType.StoredProcedure; sqlConnection.Command.CommandText = "hisp_Filter_AdCampaigns_LoadById"; sqlConnection.Command.Parameters.Add(new SqlParameter("@CampaignId", SqlDbType.UniqueIdentifier)); sqlConnection.Command.Parameters["@CampaignId"].Value = campaignId; sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection); if (sqlDataReader.Read()) { campaignContent = sqlDataReader["FAC_Content"].ToString(); costPerPopupView = float.Parse(sqlDataReader["FAC_CostPerPopupView"].ToString()); } sqlDataReader.Close(); } finally { sqlConnection.Close(); } if (AddView(udc.IsAuthenticated ? udc.UserID : udc.AnonymousUserId, udc.UserIP, campaignId, type) > 0) { IncreaseCreditsUsed(udc, campaignId, costPerPopupView); AddLog(campaignId, objectId, udc.UserID, word, type); } return(campaignContent); }
protected void Btnpreview_Click(object sender, EventArgs e) { imgprofile_pic.Visible = true; int uid = int.Parse(Session["uid"].ToString()); if (fluplod.HasFile == true) { cn.Open(); cmd = new SqlCommand("Select Email_id from Registration_Master Where User_Id=" + uid,cn); dr = cmd.ExecuteReader(); dr.Read(); string email = dr["Email_Id"].ToString(); dr.Close(); if(!Directory.Exists(Server.MapPath("~/User/"+email+"/Images"))) { Directory.CreateDirectory(Server.MapPath("~/Users/"+email+"/Profilepic")); } string fpath = "~/Users/"+email+"/Profilepic/" + fluplod.FileName; fluplod.PostedFile.SaveAs(Server.MapPath(fpath)); cmd = new SqlCommand("Update Registration_Master set User_Photo=@user_photo where User_Id=" + uid, cn); cmd.Parameters.AddWithValue("user_photo", fpath); cmd.ExecuteNonQuery(); cn.Close(); } //int uid = int.Parse(Session["uid"].ToString()); cn.Open(); cmd = new SqlCommand("select * from Registration_Master where User_Id=" + uid, cn); dr = cmd.ExecuteReader(); dr.Read(); imgprofile_pic.ImageUrl = dr["User_Photo"].ToString(); fluplod.Enabled = false; btnchoose.Enabled = true; cn.Close(); }
/// <summary> /// SqlDataReaderתDataTableTable /// </summary> /// <param name="dr"></param> /// <returns></returns> public static DataTable Convertdrtodt(SqlDataReader dr, DataTable dataTable) { //DataTable dataTable = new DataTable();//��һ���µ�ʵ�� for (int i = 0; i < dr.FieldCount; i++) { DataColumn mydc = new DataColumn();//�ؼ���һ�� mydc.DataType = dr.GetFieldType(i); mydc.ColumnName = dr.GetName(i); dataTable.Columns.Add(mydc);//�ؼ��ĵڶ��� } while (dr.Read()) { DataRow mydr = dataTable.NewRow();//�ؼ��ĵ����� for (int i = 0; i < dr.FieldCount; i++) { mydr[i] = dr[i];//.ToString(); } dataTable.Rows.Add(mydr);//�ؼ��ĵ��IJ� mydr = null; } dr.Close(); return (dataTable);//������Ҫ����datatable��������� }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MIP_MSG_NO, MSG_TARGET, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, MSG_STATE, LDATE, LUSER, SELECTALL, PROCESSED, ISNEW FROM MIP_MSG_MAIN WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mIP_MSG_NO = reader.GetInt32(0); _mSG_TARGET = reader.GetString(1); _rESERVATION = reader.GetString(2); _oNLINE_TIME = reader.GetDateTime(3); _oFFLINE_TIME = reader.GetDateTime(4); _dOPUSH = reader.GetString(5); _mSG_KIND_1 = reader.GetString(6); _mSG_KIND_2 = reader.GetString(7); _mSG_TITLE = reader.GetString(8); _mSG_CONTENT = reader.GetString(9); _mSG_STATE = reader.GetString(10); _lDATE = reader.GetDateTime(11); _lUSER = reader.GetString(12); _sELECTALL = reader.GetInt32(13); _pROCESSED = reader.GetInt32(14); _iSNEW = reader.GetInt32(15); } reader.Close(); } }
private void btnConvertExcel_Click(object sender, EventArgs e) { //Class.ExportToExcel.Export2Excel(dgvPrintSaleDayExcel); com = new SqlCommand(); com.Parameters.Clear(); com.Parameters.Add("@saleDate", SqlDbType.DateTime).Value = Convert.ToDateTime(saleDate); com.CommandText = strExcelToFormula; com.CommandType = CommandType.Text; com.Connection = Conn; dr = com.ExecuteReader(); DataTable dtFormula = new DataTable(); dtFormula.Load(dr); dtFormula.Columns["ProductId"].ColumnName = "รหัสสินค้า"; dtFormula.Columns["SaleHeadId"].ColumnName = "ใบยืม"; dtFormula.Columns["SaleDetailQuantity"].ColumnName = "จำนวน"; dtFormula.Columns["SaleDetailPriceUnit"].ColumnName = "ราคาขาย"; dtFormula.Columns["Cash"].ColumnName = "ขายสด"; ds = new DataSet(); ds.Tables.Add(dtFormula); dr.Close(); Class.ExportToExcel.Export2Excel(ds); frmCheckSaleDaily frm = new frmCheckSaleDaily(); frm.Close(); }
internal static List <string> GetCampaignObjectIds(Guid objectId) { List <string> campaignObjectIds = new List <string>(); SqlConnectionHelper sqlConnection = new SqlConnectionHelper(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandType = CommandType.StoredProcedure; sqlConnection.Command.CommandText = "hisp_Filter_CampaignObjects_LoadIds"; sqlConnection.Command.Parameters.Add(new SqlParameter("@ObjectId", SqlDbType.UniqueIdentifier)); sqlConnection.Command.Parameters["@ObjectId"].Value = objectId; sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { for (int i = 1; i <= int.Parse(sqlDataReader["FAO_NumberPopupLinks"].ToString()); i++) { campaignObjectIds.Add(sqlDataReader["FAC_ID"].ToString() + "_" + sqlDataReader["OBJ_ID"].ToString() + "_" + sqlDataReader["FAO_Word"].ToString() + "_" + i); } } sqlDataReader.Close(); } finally { sqlConnection.Close(); } return(campaignObjectIds); }
public IEnumerable <IDictionary <string, object> > GetRows(string selectStatement) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { if (!selectStatement.StartsWith("SELECT")) { throw new ArgumentException($"ILLEGAL STATEMENT!!! IT IS NOT A SELECT: '{selectStatement}'"); } SqlCommand command = new SqlCommand(selectStatement, connection); connection.Open(); System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { yield return(Enumerable.Range(0, reader.FieldCount) .ToDictionary(reader.GetName, reader.GetValue)); } } finally { reader.Close(); } } }
public static void BacaCombo(ComboBox cbRelasi, string cmd) { cbRelasi.Items.Clear(); BukaDatabase(); //Conn.Open() SqlCommand cm = new SqlCommand(cmd, conn); try { System.Data.SqlClient.SqlDataReader rdr = cm.ExecuteReader(); if (rdr.Read()) { cbRelasi.Items.Add(rdr[0].ToString()); } rdr.Close(); } catch (Exception salah) { MessageBox.Show("PERHATIAN.. " + salah.Message, "Kesalahan"); } finally { conn.Close(); } }
public List <ChartDataPair> GetUserTagWordCount() { List <ChartDataPair> chartDataPairList = new List <ChartDataPair>(); SqlConnection sqlConnection = new SqlConnection(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandText = "SELECT TOP 20 dbo.hitbl_Tagword_TGW.TGW_WordLower, Count(dbo.hitbl_Tagword_TGW.TGW_WordLower) AS TagWordCount " + "FROM dbo.hitbl_TagLog_TGL INNER JOIN dbo.hitbl_Tagword_TGW ON dbo.hitbl_TagLog_TGL.TGW_ID = dbo.hitbl_Tagword_TGW.TGW_ID " + "GROUP BY dbo.hitbl_Tagword_TGW.TGW_WordLower, dbo.hitbl_TagLog_TGL.TGW_Type " + "HAVING (((dbo.hitbl_TagLog_TGL.TGW_Type)>1)) " + "ORDER BY Count(dbo.hitbl_Tagword_TGW.TGW_WordLower) DESC"; sqlDataReader = sqlConnection.Command.ExecuteReader(); while (sqlDataReader.Read()) { // Get tag name and add to list chartDataPairList.Add(new ChartDataPair(sqlDataReader["TGW_WordLower"].ToString(), int.Parse(sqlDataReader["TagWordCount"].ToString()))); } } catch (Exception e) { throw new SoapException("Anfrage konnte nicht bearbeitet werden -> " + e.Message, SoapException.ServerFaultCode); } finally { try { sqlDataReader.Close(); } finally { sqlConnection.Close(); } } return(chartDataPairList); }
protected void Button1_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } cn.Open(); cmd.CommandText = "select Username from Users where Username like @Name"; ListBox1.Items.Clear(); cmd.Parameters.AddWithValue("@Name", "%" + TextBox1.Text + "%"); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ListBox1.Items.Add(dr[0].ToString()); } } else { ListBox1.Items.Add("Ничего не найдено!"); } cmd.Parameters.Clear(); dr.Close(); cn.Close(); cmd.Parameters.Clear(); }
/// <summary> /// 检验是否存在数据 /// </summary> /// <returns></returns> public bool ExistData(string SQL) { bool ret = false; try { System.Data.SqlClient.SqlDataReader dr = ReturnDataReader(SQL); if (dr.HasRows) { ret = true; } dr.Close(); } catch (Exception Ex) { throw new Exception(SQL + Ex.ToString()); } finally { if (null == transaction) { Close(); } } return(ret); }
public IActionResult Tables(String name) { dbname = name; SqlConnection con = new SqlConnection(connectionString); con.Open(); TableNamesList model = new TableNamesList() { }; List <string> result = new List <string>(); SqlCommand cmd = new SqlCommand(@"SELECT name FROM " + name + ".sys.Tables", con); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["name"].ToString() != "__RefactorLog") { result.Add(reader["name"].ToString()); } } reader.Close(); model.Database_name = name; model.Tables = result; con.Close(); return(View(model)); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _appname = reader.GetString(0); _accountID = reader.GetString(1); _deviceid = reader.GetString(2); _pushid = reader.GetString(3); _phonetype = reader.GetString(4); _status = reader.GetBoolean(5); _createdatetime = reader.GetDateTime(6); _pHONE_OS = reader.GetString(7); _pHONE_NAME = reader.GetString(8); _pHONE_MODEL = reader.GetString(9); _updatedatetime = reader.GetDateTime(10); } reader.Close(); } }
protected void Button1_Click1(object sender, EventArgs e) { Panel3.Visible = true; Label26.Text = Session["dn"].ToString(); cmd = new SqlCommand("select orderno,orderdate,deliverydate,name from booking where name='" + Session["nm"].ToString() + "' and Delivery='" + Labeldeliveryresult.Text + "' and distributorname='" + Session["dn"].ToString() + "'", con); con.Open(); dr = cmd.ExecuteReader(); string s1 = ""; while (dr.Read()) { s1 = dr.GetValue(0).ToString(); TextBox18.Text = dr.GetValue(1).ToString(); TextBox14.Text = dr.GetValue(2).ToString(); TextBox16.Text = dr.GetValue(3).ToString(); } TextBox12.Text = s1; TextBox13.Text = (int.Parse(s1) + 1000).ToString(); dr.Close(); cmd = new SqlCommand("select email,city from consumer where username='******'", con); dr = cmd.ExecuteReader(); if (dr.Read()) { TextBox17.Text = dr.GetValue(0).ToString(); TextBox19.Text = dr.GetValue(1).ToString(); } }
protected void Button2_Click(object sender, EventArgs e) { con.Open(); //Session["s1"] = DropDownList1.SelectedItem.ToString(); cmd = new SqlCommand("select * from add_passenger where invoice_no = '" + DropDownList1.SelectedItem.ToString() + "'" ,con); dr = cmd.ExecuteReader(); while(dr.Read()) { a = dr["Invoice_No"].ToString(); b = dr["Flight_no"].ToString(); c = dr["Date_Of_Travel"].ToString(); d = dr["Source"].ToString(); f = dr["Destination"].ToString(); g = dr["Category"].ToString(); h= dr["Passenger_Name"].ToString(); i = dr["Age"].ToString(); j = dr["Gender"].ToString(); k = dr["Phone_No"].ToString(); l = dr["E_Mail"].ToString(); m = dr["City"].ToString(); } dr.Close(); con.Close(); con.Open(); cmd = new SqlCommand("Insert into Seat_Cancellation Values('"+a+"','"+b+"','"+c+"','"+d+"','"+f+"','"+g+"','"+h+"','"+i+"','"+j+"','"+k+"','"+l+"','"+m+"')",con); cmd.ExecuteNonQuery(); con.Close(); con.Open(); con.Close(); Session["bb"] = DropDownList1.SelectedItem.ToString(); Response.Redirect("Refund.aspx"); }
/// <summary> /// 对当前数据能否拆分的检查 /// </summary> /// <returns></returns> protected string CheckCurernt() { /************* * 1、已提交明细部件不能拆分 * 2、变更删除部件不能拆分 * ***********/ string sql_1 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND BM_MSSTATE='1'"; System.Data.SqlClient.SqlDataReader dr_1 = DBCallCommon.GetDRUsingSqlText(sql_1); if (dr_1.HasRows) { return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】明细已提交,无法拆分!!!')"); } dr_1.Close(); string sql_2 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND (BM_MSSTATUS='1' or BM_MPSTATUS='1' or BM_OSSTATUS='1')"; System.Data.SqlClient.SqlDataReader dr_2 = DBCallCommon.GetDRUsingSqlText(sql_2); if (dr_2.HasRows) { return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】为变更删除记录,无法拆分!!!')"); } dr_2.Close(); return("OK"); }
public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader) { DataTable table = new DataTable(); DataTable schemaTable = dataReader.GetSchemaTable(); DataTable result; try { foreach (DataRow row in schemaTable.Rows) { DataColumn column = new DataColumn { DataType = row.GetType(), ColumnName = row[0].ToString() }; table.Columns.Add(column); } while (dataReader.Read()) { DataRow row2 = table.NewRow(); for (int i = 0; i < schemaTable.Rows.Count; i++) { row2[i] = dataReader[i].ToString(); } table.Rows.Add(row2); } schemaTable = null; dataReader.Close(); result = table; } catch (Exception ex) { SystemError.SystemLog(ex.Message); throw new Exception(ex.Message, ex); } return result; }
// 비밀번호 변경 - 입력한 기존 비밀번호가 일치?) public bool ChangePW_isMember(string id, string pw) { try { conn.Open(); string sql_truncate = "SELECT * FROM member WHERE id=@id AND pw=@pw"; command = new SqlCommand(sql_truncate, conn); command.Parameters.Add("@id", SqlDbType.VarChar); command.Parameters.Add("@pw", SqlDbType.VarChar); command.Parameters["@id"].Value = id; command.Parameters["@pw"].Value = pw; reader = command.ExecuteReader(); return reader.HasRows; } catch (Exception err) { MessageBox.Show(err.Message); } finally { reader.Close(); conn.Close(); } return reader.HasRows; }
private void button1_Click(object sender, EventArgs e) { string kode = getOppAlias(); // berikut ini adalah contoh penggunaan string.format. dimana {0} untuk parameter 1st dan {1} parameter 2nd //MessageBox.Show(string.Format("Menit: {0:MM} \nJam: {1}", DateTime.Now, DateTime.Now.ToShortTimeString())); try { koneksi.Open(); reader = konek.MembacaData("SELECT COUNT(*) FROM KASDA..BLJ_MASTER WHERE YEAR(Tgl_SP) = YEAR(GETDATE())", koneksi); if (reader.HasRows) { reader.Read(); if (alat.PengecekField(reader, 0) == "0") { Clipboard.SetText(string.Format("1/{0:MM}/{1:yy}/{2}", DateTime.Now, DateTime.Now, kode)); //MessageBox.Show("Test"); } else //MessageBox.Show(string.Format("{0}/{1:MM}/{2:yy}/{3}", alat.pengecekField(reader, 0), // DateTime.Now, DateTime.Now, kode)); Clipboard.SetText(string.Format("{0}/{1:MM}/{2:yy}/{3}", alat.PengecekField(reader, 0), DateTime.Now, DateTime.Now, kode)); reader.Close(); } koneksi.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public System.Collections.Generic.List <UsersMenu> GetAll() { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; System.Collections.Generic.List <UsersMenu> ListTmp = new System.Collections.Generic.List <UsersMenu>(); UsersMenu ObjTmp = null; SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); try { string Query = "SELECT * FROM Menu ORDER BY Menu_Id ASC"; cmd = new System.Data.SqlClient.SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp = new UsersMenu { Menu_Id = int.Parse(SDR["Menu_Id"].ToString()), MenuDisplayName = SDR["MenuDisplayName"].ToString(), ParentMenuId = int.Parse(SDR["ParentMenuId"].ToString()), MenuOrderNo = int.Parse(SDR["MenuOrderNo"].ToString()), MenuLink = SDR["MenuLink"].ToString(), Menu_Icon = SDR["Menu_Icon"].ToString(), User_Types = SDR["User_Types"].ToString(), Section = SDR["Section"].ToString() }; ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; } return(ListTmp); }
protected void Page_Load(object sender, EventArgs e) { cmd.Connection = vd.getcon(); /*if (!IsPostBack) { cmd.CommandText = "select name from componentlist"; ad.SelectCommand = cmd; ad.Fill(ds); DPLSELECTVENDOR.DataSource = ds; DPLSELECTVENDOR.DataTextField = ds.Tables[0].Columns[0].ToString(); DPLSELECTVENDOR.DataBind(); }*/ if (!Page.IsPostBack) { cmd.CommandText = "select * from purchaseorder where vendorname='"+Session["vendorname"]+"' and componentname='"+Session["comp"]+"'"; dr = cmd.ExecuteReader(); dr.Read(); TXTPONUMBER.Text = dr["ponumber"].ToString(); TXTCOMPONENTNAME.Text = dr["componentname"].ToString(); TXTQUANTITY.Text=dr["quantity"].ToString(); dr.Close(); } }
public static System.Collections.Generic.List <FAB> GetListSoonExpired(int CompanyID) { System.Collections.Generic.List <FAB> result = new System.Collections.Generic.List <FAB>(); int ID = -1; DBAccess db = new DBAccess(); db.AddInt("CompanyID", CompanyID); db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent()); db.AddGuid("AgentID", CurrentUserID); System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader); //Try dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllSoonExpired)); if (dr.HasRows) { while (dr.Read()) { ID = System.Convert.ToInt32(dr.DBtoInt("ID")); result.Add(FAB.GetFAB(ID)); } } dr.Close(); //Catch ex As Exception // Throw ex //End Try return(result); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _groupID = reader.GetString(0); _accountID = reader.GetString(1); _name = reader.GetString(2); _description = reader.GetString(3); //_password = reader.GetString(4); _password = (byte[])reader[4]; _startup = reader.GetBoolean(5); _pWLastUpdateTime = reader.GetDateTime(6); _pWType = reader.GetInt16(7); _createTime = reader.GetDateTime(8); _dModifyTime = reader.GetDateTime(9); _iFailTimes = reader.GetInt16(10); _dLockTime = reader.GetDateTime(11); _cRoleID = reader.GetInt16(12); _aD_CheckFlag = reader.GetBoolean(13); _cCallID = reader.GetString(14); _cPWD = reader.GetString(15); } reader.Close(); } }
/// <summary> /// returns DataTable from stored procedure. /// </summary> /// <param name="storeProcedure"></param> /// <returns></returns> public DataTable TableFromProc(SqlCommand cmd) { DataTable table = new DataTable(); cmd.Connection = new SqlConnection(this._connectionString); cmd.Connection.Open(); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if ((table.Columns.Count == 0)) { table.TableName = cmd.CommandText; for (int i = 0; (i < reader.FieldCount); i = i + 1 ) { System.Type type = reader.GetFieldType(i); string name = reader.GetName(i); table.Columns.Add(name, type); } } table.Clear(); int result = 0; for (; reader.Read(); result = result + 1) { System.Data.DataRow row = table.NewRow(); object[] rowdata = new object[reader.FieldCount]; reader.GetValues(rowdata); row.ItemArray = rowdata; table.Rows.Add(row); } reader.Close(); return(table); }
/// <summary> /// ��DataReader תΪ DataTable /// </summary> /// <param name="DataReader">DataReader</param> public DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader) { DataTable datatable = new DataTable(); try { DataTable schemaTable = dataReader.GetSchemaTable(); //��̬����� foreach (DataRow myRow in schemaTable.Rows) { DataColumn myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = myRow[0].ToString(); datatable.Columns.Add(myDataColumn); } //������� while (dataReader.Read()) { DataRow myDataRow = datatable.NewRow(); for (int i = 0; i < schemaTable.Rows.Count; i++) { myDataRow[i] = dataReader[i].ToString(); } datatable.Rows.Add(myDataRow); myDataRow = null; } schemaTable = null; } finally { dataReader.Close(); dataReader.Dispose(); } return datatable; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT ServiceID, sUrl, sNamespace, sClassname, APName, sDescription, sStatus, sCreateDatetime, ENCRYPTED FROM WebserviceData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _serviceID = reader.GetString(0); _sUrl = reader.GetString(1); _sNamespace = reader.GetString(2); _sClassname = reader.GetString(3); _aPName = reader.GetString(4); _sDescription = reader.GetString(5); _sStatus = reader.GetBoolean(6); _sCreateDatetime = reader.GetDateTime(7); _eNCRYPTED = reader.GetBoolean(8); } reader.Close(); } }
public int peliculaRegistrada(int CategoriaId) { int cont = 0; try { cmd = new SqlCommand(string.Format("select *from registroPelicula where categoriaId = {0}", CategoriaId), con); dr = cmd.ExecuteReader(); while (dr.Read()) { cont++; } dr.Close(); } catch (Exception ex) { MessageBox.Show("No hay Vida: "+ex.ToString ()); } return cont; }
protected void Page_Load(object sender, EventArgs e) { cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Technetium.mdf;Integrated Security=True;User Instance=True"); if (!IsPostBack) { if (Session["uid"] == null) { Response.Redirect("Default.aspx"); return; } try { int uid = int.Parse(Session["uid"].ToString()); cn.Open(); cmd = new SqlCommand("select * from Registration_Master where User_Id=" + uid, cn); dr = cmd.ExecuteReader(); dr.Read(); imgprofile_pic.ImageUrl = dr["User_Photo"].ToString(); btnchoose.Enabled = false; dr.Close(); cn.Close(); } catch { } } }
// When a DVD is selected, populate the textboxes with its information protected void btnSelect_Click(object sender, EventArgs e) { // Enable update and delete buttons btnDelete.Enabled = true; btnUpdate.Enabled = true; setConnection(); myCmd = new SqlCommand("SELECT DVDtitle, DVDartist, DVDrating, DVDprice FROM DVDtable WHERE DVDID = " + dvdDropdown.SelectedValue, myConnection); try { myConnection.Open(); myReader = myCmd.ExecuteReader(); while (myReader.Read()) { txtTitle.Text = (myReader["DVDtitle"].ToString()); txtArtist.Text = (myReader["DVDartist"].ToString()); txtRating.Text = (myReader["DVDrating"].ToString()); txtPrice.Text = (myReader["DVDprice"].ToString()); } myReader.Close(); } finally { myConnection.Close(); } }
public List <District> GetAllByStsCity(int StateId, int CityId, bool All = false) { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; List <District> ListTmp = new List <District>(); System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); try { string Query = "SELECT * FROM District where StateId=" + StateId.ToString() + " and CityId=" + CityId.ToString(); if (All) { Query = "SELECT * FROM District"; } cmd = new System.Data.SqlClient.SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { District ObjTmp = new District { Id = int.Parse(SDR["Id"].ToString()), Name = SDR["Name"].ToString(), StateId = int.Parse(SDR["StateId"].ToString()), CityId = int.Parse(SDR["CityId"].ToString()), }; ListTmp.Add(ObjTmp); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; } return(ListTmp); }
public List <Settings> GetAll() { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; System.Collections.Generic.List <Settings> ListTmp = new System.Collections.Generic.List <Settings>(); Settings ObjTmp = null; DBCon Obj = new DBCon(); try { string Query = "SELECT * FROM Settings "; cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp = new Settings { SettingId = SDR.GetInt32(0), KeyName = SDR.GetString(1), KeyValue = SDR.GetString(2), KeyDiscription = SDR.GetString(3), }; ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; } return(ListTmp); }
protected void btnUpdateDetail2_Click(object sender, EventArgs e) { foreach (GridViewRow r in gvOrderDetail.Rows) { product.Add(r.Cells[1].Text); } List <String> list = new List <string>(); list.Add(this.DDLProductname.SelectedValue.ToString()); list.Add(this.txtUnitDetail.Text); list.Add(this.txtQuantilyDetail.Text); list.Add(this.txtDiscountDetail.Text); try { if (product.IndexOf(DDLProductname.SelectedValue.ToString()) != -1) { new orderDetail().update(int.Parse(lblOrderID.Text), list); } else { new orderDetail().insert(int.Parse(lblOrderID.Text), list); } } catch (Exception ex) { Response.Write("<script language=\"javascript\">alert(\'" + ex.Message + "\');</script>"); } System.Data.SqlClient.SqlDataReader dr = (new orderDetail()).searchByID(int.Parse(lblOrderID.Text)); gvOrderDetail.DataSource = dr; gvOrderDetail.DataBind(); dr.Close(); }
} // GetSourceTypefromFeatureClass public string GetSourceFeatureClassfromFeatureClass(string FeatureDataset, string FeatureClass) { string sqlStatement = null; System.Data.SqlClient.SqlCommand featureClassCommand = null; System.Data.SqlClient.SqlDataReader featureClassReader = null; string featureClassName = null; // Confirm that there is a valid connection to the database before attempting to query tables in it. if (!ConnecttoImportMonitorDatabase()) { // Return an explanation of the process failure. return("Could not connect to the Import Monitor Database, GetFeatureClassName() FAILED!"); } try { // Build the SQL Statement that will be used to Retrieve the Feature Class Name from the Table. sqlStatement = "SELECT Input_Dataset_Name " + "FROM " + _monitorTableName + " " + "WHERE Feature_Class_Name = '" + FeatureClass + "' AND " + " ((Feature_Dataset = '" + FeatureDataset + "') OR " + " (Old_Feature_Dataset = '" + FeatureDataset + "'))"; // Build the Command Object that will be used to retrieve the Feature Class Name from the Table. featureClassCommand = new System.Data.SqlClient.SqlCommand(); featureClassCommand.Connection = _importMonitorDatabaseConnection; featureClassCommand.CommandText = sqlStatement; // Populate a Data Reader using the Command Object. featureClassReader = featureClassCommand.ExecuteReader(); // If any information was retrieved, get the Feature Class Name that was retrieved. if (featureClassReader.HasRows) { // Retrieve the data pulled from the Table. featureClassReader.Read(); // Get the Feature Class Name from the Data Reader. featureClassName = (string)featureClassReader["Input_Dataset_Name"]; } // Close the Data Reader. featureClassReader.Close(); // Return the Feature Class Name to the calling routine. If the name was not found, the returned // string will be NULL. return(featureClassName); } catch (Exception caught) { // Return a message to the calling routine indicating that this process failed. return("The GetSourceFeatureClassfromFeatureClass() process FAILED with message: " + caught.Message); } } // GetSourceFeatureClassfromFeatureClass
protected void Page_Load(object sender, EventArgs e) { cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Technetium.mdf;Integrated Security=True;User Instance=True"); //Response.Write(Server.MapPath("Images/Group/abc.jpg")); if (!IsPostBack) { try { if (Session["grpid"] == null) { Response.Redirect("GroupView.aspx"); return; } int grpid = int.Parse(Session["grpid"].ToString()); cn.Open(); cmd = new SqlCommand("Select * From Group_Master WHere Group_Id=" + grpid, cn); dr = cmd.ExecuteReader(); dr.Read(); txtGrpName.Text = dr["Group_Name"].ToString(); txtDescr.Text = dr["Group_Descr"].ToString(); imgFile.ImageUrl = dr["Group_Image"].ToString(); rblStatus.SelectedValue = dr["Group_Status"].ToString(); dr.Close(); cn.Close(); } catch (Exception ex) { Response.Write("Error : " + ex.Message); Response.End(); } } }
} // GetSourceFeatureClassfromFeatureClass public string GetLastLoadDatefromFeatureClass(string FeatureDataset, string FeatureClass, string ServerName, string SDEInstance) { string sqlStatement = null; System.Data.SqlClient.SqlCommand lastLoadDateCommand = null; System.Data.SqlClient.SqlDataReader lastLoadDateReader = null; System.DateTime lastLoadDate = System.DateTime.Now; // Confirm that there is a valid connection to the database before attempting to query tables in it. if (!ConnecttoImportMonitorDatabase()) { // Return an explanation of the process failure. return("Could not connect to the Import Monitor Database, GetLastLoadDatefromFeatureClass() FAILED!"); } try { // Build the SQL Statement that will be used to Retrieve the Last Load Date from the Table. sqlStatement = "SELECT " + ServerName + "_" + SDEInstance + "_Last_Load_Date " + "FROM " + _monitorTableName + " " + "WHERE Feature_Class_Name = '" + FeatureClass + "' AND " + " ((Feature_Dataset = '" + FeatureDataset + "') OR " + " (Old_Feature_Dataset = '" + FeatureDataset + "'))"; // Build the Command Object that will be used to retrieve the Last Load Date from the Table. lastLoadDateCommand = new System.Data.SqlClient.SqlCommand(); lastLoadDateCommand.Connection = _importMonitorDatabaseConnection; lastLoadDateCommand.CommandText = sqlStatement; // Populate a Data Reader using the Command Object. lastLoadDateReader = lastLoadDateCommand.ExecuteReader(); // If any information was retrieved, get the Last Load Date that was retrieved. if (lastLoadDateReader.HasRows) { // Retrieve the data pulled from the Table. lastLoadDateReader.Read(); // Get the Last Load Date from the Data Reader. lastLoadDate = (System.DateTime)lastLoadDateReader[ServerName + "_" + SDEInstance + "_Last_Load_Date"]; } // Close the Data Reader. lastLoadDateReader.Close(); // Return the Last Load Date to the calling routine. If the date was not found, the returned // string will be NULL. return(lastLoadDate.ToString("d MMMM yyyy")); } catch (Exception caught) { // Let the user know that this process failed. return("The GetLastLoadDatefromFeatureClass() Method FAILED with message: " + caught.Message.ToString()); } } // GetLastLoadDatefromFeatureClass
private void BindDropMsgClass() { string classidlist = ""; System.Data.SqlClient.SqlDataReader dr = DBHelper.ExecuteReader(" select a.ID,a.ClassName From MsgClass a,MsgClassAdmin b where a.ID=b.ClassID and b.Admin=@user", new SqlParameter("@user", Session["Company"]), CommandType.Text); while (dr.Read()) { ListItem list = new ListItem(dr["ClassName"].ToString(), dr["id"].ToString()); this.DropMsgClass.Items.Add(list); classidlist += classidlist + ","; } ViewState["ClassIDList"] = classidlist.TrimEnd(",".ToCharArray()); if (Request.QueryString["ClassID"] != null) { this.DropMsgClass.SelectedValue = Request.QueryString["ClassID"].ToString(); } dr = DBHelper.ExecuteReader(" select ID,ClassName From MsgClass"); while (dr.Read()) { ListItem list = new ListItem(dr["ClassName"].ToString(), dr["id"].ToString()); this.DropMsgClass_2.Items.Add(list); } dr.Close(); }
protected void Listar_Click(object sender, EventArgs e) { string nome; int idBusca; ListaNomes.Items.Clear(); if(int.TryParse(textID.Text, out idBusca) == false) { lblMensagem.Text = "Campo de busca ID em branco..!"; return; } conn.Open(); command = new SqlCommand("SELECT Id, Nome FROM tbPessoa WHERE Id >= @a", conn); command.Parameters.AddWithValue("@a", idBusca); reader = command.ExecuteReader(); while(reader.Read()) { idBusca = reader.GetInt32(0); nome = reader.GetString(1); ListItem item = new ListItem(nome, Convert.ToString(idBusca)); ListaNomes.Items.Add(item); } reader.Close(); reader.Dispose(); command.Dispose(); conn.Close(); conn.Dispose(); }
private void btnRetrieve_Click(object sender, EventArgs e) { try { // Store the ConnectionState string sConnection = "Data Source=RICKLARSEN-PC;Initial Catalog=Customers;Integrated Security=True;Pooling=False"; dbConn = new SqlConnection(sConnection); dbConn.Open(); // Store the SQL query sql = "SELECT * FROM Customers ORDER BY LastName ASC, FirstName ASC;"; dbCmd = new SqlCommand(); dbCmd.CommandText = sql; dbCmd.Connection = dbConn; // Create a dbReader object. dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { aMember = new Member (dbReader["FirstName"].ToString(), dbReader["LastName"].ToString()); this.lstCustomerNames.Items.Add(aMember); } dbReader.Close(); dbConn.Close(); } catch (System.Exception exc) { this.lblErrorMsg.Text = exc.Message; } }
public Project(string name, string description, string businessvalue) { mName = name; mDescription = description; mBusinessValue = businessvalue; mDatabase.connect(); mReader=mDatabase.executeread("SELECT Description FROM [dbo].[Issues] WHERE ProjectName='" + mName + "'"); while (mReader.Read() ) { mIssues.Add(new Issue(mReader.GetString(0).ToString(), mName)); } mReader.Close(); mReader = mDatabase.executeread("SELECT Description, Address FROM [dbo].[Link] WHERE ProjectName='" + mName + "'"); while (mReader.Read() ) { mLinks.Add(new Link(mReader.GetString(0).ToString(), mName, mReader.GetString(1).ToString())); } mReader.Close(); mReader = mDatabase.executeread("SELECT DependantName, [dbo].[Project].Description, [dbo].[Project].BusinessValueName FROM [dbo].[Dependents], [dbo].[Project] WHERE ProjectName='" + mName + "' AND DependantName=Name"); while (mReader.Read() ) { mDependencies.Add(new Project(mReader.GetString(0).ToString(), mReader.GetString(1).ToString(), mReader.GetString(2).ToString())); } mReader.Close(); }
public static bool CodigoExiste(string qryStr) { try { OpenConection(); command = new SqlCommand(qryStr, conexao); Reader = command.ExecuteReader(); if(Reader.HasRows) FlExiste= true; else FlExiste= false; Reader.Close(); } catch (Exception Ex) { throw new Exception(Ex.Message.ToString()); return false; } finally { CloseConection(); } return FlExiste; }
} //{0 city/district 1 means tehsil/TALUKA public List <City> GetAllByState(int StateId) { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; List <City> ListTmp = new List <City>(); System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); try { string Query = "SELECT * FROM City where StateId=" + StateId.ToString() + " ORDER BY Name ASC"; cmd = new System.Data.SqlClient.SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { City ObjTmp = new City { CityId = int.Parse(SDR["CityId"].ToString()), Name = SDR["Name"].ToString(), StateId = int.Parse(SDR["StateId"].ToString()), Type = int.Parse(SDR["Type"].ToString()) }; ListTmp.Add(ObjTmp); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; } return(ListTmp); }
protected void Button1_Click(object sender, EventArgs e) { if (refnum.Value == "") { MessageBox.Show("Please enter a reference number.."); refnum.Focus(); } else { try { cmd = new SqlCommand("select * from bookticketdb where refnum=" + refnum.Value, con); dr = cmd.ExecuteReader(); dr.Read(); mov = dr["movname"].ToString(); seat = dr["seats"].ToString(); date = dr["movdate"].ToString(); time = dr["movtime"].ToString(); bid = dr["bookid"].ToString(); cost = Convert.ToInt32(dr["cost"].ToString()); dr.Close(); } catch (Exception err) { MessageBox.Show("Followng Error occured :" + err.Message); } } }
internal static bool UserWantsAds(Guid userId) { bool userWantsAds = false; List <string> campaignObjectIds = new List <string>(); SqlConnectionHelper sqlConnection = new SqlConnectionHelper(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandType = CommandType.StoredProcedure; sqlConnection.Command.CommandText = "hisp_Filter_AdWords_CheckUser"; sqlConnection.Command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.UniqueIdentifier)); sqlConnection.Command.Parameters["@UserId"].Value = userId; sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection); if (sqlDataReader.Read()) { if (sqlDataReader["UPD_DisplayAds"] != DBNull.Value) { userWantsAds = (bool)sqlDataReader["UPD_DisplayAds"]; } } sqlDataReader.Close(); } finally { sqlConnection.Close(); } return(userWantsAds); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MIP_MSG_ID, MSG_NO, MSG_SOURCE, PCA_MSG_ID, ACCOUNTID, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, READ_STATE, READ_TIME, LDATE, REC_STA, PUSHED FROM MIP_MSG_DETAIL WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mIP_MSG_ID = reader.GetInt32(0); _mSG_NO = reader.GetInt32(1); _mSG_SOURCE = reader.GetString(2); _pCA_MSG_ID = reader.GetString(3); _aCCOUNTID = reader.GetString(4); _rESERVATION = reader.GetString(5); _oNLINE_TIME = reader.GetDateTime(6); _oFFLINE_TIME = reader.GetDateTime(7); _dOPUSH = reader.GetString(8); _mSG_KIND_1 = reader.GetString(9); _mSG_KIND_2 = reader.GetString(10); _mSG_TITLE = reader.GetString(11); _mSG_CONTENT = reader.GetString(12); _rEAD_STATE = reader.GetString(13); _rEAD_TIME = reader.GetDateTime(14); _lDATE = reader.GetDateTime(15); _rEC_STA = reader.GetString(16); _pUSHED = reader.GetInt32(17); } reader.Close(); } }
public static bool ExecCmd(string cmd, DataTable data) { bool result = false; try { cmdSql.CommandType = CommandType.Text; cmdSql.CommandText = cmd; cmdSql.Connection = conSql; conSql.Open(); readerSql = cmdSql.ExecuteReader(); data.Load(readerSql); readerSql.Close(); result = true; } catch (Exception ex) { //MessageBox.Show("error ExecPsParams: " + ex.Message); result = false; } finally { conSql.Close(); } //return result; return false; }
public City GetOne(int Cityid) { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; City ObjTmp = new City(); System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); try { string Query = "SELECT TOP 1 * FROM City where CityId=" + Cityid.ToString(); cmd = new System.Data.SqlClient.SqlCommand(Query, Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.CityId = int.Parse(SDR["CityId"].ToString()); ObjTmp.Name = SDR["Name"].ToString(); ObjTmp.StateId = int.Parse(SDR["StateId"].ToString()); ObjTmp.Type = int.Parse(SDR["Type"].ToString()); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; } return(ObjTmp); }
//Public Shared Function GetAllKursusDeltagerList() As DataSet // Dim db As DBAccess = New DBAccess // Dim ds As DataSet = db.ExecuteDataSet(_SQLSelectAllList) // Return ds //End Function public static System.Collections.Generic.List <KursusDeltager> GetAllKursusDeltagerDagList(int KursusDagID) { System.Collections.Generic.List <KursusDeltager> result = new System.Collections.Generic.List <KursusDeltager>(); int ID = -1; DBAccess db = new DBAccess(); db.AddInt("KursusDagID", KursusDagID); System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectIDAllDagList)); if (dr.HasRows) { while (dr.Read()) { ID = System.Convert.ToInt32(dr.DBtoInt("ID")); KursusDeltager kurist = KursusDeltager.GetKursusDeltager(ID); if (kurist != null && kurist.isLoaded) { result.Add(kurist); } } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
public void actualizador() { conexion.ConnectionString = cadena_conexion; conexion.Open(); Consulta = "select * from plantas"; comando.Connection = conexion; comando.CommandText = Consulta; Lector = comando.ExecuteReader(); int cantidades_de_registros = 0; Datos = new Plantas[30]; while (Lector.Read() == true) { Herbarios = new Plantas(); Herbarios.Codigo = Convert.ToInt32(Lector["COD_PLANTA"]); Herbarios.Descripcion = Convert.ToString(Lector["DESCRIPCION"]); Herbarios.CodigoPlanta = Convert.ToInt32(Lector["COD_TIPO_PLANTA"]); Herbarios.Precio = Convert.ToDouble(Lector["PRECIO"]); Herbarios.Stock = Convert.ToInt32(Lector["STOCK"]); Herbarios.Clima = Convert.ToString(Lector["clima"]); Datos[cantidades_de_registros] = Herbarios; lstMostrador.Items.Add(Datos[cantidades_de_registros].toString()); cantidades_de_registros++; } conexion.Close(); Lector.Close(); }
public Listado() { InitializeComponent(); textBoxUser.Focus(); consulta = "select distinct descripcion from GESTION_DE_GATOS.TiposDoc"; resultado = Home.BD.comando(consulta); while (resultado.Read() == true) { comboBoxTipoDoc.Items.Add(resultado.GetSqlString(0)); } resultado.Close(); consulta = "select nombre from GESTION_DE_GATOS.Hotel"; resultado = Home.BD.comando(consulta); while (resultado.Read() == true) { comboBoxHotel.Items.Add(resultado.GetSqlString(0)); } resultado.Close(); consulta = "select descripcion from GESTION_DE_GATOS.Rol"; resultado = Home.BD.comando(consulta); while (resultado.Read() == true) { comboBoxRol.Items.Add(resultado.GetSqlString(0)); } resultado.Close(); dateTimePicker1.Value = Home.fecha; }
public void cerrarDataReader(SqlDataReader pDataReader) { if (pDataReader != null && !pDataReader.IsClosed) { pDataReader.Close(); } }
public DataTable executarReader(String sqlCmd, SqlParameter[] sqlParams) { DataTable returnTable = new DataTable("returnTable"); associarComando(sqlCmd); _SqlCommand.CommandType = CommandType.Text; if (sqlParams != null) _SqlCommand.Parameters.AddRange(sqlParams); abrirLigacao(); if (_SqlConn.State == ConnectionState.Open) { _SqlReader = _SqlCommand.ExecuteReader(); returnTable.Load(_SqlReader); _SqlReader.Close(); } fecharLigacao(); _SqlCommand.Parameters.Clear(); return returnTable; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT HAPPY_ID, CSTATUS, FILE_KIND, APPLY_TARGET, CKEY1, CKEY2, CKEY3, TITLE, URL, F_IDX, F_NAME, CORDER, LDATE, LUSER, SELECTALL, ISTESTER, ONLINE_TIME, OFFLINE_TIME FROM MIP_HAPPY WHERE HAPPY_ID=@HAPPY_ID_PARAM"; cmd.Parameters.AddWithValue("@HAPPY_ID_PARAM", _hAPPY_ID); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _hAPPY_ID = reader.GetInt32(0); _cSTATUS = reader.GetInt32(1); _fILE_KIND = reader.GetInt32(2); _aPPLY_TARGET = reader.GetInt32(3); _cKEY1 = reader.GetString(4); _cKEY2 = reader.GetString(5); _cKEY3 = reader.GetString(6); _tITLE = reader.GetString(7); _uRL = reader.GetString(8); _f_IDX = reader.GetInt32(9); _f_NAME = reader.GetString(10); _cORDER = reader.GetInt32(11); _lDATE = reader.GetDateTime(12); _lUSER = reader.GetString(13); _sELECTALL = reader.GetInt32(14); _iSTESTER = reader.GetInt32(15); _oNLINE_TIME = reader.GetDateTime(16); _oFFLINE_TIME = reader.GetDateTime(17); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT version, sqltype, file_desc, fileUploadOldName, fileUploadNewName, datetime, version_no, imageData FROM userUploadLog WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _version = reader.GetInt32(0); _sqltype = reader.GetInt32(1); _file_desc = reader.GetString(2); _fileUploadOldName = reader.GetString(3); _fileUploadNewName = reader.GetString(4); _datetime = reader.GetDateTime(5); _version_no = reader.GetString(6); //_imageData = reader.GetBytes(7); _imageData = (byte[])reader[7]; } reader.Close(); } }
public object RetrieveAll(Type type) { List <CustomerProps> list = new List <CustomerProps>(); DBDataReader reader = null; CustomerProps props; try { reader = RunProcedure("usp_CustomerSelectAll"); if (!reader.IsClosed) { while (reader.Read()) { props = new CustomerProps(); props.SetState(reader); list.Add(props); } } return(list); } catch (Exception e) { // log this exception throw e; } finally { if (!reader.IsClosed) { reader.Close(); } } }
public string getEntidades() { try { List<entidad> entidades = new List<entidad>(); cnx = new cnx(); rdr = cnx.ExecuteCommand("select trc.VALOR, trc.ID_ENTIDAD, tcent.NOM_ENT,tcent.NOM_ABR from TR_CIFRA trc,TC_ENTIDAD_FEDERATIVA tcent where ID_FUENTE=2 and ID_VARIABLE=15 and ANIO=2014 and ID_TIPO_DATO=7 and ID_PERIODICIDAD=4 and trc.ID_ENTIDAD=tcent.ID_ENTIDAD order by trc.ID_ENTIDAD", CommandType.Text); if (rdr.HasRows) { while (rdr.Read()) { entidad ent = new entidad() { id_entidad = rdr["ID_ENTIDAD"].ToString(), valor = rdr["VALOR"].ToString(), nombre = rdr["NOM_ENT"].ToString(), nombre_abr = rdr["NOM_ABR"].ToString() }; entidades.Add(ent); } rdr.Close(); rdr = null; string data = JsonConvert.SerializeObject(entidades); return data; } } catch (Exception) { throw; } return ""; }
public int clienteRegistrado( string Tipo_ID, int Numero_ID) { con1.cnn.Open(); int contador = 0; try { string query = "SELECT id_tipo_doc, num_doc FROM LPP.CLIENTES WHERE id_tipo_doc = (SELECT tipo_cod FROM LPP.TIPO_DOCS WHERE tipo_descr = '" + Tipo_ID + "') AND num_doc = " + Numero_ID + ""; SqlCommand command = new SqlCommand(query, con1.cnn); dr = command.ExecuteReader(); while (dr.Read()) { contador++; } dr.Close(); } catch (Exception ) { con1.cnn.Close(); return contador; } con1.cnn.Close(); //MessageBox.Show("El Cliente ya existe"); return 0; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT logID, deviceid, phonetype, webservicenode, webservicemethod, webserviceparams, serverReturnData, sCreateDatetime, sRequestDatetime, webserviceparamsDecode, statuscode, ID, user_type, version FROM WebserviceLog WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _logID = reader.GetString(0); _deviceid = reader.GetString(1); _phonetype = reader.GetString(2); _webservicenode = reader.GetString(3); _webservicemethod = reader.GetString(4); _webserviceparams = reader.GetString(5); _serverReturnData = reader.GetString(6); _sCreateDatetime = reader.GetDateTime(7); _sRequestDatetime = reader.GetDateTime(8); _webserviceparamsDecode = reader.GetString(9); _statuscode = reader.GetInt32(10); _iD = reader.GetString(11); _user_type = reader.GetString(12); _version = reader.GetString(13); } reader.Close(); } }