Excel sheet - Visual Basic Discussion Boards

Christian Graus wrote:
The movies..... lied ? *sob*

Or did I just lie?? Poke tongue | ;-P

Hmmmm... I'll never tell! Muhahahahaaaaa

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

i am interfacing fuzzy logic toolbox with VB.
i have created an m-file
function [o]=rap(x,y)
fismat = readfis('C:\Matlab7\work\dmg.fis');
o = evalfis([x y],fismat)
i have created the dll file and i have got the library in VB-project-references.
now i want to call the following matlab command in VB code
p = readfis('dmg.fis');
evalfis([x y],p)
whether it can be done?,
if yes what will be the VB code?
plz give me quick reply

please try to use a sensible header.

Is this VB6 ? Is there no Matlab forum on the web ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

yes it is VB 6.0, i did'nt find anything related to my problem

OK sorry, I don't use VB6 and I am astounded that anyone still does. I hope you get your answer, but again, saying 'please get me quick reply' is rude, and won't help you.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

thanx christian,
i'll try to sort out in other way..
and sorry for saying "plz give..."

That's cool, I'm really trying to tell you how to get answers, not to just berate you.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

hi guys

my user have an excel sheet in which there are 2 columns ; one is username and second is salary
but my user want this report based on section which is stored some where in database with each user name .
how do i provide my user an interface so that he could generate report based on sections
?
thanks in advance

hello

ghumman63 wrote:
but my user want this report

What report?? Is this "report" generating this Excel sheet you're talking about??

ghumman63 wrote:
how do i provide my user an interface so that he could generate report based on sections

Sections?? What sections?? You're going to have to clarify what you're asking about. I have no idea what you're using or trying to accomplish.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Hello,

I find the way to get the MyDocument path in VS2005, VB.NET like that :

My.Computer.FileSystem.SpecialDirectories.MyDocuments

But I didn't find the way to get the All Users Shared Document path.
(in french "C:\Documents and Settings\All Users\Documents")

The whole My thing is just a bit of syntactic sugar, from the docs it seems it is incomplete. Probably AllUsersApplicationData is your best bet, then go up one and back down to the one you want.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

HI,
I HAVE A VB.NET APPLICATION, THERE IS A EXIT BUTTON IN MY FORM,ON CLICKING THAT I WILL SHOW A MESSAGE BOX , CHECK THE BELOW CODE
If MessageBox.Show("All the unsaved data will be lost! Are you sure you want to exit?", Me.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2, MessageBoxOptions.DefaultDesktopOnly) = DialogResult.Yes Then
--- SOME OPERATIONS --
END IF

THE PROBLEM is when i click YES OR NO, brings other open program into focus and hides this application

regards

winnie

Use the MessageBox overload that takes a window to be the parent window of the messageBox, so in C# you pass this, I guess you'd pass me in VB ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I have built an installer using the Visual Studio 2005 setup project wizard. It installs correctly on Windows XP but fails on Windows Vista. As per my research i found that the failure on Windows Vista is caused by a custom action that fails with an access denied error. However, I am running the setup with admin privileges in Windows Vista. How can I fix my setup so it will work correctly on Windows Vista?

Error: "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2869"

Jats

I tried to field a solution on the above problem and followed the below process

1-Download the sample script and extract the contents to the directory that contains the Visual Studio project you are working on
2-Open the project in Visual Studio 2005
3-Press F4 to display the Properties window
4-Click on the name of your setup/deployment project in the Solution Explorer
5-Click on the PostBuildEvent item in the Properties window to cause a button labeled "..." to appear
6-Click on the "..." button to display the Post-build Event Command Line dialog
7-Add the following command line in the Post-build event command line text box:
cscript.exe "$(ProjectDir)CustomAction_NoImpersonate.js" "$(BuiltOutputPath)"
8-Build your project in Visual Studio 2005

Now a new problem... the installer built now is installing in some system's with vista and showing same error for other system's in Vista.

Please help me find a solution...

Jats

Hello all, I'm using VB.NET 2003 Window Form to do some simple application. I found a problem on setting a global database connection string. How should I code it if this connection string might be change like from localhost to a Server or vice versa? This windom application may used MySQL or even MS SQL database for database as well. Anyone have this kind of solution here?

I read some article told me to put inside a module for this,but how can I do it?

This is my current testing connection which connected to my localhost MySQL database which is running perfectly in my development stage now.

Dim ConnString As String = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;UID=root;PASSWORD=;Option=3;Port=3399;"<br />
   Dim Objconn As New OdbcConnection(ConnString)<br />
   Dim ObjComm As New OdbcCommand

Hope someone can give me a solution here. Thank you for reading.

I'm not sure what you're asking. IF you want to be able to change it later, put it in your app.config so a user can modify it, and have all code read it from there.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Sorry,I'm asking how to declare a connection string which is used for my window form application. Please correct me if my idea was wrong. Is that the app.config file is just used for web based like ASP.NET for connection? I'm using window form here. Please give me some example how to do this.

For detail explanation,my application allowed the user to connect to localhost database or a Server database by pointing to a different IP address. How can I do this??

Regards
Drex

drexler_kk wrote:
Is that the app.config file is just used for web based like ASP.NET for connection?

No, you are thinking of the web.config. You have an app.config in your project which is turned into <yourappname>.config when it is built.

Then you read values in code with this sort of thing:

string value = ConfigurationManager.AppSettings["connectionString"];

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Wow..Thats so easy for this code. Thank you for your solution. I have got what you mean now. Thank you so much Christian Graus.

Happy Coding everyone~!

You do realise that for each different server/database type you will need a different connection string.

The module you mentioned in your OP is the Data Access Layer (DAL), I recommend that you research this as it is the most common solution to your problem.

Never underestimate the power of human stupidity
RAH

I have been working on migrating a old ASP app to asp.net and the VBScript block that calls a DB2 stored procedure looks like this:

oCmd.Prepared = true
Set oParam = oCmd.CreateParameter("RETURN", adsmallInt, 3, 2, 0)
oParam.Precision = 4
oParam.NumericScale = 0
oCmd.Parameters.Append oParam
ExecuteCmd oCmd
oRsReturn = oCmd.Parameters

If someone can tell me how to convert the code to VB.Net that would be great, I don't seem to find the equivalent of the first line and the last line and I don't know how to create similar parameters.

Thanks for reading!

Well, you will use the OleDBSQL classes to do this. There won't be a one to one mapping of methods, I don't think.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I am trying to print out labels from inside a piece of screen area. My IDE doesn't like vbmillimeters (I am using visual basic 9). Anyone know how I can scale my output?

Example:

Printer.ScaleMode = ScaleModeConstants.vbMillimeters
Printer.FontSize = 16
Printer.FontBold = True

-Live long and prosper

winsane wrote:
My IDE doesn't like vbmillimeters

What do you mean ? What are vbMillimeters ? Doesn't the IDE auto complete tell you what your options are ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )