|
Ohhh you need to customize the control to have two columns , there are a lots of custom controls on this site you have to search for it
|
|
|
|
|
i am in need of a Remote database connection coding in vb.net 2003. Can Anybody help.When i tried the given coding i got error.
"Provider=sqloledb; Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs; User ID=sa; Password=asdasd;"
Error.
 (An unhandled exception of type "System.Data.Odbc.OdbcException" Occured in System.Data.dll
I tried with spaces removed in between(Like "UserID=sa;").But code gave the same error. So that doesnt effect much.
Please try to tell me how to connect to a remote database.
|
|
|
|
|
I am guessing 190.190.200.100 is the ip address and 1433 this is the port number the format should be 190.190.200.100:433
|
|
|
|
|
But the server address or ip is just as i gave.
|
|
|
|
|
Can you post the code you are using please?
|
|
|
|
|
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
Private Sub btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn1.Click
Dim conn As New Odbc.OdbcConnection("Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Extended Properties=DSN=11045-flo1;UID=sa;DATABASE=callcenter11;Network Library=dbmssocn;Initial Catalog=callcenter11")
Dim datacmd As New Odbc.OdbcCommand("select fname,lname,phone from customertracking", conn)
conn.Open()
datacmd.ExecuteNonQuery()
Dim dr As Odbc.OdbcDataReader
txt1.Text = dr.Item("fname")
txt2.Text = dr.Item("lname")
txt3.Text = dr.Item("phone")
dr.Close()
End Sub
End Class
This is my complete coding in vb.net 2003.
|
|
|
|
|
Is there any particular reason you are using an OdbcConnection to connect to a SQL Server? Why not use the more specific SqlConnection?
|
|
|
|
|
Can you modify my code to use with sqlconnections
|
|
|
|
|
I have been trying to download attached soap binary file ( a pdf file ) but I am unsuccessful can any one help me please (
http://ops.espacenet.com/[^]
x = New oPDF.OpenPatentServicesService
Dim ox As New WebServicesExtension
Try
strRequest = " <openpatentservices action="DocumentRetrieval"><worldpatentdata><document id="EP 1134564A2 I " system="BNS" format="SINGLE_PAGE_PDF" page_number="2">"
x.getDocumentData(strRequest)
Catch ex As XmlException
Dim msg As String = ex.Message
Debug.Write(msg)
Catch ex As Exception
Dim msg As String = ex.Message
Debug.Write(msg)
End Try
The system gives me the following error:
Client found response content type of 'multipart/related; type="text/xml"; start="<04DE650D2C8808D1D0324462AFE2C1D7>"; boundary="----=_Part_792851_1622390197.1158570667578"', but expected 'text/xml'.
The request failed with the error message:
--
------=_Part_792851_1622390197.1158570667578
Content-Type: text/xml; charset=UTF-8
Content-Transfer-Encoding: binary
Content-Id: <04DE650D2C8808D1D0324462AFE2C1D7>
<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:body><ns1:getdocumentdataresponse soapenv:encodingstyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:EPO-OpenPatentServices-documentData"><return xsi:type="xsd:string"><WORLDPATENTDATA><DOCUMENT ID="EP 1134564A2 I " PAGE_NUMBER="2" FORMAT="SINGLE_PAGE_PDF" SYSTEM="BNS">
<DESC>FullDocument</DESC>
<CONTENT_REF>EP 1134564A2 I .pdf</CONTENT_REF>
</DOCUMENT></WORLDPATENTDATA>
------=_Part_792851_1622390197.1158570667578
Content-Type: application/octet-stream
Content-Transfer-Encoding: binary
Content-Id: <ep 1134564a2="" i="" .pdf="">
Content-Location: EP 1134564A2 I .pdf
%PDF-1.3
%????
3 0 obj
<<
/Linearized 1
/O 5
/H [ 526 186 ]
/L 97469
/E 97146
/N 1
/T 97359
>>
endobj
xref
3 11
0000000016 00000 n
0000000436 00000 n
0000000712 00000 n
0000000957 00000 n
0000001056 00000 n
0000001078 00000 n
0000096781 00000 n
0000096808 00000 n
0000096917 00000 n
0000097031 00000 n
0000000526 00000 n
trailer
<<
/Size 14
/Info 1 0 R
/Root 4 0 R
/Prev 97350
>>
startxref
0
%%EOF
4 0 obj
<<
/Type /Catalog
/Pages 2 0 R
>>
endobj
13 0 obj
<<
/Length 104
/P 0
/S 46
>>
stream
|
|
|
|
|
how can i put a progress bar to know progress of database update process
|
|
|
|
|
You may be able to with SQL Server 2005, which allows .NET code in stored procs, for example, but if you're doing a single SQL call, I doubt it's possible, you're just not going to get any sort of callback. And if you have a command that does a large update, and you can break it up into little statements, doing so will greatly slow down the process.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks
i'm using Informix
da.update(dataset,"tablename")
this is the update command
|
|
|
|
|
OK, you're not bothing with a proper data layer then ? Certainly, this is an atomic action, there's no room for a progress bar here.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi,
I'm trying to connect my VB.net program to scanner. Here i'm using Twain specification to achieve this.
I need to include a file "Twain.h" in my vb.net program.
What is the procedure to do this?
As i'm totally a biginner in .net, elaborated explanation will help me a lot.
Regards,
Member.
|
|
|
|
|
You can't. Twain.h is a C++ header file, you can't use it in VB.NET. You'll need to find a .NET TWAIN driver, or write a MC++ wrapper for the one you have.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
heelo
can someone help me with the creation of a update sp for a table adapter?
|
|
|
|
|
Probably, if you provided some useful info.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
in a dataset i have a table adapter for the table "orders"(with 2 fields:ORDERID AND CUSTOMERID) and i whant to make the update and delete stored procedures for it..
|
|
|
|
|
OK - so this is a lookup table ? I'm guessing it's a one to many lookup table, the orderID is unique ?
Do you know any SQL at all ? Or are you working on someone elses database ? To create a stored proc, you want to run the SQL Server client tools, which will also give you access to the books online, which would cover these sort of basic queries for you. However, if you're not comfortable with what you're doing, and you're part of a team, you need to be talking to your manager, so he knows where you're at with SQL and so you don't do any damage to the database.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i want to cancel the function to unload or exit the form when user click on the X button at the form. how can i did that?
I have set the msgbox to prompt user but wat ever anwser i give the form will just close down... y??
****here is the code:
Private Sub Form_Unload(Cancel As Integer)
Dim message, dialog, title, answer
message = "Do you want to Exit?"
dialogtype = vbYesNo + vbQuestion
title = "DELIVERY ORDER"
answer = MsgBox(message, dialogtype, title)
If answer = vbYes Then
savedo
else: exit sub
End If
End Sub
|
|
|
|
|
Is this VB.NET ? I don't think so, but if it is, the closing event gets passed a Handled property in the event arg, you can set that to true to stop closing.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i using vb6.
where to set =true??
form_unload=true???
|
|
|
|
|
I thought it may be VB6. None of my advice applies, and I've never used VB6. As VB6 is officially obsolete, you should specify that's what you're using, people are bound to assume .NET otherwise.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
so do u know how to set the value in vb.net?
wat command to use to cancel the closing of the form?
|
|
|
|
|
Yes, you do what I said. But, that is irrelevant, it's not going to help you in VB6, obviously.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
