In your call to the dataAdapter.Fill just pass the dataset you want to be returned. YOu have to leave the correct table name in the sql query. Then when you access the tables, if you know you are only getting one table back you just need to access Tables(0)
I told you before, you don't need all this code.
You're unncessarily reading the database into a DataSet, selecting the records that you've already selected in the SQL SELECT statement, modifying the data and (trying to) write the data back. You don't have to do this.
Here a hint for the SQL statement you should be using:
UPDATE [Caller Records] SET FirstName=@FirstName, LastName=@LastName,
Type=@Type WHERE RecordNo=@RecordNumber
All of the words preceded with an "@" symbol are named parameters that you fill in with the data from your textbox's. You don't have to retrieve anything from the database to do what you want to do.
You can find more information on parameterized queries here[^].
in Access each table has only one autonumber field. Therefore, I assume that you are trying to place the strings in different tables (right?). If your aim is to write these strings in to one table, I suggest you to use a loop and retrieve the strings and then place those to table one by one.
I need to implement udp protocol in C#/VB.net Win Forms that send some request to the broadcast address from specific port and then change to be client and receive multiple answers from the broadcast on the same specific port.
My questions are:
1.Is the first connection should use blocking (synchronous) functions ?
2.Should I close this first socket,and then open another one on the same port in order to get the broadcast answers ?
3.In which way should I get the broadcast answers:a.using asynchronous function and events like BeginSend/EndSend etc or b.using threads ?
4.How do I get multiple answers on the same port in this case ?
2) use 2. one to speak another to listen (2 different ports)
3) i have used both...the threads is easier (less events to worry about)
4) a thread per message will be created, so just process them as they come in.
Assume there is a file called .dat. In that has a lot of texts.Its size is more than 400 kb.
In VB, i read the .dat file and store it in a string variable.
is it possible to store all the texts in a string?
It doesn't work because a Word documnet is a multiple stream, binary format that doesn't work very well with any of the FileStream classes.
You have to open the document in Word to search for some text in it. This goes WAY beyond a simple text file reader and an Instr function. Now your getting into Office Automation. You can start with the documentation here[^].