command to auto generate data adapters sel,upd,and delete commands?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Output parameter not fed I'm trying to call the following SP (on a SQL 2000 database CREATE PROCEDURE fsp_NextSequenceCd @Entity as varchar(50) @Sequence as varchar(50) OUTPU A [... Which basically retreive the next sequence ID for the specified Entity. It works fine when called in VB6 or in SQL Query Analyser However, the following VB.Net code will not work (An empty string is always returned in the Output parameter) Public Function GetNextSequence(ByVal Type As enSequenceType) As Strin Dim Command As New SqlClient.SqlComman Command.Connection = mConnectio Command.CommandType = CommandType.StoredProcedur Command.CommandText = Me.CST_SP_NEXT_SEQ_C Dim NewParam = New SqlClient.SqlParamete NewParam.Direction = ParameterDirection.Inpu NewParam.ParameterName = "@Entity NewParam.SqlDbType = SqlDbType.VarCha NewParam.value = "LOT Command.Parameters.Add(NewParam NewParam = New SqlClient.SqlParamete NewParam.Direction = ParameterDirection.Outpu NewParam.ParameterName = "@Sequence NewParam.SqlDbType = SqlDbType.VarCha NewParam.value = System.Data.SqlTypes.SqlString.Nul Command.Parameters.Add(NewParam Command.ExecuteNonQuery( Return Command.Parameters.Item("@Sequence").Valu End Functio Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80435
  - 2
    - DataSet -> DataReader Is it possible to get a DataReader object from a DataSet/DataTable ? If so would it be disconnected ? in other words could I return a populated DataReader object from a class that contains a DataSet ? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80425
  - 3
    - CrystalReports.NET and Datasets.xsd When useing a Crystal Report (CR) bound to a dataset.xsd, the paramenter do not show up in the CR Field Exploere. The parameters are defined in the stored proc that I used to create my dataset. file. Yes I can access them via my VB.Net code, but I am unable to access them and their values from within my CR document formula code Is there a way to access these paramenters from within my CR document Formulas Thank Bria P.S. I am able to do this with an ADO bound connection to a SQL SP, but I have a need to use the Dataset.XSD file Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80424
  - 4
    - Populating a Typed DataSet with the MS Data Application Block Hello all, Has anyone had any luck populating a Typed DataSet using Microsoft's Data Application Block? If so, could you kindly provide some guidance? My Typed DataSet consists of 5 tables: one un-related to the others, one parent, and 3 direct children of the parent. I can provide more detail if necessary. Thanks for any advice or suggestions, Mike Best Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80423
  - 5
    - MySqlCommand timeout Hi, I use the native OleDb driver for MySql from ByteFx in my c# application. When i try to set the command timeout on a MySqlCommand object I get the following exception: Unhandled Exception: System.NotSupportedException: Specified method is not supported. at ByteFX.Data.MySqlClient.MySqlCommand.set_CommandTimeout(Int32 value) Any idea why this functionality isn't implemented or alternatives to shorten the command timeout? Thanks in advance Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80421
  - 6
    - ado.net (insert command) I am new to vb.net and ado.net. I am trying to insert some data fom 3 testboxes into an access db and on the form is an add button. This is the code for the add btn: Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim cn As String = txtcn.Text dbmanager.connect() dbmanager.insertsql("insert into carinfo (Car Name) values('pip')") End Sub Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80419
  - 7
    - How to insert c# DateTime? Is there some way to insert a c# datetime in a table without dealing with culture? The datetime object probably has som internal representation thats culture independant and the database probably stores datetime internally as a long. If i try to insert like this: insert into x(somedatefield) values ('datestring') then i have to format the datetime object in some culture specific string and make sure the database uses the same format. Is there some way to insert a date without dealing with culture settings on client and db server? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80417
  - 8
    - Format Data in BoundColumns of DataGrid Hi I want to format some columns of my DataGrid control. Example, one of my fields of DataSet is a DATE field and in BD he is Ok, but when I show him in datagrid he comes with hours too. I don´t want that. 2nd Example: Field in BD: DtSegm 17-02-2004 Note: When I save to DB I format Date to put like above In DataGrid shows like this: DtSegm 17-02-2004 10:30:45 How can I change that. -- Thank's (if you try to help me) Hope this help you (if I try to help you) ruca Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80414
  - 9
    - Table Mappings and Multiple Tables to XML Hi I understand that a dataadaptor can have multiple tablemappings, but how can I get the schemas and or xml data of multiple tables to be written to the same file, in one action, but have it so each table is separated in its own block? The below code shows 2 tables, but the select statement only retreives all rows from one of the tables. Need some way select all from both tables but when written to xml, they are separate tables? OdbcDataAdapter myAdapter = new OdbcDataAdapter(); myAdapter.TableMappings.Add("Address", "DataAddress"); myAdapter.TableMappings.Add("Products", "DataProducts"); //myConnection.Open(); OdbcCommand myCommand = new OdbcCommand("SELECT * FROM \"Address\"", myConnection); myCommand.CommandType = CommandType.Text; myAdapter.SelectCommand = myCommand; DataSet ds = new DataSet("AllData"); myAdapter.Fill(ds); ds.WriteXml("d:\\AllData.XML", XmlWriteMode.WriteSchema); Thanks in Advance David Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80413
  - 10
    - Database independent design... Hi, I'm basically a .NET newbie... My company is going to develop a solution that we would like to be as database independent as possible. I have downloaded the DataAccessManager from www.gotdotnet.com and it seems like a good idea to use this or something similar. - Anyone have any experience with DataAccessManager? I have some problems getting started since I can't find any documentation. - Is there other solutions available? - Can anyone please outline a preferred strategy or direct me to some resources on the topic? I greatly appreciate all help, Trygve Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80411
  - 11
    - Change Font Size in the SQL pane using server explorer Hi, please advise how to change teh font size in the SQL pane when using the server explorer. Peter Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80409
  - 12
    - DataTable.Select with nested Parent fields I want to make a selection from a DataTable using the Select method with the criteria including a nested parent field. Both of these works fine (Northwind data): DataRow[] drs = ds.Tables["OrderDetails"].Select("Parent(Orders2Details).ShipName LIKE 'A%'"); DataRow[] drs = ds.Tables["Orders"].Select("Parent(Customers2Orders).CompanyName LIKE 'A%'"); But when I try to... DataRow[] drs = ds.Tables["OrderDetails"].Select("Parent(Orders2Details).Parent(Customers2Or ders).CompanyName LIKE 'A%'"); ...it doesn't work! I've looked everywhere without finding any clue on how the syntax for a nested parent reference would look. Any input would be appreciated! Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80407
  - 13
    - Merge doesn't merge Perhaps I have the concept all wrong, but based on the documentation and books I have read it seems this should work. I have multiple complex datasets in an access db. They have 2 shared primary keys. I have another dataset that shares one key with them. I need to end up with a single flat dataset comprised of the merged sets. In a simpler world it would be a normal sql join, but that is not an option. Right now, I would love for someone to point out my stupidity and show me the magic setting I have forgotten. An additional complication is that the last dataset - the one with just one key was a "relation" issue because that field in the other table was not unique values. It would be a many-to-one relation. I have tried using both the relation AND the merge to no avail. I am not modifying this data. I just need to read it in, merge it based on the key values, and kick it out as a single table. As a test I tried creating a more simple 2 table set (in ms sql), read them into datasets, and tried to merge. I just do not ever see a merged result. here is the code that goes with a simple webform with one datagrid. Dim ds1 As New DataSet() Dim ds2 As New DataSet() Dim da1 As New SqlDataAdapter() Dim da2 As New SqlDataAdapter() Dim cn As New SqlConnection() cn.ConnectionString() = "server=daddy;database=test;uid=test;pwd=test" cn.Open() da1.SelectCommand = New SqlCommand("select * from table1", cn) da1.Fill(ds1, "tbl1") da2.SelectCommand = New SqlCommand("select * from table2", cn) da2.Fill(ds1, "tbl2") ds1.Merge(ds2, True, MissingSchemaAction.Add) DataGrid1.DataSource = ds1 DataGrid1.DataBind() Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80406
  - 14
    - Column Expression question Hello! After filling table into DataSet (ds), I added following line ... ds.Tables(0).Columns("MyColumn").Expression = "<MyFormula>" ... and calculation is working fine - but I need to save this calculated field value into database also because it makes easier to make SELECT queries later and it's quite often needed value in many cases too. This "MyColumn" is as a field in database too, and is used too when making DataAdapter in SELECT-query. When trying to save, I'll get error message ... "The column mapping from SourceColumn 'MyColumn' failed because the DataColumn 'MyColumn' is a computed column." Is it possible to save computed column values into database table at all? -- Thanks in advance! Mika Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80403
  - 15
    - SqlDataReader with no rows. I am using a sqldatareader with this command: select max(id) from x If there is no rows in table x then using sqldatareader.read() still return true as if there is a row, which means this code breaks: if (sqldatareader.read()) { ... = sqldatareader.GetInt32(0); // field 0 is null!? } All the examples i have seen on ms website and in books dont take any precautions for empty tables. Right now i am doing this: if (sqldatareader.read() && !sqldatareader.IsDBNull(0)) { ... = sqldatareader.GetInt32(0); } It seems clumsy. I am doing somthing wrong here? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80395
  - 16
    - Problem with OLE DB Provider Hi, I am working on an ASP.NET application. From a page, I am triggering export of a large dataset into an Excel file using OLE DB Provider and after the export is complete the user is redirected to the excel file. Note that the operations here are synchronous. The problem is the data exported is not getting written out to the disk before the user is redirected. So I get an empty excel file in IE while if I check the actual file on the disk, the data seems to be there after a lag of a few seconds. From the KB article, I learnt I cannot set the Max Buffer Size property in OLE DB cannot be set in ADO.NET. How do I ensure that the data is flushed to the disk before I redirect the user to the file? Thanks in advance, Pranav Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80390
  - 17
    - Datagrid Column Width I found the following code on microsoft.support.com which is supposed to with of a column '---------------------------------------------- Dim ts As New DataGridTableStyle( ts.MappingName = "tbl_Client DataGrid1.TableStyles.Clear( DataGrid1.TableStyles.Add(ts DataGrid1.TableStyles("tbl_Client").GridColumnStyles("First_Name").Width = 17 '-------------------------------------------------------------------------------------- Where tbl_Client is the Table name and First_Name is the column Name But when I run the code I get the following error Object reference not set to an instance of an objec Thanks for your hel Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80389
  - 18
    - PRINT in transact-SQL Hi, I have a question regarding PRINT statement in transact-SQL. The following is my test environment * Vuisual Studion 2003, server explorer * either in SQL pane or using stored procedur The scenerio are like belo * alter procedure myProcedure as PRINT 'HELLO' <===== It work * alter procedure myProcedure as begin PRINT 'HELLO' end <===== It does not work Please advice Peter Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80385
  - 19
    - I Have No Identity This has been addressed several times and I've read several articles and posts and I still can't get this to work. (This is VB .NET) My understanding is that if I append a select statement to my DataAdapter's Insert statement that I should be able to get an updated resultset. I've got this: INSERT INTO dbo.FD_Files (FileName, ExpireTime, PostedBy, HashName, FileSize, Description) VALUES (@FileName, @ExpireTime, @PostedBy, @HashName, @FileSize, @Description); SELECT FileID, FileName, ExpireTime, PostedBy, HashName, FileSize, Description FROM dbo.FD_Files WHERE FileID = @@IDENTITY I've also tried using SCOPE_IDENTITY() - reagrdless, I always get the whole table returned. I need to know the identity of the record I just added and I keep getting a whole table. It's making me crazy. I've even tried setting the adapter's select command to SELECT FileID from FD_Files WHERE FileID = SCOPE_IDENTITY() and re-filling the dataset. I get the whole damned table. Why!!!!???? What am I missing? I've tried using the built in wizard which comes up with an insert statement just like the one above and I still end up with the whole table after I update. Can anyone shed some light on this? Thanks. Jerry Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80384
  - 20
    - Populate a DataTable (with Aggregation) from an existing DataTable Hi, I have a datatable with 2 keys columns, i need get this datatable with agregate totals. How can i do that? datatable Key1 Key2 Total 1 1 100 1 1 200 1 2 50 1 2 10 2 1 100 i need other dattable agregate totals key1 key2 Total 1 1 300 1 2 60 2 1 100 Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80383
  - 21
    - Calling Oracle date functions via ODBC and .NET Hi! I'm using ODBC to connect to an Oracle database. I want to do something like the following: --------- var conn: OdbcConnection = new OdbcConnection("my connect string here"); var sql: String = "update mytable set col1=?, col2=? where keycol=?"; var command: OdbcCommand = new OdbcCommand(sql, conn); command.Parameters.Add("@col1", OdbcType.Int, 22).Value = 1; if (some_test) { command.Parameters.Add("@col2", OdbcType.Date, 7).Value = 'SYSDATE'; } else { command.Parameters.Add("@col2", OdbcType.Date, 7).Value = null; } command.Parameters.Add("@keycol", OdbcType.Int, 22).Value = my_key; command.ExecuteNonQuery(); -------- My question is, how do I do that second parameter? How can I tell it to call SYSDATE, or set the value to null? I admit that I haven't tried this code, because I don't think that the string 'SYSDATE' is a valid date object. Should it work? Thanks, Ricky Morse Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80380
  - 22
    - generic function to execute a sql stored procedure hello, In my asp.net projects I like to seperate the database connection and lookups/executes from the code-behind pages using shared functions. I find myself often using a function that returns a datatable given a sql query and it works great. The function is contained in my 'dataaccess' class and is a shared function. I would really like to do the same thing with stored procedures. However, I'm running into problems handling the paramaters since there can be zero or more and of varying types/names. Ideally, the stored procedure's parameters can be defined in the parameters of the function (using an array?) and then the stored procedure is executed using the parameters within the function. Does anyone have code for executing any stored procedure using a generalized function? Is this even possible? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80379
  - 23
    - Primary Key of string values (trims spaces from the end of strings) causes unique violation I'm loading a key values into a database and two may be identical except for maybe 1 or 2 trailing spaces. This causes a unique constraint error because for some reason it's trimming the string values when checking the unique contstraint I can clearly see in the dataset the string has spaces on the end. I know this is the exact problem because if I append a letter after one of them the exception goes away Why does it trim the string when validating the Primary Key unique constraint Thanks Jeff Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80377
  - 24
    - Top SECRET of making huge money!! Discovers the "Secret of making huge money" in just few weeks.... You shall be amazed that how easy 1 can make money on internet just for doing 1 time work..[I GUREENTED U CAN TOO MAKE BIG$$ WITH THIS PROGRAM]........ [Use IE if can't view the site] http://mysiteinc.com/gohar/index.html Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80376
  - 25
    - Max Connection Pool Reached ... Hi , " Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. " I am getting this error in my application. All requests to the Database go through the Data Access layer. And I am opening and Closing connections in the Data Access Layer. I cant seem to find out why this is still happening ? The Server Classes that I have are a mix of ServicedComponents and non-ServicedComponents and the Data Access Layer as such is marked as TransactionOption.Supported. How would COM+ affect pooling ? Any tips/pointers on how for further diagnosis would be helpful. Regards , Vikram Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80367
- Next
  - 1
    - No way to insert large data into oracle Clob??? Does anyone have the same problem? I use follow code to insert a large xml into oracle database. The data is inserted, however shows as "Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿Â¿.. xmlRawDom.Load("D:\testActual.xml" dataString = xmlRawDom.OuterXm Dim AE As New System.Text.ASCIIEncodin Dim ByteArray As Byte() = AE.GetBytes(dataString rsConnection = DBClient.OpenDBConnection(_realSuiteDBString, True tx = rsConnection.BeginTransactio Dim rsCommand As New OracleClient.OracleComman rsCommand = rsConnection.CreateCommand( rsCommand.Transaction = t rsCommand.CommandText = "declare xx Clob; begin dbms_lob.createtemporary(xx, false, 0); :tempClob := xx; end; rsCommand.Parameters.Add(New OracleClient.OracleParameter("tempClob", OracleClient.OracleType.Clob)).Direction = ParameterDirection.Outpu rsCommand.ExecuteNonQuery( Dim tempLob As OracleLo tempLob = rsCommand.Parameters(0).Valu tempLob.BeginBatch(OracleLobOpenMode.ReadWrite tempLob.Write(ByteArray, 0, ByteArray.Length tempLob.EndBatch( rsCommand.Parameters.Clear( rsCommand.CommandText = "Realdata_Rxbdoc.InsertXMLtoQ rsCommand.CommandType = CommandType.StoredProcedur Dim oraparameter As New OracleClient.OracleParameter("strXML", OracleClient.OracleType.Clob oraparameter.Direction = ParameterDirection.Inpu oraparameter.SourceVersion = DataRowVersion.Origina oraparameter.SourceColumn = "MSGDATA oraparameter.Value = tempLo rsCommand.Parameters.Add(oraparameter rsCommand.ExecuteNonQuery( tx.Commit( rsConnection.Close( ******************** procedure PROCEDURE InsertXMLtoQ(strXML IN CLOB ) A BEGI INSERT INTO ACTUALJOB (RXBDOC_ACTUALJOB_ID,MSGDATA) VALUES (1,strXML) END **************************** For small data, I can insert data directly like 'Dim conn As OracleConnection = New OracleConnection(_realSuiteDBString 'Dim cmd As OracleCommand = New OracleCommand("InsertXML", conn 'Dim s As FileStream = File.OpenRead("D:\rawActual.xml" 'Dim r As StreamReader = New StreamReader(s 'cmd.CommandType = CommandType.StoredProcedur 'cmd.Parameters.Add("strXML", OracleType.Clob 'cmd.Parameters(0).ParameterName = "strXML 'cmd.Parameters(0).Direction = ParameterDirection.Inpu 'cmd.Parameters(0).Size = r.BaseStream.Lengt 'cmd.Parameters(0).Value = r.ReadToEnd( 'conn.Open( 'Dim i As Int16 = cmd.ExecuteNonQuery( 'Console.WriteLine("{0} rows inserted", i But for large data,this method give error:'ORA-01460: unimplemented or unreasonable conversion requested Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80363
  - 2
    - DataSet.Merge question I have a dataset loaded with an xml that looks like this: <associations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <association> <associationid>{8a3aca06-a7de-41a5-b584-063e7cf391bb}</associationid> <createdon>2004-02-17T12:05:40.3430000-05:00</createdon> <modifiedon>2004-02-17T12:05:40.3430000-05:00</modifiedon> <forwardrelation>Parent</forwardrelation> <backrelation>Parent</backrelation> <forwardnotes>ttt</forwardnotes> <backnotes/> <fromid name="" dsc="" type="1">{8c4a969b-2aa4-4679-b170-d9f6441f7c6d}</fromid> <toid name="" dsc="" type="2">{df3f306f-19de-4f50-9784-623bf6693fa8}</toid> <createdby name="" dsc="" type="8">{2479254f-1dee-41dc-b79b-8de686a4db29}</createdby> <modifiedby name="" dsc="" type="8">{2479254f-1dee-41dc-b79b-8de686a4db29}</modifiedby> </association> </associations> Then I try to merge another dataset loaded with another xml: <resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <contact> <contactid>{1323159A-E579-4A9B-95A2-5F9AFC041E28}</contactid> <fullname>Jones, Sally</fullname> <jobtitle>Lawyer</jobtitle> <accountid name="Jones&Jones" dsc="0">{EE22734B-F1A1-4B0F-B874-52FE2A3B1A6A}</accountid> </contact> <contact> <contactid>{DF3F306F-19DE-4F50-9784-623BF6693FA8}</contactid> <fullname>Dodd, Cindy</fullname> <jobtitle>Owner</jobtitle> <accountid name="Suburban Cycle Shop" dsc="0">{D17A8F20-D1D0-4F51-B365-92FDF16EDBE9}</accountid> </contact> <contact> <contactid>{54B82B18-D54D-4B6B-B114-73093D2A0070}</contactid> <fullname>Hayes, Scott</fullname> <jobtitle>Primary Owner</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> <contact> <contactid>{8929CAD1-E941-4B6E-AAB7-A3D3062A9C71}</contactid> <fullname>Kennedy, Susan</fullname> <jobtitle>Finance Workout</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> <contact> <contactid>{AADC8B14-27F3-4B03-8901-FC0929D48544}</contactid> <fullname>Block, Larry</fullname> <jobtitle>Sales Turnaround</jobtitle> <accountid name="A&M" dsc="0">{3ABC2121-5315-4050-838D-477E04B37CE7}</accountid> </contact> </resultset> Using the following syntax: associationDS.Merge(resultDS.Tables[0]); // assume the first xml has been loaded into associationDS and the second into resultDS There were no schemas involved and each DataSet is loaded via ReadXml(XmlTextReader) method. Things kind of work out ok as <contact> nodes are inserted right under <associations> root so that it looks like: <associations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><association/><contact /></assocations> The only problem is that the resulting xml after the merge is missing <accountid> node under <contact>. What am I missing? Do I have to specify explicit schema info or relationship - note that <association> and <contact> are seemingly independant - ? Thanks much! Jiho Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80361
  - 3
    - Properties in VB = Parameters in .NET?? Hi! I have this problem... In Visual Basic I am work with ADODB and the next code work perfectly... Dim cmd as New ADODB.Command cmd.Properties(15).Value = 2 ... But in .NET.. OleDbCommand cmd = new OleDbCommand(); cmd.Parameters.add("15",2); ... this code throws an error: "An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The ICommandWithParameters interface is not supported by the 'GXPublic.GXPublic.3' provider. Command parameters are unsupported with the current provider." How I can work with properties en .NET? thanks... pablo Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80357
  - 4
    - Binding INTEGER and use of NULL Hi I bind a textbox to a field in the database through CurrencyManager. Everything works find exept one thing: I cannot type Null, blank, nothing in the textfield. The property in the database allows NULL but I cannot type blank in the textbox. Whatever I type that isn't numeric is changed then I leave the textbox There must be an easy way to solve this - but what? /Raymond Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80355
  - 5
    - Stored Procedure Syntax Hi, I am attempting to updata a SQL Server record using the stored procedure's UpdateCommand. Everything works fine if all fields are full, but if a user clears out a textBox that originally contained a number in it, then the update bombs out. The field in the table is setup to accept nulls. What is the proper syntax to store it back? da.UpdateCommand.Parameter[1].value = ???? <a null> ????? Any help is greatly appreciated. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80354
  - 6
    - DB_SEC_E_AUTH_FAILED(0x80040E4D). Hallo I have an import process that crashes after importing millions of data rows suddenly stops working with the error message System.Data.OleDb.OleDbException: No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D) The exception coccurs when making the connection to the Access 2000 databas objConnection.Open( Has anyone had this kind of error before As next I was going to check if this could be related to MDAC or if there is a problem with the sharing of the database connection. Any ideas would be welcome.. Thanks.. Nigel... Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80353
  - 7
    - Isolation Level Hi, We have an Asp.Net applcation with Sql Server as back end. I have a base class function that takes a SqlCommand Object as a parameter and returns a datatable. I want to set the Isolation to "Read Uncommited" (Sql Server's default Isolation Level is "Read Commited") as I am just selecting some data from the tables. When I try to do the following : objSqlCommand.Transaction.IsolationLevel = IsolationLevel.ReadUncommitted The system says IsolationLevel is a Readonly property. So the only option that I have currently is to set the Isolation Level to "Read Uncommitted" in the Stored Procedures. Is there a way to set it in the code so that I don't have to set it for each stored procedure. Thanks a lot. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80350
  - 8
    - Does SqlHelper automatically close SQL connection? Suppose I want to do something like populate a droplist control with some data. I want to use as few lines of code as possible. In the examples for the Microsoft Application Data block, it shows a few ways of doing this. (Note that Global.GetSqlDataSource(string) returns a SQL connection string like this: "server=sqlserver.domain.com; uid=login; password=pass") CASE A: // Execute stored procedure to load list of data labels DataSet ds = SqlHelper.ExecuteDataset (Global.GetSqlDataSource("DATA"), CommandType.StoredProcedure, "usp_DataLabels_List"); dropDataLabels.DataSource = ds; dropDataLabels.DataBind(); In case A, how does the SQL connection get closed? Does the connection get closed after the dataset is assigned to ds? Or do I have to add something? What would I need to add? CASE B: // Execute stored procedure to load list of data labels dropDataLabels.DataSource = SqlHelper.ExecuteReader(Global.GetSqlDataSource("DATA"), CommandType.StoredProcedure, "usp_DataLabels_List"); dropDataLabels.DataBind(); In this scenario, where is the connection closed? Or does it create a leak? If I want to keep code minimal, should I make an object that inherits from SqlHelper, but calls this.Close() when it is finalized? Or do I need to write more code to allocate a connection seperately and then close it. Doesn't that defeat the purpose of the SqlHelper? Thank you very much! David Meet people for friendship, contacts, or romance using free instant messaging software! See a picture you like? Click once for a private conversation with that person! www.SEN.us *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80347
  - 9
    - Connection recovery problem with OracleConnection Hi, I'm using ADO.Net C# with Oracle9i Release 9.2.0.4.0 when loosing the connection with the Oracle database server the connections doesn't recover and always returning the following exception even when the connection has been restore: "ORA-03114: not connected to ORACLE". I'm closing the connection properly in that it will return to the connection pool. Here is an example code: using(OracleConnection conn = new OracleConnection(connectionString)) { conn.Open(); using(OracleCommand cmd = new OracleCommand(sql, conn)) { object obj = cmd.ExecuteScalar(); } } This should close the connection properly. In the MSDN it is mention that if the connection pooler detect that the connection with the server has been severed it will remove the connection from the connection pool. It appears that this is not happening an I always get bad connections from the pool, even after the connection with the database server has been restore. How can I solve this? What is the proper way to recover from connection lost with database server? Thanks, Michael. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80343
  - 10
    - adodb.connection problems Hello, I am having a problem with ADODB connection class. This was all working fine until I restarted the pc with last known good configuration, which seems to have screwed things up In the code below the conn.open command fails with a "cannot find stored procedure error". and system.runtime.interopservices.COMexception. The specified procedure could not be found. at ADODB.ConnectionClass.Open etc.. How can I fix this problem, do I need to re-install anything. I still have a reference to adodb Regard Robert Dim Conn As ADODB.Connection = New ADODB.Connectio GblConnectionString = "PROVIDER=SQLOLEDB.1;PASSWORD=" & txtPassword.Text & ";PERSIST SECURITY INFO=TRUE;USER ID=" & txtLoginName.Text & ";INITIAL CATALOG=Master" & ";DATA SOURCE=" & txtServerName.Tex Tr Conn.Open(GblConnectionString) '''*********** FAILS HERE******************* Catch e As Exceptio MsgBox(e.Message MsgBox(e.ToString End Tr Dim rs As ADODB.Recordset = New ADODB.Recordse Dim strRowSource As Strin Tr rs.Open("SELECT Name From sysdatabases WHERE Name NOT IN( 'master','tempdb','model','msdb','pubs','NorthWind')", Conn Catch e As Exceptio MsgBox(e.Message MsgBox(e.ToString MsgBox(e.Source End Tr Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80339
  - 11
    - Refreshing database cache Dear all I have written a windows service that connects to an Oracle 9 database on start up. I use a DataTable to hold a set of near static data. Recently there have been some overnight external batch updates to this table and my DataTable needs to be refreshed. Since this change of circumstances I have been restarting my service in the morning. I need to find a way to fresh my data object without restarting the windows service. I would be grateful for any pointers. Regards, Wazir Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80337
  - 12
    - Array as input parameter Hi all, I need a SQL stored procedure that has an input parameter of type array of datetimes. How to define such a procedure? if possible Thanks, Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80330
  - 13
    - need suggestion in Guid autogeneration in dataset Hi al I have PK with Guid type in typed dataset Is anybody have any suggestion how 2 implement autogeneration of P thnks Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80326
  - 14
    - System.Data.OracleClient Couldn't understand why following line of code is failing <%@ Import namespace="System.Data.OracleClient" % I am getting following error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be foun Although I can see the System.Data.OracleClient in References and I have v1.1 framework installed. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80325
  - 15
    - Timeout Expired error. Hi there! I am using MSDE 2000 SP3, Sql.Net provider on Win2k server. When I try to execute very simple query of inserting/selecting a row into a table, I am getting following error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." This behaviour is not consistent. I have checked my code for not leaving any connection open. Is there any limitation on number of connections on MSDE? Or is it a problem with Sql.Net provider? Please help me. Thanks in advance. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80324
  - 16
    - FoxPro connect problems REGDB_E_CLASSNOTREG I'm using vs.net, clr 1.1, c# web application. I get the following error connecting to foxpro using its oledb driver. I've tried several ways to connect. No error information available: REGDB_E_CLASSNOTREG(0x80040154). [OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).] [InvalidOperationException: The 'vfpoledb.1' provider is not registered on the local machine.] System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) System.Data.OleDb.OleDbConnection.Open() Elkhorn.eCatData.Page_Load(Object sender, EventArgs e) in j:\projects\aproject\aproject\webui\data.aspx.cs:45 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() I downloaded and installed the driver foxpro8 driver from: http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en I don't have any verison of foxprox on the machine. I registered vfpoledb.dll myself from the command line just to make sure. The connection tested ok with the "Test Connection" button when I used the designer. I think the connection string is fine, is as on connectionstrings.com. @"Provider=vfpoledb.1;Data Source=C:\progra~1\aproject\data\data1.dbc;Password=;Collating Sequence=machine"; Any ideas? ??? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80320
  - 17
    - Concurrency violation, I don't understand! [This followup was posted to microsoft.public.dotnet.framework.adonet and a copy was sent to the cited author.] Hello everybody. I have a problem with an exception when I try to modify a row in a mssql db. The exception that I found is Concurrency violation. I read some other posts but I didn't find a solution. In effect with my code I want to replace all the strings inside a "info" attribute with the word "Hello" (This is a test, I know that this is a stupid thing, but I wanna make that). My code update 212 row but give me a concurrency violation in 7 roes. All these 219 rows are selected at the same time e stored inside the same table. The rows that I can't update are like the following: "IST. DI CLIN. CHIR. GEN. E TERAPIA CHIR. PROF.BATTEZZATI" But if I use SQL to replace this string with another one shorter (Like "IST. DI CLIN. CHIR. GEN. E TERAPIA PROF.BATTEZZATI" or "IST DI CLIN CHIR GEN E TERAPIA CHIR PROF BATTEZZATI" ) and then I run my code, it works fine and this line is replaced by the "Hello" word. In the db the info attribute is a nvarchar(90), I don't understand where is the problem. Is there some limit in the dimension of string that can be inserted in a datarow or datatable object? Thanks to everybody Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80318
  - 18
    - Stored procs to xsd example I have 3 pre-built stored procs and want to load the results of them into an xsd for processing. I've defined the XSD with different table and column names and would like to map these to each of the procs. I can change the names if necessary, but would rather map it, if for no other reason than to learn how to Does anyone have an example of how to do all this, or a link to an article for it? Thanks Tim Almond Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80317
  - 19
    - dataset.getchanges fails to return changes Hi All I'm experiencing the problem of dataset.getchanges returning unmodified rows only : myDs.ReadXml("c:\Parsley.xml", xmlReadMode.Auto) For Each t In myDs.Tables For Each r In t.Rows If r.Item("Deleted").ToString = "True" Then r.Delete() Exit For End If Next r Next t myTmpDs = myDs.GetChanges() myDs.Merge(myTmpDs) myDs.WriteXml("c:\Parsley.xml", xmlWriteMode.WriteSchema) The getchanges call returns the non deleted rows, the merge call adds these rows to the main dataset. I have read elsewhere that I need a primary key? There is one on the SQL table the xml is extracted from but nothing in the xml to indicate this. Ta v'ry much Parsley Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80314
  - 20
    - Installation Failure of MDAC 2.1 on Windows Server 2003 Hi, all, I have an application that starts installing with MDAC 2.1. Once the MDAC 2.1 is installed, it reboots the server and then continues again with the installation process once reboot complete. But then again, MDAC 2.1 is installed for the second time, it goes on like this. If I choose Cancel, the installation process has to abort. I understand that the version of MDAC on windows 2003 is at least 2.8. But how can I also install MDAC 2.1 for some application compatibility? Thanks a lot, Jake Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80311
  - 21
    - Oracle Connection Pool Performance We are troubleshooting performance problems with our application. There are 30-50 users using an web IE OLTP application against a 3-6GB database, queries often hitting several tables (40,000-1.2M rows but using indexes) foreign key constraints enabled). The architecture is ASP.NET - DOT NET 1.1 which means a connection pool using OLEDB. There are issues with DataReaders not being closed - meaning new connections opening often - sometimes we see 90-120 open connections. The clustered dual server is fairly new with a fast dual cpu, INTEL, WIN2000 server over 9 disks, mostly Raid 5. However there is 1.5GB RAM and little disk I/O activity. Perhaps the issue lies in the SQL, lack of caching and connection pool. However there are no queries with huge buffer gets and the oracle stats do not point to anything specific. Are there inefficiencies with dot net 1.0 with Oracle and many users? Any ideas on next steps - Metalink does not have much that is NT specific. Final info Database is 8.0.5 and no not an option to upgrade that yet, perhaps in 6 months but the issues are here and now :-) Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80307
  - 22
    - Configure DataAdapter Changes the Name of a Column in Insert Command I have a SQLDataAdapter that I allow the Configuration Wizard to auto-configure the Select, Insert and Delete commands. During the configuration wizard the Select Statement that I cause to be created is simple: SELECT [ICD-9], Category, Description FROM [ICD-9] ORDER BY [ICD-9]. However, the Insert statement that is created is : INSERT INTO [ICD-9] ([ICD-9], Category, Description) VALUES (@Param1, @Category, @Description); Look at the VALUES. Instead of the first parameter being @ICD_9, it's changed to @Param1. Now believe it or not, the statement works OK but I have no idea where @Param1 comes from and I certainly don't set a value for @Param1. Why did the configuration wizard change the name of the first column to @Param1 instead of using the @ICD_9 the way that I expected. Is it that pesky hyphen in the column name that I never should have placed in a column name in the first place? Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80300
  - 23
    - Calculated Columns vs Calculations in stored procs.... what is the best way ??? I have several crossTab type reports in a VB app. I am displaying these reports in a Datagrid. The Datagrid gets its data directly from a stored proc I have created on SQL Server 2000 (rp_crossTab) which returns data in a nice crossTab fashion. (The stored proc accepts parameters such as onRows, onCol, sumBy, etc.) My problem is I have several crossTab reports which actually depend on data found in other crossTabs. For example, I have this total paid amount crossTab: REPORTA Name/Month Jan Feb Mar Jon 20 40 40 Jack 100 50 200 Jill 25 75 75 And another report might be a month-to-month ratio of the total paid amount: (this report clearly depends on REPORTA) REPORTB Name Jan to Feb Feb to Mar Jon 2 1 Jack 0.5 4 Jill 3 1 I thought of two ways to create REPORTB: 1) Call another stored proc which then calls rp_CrossTab, and performs the necessary calculations using tempTables. 2) Creating a new table using new DataColumn objects in .NET and setting their necessary values in the "Expression" field (eg "Jan/Feb") and also making the columns dependent on REPORTA. I can think of various problems with both scenarios... Correct me if I am wrong but solution 1 would take a huge performance hit since it would be in fact re-calculating REPORT A in order to generate REPORT B. Solution 2 sucks because I would have to hard-code logic in my .NET app and I dont really wanna do that.... as well I dont think I can use custom functions in the column Expression field (eg. DataColumn.Expression = "MyWeightedAverage(COL1,COL2,COL3)") What is the best way to create this second (or any other dependent) report? Is there something I have missed? Is it generally better to have ALL logic in stored procs... even it is much slower? Thanks a lot, I really appreciate any comments anyone may have. Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80299
  - 24
    - 19 Feb 2004, How to access VB.net applications thr' PDA's Hello, I recently started development in Vb.net. I am about to finish a product in VB.net Database Applicatio, Sql Server as Backend. I read little about wireless technology and PDAs. Is it true that one can access VB.net forms/applications running on Server, using PDAs ? If so please tell me where to start for this ? what is the infrastructure investment for such projects ? What are running cost in terms of hardware and software ? Where can I get more resources on this topics ? Thanks in Advance. Regards. [Sham Shrinivas Yemul] -- > > Visit following web site for Colored flame lamps > >http://in.geocities.com/osyemul/index.html *********************************************** Intellisoft Computer Consultants Pvt. Ltd. 340 A Sakhar peth, Solapur - 413005 Phone : 91-(0)217-262 4713 http:\\intellisoft.netfirms.com Email : yemul@fusemail.com *********************************************** Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80298
  - 25
    - OleDbDataAdapter appears to use incorrect path to DB Hi I am using .NET framework 1.0. I am having problems with the following VB.NET code: ---- . . . . Dim da As New OleDbDataAdapter(selectQuery, connection) Dim ds As New DataSet() Try da.Fill(ds) Catch eDB As OleDbException showException("Database exception while filling dataset.", eDB) Return Nothing End Try . . . ----- The connection object i pass into the OleDbDataAdapter constructor has been initialised with the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\projects\TestData \tracking.mdb;User ID=Admin;Password=;Mode=Share Deny None" I checked that the data adapter's SelectCommand's connection was set to the correct connection string using the debugger. On the line: da.Fill(ds), i get an exception with the message: "Could not find file 'x:\projects\MyAppName\bin\tracking.mdb'." Now, obviously this occurs because the database does not exist at this location. But what I can't understand is why the path it's using to look for the database is the executable path. Has anyone seen this issue? Any help/comments greatly appreciated! Thanks id Tag: command to auto generate data adapters sel,upd,and delete commands? Tag: 80295

I cant remember what its called but isnt there a command that will auto
generate the select update and delete commands for a data adapter at
runtime? based on a query you have...

Top

Re: command to auto generate data adapters sel,upd,and delete commands? by Miha

Miha
Fri Feb 20 10:14:33 CST 2004

Hi Brian,

You are looking for [Prefix=OleDb, Sql]CommandBuilder class.
However I recommend that you create your commands at design time and avoid
CommandBuilder since it is a blackbox and you have no control over it.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:%23yrF5r89DHA.548@TK2MSFTNGP11.phx.gbl...
> I cant remember what its called but isnt there a command that will auto
> generate the select update and delete commands for a data adapter at
> runtime? based on a query you have...
>
>

Top