Comments by Riya-Pandey (Top 38 by date)

Did that. Result is the same. :'(

I have tried that. Console doesn't shows any error. I am using firebug

yes. in case of download it doesn't disappears but in case of load it does. No error on console.

<script type="text/javascript">

$(document).ready(function () {
$.ajax({
url: 'MYService.asmx/GetID',
type: 'post',
data: { clientid: "<%= Session["clientId"]%>" },
dataType: "json",
success: function (serverdata) {
$('#datatable').dataTable({
data: serverdata,
columns: [
{ 'data': 'ID' },
{ 'data': 'Description' },
{ 'data': 'Deleted' },
]
});
}
});
});



</script>



this is the code from service


public void GetID(int ClientId)
{
string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
List<client> lst = new List<client>();
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select [ID], [Description],[Deleted] from [Client] where [ClientId]=@ClientId";
cmd.Parameters.AddWithValue("@ClientId", ClientId);
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Client client = new Client ();
client.Id = dr["ID"].ToString();
client.Description = dr["Description"].ToString();
client.Deleted = (bool) (dr["Deleted"]);
lst.Add(client);
}

}

JavaScriptSerializer JSS = new JavaScriptSerializer();
Context.Response.Write(JSS.Serialize(lst));
}

I read the Articles that you provided . although it was not helpful for the current problem yet gaining some insight as to how things work is always helpful. Thank you

i am binding to a table. table only has header
<table id="datatable">
<thead>
<tr>
<td>
ID
</td>
<td>
Description
</td>
<td>
Deleted
</td>
</tr>
</thead>
</table>

Now if i bind it directly then it shows checkbox but if i bind it using json for that i have to serialize the the list of client and when adding data to client i have to convert it to boolean. so it's showing true false under delete column where as i want checkbox

i am retrieving the value as boolean. in this case table is showing true / false. but i want to show checkbox [checked / uncecked] which is only possible in case of it value.

i did. Problem was with the headder. dataTable was expecting <thead> where as gridview has TH

not working. problem with syntax somewhere i think

ok. I didn't add that but it's not working even after adding the reference.

Yes. Gridview Id is correct. And yes, it's rendering all the elements correctly.

I am inserting this data into a datatable.

Yeah it really is a difficult concept. God!!!, what will happen when i try to understand multi threading. really scary stuff.
You suggested using a background Worker Process. like main method?

The order here is still unexpected. well from the solutions posted i get that we can't know the order in which windows will execute a thread.

So basically what you are saying is that we can't have a sequence in which the thread will run ??
what if i have a situation where i need thread1 to be executed before thread2 ? how will i handle that case ?

Don't remember the article or the author name...

Thanks for being so brief. But i already knew the purpose of the transaction. Actually My procedure is some 1000 lines of code so couldn't paste it here. I read in an article in code project yesterday that we should only use transaction when required i mean when inserting , updating data Using Procedure, Rest of the things should be outside the transaction. for instance say if i am calculating some value that should be outside transaction . once i have the value use open transaction do your work and immediately close it. i can always put the set value part from the example in the question inside tran and then there will be no problem coz tran will rollback. Just wanted to know is it the right practice or i should follow what i read in the article. if later then how will i know where the error occured ??

Yup. It seems so. i found another way. Thanks for the advice :)

Yes. There is one more problem that if lets say there are 10 rows in datatable
and i have 2,3,4,6,9 in the list.
Now if i start removing data according to index when the counter reaches 9
there will be only 6 rows in the table because 2,3,4,6 have been removed , also wrong entries are getting removed because as soon as 2 is deleted index 3 becomes index 2 and index 4 becomes index 3 and 4 is getting removed which is index 3 now.

I don't have the Value for the the column of the row , just the index of the row.
so i can not use X.Field !!! :'(

I was talking about finding the no of ; in 63 columns.
Ok i will do so. thanks :)

Hmm but not repeating it for 63 columns is going to be a big issue.
Anyways i have done it using a simpler method.
Thanks for your Support :)

it's working perfectly if i have only 1 ; inside ".
but in my case no of ; are not fixed inside "
SO when i increased the no of ;
the result is

France,Japan,Russia,China,"India,New-Delhi;Dwarka","NewZeland;Wellington",England
France,Japan,Russia,China,"India,New-Delhi;Dwarka","NewZeland;Wellington",England

France

Japan

Russia

China

"India

New-Delhi;Dwarka"

"NewZeland;Wellington"

England

BDW this new update code is not working. it's doing the function as splitting with ; would do.

yeah i can, but in this case i am getting csv from the client. they are sending csv and then we have to consume it to synchronize our database..
Thanks for being so patient and continuously replying to my queries. :)

but no of ; will differ for each row for each column. And there are 63 columns in the table from which csv file is generating
Also here Replace function is giving too any character literals ... :'(

Replace function is giving Error- too many character literal.
Also looking at the function i think it is designed for 1 ; inside "" whereas there can be any no of ; inside "". Sorry my mistake , i should have to be more clear while asking the question.

Thanks Rohan . It works. but i have a problem that here values positions get changed and i can't have that because i have to enter data from csv file into database. Table has 63 columns and i there can be multiple value for any of the column [I mean string with multiple ;]. SO i need these values be in order.. :'(

Nop it's returning the same result. Not Working.

Any suggestions as to how to do it ??? :)

for that i will have to find the "" first.

MyString.Split(';');

I am Getting the string from a CSV file

Thank you Mr OriginalGriff. i will work on this logic and will also try to see if it can be done some other way too. Thanks again for your help :)