Vwwxrf

Is it okay / does it make sense for another player to join a running game of Munchkin?

voltage of sounds of mp3files

Tiptoe or tiphoof? Adjusting words to better fit fantasy races

How do I keep an essay about "feeling flat" from feeling flat?

What's the purpose of "true" in bash "if sudo true; then"

What are the ramifications of creating a homebrew world without an Astral Plane?

Can somebody explain Brexit in a few child-proof sentences?

Displaying the order of the columns of a table

Can criminal fraud exist without damages?

Can I use my Chinese passport to enter China after I acquired another citizenship?

What is the oldest known work of fiction?

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

Understanding "audieritis" in Psalm 94

Failed to fetch jessie backports repository

Coordinate position not precise

Have I saved too much for retirement so far?

Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past

Personal Teleportation as a Weapon

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

Is there a good way to store credentials outside of a password manager?

Can a monster with multiattack use this ability if they are missing a limb?

How to be diplomatic in refusing to write code that breaches the privacy of our users

What would be the benefits of having both a state and local currencies?

There is only s̶i̶x̶t̶y one place he can be

Making code more flexible

Make this C# code more DRYIn need of some aid in regards to making my code more efficientHow can I make this piece of code more secure?Making adding to a dictionary more efficient?FormBuilder Code Make More GenereicMaking operations more dynamicFlexible socket frameworkMaking generic code when using large EnumsFlexible TCP socket frameworkMaking TypeNameHandling in json.net more convenient

0

$begingroup$

Basically, I am loading some information about the selected vendor using mysql query. I made a method with a List as return type, then created another method to assign values coming from a list. I am wondering if there is a better way of doing things.

P.S. The vendorCrud object is a database helper.

 private List<string> GetVendorInformation(string vendorId)
 
 crud vendorCrud = new crud();
 List<string> columnData = new List<string>();

 string query = String.Format("SELECT tin, email_add, fax_no, tel_no, contact.contact_person FROM lib_inv_vendor vendor " +
 "LEFT JOIN lib_inv_vendor_contact_person contact ON vendor.vendor_id = contact.vendor_id " +
 "WHERE vendor.vendor_id = 0 ORDER BY contact_default DESC LIMIT 1", vendorId);

 vendorCrud.load_data(query, Modules.connection.filesetupDB1, CommandType.Text);

 foreach (DataRow item in vendorCrud.table.Rows)
 
 columnData.Add(item["tin"].ToString());
 columnData.Add(item["email_add"].ToString());
 columnData.Add(item["fax_no"].ToString());
 columnData.Add(item["tel_no"].ToString());
 columnData.Add(item["contact_person"].ToString());
 

 return columnData;
 

 private void SetVendorInformation(List<string> colData)
 
 txtVendorTin.EditValue = colData[0];
 txtEmail.EditValue = colData[1];
 txtFaxNo.EditValue = colData[2];
 txtTelNo.EditValue = colData[3];
 txtAttention.EditValue = colData[4];
 

 private void txtSupplier_EditValueChanged(object sender, EventArgs e)
 
 SetVendorInformation(GetVendorInformation(txtSupplier.EditValue.ToString()));
 

c# mysql

share

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

add a comment | 

0

$begingroup$

Basically, I am loading some information about the selected vendor using mysql query. I made a method with a List as return type, then created another method to assign values coming from a list. I am wondering if there is a better way of doing things.

P.S. The vendorCrud object is a database helper.

 private List<string> GetVendorInformation(string vendorId)
 
 crud vendorCrud = new crud();
 List<string> columnData = new List<string>();

 string query = String.Format("SELECT tin, email_add, fax_no, tel_no, contact.contact_person FROM lib_inv_vendor vendor " +
 "LEFT JOIN lib_inv_vendor_contact_person contact ON vendor.vendor_id = contact.vendor_id " +
 "WHERE vendor.vendor_id = 0 ORDER BY contact_default DESC LIMIT 1", vendorId);

 vendorCrud.load_data(query, Modules.connection.filesetupDB1, CommandType.Text);

 foreach (DataRow item in vendorCrud.table.Rows)
 
 columnData.Add(item["tin"].ToString());
 columnData.Add(item["email_add"].ToString());
 columnData.Add(item["fax_no"].ToString());
 columnData.Add(item["tel_no"].ToString());
 columnData.Add(item["contact_person"].ToString());
 

 return columnData;
 

 private void SetVendorInformation(List<string> colData)
 
 txtVendorTin.EditValue = colData[0];
 txtEmail.EditValue = colData[1];
 txtFaxNo.EditValue = colData[2];
 txtTelNo.EditValue = colData[3];
 txtAttention.EditValue = colData[4];
 

 private void txtSupplier_EditValueChanged(object sender, EventArgs e)
 
 SetVendorInformation(GetVendorInformation(txtSupplier.EditValue.ToString()));
 

c# mysql

share

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

add a comment | 

$begingroup$

Basically, I am loading some information about the selected vendor using mysql query. I made a method with a List as return type, then created another method to assign values coming from a list. I am wondering if there is a better way of doing things.

P.S. The vendorCrud object is a database helper.

 private List<string> GetVendorInformation(string vendorId)
 
 crud vendorCrud = new crud();
 List<string> columnData = new List<string>();

 string query = String.Format("SELECT tin, email_add, fax_no, tel_no, contact.contact_person FROM lib_inv_vendor vendor " +
 "LEFT JOIN lib_inv_vendor_contact_person contact ON vendor.vendor_id = contact.vendor_id " +
 "WHERE vendor.vendor_id = 0 ORDER BY contact_default DESC LIMIT 1", vendorId);

 vendorCrud.load_data(query, Modules.connection.filesetupDB1, CommandType.Text);

 foreach (DataRow item in vendorCrud.table.Rows)
 
 columnData.Add(item["tin"].ToString());
 columnData.Add(item["email_add"].ToString());
 columnData.Add(item["fax_no"].ToString());
 columnData.Add(item["tel_no"].ToString());
 columnData.Add(item["contact_person"].ToString());
 

 return columnData;
 

 private void SetVendorInformation(List<string> colData)
 
 txtVendorTin.EditValue = colData[0];
 txtEmail.EditValue = colData[1];
 txtFaxNo.EditValue = colData[2];
 txtTelNo.EditValue = colData[3];
 txtAttention.EditValue = colData[4];
 

 private void txtSupplier_EditValueChanged(object sender, EventArgs e)
 
 SetVendorInformation(GetVendorInformation(txtSupplier.EditValue.ToString()));
 

c# mysql

share

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

 private List<string> GetVendorInformation(string vendorId)
 
 crud vendorCrud = new crud();
 List<string> columnData = new List<string>();

 string query = String.Format("SELECT tin, email_add, fax_no, tel_no, contact.contact_person FROM lib_inv_vendor vendor " +
 "LEFT JOIN lib_inv_vendor_contact_person contact ON vendor.vendor_id = contact.vendor_id " +
 "WHERE vendor.vendor_id = 0 ORDER BY contact_default DESC LIMIT 1", vendorId);

 vendorCrud.load_data(query, Modules.connection.filesetupDB1, CommandType.Text);

 foreach (DataRow item in vendorCrud.table.Rows)
 
 columnData.Add(item["tin"].ToString());
 columnData.Add(item["email_add"].ToString());
 columnData.Add(item["fax_no"].ToString());
 columnData.Add(item["tel_no"].ToString());
 columnData.Add(item["contact_person"].ToString());
 

 return columnData;
 

 private void SetVendorInformation(List<string> colData)
 
 txtVendorTin.EditValue = colData[0];
 txtEmail.EditValue = colData[1];
 txtFaxNo.EditValue = colData[2];
 txtTelNo.EditValue = colData[3];
 txtAttention.EditValue = colData[4];
 

 private void txtSupplier_EditValueChanged(object sender, EventArgs e)
 
 SetVendorInformation(GetVendorInformation(txtSupplier.EditValue.ToString()));
 

share

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

Vish GuerreroVish Guerrero

11

New contributor

Vish Guerrero is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

Vish GuerreroVish Guerrero

11