Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
S

simworld

@simworld
About
Posts
31
Topics
19
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Javascript
    S simworld

    How can I Disable users not to view the Source Code of Javascript using Internet Explorer ->View->Source at runtime?

    C# question javascript

  • DSN
    S simworld

    How to connect Crystal Report with DSN using C# Code? CrystalReportViewer1.ReportSource=Server.MapPath("CrystalReport1.rpt"); CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID="sa"; CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password="abc"; CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName="."; CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName="db"; Instead of Database Name, I want to use DSN(XYZ); What will be the syntax? CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DSN="XYZ"; above Code will not run.

    Database database csharp sysadmin tutorial question

  • Run
    S simworld

    How can I run .net Project(C#) in Mozila Firefox instead of Internet Explorer? Please provide me the way or Code that is needed to implement that.

    C# csharp question

  • Again Crystal Report
    S simworld

    again I am sending the same problem but this time I searched in google for the code,and use the code that I got from this forum what I have found i am sending, --------------------------------------- CrystalReport1 report=new CrystalReport1(); report.ReportOptions.EnableSaveDataWithReport = false; CrystalDecisions.Shared.TableLogOnInfo myLogin; CrystalDecisions.Shared.ConnectionInfo oCRConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables) { myLogin = myTable.LogOnInfo ; //myLogin.ConnectionInfo.ServerName="(local)"; myLogin.ConnectionInfo.ServerName="."; myLogin.ConnectionInfo.UserID = "sa" ; myLogin.ConnectionInfo.Password = "123456" ; myLogin.ConnectionInfo.DatabaseName="temp"; myTable.ApplyLogOnInfo(myLogin) ; myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1); } OleDbConnection oleConn = new OleDbConnection("Provider=sqloledb; data source = .; initial catalog = inventory; user id = sa; password = 123456"); oleConn.Open(); OleDbDataAdapter da = new OleDbDataAdapter("select * from student",oleConn); DataSet ds=new DataSet(); da.Fill(ds); CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument; myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); myReportDocument.Load(@"C:\Inetpub\wwwroot\temp\CrystalReport1.rpt",CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy); myReportDocument.SetDataSource(ds); this.CrystalReportViewer1.ReportSource =myReportDocument; CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.DisplayToolbar = true; CrystalReportViewer1.DisplayGroupTree = false; oleConn.Close(); I did not got any error but my crystal Report Viewer contains no data i.e. it contains only Crystal Report Toolbar ,no data(Blank Report) If I use F11 to run step by step ,I found the execution did not enter in the following Code. foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables) { myLogin = myTable.LogOnInfo ; //myLogin.ConnectionInfo.ServerName="(local)"; myLogin.ConnectionInfo.ServerName="."; myLogin.ConnectionInfo.UserID = "sa" ; myLogin.ConnectionInfo.Password = "123456" ; myLogin.ConnectionInfo.DatabaseName="temp"; myTable.ApplyLogOnInfo(myLogin) ; myTable.Location.Substring(myTable.Locatio

    Database help database tutorial

  • PDF Problem
    S simworld

    this problem already this in this forum,but my problem still be there,I googled the following code, and try to run,but did not work. --------------------------------------- CrystalReport1 report=new CrystalReport1(); CrystalDecisions.Shared.TableLogOnInfo myLogin; foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables) { myLogin = myTable.LogOnInfo ; myLogin.ConnectionInfo.Password = "123456" ; myLogin.ConnectionInfo.UserID = "sa" ; myTable.ApplyLogOnInfo(myLogin) ; } CrystalReportViewer1.ReportSource=Server.MapPath("CrystalReport1.rpt"); CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport(); CrystalDecisions.Shared.DiskFileDestinationOptions diskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions(); report.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile; report.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat; diskOpts.DiskFileName =Server.MapPath("Output.pdf"); report.ExportOptions.DestinationOptions = diskOpts; report.Export(); Response.AddHeader("Content-Disposition","attachment;filename=Output.pdf"); Response.ContentType = "application/pdf"; Response.WriteFile("C:\\Inetpub\\wwwroot\\temp\\"+ "Output.pdf"); Response.End(); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = false; Download option is comming,when trying to open that pdf file after downloading or just trying to open. Error Meassage is ...... "There is an error Opening this Document.The File is damaged and could not be Repaired." --- NOTE::: In Crystal Report Viewer the data is showed. How can I solve that.I am using .Net version 2003

    Database help csharp database sysadmin question

  • Crystal_Report PRoblem
    S simworld

    I have a dropdownlist that contains items , each item points to the each tablename of a fixed database. I simply added a blank CrystalReport1 without adding any table, any logon informatio while creating Crystal Report. and also added CrystalReportViewer Control. private void Page_Load(object sender, System.EventArgs e) { if(dropdownlist1.Selectedvalue=="Table1") { SqlConnection con=new SqlConnection(); con.ConnectionString="Server=.;uid=sa;pwd=abc;database=db"; con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from table1",con); DataSet ds=new DataSet(); da.Fill(ds); //ds.Tables.Add(); CrystalReport1 report2=new CrystalReport1(); //report2.SetDatabaseLogon("userid","pwd"); report2.SetDataSource(ds); //CrystalReportViewer1.DisplayGroupTree = false; CrystalReportViewer1.ReportSource =report2; CrystalReportViewer1.RefreshReport(); } else if(dropdownlist1.Selectedvalue=="Table2") { SqlConnection con=new SqlConnection(); con.ConnectionString="Server=.;uid=sa;pwd=abc;database=db"; con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from table2",con); DataSet ds=new DataSet(); da.Fill(ds); //ds.Tables.Add(); CrystalReport1 report2=new CrystalReport1(); //report2.SetDatabaseLogon("userid","pwd"); report2.SetDataSource(ds); //CrystalReportViewer1.DisplayGroupTree = false; CrystalReportViewer1.ReportSource =report2; CrystalReportViewer1.RefreshReport(); } } and so on......... ===================================================== crystal Reprt is coming without data and columns of the table,(Ensuring the table contains data),i think the dataset is not attached , How can i attach database and dataset dynamically Please solve this.....

    C# database sysadmin help question

  • Crystal_Report
    S simworld

    Is there any dll file needed to convert into PDF

    C# csharp question

  • Crystal_Report
    S simworld

    I represented the data in Crystal Report based on certain conditions. which is stored in a table "abc" . I used CrystalReportViewer Control and my Crystal Report name is crystalreport1.rpt . and control name is crystalreportviewer1 I have a task to convert that report into pdf file and save into a folder(output) in Drive C: . and also to open that pdf file after creating the pdf. My question is what will be the C# code to convert Crystal Report into pdf files and stored in that folder of drive C: .

    C# csharp question

  • Date
    S simworld

    thank u very much to all of u ,for helping me.

    C# css question

  • Date
    S simworld

    I want to say.. I have a table that contains columns with date value(System date). In a form a Text box (User i/p)that takes only date in a mm/dd/yyyy format if user date will be greater/less/equal than the system date,then certain event will occur. I want the C# code syntax that will compare those date. i think this give u clear view what my question is??

    C# css question

  • Date
    S simworld

    I want to compare between two dates. One date is System Date mm/dd/yyyy format Other one is User i/p Date in SAME FORMAT. I want to check whether the User I/P date is greater/less/euqal than the system date. How can I compare between them

    C# css question

  • Backup_Restore
    S simworld

    thank u very much

    Database database sharepoint help question

  • Backup_Restore
    S simworld
    1. EXEC sp_addumpdevice 'DISK','XYZ', 'c:\abc.bak' BACKUP DATABASE student_database TO XYZ WITH DESCRIPTION='def', STATS RESTORE DATABASE student_database FROM XYZ WITH DBO_ONLY, NORECOVERY, STATS EXEC SP_DBOPTION student_database,'dbo use only','false' ------------- After executing these query,when "use student_database" ---- Error message is =the database is in middle of processing...cannot use.. 2) I also want to delete sp_addumpdevice--"XYZ" and "abc.bak" after completing the task. If I delete manually the abc.bak from device, then also when going to use "EXEC sp_addumpdevice 'DISK','XYZ','c:\abc.bak'"---error message will come as it already exist. How can i solve this.
    Database database sharepoint help question

  • string
    S simworld

    thanks a lot

    C# question csharp tutorial

  • string
    S simworld

    How to Compare two Stringsand to copy string into other string using C# Code. What is the syntax? Is there any system defined function such as strcmp,strcpy as used in C I am taken two values in strings , now I want to compare which one is greater. I can do it treating values as int or to convert.ToInt32, but requirement is to treat and compare them as strings.

    C# question csharp tutorial

  • DataSet
    S simworld

    Thanks for your help

    C# help

  • DataSet
    S simworld

    A table contains a,b,c columns a contains data. b and c Contains NULL Values. I fill dataset(ds) with the values of a,b,c if(ds.Tables[0].Rows[0]["b"].ToString()==Null ) textbox1.text="asd"; this condition is not satisfied,when comparing with value NULL ,they failed to compare and skip that condition. What other syntax I can use to solve that problem.

    C# help

  • Table
    S simworld

    Thank u very much

    Database csharp tutorial

  • Table
    S simworld

    I am using SQL Server 2000.

    Database csharp tutorial

  • Date
    S simworld

    Difference between two dates .(MM/DD/YY) One date is given through Textbox are in the same format as System date. Other is just system date . I want to get date,month,year differences

    C#
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups