I will have to perform updates/inserts/... on several relational tables of an Access database but I know that the Command builder usage is limited only to one table at a time.
View 1 Repliesi'm using this code to try and write a value to a table in an access database. when i try to write oledb.oledbcommandbuilder, intellisense doesn't recognize this but it doesn't throw an error up for that line either. when i try to execute this code i get the error "syntax error in UPDATE statement"
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUPdate.Click
Dim myConnection As OleDb.OleDbConnection
Dim ds As New DataSet
[code]....
I'm experimenting with the sql command builder and it seems to do nothing when trying to update existing rows. If I create a new row and then add it then it works fine but I cant seem to update an existing record.
Heres what I have at the moment
Code:
Dim strConnection As String = "Server=myServerSQLExpress;AttachDbFilename=C:databasepath estdb.mdf;" & _
"Database=testdb; Trusted_Connection=False;User Id=sa;Password=test;"
[CODE]...
But I'd really like to find out why its not working when using the command builder. I'm working with VB.net 2010 express and SQL server express.
I want to ask how to i , passed the value i get from my previous form using this"Login.user.Text" to a Query Builder to filter the result based on the value of Login.user.Text" .
SELECT LecturerID, Lecturer_P
FROM Lecturer
WHERE (LecturerID = ??? )
[code].....
I'm using a datagridview to display data and make updates to my access database. I was able to display data from my database to the datagridview but it is not filtered. The datagridview displays all the records on my database. I tried using query builder to execute sql select statements that will filter the data and this is where I'm stuck. Im using a variable as a parameter to the sql statement and I dont know what syntax to use in Query Builder. I tried to use @varname, '" & varname & "', and
View 1 RepliesI use visual studio 2008 with an access database.I can read the data just fine, but when I try to update the database, I get an error:"Update requires a valid UpdateCommand when passed DataRow collection with modified rows."[code]The spaces indicate different parts of the code, but I just left out the non relevant parts.
View 1 RepliesI am using a Command Builder for OLEDB, I populate the Data table from the database, and then I use data adapter's Update method to add or update the database successfully.
[Code]...
I'm running Visual Basic.net. I used to use the INKEY command, available in older DOS versions of Basic, to allow the user to change the flow of a program by touching a keyboard key. It seems to be available only in Visual Fox Pro. Is there an alternative for Visual Basic?
View 4 RepliesI have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
OpenFileDialog.ShowDialog()
Connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & OpenFileDialog.FileName
[code].....
I seem to be having a problem when attempting to insert a new record into my database through vb.net. From what I can gather, there seems to be an error in the code that the command builder (cBuilder) is creating for me. [code]...
View 5 RepliesIs there are VB.net alternative to the C++ command of set active window.text ? (its something like that) baisicly this command renames the active window to what ever you want, is VB.net powerful enough to do this?
View 3 RepliesAn excel addin was used for a report data from database employing flat files. This addin uses activeX controls to acheive the above functionality. However it was later identified that when associated with digital signature to make it run under high security settings the whole addin crashed.
However the Point of concern now is'A new dll has been developed that encapsulates all the functions of the existing addin.' The addin was registered and as it was used, it created multiple instances of excel objects vigorously. However it was identified that this was due to a portion of the code that caused a command bar to the inserted as shown below Set cbar = CommandBars.Name("My data extracts")
Can an alternative code snippet be given which would insert a CommandBar?
the sub I right now is this:
Code:
Private Sub DetermineTicketNumber()
Dim objConnection As SqlConnection = New SqlConnection(strConnectionString)
Dim objDataAdapter As New SqlDataAdapter
[code]....
My question is, how do I access the value that MAX() is returning from my SQL query?
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK?
DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
I created a report viewer app that takes a command line parameter, the report filename, and opens the report. I also created a ODBC File DSN that I want to redistribute. However, currently, the DSN needs to reside in 'c:program filescommon filesodbcdata sources'. Is there a way for the report to look for the DSN in the application directory? Also, what components besides .NET 3.5 are required to redistribute the report and report viewer app?
View 1 RepliesFirst let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
Im trying to make an EXE with a GUI have made so they can input there info and make the program.
Im trying to make a mail sender
Trying to do another replace method ' Strip URL text to generate correct download link
[Code]...
below is the "Filter Builder" for the OS Event logs.
My Question is, is it possible to use this dialog in VB.Net? i would like to be able to call it in order to generate the XML which i would then use in conjunction with the EventLogQuery.
I'm trying to modify a dataset with designer and when using the query builder to get the month or year of a date field query builder transforns month(date)into [month](date)
Where do I get all the functions that can be used in Query Builder?
i was wondering if there was something i can use in VB which will let me have some fields in the DGV query to automatically have the format of 0.0000? There are some fields in that query which require this format. The Crystal Reports that accesses it gives incorrect info without this format type.
View 6 RepliesI'm looking for a form builder / questionnaire system that will let me build a questionnaire and collect data for insurance applications. I don't want to have to build this whole thing by hand. I've looked at a few options out there and the closest is Formulator.Net [URL]. What Formulator is lacking, though, is a way for me to pass parameters to be stored in the results in the database so I can identify who filled out the form.
View 1 Repliesbefore getting into this I'd like to say that I'm very inexperienced. I know how to work vba in excel and a basic idea of how to program in VB. With that said, I need help with something I wanted to make for quite a while. So I'm in an orginization called Civil Air Patrol (or CAP). We have a certain order our ribbons on our uniform have to be. The ribbon on the bottom right is the least important ribbon and the one at the top left is the most important one.[URL]I tried making this program before, but I completely failed and threw it out. My main concern is displaying the images of the ribbons in order.
View 17 RepliesI've been using sandcastle builder to make my help file documentation for our code base. It works real good just out of the box, but I need to customize it a little.How do you you format remarks? In the xml comments in code, you can have tabs and carriage returns and such to make things look readable, but all that get's taken out by Sandcastle and it gets converted to one long paragraph.For instance:
''' <remarks>An example of how to use this function would be:
'''
''' Using Selector As ObjectSelectors.FacilitySelector = [code]......
Would end up looking like:An example of how to use this function would be: Using Selector As ObjectSelectors.FacilitySelector = ObjectSelectors.FacilitySelectorUtils.GetStandardFacilitySelector(Me.m_Project, Me.m_Map) Selector.Text = MessageCaption If Selector.ShowDialog = Windows.Forms.DialogResult.OK Then 'add these facilities to the list For Each FacilityRow As Data.DataRow In Selector.SelectedItems If Not Me.BarricadingFacilityTable.Rows.Contains(FacilityRow(0)) Then Me.BarricadingFacilityTable.ImportRow(FacilityRow) End If Next End If End Using
I know there must be some kind of tag I can use - or would it be a bunch of tags? Or is there a setting in Sandcastle Builder?
I'm making a builder for a simple ftp client, but i have a problem.I have readed a tut about a builder with a stub, thats done but i only can fill in 1 form, but how can i make that my builder fills 2 forms in the client?
My code in the stub is:
Dim options(), text1 As String
Const FileSplit = "@vorfin@"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FileOpen(1, Application.ExecutablePath, OpenMode.Binary, OpenAccess.Read, OpenShare.Shared)
[code].....
i have this win form app that performs a database search of customer information. I have a datagridview, a binding navigator and a fill/addquery toolstrip with a toolstrip button and a textbox.Here is my query, i want to find all customer names like what i enter in the textbox
SELECT ACCOUNT_NUMBER, COMPANY_NAME, COMPANY_ADDRESS, BILLING_ADDRESS, CITY, STATE, ZIP, COUNTRY, PHONE FROM tblCustomerInfo
WHERE (COMPANY_NAME LIKE @COMPANY_NAME + N'%')
i am using sql client with a datagrid and i already bind the data to the grid as a dataset automatically so i did not manually code the connection, cmd, dataset ect here is the find button code that recieves the customer info according to the sql query
Private Sub FillByToolStripButton_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillByToolStripButton.Click
Try
Me.TblCustomerInformationTableAdapter.FillBy(Me.CoCustomerAccountInformationDataSet.tblCustomerInformation, COMPANY_NAMEToolStripTextBox.Text)
[code]....
COMPANY_NAMEToolStripTextBox.Text is where the the Customer Name will be entered... I originally called it txtName.Text but still even when i changed and did everything through the query builder I get nothing when i run the query.
I've search this forum and haven't found the answer to this problem and bing new to VB 2010 [cod]e...
View 8 RepliesI want to distribute my downloader base, but not the actual source code. I've got some parameters in the downloader which the user needs to change, such as the download link and file description.How do I create a program that changes these? The user will insert the desired values into the builder, and the builder will create the downloader.exe that can be distributed to other people.
View 22 Replies