|
Hi i know how to do crystalreportviewer....,
But dont know anything about .dsr file...,
so i send u about this one...,
u send me about that dsr file...,
In ur tool box see crystalreportviewer will be there drag and drop in to ur form...,
Then in that form back code:
Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports System.IO
Imports System.data
Imports System.Data.SqlClient
Imports System.Web.SessionState
Imports CrystalDecisions.CrystalReports.Engine
Then Above page load event:
Dim crpt As CrystalReport1 'Ur crystal report name(.rpt file name)
Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo
Then page load event paste this code:
crpt = New CrystalReport1
For Each myTable In crpt.Database.Tables
myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.Password = "XXXXX"'Database password
myLogin.ConnectionInfo.UserID = "sa"'Database Username
myTable.ApplyLogOnInfo(myLogin)
Next
CrystalReportViewer1.ReportSource = crpt
Then in ur rpt file:
See in that field explorer Database fields add/remove ur database in that add ur table or command...then run the form u will get the report......
By the way dont forget to send about that dsr file plz......
Regards
Magi
|
|
|
|
|
i m working on a project.which send emails to vendors.
But the problem is same email is appearing multiple time at vendors end.
the project is in vb.
pls help me.
|
|
|
|
|
Can you provide a sample of the code. Sounds like you may not be reinitializing the mail object between sends.
|
|
|
|
|
my project works fine up to last year.From then problem came.
what might be the problem.
tx for u r reply.
|
|
|
|
|
Sir,
I have some DSN problem.Presently , I am connecting my reports(Wizard process) with DSN .The reason is , If I am connecting it through the path (I mean after invoking the file dialog box for selecting the database for my crystal reports.), It stores a static path there in the data source of crystal reports , which is not required.This is the only reason , I am using DSN.
Now , my problem is at the client end i am manually creating the dsn at each machine.There are about 5 machine.(Database is centralized)
So i wanted to create the dsn programically.
Please provide some help.
Thanks and regards
Pankaj
|
|
|
|
|
Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Integer, ByVal fRequest As Integer, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Integer
Call :
iReturn = SQLConfigDataSource(0, 1, "SQL Server", Attr)
|
|
|
|
|
Sir,
Thanks for your kind attention.
But , If i have to use MS-Access
Then Whats's the way out.
Thanks and regards
Pankaj
|
|
|
|
|
Very Simple,
Attributes = "DSN=" & "YourDSN" & Chr(0)
Attributes = Attributes & "Uid=Admin" & Chr(0) & "pwd=" & Chr(0)
Attributes = Attributes & "DBQ=E:\KB_Design.mdb" & Chr(0) & Chr(0)
iReturn = SQLConfigDataSource(0, 1, "Microsoft Access Driver (*.MDB)", Attributes)
|
|
|
|
|
Hi All,
I want to create Virtual Directory Website in IIS using WMI through Vb.net code programmatically..i searched alot in internet sites but they are giving Vbscript but my requirement is using WMI classes and objects i have to create ..... so for that any one please help me (send code if anyone knows)
Thanks & Regards
Suresh
suresh reddy
|
|
|
|
|
Hello Suresh,
See if this helps...
http://www.vbforums.com/showthread.php?t=347207
|
|
|
|
|
Thanks Nilesh for giving reply to my message
But it was using System.DirectoryServices..but my requirement is using System.Management(WMI) that too i have to create website
if u have any other answers please send me
Thanks anyway
suresh reddy
|
|
|
|
|
Hi,
I'am doing a project in VB.net.
Iam facing a strange problem while debugging. The problem is that, the execution of program does not stop at any break points, even if all the break points are enabled. B'coz of that I can't carryout the step by step execution of the program.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Vikrant,
Please make sure that your project is in Debug mode and not in Release mode.
Regards,
Nilesh
|
|
|
|
|
Hi
I am executing my project which is related to database.When i try to put a breakpoint and execute my proj using step into(F11)It does not return to code for tracing i.e it does not halt,it continues with its execution and I am not able to trace my project.It is showing no symbols loaded as an warning but still with this warning I was able to trace but now I cant,Can anyone guide me.Or is it some key has been pressed by mistake.
Thank You,
Romana
|
|
|
|
|
Hi Romana,
Please make sure that your project is in Debug mode and not in Release mode.
Regards,
Nilesh
|
|
|
|
|
Hi anyone can explain me how to pass parameter value to crystal report....,
And how to retrive that value in report like...,
Plz help me...,
Magi
|
|
|
|
|
Suppose you want to pass a order-date as a parameter to your report.
Create a Parameter Fields in your report. Name it as DateOfOrder,set its Value Type to what you want.......By right Clicking on "Parameter Fields"-----> "New" option.....
In code behind to set the parameter value the code will be like following.....
<br />
Dim oRpt as Myreport<br />
oRpt.SetParameterValue("Order_Date", DateOfOrder)
Tirtha
Miles to go before I sleep
|
|
|
|
|
hi all
i m creating VBS application which delete all content from forder
Dim file, MyFile <br />
Set file= CreateObject("Scripting.FileSystemObject") <br />
Set MyFile = file.GetFile("C:\test.txt")<br />
MyFile.Delete
it works
but i want to delete only files present in ABC folder so i get
plz plz help me
SP
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.
|
|
|
|
|
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.DeleteFile("C:\FSO\*.*"), True
|
|
|
|
|
my ini file has follwing format
[general]
Provider=SQLOLEDB
Data Source=Cornelius
Initial Catalog=Academics
User ID=" "
Password=" "
Integrated Security=SSPI
thanks
|
|
|
|
|
Hi Poo,
Why are using .INI file in vb.Net?? You can use .config file instead.
I think .ini files are replaced by .config files in .NET.
You can use System.Configuration namespace.
Regards,
Nilesh.
|
|
|
|
|
|
hello,
i want to know is any validation controls are avilable for desktop application in .net 2005 or other alternative of doing it.
|
|
|
|
|
No. But there is a validation event you can customise. I can't remember the precise details.
|
|
|
|
|
can u be more precise.
thanks
|
|
|
|