Recent update: 2008-3-21
516 byte By
Yes! at 2008-3-7
Hi,i am trying to update an access database with the OleDbCommand.ExecuteNonQuery function......lintRows=lobjOleDbCommand.ExecuteNonQuery("UPDATE TableX SET ColumnValue=9 WHERE ColumnId=1") .....The function returns value 1, indicating that 1 record have been updated.After closing the ...
Hi Folks,I have a situation here..There is a transaction that I start from within my C# code on a Connection object and hit the DB to execute a Stored Procedure. The SP has some insert statements, some update statements and then some SELECT statements also. Now after I read the data back I need ...
If I use TransactionScope against MS SQL 2000 in .NET Framework 2.0 Beta2 then I get distributed transaction. Will LTM-transaction be available for MS SQL 2000 in final version of .NET Framework 2.0?
I can only update one table with SqlDataSource's UpdateCommand property. So how can I update two tables at the same time?
Hi, I just installed VS 2005 team suite and was unable to access the Northwind database through add a connection wizard. The message I got when attempting to connect to it through Jet or ODBC was Unable to add data connection. Could not load type ...
Hey,When I run the following code, I get the error: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)The code ...
Hi Folks,I have a typical situation here.My application is a sequence of windows jobs (all are coded in C#).Now one of my jobs when run is supposed to fetch around 100,000 records from the SQLDataReader, the SP returns 100,000 records. So, this SP call from C# and then reading the data using ...
I have implemented an ADO .Net Provider and want to intergrate it with the toolbox, wizards and the Data Menu. I have derived my Connection, Command, and Adapter classes from the Component class and this lets me place them in the toolbox but I can't find any documentation on how to integrate ...
10395 byte By
gicio at 2008-2-25
Hi! I have a big problem with one of my storage procedures. First of all some information about the server: Dual XEON4 gig RAMWindows 2003SQL Server 2000 with SP4 On the database work at the same time 30 peoples…. But not all execute storage procedure. The storage procedure with that I have ...
We right now have a reasonably large commercial application that's written in C++ and we're currently working in Visual Studio .NET 2003, which actually offered us a smooth transition from Visual Studio 6. The application is working against an Access database with DAO, so we get warnings ...
For whatever reason, the code below (uncommented) does not update a particular record (that it should!) in my access database, but when i comment out the storedProcedure and comm.paramater lines in the savePatientEmbedded method and uncomment the 3 commented out lines, it updates the record ...
I am creating a database system using .NET and an access database. I am using OleDbCommandBuilder to create my SQL commands. However, i get thrown an exception when I try updating a certain field. It says that there is an error in SQL syntax. I extracted and command, and sure enough it is ...
Hello, me again!I found myself a bit confused about "query" and "stored procedure" in access. Are they the same thing? However, I do suspect this is ture as after some googling I found that varies articals mentioned "stored procedures" are actually created in MS Access for Sql server. So what ...
Hi, I have a problem with the TableAdapters implementation: let's say I want to implement a generic method that takes a TableAdapter and performs some operation on it. For the sake of example let's say I just want to open the connection the TableAdapter uses: public void ...
1072 byte By
TomZ. at 2008-2-20
Hi,I'm using a DataGridView that is bound to business objects. I have a DataGridView RowValidating event handler that accesses the business object like this: DataGridView GridView = sender as DataGridView; DataGridViewRow Row = GridView.Rows[e.RowIndex]; MyClass Data = Row.DataBoundItem as ...
I downloaded the Beta 2 and am working on developing a simple app, but wanted to work on the db in the IDE also. I can't get the database diagram window to come up, in fact I have seen reference to it only in the help: Create a database connection in Server Explorer using a member of the ...
I tried to insert a row using code that worked perfectly in vs 2003. Included is some of the code: Dim pid As Integer = CInt(Me.ParentIDLabel1.Text) Dim title As String = Me.TitleTextBox.Text Dim ttext As String = Me.txtGeneralText.Text Dim iss As Integer = Me.IssuerComboBox.SelectedValueand ...
I have several table adapters, each with an InsertCommand (among others). I call BeginTransaction before I start calling Update for each adapter. Update results in the InsertCommand being used but I get an exception because the command has no transaction.The commands are private members of ...
9316 byte By
Naresh at 2008-2-19
HiI am new to all these, I have a access data base, and i am using datagrid to update records, when i click on edit it give me option to edit the record, but when i update the data and clcik on update, nothing happens, there is no change to the record. following is the code.<!DOCTYPE html PUBLIC...
I have been using MS Outlook to create forms that our company uses to collect data and store it in MS Access. Over the years we have added more and more to these forms and to the database.We feel it is time to migrate to a more powerful platform and database. One of the options I am looking at ...
I have several table adapters, each with an InsertCommand (among others). I call BeginTransaction before I start calling Update for each adapter. Update results in the InsertCommand being used but I get an exception because the command has no transaction.The commands are private members of the ...
I have downloaded the Visual C# (Whidby-vs.net 2005) and have tested a sample program(Datatable with Large number of records). Microsoft explained the new features of ADO. NET 2.0 will resolve this issue with the new indexing engine for datatables. Please refer the following ...
Hi there!I'm trying to populate a DataSet from a CSV-File. The CSV-File looks like:"Name";"Given name";"Department";"E-Mail";"Telephone""Test";"Test";"Dep 1";"Test@Test.com";"+49 555 555 555"And my Code looks like this:string strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data ...
Is there any usable DAAB data provider for microsoft Access available? Thanks!
1024 byte By
JDeas at 2008-2-15
I have a routine that builds a menu tree from a datatable recalled from a MySQL database. My problem is I would like to work in a disconnected mode so the user can modify the whole structure and at the end of the session commit it back to the server. I have no problem obtaining the data but the ...
762 byte By
lucaz at 2008-2-15
Im here again with the same problem.I need to create a database interface very quickly.The database is an Access 2003 file, and Im using visual studio.net 2003 (c#).The database has this table:Client- ClientId AutoIncrement- FirstName Text- LastName Text- Document NumberI like to create this ...
180 byte By
Zaph0d at 2008-2-15
I want to validate some dates. I was just using datetime.parse but I can still get a sqldatetime overflow error if the date is not in the permitted range. How can I check for this?
683 byte By
Zaph0d at 2008-2-14
I am using a DA to connect to 4 SQL Server SPs for select, insert, update and delete. The 4 command objects of the DA are set and each command object has the correct parameters.I have some columns which are only in the select and should not be inserted or updated. I have excluded these from the ...
1. I am trying to find a way to get meta data out of the ADO Recordset or ADO Field objects... in particular I am trying to get the base table associated with an ADO Field (or recordset column).The ADO Recordset can be persisted to XML using the Save() method, this XML contains metadata about ...
I am using SQL Express and I do not know how to add images to my database. I've created a dataset and linked it to datalists so everything is perking along except I'm just clueless on the image handling. I create a resx file thinking that would work except I don't know how to coordinate it ...
540 byte By
kul at 2008-2-13
I have following dataset that I fetched from database ID NAME SCORE 1 ABC 70 2 XYZ 80 One another user also fetches same records And Changed the ABC to LMN And update the dataset now data in database is : ID NAME SCORE 1 LMN 70 2 XYZ 70 And I changed 70 to 100 and update the dataset After that ...
4956 byte By
marcvs at 2008-2-12
Specs:--P3 550MHzWinXP Pro.NET 1.1-- Hi there! I'm working on this application using VB.NET and Access 2002. I'm trying to avoid reading the entire database into a DataSet, so I'm using a DataReader to get records I need (it seems fast enough for now). I want to use the DataSet only to add ...
My C# application opens a database table from disk (such as from mdb, txt, csv, xls, dbf) that contains anywhere from 1,000 to 1,000,000 records. However, for tables with many rows in them, the dataset obviously becomes a memory hog. The UI is designed such that the user can scroll through the ...
<span id="_ctl0_MainContent_PostFlatView"></span> <span>Hi, how reinstaller or to update the MDAC on Windows XP service pack 2. Thank you in advance</span>
Please I want quick manual for ADO.net to help to deal with quickly please I want it as fast as you can
367 byte By
clonk at 2008-2-8
Hello, I am trying to connect to a Access database which contains link tables. I can make the connection just fine, but only local tables are shown in the explorer, the link tables are not listed. I know in Visual Studio 2003 you can interact with the link tables. Am I doing something wrong or ...
Hi all,I am developing on VS 2005 Beta 2 and I am having a problem with the Sql data provider. In a stored proc I am calling RAISERROR with a severity of 16 as below RAISERROR('My error', 16, 1)and then immediately calling RETURN but this is not causing an SqlException to be raised in my C# ...
Beta2In a dataset, I have a Parent table and a Child table , in Child table, I have a readonly column with an expression of Parent(FK_Child_Parent).ColumnNameWhen save changes to database, exception happens in the dataset designer.vb code, at the child table InitExpressions procedure at the ...
459 byte By
Timpie at 2008-2-7
Hi,I am using VB.NET with ADO.NET.I am having a problem with transactions : I can't read from a table that i am updating in a transaction. I have tried to change the IsolationLevel, but it is always the same.To make it more clear : While user1 is updating a table (within a transaction), user2 ...
139 byte By
Jade at 2008-2-7
i binded a textbox control and a combobox control to a dataset. i tried updating changes but no update was made. what must have gone wrong.
I am at my wits end! I am creating a simple web application in Visual C# 2005 Express Edition Beta 2 by dragging a table from a data source onto a windows form. I have reread numerous articles on MSDN but with the exception of adding a try block this is as far as I can tell all I need to do to ...
When I want to find the records between a date range, there is a column 'Saledate' which type is Datetime, I always use below way to do that:Select * from Table1 where SaleDate >= #1/1/2001# and SaleDate <= #1/1/2002#It works fine in MS Access UI. But it doesn't work in my C# program. ...
Does anyone know if there is a way to make the DefaultValue of a DataColumn generate a new GUID? I was hoping to see something like this in ADO.NET 2.0 but I doesn't seem to be there...<img src="/library/msdn/emoticons/emotion-6.gif" alt="Sad" /> Thanks Glenn Johnson
Are there any samples around of implimenting IBindingListView on collections for .net 2.0 yet? There's a really great one on IBindingList but I want to go further, and I'm at a loss as to how to intelligently impliment things like Advanced Sorting and Filtering on a collection. If there ...
326 byte By
Meta at 2008-2-5
Hi,I'm using databinding with a MSDE database. When I update values from a dataset to database (using databinding), additional whitespaces are added to the values. In fact, if a varchar column length is set to 10, there are (10-length(myValue)) whitespaces added.Does someone have an idea ...
insertquery doesn't work. Different from earlier problemI have a full error code, but it doesn't get that far. I created an insert query for topics table adapter. The error says argument not specified for parameter active. Active is a check box. I tried it both with true and with checked. ...
I need to connect to a Sybase database server (Version : 11.0.3.3); are there any free ADO .NET driver for Sybase 11? Preferably native driver; having no dependency on any other thing like Sybase Open Client, as my web application is needed to deploy on a commercial web hoster.If anyone has ...
subj
736 byte By
Aslam at 2008-2-4
Hi, I am doing a vb.net application using access database. One of the field is OLE object to store the photo in byte. I am able to insert the picture in byte format. I am facing a problem in updating through vb.net using the TableAdapter update statement. The given update statement is (update <My...
929 byte By
MylesR at 2008-2-4
I'm using an OleDbDataAdapter to insert rows into an Access database. I set up the InsertCommand to update 8 fields and everything worked fine. Then I added a 9th field and I got the error message:"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in ...