I am using oracle and trying to create a datagridview but when i try to create the dataset i get the error "could not retrieve schema information for table or view" stating my database and table name. I am using the Oracle client not the OLEDB as i have always used that and had no problems. I am using Oracle 11g.
View 6 RepliesI am trying to retrieve the data from MS Access Table to LIST-VIEW, its difficult for me to write the code
View 4 RepliesI am using microsoft access 2003 and visualbasic.net. I am trying desperately to add a database using the wizard, and it lets me go through with it, testing the connection is good, but when I try to finish it gives me an error: "<customers>Could not retrieve schema information for table or view customers." What am I doing wrong? I've added databases in the past without this problem using the same Access.
View 12 RepliesMy problem is I want to be able to read through this xml document and populate a winform before validating it and then storing it into a table.[code]...
View 2 RepliesI have an access database with 5 tables.I want to fill a dataset with the entire contents of the database.Why can't it roughly look like this?[code]Instead I'm having to create an adapter for EVERY table, tab the table name (why?), fill the schema, and then fill the table.
View 1 RepliesI want to move a table schema from one database to another using vb.net or c#. How can I do that?
View 1 RepliesI wrote an import procedure that extracts certain row data from Excel files. Currently, I manually create a DataTable in VB.NET, add columns and their datatypes. don't add anyconstraintsto the table, but the SQL database table where this data is going to does haveonstraintssuch as a column can't be null, check constraintsor unique constraints.Here is a simple example of my code.
Dim dt As New DataTable
With dt
.Add("Column1", Type.GetType("System.String"))
[code].....
I am selecting two table schema in a single adapter.
da=new sqldataadapter("select * from emp;select * from emp1",con);
da.fillschema(ds,Schematype.mapped);
then i am inserting some rows manually on both tables.i want to update the dataset. so that each data table in the datast will be updated in database.how to do this? since i am facing problem that it is updating all the rows in single table.
I am using VB2005 and trying to put an application together.What it needs to do is retrieve information from a binary file, possibly alter that information, and put it back into a new file.The file is a .wav file with data appened to the end. There is an additional section at the end of the .wav file which stores xml data.I have found that if I open this in a hex editor and make a 1:1 swap on any of the bytes that the application that the file is for can still read the XML.If I tried to add or remove characters from the XML then it would not read. I located a header byte and incremented it to resolve this.
This worked as an excellent bandage to do conversions where the data always needed to be changed to the same thing.What I have been asked to do is build logic that allows for different things to happen depending upon what data is contained within the file.The method that I am currently trying to impliment is:
Read through the file with a system.io.binaryreader
Searche for a bytestream that will signal data is coming
For example:
If System.IO.File.Exists("C: est estread.wav") Then
Dim findit() As Integer = New Integer() {&H3C, &H55, &H73, &H72, &H44, &H65, &H66, &H30, &H31, &H30}
Dim i As Integer[code].....
And then extract all the data till the end of element marker "<" It seemed like there should be a better way and I was looking for some insight. If I proceed with this method, I will have to read the file one time to gather the information and then a second time to write it all out with the header modified for length.This is my first experiene with working with binary files in this way.Also,I've been experiementing with building a string and slapping it back in at the end using the binarywriter.write(string) method.I noticed that it was putting in header characters before the string.These seem to change if I change the length of the string.At one point it was d0 07. Later it became e7 07. Does anyone know of a way to prevent this header from being inserted?
I tried a for each loop to grab all of the characters from the string, convert them to a byte array and deposit the byte array into the file, but the header remained the same. When I write the byte array generated from a system.io.binaryreader I do not get this header.
I have a php web service that I can call from a php client. I need to call this web service from a vb.net application. When I try to add a reference to this web service I get this error:The root element of a W3C XML Schema should be <schema>here is the top of my wsdl file:
<?xml version="1.0"?>
<!-- partie 1 : Definitions -->
<definitions name="raidService"
[code].....
I have a some information on a textfile. I want to input the customers ID number in a textbox or inputbox and get all the customers information like name, address, Date of Birth, age, etc. I know how to retrieve information from a textfile by typing the name of the textfile a getting all the information in the textfile. How to do is to retrieve certain information from a textfile. How can I type in the customers ID and pull up all the customers information and then store it in an array.
View 3 RepliesI wanted to make a program where it will retrieve data from websites I use regularly and display important parts to me such as my horoscope, friends online, new emails etc. I'm just having a problem figuring out how to get visual basic to display the website information.
View 4 RepliesI am having a bit of trouble figuring out how to collect a piece of information from a web page. Here is the web page I want to retrieve the information from:
RuneScape - The Number 1 Free Multiplayer Game
I would like to retrieve the first "Price" of the item and collect the price every time I execute the code. I understand how to retrieve the source code of the webpage and split strings but how would I retrieve that price?
How do I retrieve information from the internet such as the weather?? Are there any tutorials on for complete beginners??
View 6 RepliesHow do I retrieve the computer model information?For example, I have a dell inspiron 1545. How do I retrieve that information in a label? I search a lot of WMI information but can't seem to find it. It SAYS 1545 on my system properties
View 5 RepliesCreated an XSD file that represents my table structure from my database. Created a class file to hold my functions such as the one below.
Code sample:
Public Function GetUser(ByVal UserID As String) As xsdUser.UserDataTable
Dim SqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDatabase").ConnectionString)
[Code]....
Now it seems odd to me to have two files doing what should be contained within just one file. I feel like I should have one class file called "User" and have member variables in there along with the class functions like the one above. But all the tutorials I see are using these data tables. On top of that I'm not sure how to handle the if statement at the end of the function. I don't think I would want to return a whole DataTable since I should only have one row, and I also don't know how I would handle an error if my function is supposed to return a data table. I suppose I could return an empty one and then if the table is empty in my code then I would handle it there, but this also seems messy.
Is this the common way of retrieving information from a stored procedure? Or is there a more up-to-date method that I'm not seeing in my search results?
I am real new in vb. I need to connect to ms server and retrieve information for database. Just simple ''select * from update, delete and so on.If I add new data source using data source configuration wizard - everything is fine, but I want to use just simple selects.I use
Dim connectionString As String = _
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BBD-2;Initial Catalog=wilopumpen1;Persist Security Info=True;User ID=*****;Password=****;"
Dim queryString As String = _
"SELECT * from dbo.tableName "
[Code]...
How do I retrieve hardware device information on a machine via WMI?
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
I have the following code:
Dim searcher As New ManagementObjectSearcher("SELECT * FROM Win32_LogicalDisk WHERE DriveType = '3'
I have the FormLogin, which have the code:
Dim OLE As String = "SELECT * FROM Utilizadores WHERE [Username] = @Username and [Password] = @Password"
Dim myConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & My.Application.Info.DirectoryPath & "BD.mdb';Persist Security Info=True;"
Dim connection As New OleDbConnection(myConnectionString)
[code].....
When I enter on the program, I Register the Username 1. I type the information on the Textboxs Form Login and I enter to the Form Information.In the Form Information, i type some information on the textboxs, Save and I get out.Enter the program again, Register another Username 2, Type information on the Textboxs Form Login and I enter to the Form Information, and I see the Information that I typed on the Username 1..and here's the problem...how can i fix it?
Here I have a code with a CheckedListBox and I want to display multiple information, name, country etc.. My code just displays its name. How to display more information, retrieved from a file. txt, in CheckedListBox ? I do not know what part of the code displays
Here is the function that returns data Public Overrides Function ToString() As String
Return _Name
Return _Old
Return _Country
End Function
What i'm trying to do is retrieve 2-3 pieces of information from a parsed html file, then add the data into a listview in the corresponding columns i was initially going to do a function for each piece of information to retrieve but thought maybe i could do it all with 1 function instead.
[Code]...
I'd like to be able to get and set the different information for a user in Active Directory on Windows Server 2003 under Environment and Session tabs through a VB.Net application. I am familiar with System.DirectoryService but I can not find the correct attributes for these particular tabs. For example, I'd like to check "Connect Printer at logon" or set "Idle session limit".I've found the "ms-TS-Connect-Printer-Drives Attribute" and other attributes like it but they are only implemented on Server 2008.
View 1 RepliesI want to pass an asp.net membership user name to a subroutine and retrieve the profile property named FullName for that user, how can i achive this in vb.net?
View 2 RepliesI am faced with the prospect of having to completely rewrite the application.I have suddenly started to get this error message all the time - it seemed to start after I added a table to the schema, but deleting the table makes no difference. I can't see anything wrong with the connection string, but as it seems to be entirely undocumented, that doesn't mean much.
The connection string contains DataSource=.SQLEXPRESS;AttachDbFilename=|DataDirectory| est.mdf;Integrated Security=True;User Instance=Trueand certainly the string works when I use "test connection" from the application setting edit box. I am assuming that for some reason it is not evaluating the Data Directory , but can't see any reason why it shouldn't. Any ideas gratefully received! What might be a clue though is that I can't get rid of the table I added. I have deleted it from the database, deleted it from designer and saved the file, but it just keeps reapearing! Even when it is not showing, there is still a
table adapter in the .xsd file. I am reluctant to start editing this manually because of the danger of screwing something else up - I did try but it caused an error somewhere else (VS helpfully didn't say where)
I'm using the following code, which works, to login a user to an application built in VB.NET against active directory.This code works great but I need to retreive the user's first name, last name, display name and also check if the user is part of a group.
I've tried many forms of adResults.Property("displayname").ToString() and the like but just can't get it to work right.Anyone have any ideas how to do what I'm looking to do?Public Function ValidateActiveDirectoryLogin(ByVal sDomain As String, ByVal sUserName As String, ByVal sPassword As String) As Boolean
[Code]...
I took sample code to implement the IReportServerCredentials to send the login information to retrieve a report remotely but for some reason the implementation is error prone.
[Code]...
I am at a stand still on this one. I know how to connect and add to the database, I just don't know how to retrieve the information so that a user can see it! If anyone could help me with code or another example.
View 4 RepliesDoes anyone know what the problem is with this error message? One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
View 2 RepliesI am looking for code examples that allow me to write a user's view settings (field sorted by, label selections, etc.) from the detail view of a file open (GetOpenFileName) API
View 1 Replies