|
Hi man
Thanks for the Reply, i got the Solution Check the above post.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi guys, need ur help i have a circuit(ADC to BINARY) which i wish to communicate via USB port to a VB
program to read data from( Example like a USB mouse which gives input and the cursor moves)
I did some research and found out about virtual com ports which fools the program into thinking that
the usb port is a com port but i'm not sure how to create one, do i need to do it this way or is there
another way in which i could directly send data(binary) to the VB program 
|
|
|
|
|
Hi all,
Could anyone help me?
I'm trying to get file from the web (initialy local webserver) and save it to the database after reading. If the files are small sized (up to 2Mb) - everything works fine - files can be uploaded and then opened from a database (I use another class to display the content of MSSQL image field and it's not a matter of this thread). BUT if the filesize is greater - documents can not be opened, though if I save them the size is equal to the original.
Here is the code I'm using for downloading file from the webserver and post it to the database:
Private SqlConnection1 As New System.Data.SqlClient.SqlConnection
Private addfile As New System.Data.SqlClient.SqlCommand
Private strURL As String = "http://datcserver:1234/K2Workflows2/file5M.doc"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sServer As String
sServer = "MYSERVER"
Dim sUID As String
sUID = "myuser"
Dim sPWD As String
sPWD = ""
Dim sConStr As String
sConStr = "Server=" & sServer + ";"
sConStr &= "UID=" & sUID + ";"
sConStr &= "PWD=" & sPWD + ";"
sConStr &= "DataBase=DBNAME;"
Try
SqlConnection1.ConnectionString = sConStr
addfile.Connection = SqlConnection1
addfile.CommandType = System.Data.CommandType.Text
addfile.CommandText = "Insert into FILES (proc_id,file_body,title,description,type,version,createdby,modifiedby,createddate,modifieddate) Values (@procid,@filebody,@title,@description,@type,@version,@createdby,@modifiedby,@createddate,@modifieddate)"
Dim DocName As String
DocName = strURL.Substring(strURL.LastIndexOf("/") + 1, strURL.Length - strURL.LastIndexOf("/") - 1)
Dim oRequest As System.Net.HttpWebRequest = CType(System.Net.WebRequest.Create(strURL), System.Net.HttpWebRequest)
oRequest.Credentials = System.Net.CredentialCache.DefaultCredentials
oRequest.AllowWriteStreamBuffering = False
Dim oResponse As System.Net.HttpWebResponse = CType(oRequest.GetResponse, System.Net.HttpWebResponse)
Dim br As System.IO.BinaryReader = New System.IO.BinaryReader(oResponse.GetResponseStream)
Dim FileLen As Integer = oResponse.ContentLength
Dim Input(FileLen) As Byte
br.Read(Input, 0, FileLen)
addfile.Parameters.Add("@filebody", System.Data.SqlDbType.Image).Value = Input
addfile.Parameters.Add("@procid", System.Data.SqlDbType.Int).Value = 777
addfile.Parameters.Add("@title", System.Data.SqlDbType.NVarChar, 255).Value = DocName
addfile.Parameters.Add("@description", System.Data.SqlDbType.NVarChar, 255).Value = "Master version of original document - created automatically when the workflow started."
addfile.Parameters.Add("@type", System.Data.SqlDbType.NVarChar, 1).Value = "M"
addfile.Parameters.Add("@version", System.Data.SqlDbType.Int).Value = 1
addfile.Parameters.Add("@createdby", System.Data.SqlDbType.NVarChar, 255).Value = "Me"
addfile.Parameters.Add("@modifiedby", System.Data.SqlDbType.NVarChar, 255).Value = "Me"
addfile.Parameters.Add("@createddate", System.Data.SqlDbType.DateTime, 8).Value = DateTime.Now
addfile.Parameters.Add("@modifieddate", System.Data.SqlDbType.DateTime, 8).Value = DateTime.Now
SqlConnection1.Open()
addfile.ExecuteNonQuery()
br.Close()
oResponse.Close()
Catch ex As System.Exception
Throw New System.Exception(ex.Message)
End Try
SqlConnection1.Close()
End Sub
What is wrong here?
Thanks for any assistance!
|
|
|
|
|
hi to all
in a form i have 3 text boxes
one should accept numbers only
2nd should accepts only characters
3rd should accepts numbers+char+ spl chars,,
for the 1st text box i wrote
Private Sub TextBox1_Leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.Leave
If Not IsNumeric(TextBox1.Text) Then
TextBox1.Text = ""
MessageBox.Show("you should enter only numbers")
TextBox1.Focus()
End If
End Sub
and this working
for remaining two (2nd and 3rd)
could you please help me
self confidence+hard work=SUCCESS
|
|
|
|
|
Check out the MaskedTextBox, this might meet your requirements.
Google has a million examples on it's usage.
www.wickedorange.com
www.andrewvos.com
|
|
|
|
|
Hi Everyone,
Is it possible to detect the expiry of password in oracle without being an DBA?. Can anyone help me in this regard.
Regards,
Manowj
|
|
|
|
|
Try using the SQL forum, not the VB forum
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
|
how to create a combo box coding link with the sql database?
|
|
|
|
|
Hi
Is it means? do you want to write combo box binding with database?
thanks
|
|
|
|
|
try this
reader = "SELECT Column FROM Table"
'send the reader as query and get the result in the same
combobox.Items.Clear()
While (reader.Read())
combobox.Items.Add(reader("column").ToString)
End While
If (combobox.Items.Count <> 0) Then
combobox.SelectedIndex = 0
End If
self confidence+hard work=SUCCESS
|
|
|
|
|
I have used the Microsoft.Practices.Enterpriselibrary. I also use the connection string. I want to ecrypt the userid and password. If anyone has idea , show me method how to do.
flowerppk
|
|
|
|
|
First, show us that you have attempted to do this yourself.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
Hi every one..
I have a problem to export my SQL data to excel format directly by VB.net program (on VS2008). I already try with any script but it didn't work. Anybody can help me to solved this problem ?. Thanks so much...
|
|
|
|
|
|
Hi everyone,
I am looking for a way to generate a graph in VB based on data coming from an Access database.
Can anyone guide me into the right direction? I could not find anything posted here to show me how to do it and the books I have does not mention a thing about Graphs.
Any help will be much appreciated,
Maria
|
|
|
|
|
Have you solved this?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
It looks like the only way I can generate a chart in VB2005 is to use Drawing2D which is a pain. Because I don't want to use any third party packages I will have to learn ho to do this. Any suggestions will be much appreciated.
Thank you,
Maria
|
|
|
|
|
Hello i'm sorry to ask
Maybe the title of the Question is not clear. But i don't know where i should begin
I should do an application that give a messge box when i open a sepecific folder and add anything on it or delete from it
The message box should tell the name of the folder or whatever i add or delete and the opeation done
Thanks in advance
Assaf
|
|
|
|
|
Hi,
FileSystemWatcher Class is what you need. I suggest you read MSDN and/or some
CodeProject articles about it.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
I am using visual studio 2005 express and I am having a couple of errors that I just cannot figure out.
The first error is with the master page. When I go into a .aspx page it shows the following error: template.master cannot be processed because the code directory has not been built. I do have the template.master file in the root directory.
The second error is with a skinID. When I go into a .aspx page I get the following error: A skinID has been specified but the page is not configured to use a page theme or style sheet theme. Inside an app_theme folder I have 2 files- basic.skin(skinID) and default.css(a stylesheet)
|
|
|
|
|
Sounds like you wanted the ASP.NET forum.
Christian Graus - Microsoft MVP - C++
"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 have several list box controls in an application. Some I just add the items through a loop and the others I actually bind a datasource to. I am experiencing some strange behavior from the databound controls. If I click or scroll through the list the selected item will jump around so for example...
The items are...
First Item
Second Item
Third Item
I select Second Item no problem. I select the Third Item and the selected item will switch to the First Item. I try to select the Second Item again and it bounces back to the First Item then I select the Third Item no problem.
That can happen in any order so pay no attention to First, Second, Third, First or any pattern like that. Also this will occur with a click or a key press. I break pointed at the selected index changed event and if I were to select the Third item and the First Item catches the selection then that is the value that comes across at the selected index changed event.
Is this an issue with the databound control or is there some concept I am missing here?
CleaKO
"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)
|
|
|
|
|
Yes, if you databind to your control, the selection is lost. I suspect you are databinding again when the selectio nchanges.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
