|
Does anyone know anything about AppConfig files and how to integrate them into a SQL application because it is the only way i can think of to install my app on other computers and somewhat painlessly setup the connection string for the app. I know nothing about XML. HELP ME
|
|
|
|
|
Right click on your project, select "Add -> New Item" and select "Application Configuration File". Make sure it is called "App.Config".
On your application drag from the toolbar to your form a "SqlConnection" object. View properties of SqlConnection object and select "Dynamic Properties" then Check the default "Connection String".
Next, create a connection string and save all.
By now you should see in "App.Config" a key value pair that is added for your SqlConnection object and its connection string.
To read from your code:
using System.Configuration
myConnectionString = ConfigurationSettings.AppSettings("your key name")
|
|
|
|
|
I you want to do this in code (versus the IDE) let me know, or, if you need XML that you can read AND write from code (like by screens from user input) let me know.
I have some real-work examples.
If the IDE workds for you - great.
Good luck - Len
Thanks,
-Len Miller
"If I had eight hours to chop down a tree, I'd spend six sharpening my axe."
-Abraham Lincoln
|
|
|
|
|
This is how u have to place ur connectionstring in your app.config file.
<configuration>
<appSettings>
<add key="DBConnString" value="Data Source=ervername;Initial Catalog=Databasename;User ID=userid;Password=password;"/>
</appSettings>
</configuration>
For accessing this value from DB you can use this line of code in vb.net (in case of C# hope u can manage it, or ask me)
Public Shared CONNECTSTRING As String = System.Configuration.ConfigurationSettings.AppSettings("DBConnString")
Hope its fine and ur prob is solved.
Het Waghela
 Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|
|
|
|
|
|
i m trying to stream media files on VB.NET interface using Windows Media Player component.. but its not being played..
well, i hav tried embedding the windows media player component on the WebApplication.....it is appearing on the client side but it is not able to play any files...... and we are not able to even select any controls provided in the player...
we are using Windows 2000 Advanced Server as OS.
actually we dont ve much idea about how streaming takes place on the internet and do we need to add any other codec or component to achieve Media Streaming ???
waiting for replies.
thanks..
|
|
|
|
|
I wrote a vbscript that closes Internet explorer windows. The main reason i'm doing it this way it to get the LocationURL property of the objIE object before I call Quit on it.
The problem is that not all windows close this way.
Any suggestions?
<br />
Set objShell = CreateObject("Shell.Application")<br />
Set objShellWindows = objShell.Windows<br />
dim i, nCount<br />
nCount = objShellWindows.Count<br />
nCount = nCount - 1<br />
<br />
for i = 0 to nCount<br />
dim objIE<br />
<br />
set objIE = objShellWindows.Item(i)<br />
if (not objIE is nothing) then<br />
objIE.Quit<br />
end if<br />
next<br />
|
|
|
|
|
What do you mean by "not all windows close this way"? Are you talking about close JUST the IE windows or all applications? Also, before you close the IE window, you might want to try checking the .Busy property and wait until the borwser window is finished. I'm not syaing that this will solve the problem, but it might...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I was wondering if there is a way in VS.net to setup site templates similar to how you accomplish this in Dreamweaver, for example, so that you could make changes to one page that would propegate to the other pages of the site as well...
Anyone know how to do this???
I actually tried setting templates up in Dreamweaver and then doing my dynamic code in VS.net, but when I made changes in VS.net and tried to go back to Dreamweaver and make changes to the template, i get errors....
Thanks
cavall
"Nothing is at last sacred, but the integrity of your own mind."
"What lies behind us and what lies before us are nothing compared to what lies within us." - Ralph Waldo Emerson
|
|
|
|
|
Your question belongs in the ASP.NET Forum. It is possible to do this in ASP.NET 2003, but it gets much easier to do in 2005.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello, I write my vb.net class and I want that when another developer will be use my class the VS 2003 show a small help that say the meaning of the methods, something like the functions that VS incorporate. For example, when I write me.text VS show us a small tips that say the meaning of text in this object. Then my question is Can I do something like that?
Thanks, and excuseme but my english is very very very bad.
|
|
|
|
|
Basically you want the feature that is already available in csharp.net. Unfortunately that feature is not available in VB.net; however, I verified that this feature works with VS2005 Beta.
Anyway, to show tooltips of your methods for next VS2005 version, just add the following xml text before you declare any method:
your class description
I suggest you look for information about VBCommenter which automatically adds the tags you need and then learn to use NDoc to automatically create help files like the ones from Visual Studio.
|
|
|
|
|
I have a program that when i double click on him the form will automatically loads from the textfile and if its empty a registration form appears. now i want that if the user didn't enter any details in the textbox of the registration and he closes the reg form, the program will not crash unless he input a data in the textbox. how can i make this??
PsYcHo_A
|
|
|
|
|
Let me make sure I understand. You wrote a program and have it running on a computer. When you double click on the program's icon to start it, a form loads and gets information from a text file. If the text file is empty, a registration form loads. If the user does not enter any information on the registration form and closes it, the program crashes. You want to know how to prevent it from crashing, is that correct?
|
|
|
|
|
yes please!! thats correct!! how please?
|
|
|
|
|
How are you opening that registration form? How are you closing it?
You SHOULD be opening the registration form using .ShowDialog(), not .Show(). .ShowDialog() can return a DialogResult that can tell your main form how the registration form was handled, whether the registration was successfull or not. Without seeing your code, we can't tell you what your doing wrong.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
THIS IS THE PROGRAM FORM:
Private Sub frmBudget_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strLoadText As System.IO.StreamReader
Dim strtext As String
strLoadText = New System.IO.StreamReader("C:\Documents and Settings\PsYcHo_A\My Documents\Visual Studio Projects\Budget Program\Registration.txt")
Dim obj As New Register
strtext = strLoadText.ReadLine
strLoadText.Close()
If strtext = "" Then
obj.ShowDialog()
strLoadText.Close()
End If
If strtext = "" = False Then
strLoadText.Close()
Dim sr As New System.IO.StreamReader("C:\Documents and Settings\PsYcHo_A\My Documents\Visual Studio Projects\Budget Program\Transactions.txt")
Do While sr.Peek <> -1
lbLM.Items.Add(sr.ReadLine())
Loop
sr.Close()
End If
strLoadText.Close()
strLoadText.Close()
End Sub
Private Sub frmBudget_Activated(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Activated
Dim strLoadText As System.IO.StreamReader
Dim strtext As String
strLoadText = New System.IO.StreamReader("C:\Documents and Settings\PsYcHo_A\My Documents\Visual Studio Projects\Budget Program\Registration.txt")
Dim obj As New Register
strtext = strLoadText.ReadLine
strLoadText.Close()
If strtext = "" Then
obj.ShowDialog()
strLoadText.Close()
End If
If strtext = "" = False Then
strLoadText.Close()
Dim sr As New System.IO.StreamReader("C:\Documents and Settings\PsYcHo_A\My Documents\Visual Studio Projects\Budget Program\Transactions.txt")
Do While sr.Peek <> -1
lbLM.Items.Add(sr.ReadLine())
Loop
sr.Close()
End If
strLoadText.Close()
strLoadText.Close()
End Sub
|
|
|
|
|
 I am very new to using VB.NET. I need to be able to open a .doc or .dot file in my VB.NET program, write to that document and save as a different document. I am using .NET 2000 and MS OFFICE 2003 WORD. What I have created is a program to allow you check boxes for the items you want to add to the Word document, edit a template/document you have loaded and save as new document. I need specific code that will allow you to open, edit and save a .doc or .dot file. Any help given is greatly appreciated. Also, if I need to have MS Office 2000 I have it so I can load it as well.
J. scott Gleaton
J. Scott Gleaton
|
|
|
|
|
Hi,
Try this to open .doc/.* from vb.net and then u can edit and save it in any format.
Dim info as new ProcessStartInfo("filename.doc")
Info.UseShellExecute= True
Process.START(iNFO)
Hope this works for u.
|
|
|
|
|
Ok, I'm frustrated at this deployment stuff. How can I automatically put shortcuts into the 'all users' dir instead of just into the current user?
I've nuked the installation dialog, so the user can't select. I note this is for a corporate installation, so I can standardize such things, even though they're 'bad form' for "public" installers. This isn't one of those.
I tried setting up a custom folder to the "C:\Documents and Settings\All Users\Start Menu\Programs\" dir, and then add the folders I wanted (company and program folders), and then put the shortcuts in there.
It makes the folders, but then STILL installs the shortcuts over in the current user's startmenu instead of the all users.
Anyone have a clue? The only other thing I can think of is to make my own shortcut files (basically hardcode the shortcuts) and then just tell the deployment project to dump those files over. Will that work?
-Mike
|
|
|
|
|
Try using:
"C:\Documents and Settings\All Users.WINNT\Start Menu\Programs\" as the target folder.
You also have to put the Installation Folder dialog back into the setup, and select "All Users" when the setup is run. This is why it is creating the folder but not putting the shortcuts in it. If you remove the installation folder dialog, the setup defaults to a per-user automatically.
You can also manually edit the MSI to force the All Users install without having to show the dialog. If you have Orca, open the MSI, go to the Propertys table, add a new entry:
Name: ALLUSERS
Value: 1
This will prevent having to show the dialog.
Robert
|
|
|
|
|
Hi,
I have an Access database which looks like this:
Value 1 Value 2
| Text1 | blabla |
| Text1 | blabla2 |
| Text2 | xxxxxx |
| Text2 | yyyyyy |
| Text2 | ffffff |
| Text3 | aaaaaa |
| Text4 | kkkkkk |
There are "Values 1" which repeat one or more time, but each of these repeating values has different "Value 2". What I need is to do this:
Value 1 Value 2
| Text1 | blabla | blabla2 |
| Text2 | xxxxxx | yyyyyy | ffffff |
| Text3 | aaaaaa |
| Text4 | kkkkkk |
I want to add "Value 2" of the rows with the same "Value 1" to the first row of this value and to delete the others... I would like to do this in Access, but I don't understand VBA a lot...  Thanks for your ideas
|
|
|
|
|
David Fawn wrote:
I want to add "Value 2" of the rows with the same "Value 1" to the first row of this value and to delete the others
What??? Do you want this result in the database? Do you want all the gethered values from Value 2 to be in the same record appended to each other or in their own seperate columns in the same record?
Value 1 Value 2
Text2 xxxxxxyyyyyyffffff
or
Value 1 Value 2 Value 3 Value 4
Text 2 xxxxxx yyyyyy ffffff
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I want them to be in their own seperate columns in the same record? (Example:
Value 1 Value 2 Value 3 Value 4
Text 2 xxxxxx yyyyyy ffffff
|
|
|
|
|
hello, i have a program that when the form loads it looks up in a textfile and if the textfile is empty the program will opens a register form: obj.showdialog(). now i want to when he/she enters a register key in the textbox of the register form and then he can click on the register button. i made it that when he click on the button a messagebox appears saying the user that he registered. now in the messagebox i want to make it with OK and when he click on ok the register form will automatically closes and the program will be active!! how can i make it??
Adrian
|
|
|
|
|
msgbox(" Prompt ", msgboxstyle.Okonly, " caption/title")
If msgboxresult.ok then
form.activeform.close()
End If
I guess this is what your looking for, i dont really understand the question.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
