for user name,passward,servername, u can set using connection string.... and just using dataset....try this Rajendran.AL

Hi, Thanks for reply. In detail, I have designed a .rdl report using SQL Report Services 2005 in a server. I have vb.net program in my client machine to access that report. After rendering that report in client, I recieve data in byte() format. I further use file stream to write that as a PDF. Now, I want to print that to a particular printer. Here is the code. =========Code Starts Dim results As Byte() results = objReportingService.Render(m_sReportPath, sOutputFormat, HistoryId, DeviceInfo, LoadParams(), RSCredentials, ShowHideToggle, Encoding, MimeType, RSParamsUsed, RSWarnings, StreamIds) Dim fs As System.IO.FileStream fs = System.IO.File.OpenWrite(m_sFilePath) fs.Write(results, 0, results.Length) fs.Close() =========Code Ends Now the question again. I want to print that PDF file OR Is there any chance to print directly from byte array without converting into PDF? I hope its clear. Thanks Senthil

Senthil_GeoEdge wrote: At this time when I change, edited record is not updated What do yot mean by this? Are you saying that you can't change the data in the datagrid or you can't update the data in the database? How are you triggering the code to save the new data? What does the code look like that does the database access? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Senthil_GeoEdge wrote: Please tell that whether Request.Form can be used for a div tag in the code behind of an aspx page. No, you can't use Request.Form for that. The Request.Form collection contains the data that was sent from the form fields in the form that was posted. Nothing else. If you want some information to be sent to the server when posting the form, you have to put it in a form field. --- single minded; short sighted; long gone;

Perhaps it would be better to explain exactly what you are trying to do. Why do you need a dynamic query? Why do you need to create a table? If you dynamic query returns certain columns you can just return those columns in the result set and your program can read them. The only issue because how your program knows what to do with the columns. Ben

Unless you set up the global variable in the session in the global.asax session.Start event you won't exist until the first page load. Unless I am missing something here? Ben

treeview are very slow. I have not yet found the solution :( // ♫ 99 little bugs in the code, // 99 bugs in the code // We fix a bug, compile it again // 101 little bugs in the code ♫

Just execute this JS command on the client: document.print(); -------------------------------------------------------- My portfolio & development blog Q:What does the derived class in C# tell to it's parent? A:All your base are belong to us!