|
I think I got it now. I think all you have to do is scan the column headers (For I = 0 to MaxColumns) for the name you're looking for, then just save the index of that column for use in your Cells reference.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Thanks a lot man. Will try to code it =D
|
|
|
|
|
I have a DVR Card. And i want show video from CCTV camera by DVR Card in form vb.net.
|
|
|
|
|
There is no standard .NET classes that will do this for you. You have to see if your DVR card manufacturer supplies and SDK (Software Development Kit) you can use, or if there is any documentation on what you should be using.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
The SelectCommand property has not been initialized before calling 'Fill'.
shs
|
|
|
|
|
It appears you have not set the sql query or stored procedure in your command before you called your dataadapter.fill method. Do you have another question?
Ben
|
|
|
|
|
You're trying to execute a command without telling your OleDbCommand, or SqlCommand, or AdoDbCommand, object what command to execute. You have to give it the Sql command you want it to execute so it knows what to return to fill your dataset.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Environment: Op Sys 2003 server; Sql Server 2005 with update; Visual Studio; Multiple VB functions and subroutines as stored procedures.This subroutine needs to use a connection string to enable MARS. It does not have the SQL Attributes. They seem to prohibit byref class instantiations being returned.
Dim connectionString As String = _
"server=(local);" & _
"Trusted_Connection=yes;" & _
"database=Frontier_equipment;" & _
"MultipleActiveResultSets=true;"
RecordTypeConnection = New SqlConnection()
RecordTypeConnection.ConnectionString = connectionString
RecordTypeConnection.Open()
Error Numr 5
Error Desc An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
rkj
|
|
|
|
|
Are you sure your sql server name is correct? Are you sure the sql server allows trusted connection. Can you ping the sql server name from where you are trying to run this app? Is there an instance of a sql server you are trying to connect to? You have to put that into your server name. Sometimes you have to set a port number for sql server instances. Anyway, a few thoughts, I hope that helps.
Ben
|
|
|
|
|
I had read that Stored procedures running within the SQL Server could use the local option for server name. Placing the combined servername\sqlservername as the servername worked.!! Thank you.
rkj
|
|
|
|
|
Along with what kubben said, your connection string says that it expects the database server to be on the same machine as the one where your code is running. I hope this is true, otherwise you'll have to change your connection string.
Does your SQL Server instance have Named Pipes enabled?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
The stored procedures are on the same machine as the server. Replacing server(local) with
servername\server made the whole thing work.
rkj
|
|
|
|
|
If it's a stored procedure, you can try "context connection = true" for the connection string to use the connection that the SP is executing under. But, as you can read here[^], this is not always the best idea.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
I was using that but I needed the MARS capability.
rkj
|
|
|
|
|
Hi All
I want to import excel data into SQL Server2000 through VB6.0, but it gave error. Plz Help.
Regards
smk
|
|
|
|
|
suveenmohan wrote: but it gave error.
And that error would be??
suveenmohan wrote: Plz Help.
Not without knowing what the error message was and what the code looks like that generated it.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
i have a window application in which i am using datagridview. i want to use datagridview as dataentry.
Is there any sample i can use
|
|
|
|
|
Thats pretty much what the DataGridView was designed for. Just about every one of the thousands of DataGridView examples out on the web does this very thing. The examples pretty much show you how to do all kinds of customizations so you can tailor the DGV to do data entry.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
somebody helps me.
can vb.net read a html?how?
|
|
|
|
|
|
HTML is nothing but a text file. Where are you trying to read this HTML from? What are you trying to do with it?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
actually i want to categorize documents.i have html documents. first, i must convert them to doc type. from a html document i just need words in tittle tag and body tag..
|
|
|
|
|
OK. This still doesn't clarify the question at all. Converting them to doc types?? What does that mean? Are you trying to convert an HTML file to a Word document?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
i just want to get the text in tittle and body, and remove other tags. and then save it as word document. just text, without table, without image.
|
|
|
|
|
I have developed a project which should be implemented in multiple palces.
If it is in VB, we will have an option called PAckage and Deployment which inturn creates all the OCX and DLL files which are required to run the project succesfully.
But in VB.Net, I cannot get the Correct steps to be followed to set the PAckage and Deployment Wizard.
Please Can anyone guide me throught the steps that can create a Package to Ditribute the Code.
Thank you in ADVANCE
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
