public static List<Club> readTable(string SqlQuery, string serverName, string databaseName) { myConnection = new SqlConnection(serverName + ";" + databaseName + ";" + "Integrated Security=true"); try { myConnection.Open(); myCommand = new SqlCommand(SqlQuery, myConnection); myReader = myCommand.ExecuteReader(); ClubList.Clear(); while(myReader.Read()) { //Console.WriteLine(myReader[0].ToString()); //code here to map query output to club objects and put into list ClubList.Add(new Club { id = myReader[0].ToString(), //name = myReader[1].ToString(), //address = myReader[2].ToString(), //city = myReader[3].ToString(), //state = myReader[4].ToString() }); } } catch (Exception e) { Console.WriteLine(e.ToString()); } finally { myConnection.Close(); } return ClubList; }
private void button1_Click(object sender, EventArgs e) { listView1.Items.Clear(); CN = new SqlConnection(cadenaconexion); CMD = new SqlCommand("SELECT * FROM Prueba", CN); CMD.CommandType = CommandType.Text; try { CN.Open(); RDR = CMD.ExecuteReader(); while (RDR.Read()) { ListViewItem lvi = new ListViewItem(); lvi.Text = (string)RDR["id"].ToString(); lvi.SubItems.Add((string)RDR["nombre"]); listView1.Items.Add(lvi); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CN.Close(); } }
// Apresentar os registros da pesquisa desejada. public void loadlist() { listBox1.Items.Clear(); listBox2.Items.Clear(); listBox3.Items.Clear(); listBox4.Items.Clear(); listBox5.Items.Clear(); listBox6.Items.Clear(); listBox7.Items.Clear(); conexao.Open(); comando.CommandText = "SELECT * FROM Contatos"; LerDados = comando.ExecuteReader(); if (LerDados.HasRows) { while (LerDados.Read()) { listBox1.Items.Add(LerDados[0].ToString()); listBox2.Items.Add(LerDados[1].ToString()); listBox3.Items.Add(LerDados[2].ToString()); listBox4.Items.Add(LerDados[3].ToString()); listBox5.Items.Add(LerDados[4].ToString()); listBox6.Items.Add(LerDados[5].ToString()); listBox7.Items.Add(LerDados[6].ToString()); } } conexao.Close(); }
public List<List<String>> convert(SqlDataReader reader) { if (reader != null) { List<List<String>> list = new List<List<String>>(); while (reader.Read()) { List<String> tmp = new List<String>(); for (int i = 0; i < reader.FieldCount; i++) { string s = ""; try { s = reader.GetString(i); } catch (SqlNullValueException) { s = "null"; } tmp.Add(s); } list.Add(tmp); } return list; } return null; }
public static YellowstonePathology.Business.ClientOrder.Model.ClientOrder BuildClientOrder(SqlDataReader dr) { YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = null; Nullable<int> panelSetId = null; while (dr.Read()) { if (dr["PanelSetId"] != DBNull.Value) { panelSetId = Convert.ToInt32(dr["PanelSetId"].ToString()); } } clientOrder = YellowstonePathology.Business.ClientOrder.Model.ClientOrderFactory.GetClientOrder(panelSetId); dr.NextResult(); while (dr.Read()) { YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrder, dr); propertyWriter.WriteProperties(); } dr.NextResult(); while (dr.Read()) { YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, dr); propertyWriter.WriteProperties(); clientOrder.ClientLocation = clientLocation; } return clientOrder; }
public static void Convert(ShapefileGeometryType type, SqlDataReader reader, string shapefile) { if (!reader.Read()) throw new Exception("No Results found"); int geomOrdinal, colCount; ShapefileHeader shapeHeader = ShapefileHeader.CreateEmpty(type); DbfHeader dbfHeader = BuildHeader(reader, out geomOrdinal, out colCount); GeometryFactory factory = new GeometryFactory(); Envelope env = shapeHeader.Bounds; using (ShapefileDataWriter writer = ShapefileDataWriter.Create(shapefile, dbfHeader, shapeHeader)) { do { SqlGeometry geom = reader[geomOrdinal] as SqlGeometry; if (!geom.STIsValid()) geom = geom.MakeValid(); for (int i = 0, offset = 0; i < colCount; i++) { if (i == geomOrdinal) offset++; writer.Record.SetRaw(i, reader[i + offset]); } ExpandEnv(env, geom.STBoundary()); writer.Write(ConvertToGeometry.SqlGeometryToGeometry(geom, factory)); } while (reader.Read()); } }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (nextResultSet == null) { reader.NextResult(); List<IDictionary<XName, object>> parameters = new List<IDictionary<XName, object>>(); if (reader.Read()) { do { IDictionary<XName, object> item = new Dictionary<XName, object>(); item.Add(WorkflowServiceNamespace.SiteName, reader.GetString(0)); item.Add(WorkflowServiceNamespace.RelativeApplicationPath, reader.GetString(1)); item.Add(WorkflowServiceNamespace.RelativeServicePath, reader.GetString(2)); parameters.Add(item); } while (reader.Read()); } else { base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasActivatableWorkflowEvent>.Value); base.StoreLock.InstanceDetectionTask.ResetTimer(false); } base.InstancePersistenceContext.QueriedInstanceStore(new ActivatableWorkflowsQueryResult(parameters)); } return nextResultSet; }
public static Collection<Post> CreatePostsFromReader(SqlDataReader reader) { // First result set is the postcategories. Dictionary<int, Category> postcats = new Dictionary<int, Category>(); if (reader.HasRows) { while (reader.Read()) { // Oops - key can't be PostId as key has to be unique. Need to use a different collection.. // .. for now, make a hash of the post and category IDs. int categoryId = Convert.ToInt32(reader["categoryId"]); int postHash = (Convert.ToInt32(reader["PostId"]) * 10000) + categoryId; postcats.Add(postHash, new Category(categoryId, Convert.ToString(reader["Name"]), Convert.ToString(reader["Slug"]))); } } // Second resultset is the post(s) reader.NextResult(); Collection<Post> postlist = new Collection<Post>(); if (reader.HasRows) { while (reader.Read()) { Post p = new Post(); p.Id = Convert.ToInt32(reader["Id"]); p.Title = Convert.ToString(reader["Title"]); p.Postdate = Convert.ToDateTime(reader["PostDate"]); p.Body = Convert.ToString(reader["Body"]); p.Slug = Convert.ToString(reader["Slug"]); p.CommentCount = Convert.ToInt32(reader["CommentCount"]); p.Published = Convert.ToBoolean(reader["Published"]); p.Categories = new Collection<Category>(); // .. then the categories. IEnumerable<Category> cats = from entry in postcats where ((entry.Key / 10000) == p.Id) select entry.Value; foreach (Category cat in cats) { p.Categories.Add(cat); } postlist.Add(p); } } return postlist; }
private void loadgrid() { //sql = "select * from tbl_reg" //If rs.State = 1 Then rs.Close() //rs.Open(sql, conn) DataGridView1.Rows.Clear(); cn.Open(); cmd.CommandText = "select * from tbl_streg where (sport = N'CRICKET')"; int i; i = 0; //Do While Not rs.EOF dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { DataGridView1.Rows.Add(); DataGridView1.Rows[i].Cells[0].Value = dr[0]; DataGridView1.Rows[i].Cells[1].Value = dr[1]; DataGridView1.Rows[i].Cells[2].Value = dr[2]; DataGridView1.Rows[i].Cells[3].Value = dr[3]; DataGridView1.Rows[i].Cells[4].Value = dr[4]; DataGridView1.Rows[i].Cells[5].Value = dr[5]; DataGridView1.Rows[i].Cells[6].Value = dr[6]; i = i + 1; } } cn.Close(); }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (txtSkillHead.Text.Trim() == "") // Cannot be blank { lblMessage.Text = "Field can't be blank"; } else { query = "select Head from SkillHead where Head='" + txtSkillHead.Text + "'"; reader = db.data_read(query); if (reader.Read()) { lblMessage.Text = "Skill Head already exists"; } else { query = "insert into SkillHead (Id,Head) values ('" + AutoGeneration() + "','" + txtSkillHead.Text + "')"; db.database_command(query); txtSkillHead.Text = ""; lblMessage.Text = "Skill head added"; } } } catch (Exception ex) { } }
public RoadMap(string name ) { mName = name; mDatabase.connect(); mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'"); mReader.Read(); mTimeStamp = mReader.GetDateTime(0); mDescription = mReader.GetString(1); string UID = mReader.GetString(2); mDatabase.close(); mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'"); mReader.Read(); mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2)); mDatabase.close(); mTimeline = new TimeLine(mName); //Get the StrategyPoints mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'"); while (mReader.Read()) { StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1)); mStrategyPoints.Add(sp); } mDatabase.close(); }
/// <summary> /// lay bang cong ty /// </summary> /// <param name="ct"></param> /// <returns></returns> public Entities.ThongTinCongTy sp_ThongTinCongTy(Entities.TruyenGiaTri ct) { Entities.ThongTinCongTy banghi = new Entities.ThongTinCongTy(); try { string sql = "exec sp_ThongTinCongTy @MaCongTy"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("MaCongTy", SqlDbType.VarChar, 20).Value = ct.Giatritruyen; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ArrayList arr = new ArrayList(); while (dr.Read()) { banghi.MaCongTy = dr[0].ToString(); banghi.TenCongTy = dr[1].ToString(); banghi.DiaChi = dr[2].ToString(); banghi.SoDienThoai = dr[3].ToString(); banghi.Email = dr[4].ToString(); banghi.Website = dr[5].ToString(); banghi.Fax = dr[6].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); banghi = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return banghi; }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(ConfigurationManager.ConnectionStrings["devi"].ToString()); con.Open(); cmd = new SqlCommand("select * from user1_reg where lid='" + Session["usr"].ToString() + "'"); cmd.Connection = con; dr = cmd.ExecuteReader(); if (dr.Read()) { Label1.Text = "<img src='userfig/"+dr[11].ToString()+"' width='100' height='150' /><br />Welcome " + dr[1].ToString(); } con.Close(); con.Open(); string fid = Request.QueryString["fid"].ToString(); cmd = new SqlCommand("select * from cloud_data where id='"+fid+"'"); cmd.Connection = con; dr = cmd.ExecuteReader(); if (dr.Read()) { Label3.Text = dr[2].ToString(); TextBox3.Text = dr[3].ToString(); TextBox4.Text = dr[5].ToString(); TextBox5.Text = dr[7].ToString(); TextBox6.Text = dr[9].ToString(); } con.Close(); }
public int countRows(int tipoUsuario) { Cmd = new SqlCommand(); Cmd.Connection = Conn; int total_rows = 0; try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "[otaku_bcp].PA_COUNT_ROWS_TYPE_USER"; Cmd.Parameters.Add("@IdType", SqlDbType.Int).Value = tipoUsuario; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { total_rows = Convert.ToInt32(Dtr["total_rows"]); } Conn.Close(); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } return total_rows; }
private static void sendEachRecordOfData(SqlDataReader dataReader, SqlMetaData[] meta) { while (dataReader.Read()) { SqlContext.Pipe.SendResultsRow(createRecordPopulatedWithData(dataReader, meta)); } }
// CHECK IF SALES PERSON EXIST IN DATBASE public static string CheckSalesPersonLogIn(SqlDataReader dr) { bool noExist = true; bool isActive = true; string clear = null; while (dr.Read()) { clear = dr.GetString(0); isActive = dr.GetBoolean(5); noExist = false; } if (!isActive) { MessageBox.Show("Sorry, you are fired!", "LOL", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } else if (noExist) { MessageBox.Show("Not in the register.", "Unregistered Sales Person", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } else { return clear; } }
/// <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��������� }
protected void Page_Load(object sender, EventArgs e) { string idtiket = Request.QueryString["tiketid"]; userconnection = new SqlConnection(); userconnection.ConnectionString = @"Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aviation.mdf;Trusted_Connection=True;User Instance=True"; usercommand = new SqlCommand(); usercommand.Connection = userconnection; usercommand.CommandText = "SELECT * FROM application WHERE id=@id"; usercommand.Parameters.Clear(); usercommand.Parameters.AddWithValue("@id", idtiket); try { userconnection.Open(); userreader = usercommand.ExecuteReader(); if (userreader.Read()) { Response.ContentType = userreader["MIME"].ToString(); Response.BinaryWrite((byte[])userreader["BinaryData"]); } } catch (SqlException ex) { } finally { userconnection.Close(); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { query = "select Sid from State where SName='" + drpState.SelectedItem.ToString() + "'"; reader = db.data_read(query); if (reader.Read()) { sid = reader.GetString(0); } query = "select CIName from City where CIName='" + txtCity.Text + "' AND StateId='" + sid + "'"; reader = db.data_read(query); if (reader.Read()) { lblMessage.Text = "City already exists"; } else { query = "insert into City (CityId,CIName,StateId) values ('" + AutoGeneration() + "','" + txtCity.Text + "','" + sid + "')"; db.database_command(query); txtCity.Text = ""; } } catch (Exception ex) { } }
private void btnPreview_Click(object sender, EventArgs e) { double debit =0,credit = 0; try { string sql2 = "select * from GeneralLagerRpt where VocDate between '" + dpTo.Value.ToString("yyyy-MM-dd") + "' and '" + dpFrom.Value.ToString("yyyy-MM-dd") + "' order by SortBy"; reader = db.selectQuery(sql2); Grid.Rows.Clear(); while (reader.Read()) { Grid.Rows.Add(reader["VocType"] + "-" + reader["VocNo"], Convert.ToDateTime(reader["VocDate"]).ToString("dd-MM-yyyy"), reader["Narration"], String.Format("{0:0.00}",reader["Debit"]), String.Format("{0:0.00}",reader["Credit"])); credit = credit + Convert.ToDouble(reader["Credit"]); debit = debit + Convert.ToDouble(reader["Debit"]); } for (int a = 0; a <= Grid.RowCount - 1; a++) { if (a % 2 != 0) { Grid.Rows[a].DefaultCellStyle.BackColor = Color.WhiteSmoke; } } txtCredit.Text = String.Format("{0:0.00}",credit); txtdebit.Text = String.Format("{0:0.00}",debit); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List<Columns> GetColoumns(string tableName,string dbName) { List<Columns> allColoumns = new List<Columns>(); string database = "USE " + dbName; try { GetSqlConn.Open(); commandString = string.Format(database+" select COLUMN_NAME,DATA_TYPE from information_schema.columns where table_name = @tableName"); GetSqlCommand.CommandText = commandString; GetSqlCommand.Parameters.Clear(); GetSqlCommand.Parameters.Add("@tableName", SqlDbType.NVarChar); GetSqlCommand.Parameters["@tableName"].Value = tableName; getData = GetSqlCommand.ExecuteReader(); while (getData.Read()) { Columns aColoumn = new Columns(); aColoumn.ColName = getData["COLUMN_NAME"].ToString(); aColoumn.DataType = getData["DATA_TYPE"].ToString(); allColoumns.Add(aColoumn); } } catch (Exception exp) { throw new Exception("Error while fetching data" + exp); } finally { GetSqlConn.Close(); } return allColoumns; }
private StringBuilder LireSQL(SqlDataReader dataR1) { StringBuilder BLD = new StringBuilder(); BLD.Append("<table style='background-color: #0066ff; color: white; width: 100%' class='tabProduits'><tr>"); for (int i = 0; i < dataR1.FieldCount; i++) { BLD.Append("<th style='background-color: black'>" + dataR1.GetName(i) + "</th>"); } BLD.Append("<tr>"); while (dataR1.Read()) { BLD.Append("<tr>"); for (int i = 0; i < dataR1.FieldCount; i++) { BLD.Append("<th>" + dataR1[i] + "</th>"); } BLD.Append("</tr>"); } BLD.Append("</table>"); return BLD; }
public List<Tables> GetAllDBTables(string databaseName) { List<Tables> allTable = new List<Tables>(); try { string query = "USE " + databaseName; GetSqlConn.Open(); commandString = string.Format(query+" SELECT TABLE_NAME AS Table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'"); GetSqlCommand.CommandText = commandString; GetSqlCommand.Parameters.Clear(); getData = GetSqlCommand.ExecuteReader(); while (getData.Read()) { Tables aTable = new Tables(); aTable.TableName = getData["Table_name"].ToString(); allTable.Add(aTable); } } catch (Exception exp) { throw new Exception("Error while fetching data" + exp); } finally { GetSqlConn.Close(); } return allTable; }
protected void Page_Load(object sender, EventArgs e) { s_connection = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\user\Desktop\MyRentalService\RentalService\App_Data\RentalDB.mdf;Integrated Security=True"; sql_cn = new SqlConnection(s_connection); ds = new DataSet(); if (Session["MID"] != null)//確認Session內是否存在MID { s_MID = Session["MID"].ToString();//取出MID if (!IsPostBack) { try { sql_cn.Open(); s_sql_query = "SELECT * FROM Member WHERE Member.MID = " + s_MID;//取出該MID會員資料的SQL Query sql_cmd = new SqlCommand(s_sql_query, sql_cn); sql_dr = sql_cmd.ExecuteReader(); sql_dr.Read(); L_test.Text = "Welcome " + sql_dr["UserName"];//將會員名稱加入歡迎標語 sql_cn.Close(); } catch (Exception excp) { L_test.Text = excp.ToString(); } } } else if (Session["MID"] == null) { Response.Redirect("Login.aspx"); } }
public List<ModeloNegocio.MicroredSchool> getAllMicroredSchoolForIdMicrored(int idMicrored) { List<ModeloNegocio.MicroredSchool> lista = new List<ModeloNegocio.MicroredSchool>(); Cmd = new SqlCommand(); Cmd.Connection = Conn; try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_GET_MICRORED_SCHOOL_FOR_MICRORED_ID"; Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { ModeloNegocio.MicroredSchool microredSchool = new ModeloNegocio.MicroredSchool(); microredSchool.Id = Convert.ToInt32(Dtr["id"]); microredSchool.School_id = Convert.ToInt32(Dtr["school_id"]); microredSchool.Microred_id = Convert.ToInt32(Dtr["microred_id"]); if (DBNull.Value.Equals(Dtr["created_at"])) microredSchool.Created_at = DateTime.Now ; else microredSchool.Created_at = DateTime.Parse(Dtr["created_at"].ToString()); if (DBNull.Value.Equals(Dtr["updated_at"])) microredSchool.Updated_at = DateTime.Now ; else microredSchool.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString()); lista.Add(microredSchool); } Conn.Close(); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } return lista; }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { //generar facturacion consulta = "EXEC GESTION_DE_GATOS.registrarCheckoutEstadia "; consulta = consulta + dataGridView1.CurrentRow.Cells[1].Value.ToString(); consulta = consulta + ",'" + Home.fecha.Date.ToString("yyyyMMdd HH:mm:ss") + "',"; consulta = consulta + Login.HomeLogin.idUsuario; resultado = Home.BD.comando(consulta); resultado.Read(); if (resultado.GetDecimal(0) == 1) { resultado.Close(); //aca va lo de facturacion Facturar_Estadia.Facturacion factu = new FrbaHotel.Facturar_Estadia.Facturacion(dataGridView1.CurrentRow.Cells[1].Value.ToString()); MessageBox.Show("El checkout se ha realizado correctamente. Se procede a la facturacion"); factu.Show(); } else { resultado.Close(); MessageBox.Show("El checkout no se pudo realizar correctamente"); } this.Close(); } }
public SqlDataReader RetDataReader(string sql) { SqlCommand comando = new SqlCommand(sql, Con); Dr = comando.ExecuteReader(); Dr.Read(); return Dr; }
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; }
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(); }
/// <summary> /// The object factory for a particular data collection instance. /// </summary> public virtual void CreateObjectsFromData(FullPrepaymentPenaltyOptionTypes fullprepaymentpenaltyoptiontypes, System.Data.SqlClient.SqlDataReader data) { // Do nothing if we have nothing if (data == null) { return; } // Create a local variable for the new instance. FullPrepaymentPenaltyOptionType newobj = null; // Iterate through the data reader while (data.Read()) { // Create a new object instance newobj = System.Activator.CreateInstance(fullprepaymentpenaltyoptiontypes.ContainsType[0]) as FullPrepaymentPenaltyOptionType; // Let the instance set its own members newobj.SetMembers(ref data); // Add the new object to the collection instance fullprepaymentpenaltyoptiontypes.Add(newobj); } }
/// <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 FROM MobileDeviceDataPublic 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); } reader.Close(); } }
/// <summary> /// The object factory for a particular data collection instance. /// </summary> public virtual void CreateObjectsFromData(FNMCommunityLendingProductTypes fnmcommunitylendingproducttypes, System.Data.SqlClient.SqlDataReader data) { // Do nothing if we have nothing if (data == null) { return; } // Create a local variable for the new instance. FNMCommunityLendingProductType newobj = null; // Iterate through the data reader while (data.Read()) { // Create a new object instance newobj = System.Activator.CreateInstance(fnmcommunitylendingproducttypes.ContainsType[0]) as FNMCommunityLendingProductType; // Let the instance set its own members newobj.SetMembers(ref data); // Add the new object to the collection instance fnmcommunitylendingproducttypes.Add(newobj); } }
public double GetByYear(int year) { double all = 0; List <Receipt> ReceiptList = new List <Receipt>(); Dao dao = new Dao(); try { string sqlStatement = "SELECT SUM(Total) FROM Receipt where FORMAT(PrintDate,'yyyy')= '" + year + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { all = (double)reader.GetDecimal(0); } } catch (Exception e) { return(0); } dao.Con.Close(); return(all); }
public int queryChannelMax() { SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "select max(TS_CHANNEL) as channelMax from TS_DEVICE"; System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader(); if (SDR.HasRows) { SDR.Read(); max = Convert.ToInt32(SDR["channelMax"]); } sqlcmd.Dispose(); sqlcon.Dispose(); max = max + 1; return(max); }
/// <summary> /// The object factory for a particular data collection instance. /// </summary> public virtual void CreateObjectsFromData(Dependents dependents, System.Data.SqlClient.SqlDataReader data) { // Do nothing if we have nothing if (data == null) { return; } // Create a local variable for the new instance. Dependent newobj = null; // Iterate through the data reader while (data.Read()) { // Create a new object instance newobj = System.Activator.CreateInstance(dependents.ContainsType[0]) as Dependent; // Let the instance set its own members newobj.SetMembers(ref data); // Add the new object to the collection instance dependents.Add(newobj); } }
public static List <Productor> BuscarTodos() { List <Productor> lProductor = new List <Productor>(); using (SqlConnection conn = BDConnection.obtenerCnx()) { SqlCommand comando = new SqlCommand(String.Format("Select * From Productor"), conn); System.Data.SqlClient.SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { Productor productor = new Productor(); productor.id = Int32.Parse(reader["id"].ToString()); productor.nombre = reader["nombre"].ToString(); productor.telefono = reader["telefono"].ToString(); productor.email = reader["email"].ToString(); productor.fincas = Int32.Parse(reader["fincas"].ToString()); lProductor.Add(productor); } } return(lProductor); }
/// <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 SecureKey, AccounID, LoginType, IPAddress, CreateDatetime, UsedDatetime, IsUsed FROM SecurityUserAccount_SecureKey WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _secureKey = reader.GetString(0); _accounID = reader.GetString(1); _loginType = reader.GetInt32(2); _iPAddress = reader.GetString(3); _createDatetime = reader.GetDateTime(4); _usedDatetime = reader.GetDateTime(5); _isUsed = reader.GetInt32(6); } 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 SysModID, ModuleDesc, iOrder, isDefault, PageLink, Pic, iDisplay FROM SystemModule WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _sysModID = reader.GetString(0); _moduleDesc = reader.GetString(1); _iOrder = reader.GetInt32(2); _isDefault = reader.GetInt32(3); _pageLink = reader.GetString(4); _pic = reader.GetString(5); _iDisplay = reader.GetInt32(6); } reader.Close(); } }
public IEnumerable <MISNewOthersTEMP> MISNewOthersTEMPusingparams(string status, string search) { List <MISNewOthersTEMP> obuList = new List <MISNewOthersTEMP>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //cmd.CommandText = "select * from Names where Id=@Id"; //cmd.Parameters.AddWithValue("@Id", id); con.Open(); cmd.CommandText = "select top 500 Id, State, Teamname, new_mis, old_mis, Accountofficer_code, ApprovalStatus from mis_new_others_TEMPTEMP " + "where ApprovalStatus=@STATUS and (Teamname like @searchval OR new_mis like @searchval OR old_mis like @searchval)"; cmd.Parameters.AddWithValue("@STATUS", status); cmd.Parameters.AddWithValue("@searchval", "%" + search + "%"); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var obu = new MISNewOthersTEMP(); obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0; obu.State = reader["State"] != DBNull.Value ? reader["State"].ToString() : ""; obu.Teamname = reader["Teamname"] != DBNull.Value ? reader["Teamname"].ToString() : ""; obu.new_mis = reader["new_mis"] != DBNull.Value ? reader["new_mis"].ToString() : ""; obu.old_mis = reader["old_mis"] != DBNull.Value ? reader["old_mis"].ToString() : ""; obu.Accountofficer_code = reader["Accountofficer_code"] != DBNull.Value ? reader["Accountofficer_code"].ToString() : ""; obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : ""; obuList.Add(obu); } con.Close(); } return(obuList); }
static public string SelectRowsByCategory(int User_id) { using (var command = new QC.SqlCommand()) { using (var connection = new QC.SqlConnection("Data Source=LENOVO-PC;Initial Catalog=DB_CourceProject;Integrated Security=True;" )) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); connection.Open(); command.Connection = connection; command.CommandType = DT.CommandType.Text; command.CommandText = $@"select name_category, sum(amount) from costs where user_id = {User_id} group by name_category"; QC.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { sb.Append("").Append(String.Format("\n{0}\t{1} ", reader.GetValue(0), reader.GetDouble(1))); } string str = sb.ToString(); if (String.IsNullOrEmpty(str)) { return(String.Format("Пока что список твоих трат по этой категории пуст\nотправь мне фотографию чека.")); } else { return(str); } } } }
public IEnumerable <IncomeAccountsTreeAccountTEMP> IncomeAccountsTreeAccountTEMPusingparams(string status, string search) { List <IncomeAccountsTreeAccountTEMP> obuList = new List <IncomeAccountsTreeAccountTEMP>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //cmd.CommandText = "select * from Names where Id=@Id"; //cmd.Parameters.AddWithValue("@Id", id); con.Open(); //cmd.CommandText = "select top 500 Id, accountnumber, mis, AccountOfficer_Code, ApprovalStatus from Income_accountMIS_Override_TEMP " + // "where ApprovalStatus=@STATUS and (accountnumber like @searchval OR mis like @searchval OR AccountOfficer_Code like @searchval)"; //cmd.Parameters.AddWithValue("@STATUS", status); cmd.CommandText = "select top 1000 * from Income_accountMIS_Override_TEMP " + "where ApprovalStatus=@STATUS and (accountnumber like @searchval OR ExpirationPeriod = @searchval OR ExpirationYear = @searchval)"; cmd.Parameters.AddWithValue("@searchval", "%" + search + "%"); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var obu = new IncomeAccountsTreeAccountTEMP(); obu.ID = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0; obu.AccountNumber = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : ""; obu.ShareReason = reader["ShareReason"] != DBNull.Value ? reader["ShareReason"].ToString() : ""; obu.ExpirationPeriod = reader["ExpirationPeriod"] != DBNull.Value ? Int32.Parse(reader["ExpirationPeriod"].ToString()) : 0; obu.ExpirationYear = reader["ExpirationYear"] != DBNull.Value ? Convert.ToInt32(reader["ExpirationYear"].ToString()) : 0; obuList.Add(obu); } con.Close(); } return(obuList); }
public void showSonNode(System.Windows.Forms.TreeNode currentNode) { System.Windows.Forms.TreeNode treeNode; string sonNodeName; SqlCommand sqlcmd = new SqlCommand(); Tools.DataBase db1 = new Tools.DataBase(); SqlConnection sqlcon = db1.getConnection(); sqlcon.Open(); sqlcmd.Connection = sqlcon; string last = ""; if (currentNode.Name == "agentGroup") { sqlcmd.CommandText = "select [TS_GROUP_NAME] as nodeId from [TS_AGENT_GROUP] order by TS_GROUP_ID"; last = "组"; } System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader(); while (SDR.Read()) { // SDR.NextResult(); sonNodeName = SDR["nodeId"].ToString(); treeNode = new System.Windows.Forms.TreeNode(sonNodeName); treeNode.Name = currentNode.Name + "<" + sonNodeName; treeNode.Text = sonNodeName + last; if (!currentNode.Nodes.ContainsKey(treeNode.Name)) { currentNode.Nodes.Add(treeNode); } } sqlcmd.Dispose(); sqlcon.Dispose(); }
/// <summary> /// Get the number of upcoming birthdays for all activated friends /// </summary> internal static int GetFriendsBirthdays(Guid userId, Business.Dialog dialog) { int friendsBirthdayCount = 0; SqlConnectionHelper sqlConnection = new SqlConnectionHelper(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandType = CommandType.StoredProcedure; sqlConnection.Command.CommandText = "hisp_UserFriend_GetBirthdates"; sqlConnection.Command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.UniqueIdentifier)); sqlConnection.Command.Parameters["@UserId"].Value = userId; sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { try { DateTime birthDate = (DateTime)sqlDataReader["UPD_Birthday"]; DateTime birthDay = new DateTime(DateTime.Now.Year, birthDate.Month, birthDate.Day); TimeSpan daysUntilBirthday = birthDay - new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59); if (daysUntilBirthday.TotalDays > 0 && daysUntilBirthday.TotalDays <= 1) { friendsBirthdayCount++; } } catch { } } sqlDataReader.Close(); } finally { sqlConnection.Close(); } return(friendsBirthdayCount); }
private void MainForm_Load(object sender, EventArgs e) { using (LoginDatabase login = new LoginDatabase(_myConnectionString)) { login.ShowDialog(); _myConnectionString = login._connectionString; _user = login._userName; _server = login._server; } string getDatabaseName = "SELECT Name FROM Master..SysDatabases"; try { using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(_myConnectionString)) { conn.Open(); using (System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(getDatabaseName, conn)) { using (System.Data.SqlClient.SqlDataReader dr = command.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { databaseList.Add(dr["name"].ToString()); } } } } } this.cmb_CurrentDatabase.Items.AddRange(databaseList.ToArray()); this.cmb_SourceDatabase.Items.AddRange(databaseList.ToArray()); this.toolScriptUser.Text = "用户: " + _user; this.Text = this.Text + "[" + _server + "] - DataToy"; } catch { } }
public IEnumerable <Project> SelProject(int ProjectID = -1) { int intRC = 0; objProjects = new List <Project>(); IParameterFactory objParams = new ProjectsParameterFactory(ProjectID: ProjectID, ProjectName: ProjectName); System.Data.SqlClient.SqlCommand objCmd = new SqlCommand("pSelProjects", new ADOConnectionFactory().Connection); objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.Add(objParams.Parmeters["RC"]); objCmd.Parameters.Add(objParams.Parmeters["ProjectID"]); try { objCmd.Connection.Open(); System.Data.SqlClient.SqlDataReader objDR = objCmd.ExecuteReader(); while (objDR.Read()) { Project objP = new Project(); objP.intProjectID = (int)objDR["ProjectID"]; objP.strProjectName = (string)objDR["ProjectName"]; objP.strProjectDescription = (string)objDR["ProjectDescription"]; ((List <Project>)objProjects).Add(objP); } objDR.Close(); //You cannot get the return value if the reader is not closed! intRC = (int)objParams.Parmeters["RC"].Value; if (intRC < 0) { throw new Exception("Error reported in Stored Procedure: " + objParams.Parmeters["RC"].Value.ToString()); } objCmd.Connection.Close(); } catch (Exception) { throw; } return(objProjects); }
private void CreatePLMParameterModes(int plmId, int userId, System.Data.SqlClient.SqlCommand command) { List <BusinessLogic.Json.PlmParameterModeInfo> modes = new List <BusinessLogic.Json.PlmParameterModeInfo>(); string sql = "SELECT Id, DefaultHostSpeedId, DefaultPowerId FROM PLMParameterModeType WHERE (Id NOT IN (SELECT Id FROM PLMParameterMode WHERE (PLMId = " + plmId + ")))"; command.CommandText = sql; System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { BusinessLogic.Json.PlmParameterModeInfo mode = new Durados.Web.Mvc.Specifics.SanDisk.Allegro.BusinessLogic.Json.PlmParameterModeInfo(); mode.Id = reader.GetInt32(reader.GetOrdinal("Id")); if (!reader.IsDBNull(reader.GetOrdinal("DefaultHostSpeedId"))) { mode.DefaultHostSpeedId = reader.GetInt32(reader.GetOrdinal("DefaultHostSpeedId")); } if (!reader.IsDBNull(reader.GetOrdinal("DefaultPowerId"))) { mode.DefaultPowerId = reader.GetInt32(reader.GetOrdinal("DefaultPowerId")); } modes.Add(mode); } reader.Close(); foreach (BusinessLogic.Json.PlmParameterModeInfo mode in modes) { sql = "insert into PLMParameterMode (PLMId, PLMParameterModeTypeId" + (mode.DefaultHostSpeedId.HasValue ? ",HostSpeedId" : "") + (mode.DefaultPowerId.HasValue ? ",PowerId" : "") + ") values (" + plmId + "," + mode.Id + (mode.DefaultHostSpeedId.HasValue ? "," + mode.DefaultHostSpeedId.Value : "") + (mode.DefaultPowerId.HasValue ? "," + mode.DefaultPowerId.Value : "") + "); SELECT IDENT_CURRENT('[PLMParameterMode]') AS ID"; command.CommandText = sql; int id = Convert.ToInt32(command.ExecuteScalar()); sql = "insert into durados_ChangeHistory (ViewName, PK, ActionId, UpdateUserId) values ('PLMParameterMode', '" + id + "', 1, " + userId + ")"; command.CommandText = sql; command.ExecuteNonQuery(); } }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { TestSprocGenerator.Data.SingleTable.Dto.Suppliers dto; using (reader) { while (reader.Read()) { dto = new TestSprocGenerator.Data.SingleTable.Dto.Suppliers(); dto.CompanyName = _baseDatabase.resolveNullString(reader.GetOrdinal("CompanyName"), reader); dto.ContactName = _baseDatabase.resolveNullString(reader.GetOrdinal("ContactName"), reader); dto.ContactTitle = _baseDatabase.resolveNullString(reader.GetOrdinal("ContactTitle"), reader); dto.Address = _baseDatabase.resolveNullString(reader.GetOrdinal("Address"), reader); dto.City = _baseDatabase.resolveNullString(reader.GetOrdinal("City"), reader); dto.Region = _baseDatabase.resolveNullString(reader.GetOrdinal("Region"), reader); dto.PostalCode = _baseDatabase.resolveNullString(reader.GetOrdinal("PostalCode"), reader); dto.Country = _baseDatabase.resolveNullString(reader.GetOrdinal("Country"), reader); dto.Phone = _baseDatabase.resolveNullString(reader.GetOrdinal("Phone"), reader); dto.Fax = _baseDatabase.resolveNullString(reader.GetOrdinal("Fax"), reader); dto.HomePage = _baseDatabase.resolveNullString(reader.GetOrdinal("HomePage"), reader); dto.SupplierID = _baseDatabase.resolveNullInt32(reader.GetOrdinal("SupplierID"), reader); this.Add(dto); } } }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { TestSprocGenerator.Data.SingleTable.Dto.Person_Address dto; using (reader) { while (reader.Read()) { dto = new TestSprocGenerator.Data.SingleTable.Dto.Person_Address(); dto.Person_AddressID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("Person_AddressID"), reader); dto.Deleted = _baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader); dto.InsertedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader); dto.ModifiedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader); dto.PersonID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("PersonID"), reader); dto.AddressID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("AddressID"), reader); this.Add(dto); } } }
//================ methods to call starts IncomeNewDetails ========================================== public IEnumerable <IncomeRetailProductOverrideTEMP> IncomeRetailProductOverrideTEMP(string status) { List <IncomeRetailProductOverrideTEMP> obuList = new List <IncomeRetailProductOverrideTEMP>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //cmd.CommandText = "select * from Names where Id=@Id"; //cmd.Parameters.AddWithValue("@Id", id); con.Open(); //cmd.CommandText = "select top 500 * from Income_RetailProduct_Override_TEMP where ApprovalStatus=@STATUS"; cmd.CommandText = "select top (@TAKETOP) * from Income_RetailProduct_Override_TEMP where ApprovalStatus=@STATUS"; cmd.Parameters.AddWithValue("@STATUS", status); cmd.Parameters.AddWithValue("@TAKETOP", taketop); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var obu = new IncomeRetailProductOverrideTEMP(); obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0; obu.Customerid = reader["Customerid"] != DBNull.Value ? int.Parse(reader["Customerid"].ToString()) : 0; obu.Bank = reader["Bank"] != DBNull.Value ? reader["Bank"].ToString() : ""; obu.Mis_code = reader["Mis_code"] != DBNull.Value ? reader["Mis_code"].ToString() : ""; obu.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : ""; obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : ""; obuList.Add(obu); } con.Close(); } return(obuList); }
private void textBoxSearch_TextChanged(object sender, EventArgs e) { if (radioButton1.Checked == true) { List <String> productlist = new List <string>(); sqlconnectionclass selecttousers = new sqlconnectionclass(); DR = selecttousers.ReadDB("select * from Products where ProductName like '%" + textBoxSearch.Text + "%' and itemtype='SI'"); while (DR.Read()) { productlist.Add(DR[0] + ":" + DR[1]); } listBox1.DataSource = productlist; } else if (radioButton3.Checked == true) { List <String> productlist = new List <string>(); sqlconnectionclass selecttousers = new sqlconnectionclass(); DR = selecttousers.ReadDB("select * from Products where ProductNo like '%" + textBoxSearch.Text + "%' and itemtype='SI'"); while (DR.Read()) { productlist.Add(DR[0] + ":" + DR[1]); } listBox1.DataSource = productlist; } else if (radioButton2.Checked == true) { List <String> productlist = new List <string>(); sqlconnectionclass selecttousers = new sqlconnectionclass(); DR = selecttousers.ReadDB("select * from Products where barcode like '%" + textBoxSearch.Text + "%' and itemtype='SI'"); while (DR.Read()) { productlist.Add(DR[0] + ":" + DR[1]); } listBox1.DataSource = productlist; } }
public String[] Reminder_Shower() { System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(); sc.ConnectionString = @"Server =Localhost;Database=TeamProject;Trusted_Connection=Yes;"; sc.Open(); System.Data.SqlClient.SqlCommand insert; String query = "SELECT Description from Reminder as re, Jurisdiction as ju where ju.JurisdictionID = re.JurisdictionID AND DateType = '" + DateType + "' AND county = '" + County + "' AND Court = '" + Court + "';"; insert = new System.Data.SqlClient.SqlCommand(query, sc); System.Data.SqlClient.SqlDataReader dataReader = insert.ExecuteReader(); String[] reminderList = new string[3]; int counter = 0; while (dataReader.Read()) { reminderList[counter] = Convert.ToString(dataReader[0]); counter++; } return(reminderList); }
/// <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 ContactID, ContactName, Title, Tel1, Tel2, Tel3, EMail, Memo FROM SecurityGroup_Contact WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _contactID = reader.GetInt32(0); _contactName = reader.GetString(1); _title = reader.GetString(2); _tel1 = reader.GetString(3); _tel2 = reader.GetString(4); _tel3 = reader.GetString(5); _eMail = reader.GetString(6); _memo = reader.GetString(7); } reader.Close(); } }
static public string SelectRowsByDates(int User_id) { using (var command = new QC.SqlCommand()) { using (var connection = new QC.SqlConnection("Data Source=LENOVO-PC;Initial Catalog=DB_CourceProject;Integrated Security=True;")) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); connection.Open(); command.Connection = connection; command.CommandType = DT.CommandType.Text; command.CommandText = $@"SELECT dt, amount FROM costs WHERE user_id = {User_id} ORDER BY dt DESC;"; QC.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { sb.Append("").Append(String.Format("\n{0}\t{1} Р", reader.GetDateTime(0), reader.GetDouble(1))); } command.CommandText = null; string str = sb.ToString(); sb.Clear(); if (String.IsNullOrEmpty(str)) { return(String.Format("Пока что список твоих трат пуст\nотправь мне фотографию чека.")); } else { return(str); } } } }
public string gerarFatura(string param1, string param2, string param3) { string url = "Sorry.aspx"; string idfat = ""; OperacaoBanco operacao = new OperacaoBanco(); bool inserir = operacao.Insert("insert into Tbl_Faturas (ID_Cliente,Quant,Valor_Total,Data_Fatura,Status_Pagam) values " + "(" + param1 + ", " + param2 + " , " + param3 + " , dateadd(hh,-3,getdate()) , 'Em Aberto' ) "); ConexaoBancoSQL.fecharConexao(); if (inserir == true) { //obtem o numero da fatura criada string stringselect = "select ID_Fatura from Tbl_Faturas " + " where ID_Cliente = " + param1 + " order by ID_Fatura desc"; OperacaoBanco operacao1 = new OperacaoBanco(); System.Data.SqlClient.SqlDataReader dados = operacao1.Select(stringselect); while (dados.Read()) { idfat = Convert.ToString(dados[0]); break; } ConexaoBancoSQL.fecharConexao(); //define as entregas como pertencentes a fatura recem criada OperacaoBanco operacao2 = new OperacaoBanco(); bool alterar = operacao2.Update("update Tbl_Entregas_Master set " + "ID_Fatura = " + idfat + " where ID_Cliente = " + param1 + " and ID_Fatura = 0 and Forma_Pagam = 'Faturado'"); ConexaoBancoSQL.fecharConexao(); url = "Faturas_Gerar.aspx"; } return(url); }
public CustomerDeviceRelations ReturnRelations(int id) { CustomerDeviceRelations a = new CustomerDeviceRelations(); System.Data.SqlClient.SqlDataReader reader = null; string strSQL = "SELECT * FROM CustomerDeviceRelations WHERE ID = @id"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSQL, conn); cmd.Parameters.AddWithValue("@id", id); reader = cmd.ExecuteReader(); if (reader.Read()) { a.ID = reader.GetInt32(0); a.Customer_ID = reader.GetInt32(1); a.Device_ID = reader.GetInt32(2); return(a); } else { return(null); } }
protected void approveStudentLinkBtn_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = GridView1.Rows[rowIndex]; int applicationID = Convert.ToInt32(e.CommandArgument); Session["selectedapplicationID"] = applicationID.ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT ApplicationRequest.ApplicationID, Student.FirstName + ' ' + Student.LastName AS FullName, JobListing.JobTitle, Organization.OrganizationName FROM ApplicationRequest INNER JOIN JobListing ON ApplicationRequest.JobListingID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID WHERE ApplicationRequest.ApplicationID = " + Session["selectedapplicationID"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { StudentApproveLabel.Text = reader.GetString(1); StudentSubApproveLabel.Text = reader.GetString(2); Student2ndSubApproveLabel.Text = reader.GetString(3); } sql.Close(); ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveXModal();", true); }
public Device ReturnDevice(int id) { Device a = new Device(); System.Data.SqlClient.SqlDataReader reader = null; string strSQL = "SELECT * FROM Device WHERE ID = @id"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSQL, conn); cmd.Parameters.AddWithValue("@id", id); reader = cmd.ExecuteReader(); if (reader.Read()) { a.ID = reader.GetInt32(0); a.Type = reader.GetString(1); a.Name = reader.GetString(2); a.UUID = reader.GetString(3); a.MAC = reader.GetString(4); return(a); } else { return(null); } }
private void Passbook() { Console.Clear(); Center("**** Alif Bank | Моя Книжка ****\n"); Console.BackgroundColor = ConsoleColor.DarkGreen; Console.WriteLine("|{0}|", Text(5, "Сумма Сделки |" + " Время и Дата совершения сделки |" + " Описание транзакции")); Console.WriteLine("|{0}|", Text(0, "|".PadLeft(28) + "|".PadLeft(37))); System.Data.SqlClient.SqlDataReader dataReader = User.ReadPassbook(); while (dataReader.Read()) { int Length = dataReader.GetValue(1).ToString().Length; int DescLength = dataReader.GetValue(3).ToString().Length; string Amount = dataReader.GetValue(1).ToString(), DateAndTime = dataReader.GetValue(2).ToString().PadLeft(27).PadRight(36), Description = dataReader.GetValue(3).ToString().PadLeft(DescLength + 8); Console.WriteLine("|{0}|", Text(9, "Tj. " + Amount.PadRight(((14 - Length) + Length)) + "|" + DateAndTime + "|" + Description)); } Console.WriteLine("|{0}|", Text(0, "|".PadLeft(28) + "|".PadLeft(37))); Console.BackgroundColor = ConsoleColor.Black; Console.WriteLine("\n"); Center("Нажмите любую клавишу, чтобы вернуться в предыдущее меню!"); dataReader.Close(); }
private int Get_OFID(String county, String court) { System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(); sc.ConnectionString = @"Server =Localhost;Database=TeamProject;Trusted_Connection=Yes;"; sc.Open(); System.Data.SqlClient.SqlCommand insert; String query = "select JurisdictionID from Jurisdiction where DateType = 'None' AND county = '" + county + "' AND Court = '" + court + "';"; insert = new System.Data.SqlClient.SqlCommand(query, sc); System.Data.SqlClient.SqlDataReader dataReader = insert.ExecuteReader(); int ofID = 0; while (dataReader.Read()) { ofID = Convert.ToInt32(dataReader[0]); } sc.Close(); return(ofID); }