I developed a package in vb6.0 backend as oracle 8.1.7, i instaled my package on nearly 50 client systems, every thing is fine except ,in some screens when iam saving the record it displays the message "Table or view does not exists", but this error is occuring only on thoes systems using other than Windows 2000 OS . What might be the problem
View 5 RepliesI created primary/start up Form for my VB2005 app (called Admin.vb). Now when I go back to the solution explorer, I can see Admin.vb but it doesn't have the form icon and clicking it doesn't open the form. Instead it opens the code.All of my other forms are fine and have the right icons and open in the [Design] view ...The form obviously still exists as it opens in runtime but I can't seem to open the design view for it.
View 6 RepliesI'm using the following code (System.Data.SQLite within VB.net)[code]...
I know the table exists because I can write to it via the command line through sqlite and through Autoit and can see it and edit it in the SQLite browser when I open the database. I don't understand why VB can't see it (I know it sees and opens the database file just fine).
I'm using ADO.Net to work with an Excel Document. Essentially, I'm looking up values in a table called "source" and creating a new table called "result" which will be populated with the results of my query.
I have a couple of questions.A) How can I check if a table exists and create a new one if it doesn't? B) Is a table the same as a sheet in Excel?[URL]...
I have a tenant details form that has a field called TenantID, I also have a Lease table that also has a TenantID field, what I want to do is click the lease button, check to see if the lease already exists, if it does open the lease form to that record. If not then open the lease form to a New record so the user can enter all the information for that lease.
I am trying to use the below code but am having a little trouble understanding how it all works. What needs to be declared, what doesnt
HTML
Private Sub btnLease_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLease.Click
Dim fm2 As New LeaseDetails
[Code].....
I'm trying to do an if statement to determine whether a value entered in a text box exists within a column..
View 6 RepliesI am looking to programme a button to check if an entry from a textbox exists within a table.
This will done via a button.
how I would code the button to make it query the table?
I have an 'invoices' table with a column for the invoice number.
When adding a new invoice, I would like to check if it already exists. If it exists, produce a MessageBox to the user that there's already a record with this number.
I'm using Visual Basic 2010 and SQL Server 2008.
i am trying to search a table in an access database to see if the value of a text box exists in it. I have this so far:
Dim myConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Application.LocalUserAppDataPath & "\Database" & "\Student Aid Database.mdb")
myConnection.Open()
[code].....
I wont to be able to check if a table exist, if not i wont to create it...
This is the code i use for connecting...
Code Block
Have a method who gets data from one table, put the data into variables before it it returned into the same table with changed ID etc. My problem is that it adds the first row without any problems, but when it is supposed to add row number 2 the error says tha the row allready exists in the table. and I can not understand why. I have put in a couple of messageboxes to se that the ID is changing and that the ordreID is correct and changing as they should and they do, but stll I get that errormessage.
My code looks like this:
Public Sub Ordreupdate()
Dim dtbl As New DataTable
Dim dt As New DataTable
dtbl = Kalkyle1DataSet.Tables("Ordre")
dt = dtbl.Clone
[CODE]...
Annyone who can see why I get that error?
I'm trying to create an option to select a specific entry in a SQL table if multiples exists. The Sub listed below is for a textbox (MOTxt) and a button (GotMO) for checking an MO# to pull from SQL. Based on the number entered, will populate other text boxes on the page with that row's data. There are exceptions to this, where the MONumber will be entered more than once with different data associated with each entry. So, here's my situation. If we have a duplicate MONumber listed in the table, it will populate the textboxes with the first entry it finds for an update.I would like to create a dynamic dropdownlist (that displays only if multiples are found) displaying the 'Name' field entries for each MONumber found, then once the correct name is selected from that list, to then populate the textboxes with that selected datarow.Here's my code behind:
Protected Sub GotMONum_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles GotMO.Click
Dim da As New SqlDataAdapter
[code].....
I'm trying to check if a LINQ Entity exists in its table, but at design time I dont know what type that entity is. So I figure I'll just get the table, and try the Contains method on it. But I cant get the table in such a way that I can query it at design time.I've tried the GetTable method on the datacontext, but I dont know how to cast it to the appropriate type when using GetTable(Of). GetTable(Type) works, I just use Entity.GetType(), but then I don't know how to query the ITable thats returned.To try and cast the ITable to something useable, I created an interface(IWhatever) that could implement properties that are native to all of my entities I would encounter. [code]
View 2 RepliesI'm trying to query old Access database tables and compare them with SQL Server tables.They often don't have primary keys, or they have extra fields that had some purpose in the nineties, etc., or the new tables have new fields, etc.I need to find records - based on a set of fields specified at runtime - that are in one table but not another.So, I do this kind of query all the time in SQL, when I'm comparing data in different tables:
dim fields_i_care_about as string = "field1, field2, field3"
'This kind of thing gets set by a caller, can be any number of fields, depends on the
'table
dim s as string= ""
[code]....
It tells me it can't convert a Boolean - Is there any way to do this without Linq expressions? They seem far more complex than what I'm trying to do here, and they take a lot of code, and also I can't seem to find examples of Expressions where we're comparing two fields in a subquery.Is there a simpler way? I know I could do the usual EXISTS query using JOIN or IN - in this case I don't need the query to be super fast or anything. And I don't need to use a DataTable or DataSet - I can put the data in some other kind of object.
I am making a simple database app in VB 2008 which will store products of a store thatmonitors info about, productId, productName, productPrice and the quantity left in stocks. I already created the database that stores this information, now I would want to do is have a feature w/c will make the user choose a row on the datagridview and then click a button then add productName and productPrice on to the listview control so far this is how my app looks like:
View 31 RepliesI am newbie with vb.net and i used the wizard,I have a tableadpter that references to a sql view and it is displayed in a grid.The problem comes when i update a table that is related to the view, i only can see the changes when i restart the application.
View 1 RepliesI am using oracle and trying to create a datagridview but when i try to create the dataset i get the error "could not retrieve schema information for table or view" stating my database and table name. I am using the Oracle client not the OLEDB as i have always used that and had no problems. I am using Oracle 11g.
View 6 RepliesMy problem doesn't seem to be with the SQL server. I executed an update statement inside the database manually against the view and I was able to update the Bar table. I'll close this and research the OleDbDataAdapters more since I think the problem lies with them.[code]...
View 3 RepliesI have this code where I get the tree view of a table in access database..what I want is ..I want to add nodes on each base on it's ID...
this is the table
CODE:
And the treeview's output will beme will be a child node of Pet base on ID_Menu same as the ID...
i search for gridview user control opensource that allow me to set tabename then its how tabe data and allow adding new row edit delete row , i searched online and didn't find any .
View 2 Repliesi want to create new report this report show data between 2 dates and it this data should be filtered Table1 fields : ID DateINOUT Table2 Fields : ID Name DepartmentID table3: fields : DeprtmentID DeprtmentName i need report to view data from date to another from table 1 and query from table 2 the name by id from table 1 also get department name by departmentID all that in same report
View 4 RepliesI am trying to write a program that will access a remote database and let the user edit different tables that are in the database.My program currently connects to the database however I do not know how to select or display a particular table to the user.
View 1 RepliesHow could I view data from my table through crystal report?
Here's my code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim cryRpt As New ReportDocument
[Code]......
I have a Link Table containing the ID field of several tables, how do I load the grid from the Link_Table based on the ID field of several tables loaded to the grid? [code]...
View 9 Repliesim using this code for create view joining tow table but its gived me error on 'INNER JOIN' :
Cmd.CommandText = "CREATE VIEW MyQry As SELECT TblData.Emp_ID,TblData.Emp_Name,TblData.Emp_Bonus,TblData.Emp_Salary,TblData.Emp_Sanction FROM TblData WHERE TblData.Emp_ID LIKE '" & LstEmp.Text & "' INNER JOIN
[Code].....
i want to know how to view data table in checkedlistbox and view selected record in another form.
View 2 RepliesI have to develop a small app for which I have to create a user control which is intended to be something like a Table View.On Form Load, the user should be asked about the number of rows of columns required on the form.Once the user sets the number of cells, each cell should have a button and a Text Box inside it (grouped together).
View 8 RepliesI am trying to retrieve the data from MS Access Table to LIST-VIEW, its difficult for me to write the code
View 4 Repliesi'm having problem saving my records into database here's my code
[Code]...
Update: My problem doesn't seem to be with the SQL server. I executed an update statement inside the database manually against the view and I was able to update the Bar table. I'll close this and research the OleDbDataAdapters more since I think the problem lies with them.This question applies to MS SQL Server 2000. How do I determine which table of the multitable view can be modified?
[Code]...
I realize I can write two update statements one for each table. My concern is different. I need to audit code that uses views like the one above and does updates on the views. I was hoping to find a way to determine which parts of the updates will be silently ignored.
I edit Bar.Column1 and then call the Update() method of the OleDbDataAdapter. This results in the Bar table not being modified nor is an exception thrown. If I edit Foo.Column2 then call Update() the Foo table does get modified.