|
Well, here is the code, I have also given the SQL field type.
Anyways, what are string concatenation. What is the difference between insert through string concatenation and parameterized queries. Can you please focus me that where am i going wrong.
con.Open()
trans = con.BeginTransaction()
Try
cmd = New SqlClient.SqlCommand("INSERT INTO issuec(cen, cses, ctdate, cttime, caction, camt, cde, cdch, crt, crr, cda, uc, cty) " & _
"VALUES('" & cen & "','" & frm.txtcses.Text.Trim & "','" & s_date & "','" & s_time & "','" & temp & "','" & a11 & "','" & sdepo & "','" & b & "','" & type & "','" & reason & "','" & damage & "'," & ccde & ",'" & cs & "')", con, trans)
cmd.ExecuteNonQuery()
cmd = New SqlClient.SqlCommand("update master set ccb='" & newbalance & "', cact='" & t & "',cldate='" & s_date & "', cl='" & lc & "', cde=" & cnt & ", cty='" & cs & "' where cen=" & cen & "", con, trans)
cmd.ExecuteNonQuery()
trans.Commit()
Catch ex As Exception
trans.Rollback()
End Try
con.Close()
Field type:
Sql1:
------
cen: numeric
cses: int
ctdate: datetime
cttime: char
caction : char
camt: numeric
cde : numeric
cdch : numeric
crt : char
crr : varchar
cda : char
uc : int
cty : char
Sql2:
------
ccb : numeric
cact : char
cldate : datetime
cl : cahr
cde : int
cty : char
cen : numeric
I have also given the field type for the above code in SQL.
Regards
|
|
|
|
|
vb_buddy wrote: What is the difference between insert through string concatenation and parameterized queries.
Parameterized queries, using SqlParameter objects, automatically escape certain characters for you. These characters, like the ', can completely change the meaning of an SQL statement.
vb_buddy wrote: Can you please focus me that where am i going wrong.
I already did. You're using string contantenation to build SQL statements.
BTW: Your SQL column names are utter junk. What column holds what data?? You've thrown away the entire meaning of "self documenting code".
|
|
|
|
|
To further what Christian said, execute the statements in a SQL Query Analyzer session to ensure that the update is in fact working against a field that exists. The statements listed show an insert into table1, but an update against table2.
Tim
|
|
|
|
|
When you update, you compare the colbl field with the value in col1 as a numeric value, but then you set the field with col1 as a string value. What are the types of the col1 variable, and the colbl field, really?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hello,
I'd like to know what is the best way to store product information, and where I can find a good tutorial about it. My idea was to use a Microsoft Acces database, looked best to me. Any suggestions are welcome! 
--Zaegra--
|
|
|
|
|
Access is unsuitable for all but the most trivial applications. It is only useful in single user, small data size applications.
|
|
|
|
|
What would you recommend?
|
|
|
|
|
SQL Server Express Edition is free, and works the same as the bigger versions, so you can learn without paying.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'll second Christians recommendation. SQL Server Express will give you a dramatically better platform to begin developing and you will get exposure in SQL Server which is a clear upgrade path and a valid learning curve. Access is a dead end as a learning point.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Like Christian said, SQL Server Express.
|
|
|
|
|
And now for a tutorial?
I would like to know too!
|
|
|
|
|
I'd like to be able to let my clients write code through code provider, such as
Dim Diff = Close - Open
...where Diff, Close, open are actuallyi double Arrays()
I see I can do it by overloading the - operator, but only if either Close or Open are new types. But I don't want to have to create a new type -- I just want to use plain old Close()as double and Open() as double in the syntax.
Is there anyway around this? Why does the operator overloading require a new type?
Thanks!
|
|
|
|
|
cstrader232 wrote: Is there anyway around this?
No.
cstrader232 wrote: Why does the operator overloading require a new type?
Because you can't modify the behavior of the System.Array class. You can only modify the behavior of a class you create FROM the Array class, which, won't be usable in the manner you want because that will ALWAYS use the System.Array class.
You simply cannot do what you want without requiring the user to use your custom type.
|
|
|
|
|
OK, fair enough... just wanted to be sure. Thanks and Happy weekend!
|
|
|
|
|
Dave Kreskowiak wrote: Because you can't modify the behavior of the System.Array class. You can only modify the behavior of a class you create FROM the Array class,
Can't you add code to existing classes in 3.5 now ? Or am I thinking of Objective C ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Can't you add code to existing classes in 3.5 now ? Or am I thinking of Objective C ?
Not that I know of, or heard of anyway. Maybe in C# it's possible? 
|
|
|
|
|
I guess the most likely thing is that I'm thinking of something I read in an OC book....
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
If it was C#, you could make a wrapper type for an array, and implement an implicit conversion from you type to an array, to let the clients assign your type to an array variable and get the array instead.
Sadly, VB.NET doesn't support implicit conversions.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi all.
I have created a website that will be used internally. I want to create a web form in vb so scroll bars and menu's are gone and the site will load in a clean window.
I have created this form and when i load it up and click on a button (a JAVASCRIPT button) it comes up with the following error
'A runtime error has occured, do you wish to debug?
Line:35
Error: parent.frames.2 is null or not an object.
I have added the site to a server using IIS and it works throught internet explorer but i cannot get it to work with the vb form. I am pretty sure it's something to do with the buttons in my script as the message comes up whenever you click on one.
Any help would be appreciated.
David
|
|
|
|
|
Wat do you mean by VB form, you have a browser control in a VB program ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
I wanna to get hard disk serial number i m using this code it work well in my pc but in client pc it doesn't give hdd serial no i don't know that
given number belogs to which physical media?
<br />
Dim mgmtobj As New ManagementObject<br />
Dim searcher As ManagementObjectSearcher<br />
<br />
searcher = New ManagementObjectSearcher("SELECT * FROM Win32_PhysicalMedia")<br />
<br />
For Each mgmtobj In searcher.Get<br />
If mgmtobj("SerialNumber") = Nothing Then<br />
serial = ""<br />
Else<br />
serial = mgmtobj("SerialNumber").ToString.Trim<br />
End If<br />
Next<br />
Really its very urgent for me now
Thanks
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
|
|
|
|
|
Please read the forum guidelines. Using 'urgent' in your message (or title) is frowned upon and my get you ignored completely.
|
|
|
|
|
I have this code in my library for getting the HDD serial number.
I know its not the best code - I cant remember where I got it from, but it does seem to work on the few machines I have tested it with:
Dim mobjSearcher As New ManagementObjectSearcher("SELECT * FROM Win32_LogicalDisk WHERE Name = 'C:'")
For Each obj As ManagementObject In mobjSearcher.Get
Return obj("VolumeSerialNumber").ToString
Next
Return "00000000000000"
Maybe it will work for you?
|
|
|
|
|
But - the obvious mistake you have made is...
If you find more than one drive in your search, and the SECOND drive doesnt have a serial number (for whatever reason), you are clearing the serial number...
Oops?
Thats the problems with for...next loops setting variables.
|
|
|
|
|
First of all thanks to all for reply
I know its not good to say "Urgent" but its really very very urgent for me so i had to wrote
Thanks Jasey9 for your code but....
<br />
Return obj("VolumeSerialNumber").ToString<br />
I have already tried it but it will return the volume number of a particular Drive like C: but after format the Pc it will change
so i need only the serial number of hard disk
Is there any way to varify that the number returned by searcher = New ManagementObjectSearcher("SELECT * FROM Win32_PhysicalMedia")
is hard disk serial number,I need your guidance...
Thanks
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
