I am trying to retrieve a value saved in project A settings from project B in same solution set. Is this possible in VB.NET? If possible what namespace and function would I use?
View 3 RepliesI have a few of them set up and notice that they change based on where the application is run from.
Where are the actual values of these settings saved to? I have googled but not found anything definite.
I have this code, how can I test the URL which is stored in My.Settings.MyLink to make sure the link is valid before it tries to get the elements of my xml file.
Dim myXMLTextReader As New Xml.XmlTextReader(My.Settings.MyLink)
myXMLTextReader.ReadStartElement("ATypes")
Do While myXMLTextReader.Read()
[Code]....
We are trying to retrieve PDF files stored in a SQL Database. We want to display them on a web page. We are using VB and ASP Code within Visual Studio 2008. We have found snippets of code, but because we are new it does not make sense to us. We are looking for infomation on how to retrieve the PDF from the database and either display directly to a web page, or write the information to a Temporary PDF file we can delete later.
View 1 RepliesCreated an XSD file that represents my table structure from my database. Created a class file to hold my functions such as the one below.
Code sample:
Public Function GetUser(ByVal UserID As String) As xsdUser.UserDataTable
Dim SqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDatabase").ConnectionString)
[Code]....
Now it seems odd to me to have two files doing what should be contained within just one file. I feel like I should have one class file called "User" and have member variables in there along with the class functions like the one above. But all the tutorials I see are using these data tables. On top of that I'm not sure how to handle the if statement at the end of the function. I don't think I would want to return a whole DataTable since I should only have one row, and I also don't know how I would handle an error if my function is supposed to return a data table. I suppose I could return an empty one and then if the table is empty in my code then I would handle it there, but this also seems messy.
Is this the common way of retrieving information from a stored procedure? Or is there a more up-to-date method that I'm not seeing in my search results?
How to retrieve the particular column row to the text box?
I mean how to display it in textbox?
The column has got different rows.
The code I wrote in vb net is :
cmd = New SqlCommand("select ida from Issue where aname='" + TextBox3.Text + "'", con)
In the above line I compare the textbox3 data in the table.And if the data matches then it should display the ida that matches with aname row to textbox4.
Is this possible programmatically? Getting the names of stored queries or checking if a query with a specific name exists?
View 3 RepliesI'm new to LINQ and am having a problem getting proper results from a simple (working) stored procedure that takes no parameters and returns a single Integer. When calling this sproc with LINQ its returnvalue is always 0. When run using tableadapter or directly on the sql server it works, returning 6 digit values like 120123.
Here is my LINQ code:
Dim MeetingManager As New MeetingManagerDataContext
Dim MeetingID As Integer = MeetingManager.NewMeetingID().ReturnValue Here is the NewMeetingID procedure:
ALTER PROCEDURE [dbo].[NewMeetingID]
AS
SET NOCOUNT ON
BEGIN
[Code]...
If I modify a program of mine in some parts, adding also some settings in My.Settings and changing version, then I have to compile and create a new installer with the dear old InnoSetup.
Then I install the program, I go to see the settings ... and I see that them are the default settings stored in the MyProgram.exe.config file shipped with the new installer.
But is absolutely easy that a user would have changed the settings in a previous version (if existing) of the program.
So now the question is: during the new installation is there some clean and tested method to retrieve and update the settings set by users in any previous version of a program?
is there a way to see the My.Settings of one project from within another project within the same solution?I'm guessing the answer is no, they are scoped at the project level
View 3 RepliesBut i've a problem, everytime i hit the button "Save Settings" in my form/application it will re-save the settings to ini file, causing duplicate entries :(
Does anyone knows how can i avoid it to happen?
And, how can i retrieve a setting from the ini file to a textbox or messagebox or something?
(before anyone start saying me to use .xml, i was reading and i prefer the .ini files to what i'm doing)
how i can use stored procedures with parameters to retrieve data and display it in a report viewer in VB 2005.
View 1 RepliesI have a task to create a web service to receive client-side app's http request(with rpc={json data} in the end), deserilize it and put he parameter in stored Procedure in order to retrive data from sql server. the procedure query and client-side's app are already there and the return data to client-side app is JSON too
View 1 RepliesI have one project that manage my database connection (DBServer) and one project as the main system (MainSystem). In DBServer I store all my connection data that I already managed to my.settings (ServerName, DatabaseName, connectionString, etc). How can I get all the my.settings value in DBServer (ServerName, DatabaseName, connectionString, etc) from MainSystem?
View 2 RepliesI make project 1. I add 10 settings in the Properties->settings section.
I now make a new project. Project 2. But I want to have the same settings as project 1. It would be easier to import the settings from project1. but can this be done.
Ive seen the setting file in the explorer but this code is auto generated so if its copied into project 2 after you save its regenerated again from the properties->settings values.
I have a project that has several different interfaces (a website, a local application, and some webservices), that all use the same class library. The library is an API to a database. Some settings, like log level, database connection etc, i want to store in a single place, and I want them editable. What is the best way to accomplish this? I am concerned both about ease of editing, and ease of access for the dll, as there will be a lot of calls to it and a lot of lookups for the values. I have considered using app.config, a standalone XML file, and writing values to the registry, but I cannot find any good comparisons.
View 2 RepliesI want to add a setting that uses an enum defined in form1.vb. All the research I've done suggests support for enum type settings is built-in and handled automatically by the VS IDE ... I assume this means it's as easy as defining font or color settings. However, I'm not having much. Are any of you gurus aware of how to set up an enum setting via the Project Settings UI?
View 8 RepliesI am trying to bootup other executeable file from my project's resources folder, and I can't figure out how
View 2 RepliesIn a VB.Net project, you can use the Settings tab of the properties page to define application settings. To reference the settings in code, you use the syntax My.Settings.SettingName in VB.
On the Settings tab, you get to choose the Access Modifier. It may be "Friend" or "Public". Presumably, when you choose "Public", you are making the settings accessible to other assemblies. However, once "Public" is chosen, I can't figure out the syntax to reference the settings of one project from another. In fact, I can't observe any difference between using "Internal" vs. "Public" as the access modifier.
My question: Does choosing "Public" as the access modifier make settings accessible to other assemblies? If so, what is the syntax to reference the settings from other assemblies? If not, what does "Public" do?
I get this error
Format of the initialization string does not conform to specification starting at index 34.
When I take my connection string and store it in the project settings. I know that this works.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb
Because if I use it like this
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb")
conn.Open()
The connection succeeds but if I try this
Dim conn As New OleDbConnection(My.Settings.Default.employeeConnection)
conn.Open()
I get that error.
name:employeeConnection
type:string
scope:application
value:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb
I like the way one saves settings in VB.Net, that is, with the project properties. However, I want to develop a mobile project that includes saving some settings. Problem is that the project properties doesn't include "Settings" when developing a mobile project.
View 3 Repliesi have one project that manage my database connection (DBServer) and one project as the main system (MainSystem).In DBServer I store all my connection data that i already managed to my.settings (ServerName, DatabaseName, connectionString, etc).
View 2 RepliesI have my xslt's stored in a folder in my asp.net web application project folder.
Is there anyway i can call this style sheet from an asp.net web page?
Does anyone know how to retrieve a list of reports found in a project?
View 1 RepliesI use Project Setting in visual studio 2008 and everything works correctly and save my information when the application is closed. However the information it lost when the application is Uninstalled. The information is not available with my new install.how to keep Project Settings through uninstall and installs!
View 4 RepliesIs it possible to access the My.Settings of an other DLL referenced in the current Project? I have a Database project in which Settings the ConnectionString is stored. I need access to this Setting in an other Project(for Log-File).
View 2 RepliesIt must be to close to the weekend, but I thought I read at some time an article of an easy way to have a common settings file for both application and user settings across a solution.
I currently have a Solution that contains 4 projects. Each of these projects need to access the same set of settings and be able to update the user settings. Is there a way to do this utilizing the My.Settings functionality?
I have a Web Service Application Project in Visual Studio 2008. This is supposed to be an ASP.Net 2.0 project and at some point this has been rebuilt using 3.5.VS has kindly added in project level imports to System.Linq and System.Xml.Linq, but when I have re-targeted the project at 2.0 these project level imports have remained.Because the Web Service Application Project does not have the detailed window for editing project references I cannot find how to remove these project level imports.There is no .proj file which is where I would assume these were included.I cannot now build the project as it fails, even though I only get warnings (no errors reported) such as this:Namespace or type specified in the project-level Imports 'System.Linq' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
View 3 RepliesI just created a game program out of VBE2008 and did the build process to turn it into a .exe file.When I did the build function I apparently missed the step of attaching an icon to the project.Now when I do a desktop shortcut to the .exe file there is no pretty icon - just an ordinary looking window box.How do I add a desktop shortcut icon to inside the project settings?
View 1 RepliesThe Visual Studio Settings and Project Designers Package ({67909B06-91E9-4F3E-AB50-495046BE9A9A}) did not load because of previous errors. For assistance, contact the package vendor. To attempt to load this package again, type 'devenv /resetskippkgs' at the command prompt.
View 1 Replies