Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score No value given for one or more required parameters
André - 17 Jun 2006 8:24 PM - 4 messages
Hi, I created a button in order to delete all the records at once in a gridview. But i get the error: No value given for one or more required parameters Thanks André The aspx file contains: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="..." ...
Score BindingSource.Find causing problems
neil - 17 Jun 2006 9:32 AM - 1 message
Hi all I have an ADO problem when I call BindingSource.Find and the BindingSource.DataSource is set to a DataView. Here is some sample code to illustrate my problem             DataSet dataSet = new DataSet(); ...
Score Formview (EditView) Money Data Type Binding problem. Help....
Sam - 16 Jun 2006 11:32 PM - 1 message
Folks.. I am trying to use a Simple form with 3 fields from SQL NorthWind Database (Order Details Table with 3 Fields. - OrderId, ProductId and Unit Price). The Field Unit Price has a data type of 'Money Type'. All I want is to able to edit/view/insert 'UnitPrice' field with 2 ...
Score GridViewUpdateEventArgs.Keys is missed
ad - 16 Jun 2006 7:20 PM - 1 message
I have set "Years,GradeID" as DataKeyNames of a GridView.I use the codes below to get the Keys value of a GridView, it is ok. But if I sort this GridView on Pageload like:   gv.Sort("Years", SortDirection.Descending); ...
Score datagridview does not update in master detail relation
Dirk W - 16 Jun 2006 7:03 PM - 3 messages
I setup a simple database with a master and a detail table. Both are connected via a datarelation. Data of each table is shown in a datagridview (dgLektion and dgLektionlernkarten). When I start the app for the first time, everything works fine: all master rows are shown ...
Score Query Strings using Web Matrix
glenn - 16 Jun 2006 6:44 PM - 2 messages
Hi folks, I have two tables in one database. One table has an automatic numbering primary key named ID and is named rfi. The other table has a field named rfinumber and is named discussion. Both ID and rfinumber have a datatype of number. ...
Score Unable to update gridview
Terence - 16 Jun 2006 6:39 PM - 2 messages
Hi, I have a web user control which includes a gridview and a sqldatasource. It also has a property called TableName which is used to populate the gridview. However, i'm running into a problem where i can select and delete row but i ...
Score Best practices for using Connections in connected environment?
Michael Russell - 16 Jun 2006 6:22 PM - 4 messages
Hi all, I'd be interested in hearing opinions for best practices regarding handling data connection in a connected (desktop client/server) application environment.  I'm working with the assumption that the database (driver/component/etc.) supports pooling.  I'm currently ...
Score Can't get DataView to sort correctly.
tshad - 16 Jun 2006 4:23 PM - 4 messages
I do a select into a Dataset, apply a DataView to it and then sort it.  But the sort is not correct.  I am sorting it by the UserName and it is not in alpha order when I bind it to my datagrid. ...
Score Count Of items, Count of Items Passed and percentage passed
Jay Balapa - 16 Jun 2006 3:55 PM - 5 messages
Hello, Underlying table has the following fields and values Barcode   Item    Pass 1000        x         YES 1001        x         YES ...
Score Pass an array to an Oracle stored procedure using Microsoft's client for Oracle
michelle.m.talt - 16 Jun 2006 3:34 PM - 1 message
Hi, Does anyone know how to use an array as a parameter for a stored procedure using Microsoft's client for Oracle? I know that Oracle's client for .net has property you can set to declare it as an array: ...
Score Reading image columns from SQL Server
ipramod - 16 Jun 2006 12:17 PM - 1 message
Hi, I am having a SQL Server table which has the following column value and the column datatype is image. 0xFFFFFFFF020000001901000009000000DD0000001E0000000000000046000000240032003100200024003A0020002000240032003200200024003A0020002000240032003300200024002000760061006C007500650020003D002000240032003500200024002A000000240032003100200024003A00200020002400320032 How can I convert the above image data into string? This is just a sample data I found in ProcessRule table of MOM 2005 OnePoint database. ...
Score Connecting through a proxy
keeper - 16 Jun 2006 11:50 AM - 2 messages
I have a client application that I want to connect to an Sql Server but the client machine is behind a proxy. I've been told that the application has to connect to the proxy with a username/password on port 8080, but is this even possible for an ...
Score How to specify the sort field in Gridview
ad - 16 Jun 2006 11:37 AM - 3 messages
How can we specify the data in a gridview to be sorted by a spcified column? ...
Score datagridview is not updating in master-detail relation
Dirk W - 16 Jun 2006 10:25 AM - 1 message
I setup a simple database with a master and a detail table. Both are connected via a datarelation. Data of each table is shown in a datagridview (dgLektion and dgLektionlernkarten). When I start the app for the first time, everything works fine: all master rows are shown ...
Score expression in data column and Type GUID
Dirk W - 16 Jun 2006 9:59 AM - 2 messages
in my app I have two tables, which are connected with a datarelation. Now I want to include a new datacolumn in the master table with an expression that shows the number of rows in the detail table. My idea ...
Score Strange problem while inserting row into table.
trialproduct2004 - 16 Jun 2006 7:17 AM - 3 messages
Hi all, I am facing one problem while inserting data into table through windows application. I am having one table in sql server containing one field for which i set default value as 'getdate()' while designing that table only. So when i add reords to that table through sql query analyser no need ...
Score Mysterious problem
leodippolito - 16 Jun 2006 4:49 AM - 5 messages
I have these tables: Questions    - id (PK)    - description    - status Replies    - id (PK)    - status    - idQuestion (FK) I am trying to run this query within an ASP.NET application (OleDB): ...
Score DbDataAdapter and RowUpdated event
Michael Russell - 16 Jun 2006 2:02 AM - 2 messages
I'm working on a small app that will talk to different databases, and so far it's been working great using a generic database factory model. However, I've run into a situation where I need to be catching some ...
Score Connecting to SQL Server 2005 on a server in a workgroup
BobRoyAce - 16 Jun 2006 12:49 AM - 5 messages
I have a bunch of lcient PCs that are primarily running Windows XP and Windows 2003 and they all belong to the same workgroup. In addition, I have a server PC that is running SQL Server 2005 and it also belongs to ...
Score Argument out of range ..really?
Earl - 15 Jun 2006 9:58 PM - 5 messages
This is a replicated database from SQL2k to SQLCE. I'm getting an ArgumentOutOfRange exception when I try to add this parameter (all other params are ok):     pc.Add(New SqlCeParameter("Age", SqlDbType.VarChar, 3, "Age")) In the main database, this is indeed the column name, datatype and length. ...
Score Microsoft Jet 4.0 Engine can't work properly
Goh - 15 Jun 2006 7:12 PM - 5 messages
Hi,     Recently I has try to install some of my software in a PC. and my software are actually using microsoft MSADO objects. The problem come when I try to run this software in this pc. The computer throw an error said that ...
Score DataBinding across multiple form
Goh - 15 Jun 2006 7:04 PM - 3 messages
Hi,     let said my form1 got a dataset and datasource my form1 got some textbox is binding with the dataset currently.    If I got another form2 can I bind form2 textbox from form1? And after I bind I evetually need to update back what ever changes in form2 ...
Score Share Dataset across multiple windows form
Goh - 15 Jun 2006 7:00 PM - 3 messages
Hi,         Got question every time windows from is load database, are dataset is isolated with others form? if this is true then it mike take up allot of memory space.         Can we actually share the same dataset across multiple windows form ...
Score updating dataset when original data adapter has been disposed of.
smHaig - 15 Jun 2006 6:37 PM - 3 messages
Hello: I have a separate module that creates my dataset and passes it back to my form. I am using vb.net 2003 with ado.net and sql server 2000.  The dataadpator that creates the dataset using a stored procedure is disposed ...
Score Simple DataReader to Business Object
J055 - 15 Jun 2006 12:23 PM - 3 messages
Hello I normally use DataTables to retrieve data but I thought I should probably be using DataReaders to populate a Business Entity Object with a single record at my DAL. I'm struggling to find some good examples on the subject. ...
Score ADO .NET 1.1 SqlClient and Sql Server 2000
Edward Diener - 15 Jun 2006 12:10 PM - 5 messages
Can I access an Sql Server 2000 database with ADO .NET 1.1 and the SqlClient classes. The doc mentions Sql Server 7 and I want to make sure the driver also works with Sql Server 2000. ...
Score Cannot load schema to dataset
Petri - 15 Jun 2006 11:28 AM - 6 messages
Hi, I'm trying to read an XML schema into a dataset and it fails. I tried both ways, importing it into VS.NET and then generating dataset there, or using dataset.readxmlschema("Filename.xsd") method. Both complain about the same ...
Score How can I update a datatable?
Arne Garvander - 15 Jun 2006 10:14 AM - 16 messages
One the columns in my gridview needs to be computed. I am not able to get my computed value to stick. DataTable orders; getSqlData(orders); for (i = 0; i < orders.Rows.Count; i++) {      orders.Rows[i][8] = i * 8; ...
Score code query
Adrian - 15 Jun 2006 9:45 AM - 2 messages
Q: In the code below: how do I give the key a value? new_data["key"] = whatever; gives the error column not found. Many thanks, Adrian. private void Form1_Load(object sender, System.EventArgs e) { string connect = "server = fred\\sqlexpress; database = TrialDB; Integrated ...
Score sudden problem with new datarow positioning
newbie via DotNetMonster.com - 15 Jun 2006 9:43 AM - 1 message
hi. ive been using a certain code for updating information from the windows form to an Access database , and it was handling the addition of new information properly until this week. now suddenly the dataset seems to be reordering the ...
Score How can you reset the odbcparamter string
Mike - 14 Jun 2006 10:20 PM - 1 message
If I have a read loop and I am reading from a file, then I set the odbcparameter values to whats in the input. How do you reset the odbcparameter so that you can continue to use it? Here is my program. I read a disk file that I use to add records to a ...
Score table row count not updated in "while" loop?
Martin.McDonald - 14 Jun 2006 8:45 PM - 4 messages
while (MyModel.MyTable.Rows.Count > 0) {      MyModel.MyTable[0].Delete(); } This will execute indefinitely.  One must add "AcceptChanges" after the delete to fix it. Is this a bug or is it by ADO.Net design? ...
Score Computed value in a Gridview
Arne Garvander - 14 Jun 2006 8:22 PM - 3 messages
One the columns in my gridview needs to be computed. I am not able to get my computed value to stick. DataTable orders; getSqlData(orders); for (i = 0; i < orders.Rows.Count; i++) {      orders.Rows[i][8] = i * 8; ...
Score AcceptChanges doesn't do anything !
Arne Garvander - 14 Jun 2006 7:16 PM - 7 messages
DataTable orders; getSqlData(orders); for (i = 0; i < orders.Rows.Count; i++) {      orders.Rows[i][8] = 800; } orders.AcceptChanges(); ExcelView.DataSource = orders; ExcelView.DataBind();  How can I get a gridview control to accept my changes? ...
Score ADO.NET Timout
Lit - 14 Jun 2006 6:53 PM - 10 messages
Hello, The default ADO.NET Timeout is 30 seconds. If I execute a Stored procedure that takes lets say 120 seconds then what happens. ADO.NET Times and throws an exception But what about SQL Server Does SQL Server keep on Executing the Stored ...
Score Edit a datatable
Arne Garvander - 14 Jun 2006 6:39 PM - 10 messages
How do I edit or reformat a DataTable? DataTable orders; getSqlData(orders); for (i = 0; i < orders.Rows.Count; i++) {        orders.Rows[i].BeginEdit();        orders.Rows[i][8]=  800 ; ...
Score DataTable Edits
Arne Garvander - 14 Jun 2006 5:46 PM - 5 messages
How do I edit or reformat a DataTable? DataTable orders; getSqlData(orders); for (int i;i<orders.row.count;i++) {       orders.row[i].ItemArray[0] = "Some special edits"; } orders.AcceptChanges(); The code above doesn't do anything! ...
Score error when trying to add data connection
BJ - 14 Jun 2006 2:47 PM - 4 messages
I want to add data connection on access database and every time I'm getting the same error: "format of the initialization string does not conform to specification starting at index 0" I'm using  Microsoft Access Database File (OLE DB) with this connection ...
Score SetDataSource Not Being Used Correctly
Chris - 14 Jun 2006 12:27 PM - 1 message
I am trying to implement some one else's idea! Does anyone know how to correct his syntactical error? Could you post the corrected code? When I modified the code in my application, VB complains immediately about the syntax by underlining the "SetDataSource" message line. In ...
Score Undefined function 'InStrRev' in expression.
alanwo - 14 Jun 2006 12:09 PM - 8 messages
Hi Experts, Connected to Access MDB file using ADO.net OLEDB, I have a SQL to get file extension from file name which is stored as field. SELECT Right(FileName, Len(FileName) - InStrRev(FileName, '.')) FROM Files This query work in MS ACCESS enivronment but not VB.net program ...
Score Handling a Concurrency Exception
W. Dengler - 14 Jun 2006 9:14 AM - 3 messages
hi in the Walkthrough: Handling a Concurrency Exception example seems to be an error. because of my actual knowlage, i cannot solve the problem the expression custRow.Item does not exist! private string GetRowData(NorthwindDataSet.CustomersRow custRow, DataRowVersion RowVersion) {     string rowData = ""; ...
Score How can I call an Oracle store procedure who has a paremter which is a table type?
Si Jingnan - 14 Jun 2006 7:01 AM - 5 messages
As the subject. Thanks Jingnan Si ...
Score Web Success
dave - 14 Jun 2006 2:28 AM - 1 message
...
Score making a datarow repeat
hero281 - 13 Jun 2006 8:24 PM - 2 messages
i have created a sql database with a vb.net front end. i have records that databse that have dates attached. i want each record to repeat in a given time frame according to a field in the datarow. is it possible. ...
Score Dataset with master and multiple nested tables in DotNet 2.0 WinFo
DEWright_CA@online.nospam - 13 Jun 2006 8:21 PM - 3 messages
I am having a really hard time understanding how to make this work. I have a datasource/tableadapter/bindingsource setup to talk to a dataset. This dataset and 1 main table and 3 subtables. 2 subs have a many-one relation ...
Score Locale and OLEDB problem
James Minns - 13 Jun 2006 7:16 PM - 3 messages
Hi all, I wonder if you can help with the following problem - it seems that the "Locale Identifier" parameter in my connection string is completely ignored; I've written a program of a few lines which duplicates the problem. db1.mdb contains 1 table with 2 fields: ...
Score Alternative to Dataset??
amarjeetlokhande - 13 Jun 2006 4:04 PM - 3 messages
Hi, I am part of a team building a stock exchange software  - Order Management system'. The current system that we have supports 200,000 orders per day. All of this data is needed in memory.Ofc ourse this system was built in ...
Score IDataParameter - output parameter returns weird results
Doug - 13 Jun 2006 3:50 PM - 4 messages
Hi, I'm trying to use a method like so to get values from within an IDataParameter collection: protected System.Object GetParameterValue(IDataParameterCollection parameterCollection, System.String parameterName) {   System.Object returnValue = null;   foreach(IDataParameter paramMember in parameterCollection)   {     if(paramMember.ParameterName.Equals(parameterName)) ...
Score DataAdapters and Auto IDs
robin9876 - 13 Jun 2006 3:09 PM - 5 messages
In asp.net v1.1 I have created a data adapter which has stored procedures for inserting data which also refreshes the data after the insert. How can you get the value of the auto increment field after the accept ...
Score DataGridView Master-Detail (Parent-Child)
Mark Tompkins - 13 Jun 2006 2:50 PM - 3 messages
Gents - I have a DataSet with a Parent / Child relation. On Form1 I have a DGV that is bound to the details (child) portion of the relation (tblInventoryTransBindingSource). I have a BindingNavigator bound to the Parent binding source (tblPurchaseOrdersBindingSource). On the form I also have a DateTimePicker for date control bound to tblPurchaseOrdersBindingSource ...
Score Reserved Words
restucci - 13 Jun 2006 1:31 PM - 4 messages
I am attempting to update/insert to a Microsoft Access Database. I have a database column that is unfortunately using a the reserved word 'output'. Changing this name isn't a very viable option (at least not now). My problem is that I cannot get the database to update using .net ...
Score DAO with Excel, QueryInterface failed...
Tim_Mac - 13 Jun 2006 12:31 PM - 3 messages
hi, i need to use DAO to read the correct order of worksheets in an excel file.  ADOX uses the original ordering and disregards any worksheet shuffling that the user may have done.  I need the order as it appears ...
Score DataTable.Select Method bug?
Adrian - 13 Jun 2006 9:51 AM - 4 messages
Hi all ..Net Framework 1.1 vb.net We use the Select-Method of the DataTable class to retriev data. The select statement is as follows: myDeDT.Select("Pers_Name = 'Adrian '") Please look exactly at the content of the parameter! There is a space at the ...
Score Timeout expired
martin_link75 - 13 Jun 2006 9:45 AM - 2 messages
I have a problem that seems to occur at random. I am running a .Net windows application on a Windows 2000 machine which connects to a MS SQL Server 2000 on a Windows 2003 Server. The application is running just fine but every two months or so I start ...
Score How to generate "plain" SQL with OleDb or Odbc providers, in db in
Matej Kovacic - 13 Jun 2006 7:58 AM - 2 messages
How to generate "plain" SQL with OleDb or Odbc providers, in database independent sintax ? ---- In VS2005 all generated SQLs in new dataset designer are database dependent, even if we use OleDb provider, for example, if we prepare TableAdapter over Microsoft.Jet.OLEDB.4.0 ...
Score Filter Master Table based on Child Criteria
Rick - 13 Jun 2006 2:36 AM - 4 messages
I posted a previous message similar to this, but I think that the presentation wasn't complete. Thanks to all who tried to decypher the mess. Hopefully this message will be more understandable. I have a need to Filter a master DataView (easily) through a ...
Score Retrieving multiple datatables from a tableadapter insert query
Stephen - 13 Jun 2006 12:08 AM - 3 messages
Hello, I have in my database a trigger on a particular table that writes entries to an audit table upon inserts & updates, and returns a set of AuditId's. When I insert into this table, I need to retrieve both the set of AuditId's ...
Score DataTable Fill from two Source Tables does it Append ?
mosscliffe - 12 Jun 2006 10:03 PM - 3 messages
I have two tables containing similar data but from different sources. I would normally use a UNION statement to create my SELECT statement, but because I have Access Memo fields, these get truncated at 255 characters, if I use Union.  This was a nightmare to discover why it ...
Score Typed DataSet Navigation (Multiple Tables)
rryerson - 12 Jun 2006 8:53 PM - 8 messages
I don't know if my terminology is correct so please bear with me. I have a Typed DataSet that contains a number of related Tables. I am trying to filter the parent table, child table and then traverse a ...
Score connectionstring problem
Fanor - 12 Jun 2006 8:38 PM - 6 messages
HI all, I have in my settings a connection string. When I run in debug mode the connection string is pointing to myproj\bin\debug\mydbase.mdb however  mydbase.mdb is in  myproj\ From the dsigner i can view the tables, wich means the connection is ok. But ...
Score creating an vb.net exe
Beski - 12 Jun 2006 4:41 PM - 2 messages
I have created a vb.net program that incorporates a SQL Sever Database. In my program I have the line: con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = database.mdb" So I used the vb.net publish project tool and made an installation ...
Score DataSet Split Data
TCB - 12 Jun 2006 4:24 PM - 3 messages
Hi, I have a dataset with 12 records selected from a Database (Top 12) I need to bind a DataList to the first 6 records and another DataList to the last 6 records. How can I split this datadet in two or accomplish this? copy each ...
Score What dataadapter should I use with an Access Database?
clusardi2k - 12 Jun 2006 3:53 PM - 3 messages
What dataadapter should I use and can I use something such as DataDirectory in the connection string? Can you give me an example? Thanks, Christopher Lusardi ...
Score Help calling a stored procedure
Mike - 12 Jun 2006 3:08 PM - 6 messages
Hello all, I need a little help. I'm calling a stored procedure from my vb.net prog and I keep getting an error. Could someone look at my code and help me out a little. Thanks in advance. I need to use odbc because of ...
Score Date time format trouble
serge calderara - 12 Jun 2006 1:22 PM - 2 messages
Dear all, I have a windows application which collect data from an SQL server database. part of those data are store in a dataset and then written to an XML file. In that dataset I have a date/Time field format as "dd/mm/yyyy hh:mm:ss" ...
Score After delete Trigger on Transaction
sandi - 12 Jun 2006 12:04 PM - 1 message
Please Advise ..After delete Trigger on Transaction I have 3 table 1.    JournalParent     1.    counter    int        (used for relation to journalDetail) ...
Score Web Service and Client
zchrs - 12 Jun 2006 11:26 AM - 3 messages
Introduction (as short and concise as possible!) - My colleague and I are new to ADO DotNet. We have as a reference the excellent Microsoft book by David Sceppa. Dev. environment is Delphi 2006 (not very important in this context as far as I can see). We are developing a Web ...
Score DataAdapetr Update
Baren - 12 Jun 2006 7:31 AM - 2 messages
Hi! I have text file with tabbed columns, I am getting those values into a dataset by parsing the tab. I want to save the same dataset into a table in a database. I am getting error "Update requires a valid InsertCommand when ...
Score RE: ORA-01036: illegal variable name/number
lakshmi - 12 Jun 2006 7:13 AM - 1 message
hi,   i am also working on the .net. I also got the same problem while inserting the values into the database. If any overcome this plz reply me as early as possible. From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Cannot add record for child table that have relationship with master table.
Goh - 12 Jun 2006 5:38 AM - 3 messages
Got a question examples the senario is like that. if we got master and detail table. detail table have a relationship with th master table with a primary key. primary key is an auto number. from my testing if master table show in "detail view" and detail table show ...
Score Executing a stored procedure...
BobRoyAce - 11 Jun 2006 9:36 PM - 6 messages
I have stored procedures with parameters in a SQL Server 2005 DB and want to execute them (primarily to update, delete, and insert records to tables). Could someone please provide simple code to do this. I found sample code using something called SqlHelper, but SqlHelper ...
Score Can return typed DataTable with VS2005
ad - 11 Jun 2006 9:24 PM - 1 message
It can not return DataTable with WebMethod, only  only return dataset in VS2003. Can the WebMethod return typed DataTable in VS2005? ...
Score Strongly typed dataset and transactions
James Minns - 11 Jun 2006 8:56 PM - 14 messages
Hi all, I am using VB.NET (2005) to write to an Access database, with oledb. I have created strongly typed datasets in an xsd file to read from and update several tables in the database. I would like to use a transaction so that in case the update of one table ...
Score Binding to variable
Goh - 11 Jun 2006 7:31 PM - 3 messages
dear all,     I have learn context binding in the pass. I search the internet to find some way for me to bind my dataset to my local variable. It also mean that when I navigate the record the value of that variable should change ...
Score Need help with BindingNavigator
Michael Russell - 11 Jun 2006 6:02 PM - 6 messages
Hi, I'm looking for a simple way to scroll through records, and a BindingNavigator seemed to be it.  However, I can't seem to get it to work.  I can see in an output window that I'm retrieving the correct ...
Score How to insert ?
ad - 11 Jun 2006 12:26 PM - 5 messages
I want to insert about 10000 records into database. I don't know if the records existed in the database at first. There are to methods to achieve it. 1. Use select to test if primary key of a record existed in the database, if ...
Next »