What I have is a database in a Windows Form (via tableAdapters etc., basically the default stuff VS adds). What I need to do, is add a very simple record of a name and score (the "place" is an auto-number). I have not even been able to tackle sorting the table, because I can not even figure out how to insert...
View 8 RepliesI am trying to insert a new record though linq. I am able to update and read data with out any problem, but how to just inset a new record. Here is a start of my function.
Public Function AddAddressInfo(ByVal objdeptGUID As String, ByVal objGEOCode As String, ByVal objArressCommonName As String, ByVal objStreetAddress As String, ByVal objAddressNotes As String, ByVal objIsPublic As Boolean, ByVal objSesionToken As String)
''#Check of Token is good
If CheckToken(objSesionToken, objdeptGUID) = False Then
Return "Error"
End If
[Code] .....
ok I have a weird issue. I created a master record in the master table and then a record in the detail table. when creating the detail record i get a Specified cast is not valid error. Now another weird thing is that once I create the master record I can't query and verify it was created. But when i got to sql management studio I can see the master record. Below is my two procedures and the table definitions. Master table primary key is INVNUM child table primary key it INVLIN_ID and the reference key is INVNUM
View 13 RepliesI have been following a tutorial in a book Vb 2005 Jumpstart Ch 4..Anyway I have followed the books code exactly and the program runs.It connects to Amazons web service and allows the user to search and display books, the application also allows the user to save the titles that they wish by clicking an Add Title button, when the user does this the current focus title is saved to the database and can be viewed off line.When I hit the add title the record gets saved as I can hit the catalog button which opens a new form with a datagrid that has all the titles I just saved in it!! But when I close the app and run it again the catalog is gone?? back to no records again?Now ive never worked with SQL databases before and this is me just having a go at .Net so I have no idea whats wrong or where to look.[code]
View 6 RepliesTo clarify - I'm building a simple game in visual basic and I'm trying to create a simple file to record and display the "Best Score" from each game. Actually there are four levels in this game (each one is on a different form) - I'm trying to save the best score from each level to display in a separate Game Stats form. Therefore I creating a datatable on one form, but then trying to get all my other forms to access it.
But now I get a new DBNull error message in part of code not of my making - NewGameDataSet.Designer.vb
Error Message = "The value for column 'BestScoreEasy' in table 'GameTable' is DBNull."
Does this mean I need another New Statement somewhere?
Haveing troubles with an assignment. I am writting code that will allow user to enter a score and the program returns a grade based on the score entered. I can get it to work using "IF" statements but want to use code for ranges. My "IF" code is as follows.......
[Code]...
Haveing troubles with an assignment. I am writting code that will allow user to enter a score and the program returns a grade based on the score entered. I can get it to work using "IF" statements but want to use code for ranges. My "IF" code is as follows.......
[Code]....
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesI have two tables Products and Categories with a many to many relationship. I am trying to copy the categories linked to one product (OriginalProduct) to another product (newProduct). The problem is when I execute the SaveChanges() method, I not only get the records in my linking table, but it also creates another copy of the categories in the categories table. I've tried this in many ways but here are the last couple that I've attempted:
' Copy Product/Categories
For Each oneProdCategory In OriginalProduct.Categories
Dim relatedCategory = _productContext.GetObjectByKey(New EntityKey ("ProductInfoEntities.Categories", "RecordId", oneProdCategory.RecordId))
[code]....
I am writing a noughts and crosses game and I want to be able to keep score everytime each character wins a game, I have written a sub routine to handle this but it seems to count up in 5's and 10's??I have used a global variable like this Dim i As Integer = 1 then declaired that variable in my sub like this i += 1 (I thaught that this would just add 1 everytime X won a game)then used the variable i to add the score to the label control that keeps the score for the character X.My question is, am I using the correct syntax (+=) for the variable.
View 2 RepliesIm new to VB. how do I get to add the score.my code is
[Code]...
I have been utilizing Scott Gu's tutorials on LINQ to SQL to try to learn some LINQ. I have been able to view, retrieve, and update records but I am unable to write new records into the database (MSSQL). Scott starts getting into inserting rows in the fourth section of the set of tutorials. As you can see on that page (or may already know), in order to add a record you must do the following (VB.NET)[code]...
View 1 RepliesI have one problem regarding how to check whether the record already have or not then do insert or update.I'm using firebird database.i want to pull all record from one table to other database . Here my coding but i'm get stuck to do insert or update. [code]
View 1 RepliesHow can search record in my DataSet (fields: Name, Address, Phone#) for a certain name, given by user by clicking a combo box?
View 3 RepliesI have this form that acts as a patient history form, so when I click the "New record" button I want the form to be ready for new input and for it to save the data when I'm done. I also need a button to delete records, but I am completely terrible with databases so I have no idea what I need to do to add records. I assume I can just have the form clear to be ready for the input but I don't know how to get it to save the data.
The whole thing works in Access but I guess that's older VB or something, they were using the acRecord to be able to cycle through all the records of the database. What is VB.net's equivalent?
I am learning MS Access by reading books and i have no formal education on computers. I am trying to insert one record from a form (not bound to any table) by using VBA - Class Module. When following codes are run, the dialogue for parameter value of A and B are opened instead of using the value of variable A and B which is the value of txtbox1 and txtbox2 respectively .
Dim MySql as string Dim A as string
Dim B As String A = me.txtbox1.value B = me.txtbox2.value
MySql = "INSERT INTO tblcom (fieldA,fieldtB) VALUE (A,B)"
I made a window for the purpose of managing "profile" records
while the navigation and updating is working
i cannot seem to get insertion working, as well[code]...
when i press add, i get a new empty record, when i fill it in, i see that the collection sees it, as there is an onform listbox showing the profiles, and it gets listed there, so its actually attached to the list, but the savechanges command does not insert it into the db
there may be some validation errors upon insert, but then i would get some indication, right? now its just silently failing. as if i never tied to commit changes
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim conn As ADODB.Connection
conn = New ADODB.Connection[code].....
I have a problem with this code.It loops all records in tables SAP_CC and ORCL_CC and matches all records where amounts are equal in both tables. The problem arises when I need to update the tables.I need to update a column on tables SAP_CC and ORCL_CC, setting the records as matched and also to create new records on the CC_RECONCILED table.
In the If ¦ End If the line .Open("CC_RECONCILED") throws the COM Exception:Operation is not allowed when the object is open. I cannot close rsl¦Is there a way of achieving my goal?
con.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = Database.mdb"
da = New OleDb.OleDbDataAdapter(sql, con)
sql = "SELECT * FROM tblCustomer"
da.Fill(ds, "Customer")
con.Close()
[Code]...
i have a database with a hrd_users table whicn contains username and password as columns.and now heres my "add button" with this code. how to make it work? whats wrong with my code? [code]
View 1 RepliesI´m trying to update my Students table record using LINQ to SQL. The problem is when one of the Properties of the object changed and 'PropertyChanging' Event is fired using 'SendPropertyChanging()' method.
student_id is a PK
data types are matched
Here is the full ArgumentException:
GenericArguments[2], 'System.String', on
'System.Data.Linq.Mapping.PropertyAccessor+Accessor`3[T,V,V2]'
violates the constraint of type 'V2'.
[code]....
Our remit is to make a Veterinary Surgery Booking System.
I have an asp.net page that has 4 fields, one of the fields is populated on page load as per the vb code below.
I'm trying to get the selected value (or text) of the dropdownlist control and use it as the value for the first field in the record however every time I select the second or third value in the dropdownlist and click the submit button the new record that is created is inserting the first value in the dropdownlist.[CODE...]
I am pretty confused about lambdas. What I am trying to do here is write a function that will return an object from a certain table with a certain criteria. So lets say I can write:
function GetRecord(TableName as string,Criteria as string) as object
'do the linq-stuff
end function
Now I don't care if the parameters are strings or lambdas or whatever, but the end result must be that at runtime I don't know which table and which criteria will be used. As sometimes I need to get a customer record by email and sometimes a product by id etc. If possible I would prefer returning a list of matching objects and then I would just use .firstordefault when I want 1 (such as by id...).
I am using the following line of LINQ to drill down into an element. Is it possible to expands this code to drill further down so that I can add content to the <population> element in "Test2". I want to be able to do somthing like element.SetValue(1000000). However I need to expand the code below so that I can pass the entire query results into the variable called "element"'
Dim eles = From c In doc.Descendants("File") _
Where c.Attribute("Name").Value = "Test2" _
Select c
[code]....
I'm very new to linq and I'm trying to come up with a linq query against a dataset that will return a max count value based on grouping records.[code]...
View 1 RepliesI am using VB.Net in Visual Studio 2008 with a connected SQL Server Compact Database but for some reason I can not get a record to insert into my Database from my Windows Form.I have used the data connection on the form already to populate a couple of combo boxes but when it comes to commiting the data the sub runs through but there is no additional data in my database.my code is as follows
Private Sub cmdAddQuote_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAddQuote.Click
Dim cnData As New SqlCeConnection
Dim cdData As SqlCeCommand[code]......
Teh table only contains these 4 fields and another field which is an automatically generated number called nbrQuoteID .All of the fields are number fields but I have tried sending them as text to see if it made a difference (Threw up an error) but it didn't.
im using vb.net 2005 express to connect to Ms Access 2010, im trying to insert information from textboxes located in a vb form to a table in Access how ever its not working here is the code ive tried :
Public Class Form2
Dim cn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
[Code].....
Am trying to connect and insert a record into my database using vb.net this is my code:
cs = New SqlConnection("Data Source=AYACHMOHAMED;Initial Catalog=Employe;Integrated Security=True")
cs.Open()
sqlcom = New SqlCommand("INSERT INTO EMPLOYE VALUES 3, 'AYACH', 'PDG'", cs)
Try
[code]....
the problem is ra = 0 mean no insertion made I can't figure it out!
I have design a form in which there are three input field with one submit button.
Below submit button i have added DataGridview control also.
Now if i enter any data in those three input fields and press submit button then its should first popup for adding record or not, and if i press yes then the record should inserted into database table and also its should show in DataGridview.
i try to inser a record in my db but ii doesnt work,i try many solutions but only thedataset were updated , never the table in dbthese are my buttons with all my attempts:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....