Error reading large file from the webserver using HttpWebRequest - Visual Basic Discussion Boards

It should go! Did you change any property of that textbox?

"Legacy code" often differs from its suggested alternative by actually working and scaling.

—Bjarne Stroustrup

NO i did not Change any Property except "Multiline" and set it to true.

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 Man

Thanks for your Reply, i got the Problem

The Property "AcceptsReturn", by default is False, to use Enter key in a Multiline textbox, you have to set it to "true"

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

Great....

"Legacy code" often differs from its suggested alternative by actually working and scaling.

—Bjarne Stroustrup

How will the information be input. Will you be manipulating it as one large string or are you storing it as one large string.

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 Wink | ;)

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)

Thanks.

Regards,
Manowj

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? Confused | :confused:

thanks

Cheers,Earn and Enjoy
RRave
MCTS,MCPD
http://ravesoft.blogspot.com

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 herag

I had seen in the last night very very good very for export /import data from sql database to excel sheet/txt/csv/etc..

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/[^]

write this function within in the stored proc,after call in vb.net code.

i think this very very good very for those type of work.

thanks

Cheers,Earn and Enjoy
RRave
MCTS,MCPD
http://ravesoft.blogspot.com

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.

Smile | :)

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.