There is probably a log file somewhere. You should find it and see what the real error is.

pls some body help.......

Presumably you are not asking how to create a file on the SQL Server file system itself given that you do not have access to that file system. So.... Steps 1. Connect to SQL Server 2. Query for xml 3. Open file 4. Read xml 5. Write xml to file. 6. Continue 4 and 6 until all of the xml is read. 7. Close the connection and the file. The above are distinct parts of the total problem.

To set the value of a CheckBoxCell you need to cast it specifically like this: (dataRow.Cells["your cell index"] as DataGridViewCheckBoxCell).Value = true; This presumes dataRow is your current datagridview row. Hope this helps ...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....

Manish_84 wrote: I call a third Form by clicking a button using ShowDialog() placed in MDI Child. I like to refresh MDI Child after closing that third Form... The ShowDialog method is blocking; you can refresh your MDI child right after the line where you show the dialog. Once the dialog is closed, execution will continue there. Manish_84 wrote: Give the solution... :) I are Troll :suss:

But why use a stored procedure at all? Just do the same thing but in regular code.

Use Print(sql) to have a full customized query. Regards, Hiren. "We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made." - Einstein Microsoft Dynamics CRM

Manish_84 wrote: Convert Image field in Varbinary(Max) It'd be 'sweet' if you could create a hash to represent your image, and store that in a column next to the image itself :) I are Troll :suss:

AA503 is the model Number of the device, thx...

If the databases are both Sql Server (and maybe some others) you can use an INSERT/SELECT statement. You can get a DataReader from the source database, and perform inserts on the destination database. If you do it enough you can write a Windows Service to copy the data. I've had to do that in the past for a data warehousing project.

Manish_84 wrote: 24 hrs to generation commission :wtf: For that few of rows, there is no way it should take that long. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

I believe no one can help without seeing the error message or the stored procedure you have. Would you mind posting that?

Restart your pc :)

Yes. I am also confused from his post :confused: Cheers ! Abhijit Codeproject MVP

You could alos try a third paty control such as the Infragistics UltraWebGrid[^] which has a LoadOnDemand capability and is pretty simple to use. Here: Load On Demand in WebGrid 2[^]. An old article but you get the idea. Tychotics: take us back to the moon "Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars." H. G. Wells

since you are using C#, this is how it will work Response.Redirect(@"~/MemberInfo/UserFrontPage.aspx"); or Response.Redirect("~//MemberInfo//UserFrontPage.aspx"); and not Response.Redirect("~/MemberInfo/UserFrontPage.aspx"); Hope it's helpful? Tunsten