Preview

advantage and disadvantage of computers

Powerful Essays
Open Document
Open Document
1350 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
advantage and disadvantage of computers
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Configuration;

namespace Loginventory
{
public partial class Home : Form
{
public Home()
{

InitializeComponent(); display(); loadTitle();

}

public void display()
{
DataTable dt = bol.sp_display().Tables[0]; dataGridView1.DataSource = dt.DefaultView;

}

DataView dv; private void loadTitle()
{
string con = ConfigurationManager.ConnectionStrings["mar"].ConnectionString; try {
SqlDataAdapter ada = new SqlDataAdapter("select prodname, price, quantity, date_purchased, per_unit from tb_productinfo", con);
DataSet ds = new DataSet();
BindingSource bs = new BindingSource(); ada.Fill(ds, "prodname"); this.dataGridView1.AutoGenerateColumns = false;
DataTable dt = ds.Tables["prodname"]; bs.DataSource = ds.Tables["prodname"]; dv = new DataView(ds.Tables["prodname"]); this.dataGridView1.DataSource = bs;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

}

private void Home_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'buyerinfos.tb_buyer' table. You can move, or remove it, as needed. this.tb_buyerTableAdapter1.Fill(this.buyerinfos.tb_buyer); // TODO: This line of code loads data into the 'nalladineDataSet4.sp_displaybuyer' table. You can move, or remove it, as needed. this.sp_displaybuyerTableAdapter.Fill(this.nalladineDataSet4.sp_displaybuyer); // TODO: This line of code loads data into the 'nalladineDataSet3.tb_buyer' table. You can move, or remove it, as needed. this.tb_buyerTableAdapter.Fill(this.nalladineDataSet3.tb_buyer); // TODO: This line of code loads data into the 'nalladineDataSet1.sp_displayprod' table. You can move, or remove it, as needed. this.sp_displayprodTableAdapter.Fill(this.nalladineDataSet1.sp_displayprod); //// TODO: This line of code

You May Also Find These Documents Helpful

  • Good Essays

    DBM380 Week 2

    • 837 Words
    • 3 Pages

    There will be seven tables in this database source system order data, customer data, corrections table data, drop ship corrections, workflow status, end system data, and comparison results table. The source system table will be comprised of columns for customer purchase order number, customer name, transmitted date, and status. The customer table will consist of columns for customer name and customer number. Corrections table will provide columns for customer purchase order number, system reference data, date received and error message. Drop ship table…

    • 837 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    # Select a primary key for each table as indicated in the provided ERD diagram.…

    • 694 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Nt1330 Unit 4

    • 1142 Words
    • 5 Pages

    4. Lynn is adding a billing table to a customer database. If she wants the database to retrieve…

    • 1142 Words
    • 5 Pages
    Good Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Entities for this database application will include a Customer, Products, Orders, Sales Rep and Shipping table. The attributes for the following tables are as follows:…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    canadian born

    • 350 Words
    • 2 Pages

    Restore your table TOWNS from recycle bin and describe it. Check what is in your recycle bin now.…

    • 350 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Simpson Case ACL

    • 651 Words
    • 10 Pages

    Question 7 Determine the customer name for any customer records you identified with the unusual transaction type. Even though customer names are not included in the sales transaction table, this table can be related to the Simpson master file table, which does include names.…

    • 651 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    The data tables, specifically the Pivot table, may be improved on by arranging the codes chronologically. This would facilitate easy…

    • 851 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The SQL command that lets you insert data into a table, one row at a time, is…

    • 1917 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    /****** Object: Database [Jeff Thompson Sr - POS 410 - IA - KVO] Script Date: 03/27/2012 09:23:56 ******/…

    • 1555 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    week 4 Discussion 1

    • 447 Words
    • 2 Pages

    When adding specific entities to a database, it's important to understand the overall concept of how these entities are affecting the rest of the database. You will need focus down on specific entities, usually the…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    07

    • 4772 Words
    • 25 Pages

    12) Data values to be added to a table are specified by using the SQL VALUES clause.…

    • 4772 Words
    • 25 Pages
    Good Essays
  • Powerful Essays

    Paper on Summation

    • 10542 Words
    • 43 Pages

    @T (Image Tag) Required for each DII record. Must be used before any @C tokens for each DII record. Each instance of a line beginning with the @T token causes Summation to create a new database record or overwrite an existing one. If the value that follows the @T line does not match an existing record number in the active table (usually either the STDTABLE or the ETABLE) then a new record with that number is created. If a record with that number already exists, Summation prompts the user to either replace that record’s existing image information or leave its image information intact. The field normally used to determine a record’s unique number is either the BEGDOC# field (for the STDTABLE) or the DOCID field (for the ETABLE). This field can be changed via OPTIONS>DEFAULTS>IMAGING>COLUMN TO HOLD IMAGE TAG but it is not recommended. If there is an input template on the database’s record number field, then the @T value must conform to the template format.…

    • 10542 Words
    • 43 Pages
    Powerful Essays
  • Satisfactory Essays

    Assign1

    • 1387 Words
    • 16 Pages

    4. Show the result of a natural join that combines the Customer and OrderTbl tables.…

    • 1387 Words
    • 16 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Computers were invented many years ago, but we began to use them recently. The technical progress is constantly developing. People always create new computer technologies. The computer has become a part of our daily life. Many people use computers at work, school, and at home, but we have not yet realized the advantages and disadvantages of the computer.…

    • 267 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    From day to day, our world has been changed gradually form one condition to other. The revolution of new ideas always comes up to the minds of every person; especially the ideas to improve technology which people need to make the living better. As result computer has been bring people certain advantages and disadvantages for people ask well.…

    • 274 Words
    • 2 Pages
    Satisfactory Essays