Comments by The Praveen Singh (Top 48 by date)

you mean common id data like 1 and 3 in a single datagrid.

use group by with oeShift.

check id of your textbox after inspecting in master page this will be changed as text box id, master page appends something like this:-ctl00$cpMainContent$ check and change in your case.

in your excel there is 11 colomn and in your loop you have set 7.

where is the code ..

put debug on cmd.CommandType = CommandType.Text; see what is the final query is made run it over SQL and Finds where the mistake.

how to get only 5,6,7 from "copkshopno in ('5,6,7') and"

sure i have store all value in variable after that i used your code this will return like this copkshopno in ('5') and copkshopno in ('1','2','3','4')

and I can't use OR operator here due to dependency of Other params.

this will return like this copkshopno in ('5') and copkshopno in ('1','2','3','4')

which does not provide expected result because of AND operator.

before second parameter came Value look like copkshopno in ('5') and i want to append a String value='1,2,3' into in operator after 5.

yes

this is contains Value of Textbox.

yes

//here ConnectedField return Param Names.

if (whereCondition.Contains((ctrlParam as DNTextBox).ConnectedField))
{
//here i want to apend.
}

pnl.Controls.CopyTo(arrCtrl, 0);
string whereCondition = string.Empty;
string SelectedValue = "";
//bool selectShop = false;
List<control> list = new List<control>(arrCtrl);
foreach (HtmlControl genParam in list.FindAll(p => { return (p is HtmlGenericControl); }))
{
if ((ctrlParam as DNTextBox).InputTable.ToLower() == "tashop")
{
whereCondition += (ctrlParam as DNTextBox).ConnectedField + " in ('" + string.Join("','", (ctrlParam as DNTextBox).Text.Replace(",", "','")) + "') and ";
}
if ((ctrlParam as DNTextBox).InputTable.ToLower() == "tashopgroups")
{
string selectItems = Parameters.getShopGroup(string.Join("','", (ctrlParam as DNTextBox).Text));
//Select items returns shop no on the basis of shop group which i want to append
if (selectItems == "")
{
string value = XYX.GUI.MultiLanguage.DNMultiLanguage.GetMessage("noshopfound");
string sccript = "<script>alertify.alert('" + value + "');</script>";
Page.ClientScript.RegisterStartupScript(GetType(), "key", sccript);
return;
}
}

}

@Karthik Actually you don't undersatnd what i exactly want to ask:-
whereCondition += (ctrlParam as DNTextBox).ConnectedField + " in ('" + string.Join("','", (ctrlParam as DNTextBox).Text.Replace(",", "','")) + "') and ";
Above syntax returns "copkshopno in ('5') and"
Again through loop next param comes Shopgroup in which multiple shop were found i want to append that in my wherecondition in query for coshopno.

Install target framework 4

i did't help due to lack of Information.

Run SQL Server with Administrative Privilege.

what error you have get ??

question not clear

if can't use primary key then don't use EF because its necessary to be a primary key in table used in EF.

please explain what are you trying to ask..

you can not pass value in output parameter

use temp table with auto identity colomn

if you need freelancer to make service then contact to me on my mail praveendotnetexe@gmail.com

use service to get data

first check in your data table there should be all column name which you used on RowIndex. For eg-
dt.Rows[row.DataItemIndex]["APCUserID"] = ((Label)(row.Cells[1].Controls[0])); in dt there shuld be "APCUserID",this the only cause when error occurs as you mentioned.

because you have inserted value of your foreign key before it is exists in Table in which you have make primary key.

where is the problem or what error you get ?

Use Server side paging, also optimize your query if possible.

may be you are not close your connection object

No codes written means it is in the air..

Share what are you tried ?

what do you want to ask please clear ?

is there any error occured ?

try with Temp table

data.addRow([jsonData[i].Text, jsonData[i].Value]);
put alert before above line alert(jsonData[i].Text);
Is data comes ??

What error you have get ??