Ttykuu

Go Pregnant or Go Home

Products and sum of cubes in Fibonacci

Applicability of Single Responsibility Principle

Are there any comparative studies done between Ashtavakra Gita and Buddhim?

when is out of tune ok?

Generic lambda vs generic function give different behaviour

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

What's a natural way to say that someone works somewhere (for a job)?

Teaching indefinite integrals that require special-casing

The plural of 'stomach"

Print name if parameter passed to function

Everything Bob says is false. How does he get people to trust him?

How do I define a right arrow with bar in LaTeX?

Finding all intervals that match predicate in vector

Do there exist finite commutative rings with identity that are not Bézout rings?

Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?

Ways to speed up user implemented RK4

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

Why are on-board computers allowed to change controls without notifying the pilots?

What is difference between behavior and behaviour

Why is delta-v is the most useful quantity for planning space travel?

Will it be accepted, if there is no ''Main Character" stereotype?

apt-get update is failing in debian

Why does John Bercow say “unlock” after reading out the results of a vote?

Retrieving information about a vendor using MySQL

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$

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|improve this question

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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$

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|improve this question

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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$

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|improve this question

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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|improve this question

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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|improve this question

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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.

edited 6 mins ago

200_success

130k17155419

edited 6 mins ago

200_success

130k17155419

asked 48 mins ago

Vish GuerreroVish Guerrero

12

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 48 mins ago

Vish GuerreroVish Guerrero

12