I have copied all dlls from windows folders to my website bin folder, and it worked.

I have copied all dlls from windows folders to my website bin folder, and it worked.

Thank you for your answer. However, in my situation, I can't do that because it is a server used by many people! Appreciate your time, though!

Hi, I have created a report with Report Viewer control using Visual Studio 2008 under 3.5 frame work in the local mode. However, I am trying to publish this website for public to use on Windows 2003 server. I have installed published the website with Web.Config from my machine and then executed ReportViewer.exe on this server by double clicking on it. This Report Viewer.exe was downloaded from Microsoft Report Viewer Redistributable 2005. However, so I read an article in this that I need to copy exe file from C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer\ReportViewer.exe to the server. I did the same, but I do not see same directory path on the server. It does not have no subdirecties from BootStrapper\Packages\ReportViewer\ReportViewer.exe in the server. When I try to access the website, it still says "Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies". Although I executed ReportViewer.exe from c:\ on the server, I am not sure what else needed to do. It says that all the required files in C:Windows directory. But I am not positive on copying files and placing them anywhere. I am wondering if my actions are not coherent enough to publish the website or not. Any help is greatly appreciated.

Hi, I have created a report with Report Viewer control using Visual Studio 2008 under 3.5 frame work in the local mode. However, I am trying to publish this website for public to use on Windows 2003 server. I have installed published the website with Web.Config from my machine and then executed ReportViewer.exe on this server by double clicking on it. This Report Viewer.exe was downloaded from Microsoft Report Viewer Redistributable 2005. However, so I read an article in this that I need to copy exe file from C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer\ReportViewer.exe to the server. I did the same, but I do not see same directory path on the server. It does not have no subdirecties from BootStrapper\Packages\ReportViewer\ReportViewer.exe in the server. When I try to access the website, it still says "Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies". Although I executed ReportViewer.exe from c:\ on the server, I am not sure what else needed to do. It says that all the required files in C:Windows directory. But I am not positive on copying files and placing them anywhere. I am wondering if my actions are not coherent enough to publish the website or not. Any help is greatly appreciated.

Thank you.

Hi, When I tried to implement the code from this forum to display data in the excel from a webpage, I am getting weird results. I am wondering if you could direct me to correct the problem? I thank you for your help. The code is : HttpResponse response = HttpContext.Current.Response; response.Clear(); response.Charset = ""; //MAKE THE CONTENT TYPE TO EXCEL FORMAT. response.ContentType = "application/vnd.ms-excel"; response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + ".xls\""); // CREATE A STRING WRITER. using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // INSTANTIATE A DATAGRID. GridView dg = new GridView(); dg.DataSource = ds.Tables[0]; dg.DataBind(); dg.RenderControl(htw); //STYLE TO FORMAT NUMBERS TO STRING. string style1 = @" .textmode { mso-number-format:\@; } "; response.Write(sw.ToString()); response.Write(style1); //response.Flush(); HttpContext.Current.ApplicationInstance.CompleteRequest(); } } } catch (Exception ex) { throw ex; } } ds:is the dataset and filename is the name of the filename. However, the file contains data as below: " " MonthYearUSERIDApplicationNumOfReturns" " 08/2011userid12010" " 08/2011userid22010" " 08/2011userid32009" " 08/2011userid42010" " " .textmode { mso-number-format:\@; } " Untitled Page"

I am wondering what wrong with my code. Any help is greatly appreciated. Thank you.

Thank you for your help.

Thank you for your help.

Thank you for your replies. Yes, I do have a column(primary key) that starts from 1 and automatically generated by adding 1.

Hi, Good morning. Would you please shed some light on the question I have on partitioning a table? I have a table with a size of 1.2 GB with 3.7 million rows. My question is whether it is a candidate for partitioning it? I thank you in advance for your help. Have a nice day. Regards.