Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>That helps! I have it up and running now....</p> <p>public Person(int id) { </p> <pre><code> SqlConnection conn = new SqlConnection(@"Integrated Security=True; Data Source=JODIEPC\XPRESS;Initial Catalog=TEST5"); conn.Open(); SqlCommand cmd = new SqlCommand("usp_EmployeeSelect", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@emp_id", SqlDbType.Int).Value = id; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { department = dr["dept_name"].ToString(); fname = dr["emp_first_name"].ToString(); lname = dr["emp_last_name"].ToString(); email = dr["emp_email"].ToString(); phone = dr["emp_phone"].ToString(); position = dr["emp_position"].ToString(); address1 = dr["emp_address1"].ToString(); address2 = dr["emp_address2"].ToString(); city = dr["emp_city"].ToString(); state = dr["emp_state"].ToString(); postal_code = dr["emp_postal_code"].ToString(); } } protected int id; protected string fname; protected string lname; protected string department; protected string email; protected string position; protected string address1; protected string address2; protected string phone; protected string city; protected string state; protected string postal_code; public int Id { get { return id; } set { id = value; } } public string Department { get { return department; } set{ department = value; } } public string Fname { get { return fname; } set { fname = value; } } public string Lname { get { return lname; } set { lname = value; } } public string Email { get { return email; } set { email = value; } } public string Position { get { return position; } set { position = value; } } public string Address1 { get { return address1; } set { address1 = value; } } public string Address2 { get { return address2; } set { address2 = value; } } public string Phone { get { return phone; } set { phone = value; } } public string City { get { return city; } set { city = value; } } public string State { get { return state; } set { state = value; } } public string Postal_Code { get { return postal_code; } set { postal_code = value; } } } </code></pre> <p>---------winform--------------- private void btnSearch_Click(object sender, EventArgs e) { Person Emp = new Person(Int32.Parse(txtId.Text)); txtFirstName.Text = Emp.Fname; txtLastName.Text = Emp.Lname; txtEmail.Text = Emp.Fname; txtPhone.Text = Emp.Phone; txtDepartment.Text = Emp.Department; txtPosition.Text = Emp.Position; txtAddress1.Text = Emp.Address1; txtAddress2.Text =Emp.Address2; txtCity.Text = Emp.City; txtState.Text = Emp.State; txtPostalCode.Text = Emp.Postal_Code; } } It's not the most creative way of going about it but it works....</p> <p>Thanks alot guys.... </p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I populate the data from my Stored Procedure into my winform?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJodie ThatOne Guy Logan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload