ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2018 All rights reserved.Wrap long text in GridView and report viewer in ASP.Net<p><em>What i want, if the text is too long to fit as per the defined width, the text should be wrapped in next row. I don&rsquo;t want to expand the column width to accommodate this text in one row. In other words, I want to wrap the text in next row if the text inside this columns exceeded the width of the column defined i<img src="Untitled.png" alt="" />n&nbsp;gridview and reportviewer</em></p>, 19 Nov 2017 06:55:00 GMTwhat is Fiddler and how its helpfull in wcf service<p>"HTTP data inspector Fiddler." what is the use of this and give me any article &nbsp;for&nbsp;how to use fiddler to monitor wcf service in detail</p>, 24 Jul 2014 02:30:40 GMTVisual Studio localhost Port casuing problems for Crystal Reports in ASP.Net<p>Hi, I have created a dataset with 3 tables and trying to fill this dataset using dataadapter(By executing stored procedure). The data is getting filled into the dataset but it is not getting displayed in the crystal report(Getting blank report). Pls refer by code below :<br /><br /></p> <pre class="brush: csharp">using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Configuration; using System.Data.SqlClient; using CrystalDecisions.CrystalReports.Engine; namespace CrystalEx { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string sqlCon = &#34;Server=ServerName;Database=DBName;uid=sa;pwd=sa;connection timeout=3600;&#34;; SqlConnection sqlConn = new SqlConnection(sqlCon); SqlDataAdapter sqlAdap = new SqlDataAdapter(); //TQReportCM is a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportCM&#34;, sqlConn); sqlConn.Open(); DataSet1 ds = new DataSet1(); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@CmNo&#34;, SqlDbType.NVarChar, 400).Value = &#34;1&#34;; sqlAdap.Fill(ds, ds.CM.TableName); //TQReportCRPOCis a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportCRPOC&#34;, sqlConn); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@Name&#34;, SqlDbType.NVarChar, 400).Value = &#34;hello&#34;; sqlAdap.Fill(ds, ds.CRPOC.TableName); //TQReportSelectHS is a stored procedure , i am selecting a record by passing one parameter sqlAdap.SelectCommand = new SqlCommand(&#34;TQReportSelectHS&#34;, sqlConn); sqlAdap.SelectCommand.CommandType = CommandType.StoredProcedure; sqlAdap.SelectCommand.Connection = sqlConn; sqlAdap.SelectCommand.Parameters.Add(&#34;@FirstName&#34;, SqlDbType.NVarChar, 400).Value = &#34;abcd&#34;; sqlAdap.Fill(ds, ds.Customer.TableName); ReportDocument rptDoc = new ReportDocument(); rptDoc.Load(Server.MapPath(&#34;CrystalReport1.rpt&#34;)); rptDoc.SetDataSource(ds); CrystalReportViewer1.DataBind(); CrystalReportViewer1.ReportSource = rptDoc; } } }</pre> <p>Any help would be appreciated.<br />Thanks in advance</p>, 08 Aug 2013 09:10:49 GMTVisual Studio Crystal Report does not work in IE 10 browser<p>How to make <strong>Crystal Report</strong> using inbuilt sql express <strong>in VisualStudio2012</strong>??</p>, 10 Oct 2013 01:54:15 GMTVisual Studio crashing as soon as i try to add crystal Report<p>using VS2005 web application</p> <p>when i even try to add crystal report rpt to the application visual studio shutsdown</p> <p>i tried repairing VS &amp; even checked if ccrystal report is checked while installation</p> <p>&nbsp;</p> <p>but still the same issue</p> <p>so wanted to check log files if i can get any info</p> <p>where can i find the log files for the same</p> <p>&nbsp;</p>, 26 May 2012 01:05:24 GMTVersion of Crystal Report runtime that would work with website built using visual studio 2010 and hosted with IIS7<p>which version of crystal report would be install with visual studio 2010 ultimate which can be work perfectly with IIS7.</p>, 05 Jan 2013 03:02:58 GMTUsing Hindi or Marathi fonts in Crystal Reports in ASP.Net<p>HI Mudassar,</p> <p>I am Exporting Crystal Report to pdf in hindi font it displaying &nbsp;as boxes&nbsp;i have installed adobe reader 11.0 with asian extended language pack in my local system bit still i am facing issue please help in solving this issue thanks in advance.(English is working fine problem is with only with hindi font)</p>, 08 Apr 2014 23:27:29 GMTUsing Crystal Reports PrintToPrinter command with ASP.Net<p>i am using this code for printing when i try printing from client system its printing on server printer . &nbsp;Helpp</p> <p>&nbsp;</p> <pre class="brush: csharp"> DateTime curdate = Convert.ToDateTime(TextBox1.Text); SqlDataAdapter da = null; DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); con.Open(); SqlCommand cmd = new SqlCommand(&#34;SELECT * FROM Transactions where report_type = @report_type AND dateadd(dd, datediff(dd,0, [R_date]), 0) = @R_date&#34;); cmd.Connection = con; cmd.Parameters.Add(&#34;@report_type&#34;, SqlDbType.NVarChar).Value = DropDownList1.SelectedValue; cmd.Parameters.Add(&#34;@R_date&#34;, SqlDbType.DateTime).Value = curdate.Date; da = new SqlDataAdapter(cmd); dt.Clear(); da.Fill(dt); if (dt.Rows.Count &gt; 0) { ReportDocument Report = new ReportDocument(); Report.Load(Server.MapPath(&#34;~/Report.rpt&#34;)); Report.SetDataSource(dt); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; Report.SetDatabaseLogon(&#34;sa&#34;, &#34;123456789&#34;, @&#34;TRAINING-ROOM-8&#34;, &#34;newMreport&#34;); CrystalReportViewer1.ReportSource = Report; CrystalReportViewer1.ReportSource = Report; CrystalReportViewer1.DataBind(); CrTables = Report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } Report.Refresh(); Report.PrintToPrinter(1, true, 1, 1); con.Close(); } }</pre> <p>&nbsp;</p>, 02 Dec 2012 22:45:02 GMTUsing Crystal Reports in ASP.Net Example<p>how to make crystal report from project?</p>, 01 Nov 2012 22:49:33 GMTUse Crystal report made uisng vs 2008(crystal report 10) in crystal report viewer 13 in ASP.Net<p>what happens if i build web app (.net 3.5, vs 2008) with crystal report basic for vs 2008 (cr basic 10) and i publish it in server which using crystal report viewer 13?</p> <p>can it runs smoothly? if error what can i do?must i upgrade my crystal report?</p>, 08 Jun 2016 07:08:06 GMTUpload Download Files using Web Service in ASP.Net<p>hi<br />My web service Return Files bytes Correctly .<br /><strong>service Code is as Follows...</strong></p> <p>&nbsp;</p> <pre class="brush: csharp">[WebMethod()] public byte[] Download_Files_From_Database1(string File_ID) { try { byte[] buffer = null; using (SqlConnection con = new SqlConnection(&#34;ConnString&#34;)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = &#34;select ID,File_Name,File_Extension,File_Content_types,File_Size,File_Uploaded_Date,File_Data from dbo.File_Information (nolock) where Id=@Id&#34;; cmd.Parameters.AddWithValue(&#34;@id&#34;, File_ID); cmd.Connection = con; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { buffer = new byte[Convert.ToInt32(dr[&#34;File_Size&#34;])]; buffer = (byte[])dr[&#34;File_Data&#34;]; } } } return buffer; } catch (Exception ex) { throw ex; } } </pre> <p><strong>and Client Side Code is</strong></p> <pre class="brush: csharp">protected void lnkDownload1_Click(object sender, EventArgs e) { Stream download = null; try { LinkButton lnkbtn = sender as LinkButton; GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow; int fileid = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Values[&#34;ID&#34;].ToString()); string File_Name = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Name&#34;].ToString(); string File_Content_types = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Content_types&#34;].ToString(); string Ext = GridView1.DataKeys[gvrow.RowIndex].Values[&#34;File_Extension&#34;].ToString(); //// Url Working Perfect string url = &#34;http://localhost:13817/Web_Service_File_Download_Service_Side_Example2/WebService.asmx/Download_Files_From_Database1?File_ID=&#34; + fileid; HttpWebRequest Request_From_Client = WebRequest.Create(url) as HttpWebRequest; Request_From_Client.Method = &#34;GET&#34;; HttpWebResponse response_From_Server = Request_From_Client.GetResponse() as HttpWebResponse; Stream stream = response_From_Server.GetResponseStream(); Response.ContentType = &#34;application/octet-stream&#34;; Response.AppendHeader(&#34;Content-Disposition&#34;, &#34;attachment; filename=&#34; + File_Name); const int bufferLength = 10000; byte[] buffer = new Byte[bufferLength]; int length = 0; download = stream; do { if (Response.IsClientConnected) { length = download.Read(buffer, 0, bufferLength); Response.OutputStream.Write(buffer, 0, length); buffer = new Byte[bufferLength]; } else { length = -1; } } while (length &gt; 0); Response.Flush(); Response.End(); } catch (Exception ex) { System.Web.HttpContext.Current.Response.Write(&#34;Error : &#34; + ex.Message); } finally { if (download != null) download.Close(); } } </pre> <p>can any body help me.<br />when i hit url it gives required Output.<br />but not using in above code</p>, 14 Jul 2014 18:47:52 GMTService1 service failed to start due to the following error: Service1 is not a valid Win32 application<p>After installation when i am starting the windows service. I am getting the error:</p> <p>Error 193: 0xc1 &nbsp; windows could not start the service on local computer.</p> <div class="body"> <p>In Windows Logs in Event Viewer, i am getting this error:</p> <p>The RocketBackupDatabase service failed to start due to the following error: <br />RocketBackupDatabase is not a valid Win32 application.</p> <p>what is the solution of this. Please suggest me.</p> </div> <p>what is the solution of this error. Please suggest me.</p>, 17 Jan 2013 03:23:33 GMTRounding Off formula field values In Crystal Reports using C# in ASP.Net<p>How to round off formula field value of crytsal report</p> <p>e.g. The field value is 1549.60</p> <p>I have to show the value by rounding it off i.e. 1550.</p> <p>Please Help me out</p> <p>&nbsp;</p> <p>Thanks in advance</p>, 12 Feb 2018 00:39:09 GMTTo Display the data crystal Report<p><strong>Hai Techie</strong></p> <p><br />I have created a following crystal report to show the details of a table.<br />Crystal report runs perfectly but does not show data</p> <p><br />The code is</p> <p><br />SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Iwens_Database; Trusted_Connection=yes");<br />SqlCommand cnd = new SqlCommand("SELECT E_id, E_Name, E_Address, E_Contact_No, E_Email, DOEn, E_noi, E_coursename, E_year, E_companyname, E_design, E_others, E_Selected, E_Followup FROM Enquiry_table", con);<br /><br /><br />SqlDataAdapter sda = new SqlDataAdapter();<br /><br />DataSet eds = new Enquids();<br /><br /><br />ReportDocument rdoc = new ReportDocument();<br />sda.SelectCommand = cnd;<br />DataTable dt = eds.Tables[0];<br />sda.Fill(eds, "enquirypartfollowp");<br />rdoc.Load(Server.MapPath("Enquirybydate.rpt"));<br />rdoc.SetDataSource(eds.Tables ["Enquiry_table"]);<br />eds.Tables[0].TableName = "Enquiry_table";<br />CrystalReportViewer1.ReportSource = rdoc;<br />CrystalReportViewer1.RefreshReport();<br /><br /></p>, 21 Feb 2013 05:05:04 GMTThe type or namespace name ASPSnippets could not be found Error<p>i have used an ASP.Net C# web application to post image on facebook.for that i have used "aspsnippets.facebookapi.dll"</p> <p>everything is working fine while execute from local server.but when i upload my code in server and run</p> <p>it says error like "The type or namespace name 'ASPSnippets' could not be found (are you missing a using directive or an assembly reference?)"</p> <p>but i have added Dll reference in my page like&nbsp;</p> <pre>&nbsp;</pre> <pre class="brush: csharp">using ASPSnippets.FaceBookAPI;</pre> <p>how to solve this issue.</p>, 18 Aug 2014 05:51:33 GMTtext out from textbox crystall report<p>Hi! I have text more than 1000 character in table. But I want show text from table in crystal report. When I show text in textbox crystal report text out from textbox and can&rsquo;t seen all text.</p> <p>For example:</p> <table> <tbody> <tr> <td width="115"> <p>Text out from t</p> </td> </tr> </tbody> </table> <p>extbox.</p> <p>For me need like this:</p> <table> <tbody> <tr> <td width="115"> <p>Text out from textbox . it&rsquo;s need me</p> </td> </tr> </tbody> </table> <p>How I can solve this?</p>, 17 Nov 2015 02:41:25 GMTSum Column Values in Crystal Report<p>am generating crystal report and in this am using product name&nbsp; and its price, i want to display the total price of the product in footer section ,</p> <p>what i do,?</p> <p>thank you...</p>, 11 Oct 2013 23:04:57 GMTSubreport in RDLC report using C# and VB.Net in ASP.Net<p>i have 3 dataset i want to display with Rdlc Report view</p> <p>i want to display per a page studnent Name, all subjects under assessments1 and assements2 for a sudent.</p> <p>any help or link to help me in</p>, 14 Jan 2018 23:18:06 GMTShow sum of columns in RDLC Report using C# and VB.Net in ASP.Net<p>Hi,</p> <p>In my Database i have <strong>orderIncome</strong> table.</p> <p><strong>OrderIncome:(Fields)</strong></p> <p>1.OrderDate</p> <p>2.OrderNo</p> <p>3.PaymentMethod</p> <p>4.Amount</p> <p>5.OrderClosingDate</p> <p>&nbsp;</p> <p>PaymentMethod have following types:</p> <p>1.Cash,Online,Cheque,Foc</p> <p>&nbsp;</p> <p>How i want separately display sum(cash),Sum(online),etc.. using orderclosingdate range in RDLC report.</p> <p>&nbsp;</p> <p>&nbsp;</p>, 21 Jun 2017 02:50:37 GMTShow hide columns in RDLC report at Runtime in ASP.Net<p>Hide /Unhide RDLC Columns on Runtime</p> <p>to collapase the columns having no data list excel hide columns but on runtime..</p> <p>&nbsp;</p>, 29 Jul 2016 03:01:23 GMT