|
OK, if you make that more prominent by editing your original post, you may get lucky, someone who has used it may read it. I'd even put it in the header, actually, to help attract the rare people who can help.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
I'm doing a masterdetail form, so far when you typed the data in the detailed form and datagridview, it works, but the moment you save it and load it again nothing appears in the datagridview, but the one in the detailed form works properly
here is the code I used:
Private Sub FrmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.OrderIDTableAdapter.Fill(Me.Database1DataSet.OrderID)
Me.ProductsTableAdapter.Fill(Me.Database1DataSet.Products)
End Sub
Private Sub ProductsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ProductsBindingNavigatorSaveItem.Click
If Validate() Then
ProductsBindingSource.EndEdit()
OrderIDBindingSource.EndEdit()
Try
Me.OrderIDTableAdapter.Update(Me.Database1DataSet.OrderID.Select("", "", DataViewRowState.Deleted))
ProductsTableAdapter.Update(Me.Database1DataSet.Products.Select("", "", DataViewRowState.Added Or _
DataViewRowState.ModifiedCurrent Or DataViewRowState.Deleted))
Me.OrderIDTableAdapter.Update(Me.Database1DataSet.Products.Select("", "", DataViewRowState.Added Or _
DataViewRowState.ModifiedCurrent Or DataViewRowState.Deleted))
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End If
End Sub
|
|
|
|
|
is this possible in visual basic.net?
cant seem to make it work
vb.net
using access database
oledb
update t1
set t1.f1 = (select sum(t2.f1)
from t2
where t1.code=t2.code)
ty in adv
|
|
|
|
|
You're posting SQL. Does the SQL work in Access ? If not, that is your issue. if so, then your issue is with the code you're not posting, the code that is appropriate for this forum. You know, in VB.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
In MSSQL, the syntax would be
UPDATE t1
SET f1 = SUM(t2.f1)
FROM t1
INNER JOIN t2
ON t1.code = t2.code
I assume it would be the same in Access. The key here is that the column receiving the update is not aliased, and any tables used in the update need to have their own references in the FROM statement.
Don't use old style SQL Join syntax (from t1, t2 where t1.code=t2.code) if you can help it. Its difficult to follow.
|
|
|
|
|
ty for the reply
but i get this error
Syntax error (missing operator) in query expression 'SUM(Accessory_Table.Qty * Accessory_Table.Cost) FROM Stock_Table INNER JOIN Accessory_Table ON Stock_Table.StkCode = Accessory_Table.StkCode'.
this is my actual code
"UPDATE Stock_Table " & _
"SET StkCost = SUM(Accessory_Table.Qty * Accessory_Table.Cost) " & _
"FROM Stock_Table " & _
"INNER JOIN Accessory_Table " & _
"ON Stock_Table.StkCode = Accessory_Table.StkCode"
maybe UPDATE and SUM doesnt really work together in access?
|
|
|
|
|
How to extract or get source code from a dll in VB
|
|
|
|
|
Do you own the DLL?
I suspect not - why would you make such a request to software developers, you know the people who create the DLLs you want to get the source from. If you do own the DLL then you already have the source and why are you asking. If you have lost the source then you a sh*t out of luck.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: If you have lost the source then you a sh*t out of luck.
Well put 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
One gets the impression that even if you got it, you'd have no idea what to do with it. Why do you want to get source from someone elses dll ? VB.NET or VB6 ? Do you have any idea about the .NET framework at all ? Why did you post this in two forums ?
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Christian Graus wrote: Why did you post this in two forums
Perhaps the clue train passed his station without stopping.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi,
i need to getting list of visited sites in Vb.Net.
please help.
Thanks
modified on Thursday, August 21, 2008 5:06 AM
|
|
|
|
|
Good luck, I hope it works out for you.
People usually use these forums to ask questions, ideally about code they have written, not about tasks they have accepted and have no idea how to even start.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hi I am new for .Net....
I work with Microsoft Visual Basic 2008
I want to import the csv(comma delimited values) file into my database(Access). I read the file using StreamReader(File IO) instead of database (OLEDB) connection.I read the line and splited each values by 'comma' and stored into an array of strings. The csv file may contain field names or not...
Now my problem is i want to read the records from csv file and store into database in appropriate field names in table(access)(I dont know how many records in csv and whether it contains field name or not, and also only selected fields are stored into database.)
Can someone explain?
Thanks in Advance...
|
|
|
|
|
You can open the mdb with any .net connection and use the INSERT SQL to import the csv data.
Ensure the target table is blank and make a Schema.ini file for define the schema of the csv file.
eg.
string sql = string.Format("insert into {0} select * from [Text;FMT=Delimited(|);HDR=No;DATABASE={1};].[{2}#csv];",
info.TableName, info.FilePath, info.FileName);
System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand(sql, connection);
command.ExecuteNonQuery();
for schema.ini
http://msdn.microsoft.com/en-us/library/ms709353.aspx
Emimmortal
|
|
|
|
|
Thanks for your reply....
My target table contains values(master table).I want to add the selected columns( appropriate values) from the csv file to related fields in the master table..(Mapping via field names, if csv doesn't contain field names we can assign...)
How is this possible...
Please explain...
|
|
|
|
|
When you create this post it suggested you first search the site and ot Google. This is one of the most asked questions ANYWHERE, do the searches!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
Im sorry. I know that this subject does not belong to this forum but I asked this question also in suggestions and saw no response.
I sent an article to codeproject about 2 weaks ago. I dont know why this article is still unedited.If this article[^]"> has fatal bugs or doesnt meet the CodeProject expected quality why people there dont inform me via e-mail? they seem too busy!
A.E.Kubanani
|
|
|
|
|
|
A.E.K wrote: why people there dont inform me via e-mail?
The article looks good to me. Don't worry, unedited means unedited. If they had looked at it to bother to email you, they would have edited it, I would presume.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Background: I have a datagridview that I am adding rows to manually. In design mode, I have specified the column header text on all columns to sans sherif, 14, bold (I have done this specifically to each column and also specified the font settings as the default header cell style). Various other formatting changes were made like making the highlighted rows yellow etc.
1. When I start the app, the column header text reverts back to the default header text sytle (Arial 8). What causes this to occur?
*EDIT* - in regards to #1, I found that if I reset the AutoSizeMode, the column header text switches back to one line. But what is the root cause of the grid losing the formatting at runtime?
I also found some posts on other sites that forcing a sort on the grid may at times clear the formatting. In this case, I'm not doing any sorts that would cause this condition. Any ideas on why this occurs?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
modified on Thursday, August 21, 2008 8:47 AM
|
|
|
|
|
I need to create a routine that queries a database whenever an event is fired. the thing is that I have to wait a specific amount of time before I execute that query. I am already able to run the sql query but I am not sure how to go about waiting the specified amount of time. Also each time the event is fired, it could require a different wait time, which could be up to 24 hours.
Right now I use a background worker to process the database query but can I (should I) use a wait inside the background worker?
Thanks in advance
|
|
|
|
|
Yes (and yes). There are two ways that come to mind if you need this kind of a wait. If you will not ever need to cancel the wait, you can just use Thread.Sleep, but if you may need to cancel (eg: to shut the thread down immediately), you can use an AutoResetEvent (or one of the other similar System.Threading classes).
As far as the variable wait time, just encapsulate the DoWork event handler in a class with the wait time as a field or property.
Here's a simple console app sample to demonstrate the two ways. Uncomment the lines and comment the Thread.Sleep line to use the AutoResetEvent instead.
Dim waitTime As Integer
Dim handle As New System.Threading.AutoResetEvent(False)
Sub Main()
Dim rand As New System.Random
waitTime = rand.Next(10, 20)
Dim bw As New System.ComponentModel.BackgroundWorker
AddHandler bw.DoWork, AddressOf WorkerRoutine
Console.WriteLine("Wait time will be {0} seconds", waitTime)
bw.RunWorkerAsync()
'Console.WriteLine("Press any key to interrupt the worker.")
'Console.ReadKey()
'handle.Set()
Console.WriteLine("Program complete...")
Console.ReadKey()
End Sub
Private Sub WorkerRoutine(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs)
Console.WriteLine("Beginning work")
System.Threading.Thread.Sleep(waitTime * 1000) 'gives a non-interruptable sleep
'handle.WaitOne(waitTime * 1000, False) 'gives an interruptable "sleep" period
Console.WriteLine("Ending work")
End Sub
|
|
|
|
|
Is there a good way to connect to a password protected Access databse usig VB.Net?
I tried some of those but it is still giving me errors!!
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="
|
|
|
|
|
I use an OLEDB connection with this connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
If you are looking for more connection string options this [^]is a great site.
Hope this helps.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
