Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score How to serialize a string
xyz - 9 Jul 2005 6:07 PM - 3 messages
Hi I need to serialize a string and put it into database table that has 2 columns. First is filename (name.txt) and the second is an image type that contain file. Thanks ...
Score How to contine inserting the rest record when a duplicate occur
ad - 9 Jul 2005 8:02 AM - 4 messages
I use a loop to insert about 12 record into table: Mybe there are already some records exist in the table, When the duplicate primary key exception thow, my program will show an error page and the loop terminate. I hope that when an duplicate primary key exception thow, my application ...
Score How a commit a loop of inserting
ad - 8 Jul 2005 10:01 PM - 3 messages
I use loop to insert 12 record into a table: But the for_Loop only loop once and throw an error: [System.Data.SqlClient.SqlException] = {"The variable name '@PID' has already been declared. Variable names must be unique within a query batch or ...
Score System.Data.SqlClient.SqlException: SQL Server does not exist or a
guru - 8 Jul 2005 9:04 PM - 12 messages
I am getting this error when I try to open database connection. SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Persist Security Info=False;User ID=ABC;Pwd=XYZ;Initial Catalog=MYDB;Data Source=MYSQLSERVER"; conn.Open(); This is happening on my local machin, when I tryed same code on my collges ...
Score Updating Dataset with Identity column
Nick Chakarov - 8 Jul 2005 8:33 PM - 4 messages
Hi everybody, I have a problem updating typed dataset with identity columns in it.The dataset contains parent-children tables and the updates must happen in order 1. update deleted records in children 2. Update modified-added records in parent, children ...
Score Getting COM components running in ASP.NET to connect to SQL Server databases
Oenone - 8 Jul 2005 3:49 PM - 8 messages
Sorry for the cross-post but I've really no idea where this is best suited. I've an ADO.NET application which connects to a SQL Server database. I have spent the entire morning trying to get it to connect, but eventually got it ...
Score Component that helps generating sql code
Peter Laan - 8 Jul 2005 3:02 PM - 2 messages
I've been spending a few hours writing a component that helps generate simple sql queries. But if I can come up with the idea, it's probably stupid or someone has already done it. So does anyone know of a component that does ...
Score Image.FromStream - Invalid Parameter Used
Tom John <> - 8 Jul 2005 8:43 AM - 10 messages
Hi I am storing images in an access database, based on an MSDN article. The code i use to store is as follows: <code> 'Create the command object Dim command As New OleDbCommand("ImageBlobUpdate", dataConnection) Command.CommandType = CommandType.StoredProcedure) ...
Score checking if recordset comes up empty ADODB/VB6
pb - 8 Jul 2005 7:20 AM - 3 messages
i want to run a procedure if a recordset comes up empty....what is the correct syntax? Do While Not rstRecordSet.EOF If rstRecordSet("ID") = Empty Then MsgBox stempGlobal, vbCritical, "record not found" 'run procedure Else MsgBox rstRecordSet("PT_ID"), vbCritical, "record Found" ...
Score Connection Timeout
sam - 8 Jul 2005 5:24 AM - 5 messages
When I use ASP.Net via ADO.Net to retrieve data from MS SQL Server 2000, it is always prompt error message "Timeout" if the number record is larger than 1 million. May I know what is the best practise for pool large records for my case, ...
Score View SQL Server Tables in ASP.net/ADO.net
Allison Thomas - 7 Jul 2005 11:14 PM - 3 messages
I am trying to list the tables in a SQL Server database on an ASP.net page but can't seem to find out how to do it. The old ADOX did it for Access data bases and I presume SQL Server but this seems like taking a step backward. ...
Score Pros/Cons of using sqltransaction class vs sql server stored proce
Mike Moore - 7 Jul 2005 9:50 PM - 3 messages
Can anyone provide suggestions/recommendations of using either the sqltransaction class for ado.net or a sql server stored procedure.  we need to using begin and end transactions to update mulitple tables? asp.net app with sql server 2000 database ...
Score Connection pooling
Arne - 7 Jul 2005 8:33 PM - 2 messages
I have one SQL account that is used by 100 simultaneous users at my website. Let's say one user starts a long running query. I get another sql request before the first sql statement finishes. Does that mean I have to open or use ...
Score setting options to work with indexed view
Zeng - 7 Jul 2005 5:11 PM - 4 messages
Hello, I'm starting to use indexed view for the first time with Standard Edition and I ran into failure of updating base tables that involved in the indexed view. I found out what the problem is, basically all my update code ...
Score Dispose table
wansch - 7 Jul 2005 3:49 PM - 3 messages
Hi, i read in newsgroups and hints, that everthing wich has a dispose() method should be disposed. Is this true for tables and columns both have a dispose() method. Thanks for reply wansch ...
Score Are there escape characters for SQL?
basulasz - 7 Jul 2005 3:04 PM - 2 messages
I think it is a very simple question, but i don't know the answer. I am developing a web site in C# and ASP.NET . If an entry like "Here is Sam's Pub" is entered into a Textbox exception occurs. Since " ' " character causes ...
Score Update using OleDbDataAdapter and DataSet
pagates - 7 Jul 2005 2:49 PM - 2 messages
I am having difficulty getting an Update (MS Access) to work correctly using a OleDbDataAdapter, DataSet, and parameters. I add the parameters, and must have a default value for the values I want to SET in the update (I use the current time, so I can see any changes).  I then ...
Score System.Data.NoNullAllowedException
nbohana - 7 Jul 2005 3:59 AM - 4 messages
I am using sql server, Visual Studio .NET and C#. My application uses windows forms. The form that I am having a problem with has some text boxes and a data grid. There are two sql tables (i.e task and task-details) each table ...
Score Joining table or using a view
Mike Moore - 7 Jul 2005 12:01 AM - 3 messages
I have a situation where I need to join numerous tables in order to display data to the user. The user will be allowed to update the information. I am creating my data adapter and dataset in Visual Studio. However, Visual ...
Score update problem
Stephen Martinelli - 6 Jul 2005 10:57 PM - 4 messages
Hello... Im cross posting this ...sorry but I'm stuck... Im trying to update a access table called xUpdate with another table called temp. Both table live in the same database. I want to update the field xUpdate.status with a field in temp called temp.newStatus. I thought the ...
Score Using LIKE to perform a database match
Nathan Sokalski - 6 Jul 2005 10:16 PM - 10 messages
I am trying to do a database search using LIKE using the following code: Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click If Page.IsValid Then Dim logictype As String Dim keywords As String() ...
Score Update Dataset Not working
GarrettD78 - 6 Jul 2005 3:50 PM - 3 messages
I have a typed dataset that is display in a form with parent data in text boxes and the child table in a componentone flexgrid. To add a row to the child table I open a form with text boxes and then return each piece of ...
Score Persist Security Info = True in connection string
Greg Robinson - 6 Jul 2005 3:39 PM - 5 messages
Sql Server connection string, Persist Security Info = True\False Per the docs I find: "When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open ...
Score General Network Error - LocalHost
JL - 6 Jul 2005 3:03 PM - 5 messages
We have a Winforms app running on XP against a local installation of MSDE. The machine is connected to a network.  When we pull the network cable out we get General Network Error from SQL Server even though we are connected to ...
Score What first? Merge or acceptchanges?
Roland_Müller - 6 Jul 2005 3:02 PM - 2 messages
Hi, we have a client-server-application. On the client we add, delete things to/from a dataset then we save it via webservice; after that the dataset on the client must be updated. We do this with - DataSet.Merge (to get new Ids for example) ...
Score SQL statement with multiple WHERE statements
thomasp - 6 Jul 2005 1:37 PM - 3 messages
I have a MS Access table with the fields, ID, ATime, and ADate and I want to select records between a certain date and time. Will someone show me the proper syntax for the SQL statement.  I need to construct the sql statement ...
Score Difference between a datatable and dataview
DOTNETGUY - 6 Jul 2005 1:16 PM - 3 messages
What are the main differences between a dataTable and dataView? Does one perform better than the other? ...
Score really daring subject! DataGrid MyBase.OnPaint -> content
DraguVaso - 6 Jul 2005 11:34 AM - 9 messages
Hi, I want to override the MyBase.OnPaint(ByVal pe As System.Windows.Forms.PaintEventArgs) of the DataGrid, to have some custom property's designed (other column headers etc). The problem is that I don't know the content of the original MyBase.OnPaint, ...
Score Question regarding OOP and database access
leodippolito - 6 Jul 2005 11:10 AM - 3 messages
Hello sirs! Suppose I have these objects (and their attributes): Car - string carName - Wheel aWheel Truck - string truckName - Wheel aWheel Wheel - string wheelColor - bool hasAHonk (as I lack imagination for a better example, let's assume that the car and the truck use the same kind of wheel). ...
Score Q:Multithreaded ADO.Net Connections Are Non Pooled?
Marauderz - 5 Jul 2005 5:54 PM - 12 messages
Hi guys, have a little weird scenario here. I have a windows Service that's serving requets using multiple threads created by the .Net threadpool. Within each thread they will create their own Connection object and go off and do their thing, an insert, a Select and ...
Score Problems with connection pool for DB2400
jabailo@texeme.com - 5 Jul 2005 5:42 PM - 2 messages
Platform: W2K IIS 5.0 ..NET 1.1 ADO.NET managed DB2 provider for iSeries I wrote a web service which allows me to post records to the as/400 Occasionally there seem to be errors such as "Communication Problem". ...
Score close SqlDataReader
Ruslan - 5 Jul 2005 5:15 PM - 2 messages
Hi, I have the following code: using (SqlConnection connection = DBConnector.GetConnection()) { SqlCommand cm = new SqlCommand();       SqlDataReader dr = new SqlDataReader (cm.ExecuteReader());       while (dr.Read())       {             ... ...
Score rowfilter not working correctly
Benjamin - 5 Jul 2005 4:44 PM - 5 messages
We are using a rowfilter on our dataview and are not getting the expected results.  Our filter is as follows: "CLIENT_ID='T1000' AND NOT (RES_RATE=0  AND BP_SIT_SYS=0  AND BP_SIT_DIA=0  AND PULSE_API=0  AND TEMPERATUR=0  AND WEIGHT_NUT=0)" ...
Score ADO.NET in classic ASP?
jason - 5 Jul 2005 4:39 PM - 3 messages
can ADO.NET be used in classic ASP? that is to say: is it made available through COM Interop, or would i have to wrap ADO.NET objects in a COM Interop class library myself? if ADO.NET objects are available in COM already, what is the namespace ...
Score null value of parameters when update by DataAdapter
p:D - 5 Jul 2005 4:35 PM - 2 messages
I have a parent with a DataSet and a child form that have few tables, after I change the data in the tables and then "Merge" the tables into the parent DataSet. I found that all values in the DataAdapter were null when update to ...
Score Update ado.net DataSet
skyjoker1 - 5 Jul 2005 3:31 PM - 9 messages
I think what I'm trying to do is something relatively simple.  I have created a DataTable using the SQLDataAdapter.Fill method: Dim da As New SqlDataAdapter("SELECT * FROM Trans", cn) Dim ds As New DataSet da.Fill(ds, "AllTrans") ...
Score Creating a temporary table in a SqlCommand with Parameters fails
Mark Rendle - 5 Jul 2005 3:21 PM - 2 messages
For some reason, if I create a temporary table in a SqlCommand which has parameters, it doesn't get created properly, although no exception  is thrown and ExecuteNonQuery returns the correct number of rows. So cmd.CommandText = "create table #temp (col int); insert into #temp values ...
Score NTAUTHORITY\NET SERVICE not authorized
ChuckD_Duncan - 5 Jul 2005 1:40 PM - 9 messages
(Platform: 2003 or XP, IIS) From a Web Service, I have a sqlConnection with a correct (tested) connection string.  When I try to       myConn.Open();  it fails with NTAUTHORITY\NET SERVICE not authorized... meaning it seems ...
Score Dataset refresh single column
Arapi - 5 Jul 2005 12:43 PM - 3 messages
Hi, I am upgrading a vb6 app to .net.   My app works this way: on the form_load event I populate a dataset with all existing products (over 25,000) and their quantities on the database.   Having in mind that many people (many ...
Score referential integrity
simo71 - 5 Jul 2005 10:26 AM - 11 messages
I'm trying to create a form to maintain 2 MS Access RELATED tables 'Parent' and 'Child'. I use 2 datagrids that are binded to 2 datatables. I've created 2 dataadapters and filled the datasets. I try to modify in the ...
Score How to filter a Dataset and save it into Xml ?
Patrice Dargenton - 5 Jul 2005 9:40 AM - 3 messages
Hello, I can save my DataSet into Xml using ds.WriteXml(strXmlPath). Now I would like to filter it like I can do using DataView.RowFilter into another Xml file, but I don't know how to do it, because It always contains ...
Score sqlDataAdapters/
nbohana - 4 Jul 2005 7:54 PM - 6 messages
I am using sql server, and in my database there two tables. One of the tables is the primary (tasks) and the other is secondary (Detail).  The primary keys in both tables is "services-order-number".  The 'Detail table' also has ...
Score Intellisense
rbutch@coair.com - 4 Jul 2005 6:27 PM - 4 messages
hey guys quick question. all of a sudden my intellisense feature in Visual Studio seemed to stop functioning. could there have possibly been something i inadvertantly Clicked to Stop this? i mean i can type Dim foo as st....................and usually the list comes up with the choices. ...
Score The best online ADO resource
worzel - 4 Jul 2005 1:24 PM - 7 messages
Aside from MS site, which is the best site for ADO on the web? Actually, which is considered th ebest (biggest) for dot net in general? ...
Score CurrencyManager.addnew
Donald - 4 Jul 2005 1:08 PM - 2 messages
when I use the cm.addnew method to add datarow, I know the editing can be completed with bindingcontrol, such as textbox, if i have some columns which I have not bind it on winform, how to edit them with coding? I cannot find ...
Score executenonquery - insert works only in debug mode
ADF - 4 Jul 2005 9:06 AM - 4 messages
I have wrote this code: ----------------------------------------------------------------------------- Dim cnsql As New SqlClient.SqlConnection cnsql.ConnectionString = "Data Source=ced2; User ID=sa; Password=;Initial Catalog=NGN;Persist Security Info=True;" Dim cmdsql1 As New SqlClient.SqlCommand Dim i As Integer Dim j As Integer ...
Score Need OLEDB Connect String Example for Sybase
Mori - 4 Jul 2005 1:11 AM - 3 messages
I need to use OLEDB Provider to access Sybase.  I am having problems with the ASE provider and prefer OLEDB. Question:  What do I need to implement that?  Any clients to install? A working example would be appreciated. ...
Score Cast from string to type integer
Bob - 3 Jul 2005 11:58 PM - 10 messages
Hello: This has been driving me nuts. Everything I do gives the same error.  The bigger issue here is that it doesn't give me a clue where the error is rising. The debugger is blank. Thanks Bob ...
Score Emergency: Unicode Characters in a Dataset.
Mohammad-Reza - 3 Jul 2005 3:01 PM - 8 messages
We are writing an application for a specific culture(Arabic or Farsi). This application involves using DataAdapter, OLEDB Connection and the DataSet. We didn't use the .NET data binding, just field TextBoxes with the data retrieved from the DataSet but whole system seems to be unable to update the ...
Next » 2 3 4 5 6 7 8 9 10