Skip to main content

crystal reports using stored procedures in asp.net

By


 

crystal reports using stored procedures in asp.net

 




ReportDocument document = new ReportDocument();
        document.Load(this.Page.Server.MapPath("~/CRY/crTest.rpt"));
        string str = ConfigurationManager.AppSettings["ConnectionString"];
        string server = str.Substring(str.IndexOf("=") + 1, str.IndexOf(";") - (str.IndexOf("=") + 1));
        str = str.Substring(str.IndexOf(";") + 1);
        string database = str.Substring(str.IndexOf("=") + 1, str.IndexOf(";") - (str.IndexOf("=") + 1));
        str = str.Substring(str.IndexOf(";") + 1);
        string user = str.Substring(str.IndexOf("=") + 1, str.IndexOf(";") - (str.IndexOf("=") + 1));
        str = str.Substring(str.IndexOf(";") + 1);
        string password = str.Substring(str.IndexOf("=") + 1);
        document.DataSourceConnections.Clear();
        document.DataSourceConnections[0].SetConnection(server, database, user, password);
        new TableLogOnInfos();
        TableLogOnInfo logonInfo = new TableLogOnInfo();
        ConnectionInfo info2 = new ConnectionInfo();
        info2.ServerName = server;
        info2.DatabaseName = database;
        info2.UserID = user;
        info2.Password = password;
        foreach (CrystalDecisions.CrystalReports.Engine.Table table in document.Database.Tables)
        {
            logonInfo = table.LogOnInfo;
            logonInfo.ConnectionInfo = info2;
            table.ApplyLogOnInfo(logonInfo);
        }
        document.SetDatabaseLogon(user, password, server, database);
        document.Refresh();
        for (int i = 0; i < document.ParameterFields.Count; i++)
        {
            document.SetParameterValue(document.ParameterFields[i].Name, 1);
        }
        this.CrystalReportViewer1.ReportSource = document;

Comments

Post a Comment

Popular posts from this blog

Message Helper for MVC Application

By
Message Helper for MVC Application public static class MessageExtensions { public enum MessageType { Success = 0, Info = 1, Warning = 2, Error = 3 } public static void ShowMessage( this Controller controller, MessageType messageType, string message, bool showAfterRedirect = false ) { string messageTypeKey = messageType.ToString(); if (showAfterRedirect) { controller.TempData[messageTypeKey] = message; } else { controller.ViewData[messageTypeKey] = message; } } public static HtmlString RenderMessages( this HtmlHelper htmlHelper, bool clearMessage = true ) { string messages = String .Empty; foreach ( string messageType in Enum .GetNames( t
Post a Comment
Read more

Pass Values Between ASP.NET Web Pages without Session or any State Management

By
If the source page and target page are both ASP.NET Web pages in the same Web application, and if you transfer execution from the source page to the target page on the server by using the transfer method, the target page can access public properties in the source page. Page One <asp:TextBox ID="textCity" runat="server" Text="Brjesh"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />  public String CurrentCity         {             get             {                 return textCity.Text;             }         }         public List<String> Current         {             get             {                 return _Current;             }         }         private List<String> _Current = null;         protected void Page_Load(object sender, EventArgs e)         {             _Current = new List<String>();             _Current.Add("1
Post a Comment
Read more

CRUD in EF

By
 public int Create(Users entity)         {             using (var context = new K305DataEntities())             {                 var newEntity = Mapper.Map<User>(entity);                             context.Users.Add(newEntity);                 context.SaveChanges();                 return newEntity.Id;             }         }         public int Update(Users entity)         {             using (var context = new K305DataEntities())             {                 var dbEntity = context.Users.FirstOrDefault(dc => dc.Id == entity.Id);                 if (dbEntity == null) throw new ApplicationException("Entity not found.");                 dbEntity.Name = entity.Name;                 context.SaveChanges();                 return dbEntity.Id;             }                 }         public List<Users> GetAll()         {             using (var context = new K305DataEntities())             {                 return context.Users.Select(
Post a Comment
Read more