|
-Open the VB6 IDE
-in the new project screen choose ActiveX DLL
-in the class module you can write your functions , subs just as you make in VBScript.
register the DLL and call it from the ASP.
create it using Server.createObject
|
|
|
|
|
i want to know how can i read and save record into .xsl file by ado.net like any table.i did this by vb data control to read and write data to work sheet in excel .xsl file just like .xsl file behave like database and worksheet behave like table.if possible please tell me in detail how can i do it by ado.net and if possible give me the sample code.
tbhattacharjee
|
|
|
|
|
OK. Have you done any research on your questions before you post them here? Finding an example of this one was ridiculously easy. All it took was searching Google for 'Excel ADO.NET'.
I don't mind helping out, but you have to at least TRY to help yourself first. It will lead to a much greater depth of knowledge about your question and how VS.NET and other technologies work.
This is but a single article and code sample, but Google returned over 58,600 hits on pages written within the last year!
<a href="http://www.dotnetjohn.com/articles/articleid54.aspx">http:
RageInTheMachine9532
|
|
|
|
|
i want to know how can i read and save record into csv file by ado.net like any table.
if possible please give me the sample code
tbhattacharjee
|
|
|
|
|
It's anyones guess why you would want to do this, but here[^] it is.
RageInTheMachine9532
|
|
|
|
|
Instead on show report I want whenever I will click on a button then my report content will export a text file or forward as e-mail to some one. Please give me the code by which I can do my job
tbhattacharjee
|
|
|
|
|
An example of exporting a report to an RTF file can be found here[^]. From there, you can email that file as an attachment...
RageInTheMachine9532
|
|
|
|
|
Say suppose I have populated two tables data in dataset called one “Customer” and other “Order”. How could I save the customer table detail to any xml file from my Dataset? Please give me the code by which I can save only one table detail to xml file if there is 10 tables detail in my dataset.
tbhattacharjee
|
|
|
|
|
'Suppose in the dataset ds you have three tables
'Customer, Order and Supplier. If you want to save
'the Customer table. Below is the code
'Duplicate the table and add it to a DataSet<br />
Dim datatb As DataTable = ds.Tables("Customer")<br />
Dim datatbTmp As DataTable = datatb.Copy()<br />
Dim dsTmp As DataSet = New DataSet()<br />
dsTmp.Tables.Add(datatbTmp)<br />
<br />
'Save data to xml file and schema file<br />
dsTmp.WriteXml(Server.MapPath("Customers.xml"), XmlWriteMode.IgnoreSchema)<br />
dsTmp.WriteXmlSchema(Server.MapPath("Customers.xsd"))
|
|
|
|
|
Please tell me few url from where I can get the knowledge and sample code for developing project by vb.net and crystal report other than www.crystaldecision.com . Actually I want to know the about the various classes of crystal report accessing from vb.net.
tbhattacharjee
|
|
|
|
|
You can find a good start on MSDN here[^]. You'll find all the doc's for all the classes and Samples to go with them.
RageInTheMachine9532
|
|
|
|
|
Please tell me the definition of typed and untyped dataset and what is the difference between typed and untyped dataset.
tbhattacharjee
|
|
|
|
|
You might want to start here[^]
RageInTheMachine9532
|
|
|
|
|
There could be Formula field and Parameter filed in my sub report and I want to know how can I pass value for Formula field and Parameter filed writing code by vb.net, which is embedded in my sub report.
And I also want to know how can I pass report title for sub report writing code by vb.net
tbhattacharjee
|
|
|
|
|
Say suppose there is two formula fields in crystal report and I want to pass value for two formula filed from vb.net writing code. Please give me the sample code by which I can pass value for two formula fields.
tbhattacharjee
|
|
|
|
|
I have developed a small report by crystal report, which comes with visual studio. net. How could I pass report title writing code by vb.net before showing report? Please give me code by which at run time I can pass or set report title.
tbhattacharjee
|
|
|
|
|
Say suppose a single parent table may have relation with other three-child table. I want to show that related to user. If possible please solve my problem and give me the sample code to implement it by vb.net.
tbhattacharjee
|
|
|
|
|
That's a bit of a vague request. What type of applications are you writing? This is a user interface question - so, please, let us know what you technologies you are using for your presentation layer. Are you using ASP.NET or WinForms?
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
|
|
|
|
|
Say suppose I have developed a small application by vb.net, which will insert new record and modify existing record and delete existing record. At the time of inserting new record then primary key, index, unique key, check key can violate for reason like duplicate record, like null value. So how could I capture those errors separately and show proper message for different type of errors to user. At the time of deletion relation can violate say suppose user are trying to delete record from parent table where references are in the child table, at that time foreign key will violate and I want to capture that and show proper message to user.
Please solve my problem giving me the proper exception handling code with comment implement by vb.net.
tbhattacharjee
|
|
|
|
|
Since SQLServer is generating the errors, your SQL procedures can return codes to your VB.NET code so you can determine what to do with the errors there.
But, if your code is written properly, your SQL database is setup and the stored procedures that do the actual work are written properly, you should never have to deal with foreign key violations like what your talking about. The only way a user can delete a record from a parent table and violate the child relations is if your code lets them do it in the first place.
RageInTheMachine9532
|
|
|
|
|
After developing a big windows application by vb.net how could I be able to test the load.
So I want to know is there any tool that comes with Visual Studio.Net by which I can test the load of windows and web application, if so then please tell the step-by-step detail to test the load.
tbhattacharjee
|
|
|
|
|
I always rely on the old task manager. If you watch closely you'll be able to see how much you are muncing (It works for me in C++,VB and C#) I managed to find memory leaks and so. Other of that I dont know any tools to do the job. I hope this helps.
The warlord
|
|
|
|
|
After developing a big windows application by vb.net how could I be able to test the load.
So I want to know is there any tool that comes with Visual Studio.Net by which I can test the load of windows and web application, if so then please tell the step-by-step detail to test the load.
tbhattacharjee
|
|
|
|
|
What it sounds like your looking for is this:
Application Center Test is designed to stress test Web servers and analyze performance and scalability problems with Web applications, including Active Server Pages (ASP) and the components they use.
Application Center Test simulates a large group of users by opening multiple connections to the server and rapidly sending HTTP requests.
It comes with Visual Studio.NET, but I don't know which editions...
RageInTheMachine9532
|
|
|
|
|
hi can anyone tell how do i change a RTF text into char array or how do i get it seperated one word by one??
eg:this is a text
to
t
h
i
s
a
t
e
x
t
tks a lot..
Have a Super Blessed Day!
-------------------------
For God has not given us a spirit of fear, but of power and of love and of a sound mind.
2 Timothy 1:7
"For God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life."
John 3:16
"Therefore you also be ready, for the Son of Man is coming at an hour you do not expet."
Luke 12:40
|
|
|
|