Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Can't Use Typed Dataset from Class Library in .Net 2.0 - Help!
Abhorrenator - 8 Jul 2006 11:11 PM - 1 message
I need to have several different applications on a multi-tiered system access a common data infrastructure.  I'm trying to store a strongly typed dataset in a class library (dll) which contains resources common to all of the applications.  I'm having problems. ...
Score Why do we serialize business objects ?
kunaly - 8 Jul 2006 7:57 PM - 2 messages
Why do we serialize business objects? ...
Score Adding new Strongly typed Row - BindingSource Errors
ECathell - 8 Jul 2006 12:46 PM - 1 message
I am trying to add a new item to a table based on another item in the same table. To do this I have the user click on the + button on the navigator. A form is displayed where they enter the new primary key information, tell it what type of templated Item to use and then press ok. In the real world it is adding the row correctly to the database, however I keep getting binding source errors whether it is positional errors(no row at position 837) or invalid object errors(you can only add the same item type to a binding list) ...
Score Access Date Format
Goh - 8 Jul 2006 4:22 AM - 4 messages
Hi guy,     How can we make sure the date format that we pass in MS Access are constantly the format that we wish.     I ask this is because My select statement work in some computer and some ...
Score SQL connection timeout -- is it pretty useless or what?
Rob R. Ainscough - 7 Jul 2006 7:40 PM - 8 messages
I'm trying to code a routine that will test the connection to a server and I would like to specific how long (aka timeout) the .Open() should wait before a timeout error is triggered. I've tried "connection timeout=10;" in the connect string, but that still ...
Score How to set the SmallDateTime field
ad - 7 Jul 2006 7:26 PM - 2 messages
I have a Table with a SmallDateTime field name OrderDate. I want to insert a record into this table, I use the SQL below: sSqlLogIns = "Insert Into hInfLog (OrderID, OrderDate) values ('{0}',{1}) ";   sSqlLogIns = string.Format(sOrderID, DateTime.Now.ToString()); ...
Score DataView Filter Problem
Tom_B - 7 Jul 2006 5:34 PM - 3 messages
Running VB.Net I pass a datatable from a form.list to a form.item and use a dataview to show a selected row in text boxes.  The row to show usesthe dataview's filter property with the selected row's row id. ...
Score One table not updating after a few insertions
samyk - 7 Jul 2006 5:19 PM - 2 messages
Hello All, I'm having this problem which deals with 2 tables in a database. Both tables have a primary key set as an autonumber but also both tables are dependent on each other by having their primary key as a value in their tables. The ...
Score Combobox en vb.net con informacion del AS400
Kary - 7 Jul 2006 4:05 PM - 1 message
Hola Tengo un problema con una pantallita que estoy realizando, lo que quiero es cargar un combobox con informacion de una biblioteca del AS400 pero me marca un error, el siguiente: " La operacion de multiples pasos de OLE DB genero errores. compruebe ...
Score DAAB is good????? I dont think so...
Bruce One - 7 Jul 2006 3:55 PM - 6 messages
I have just opened DAAB code and saw that, incredibly alll functions return only Sql objects. That means this App Block does not deal with Oracle or even other DB like MySQL. I dont understand who would use this... ...
Score word document to appear from treeview how?
julie - 7 Jul 2006 3:21 PM - 1 message
greetings!   I am new to this, so if I am in the wrong discussion group, I apologize. I would like to 1)use a treeview component (in Web Developer 05 Express) to make a Word document open up. Do I use the .COM component Microsoft Office Data Source control  or ...
Score ObjectSpaces is realy good?
Bruce One - 7 Jul 2006 2:48 PM - 14 messages
Hey, I have been using a tool for generating persisting classes (its called MyGeneration)...I not even use DAAB (I was rather creating my own DAAB). Now MS says ObjectSpaces is a good integrated O/RM tool, that will eliminate any ...
Score ANN: C# Online.NET en Español
Press Relations - 7 Jul 2006 12:42 PM - 1 message
PARA SER PUBLICADO INMEDIATAMENTE La primera referencia en Español en línea basada en la tecnología Wiki sobre C# y .NET se encuentra en C# Online.NET Dallas, TX — Un nuevo concepto en referencias en línea para los ...
Score Long running stored procedure
Locus - 7 Jul 2006 1:27 AM - 3 messages
I have a very long stored procedure "runMRP". approx 1000 lines and can runs for 30 minutes at Query Analyser. It runs sucessfully at query analyser with all the result. It runs successfully on osql. It runs fine from VB.Net program on small data set. (with less than few sec ...
Score Access Lock Remains after Connection Closed - OLE DB / Jet
mithridates - 6 Jul 2006 9:30 PM - 15 messages
I am using a non-pooled OLE DB connection to add records to an access database.  The database is an empty template database that is copied to the running application directory for a set of objects.  For each ...
Score Referencing another SQL Server database table
jwilson - 6 Jul 2006 7:54 PM - 7 messages
I am a new user of Visual Basic Express / SQL Server 2005 Express editions. I am trying to write sql statements in an application database that reference tables in another database (same SQL server). Based on the prior posts that I've read, it would seem this is pretty ...
Score Can VS2003 vb .net app connect to SQL Server 2005 Everywhere?
dotnet user - 6 Jul 2006 3:46 PM - 5 messages
I have Visual Studio 2003 VB .net application that currently access MS Access database. Does anybody know that if it is possible for these applications connect to SQL Server 2005 Everywhere thru adonet? Since VS2003 is using .net framework 1.1, and SQL Server 2005 everywhere uses .net framework 2.0, is ...
Score Strange Problem. Unable to run stored procedure:
MPutt - 6 Jul 2006 2:29 PM - 3 messages
I apologize if I am posting this to the wrong area. Here is my problem. I am running a .NET 2003 Windows service against Oracle 9i.  This service is attempting to run a stored proc that inserts data into the ...
Score Datagrid Refresh
Ritesh Sharma - 6 Jul 2006 5:33 AM - 2 messages
Hi All,            I hope someone can help me with this. I am working with real time data.Where on one end there is a desktop application & on the other hand a PDA both communicating with SQL Server ...
Score AutoGenerated TableAdapter and GenerateDbDirectMethods
A.T - 6 Jul 2006 2:31 AM - 1 message
I have a typed dataset. It has a single datatable. I used the wizard in VS.Net 2005 to generate it. It is setup to do a Select from a database view in SQL Server. The view in question is updateable as it has an instead of ...
Score ADOX: Copy table structure with C#?
Sensei76 - 5 Jul 2006 6:17 PM - 3 messages
Hello, I am working with an Access database file and want to create a new file with the same table structure. Creating the new file was no problem, also creating new tables with adjacent keys worked well. But copying the indexes is a pain. ...
Score VB 2005 newbie - Databinding
Oh-its-all-gone-wrong - 5 Jul 2006 3:11 PM - 3 messages
...
Score Raccomandata on line
flavio - 5 Jul 2006 2:40 PM - 2 messages
Avendo visto il servizio di Raccomandata on line mi sono chiesto se sia possibile inviare in modo automatico una raccomandata direttamente dal software. Tipo pulsante invia raccomandata. Grazie FLAVIO ...
Score VB.NET 2005 TableAdapter
ken - 5 Jul 2006 11:30 AM - 6 messages
In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code the query and parameter query by "Query Builder". I can build a single parameter or multi parameters SQL Query by using "Query Builder" (WHERE ClientCode = @ClientCode  ....etc) ...
Score Permission denied error in Javascript
Tanmaya Kulkarni - 5 Jul 2006 9:12 AM - 2 messages
Hi, I my web application, am using frames. <frameset name="aaframe" rows="190px,64.0%,45px" >       <frame name="aframe" language="vb" src="../Top_page.aspx" frameBorder="0" noResize  scrolling="no">       <frameset name="bframe" cols="25%,75%"> ...
Score How to make a DataTable Independent
ad - 5 Jul 2006 4:15 AM - 3 messages
I have a DataTable, it belong to a DataSet. How can I  insert this DataTable to another DataSet? ...
Score Questions about Excel Object Model
Tim - 5 Jul 2006 4:02 AM - 2 messages
I have been digging through MSDN and this group for solutions, but I'm just left with questions. Can I use the object model to create a XLS file from scratch on a machine that doesn't have Excel installed on it? ...
Score ANN: C# Online.NET Summer 06 Contest
Press Relations - 5 Jul 2006 3:00 AM - 1 message
FOR IMMEDIATE RELEASE C# Online.NET Summer 06 Contest Apress Publishing and C# Online.NET have joined forces to reward the most prolific contributors to C# Online.NET. Our contributors are all volunteers from around the Globe: They write articles, source code, and tutorials for the benefit of the C# and ...
Score Index column in Dataset (or Datareader) !!!!
Bruce One - 4 Jul 2006 9:52 PM - 9 messages
When I put the a Select command result into a dataset (or datareader), I have to inform which column index I want to work with...thats pretty akward , since I have to know in advance exactly the order the column appears in ...
Score Enterprise Library (what should I use...)
Bruce One - 4 Jul 2006 9:45 PM - 20 messages
Hi, what is really worthwhile to use of Ent Library framework (e.g. Data Access Application Block) ? Who has used in practice ? Thanks a lot ! ...
Score OleDbDataReader "Closed" Problem
Alex Maghen - 4 Jul 2006 8:28 PM - 3 messages
I've made some changes to the structure of my code around a bunch of my pages which access the database and now I'm getting a very occasional error at DataBind() time saying that my OleDbDataReader object is already closed. ...
Score ANN: SQLite ADO.NET 2.0 Provider v1.0.30.1 Released
Robert Simpson - 4 Jul 2006 5:01 PM - 1 message
[link] Features: Written from scratch on VS2005 specifically for ADO.NET 2.0, implenting all the base classes and features recently introduced in the framework, including automatic transaction enlistment. Supports the Full and Compact .NET Framework, as well as native C/C++ ...
Score DataTable internal index is corrupted?!?!?!
Mike - 4 Jul 2006 4:47 PM - 1 message
Hi all, Some code of mine which has been working for well over nine months, in a recent build (with unassociated changes) has just stopped working. I have a DataTable, which belongs to a DataSet created in the designer. This ...
Score typed DataRow
Ant - 4 Jul 2006 1:06 PM - 4 messages
Hi, I'm using VS2003 C# I'd like to use a typed dataRow in an iteration by using the TableRow property of the Dataset so that I can use the instance to directly access the col. for example: foreach (dsmyDataSet.myTableRow tr in dsmyDataSet.myTable) ...
Score How to read OleDbSchemaGuid tables 1 record at a time ?
tommaso.gastaldi - 4 Jul 2006 10:55 AM - 18 messages
Hi, if we have an OleDbConnection it is possible to retrieve a datatable containing information about the database fields using the statement (watch out line breaking): OleDbConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, New Object() {}) This however return a whole DataTable, which in some cases can be very ...
Score kader
faruk.nur - 4 Jul 2006 8:43 AM - 1 message
Kader; soru:madem,herþey bir kader defterinde yazýlý ve herþey ona göre oluyor.o halde insanlar niçin cehenneme gidiyor? cevap:evet herþey bir kader defterinde yazýlý ve herþey ona göre ...
Score How to insert a DataTable into a DataSet
ad - 4 Jul 2006 5:51 AM - 2 messages
I have a standalnoe DataTable DataTable1, and a DataSet DataSet1. How can I insert DataTable1 into DataSet1? ...
Score The Simplest Question of all
Dave Johnson - 4 Jul 2006 2:45 AM - 3 messages
Greetings, i have a sql text file, and i dont knw how to execute it in VS.net 2005 sql express! can anyone help!? thanks, Sharing makes All the Difference ...
Score Showing/Hiding Some Elements in JS
Alex Maghen - 3 Jul 2006 7:35 PM - 5 messages
Hi. I want to write a function that will show or hide a few elements on the client-side. The elements that I'm working with are, for example, an <asp:Label />. Let's say I have:    <asp:Label id="SomeLB" runat="server" Text="Hi there" /> ...
Score How to generate automatic win-forms for SQL Server's tables?
ABC - 3 Jul 2006 4:54 PM - 5 messages
I need to build many data enter forms for SQL Server's tables.  Is there any best methods to generate data forms from database table structure? ...
Score Binding - problem with column name
Qubeczek - 3 Jul 2006 2:11 PM - 3 messages
Hello, I have the following problem. I have my own component descendand for TextBox, Where I have property "DataField", that indicate into column name of DataView. When I set this property, there is automaticali genmerates Binding Text porperty into particular column. ...
Score Quick Question: SqlDataAdapter.UpdateBatchSize and stored procedures?
windsurfing_stew - 3 Jul 2006 10:43 AM - 4 messages
Hi, Quick question.  I've been playing with SqlDataAdapter.UpdateBatchSize and am puzzled by the results.  Firstly I've got profiling on in SQL Server 2005.  Now, when I set the UpdateBatchSize=0 I find that profiler still shows every update as a separate statement.  This is not ...
Score Need fill all DataTable in a DataSet
ad - 3 Jul 2006 7:31 AM - 2 messages
I have two table in a DataSet. I have set a master-detail relation between then. I thought if I fill the master datatable, the detail table will automatically be filled. but the truth is not. How can I make my thought to b be true? ...
Score .NET/SQL naming conventions?
Byron - 3 Jul 2006 1:16 AM - 2 messages
There seems to be a trend toward the SQL naming convention advocated by Joe Celko that replaces Pascal casing of column names with underscores.  For instance rather than naming a column SaleDate the trend seems to be to use ...
Score DataGridView CellFormating event problem ?
jmd.msdn - 2 Jul 2006 8:52 PM - 2 messages
Hello, the following DataGridView eventhandler poses problem : // I am working with .NET 2.0 in Visual Studio 2005 Pro on a Windows XP SP2 computer // dgvLabels is a DataGridView control private void dgvLabels_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) {   try     { ...
Score Runtime DataSource Selection
Rich S. - 2 Jul 2006 7:53 PM - 4 messages
When I use the Data Source Wizard to set up my project for using an Access Database file, it seems to hard-code the file path of the MDB file into the project. This makes it not possible to allow the user to specify what MDB file he ...
Score Read Word docs from Image (BLOB) Column in SQL Server
excession - 2 Jul 2006 4:12 PM - 7 messages
Hi I'm trying to read RTF and Word files from blob columns in SQL Server, but the files can't be opened in Word when i retreive them. They seem to contain garbage... What am I doing wrong? This is some of the code used to get the files: ...
Score Moving a database
cashdeskmac - 2 Jul 2006 9:09 AM - 3 messages
I am using the MSDE version of SQL Server in order to create a  SQL database.  Once I have reated the database, how would I go about sending it to a colleague so that he can install it on his version of SQL Server?  Is it just ...
Score database connection
Pure Heart - 2 Jul 2006 6:55 AM - 11 messages
hi guys im developing a desktop application that conect to a database, and that database file is in the application development folder, and i made a dataset that conect to it but after packaging and installing on client pc the ...
Score DefaultValue and Caption in Dataset Designer
Paul Craig - 2 Jul 2006 4:54 AM - 2 messages
Hi everyone, Just wondering if someone can explain to me the reasoning behind (and a possibly workaround) why the DefaultValue and the Description (Caption) values dont come across to the dataset from a given database. I am using SQL Server 2000 and have this probhlem in both Visual Studio 2003 and 2005. To ...
Score ODP.NET migration
Erik Cruz - 2 Jul 2006 4:45 AM - 4 messages
Hi. As I could not find material regarding this issue on Oracle newsgroups, I would like to try your help. I have an ASP.NET application that uses ODP.NET version 9.2.0.7 to access an Oracle 10g database. The application works ok, but now we are considering to ...
Next »