Hi Everyone,
(1). There are main_category_1, main_category_2, main_category_3, main_category_4, and main_category_5 in the database table. And each main_category_1 can have either "Yes" or "No" value. How can I use SQL Index for the following code (Get_Products()).
(2). Can you please re-write my SQL, so that my SQL will run faster ?
Thanks,
May
public void Get_Products()
{
// begin - dataset 1
SqlConnection con;
DataSet ds1;
string ConString;
ConString = System.Configuration.ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString;
con = new SqlConnection(ConString);
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT [display_value], [main_category_1], [product_list_image], [item_number], [item_product_description], [ ...
Go to the complete details ...