Hi There, I have databound a multiline textbox to a memo field in an access database. When the multiline textbox's value is nullstring ("") the Update command of the associated Adapter fails. (The field that the multiline textbox is databound to allows Null values). Any ideas? Perhaps a b...more >>

Hello, is there any method to load DataSet from CSV file and on the other side to place them to the file or some string? Ondra. ...more >>

Hi NG, how to make a DataView show only selected COLUMNS? E.g: DataTable table // is already in memory and has two columns: "id" and "value" DataView view // should only show all rows from "value" TIA, KN x-post & f'up to .adonet ...more >>

I have a dataset with a datatable that has an identity column. There are no relationships. I'm trying to directly add a datarow to the datatable using existing data from the database, including a value for the identity column. It won't let me because it says the indexer is read only. What...more >>

I want to create ASP page that shows the schedule of TV station. Since each day's (Monday - Sunday) schedule is different, and I want each day will display the schedule on that day of a week. I wonder if I need to create 7 different ASP pages and call different one on each day? This is just my i...more >>

Hi I have a databound form with "person data" (ie first name, surname, gender) that is bound to a dataset. I would like to filter the form so it only shows persons with gender = "Boy". I have tried to edit the sqlDataAdapter.Selectcommand.commandtext and then use sqlDataadapter.Fill(MyOriginal...more >>

Hi, I tried to insert an Image object, like I insert a text or numereic value,into a column of type OLE Object,but it received an error message. Do I need to do extra work to insert an image to OLE Object column? Thank you. ...more >>

Hi, I am trying to add a OleDataAdapter to my form so i can connect my datagrid to my access XP database. When i am propted in the configuration stage to enter a sql query, i use the query builder to create the following query: SELECT [Caravan details].Beds, [Caravan details].[Caravan ...more >>

Hi, I have a form with many controls on it that is bound to a dataset containing several related tables. The form will display data from one DataRow of a main table as well as related data from a number of child tables (with 1 to 1 relations). Now I have several problems with the way this thin...more >>

I have a SqlDataAdapter that queries the main table tblTime and joining it with another table tblStaff just to get a description column "StaffName" from table. I Select tblTime.StaffID, tblTime.TimeSpent, tblStaff.StaffName FROM tblTime INNER JOIN tblStaff ON tblTime.StaffID = tblSt...more >>

Hello, I have looked at several ADO.NET resources and they all say to use the infomessage event handler. I have added the code to my form but when I disconnect the network cable, it does not fire. I have also read that infomessage is for server error messages below 10. I have tested t...more >>

Hi, Im new to Vb.net and am trying to create my first practice project. The problem iv encountered is to do with SQL queries issued against my access DB iv created. i want to wright a query that will pull all the caravan details that are available at a partuclar date which will be enter...more >>

Hi I have got 2 dates that need to be stored on my access database. arrival_date and departure_date. these values are entered by a user who is making a room booking. What i wanted to know is if there is a function in vb.net that recognises this as an interval and therefore stops booking...more >>

I'm using vb.net and actually am using ADOX 2.7 so I can create an empty access db (working fine) then create linked tables. I "thought" i did this before and found references to this working but it barks and says the properties are read only. is there a problem with the following? How ...more >>

I am trying to sort a datatable, and return the sorted results. Not working with a datagrid, or ASP.NET. Cannot do the sort on the database. DataView dv = existing table view dv.sort = "EVENT_DATE DESC" DataTable NewTable = new DataTable(); foreach (DataRowView drv in dv) { DataR...more >>

Help! We keep all our contacts in a public folder called "Company Contacts", I am writing a windows forms vb.net application, where i would like to find a contact from that public folder, and get some information from it like, "Full Name", "Business Fax" etc etc. Right now i have an Outlook...more >>

I am trying to set up a master-detail relationship between two grids. I have two problems: 1) The DataTables that are the sources for each grid have a many-to-many relationship, meaning there is a cross- reference table between them. 2) The DataTable for the detail grid refences a DataTable ...more >>

Hello, I am having this strange time out issue with some of our stored procs. We have an SQL server on which we run our databases. Some times all of a sudden a stored proc that is running fine from ASP.NET will start timing out. The same query will run fine in the query anlyzer. Initially w...more >>

All, we are developing ASP pages using middle tier COMs written in VB and using ADO. It is quite huge application and we are considering development of new functionality in .NET. It means that the existing code (using COM and ADO) will be executed side by side with new ".NET" code (using ADO.N...more >>

I've got some file UDL's I use with my current 6.0 apps. I want to use them with .NET, but I can't get the connection right. Basically, I'm doing this (C#): strConnect = "File Name=" + HttpRuntime.AppDomainAppPath OdbcConnection con1 = new OdbcConnection(); con1.ConnectionString = strConn...more >>

On a pocketpc 02 with sqlce I get a dataset with 30,000 records from a webservice I then load this dataset into a empty table that has no indexes or constraints. The load takes 50 minutes, which is about 49 minutes to long. Is there a faster way to do this? Dim cmd As New SqlCeCommand ...more >>

Hi all, I have two master/child tables master: DEPT - PK deptid child: EMP - PK empid ,FK (DEPT.deptid) when i fill a dataset with the records of these two tables Dataset ds=new Dataset(); DataAdapter.Fill(ds,"DEPT"); DataAdapter.Fill(ds,"EMP"); and add constraints to it DataColumn[...more >>

Hi; I am try to select only child rows of data from two related dataset data tables. I am using the "table.select" method. Here is an example of the code : Dim holdstr As String = MonthCalendar1.SelectionEnd.ToShortDateString For Each rowCase In dsCases.Tables("dtCases").Ro...more >>

Dear all, i am using the following code to get data from Oracle. Sometime it returns 0 record but if i reduce the number of columns or reduce the size of columns in query, i get all the records. ANy Pointers? DataSet dsTmp = new DataSet(); OracleDataAdapter daOracle = new OracleDataAdapter...more >>

Hello: I am trying to use an output parameter with the data access application block and seem to be running into some difficulties. Specifically, I am receiving the error message: "Object reference not set to a reference of an object" when I attempt to access the parameter value. Component ...more >>

Hi, I'm trying to pass data between the Data Access Layer and the Business Process Layer of my app.... Is the best way to do this... DAL public function SavePerson(byval ds as dataSet) as boolean .... code in here end function public function LoadPerson(byval ID as integer) as Datas...more >>

Using System.Data.OracleClient in .NET 1.1 framework... If I'm reading the OracleConnection docs right, it indicates that if I do this: using (OracleConnection con = new OracleConnection(dsnstring)) { ... } then although it appears that I'm destroying the connection each time, ...more >>

I have a truedbgrid with AllowAddNew = False The changes I make to a record are only submitted after I move to another record. This could pose problems if there is only one record in the table (because then you can't change the cursor) How can I take care of this programmatically ? I want ...more >>

Hello, I need to use Update Sql stmt from my page. Some of the field values has apostrophes and and quotes. How do I make ado.net ignore those characters? Eg- UPDATE ROOM SET HEIGHT='3' - 5"' WHERE RMNU='100' Iam using c#. Thanks. Jay ...more >>

Hello all, I have created a dataset with a datatable in it. A dataadapter fills the datatable with username, password, first name, etc.... Then I put the datatable in the dataset. The password is encrypted before it is saved to the db. So when the datatable is filled with the password col...more >>

Has anyone read any articles which discuss DNA Architecture and the use of Visual Studio to create database applications? We talk about Data Access layers, Business layers and Presentations layers being different programs and then focus our development on using Visual Studio to create Connection...more >>

Hi All! Does anyone know how to disable adding/deleting rows in a DataGrid whose cells could be edited? Many thanks, Phil...more >>

I have a datareader that I am using in my VB.NET code. I loop through it once "processing" each row. On the 2nd "pass" I want to get the newest data in the database (stored into a 2nd datareader) and compare each record (compare dr1 and dr2) to see what has changed. If a row remains the same...more >>

Hello! I have a question about treathment of optional parameters of Stored Procedures in ADO.Net If I have the following SP (on SQL Server 7.0 DB): CREATE PROCEDURE dbo.test_sp @first_param int = NULL, @second_param int OUTPUT, @third_param int AS BEGIN RETURN 1 END How c...more >>

Hi All, I posted this m.p.d.l.vb but someone suggested I post here, so here goes. I've shortened it down to this simple example: I'm getting an error message saying "Input string was not in a correct format" I hope someone can help or spot the obvious mistake maybe? I also wonder if ther...more >>

Does anyone know how (or if it's possible) to call a vb.net routine from, say, a stored procedure, in SQL Server 2000? Thanks!...more >>

I have a data adapter that I created in a Win forms application. I used the "data adapter configuration wizard" to create the stored procedures in the database (SQL server 7). I can bind the data to a combo box and it works fine when I'm displaying only one field. What I need to do is...more >>

I have a large dataset that I want to be able to retrieve a datatable (product codes) from my dataset which has duplicates. I want to be able to select the unique product codes and put into a new dataset which i need to use to bind to a combobox. How can I accomplish this? Thanks ...more >>

Hi Techies, I am facing problem in copying content of table from a untyped dataset into to a table inside the typed dataset. I wanted to copy the data into typed dataset in order to ease the further processing using typed references. DataSet ds = getDataFromDB(); - i am getting the datase...more >>

I am attempting a very straight forward Update on a dataset. I have a WinForms N-Tier app using VB.NET. Visual DataAdapters, typed Datasets. Me.txtHomePhone.DataBindings.Clear() Me.txtWorkPhone.DataBindings.Clear() Me.txtPostalCode.DataBindings.Clear() 'New fie...more >>

I am trying to get SQL Debugging working in VS.NET 2003 so that I can step into stored procedures. I have gotten this to work in the past on another machine, but I am not having luck with this one yet. * Windows XP Pro * VS.NET 2003 * SQL Server 2000 SP3a and most recent patch * Query Analyz...more >>

I am currently trying to find a way to retrieve column datatypes for use in a managed component. I have looked at using the OleDbConnection.GetOleDbSchemaTable method and the OleDbDataReader.GetSchemaTable method. The OleDbDataReader.GetSchemaTable method provides the information I need,...more >>

I'm new to ADO.NET, and trying to understand... Say you have a disconnected DataSet generated by "SELECT * FROM MyTable WHERE ID = 1". The DataSet is edited and passed back into a data component for update. For instance: Persistence.Store(myDataSet); Assuming Persistence.Store knows the...more >>

Hello, I have an Access table called Products which contains text field Description. When I use Data Adapter Configuration Wizard to generate the SQL statements for that table it says that it couldn't generate UPDATE and DELETE statements. The following is a code snippet for SELECT statemen...more >>

Hi All, Wondering if anyone else had encountered this problem. As an English based country our date format is dd-mm-yyyy format. This has always been a bit of an issue with Jet as natively it expects mm-dd-yyyy. However, I have struck a problem with the OLEDBPRovider in .net 2003 whereby I ...more >>

Dear all, I am using an access 2000 database in my application and VB.net. I am able to handle simple querry on a unique table without any troubles. Now comes the fact that I need to execute a querry in order to retrive information from an other table. this works fine when I execute th...more >>

I fear that I am asking a very elementary question, but never-the-less I need help so here goes... I need to simply copy the contents of one DataTable into another DataTable. My application looks something like this.... DataTable dt1, dt2; dt1 = new DataTable(); // Read dt1 from database ...more >>

I am having problems with the HasChanges() method. Here's what I have: 1. Access Database with Suppliers and Suppliers_Plants tables. 2. One ComboBox (bound on the Suppliers key) and multiple TextBoxes bound the Suppliers table fields. This is DataSet41 and I can't seem to see if there w...more >>

Hi I'm trying to set the text value of a combobox when I navigate to a new record using me.cboCombobox.text="" however it will not reset, I can step through the code and see the line execute, and check it in the immediate window, it still retains the value of the last record it was on, if...more >>

Hello all, I have a sql string that including both insert and select, for example: sql = " INSERT INTO table1 (id, name) VALUES ('100', 'hello world') "; sql += " SELECT MAX(id) FROM table1 "; I want to execute these two sql statement in one execution, so i decided to use executeReader. ...more >>