When we have code like this:
vb.net
Using connection As New SqlConnection(strConnString)
Using command As New SqlCommand(strQuery, connection)
command.Parameters.AddWithValue("@CuserID", intUserID)
command.Parameters.AddWithValue("@CstartTime", dtStartTime)
[Code]...
suppose we have three tables in the Database:
[Code]....
I am making a Texas hold'em poker game for my class project. I already have the cards in the game through an image list. I am now trying to compare the player cards with the flop, turn, and river card to tell the player what they have and if they have won or not. I have tried a number of different things but have come up short. This is the last thing I tried[code]...
View 6 RepliesI need some thought input on how I can take my string of HEX values and convert them to ASCII according to the specifications below: A function would be ideal since I need to quickly decode about 250 records all having 20 thresholds to record.[code]
View 14 RepliesI am trying to add a value to an array by converting it to a list [code]...
View 4 RepliesI'm looking for a fast way of searching a textbox containing plain text mixed with coordinate values.These coordinate values may contain no decimals or 4 decimal places after the decimal.I'm somewhat familiar with regex, but my uncertainty is the actual number of characters in each word will be different.[code]
View 2 RepliesIs there anyway to convert an image file bytes array into an array of the real RGB values of that image?
I don't really want to use GDI+ or the System.Drawing library, but simply apply a certain calculation/processing to every byte of the image file and get another array that contains the RGB values of every pixel in that image. I know it could be done as I know how to do it in a different programming language (Python) but not in Visual Basic.
how can i put the insertion key at the first textbox?
View 4 RepliesBeen looking at this for a few hours now, is it possible to insert into the FIRST line in a rich text box? I have a simple app that regularly copies a reference file to several PCs but I need to have the success/failure and timestamp visible, so I want to insert into the top line each time - ie. in descending order.
View 1 RepliesI'm having issues with returning a list of strings of the .Value of a Linq query:
Dim details = <Details>
<Vector size="5">
<Item>Syntactic Structures</Item>
<Item>Introduction</Item>
<Item>The Independence of Grammar</Item>
[Code]...
Is correct in that it returns the list of XElements I want (items 1 - 4, base 0), but I really just need a list of strings for the .Value of those XElements. Maybe I'm just dense here, but anything I've tried in the chapterTitles query isn't working (appending with .ToList.ToString, etc.). details.<Vector>.<Item>.Skip(1).Take(4).Value just returns the first XElement's value.
I'm an undergraduate student from Singapore University, would like to enquire you on how to convert character codes to ASCII codes using visual basic. regarding the codes on how to build it as I need it for my semestral project
View 3 Repliesi have a table with data definition: [code] My problem is that i can't see the inserted data in my table. [code]
View 1 RepliesIm confused on how to write a code on checking duplicates before insertion on vb.net. I know the sequence on how to do it but its kinda confusing when writing a code.
1.) Create a query that will check if the mobile number already exists on the database
2.) If not, insert the new data
3.) Else, a message will prompt that "You are already registered".
writing this in PHP is kinda easy for me but in vb.net.. , unfortunately, not easy.. Im still a beginner on vb.net.
[Code]...
I've been trying to learn enough to develop the family tree diagram and making progress.[URL]..It illustrates many of the drawing, saving, re-opening, editing, drag/drop features that the family tree diagram would need, and is a good starting point.
To adapt this for the project, after searching for snippets online, I've tried to add dynamic insertion of a label as a start (eventually, it should be a textbox that the user, in runtime, can enter text into, save, re-open, edit). But, I can't get this to work. No errors display, but I must be doing something wrong.
Here's the label code which I've so far appended at the end:
[Code]...
I'm getting this error when I go to insert data into access DB using vb.net 2008 which is specified by the user.
"OleDbException was Unhandled No value given for one or more required parameters "
If I hard code the values it works just fine.
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
[Code].....
I know you can do it with an WMI event or overriding WndProc and looking for the right messages, but i was wondering if there wasn't something hidden in the net framework that makes this task easyer.
View 2 RepliesI have a device with upon serial communication , it send the data as HEX values , (eg, C020042ABD0F91A103E400F929EBC) . I use the following code to get data from the serial port.
Dim fStream As New FileStream(sFileName, FileMode.CreateNew) ' creates new file
Dim bw As New BinaryWriter(fStream)
System.Threading.Thread.Sleep(1500)
ComTd.Read(data, 1, bCount)
[code]....
onbutton click, I want to convert a string from textbox1 to textbox2 but assign values to each character.
i want to assign an alphabet character, to another alphabet character or number.
for example textbox1 - "visual basic" to textbox2 "abcabc abcab"
example if "v" then "a"
if textbox1 "b" then textbox2"c"
I have a device with upon serial communication, it send the data as HEX values, (e.g., C020042ABD0F91A103E400F929EBC). I use the following code to get data from the serial port.
Dim fStream As New FileStream(sFileName, FileMode.CreateNew) ' creates new file
Dim bw As New BinaryWriter(fStream)
System.Threading.Thread.Sleep(1500)
ComTd.Read(data, 1, bCount)
Dim bCount As Integer = 4119 ' it is the size of the chunk not block size
Dim data(bCount) As Byte
[Code] .....
can i convert colors values to integer?
View 6 RepliesCreate a function named DecimalDegrees to refactor the code that converts a latitude or longitude into a value in decimal degrees. (This function will be used inside the functions ValueOf and Distance.)
Task 2a: Write the code for the function DecimalDegrees with an input parameter for DegreeString as type string, and returns the value as type Double.
Here is my code for the function part
Private Function DecimalDegrees(ByVal DegreeString As String, ByVal degrees As Double, ByVal minutes As Double,
ByVal seconds As Double, ByVal ID As Integer) As Double
I am having difficulties with the 2nd part which is I believe to take the code for the calc1 and calc2 buttons and somehow get it to convert to decimal degrees by the function I have created. The buttons would then be removed as the code would automatically take the latitude and longitude and convert the degrees, minutes and seconds into a decimal.
Here is the code for the current buttons:
Dim StartPtr, StopPtr As Integer
'To Replace Calculator 1 Button
'Convert degrees before passing argument - Latitude
StartPtr = 0
[Code] .....
I have recently been working on a number of sections of code that deal with the insertion of Nullable types into a database. As I'm sure anyone who has dealt with similar code will be aware of the annoyance of constantly writing conditional logic to deal with the insertion of nulls into a database. I.e.:
MyValue.HasValue ? MyValue.Value : DBNull.Value;
If(MyValue.HasValue, MyValue.Value, DBNull.Value)
Basically I am just wondering why DBNull.Value exists and why Null simply couldn't be used?
Why is it that this VB.NET code only works for detecting flash disks?
Select Case m.WParam
Case WM_DEVICECHANGE_WPPARAMS.DBT_DEVICEARRIVAL
MsgBox("USB Inserted")[code].....
What would be the possible way to detect the insertion and removal of other USB peripherals, such as mouse and keyboard?
I am having problem with my FYP that my application is based on the detection of Insertion and Removal of a device. I am aware that this would happen using Win32_VolumeChangeEvent class or WMI. (Please notify me if I am wrong). Kindly solve this problem and send the code for Console Application in VB.NET. Please do not send code in any script language or C#. Also to get the device information.
View 6 Repliesscardgetstatuschange DOES wait(timeout is set INFINITE by -1) for card-insertion after connecting the reader-device to the pc. After a card is being insterted the first time and removed again, it won't wait any longer and returns immediately everytime;
lResult = SCardGetStatusChange(DethContext, -1, rgReaderState(0), 1)
So, scardgetstatuschange CAN work. But why only when i re-attach the cardreader-device to the pc????
Actually in our project we create different database using vb form code..so this database is a chance of transferring to other users to use others database. so when we create the database it will insert the database name into the main database. Problem: One user who is accessing MS 2010 ACCESS has created a database and transferred into other PC where MS 2003 access available..when he is going to insert database name into main database which is transferred it is not inserting into main database exception is occured..
[Code]...
is there an issue, in [VB2010] for the trouble of the insertion of a transparent swf in an windows form ??
View 5 RepliesHow to check data in multiple rows is changed or not?If data is changed in exisiting row or rows, i want to do updation.
If data is added in new row or rows, i want to do insertion.
I don't want to use LINQ.
I'm using parameters on a SQL stored procedure to insert a record with data entered on a website form (and on the form I'm using VB.net). As of right now, the form works perfectly; the record is inserted. However, after the user hits the submit button, everything executes and then the page will basically refresh with emtpy values in all the fields. So I want to give the user some type of SUCCESS message, assuring the user the information was successfully entered into the database. So my question is: How can I verify that the record insertion was successful? I want to do this with the ExecuteNonQuery statement, because that's what I'm using.
Code is below:
If Page.IsValid then
Dim MyConn as SQLConnection= New SQLConnection("Blah")
Dim MySQL As SQLCommand
MySQL= New SqlCommand("proc_newWebEntry", MyConn)
MySQL.CommandType = CommandType.StoredProcedure
[Code] .....
I have dealt w/ SQL as back-end many times before, but this local CE database is driving me crazy. I have a dataset (CsDbDataSet) with my table (ServiceMonitor) all set up. I have the dataset configured for CRUD and everything looks just peachy there. The problem is that I cannot write directly to the table and have it show up. I don't get any kind of error, but when I run a SELECT statement on the table, I receive no data. Am I missing something?I am using the direct database access methods used herensert Method I am trying to use:
Dim ta As New CsDbDataSetTableAdapters.ServiceMonitorTableAdapter
ta.InsertRecord("Test", Now.ToString, "TestSvc", "TestSvcVer", "TestSvcStat", "TestNote", "TestProgram")
[code].....