|
skippydog wrote: CommandText = "SELECT MATTER_UNO FROM(HBM_MATTER)WHERE (CLNT_MATT_CODE = '" + TextBox1.Text + "')"
You had the right idea starting with the previous line by adding parameters, but you seem to have decided to inject the value from the text box into the SQL directly. You should really read up on some SQL Security, unless you want your server to be 0wn3d: SQL Injection Attacks and tips on how to prevent them.[^]
Now, to your question: What was the error produces. I can see nothing much wrong with the code (apart from the security hole I indicated above)
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
finaly solved it by putting a return parameter into the parameter collection and executescalar() as all I wanted was one field from one row. for the textbox I can write a validation routine that will check the format of the string to be passed but only when the app gets anywhere near to being tested by someone.
thanks for the input
|
|
|
|
|
skippydog wrote: but only when the app gets anywhere near to being tested by someone.
Surely you are someone and you are testing the application all the time. Security is not something to be tagged on at the end. It is something that should be in up front at the start or development and stays all the way through to the end.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
I use DirectX.AudioVideoPlayback to play video, which require any control to be an "owner" in which it plays video. Now I selected to play video in Panel control & wanted to save snapshot/picture of any paused frame. Thats taking picture from movie.
Tell me how can I do this (please include coding if possible)
|
|
|
|
|
AudioVideoPlayback is no longer supported, and won't come out in future versions for .NET 2.0 at least. However, you should be able to render to a texture, which you can then save.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
"However, you should be able to render to a texture, which you can then save."
Please tell me how can I do this in VB.NET with .NET Framework v1.1.
Also whats new in .NET Framework v2.0 about saving pictures from movies.
|
|
|
|
|
Iftikhar Ali wrote: Please tell me how can I do this in VB.NET with .NET Framework v1.1.
I've never done it, I've just read the docs
Iftikhar Ali wrote: Also whats new in .NET Framework v2.0 about saving pictures from movies.
The AudioVideoPlayback namespace is gone. There's nothing new that's good that I know of.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote: I've just read the docs
Please tell me the source of docs.
Christian Graus wrote: The AudioVideoPlayback namespace is gone. There's nothing new that's good that I know of.
Thats really bad, but I think some other namespace will replace it but it cannot be completely removed.
|
|
|
|
|
Iftikhar Ali wrote: Please tell me the source of docs.
They are in the SDK, but I also bought a book.
Iftikhar Ali wrote: Thats really bad, but I think some other namespace will replace it but it cannot be completely removed.
My fear is the new SDK will be WPF, which only runs on XP and higher.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Ok I'll search in the SDK, Please confirm me, you are talking about DirectX SDK?
Christian Graus wrote: My fear is the new SDK will be WPF, which only runs on XP and higher
Thats Microsoft policy to eliminate usage of old versions of Windows.
Tell me what WPF stands for?
|
|
|
|
|
Iftikhar Ali wrote: you are talking about DirectX SDK?
Yes
Iftikhar Ali wrote: Tell me what WPF stands for?
Windows Presentation Foundatin AKA Avalon
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanx
I know WPF as Avalon.
If possible tell me the link from which I can get my answer to this question.
|
|
|
|
|
Private Sub txt_ord_qty_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txt_ord_qty.KeyPress
If IsNumeric((e.KeyChar)) = False Then
MsgBox("ENTER ONLY NUMERIC VALUE")
End If
End Sub
I M USING THIS CODE BUT AFTER MESSAGE IT INSERT VALUE IN TEXTBOX
HOW CAN I PREVENT STRING VALUE IN TEXTBOX
PLEASE HELP ME
asdf
|
|
|
|
|
Have you check if there's a cancel property available under e?
Otherwise strip last char in the text property.
|
|
|
|
|
|
did u tried
return
after the msgbox in the if condition
abhinav
|
|
|
|
|
hi vivek
the code that i m giving u will definately help u
in the key press event of the textbox write the following code
if char.isNumber(e.keyChar) = false then
e.handled=true
end if
karan jain(Vinit Jain)
|
|
|
|
|
System.Data.OleDb.OleDbException: The statement has been terminated. Cannot insert the value NULL into column 'bcId', table 'ForumVB.dbo.forumTopics'; column does not allow nulls. INSERT fails. at System.Data.OleDb.OleDbDataReader.NextResults(IMultipleResults imultipleResults, OleDbConnection connection, OleDbCommand command) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at dotForumTopicAdd.addTopic.submitter_update(Object sender, CommandEventArgs e)
|
|
|
|
|
It seems that the message tells the story.
Or you set a non null value for bcId or you make it nullable in the DB.
|
|
|
|
|
yup, i set non null value for bcId, but i forget 2 set it automatic generate number because i use bcId is primary key and is not get the value from user keyin.... So after i set bcId to auto generate number in database then my erorr was solve already
anyway thanks for reply n all d best 2 u
-- modified at 6:06 Tuesday 17th January, 2006
|
|
|
|
|
Hi. I think that I saw on a site that I can display Master and Details in the same grid with "+" on the left of each Master's row. and if I click on the "+" so it open the details rows in the same grid with few left margin increment.
can anybody help me please... I forgot where I can find this article
OmarMallat
|
|
|
|
|
I have a picturebox for view some jpg file.
However, the jpg is always larger than the picture box view.
By default,
<br />
pictureBox.SizeMode = PictureBoxSizeMode.StretchImage<br />
after a button is clicked, it change to
<br />
pictureBox.SizeMode = PictureBoxSizeMode.Normal<br />
How can I view the whole 1:1 picture by the control of verticle and horizontal scrolling bar?
Any example/article for this?
Thank you!
|
|
|
|
|
|
Wow, You are so great!
Thank You
|
|
|
|
|
Hi,
I am new to VB .Net so was going thru this e-book. I came across an error which I was unabe to understand. Even writing to their customer support didn't help and they referred me to the author who hasn't replied back for past 2 months. here is the description of the problem
e-Book : Mastering VB .Net
Author : Evangelos Petroutsos
Page Number : 112
Lines In Concern : 15 to 21
Specific Line : 20
Structure Person - Line 15
Dim First As String - Line 16
Dim Last As String - Line 17
Dim Address As String - Line 18
Dim Phone As String - Line 19
Dim EMail(10) As String - Line 20
End Structure - Line 21
My Operating System : Microsoft Windows 2000 5.00.2195
Service Pack 4
IDE : Microsoft Visual Studio .NET 2003
Error Text : "Arrays Declared as structure members cannot be
declared with an intial size"
Problem Description : The code was copied 'AS IT IS' From the book and
The declaration given in the 20th line on the
112th page, where an Array of index 10 is declared
inside the structure, generated the above quoted
error. Please explain the reason for the
occurance of the error.
|
|
|
|