Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Multiple combo of same table
Hemang Shah - 29 Jan 2005 11:59 PM - 2 messages
Hello I have a lookup table in my database like this: tblLookup     LookupType     LookupValue Suppose that lookup type is Language Spoken; Country; Gender etc.. and I want the individual combo box to list only the values of one type. ...
Score DataView vs. DataSet
Hemang Shah - 29 Jan 2005 8:40 PM - 9 messages
Hello Few things to remove the cloud: 1)  Can a DataView be a subset of a DataSet ? 2)  DataSet consists of tables, is that different from a DataTable object ? 3)  In IDE, when you create a DataSet it also generates update, add, delete ...
Score Sporadic Error: Cannot find table 0
POL8985 - 29 Jan 2005 4:39 PM - 6 messages
The application is developed in ASP.Net with a SQL Server database. Essentially, the application uses a single shared Connection object for all users logged into the system.  The connection object is opened/closed for each transaction. The error - System.IndexOutOfRangeException: Cannot find table 0 - ...
Score How to simple storage data about colors in database ?
£ukasz Margielewski - 29 Jan 2005 1:30 PM - 4 messages
I have column color, which describes color of something ..Ths paramete I use to set color of some windows forms, which willr epresents data in records... what is the simplest way to storare inforamations about colors in database ?? ...
Score How to control another program that is running?
Tee - 29 Jan 2005 10:13 AM - 3 messages
Hi, Does anyone know how to control another program that is running? Eg: I would like to control the outlook express and tells it to minimize. Thanks. ...
Score Why do I get an error message
dennist685 - 29 Jan 2005 8:35 AM - 2 messages
Why do I get the following error message.  If I click on a datagrid after clicking addnew, an unhandled exception has occured in your application.  If you click continue, the application will ignore this error and attempt to continue.  If ...
Score Problem with ExecuteNonQuery() Result, Access, ASP.NET, C#, ADO, OleDB
vanvee - 29 Jan 2005 5:58 AM - 8 messages
Hi I have the block of code below which is supposed to determine the number of rows affected with an update statement (ASP.Net, Access, C#, ADO.Net, OleDB) to determine if the update was successful or if a concurrency error occurred.  There is an enumeration defined called ...
Score protect overflow of sql data type decimal(9,3)
Zeng - 29 Jan 2005 2:46 AM - 2 messages
Hello, I have many fields in my SQL database that are of type decimal(9,3).  How do I detect a decimal value (type decimal in C#) will overflow the db column of sql type decimal (9,3)?   Is there a way to figure out the min/max constants ...
Score date format in parameter
Paulb1us@newsgroup.nospam - 28 Jan 2005 10:07 PM - 6 messages
I have SQL parameter that looks like this: cmdUpdate.Parameters.Add ("@invoicedate", SqlDbType.NVarChar, 40).Value = dr["invoice date"].ToString(); IT is updating a field in a SQL2K database. The database field is of type char and not date. The data in dr["invoice date"] looks like this: ...
Score SqlDataReader.GetChar(n) failed because of Specified method unsupp
DHuang - 28 Jan 2005 9:47 PM - 6 messages
Hi there, I just set up my VStudio 2003 and tried to run a test of reading a character from database by using SqlDataReader.GetChar, but it failed. I got the following error message: ----------------------------------------------------------------------------------------------- An unhandled exception of type 'System.NotSupportedException' occurred in ...
Score Cant get Stored Procedure connection string right??
hemant - 28 Jan 2005 7:15 PM - 3 messages
Hi,    SqlCommand cmd = new SqlCommand("my_storedprocedure",con);    cmd.CommandType = CommandType.StoredProcedure; The error is : type or namespace name 'CommandType' could not be found(are you missing a using directive or an assembly reference) I have included the following namespaces ...
Score Question on how I can use ForeignKeyConstraint
Harry Keck - 28 Jan 2005 6:25 PM - 3 messages
I am using ForeignKeyConstraints so that when I change a parent row's key, the child rows are updated with the appropriate key. The problem that I am running into is that I would like to be able to add a ...
Score How to make an XSLT from one scheme to another?
Ruslan Popov - 28 Jan 2005 6:05 PM - 2 messages
Hello, Can you recommend a tool for making XSLT schemas. Let's say I have one XSD scheme, and I want to make another XSD scheme from the scheme 1, containing generally the same elements, but groupped in another way, omitting some ...
Score Confused about MissingSchemaAction.AddWithKey
Tony - 28 Jan 2005 5:29 PM - 2 messages
Hi! I am trying to improve the speed of the app. Can you tell me if i need to use AddWithKey or not? Thanks. if (base.OpenDB() != System.Data.ConnectionState.Open) { throw new Exception("Unable to open DB connection!"); } string sSQL = "SELECT * FROM PROCESSCONTROLVIEW WHERE GROUP_ID = '" + sTemp ...
Score Data reader already open?
Brett - 28 Jan 2005 5:22 PM - 6 messages
I'm using this code in VS .NET 2003 [code] Me.SqlCmd_BlacklistUpdateStatus.CommandText = "dbo.[SpamUpdateReport_blacklist]" Me.SqlCmd_BlacklistUpdateStatus.CommandType = System.Data.CommandType.StoredProcedure Me.SqlCmd_BlacklistUpdateStatus.Connection = Me.cn2 Me.SqlCmd_BlacklistUpdateStatus.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, ...
Score What is the Best way to fetch the most recent updated row in a database
jagrat - 28 Jan 2005 4:59 PM - 5 messages
I am having an OleDBDataAdapter and a dataset. I fill the dataset with a row and execute Adapter.update(dataset,"Table Name"); Adapter.fill(dataset,"Table Name"); For the database table, my primary key is an auto number. Currently, I am fetching the key using: ...
Score Question about SQLDataReader
Marlon - 28 Jan 2005 3:34 PM - 6 messages
Would there be any performance gain to calling SqlDataReader.GetSqlXXXX instead of SqlDataReader.GetXXXX ? I assuming that  SqlDataReader.GetXXXX makes a call SqlDataReader.GetSqlXXXX (i.e.GetString calls GetSqlString) ...
Score RowState
?scar Martins - 28 Jan 2005 3:34 PM - 2 messages
Hi I have a datable that is linked to a db table. When I delete an unchanged row and then add a new row with the same values my datatable stays with a deleted and an added row identical in values. When I ...
Score Question: SqlDataReader.GetSqlXXXX vs. SqlDataReader.GetXXXX
Marlon - 28 Jan 2005 3:29 PM - 2 messages
Would there be any performance gain to calling SqlDataReader.GetSqlXXXX instead of SqlDataReader.GetXXXX ? ...
Score Dataset created in Code cannot be used in Crystal Reports designer
Chris - 28 Jan 2005 12:53 PM - 3 messages
Hello, I've created a Dataset in code on my form based on an OLEDB provider also created in code.  I want to be able to use this dataset in a Crystal Report, but the dataset is not listed in the report designer?  I'm not sure how to ...
Score OleDbParameter doesn't update value correctly
HungTrinh - 28 Jan 2005 4:33 AM - 3 messages
Hi,     I use OleDbCommand to insert a new row to Access database. We reuse instance of OleDbCommand more than one times.     example:         - The value of the first record is QueryID = 1  and BooleanOperator = "And"; Add to database correctly; ...
Score Continue to develop a old project at a new web path
cschang - 28 Jan 2005 3:09 AM - 2 messages
I have developed my web module project at my test machine under a different web path ex.  c:\inetput\wwwroot\myProject and tested it. After it work find there I coped it to my real web site under the ...
Score # of pooled connections seem too high
Bob - 28 Jan 2005 2:02 AM - 3 messages
We have a production web site that's data intensive (save user input to DB and query for displaying) with the ASP.NET app part on one W2K server and SQL 2000 DB on another W2K server.  I have set up performance logs to log # ...
Score infoMessage Truncated
Lachlan - 28 Jan 2005 1:47 AM - 4 messages
I have a large SP that has various print messages throughout. I want to view these print messages from .Net. As such I wire up an infoMessage event handler to the connection. If executed using executeNonQuery it will return all messages fine. Using ...
Score Domains
Charles A. Lackman - 28 Jan 2005 12:26 AM - 2 messages
Hello, I have a made client application that adds records to a database on a domain.  Every now and then the database will create duplicate records.  I have closely checked the code and have not seen anyreason for this to be.  I ...
Score help to nav through DataReader
Chris - 27 Jan 2005 10:59 PM - 4 messages
I need to move through some records to get the first and last value of a field. The od days there was movefirst, etc in ADO. I know .ExecuteScalar() can get me the first record. But if I use a ...
Score Concurrency in N tiers
Rodolfo - 27 Jan 2005 9:34 PM - 6 messages
Hi, I'm creating the arquitecture of a N tiers application, at the moment I decided to use classes to inherit from Dataset in order to represent the Data Entities. However I hit the concurrency problem and I'm not sure how to prevent it ...
Score Cannot generate DataSet from SQL SP in VS 2003 (Biztalk 2004!!)
Shaun - 27 Jan 2005 8:11 PM - 2 messages
I have VS.NET 2003 and also have BizTalk 2004 installed on the machine. Usually it is possible to add a DataSet to a project and then drag a stored procedure to the design surface to create a strongly typed dataset. ...
Score preventing new rows in datagrids when using relations
Albert Price - 27 Jan 2005 5:05 PM - 3 messages
hi, i am using 2 datagrids tied together with datarelations in a  dataset. That part works great. i need to suppress the new row on the datagrid but cannot use the readonly properties on the datagrid so i  can allow the user to check off on bool ...
Score How do I filter a child table through its parent?
Carolina - 27 Jan 2005 5:03 PM - 8 messages
Hi all! I am trying to apply a filter to a table in a dataset using criteria from a parent table, but I have no luck so far. Having a dataset with tables for Customers and Orders, and a relation ...
Score Looking for ideas on how to handle a specific data situation.
pantichd - 27 Jan 2005 4:21 PM - 4 messages
Hello, I'm looking for options in handling a certain data situation. Data is stored in Oracle. There is a database that contains tables with common information. For example, it contains a table called USER_COMMON. This table has a key field ...
Score datagrid paging and XML
Perre Van Wilrijk - 27 Jan 2005 3:15 PM - 4 messages
Hi, Just curious. If you use the pagingsystem delivered with ASP.NET datagrid control ... will the system access the database each time you ask the next page ... or will all data be loaded into a hidden XML-file which will be used when ...
Score SELECT Distinct from DataTable, without using SQL
Duncan M Gunn - 27 Jan 2005 2:47 PM - 5 messages
Hi, I have the following query I run using SQL: Select Distinct col1 as D1, col2 as D2, count(col3) as CountOf from MyTable group by col1, col2 order by col1 I need to be able to get the same result without using SQL, by querying an ...
Score Re: Apostrophe in SQL string
Guest - 27 Jan 2005 9:59 AM - 7 messages
You've probably solved this by now. All you have to do is add another apostrophe beside the one you'd like to store e.g. insert into table XYZ (Firstname) values ('D''Artienne'). So in the table the column Firstname stores the value D'Artienne. ...
Score Re: Apostrophe in SQL string
Guest - 27 Jan 2005 9:55 AM - 4 messages
...
Score ASP.NET connection file problem
asad - 27 Jan 2005 7:53 AM - 3 messages
Hello friends, I have some problem in my ASP.NET connection 'Connection file code <% dim connstr connstr=("Provider=Microsoft.Jet.OLEDB.4.0;data source="&server.mappath("database/it.mdb")&"") %> follwoing error message occur when i execute the page ...
Score Connection Object
Charles A. Lackman - 27 Jan 2005 2:34 AM - 2 messages
Hello, Is there a way to connect to outlook's address book with ADO.net and fill a dataset with it? Any suggestions will be greatly appreciated. Thanks, Chuck ...
Score Executing SP while data read is open?
Brett - 27 Jan 2005 1:47 AM - 7 messages
I execute an SQL stored procedure that returns 5 records ("SqlCmd_SpamUpdate_spfBlackUnprocessed").  I then open a data reader, loop through those five records while calling stored procedures that does updates.  The second SP needs information from the 5 records being returned. ...
Score How to check for query field length
Kurt Schroeder - 27 Jan 2005 12:43 AM - 3 messages
I have the follow asignment:       txtDescription.Text = dtrSlb("slbDesc2") If the field returned  is Null i get a run time error. I can check for if (dtrSlb("slbDesc1").GetType.ToString() = "System.DBNull") then .... But there has to be a better way. ...
Score Async Calls to DB does not help in the efficiency department?
roberto3214 - 26 Jan 2005 11:49 PM - 4 messages
Hi Guys, I was recently reading an article: [link] [Excerpt] "One of the most common types of I/O operations that occur within a Web ...
Score SQLHeper ExecuteNonQuery - returning values
Paul Aspinall - 26 Jan 2005 11:02 PM - 6 messages
Hi I have a Stored Proc in SQL server, which creates a record key when a record is created. I want to return the value back to my code, once the record has been created. I am using SQLHelper (Data Application Blocks for SQLServer), and calling ...
Score Oracle Datareader - Datatype
SDF - 26 Jan 2005 10:37 PM - 4 messages
I have a table in 9.2 and a field as INT.  When I use an OracleDataReader to query the table the field is being returned as Decimal.  Being not to familiar with Oracle does anyone have an idea why? ...
Score Implementin Three-Tier App.
Anibal - 26 Jan 2005 9:28 PM - 3 messages
Hi, I'm learning about three-tier programing and i want to implement this in a simple windows forms Application (not web), i'm using an Access 2000 Data Base, the objective of my application is to stores data from cd's into the ...
Score Common SQL connection help
fsu_mike - 26 Jan 2005 9:19 PM - 6 messages
Can someone share with me code for the following task please? 1) User clicks a button(button1), to bring up a file location window for the user to select the SQL Server 2000 and Pub database on the network(not ...
Score get record count from stored procedure without passing DATA back?
John B - 26 Jan 2005 8:00 PM - 3 messages
Is it possible in ADO to execute a (select) stored procedure, but just return the number of records, not the actual data. My client has some stored procedures which if executed with certain parameters can return thousands of rows. I would like to execute a check ...
Score Data Controls or Code
Steve Murphy - 26 Jan 2005 7:37 PM - 7 messages
I'm fairly new to .NET, so bear with me if this question is naive. But do most developers use the VS data controls for connections, adapters, and datasets, or do you write all that code manually? And if you use the controls, how do you wrap your connection and adapter ...
Score need to know the primary key of a table
toufik - 26 Jan 2005 7:07 PM - 3 messages
Hi, in order to know the primary key of a table in my dataset, i've the folowing code sql "select * from table1" create a dataadapter with this sql DA fill the dataadapter in a dataset DS DS.Tables(0).PrimaryKey ...
Score ARITHABORT....
Ollie Riches - 26 Jan 2005 4:25 PM - 7 messages
I have a stored procedure that is being called from ado.net and it is failing with an exception that is related to the option ARITHABORT - 'UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. This stored procedure works perfectly fine from query analyzer and from ...
Score Execute Query on a TOTALLY disconnected DataSet
rawCoder - 26 Jan 2005 4:17 PM - 2 messages
Hi All Is there a way to Execute a query (possibly including two tables and joins) on a totally disconnected dataset. By 'Totally Disconnted' , I mean there is no DB and there is no DBConnection / DBCommand - all the data and structure is in memory. ...
Score db file lock problem, permissions help
Kurt Schroeder - 26 Jan 2005 3:55 PM - 3 messages
I'm having a problem with my test server where I get the following message when i run a simple test app created in VisualStudio.net: The Microsoft Jet database engine cannot open the file 'E:\WebSites\DamarStone\db\damarstone.mdb'. It is already opened exclusively ...
Score Null Exception on OleDbDataAdapter.Fill
Chris - 26 Jan 2005 1:51 PM - 4 messages
I am getting Null Exception error when I try to fill a dataset.  I am providing a value for my parameter so I'm not sure, what's going on.  Please see below..... Thanks Dim cmd1 As OleDbCommand = New OleDbCommand ...
Score update a DataSet object with a GridView
dave - 26 Jan 2005 12:51 PM - 2 messages
hi, it seems, that a lot of people have the problem (including me), that isn't possible, to update a dataSet object with a gridview (without a data objet). does anybody knows something about this problem??? thanks. ...
Score problem of using ACCESS
Shao Yong - 26 Jan 2005 9:05 AM - 4 messages
I've written an asp.net application using ACCESS as the database. It works well first. But after a while, I found the application cound not make response to user's request quickly. It seems dead. You couldn't the ...
Score Three-Tier Application Examples.
Anibal - 26 Jan 2005 6:12 AM - 2 messages
Where can i find simple Three-Tier Application Examples? Thank you. ...
Score How to update dataset with multiple tables in C#?
afunguy - 26 Jan 2005 3:53 AM - 2 messages
I create 2 tables, ParentTable and ChildTable. The row in ChildTable is referenced to ParentTable. But after updated and saved to database, the row in ChildTable doesn't refer to the correct row in ParentTable. You can see the following example to get the problems. ...
Score NullReferenceException in call to DataTable Select
headware - 26 Jan 2005 1:06 AM - 3 messages
I'm trying to use the Select() method on a DataTable but I'm getting a NullReferenceException. Here's the stack trace: at System.Data.Select.Evaluate(Int32 record) at System.Data.Select.FindFirstMatchingRecord() at System.Data.Select.GetBinaryFilteredRecords() at System.Data.Select.SelectRows() ...
Score Optimizing multiple rows storing into Access 2003. Need Help!
yachea2002 - 25 Jan 2005 11:17 PM - 2 messages
Hi I am looking for a way to optimize my data storing into an Access 2003 Table (the mdb file I am using is Access 2000 version) oleDbDataAdapter seem to write one row at time even if it receives multiple rows ...
Score Like keyword
Patrick - 25 Jan 2005 11:03 PM - 2 messages
Hi Group I have one column which can be either Null or with some value. I have one filter criteria in From End with "All", 'RTF Yes' and 'RTF No'. Depending on the filter selected by user i have to select the pertaining ...
Score Re: DataAdapter problems...
Paul Aspinall - 25 Jan 2005 10:52 PM - 2 messages
OK I have made a little progress on this.... Seems I was missing: dataset.Tables[0].AcceptChanges(); However, this alone did not fix it.... I needed to manually assign the value from the 'bound' textbox, by doing... dataset.Tables[0].Rows[0]["Name"]=boundtextbox.Text.ToString(); ...
Score SQL Server Error Trapping in ASP/ASP.NET
Havagan - 25 Jan 2005 8:51 PM - 2 messages
I've run into an odd bit of behavior when dealing with SQL Server 2000 and ASP/ASP.NET that I wanted to discuss. The issue I encounter is that in a stored procedure, once a SELECT statement succeeds and returns a recordset, all resulting errors are ignored by ...
Score Lock tables during SELECT
Pickles The Cat - 25 Jan 2005 8:12 PM - 3 messages
I am doing a transfer operation from one database to another. During that time, I want to lock some tables so no new data can be written. How can I do this ? ...
Score vb.net version 1.1 Can't connect to SQL server2000 on a server.
fsu_mike - 25 Jan 2005 7:51 PM - 7 messages
Can someone tell me why I can't use the data adapter to SQL server 2000 on my server using vb.net 1.1?  When I try from my workstation, I get a good test connection message, but then VB will tell me the following message "Unable to ...
Score TableMappings
Fei - 25 Jan 2005 7:38 PM - 2 messages
Hi,    I got a problem by putting 3 SELECT statements in one DataAdatper. I try to build a 'Select' DataAdatper, which only has select command. I put following lines in select commandtext    Select * from Orders;    Select * from OrderProducts; ...
Score Cannot Create a Dataset for an OLEDB DataAdapter
Chris - 25 Jan 2005 7:17 PM - 3 messages
Hello, I have an OLEDB DataAdapter and cannot create a Dataset to use with the adapter because the SelectCommand contains a parameter.  Is there a work around for this? Any Help is appreciated. Thank You ...
Score Error while using Scope_Identity() instead of @@identity. WHY?
nashak - 25 Jan 2005 7:13 PM - 2 messages
Hello everyone, I am trying to get back the primary key and was using @@identity without any problem. However, when I use scope_identity() I get the following error. "Cast from type 'DBNull' to type 'Integer' is not valid." Please help. ...
Score Error joining tables from separate db's using SqlCommand object
Corbin - 25 Jan 2005 7:04 PM - 5 messages
I'm trying to run a query that joins tables from 2 databases on the same server.  The query is like this: SELECT TitleID, u.Name as Assignee FROM tblTitle t LEFT JOIN titlepost..Portal_Users u ON t.TitleProcessor = u.email ...
Score Constructing a Dataset from XML
Michael Kellogg - 25 Jan 2005 5:49 PM - 6 messages
I have an XML file I've created in another application that contains information on files, forms, and job header.  My plan is, in my new "consumer" app, to read in this data and work with it, ultimately producing labels for shipping, etc. ...
Score ASP.NET Connection String
m00nm0nkey - 25 Jan 2005 5:27 PM - 5 messages
Hello, I have successfully been using the following connection string to connect via a SQLConnection object in my ASP.Net application for many weeks: Data Source=MARS-TEST;Initial Catalog=CascadeWMCClient;UID=marsweb;PWD=marsweb Today, after our Network Support Technician added a hard drive to the ...
Score copy datatables between datasets..
venkat - 25 Jan 2005 5:21 PM - 4 messages
How do I copy a table from one dataset to another ? code I am using and that is not working : dataset2.tables.add(dataset1.tables(tablename)) Please help me. prashant ...
Score Use data designers in non-visual component
Bomza - 25 Jan 2005 4:38 PM - 4 messages
Is there any way of using the ADO data wizards in a non-visual component?  If you create a "web service" project, you drag ADO components onto a designer and use wizards, but I can't work out how to ...
Score Create a parameter for the oledb data adapter
Chris - 25 Jan 2005 2:55 PM - 2 messages
Hello, Is it possible when configuring an OLEDB DataAdapter, using the Query Builder, to specify parameters? I've tried placing =@parametername in the criteria section of the Query Builder, but this seems to always gerenate errors and then the Datasets won't ...
Score Copying a table in ADO.net and the pesky identity column
Rippo - 25 Jan 2005 12:20 PM - 6 messages
I am finding problems in trying to copy a databse table from one SQL 2000 server to another using ADO.net. However the source table has an identity column and I need to preserve the values in the destination table. Obviously every time I run the below code the destination table ...
Score Multi DB. And now?
Max André Bündchen - 25 Jan 2005 10:54 AM - 2 messages
Hi all, That is a really bad, bad question, but some of us have problem with a application with more than one DB. Anyone here dev. the same app. for more than one DB? Why the best solution in the ADO.NET for that, thinking in time ...
Score Removing row pointed to by bound combo
Paul Aspinall - 25 Jan 2005 8:42 AM - 3 messages
Hi I have a combo which is bound to a datatable. I want to remove the record from the datatable, which the combo points to. Can anyone confirm the correct syntax.... I believe it will be something like datatable.Rows.Remove(.......??how do I find the row that is bound to the ...
Score Correct syntax for pasing a SELECtT statement in a string
Gordon - 25 Jan 2005 4:23 AM - 3 messages
What is the correct syntax for passing a select statement via the Reader. The following code doesn't return anything.        Dim strSQL2 As String = "SELECT *  from ATable  WHERE  ' " & ComboBox1.Text & " '  =  ' " & TextBox1.Text & " '" ...
Score MyGeneration for .NET (100% Free Code Generator / OR Mapper)
MyGeneration - 25 Jan 2005 3:17 AM - 2 messages
MyGeneration is 100% free, tired of hand coding business objects, stored procedures, spend your time wisely doing other thing and let us help you. See [link] 1) MyGeneration is a Template Based Code Generator Supporting Four Template ...
Score Web service on two tables
garyrob - 25 Jan 2005 3:01 AM - 4 messages
Please could anyone show me how to create a web service which accesses and updates information in two tables. I have seen examples in MSDN  based on one table but these fail when using the DataAdapter Config Wizard tries to join ...
Score Synchronize Question
slonocode - 25 Jan 2005 1:13 AM - 3 messages
I have a situation where I have read only access to an Access database.   I need to query the database and insert the rows retrieved into my own database.  However there is no gaurantee that the original query won't ...
Score OracleDataAdapter filling Dataset with duplicate rows
MS - 25 Jan 2005 12:43 AM - 5 messages
Hi, I am using OracleDataAdapter to fill my DataSet. I am using Select Distinct in my sql querry to get unique recored. I am getting duplicate rows in DataSet. My SqlPlus shows only one row of Data. When I execute the code to fill DataSet ...
Score Error: "System.Data.OleDb.OleDbException: No value given for one or more required parameters"
Brian Foree - 25 Jan 2005 12:32 AM - 4 messages
I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I don't think I made any changes ...
Score ORA-01461 while moving data from sqlserver to oracle
Jan van Veldhuizen - 24 Jan 2005 10:42 PM - 4 messages
I worte a conversion program which moves all data from SqlSrv to Oracle, using the OracleClient and SqlClient classes of .Net. Now when a column has 2001 characters or more I get this error. I've read a lot of it, but I do not fully understand what is wrong, and more important, ...
Score Good Practice on ListBox
Hemang Shah - 24 Jan 2005 10:31 PM - 5 messages
Greetings I want to display a listbox on the form which will include two columns from the data table" FirstName" & "LastName" What I've done now, is modify the DataAdapter to include two additional colums as: [FirstName] + " " +[LastName] As NameFN ...
Score How to save/update DataTable when its structure is unknown?
Uri - 24 Jan 2005 10:15 PM - 10 messages
Hi all, I would like to have a functionality that saves/updates a given DataTable into the DB while its structure is unknown. I think of 2 possible solutions: 1) to use SqlCommandBuilder - which is very expensive in the runtime ...
Score ADO.NET Oracle Varchar2 BUG?
plumeprog - 24 Jan 2005 7:19 PM - 3 messages
Hi, I have an Oracle 8.1.7 server and I'm extracting a Varchar2(length 300) using an aspx page and the field is always Null, even if it's not in the DB.  I tried the EXACT same code in a windows form and it works perfect. ...
Score sending mail through stored procedure
Patrick - 24 Jan 2005 7:12 PM - 2 messages
Hi Can anyone tell me how can I send email through stored procedure in sql server ? I want to send attachment with this email too. TIA ...
Score SQLDataReader and Columns
Roger Webb - 24 Jan 2005 6:33 PM - 2 messages
How would I get the length of a column from a SQLDataReader?  I'm looking for something like Query Analyzer uses to display its data.  So, I would need to know that a varchar(200) is 200 where a varchar(20) is only 20. ...
Score Execute File SQL in AdoNET VB
John Fred - 24 Jan 2005 6:09 PM - 3 messages
Hello, I have a file .SQL Containing a Script to Create Tables and Stored Procedure... Example : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_ADVANCED_SEARCH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_ADVANCED_SEARCH] GO ........ SET QUOTED_IDENTIFIER OFF ...
Score Passing OracleDateTime.null.value to store procedure???
Kevin Yu - 24 Jan 2005 6:07 PM - 3 messages
using Data access application block for oracle, I try to pass a null value to the OracleDateTime to the store procedure. but I got an exception saying "this value si null", what am I missing here? shouldn't I be able to pass ...
Score Re: Heeelpppp ORA-02041 error!!!!
Bill - 24 Jan 2005 5:57 PM - 2 messages
Lyndon Hills wrote: Dear All, I had the same issue ORA-02041 error.  I tried the above example and I did not have any success.  I was successful in getting this to work.  I reversed the Sql string and connected to the other database.  Please ...
Score Databinding in c# - Important
Hemang Shah - 24 Jan 2005 5:50 PM - 3 messages
Hello All the samples I found are based on datagrid for the child table. What if I don't want the child records to be displayed in a datagrid, but in their own data bound controls like "text box, combo & list boxes).  And I ...
Score edit memory DataTable
Petez - 24 Jan 2005 2:57 PM - 4 messages
Hi, I created simple dataTable (one field numeric, one string). Then I prepared dataConnector and put DataGridView on the form. In datagrid I can edit now numeric field but string field after post is clear (NULL value). Can anyone help? ...
Score edit string field in DataGridView
Petez - 24 Jan 2005 2:55 PM - 2 messages
Hi, I created simple DataTable (memory table) object with two fields -numeric Id -string Name then I configure dataConnection and put on the form DataGridView. I bind fields from table to columns and now I can edit numeric column but when I try edit string column then it is after post event clear (NULL ...
Score DataRow to XML
nashak - 24 Jan 2005 2:52 PM - 6 messages
Hello, I am creating a datarow (new or existing) in my data-tier and passing it to my business tier where it is filled with data and then passed back to data-tier to be inserted into the table. I need to keep original and updated versions of the datarow in xml ...
Score Lock Table
Geoff Murley - 24 Jan 2005 11:12 AM - 8 messages
In a SQL Server 2000 Database I have a Table which is shared by many users.  I have a VB.NET Procedure which contains many calls to Stored Procedures and ADO.Net Commands to clear and update this shared table.  What I ...
Score Current record of datatable in dataset
Paul Aspinall - 24 Jan 2005 10:51 AM - 2 messages
Hi I have a datatable which I have linked to a combo control, via the datasource property of the combo control. I have also set the displaymember property of the combo, to ensure that my description is shown in the combo. ...
Score Cant connect to SQL Server 2000 Developer edition
hemant - 24 Jan 2005 3:53 AM - 4 messages
Hi,    I have been trying to connect SQL Server2000 developer edition using the following string. SqlConnection conn = new SqlConnection("server=localhost;database=pubs;uid=sa;pwd="); I dont know where i am going wrong. SQL Server Service Manager shows the following: ...
Score duplicate ids after insert
toufik - 24 Jan 2005 12:19 AM - 5 messages
Hi, I'm trying to create an archiving script, using the folowing query for all database tables insert into table2 select * from table1 (table1, table2 are 2 tables having exactly the same definition) The rpoblem is that the rows are,'t deleted from the table TABLE2, so the ...
Score Timberline (Pervasive) ODBC Access
Robert Porter - 24 Jan 2005 12:18 AM - 2 messages
Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET. ...
Score CharIndex SQL
pierre hourdille via .NET 247 - 23 Jan 2005 5:38 PM - 2 messages
Hi alls I have a problem with a stored procedure : I use a CHARINDEX to filter a query and if I execute the query from sqlServer the charindex works fine but if I execute the query from my ASPNET application the charindex always return 0 (to test it I quit it from the Where to put it as a column). ...
Score Sharing an OLE DB connection between MDI Parent and Children
Peter Hawkins via .NET 247 - 23 Jan 2005 5:38 PM - 2 messages
G'day all, Being a fairly inexperienced programmer, I've never worked with MDI Forms before. What I'm trying to do is open a Jet OLE DB connection on my MDI Parent form (which is used to log in and out with user name and password), and access this same connection from the MDI Child forms to do other database related adding, updating and etc of records. ...
C# SQL SERVER LAST INSERT ID EXAMPLES
insert multiple rows using loop
ExecuteReader requires an open and available Connection. The connection's current state is Closed.
Fire query on DataSet
Can't get record to insert into Access
.Net master-detail interface
.Net Data Provider error help
newbee needs help with code
Help! Operation is not allowed in this context.
convert 2 XML files into a dataset
Next » 2 3 4 5 6 7 8 9 10