|
when i update a record in the database using command from another form, the database becomes updated but the oledbdataadapter in the second form does not relect this changes until i restart the application. when I deployed the application, the changes do not even reflect even when I restart the application though the updated record appears in the database
this is the code i use to refresh the dataset.
Try
DsAsets1.Clear()
OleDbDataAdapter1.Fill(DsAsets1)
count()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
I am using Ms Access as my database.
David T. Motajo
|
|
|
|
|
Sounds like you have to somehow commit the dataset to the database.
"The early bird may get the worm, but the second mouse gets the cheese" - anonymous, found in Uncle John's Bathroom Reader
|
|
|
|
|
I am quite new to windows form programing. In my application i want to be able to show a dialog box that has a progressbar in it when the main form loads a set of images into memory. I have created the form that contains a progress bar in it.. now what?
Thank you very much
|
|
|
|
|
Load your images in a thread so your UI remains responsive, then update the progress bar when each image loads. You want to use the BackgrouindWorker class, it can send messages to the UI thread to update progress.
Christian Graus - Microsoft MVP - C++
"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 was wondering if it possible to get VB to connect to a MySQL database or not, I've tried a few tutorials and I can't get it to work. I Don't want VB.NET to do it as I'm running this script on server that only serves PHP
|
|
|
|
|
Do you mean VB6 or VBscript ? Neither has anything to do with PHP.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
Andrew Brock wrote: possible to get VB to connect to a MySQL database or not
Yes it is.
Andrew Brock wrote: I Don't want VB.NET to do it as I'm running this script on server that only serves PHP
Huh?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
You can use VB6 as well as VB.NET to connect to MySQL. You will be needing ODBC data source for MySQL for that. This can be downloaded from MySQL site.
Nav
|
|
|
|
|
You should have directed your post to Andrew 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
thanx guys I have since done anoth way using PHP. To answer the question why PHP the place I am building this for don't have Windows Server Licenses so they are using Linux but people can use Windows laptops to connect to the internet and other stuff like that
|
|
|
|
|
if can not used in vb.net ,if there other language or tool can used to detecting the mic
|
|
|
|
|
Don't start a new thread for follow up questions.
Christian was talking about physical limitations, it has nothing to do with the programming language you are using.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi,
I wondered if anyone could help me (again). In a database, I have a list of users and their portfolio paths. I have got them to load into a list box. I need it so when a user clicks on a user ID from the list box, it shows the content of the folder in an explorer style window (using icons).
Being good at VB6, I can do that quite easily and the standard TreeView in .net is a bit dull and I have no idea how to do what I need to do.
Could anyone help me with this problem?
My sincere thanks.
|
|
|
|
|
Hi,
I wondered if people could help. I have a program which imports users and creates a folder for the user. The users details (including network username, folder path etc) are stored in a database. That all works fine.
I now need, as part of the import process, for the program to set the folder permissions so that the user has modify access permission and the group 'staff' have full control. Being new to this, I am a little confused as to how to do it. I have looked into it online, but it is not clear.
Could anyone help me please?
-- modified at 16:56 Tuesday 6th November, 2007
|
|
|
|
|
Hi Everyone,
I wondered if anyone could help me. I am baffled with this one. I am trying to allocate permissions on folders within my program. I am aliasing Imports Microsoft.Win32.security. When I do, I just get the error: Namespace or type 'security' for the Imports 'Microsoft.Win32.security' cannot be found.
Any ideas?
Many thanks.
|
|
|
|
|
Have you added the reference to the appropriate assembly. (Right click on the project in the solution explorer and select "Add Reference..." and pick the assembly from the list in the first tab)
|
|
|
|
|
Found it, just as you suggested it. Thank You 
Not used to VB.Net Environment.
Many thanks.
|
|
|
|
|
chrischome wrote: Found it, just as you suggested it. Thank You
You're welcome.
|
|
|
|
|
I have a Windows Forms Project with a form that has a DataGridView with 15 columns. Depending upon criteria when the user navigates to the form, some of the columns are hidden. Some of the columns are defined at design time, and some of the columns are added via connecting the DataGridView to a datasource in the page load event. After loading the DataTable that is the DataSource to the grid, I set the DisplayIndex of each DataGridViewColumn to the order I want them to appear in. However, when the screen loads, they are still not in that order. I have added code to make the DisplayIndex appear in the column header text, and it goes
0, 2, 4, 3, 5 ...
Column 1 in this case was not visible, which was correct...but why isn't it
0, 2, 3, 4, 5 ...
I tried NOT hiding the columns I want to make invisible and that didn't fix it. I made sure I'm setting the DisplayIndex for all of the columns and that didn't fix it. I'm out of ideas. What other settings are involved with reordering the columns on a DataGridView? Or what other settings could interfere with this? I would appreciate any help or advice.
|
|
|
|
|
hi,
how detecting headset mic plugged in to computer?
|
|
|
|
|
can't. The only possible way is to detect input on the mic, you can't just tell it is there.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
when i update a record in the database, the database becomes updated but the oledbdataadapter does not relect this changes until i restart the application. when I deployed the application, the changes do not even reflect even when I restart the application though the updated record appears in the database
this is the code i use to refresh the dataset.
Try
DsAsets1.Clear()
OleDbDataAdapter1.Fill(DsAsets1)
count()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
I am using Ms Access as my database.
David T. Motajo
-- modified at 16:01 Tuesday 6th November, 2007
|
|
|
|
|
What do you mean that the oledbdataadapter object doesn't reflect the change? Because if you mean that it doesn't show the updated data, then you are looking at the wrong object. The DataAdapter is used to update the database, but it doesn't contain the data. The DataSet object does. That would DsAsets1 in your code. How are you displaying your data? How are you determining that the change is not being reflected in your app?
|
|
|
|
|
I am using textboxes to display the data and a navigator to browse through it. but the dataset cant pick up the newly updated record unless i restart my application.
this is the code i use to insert data in the database. I'll try and keep it short by just giving you the insert statement.
mycmd = "Insert into Assets(AssetID,AssetDescription,AssetCategory,Department,DateAcquired,Cost,ModelNumber,DepreciationPercent,MaintenanceType,comment,Location) Values ('" & assetId & "','" & assetdescription & "', '" & assetcategory & "', '" & department & "', #" & dateacquired & "#, '" & costprice & "', '" & modelnumber & "', '" & depreciation & "', '" & maintenancetype & "', '" & comment & "','" & location & "')"
conn.Open()
mycommand.Connection = conn
mycommand.CommandText = mycmd
myadapter.InsertCommand = mycommand
myadapter.InsertCommand.ExecuteNonQuery()
conn.Close()
and this is the code i use to retrieve the data from the database.
Try
DsAsets1.Clear()
OleDbDataAdapter1.Fill(DsAsets1)
count()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
when I search for the data using the following code, I could see the data but the dataset can not pick it up
conn.Open()
Dim cmd As OleDbCommand = conn.CreateCommand()
cmd.CommandText = "SELECT AssetId, assetDescription, assetCategory, Department, DateAcquired, Cost, ModelNumber, DepreciationPercent, MaintenanceType, Comment,Location FROM Assets WHERE AssetID = '" + assetId + "'"
Dim reader As OleDbDataReader = cmd.ExecuteReader()
reader.Read()
If reader.HasRows Then
txtAssetNo.Text = (reader.GetString(0))
txtDescription.Text = (reader.GetString(1))
cmbCategory.Text = (reader.GetString(2))
cmbDepartment.Text = (reader.GetString(3))
dtpDateAcquired.Text = (reader.GetDateTime(4))
txtCostPrice.Text = (reader.GetDecimal(5))
txtModelNumber.Text = (reader.GetString(6))
txtDepreciation.Text = (reader.GetDecimal(7))
cmbMainType.Text = (reader.GetString(8))
txtComment.Text = (reader.GetString(9))
txtLocation.Text = (reader.GetString(10))
BindingNavigatorPositionItem.Text = 1
BindingNavigatorCountItem.Text = "of " & "{1}"
BindingNavigatorMovePreviousItem.Enabled = False
BindingNavigatorMoveNextItem.Enabled = False
txtFind.Text = ""
|
|
|
|
|
Do you have the .SelectCommand.CommandText set in the OleDbDataAdapter1 object before you retrieve data from the database? It should be the same as your SELECT when you are using the OleDbDataReader. You also must have the connection set, but I'm assuming you just didn't show us that code. So how are you tying the DataSet to the textbox/navigation controls? Are they showing the OLD data, or do they just get cleared after you perform an update?
You should try to put a breakpoint on the line right AFTER you've filled the DataSet. Then quickwatch the dataset and look at the data you have brought back. Here you will be able to see if the DataSet is actually bringing back the updated data. If the data is the updated data, then the problem is however you are connecting your textboxes to the DataSet.
I do things very different than you, so I'm kind of confused by your code in general. If you are just going do an execute non query you can do that with just a Command object, you don't need the DataAdapter. Like this:
mycmd = "Insert into Assets(AssetID,AssetDescription,AssetCategory,Department,DateAcquired,Cost,ModelNumber,DepreciationPercent,MaintenanceType,comment,Location) Values ('" & assetId & "','" & assetdescription & "', '" & assetcategory & "', '" & department & "', #" & dateacquired & "#, '" & costprice & "', '" & modelnumber & "', '" & depreciation & "', '" & maintenancetype & "', '" & comment & "','" & location & "')"
conn.Open()
mycommand.Connection = conn
mycommand.CommandText = mycmd
mycommand.ExecuteNonQuery()
conn.Close() Also, you may want to look into using parameters for insert statements like this, to avoid SQL Injection. And there are ways to update the DataSet and have it automatically generate the proper Insert or Update or Delete statements for you. You may want to look at some articles about this if you are interested.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
