I'm working on my own project management software and I'm having trouble linking the database with the interface and then coding it so that the components interact with the database. Can anyone refer me to a good tutorial. I tried the MSDN and found that to be a little too over my head.
View 2 Repliesi'm trying to set a password in my database using vb.net.here's my codes..
Private Sub btn_ok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_ok.Click
Dim chkpass As Integer
Dim strsql As String
[code]....
I want to set a password to my database..I used DAO to access a database..It is MS-Access 7.0 Database..I searched lot of forums, but i found only with ADO..I tried this concept with DAO.. But i couldn't get.
View 1 RepliesI want to insert text into an empty database.I create a database using Access and now I want to insert text1) first I Added the data source2) I drag and drop the Fields into the dialog Form3) using dataview I inserted the database onto the dialog form4) added a little bit of code...5) Built the program and the database shows nothing...do I need to make a Query or something...bind the source
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[Code]...
I have created a project with my forms & a little bit of validation logic, the basic skeleton of the project looks just fine.The data that I have for the project is currently in 2 Excel spreadsheets, so I have created a database within my project (I chose a SQL option, even though I have only ever used Access in the past) & I now have Database1.sdf & MyFinancesDB.xsd in my Solution Explorer.
I have created 2 Tables, the same as the Spreadsheets & have created Columns as necessary, and also set up Primary keys in both Tables and linked the Primary key of the Parent Table to a keyed column in the Child Table ... I *think* I have done what I need to do.Now, the big question (assuming I have set things up correctly !) is how do I import / load the data from the Excel spreadsheets into the SQL Tables?
i have so far set up a form to save data into a database and i am using:
[Code]....
i have so far set up a form to save data into a database and i am using:
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0.;" & _
"Data Source = F:Database1.mdb"
con.Open()
I tried saving the database as i did with images in the resource folder and used my.resources but this didnt work is there any way i can save the database into the project folder and link to it no matter whan machine i am on?
I tired the following Query to access my SQL Server database. It returns an error. SELECT Name, Address, PhoneNo FROM dbo.tblContacts where name=?
[Code]....
Does the database connection have to be set inside a TransactionScope?
Or can I set it in the ctor and then have instance methods create up a TransactionScope?
EDIT: e.g.
Public Sub New()
Dim conn = new SqlConnection(...connection string)
Public Sub SomeClassMethod()
[Code].....
the question is do you need to create the connection to the database after you've created a TransactionScope or can it be done before?
have a problem in setting hyperlink text property from database at runtime....Iam struggling to connect the database values to dynamic hyperlinks.
View 7 RepliesI have an application that's going to be portable so it's likely the path of the database itself (access mdb file) will change so hard wiring the path in the app.config isn't practical. I would like to create a 'Settings' form for the user to enter the path (browse for would be ideal but I can figure that out later) of the database file and save it for future use with the same app. I've found a few things out there talking about creating a new app.config file alongside the original with a 'key' defined but I'm not sure how that relates to the original app.config and how it would call the new variable to make the connection.
View 3 Repliesi have a program that connects to mysql database to check username/password.I have a line like this in the project:
conn = New MySqlConnection("server=myserver.info;Port=3306; user id=dbusername; password=dbpassword; database=dbname")Anyways, a user managed to get this info from the program
How can i make it so they can NOT grab this info from the program ?
I have a project that I used the 'Connect to Database' tool to set all the bindings and table adapters, etc. Currently the database is housed in the same directory as the exe. I was asked if I could have the database location be a dynamic value. My question is when you set up a project to work with a database using the 'Connect to Database' tool, how can you change its location?
I found this setting:
ASRDBConnectionString
But its read only.
Within that setting is text that says: DataDirectory
So thought that might be a variable to change somewhere....but can't find it.
I am not going to explain my whole project or why I want it do this...Ok... so for example my myfile.txt file would contain the word "hello"ashuming this would work (which it didnt):dim myfile as String = application.startuppath("/myfile.txt")on form1 load: textbox1.text = myfileunfortunately instead of it sending the value of the file it sends to file location.
View 8 RepliesI'm using VB2010 (10.0.40219.1 SP1Rel) and .NET 4 (4.0.30319 SP1Rel) on Windows 7, when I press F1 for a VB item I get help for VB 2008 and .NET 3.5; how do I set those to the correct values? I have run "Check for updates online" under "Manage help settings", and rebooted; no change.
View 3 RepliesHow would I go about setting an active window? I've researched and I can use "SetForeGroundWindow". I have tried, but I still can't get it to work.
View 9 RepliesThe Window Layout setting seems to have gone away in VS 2010. I'd rather my environment default to Multiple Documents. I really can't stand Tabbed. Tabs are good for browsers and cell phones, but not so good for a programming IDE.
View 2 RepliesI have a problem setting the checked state of checkboxes in a listview programmatically.
Background: I have a Windows Form Application which uses CheckedListBox�s. The names/labels for each CheckBox in the list are imported for a database. Also in the database is a field which defines whether the CheckBox should be Checked or Unchecked. The program works fine.
Problem: My requirement is to add a tooltip to each item in the list of checkboxes. I have read that the best/easiest way to do this is to use a ListView instead of the CheckedListBox. I have setup a ListView with CheckBoxes = True and View = Details. I have populated the ListView with the items from my database. The ListView now looks exactly like the CheckedListBox and the tooltips work fine.
My problem is that I can�t seem to find a way of setting the CheckBox�s to Checked programmatically. Is there a way to do this, or is there a better way of achieving what I am trying to do?
I have an existing zip file. I would like to set a password to my existing zip file. I know how to zip, unzip using SharpZipLib. I am wondering, Is there a way to set a password without extracting and re-creating the zip file with password?
View 3 RepliesMy app needs a config file that can be written to by the user. I've got the Setup project to install it to [CommonAppDataFolder][Manufacturer]][Product] but that folder is then read only to normal users (which defeats the point really!).
I've read various articles on the internet on how to solve this, ranging from making the app a Full Trust ClickOnce app to running a separate app post install to change the permissions.
This is in a RichTextBox. I'm making a string of sports stats and I need to have them aligned neatly in the RichTextBox. Here is an example: str = "12/24 (tab) 225 yards (tab) 2 TDs (tab) 2 INTs" When I use the vbTab constant in place of (tab) I run into problems as the size of the text in each column can be different which makes the tab not balance out correctly.
[Code]...
In my Windows application I have 2 forms, Form1 & Form2 in Form1 there is a Button so now I want to place the form2 exactly bottom of the Button when I click.
View 3 RepliesLets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
View 7 RepliesI am trying to set custom paper size on my printer with Winspool.drv. But getting error as 'Attempted to read or write protected memory.'
Private Sub btnTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTest.Click
Dim hPrinter&
[Code].....
I'm trying to set hotkeys for all my favorite websites. When one of these hotkeys are pressed, I want it to load the assigned website in internet explorer, but I want internet explorer to load on my SECONDARY monitor. I've already set out the hotkeys to load internet explorer, but it loads on the wrong screen. How to check if an instance of IE is already running. To be a bit more specific: the secondary monitor is set to the LEFT of the primary one. And the resolution is at 1440 x 900. So basically, I want to programmatically set IE's position to (-1440, 0) from within my application itself.
View 5 RepliesI didn't understand something about DateTimePicker control, on one of the site i found the Private Property Hour() as integer this property was used. And inside it was:
[Code]...
I am passing a function a parameter of browser_id, when i try to add it to my function, it throws an error
WebBrowser + browser_id + .Document.....
I dont know how to make it gerneric...
Can someone clarify if there is ever a need for the below?
When setting a textbox "Visible" property to False is there any reason why I should also set the "Enabled" property to false.
To make this short and simple, I'm developing a program that goes full screen but cannot allow the user to close or Alt-Tab out of it. The program is responsible for giving out tests that teachers create for various students and, to deter cheating, I was going to have the program block attempts to close it (I have that figured out already) and stop Alt-Tabbing out of it.
I looked up SetWindowsHookEx, but I was never good with PInvoke's and my attempts to get it to work have resulted in nothing.
This is my current
<DllImport("user32.dll", SetLastError:=True)> _
Private Shared Function SetWindowsHookEx(ByVal hookType As HookType, ByVal lpfn As HookProc, ByVal hMod As IntPtr, ByVal dwThreadId As UInteger) As IntPtr
[Code].....
I am developing a point of sale for a buddy.The system it will be on will be running nothing but this application. The system SHOULD always stay at 1024, 768 but i like to plan for problems.What I would like to do is on form_load change to 1024, 768. On exit, (for learning sake on my end) I would like to have it set back to the default.
View 6 Replies