DataSet - DataColumn MaxLength

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
    - Access database, network access problems I've recently run into a problem when creating a web service. I have a webserivce that returns data from a small access database; I created and tested the service on my local machine with the database local in a sub-directory. I verified the results on a test server remotely with the database stored on the local disk. The production server is a web farm, a SAN provides all data storage for this farm; This is where I am having problems, I'm no longer able to open the database, the permissions have been validated on the remote share and the user account has access? My connection string "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\server\share\folder\folder\folder\database.mdb;" I have also tried using the extended property Mode="Share Deny None" The mappath function is used to get the actual file path. It points to the correct location, but, I get errors that the database cannot be opened because you don't have permissions or the database is being opened exclusively, or something to that nature. I don't have recordlocking enabled and a .ldb file is never created. Any suggestions? If you need more information please let me know. Tag: DataSet - DataColumn MaxLength Tag: 97621
  - 2
    - how to correctly map multiple datasource tables to typeddataset ta I foolishly thought that if.. 1. I have a typed dataset built from my data source schema (that is, all the table names and all their column names, and types, match), and 2. I fill an instance of the dataset using a dataadapter, then the table names in the dataset would be correct (i.e. matching data source table names). I found that they are named Table, Table1, Table2, etc, and that to override this I need to set up table mappings for these default table names (which are dependent on the order of tables in the query text!). Is there a correct way to do this, or is the proper technique simply to map the default table names!? Tag: DataSet - DataColumn MaxLength Tag: 97607
  - 3
    - Inheritance VB.NET Hi guys, Wonder if anyone can help a newbie in VB.net. I've done a substantial amount of work in VB6 and to promote code use, I lent some methodology from some other OOP RAD tools - but I'm having a probem figuring out an approach in VB.Net... In VB6, I would, for each database table, create a 'class module', which contained all of the necessary database functions I required. So, e.g. I would have a class module called 'tcProvinceState', which would handle all of my database IO for the ProvinceState table. In each class module, I would have functions such as 'DoSelect', 'DoSelectRow', 'InsertRow', 'UpdateRow' and 'DeleteRow'. Here are some examples of the type of thing I currently do; Public Function Do_Select(pSearchString As String) As ADODB.Recordset ' Select all records from the table sSQL = Do_Select_Body(pSearchString) 'Get the body sSQL = sSQL & " ORDER BY PS.PROVINCE_STATE_NAME" Set Do_Select = clsSQL.Perform_SQL(sSQL) End Function Private Function Do_Select_Body(ByRef pSearchString As String) As String ' Get the select body sSQL = "SELECT" sSQL = sSQL & " PS.ID" sSQL = sSQL & ", PS.CODE" sSQL = sSQL & ", PS.PROVINCE_STATE_NAME" sSQL = sSQL & ", PS.COUNTRY" sSQL = sSQL & ", PS.GMT_ZONE" sSQL = sSQL & ", PS.TAX_GROUP_ID" sSQL = sSQL & ", TG.CODE AS TAX_GROUP_CODE" sSQL = sSQL & ", TG.DESCRIPTION AS TAX_GROUP_DESCRIPTION" sSQL = sSQL & ", PS.FREIGHT_ADJUSTMENT" sSQL = sSQL & ", PS.RECORD_CREATED" sSQL = sSQL & ", PS.RECORD_UPDATED" sSQL = sSQL & ", PS.USER_ID" sSQL = sSQL & ", EL.USER_NAME AS EMPLOYEE_USER_NAME" sSQL = sSQL & ", EL.FIRST_NAME AS EMPLOYEE_FIRST_NAME" sSQL = sSQL & ", EL.LAST_NAME AS EMPLOYEE_LAST_NAME" sSQL = sSQL & " FROM ((" sSQL = sSQL & "PROVINCE_STATE AS PS" sSQL = sSQL & " LEFT JOIN EMPLOYEE_LOGIN AS EL ON PS.USER_ID = EL.ID)" sSQL = sSQL & " LEFT JOIN TAX_GROUP AS TG ON PS.TAX_GROUP_ID = TG.ID)" sSQL = sSQL & " WHERE 1=1" Build_Search pSearchString Do_Select_Body = sSQL End Function Public Function Insert_Row(ByRef rsRow As ADODB.Recordset, pID As Long) As Boolean ' Insert row into the table; Dim sErrors As String Dim sDate As Variant sDate = Format(Now(), "d-mmm-yyyy") ' Use Stored Procedure (SQL Server 2000) ' Initialize the input & output parameters; Set cStoredProcedure = New ADODB.Command Set cParam = New ADODB.Parameter With cStoredProcedure Set cParam = .CreateParameter("@CODE", adVarChar, adParamInput, 4, rsRow.Fields("CODE")) .Parameters.Append cParam Set cParam = .CreateParameter("@PROVINCE_STATE_NAME", adVarChar, adParamInput, 30, rsRow.Fields("PROVINCE_STATE_NAME")) .Parameters.Append cParam Set cParam = .CreateParameter("@COUNTRY", adVarChar, adParamInput, 20, rsRow.Fields("COUNTRY")) .Parameters.Append cParam Set cParam = .CreateParameter("@GMT_ZONE", adSmallInt, adParamInput, 5, rsRow.Fields("GMT_ZONE")) .Parameters.Append cParam Set cParam = .CreateParameter("@TAX_GROUP_ID", adInteger, adParamInput, 8, rsRow.Fields("TAX_GROUP_ID")) .Parameters.Append cParam Set cParam = .CreateParameter("@FREIGHT_ADJUSTMENT", adCurrency, adParamInput, 8, rsRow.Fields("FREIGHT_ADJUSTMENT")) .Parameters.Append cParam Set cParam = .CreateParameter("@USER_ID", adInteger, adParamInput, 8, glngUserID) .Parameters.Append cParam Set cParam = .CreateParameter("@ID", adInteger, adParamOutput, 8, pID) .Parameters.Append cParam sSQL = "SP_PROVINCE_STATE_INSERT" clsSQL.Perform_StoredProcedure sSQL, cStoredProcedure, sErrors End With ' Check Errors If Len(sErrors) Then Display_Errors "Insert Failed", sErrors Insert_Row = False Exit Function End If ' Read any output parameters pID = cStoredProcedure.Parameters("@ID").Value Insert_Row = True End Function With this method, creating a new table and its related 'class' is quite simple. Now, although this methodology doesn't have true inheritance, I get some code re-use and it provided a very good platform for my DB applications. However, I am now somewhat confused with regards to VB.Net. .Net would appear to give me some native functionality for things such as selects, inserts and deletes. I can see how inheritance may truly help me by allowing me to create a 'master class', but I'm not sure how I would implement this? - Should I be looking at writing similar code? or does .Net offer me another option? Ideally I would like to create a visual class such as a dataset - but from what I can see - this has to be copied from form to form as required - not inherited. Anyway, if anyone has any suggestioms, or can point me in the right direction, I'd very much appreciate it. All the best, Graham Tag: DataSet - DataColumn MaxLength Tag: 97605
  - 4
    - Recommended OleDB driver for MySQL? I am accessing MySQL from VS 2003, C# and ADO.NET, using the OleDb interfaces (not ODBC) and have been using (successfully) an OLE DB driver on: http://www.mysql.com/downloads/download.php?file=Downloads/Win32/MyOLEDB3.exe&pick=mirror This driver is called "My OLEDB 3.0, OLE Provider for MySQL, February 20, 2001". I am actually amazed that anything written in 2001 still works with the recent MySQL 4.1 ... amazed - and worried that some of the issues I am working through may be caused by some incompatibilies ... Should I be using a more recent driver? I see mysql-connector-net-1.0.0-beta.zip on www.MySQL.com but this package doesn't contain any EXE (and I don't whether one can be built from the included file or how). I am not even sure this is an OLE DB provider, it may be an ODBC provider. In fact, considering how new I am to MySQL, I am not even sure that *any* MySQL OLE DB provider is required: the Windows System Requirements page (http://dev.mysql.com/doc/mysql/en/Windows_system_requirements.html) does not even mention the need to install anything before proceeding with the MySQL installation (except for those planning to connect via ODBC). Thanks! Patrick Tag: DataSet - DataColumn MaxLength Tag: 97598
  - 5
    - DataGrid boundcolumn problem I want to use a datagrid with my display, but I don't want to use 1 row per record. What I have is a record with up to 6 values - (answer1,answer2,answer3,answer4,answer5,answer6). I want to display them with alternating styles. One record may only have the first 3 fields with data and another with 4 and still another with 6. I want it to show as: Answer1 Answer2 Answer3 or Answer1 Answer2 Answer3 Answer4 Answer5 Can I set up a DataGrid this way? Thanks, Tom Tag: DataSet - DataColumn MaxLength Tag: 97597
  - 6
    - Select datagrid rows with key-up and key-down? I have an application that uses a windows forms datagrid. How do I select rows using the up-arrow and down-arrow keys? Mervin Williams Tag: DataSet - DataColumn MaxLength Tag: 97592
  - 7
    - DataTable.Add(row) and fired events I have a situation where a method listens to the RowChanged event for a datatable. The problem I having is this.. The RowChanged event handler calls another method, passing in the e.Row["ID_VALUE"] of the row that fired the event. In the case where this is a .Add(dr) that has caused the RowChanged event to fire.... the row that is referenced in e.Row (event arg for the RowChanged event handler) is not actually in the table yet. If I do a dt.Select() or a dt.Rows.Count,,, it is obvious that the row firing the event has not actually been added to table yet. Why is this happening? Is this a bug? Why would the row fire the table event and not be in the Rows collection for the table??? Tag: DataSet - DataColumn MaxLength Tag: 97584
  - 8
    - Opening an acess database I have been programming in years in VVB-5-6 but can anyone help in the syntax in how to open an access database with a password and how to get a recordset from it as I am only used to the DAO method and this does not seem to be used in .net -- Clifford Sutton Tag: DataSet - DataColumn MaxLength Tag: 97575
  - 9
    - Newbie: Detecting type of field contents in datareader This is a multi-part message in MIME format. ------=_NextPart_000_0059_01C4B5CD.2DB31250 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have a few examples and things are quite clear with using a datareader = (reading data, naming column headers etc.), and populating a listview. However: (!!!) In all of the examples we know beforehand the number of = fields and therefore the data type (Int, Date, String etc) since the = SELECT string is constant. My problem is with variable strings that get constructed at runtime. = Then, since i do not know beforehand what exactly is my first,second, = etc. field, I CANNOT use : myDataReader.GetString(0) or myData.GetInt32(0),etc. since io do not = know the type beforehand. Is there a way around this? I really dont mind getting them all as text = so is the an CType analogous method I could use . Something like casting = BEFORE reading ?? ANY help would be appreciated, Thanx -steve ------=_NextPart_000_0059_01C4B5CD.2DB31250 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have a few examples and things are = quite clear=20 with using a datareader (reading data, naming column headers = etc.), and=20 populating a listview.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However: (!!!) In all of the examples = we know=20 beforehand the number of fields and therefore the data type (Int, Date, = String=20 etc) since the SELECT string is constant.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>My problem is with variable strings = that get=20 constructed at runtime. Then, since i do not know beforehand what = exactly is my=20 first,second, etc. field, I CANNOT use :</FONT></DIV> <DIV> <P><FONT face=3DArial size=3D2>myDataReader.GetString(0) or = myData.GetInt32(0),etc.=20   since io do not know the type beforehand.</FONT></P> <P><FONT face=3DArial size=3D2>Is there a way around this? I really dont = mind=20 getting them all as text so is the an CType analogous method I could use = .=20 Something like casting BEFORE reading ??</FONT></P> <P><FONT face=3DArial size=3D2>ANY help would be appreciated,</FONT></P> <P><FONT face=3DArial size=3D2>Thanx</FONT></P> <P><FONT face=3DArial size=3D2>-steve</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P></DIV></BODY></HTML> ------=_NextPart_000_0059_01C4B5CD.2DB31250-- Tag: DataSet - DataColumn MaxLength Tag: 97570
  - 10
    - Syntax error in UPDATE statement - field name "Upper", or "Lower" I am getting "Syntax error in UPDATE statement" if one of the fields in a table of Access database (2000, or 97) has the name "Upper" or "Lower". As soon as I change the name of the field to something else, the code works fine. I looked through the list of reserved names, and I could not find the words "Upper" and "Lower". In order to reproduce this behavior, please create a database "Lookup.mdb" with one table "Test" which contains 2 fields of type "Text". The name of one of the fields should be "Upper", or "Lower". Populate the table with any entries you want. After that create a Windows Forms app and add a Windows Form. Use the code of the Windows Forms class Update1.vb below. Change the constant LOOKUP_DBPATH appropriately. Run the app. Click the button "Get Lookup Test". The datagrid should be populated with values from table "Test". Edit the content of a cell under the filed "Upper" or "Lower". Click the button "Update Lookup Test". An exception should be raised. You may want to set breakpoints in the routines "OnRowUpdating" and "OnRowUpdated". The environment is: Visual Studio 2003; Windows XP Prof; Windows Forms App; Microsoft Access 2000 database. ================================= The code: #Region " Imports " Imports System Imports System.Data Imports System.Data.OleDb #End Region Public Class Update1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents grdLookup As System.Windows.Forms.DataGrid Friend WithEvents btnGetLookup As System.Windows.Forms.Button Friend WithEvents btnUpdateLookup As System.Windows.Forms.Button <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.grdLookup = New System.Windows.Forms.DataGrid Me.btnGetLookup = New System.Windows.Forms.Button Me.btnUpdateLookup = New System.Windows.Forms.Button CType(Me.grdLookup, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'grdLookup ' Me.grdLookup.DataMember = "" Me.grdLookup.HeaderForeColor = System.Drawing.SystemColors.ControlText Me.grdLookup.Location = New System.Drawing.Point(6, 8) Me.grdLookup.Name = "grdLookup" Me.grdLookup.Size = New System.Drawing.Size(346, 166) Me.grdLookup.TabIndex = 0 ' 'btnGetLookup ' Me.btnGetLookup.Location = New System.Drawing.Point(370, 10) Me.btnGetLookup.Name = "btnGetLookup" Me.btnGetLookup.Size = New System.Drawing.Size(114, 22) Me.btnGetLookup.TabIndex = 1 Me.btnGetLookup.Text = "Get Lookup Test" ' 'btnUpdateLookup ' Me.btnUpdateLookup.Location = New System.Drawing.Point(370, 40) Me.btnUpdateLookup.Name = "btnUpdateLookup" Me.btnUpdateLookup.Size = New System.Drawing.Size(114, 22) Me.btnUpdateLookup.TabIndex = 2 Me.btnUpdateLookup.Text = "Update Lookup Test" ' 'Update1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(492, 181) Me.Controls.Add(Me.btnUpdateLookup) Me.Controls.Add(Me.btnGetLookup) Me.Controls.Add(Me.grdLookup) Me.Name = "Update1" Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen Me.Text = "Update1" CType(Me.grdLookup, System.ComponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub #End Region <STAThread()> Public Shared Sub Main() Application.Run(New Update1) End Sub Private m_Conn As OleDbConnection Private m_openedConnection As Boolean Private m_sql As String Private m_adap As OleDbDataAdapter Private m_build As OleDbCommandBuilder Private m_dt As DataTable Const conAccess As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;" Const conAccess1 As String = "Data Source=" Const LOCALDB_PATH = "E:\SMW\TestUpdates\Lookup.mdb" Private Sub Update1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Try m_openedConnection = OpenConnection(m_Conn) Catch ex As Exception Debug.WriteLine(ex.Message) End Try End Sub Private Sub Update1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing Try Call CloseConnection(m_Conn) Catch ex As Exception Debug.WriteLine(ex.Message) End Try End Sub Private Sub btnGetLookup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetLookup.Click Dim gotLookup As Boolean Try m_sql = "SELECT * FROM Test" m_dt = New DataTable m_dt.TableName = "Test" gotLookup = GetDataTableForEditAndUpdate(m_sql, m_Conn, m_adap, m_dt) grdLookup.Text = "Test" grdLookup.DataSource = m_dt AddHandler m_adap.RowUpdating, _ New OleDbRowUpdatingEventHandler(AddressOf OnRowUpdating) AddHandler m_adap.RowUpdated, _ New OleDbRowUpdatedEventHandler(AddressOf OnRowUpdated) Catch ex As Exception Debug.WriteLine(ex.Message) End Try End Sub Private Sub btnUpdateLookup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdateLookup.Click Dim updated As Boolean Try updated = UpdateLookupTableBackToLocalDB() Catch ex As Exception Debug.WriteLine(ex.Message) End Try End Sub Public Function OpenConnection(ByRef conn As OleDbConnection) As Boolean Try If conn Is Nothing Then conn = New OleDbConnection conn.ConnectionString = conAccess & conAccess1 & LOCALDB_PATH End If Catch ex As Exception OpenConnection = False Debug.WriteLine(ex.Message) Exit Function End Try Try If conn.State = ConnectionState.Closed Then conn.Open() End If OpenConnection = True Catch ex As OleDbException Debug.WriteLine(ex.Message) OpenConnection = False End Try End Function Public Sub CloseConnection(ByRef conn As OleDbConnection) Try If Not conn Is Nothing Then If conn.State = ConnectionState.Open Then conn.Close() conn.Dispose() End If End If Catch ex As Exception Debug.WriteLine(ex.Message) Finally conn = Nothing End Try End Sub Public Function GetDataTableForEditAndUpdate(ByVal sql As String, _ ByVal conn As OleDbConnection, _ ByRef adap As OleDbDataAdapter, _ ByRef dt As DataTable) As Boolean Try adap = New OleDbDataAdapter(sql, conn) m_build = New OleDbCommandBuilder(adap) adap.FillSchema(dt, SchemaType.Source) adap.Fill(dt) GetDataTableForEditAndUpdate = True Catch ex As Exception Debug.WriteLine(ex.Message) GetDataTableForEditAndUpdate = False End Try End Function Private Function UpdateLookupTableBackToLocalDB() As Boolean Try Me.Cursor = Cursors.WaitCursor With m_adap .Update(m_dt.Select(Nothing, Nothing, DataViewRowState.Deleted)) .Update(m_dt.Select(Nothing, Nothing, DataViewRowState.ModifiedCurrent)) .Update(m_dt.Select(Nothing, Nothing, DataViewRowState.Added)) End With UpdateLookupTableBackToLocalDB = True Catch ex As Exception Debug.WriteLine(ex.Message) UpdateLookupTableBackToLocalDB = False Finally Me.Cursor = Cursors.Default End Try End Function Protected Sub OnRowUpdating(ByVal sender As Object, _ ByVal args As OleDbRowUpdatingEventArgs) Debug.WriteLine(args.Command.CommandText) If args.Errors Is Nothing Then ' Else Debug.WriteLine(args.Errors.Message) Debug.WriteLine(args.Errors.Source) End If Debug.WriteLine(args.Status.ToString) End Sub Protected Sub OnRowUpdated(ByVal sender As Object, _ ByVal args As OleDbRowUpdatedEventArgs) Debug.WriteLine(args.Command.CommandText) If args.Errors Is Nothing Then ' Else Debug.WriteLine(args.Errors.Message) Debug.WriteLine(args.Errors.Source) End If Debug.WriteLine(args.Status.ToString) End Sub End Class -- Igor Gegusin Tag: DataSet - DataColumn MaxLength Tag: 97567
  - 11
    - OracleClient exception... Hey guys, I'm stumped on this... Today I was asked to look into coverting our ODBC access to a Oracle database to the client that microsoft wrote and have come up against the lovely "ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'MSG_DATAREAD' " message... All I'm doing is converting the code from the stuff that's using OdbcConnection/Command etc to OracleConnection/Command etc so I know the stored procedure's all work fine. Here's the code that's failing: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' get a reader for the record set with this msg number Dim dbcommand As OracleCommand = New OracleCommand dbcommand.Connection = dbData dbcommand.CommandType = CommandType.StoredProcedure dbcommand.CommandText = "MSG_DATAREAD" ' get a cursor out Dim param As OracleParameter = New OracleParameter param = dbCommand.Parameters.Add("RC1", OracleClient.OracleType.Cursor) param.Direction = ParameterDirection.Output ' pass in the msg number Dim msgnumParam As OracleParameter = New OracleParameter msgnumParam = dbcommand.Parameters.Add("MsgNumber", OracleType.VarChar, 50) msgnumParam.Direction = ParameterDirection.Input msgnumParam.Value = NullToBlank(m_szCurrentMsgNumber) Dim dbReader As OracleDataReader = dbcommand.ExecuteReader While dbreader.Read ' do some stuff with the data I get back End While dbreader.Close() ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Here's the Stored Procedure it's calling: /* Stored procedure MSG_DATAREAD ------------------------------------------- */ ( MsgNumber IN VARCHAR2 DEFAULT NULL, RC1 IN OUT Omwb_emulation.globalPkg.RCT1 ) AS MsgNumber_ VARCHAR2(50) := MsgNumber; StoO_selcnt INTEGER; StoO_error INTEGER; StoO_rowcnt INTEGER; StoO_crowcnt INTEGER := 0; StoO_fetchstatus INTEGER := 0; StoO_errmsg VARCHAR2(255); StoO_sqlstatus INTEGER; BEGIN NULL; /*[SPCONV-ERR(6)]:(set DATEFORMAT) Manual conversion required*/ OPEN RC1 FOR SELECT MsgNumber , MsgItem , Section , Field , Data FROM MSG_Data WHERE MsgNumber = MSG_DATAREAD.MsgNumber_ ORDER BY MsgItem ; END MSG_DATAREAD; Tag: DataSet - DataColumn MaxLength Tag: 97559
  - 12
    - problem with the dataset update Hi, I have notice something with the datagrid update i have an application which is updated from multiple sources when one user deletes a row on the datagrid, the delete propgates back to the database. I see it is gone, from the database. but, when other users app calls it's fill command to refresh it's datatable, It sees the already deleted row. what am i doing wrong? Tag: DataSet - DataColumn MaxLength Tag: 97556
  - 13
    - Setting Textbox to Null for DateTime I have a textbox on a windows form which is bound to a smalldatetime field in a Dataset. The problem is that sometimes this date should be deleted so that a null value gets written back to the database. However, if I delete this date and leave the Textbox the previous entry gets retrieved. Is there a way to prevent this from happening and leaving the textbox empty so that a null value gets written back to the database when update is called? Tag: DataSet - DataColumn MaxLength Tag: 97551
  - 14
    - Date/Time in Access I'm having trouble storing the value of Now in an Access table. I'm using VB.NET 2002. I need to store a time value, but no matter what I do I end up getting just a date value in Access. I'm doing something like this: Dim NewRow as DataRow = MyTable.NewRow NewRow("InTime") = Now MyTable.Rows.Add(NewRow) DataAdaptor.Update(MyTable) The value of CDate(NewRow("InTime")) is correct until I refresh the dataset with data from the database. All I get is the correct date and a time of 12:00:00. I've tried using every possible format of Date/Time in Access, including my own custom format. Thanks for the help Tag: DataSet - DataColumn MaxLength Tag: 97550
  - 15
    - Delete datarowview objects from a dataview Hi all, I have a problem when attempting to delete datarowview obecjts from a data view Dim mydv As New DataView Dim thisDRV As DataRowView mydv.Table = myDS.Tables("CountedItem") mydv.RowFilter = "ilID = '" & lID & "'" For Each thisDRV In mydv thisDRV.Delete() Next When I execute this code I get an IndexOutOfRangeException exception. However, if I print the first column of the datarowviews they all exist. Dim mydv As New DataView Dim thisDRV As DataRowView mydv.Table = myDS.Tables("CountedItem") mydv.RowFilter = "ilID = '" & lID & "'" For Each thisDRV In mydv debug.writeline(thisDRV(0)) Next Is there something funny happeneing with the deleting of a datarowview from a dataview? Is this the correct way to delete a subset of rows from a datatable? Many thanks, Jason. Tag: DataSet - DataColumn MaxLength Tag: 97546
  - 16
    - Convert string to sqldbtype This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C4B5C4.ECD8DFB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there another easier way to convert a string to a sqldbtype than = using a select case, as in: Namespace ADOHelper Public Class sqldbtype Public Shared Function Convert(ByVal type As String) As = System.Data.SqlDbType Select Case type Case "int" Return System.Data.SqlDbType.Int Case "NVarChar" Return System.Data.SqlDbType.NVarChar Case "VarChar" Return System.Data.SqlDbType.VarChar Etc ......... ------=_NextPart_000_0008_01C4B5C4.ECD8DFB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Is there another easier way to convert = a string to=20 a sqldbtype than using a select case, as in:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <P><FONT face=3DArial size=3D2>Namespace ADOHelper<BR>    = </FONT><FONT face=3DArial size=3D2>Public Class = sqldbtype<BR>   =20     </FONT><FONT face=3DArial size=3D2>Public Shared = Function=20 Convert(ByVal type As String) As = System.Data.SqlDbType<BR>   =20         </FONT><FONT face=3DArial = size=3D2>Select Case=20 type<BR>           =20     </FONT><FONT face=3DArial size=3D2>Case=20 "int"<BR>           =20         </FONT><FONT face=3DArial = size=3D2>Return=20 System.Data.SqlDbType.Int<BR>       =20         </FONT><FONT face=3DArial = size=3D2>Case=20 "NVarChar"<BR>           =20         </FONT><FONT face=3DArial = size=3D2>Return=20 System.Data.SqlDbType.NVarChar<BR>       =20         </FONT><FONT face=3DArial = size=3D2>Case=20 "VarChar"<BR>           =20         </FONT><FONT face=3DArial = size=3D2>Return=20 System.Data.SqlDbType.VarChar<BR>      &nbs= p;         Etc=20 .........</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C4B5C4.ECD8DFB0-- Tag: DataSet - DataColumn MaxLength Tag: 97544
  - 17
    - Populate SQL table with a dataset all in one It's possibile to populate a SQL table with a dataset without throw all rows in datatable but in one query? Thanks -- Filippo Macchi www.filippomacchi.it Tag: DataSet - DataColumn MaxLength Tag: 97542
  - 18
    - How to use DACW with Scope_Identity for a usable DataSet? How do you use 'Data Adapter Configuration Wizard' (DACW) with an Insert stored procedure that uses 'Scope_Identity' and get a usable DataSet? When my Insert stored procedure looks like this: Note the [@@IDENTITY] =================================================== CREATE PROCEDURE dbo.CustomerInsert ( @FName char(10), @LName char(10) ) AS SET NOCOUNT OFF; INSERT INTO Customer(FName, LName) VALUES (@FName, @LName); SELECT ID, FName, LName FROM Customer WHERE (CustID = @@IDENTITY) GO =================================================== Then the Dataset created by the DACW results in the following properties for CustID: AllowDBNull = FALSE AutoIncrement = TRUE AutoIncrementSeed = 0 AutoIncrementStep = 1 ReadOnly = TRUE Unique = TRUE This results in a dataset that works for successfully adding records to the table. However? when my Insert stored procedure looks like this: Note the [SCOPE_IDENTITY] =================================================== CREATE PROCEDURE dbo.CustomerInsert ( @FName char(10), @LName char(10) ) AS SET NOCOUNT OFF; INSERT INTO Customer(FName, LName) VALUES (@FName, @LName); SELECT ID, FName, LName FROM Customer WHERE (CustID = SCOPE_IDENTITY()) GO =================================================== Then the Dataset created by the DACW results in the following properties for CustID: AllowDBNull = FALSE AutoIncrement = FALSE AutoIncrementSeed = 0 AutoIncrementStep = 1 ReadOnly = TRUE Unique = TRUE This results in a DataSet that CANNOT successfully add new records to the table. I get the following error: =========================================== Error when committing the row to the original data source ------------------------------------------------------- Column 'CustID' does not allow nulls. Do you want to correct the value? [Yes][No] =========================================== Tag: DataSet - DataColumn MaxLength Tag: 97537
  - 19
    - A bug in Data Adapter Configuration Wizard (VB.Net for SQLS2k) == Description == VB.Net will unfaithfully represent primary keys when they are identified as an IDENTITY field for SQL Server tables. I will make these mistakes when producing Insert Stored Procedures and when producing DataSets. It will NOT make these mistakes when the field is 'ID', but it WILL create these mistakes when the field is named other than 'ID' for example 'CustID'. The mistakes in the Insert Stored procedure are: ? The id will not be recognized as an IDENTITY ? The id will be included as a parameter to be assigned a value by the user ? The id will be included in the insert into statement and the Values statement (as if a value will be assigned to it by the user) ? The id will be included in the select statement of the insert stored procedure ? The WHERE statement of the Insert stored procedure will have a parameter for the id equal to its parameter (CustID = @CustID) not (CustID = @@IDENTITY) The mistake in the DataSet is: ? The id field's AutoIncrement property is set to FALSE This mistake will be seen in the DataGrid: ? The ID will shown as NULL ? You will not be able to enter data into the table I can provide instruction on how to duplicate this error. Tag: DataSet - DataColumn MaxLength Tag: 97536
  - 20
    - Datagrid column labels are clipped. Has anyone else had this problem? Right-justified column labels have the rightmost 1-2 pixels clipped off. So a label like "Ship Date" only shows half of the 'e'. Left-justified labels are displayed just fine. Thanks in advance. John John@nospamViridianTech.com Tag: DataSet - DataColumn MaxLength Tag: 97535
  - 21
    - OracleClient and OCI.dll I'm getting this error when I run, but I'm able to connect and get data from adapter in design mode. What's my problem please. [DllNotFoundException: Unable to load DLL (oci.dll).] System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) System.Data.OracleClient.OracleConnection.Open() Filter.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\aspnet_client\filter\webform1.aspx.cs:29 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() Tag: DataSet - DataColumn MaxLength Tag: 97531
  - 22
    - MDAC -- error enumerating data servers I'm having a problem using the Database wizard in Visual Studio 2003 (Academic version) to connect in a very basic way (not even any code yet) to SQLEXPRESS, the only available version of SQL Server 2005 out so far. I was running MDAC 2.7 XP SP 1 on Windows XP Pro and thought that maybe pulling down a recent refresh for 2.7 might help (it didn't). So I went ahead and upgraded to 2.8 and still have the error message 'error enumerating data servers'. I know my databases are up and running because my management console tells me so. The whole environment is local to my machine and I don't think it's a permission problem. I'm wondering if maybe the fact that Studio runs on .NET framework 1.1 and SQL Server 2005 express is running on framework 2.x might be part of the problem but have no information so far that confirms for me that trying to run Visual Studio on framework 2.x will improve the situation. Component Checker was showing me just a few MDAC mismatches on 2.7 but 2.8 is showing heavy mismatches ... too many to mention and I couldn't say which ones are relevant anyway (but no change to the error message so if something else is broken I'm not suffering from it yet). When I search for oledb32.dll in the registry, I can't find it (though it is in my file system) so I'm having trouble figuring out how to register it if it isn't there now ... Many thanks for any help. -- thank you, Stephanie Tag: DataSet - DataColumn MaxLength Tag: 97527
  - 23
    - problems with datatable update Hi, I have a datatable which is bound to a database table. the table has a primary key on 1 field and i am using the machine generated statements from the sql data adapter. here is the scenario two users are using different instances of the application if I use the dataset.fill command, i can propogate changes made by one user, to another user. however, if a user deletes one of the primary keys, and inserts another in it's place, the other users datatable has a phantom row. has anyone noticed this problem and what is a good workaround thanks Tag: DataSet - DataColumn MaxLength Tag: 97525
  - 24
    - Bad variable type exception I have made this function to create a command object to be used to call a Stored Procedure: Public Overrides Function GetStoredProcedureCommandObject(ByVal cn As ADODB.Connection) As ADODB.Command '* Create a command objekt to call SP Dim cmd As New ADODB.Command() Dim prm As ADODB.Parameter cmd.ActiveConnection = cn cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc cmd.CommandTimeout = 15 cmd.CommandText = "LEVE_Lev" prm = cmd.CreateParameter("nLev", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput) MsgBox("Me.Lev=" & Me.Lev) prm.Value = Me.Lev cmd.Parameters.Append(prm) Return cmd End Function The parameter is declared as int, and Me.lev contains the value 812 I don't understand why I get the following exception: ************** Exception Text ************** System.Runtime.InteropServices.COMException (0x80020008): Bad variable type. at ADODB._Parameter.set_Value(Object pvar) at ADODB.InternalParameter.set_Value(Object value) at SugroBR.LeverandÃ¸r.GetStoredProcedureCommandObject(Connection cn) at SugroData.SugroDataObjekt.GetData(Boolean bClose) Tag: DataSet - DataColumn MaxLength Tag: 97517
  - 25
    - The way ADO retreives parameters from SQL Server I have a question to which I hope someone has the answer. We have developed an application that queries a database a great deal and speed is crucial. We do all database operations utilizing stored procedures and return the information in parameters since there would be only one row anyway. We have noticed some interesting timing that is causing us problems in the overlying process this applciation supports. By using Windows high performance timers to measure the performance we have learned that sometimes we'll have long delays (When I say long delay I mean between 150 to 600 mS.) waiting for the ExecuteNonQuery to return. Other times (a little more rare) we would have a long delay getting the parameters back after the ExecuteNonQuery returned. Of course we try to retrieve the SQLParameters as soon as the ExecuteNonQuery returns. That delay is measured from the time the ExecuteNonQuery returns and the first SQLParameter is read out of ADO. The time needs to stay below 100 mS. The delay doesn't happen very often about once in every 100 or so attempts. We are putting performance timers in SQL Server to determine the times the stored procedures uses for processing and examining when the server recompiles its stored procedures. So now for the question. We are concerned with the delay ADO is giving us when we attempt to call the SQLParameters collection. Do the parameters return to ADO on a background thread that is spawned when the ExecuteNonQuery returns complete from the stored procedure? If not does anyone know what might account for these infrequent delays that we are seeing? We are using Framework 1.1 SP 1. Any help will is greatly appreciated. Rob Tag: DataSet - DataColumn MaxLength Tag: 97514
- Next
  - 1
    - Problems with DATASET.WriteXml: I get two files (XML and XSD) Hi Newsgroup, I have a really suspicious problem: I want to write the data of a Dataset to a XML-File, wich should include then schema of the data. For this I'm using the method DATASET.WriteXml("FILENAME" + ".xml" , System.Data.XmlWriteMode.WriteSchema). As result I get two files: a) XML-File : FILENAME.xml, of course containing the data and a reference to b) b) XSD-File : FILENAME_app1.xsd , containing the schema. When I'm changing the overloaded WriteXml-method to try a work around over a XMLTextWriter I get the same result. What can be the reason for this behavior ? How can I solve this problem ? How can I get an XML-File with an inline schema ? Many thanks in advance Jan -- Jan Schoenrock, Hamburg, Germany Tag: DataSet - DataColumn MaxLength Tag: 97510
  - 2
    - Reading timestamp value form Sybase DB I'm trying to read the timestamp value from the DB into a template column within a datagrid. The issue I'm having is that the value displayed is "System.Byte []". Do I have to do any operations to get it in this format -> "0x000100000139d595" which is the format it's in the DB. Thanks, Tag: DataSet - DataColumn MaxLength Tag: 97507
  - 3
    - SELECT procedure - ALL for integers Hello, How can I create stored procedure with clause "where integer=ALL" that would return all the values. select * from tblA where integer = ALL I cannot use like in this procedure and because this is integer I cannot use ALL. Thank you Arek *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: DataSet - DataColumn MaxLength Tag: 97504
  - 4
    - EXCEL.EXE process doesn't die after ADO.NET connection Hi everyone, In a recent post I ask about a problem: >If I open a .NET application from EXCEL using SHELL function, when I close >EXCEL, the EXCEL.EXE process remain active and I must close it by Task >manager. Today I have deepened the problem, and this is the new scenario: 1) I open "MyWorkbook.xsl" file with EXCEL; 2) In my worksheet I open a .NET application using SHELL function; 3) The opened .NET Application perform an ADO.NET Connection and a Query from "MyWorkbook.xsl" workbook. 4) After perform the query, the connection and all the ADO.NET object involved will be closed and disposed; 5) Now I close my .NET application; 6) If now I close Excel, the UI quit but the process EXCEL.EXE remain active and I must close it by the Task Manager. I suppose that the ADO.NET Connection, in some manner, remain opened or locked and lock my workbook... So, how I can unlock the situation ? Any ideas? Thanks in advance. Lorenzo Melato Tag: DataSet - DataColumn MaxLength Tag: 97500
  - 5
    - Updating Source Data in ADO.NET (Continued) I'm still having trouble getting the updates to work. I read the row in from the dataset and bind it to a textbox. When the user hits a Save button, I have code to perform the update, but nothing gets Updated. No errors, just no update. Here is the Code I am using to read and Update an Access Table called CUSTOMERS with 2 columns: CUSTID, and CUSTNAME First is the code to set up the connections: Public odbc_conn As String = "PageTimeout=5;DSN=MS Access Database;DefaultDir=C:\testdb;DriverId=25;DBQ=C:\testdb\Access_MGSDATA.mdb;FIL=MS Access;MaxBufferSize=2048;UID=admin" Dim daCustomers As Odbc.OdbcDataAdapter Dim dsCustomers As DataSet Dim dtCustomers As DataTable Dim mgscust As New Odbc.OdbcConnection(odbc_conn) Dim strSQL As String = _ "SELECT * FROM Customers where Custid = '000007' order by Custid" Dim ocmd As New Odbc.OdbcCommand(strSQL, mgscust) Then I have this code in the Form Load event daCustomers = New Odbc.OdbcDataAdapter(ocmd) dsCustomers = New DataSet daCustomers.Fill(dsCustomers, "Customers") dtCustomers = dsCustomers.Tables(0) TextBox1.DataBindings.Add("Text", dtCustomers, "Custid") TextBox2.DataBindings.Add("Text", dtCustomers, "Custname") Finally When the user hits a Save Button I have thiis code on it's event: strSQL = "UPDATE Customers SET Custid = '" & TextBox1.Text & "'" & _ ",Custname = " & TextBox2.Text & " where Custid ='000007'" Dim ucmd As New Odbc.OdbcCommand(strSQL, mgscust) daCustomers.UpdateCommand() = ucmd daCustomers.Update(dsCustomers, "Customers") The load works fine, but When I hit the Save button after updating the Custname textbox, nothing happens. Can you tell me what is wrong with the code. What am I missing? Thanks Tag: DataSet - DataColumn MaxLength Tag: 97499
  - 6
    - VB.Net connection to a Kronos database on the AS/400 I would like to retrieve data stored in a Kronos database located on an AS400. I'm assuming there is a connection string that will allow me to connect and retrieve data with the appropriate data adaptor. Any help would be appreciated. Tag: DataSet - DataColumn MaxLength Tag: 97493
  - 7
    - Batched Update in .NET 2.0 Would you say that in Yukon/.NET 2.0, it would be better to pass in the entire dataset changes in all of the related parent-child tables - as a dataset - into the Yukon CLR? That way you could have the cake and eat it too viz, have a complex relation-ed dataset and yet be able to acheive the update in one shot to the Yukon Sql Server. Which brings up another question - why do people not use too much of that approach by sending updategrams into Sql 2000 using SqlXml? Of the above two approaches, which one would you recommend, and why? - Sahil Malik You can reach me thru my blog - http://www.dotnetjunkies.com/weblog/sahilmalik Tag: DataSet - DataColumn MaxLength Tag: 97487
  - 8
    - UpdateBatchSize Hi, In .NET 2, is there any way to batch multiple DataSet updates like the ones that occur on a windows form editing a parent and a child table? This means at least 4 calls to TableAdapter.Update plus multiple round trips to the server while the TableAdapter traverses each row and updates/adds/deletes it. Thanks, Juan Tag: DataSet - DataColumn MaxLength Tag: 97479
  - 9
    - Access DataBase on PocketPC Hello, In eVB I made a simple application for my PocketPC (2003) that made connection with a (converted) access database. I'm now trying to write the same application in VB.NET. I just can't figure out how to make the connection with the database. I tried connecting with the use of a connection-string, but it seems this is not supported for writing applications for a SmartDevice. The syntax "Imports System.Data.OleDb" is also not allowed for a SmartDevice application. Can someone give me a clue please....... Douwe Tag: DataSet - DataColumn MaxLength Tag: 97476
  - 10
    - Timeout expired - Server not responding - OPC/C#/SQL Server I recently inherited support for a C# application that communicates with SQL Server and some OPC devices. Unfortunately, I don't have access to the required version of the source code (working on this aspect), so I'm having problems troubleshooting the following problem: The application intermittently returns this error message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." for the System.Data.SqlClient.SqlCommand.ExecuteReader and ExecuteNonQuery methods. This error occurred about two weeks ago, and although I performed a variety of modifications, the ones that seemed to restore the application's stability included freeing up some hard drive space, backing up the SQL server database, and clearing up some OPC configuration problems (not sure if the restored functionality was coincidence???). The application then operated as desired for approximately two weeks when suddenly it started timing out again (according to support techs, nothing has changed - the application just started returning these errors out of the blue). Typical operation is to collect data from the OPC devices and store it in the SQL Server database every 1-5 seconds (depending on configured polling rate) and the amount of data being transferred isn't extremely high. Communication to the OPC devices appears to be stable (confirmed through third-party OPC client testing), and when the errors occur, they occur approximately every other polling cycle. I've done some preliminary research on the internet, but there seem to be many variations of this problem. BizTalk, I believe, even has a .dll to address this type of problem. Does anyone have any ideas on some things to try? I realize that this may be hard to track down for a variety of reasons, but I'm open to suggestions. The application server is running W2K SP4 with SQL Server 2000 and .NET framework 1.0. Thank you, Curt Tag: DataSet - DataColumn MaxLength Tag: 97474
  - 11
    - output param returns array this code below returns an int array (length=8) from the sql server 2K proc. I have NO idea why... any suggestions? ---------------------------------------------------------------------------- Address a = address; SqlParameter[] param = new SqlParameter[12]; int x = 0; AddParam(param, "@p_AddressTypeId", a.AddressTypeID, x++); AddParam(param, "@p_POBox", a.POBox, 50, x++); AddParam(param, "@p_AddressCO", a.CareOf, 50, x++); AddParam(param, "@p_Address", a.AddressLine1, 50, x++); AddParam(param, "@p_AddressLine2", a.AddressLine2, 50, x++); AddParam(param, "@p_City", a.City, 50, x++); AddParam(param, "@p_USState", a.USState, x++); AddParam(param, "@p_Province", a.Province, 50, x++); AddParam(param, "@p_PostalCode", a.PostalCode, 10, x++); AddParam(param, "@p_ZIP4", a.ZIP4, 4, x++); AddParam(param, "@p_CountryId", a.Country, x++); AddParam(param, "@p_AddressId", null, x); param[x].Direction = ParameterDirection.Output; ExecuteNonQuery(CommandType.StoredProcedure, "prAddressAdd", param); object val = param[x].Value; <== object is array!!!! ---------------------------------------------------------------------------- create PROCEDURE prAddressAdd @p_AddressTypeId TINYINT ,@p_POBox VARCHAR(50) ,@p_AddressCO VARCHAR(50) ,@p_Address VARCHAR(50) ,@p_AddressLine2 VARCHAR(50) ,@p_City VARCHAR(50) ,@p_USState TINYINT ,@p_Province VARCHAR(50) ,@p_PostalCode VARCHAR(10) ,@p_ZIP4 VARCHAR(4) ,@p_CountryId INT ,@p_AddressId INT OUTPUT AS SET @p_AddressId = NULL INSERT INTO tb_ADDRESS( AddressTypeId ,POBox ,AddressCO ,Address ,AddressLine2 ,City ,USState ,Province ,PostalCode ,ZIP4 ,CountryId ) VALUES( @p_AddressTypeId ,@p_POBox ,@p_AddressCO ,@p_Address ,@p_AddressLine2 ,@p_City ,@p_USState ,@p_Province ,@p_PostalCode ,@p_ZIP4 ,@p_CountryId ) SET @p_AddressId = SCOPE_IDENTITY() ---------------------------------------------------------------------------- Thanks for the help! Tag: DataSet - DataColumn MaxLength Tag: 97470
  - 12
    - Using OleDBParameter in a simple UPDATE statement I am afraid I am not understanding at all how OleDbParameters work (I am new to SQL) ... the simple code below fails with E_ABORT: OleDbParameter p = catCMD.CreateParameter(); p.ParameterName = "val2"; p.OleDbType = OleDbType.Integer; p.Value = 8; catCMD.Parameters.Add(p); catCMD.CommandText = "INSERT INTO MyTable (val1,val2) VALUES (5,?);" catCMD.ExecuteNonQuery(); [Not sure what's the role of the ParameterName actually, I would have thought that all that matters is the position of the parameter in the params collection, as matching the "?" I am targetting.] Help :-)! Patrick PS: this is with MySQL 4.1 as the database Tag: DataSet - DataColumn MaxLength Tag: 97466
  - 13
    - ExecuteReader requires an open and available Connection. The connection's current state is Closed. (Type your message here) -------------------------------- From: renu Friends, when I am trying to create a login page and connecting to the sqlserver database I am getting the following error ExecuteReader requires an open and available Connection. The connection's current state is Closed. and mycode is Dim strconn As String Dim strsql As String Dim command As SqlCommand Dim i As Integer Try strconn = "server =(local);trusted_connection=yes;database=consultants;" Response.Write("connection ok") Dim conn As New SqlConnection(strconn) strsql = "select count(*) from consul_login where uname='" & txtUname.Text & "'and pword='" & txtPassword.Text & "'" command = New SqlCommand(strsql, conn) conn.Open() Catch ex As Exception Response.Write(ex.Message) End Try i = command.ExecuteScalar() If i <> 1 Then Response.Redirect("e:\dotnet\authenticationdenied.aspx") Else Response.Redirect("e:\dotnet\timesheet.aspx") Response.Redirect("timesheet?n1" & txtUname.Text) End If can anybody help me out? thanks renu ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>DpcjgwYOwUyoDPoc0J25SQ==</Id> Tag: DataSet - DataColumn MaxLength Tag: 97458
  - 14
    - Fire query on DataSet DataSet is supposed to be an in-memory database=2E So is it= possible to fire a query on it=2E I want to fire a "Select" query= (with alises in it) and also a "Transform" (Crosstab) query=2E In= the current scenario I am putting things in an Access table but= for performance reasons want to deal with in-memory contents=2E Thanks in advance=2E -------------------------------- From: Arun Gupta ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>Z/hkOkwnv0uFZGAK+STeoQ=3D=3D</Id> Tag: DataSet - DataColumn MaxLength Tag: 97457
  - 15
    - Can't get record to insert into Access I have a windows service that will insert records into an Access= database=2E Or at least that's the idea=2E The insert isn't= happening, but the code runs without raising any errors=2E When I= run the generated sql statement from a query window in Access,= the record inserts just fine=2E Can anyone help me? string sqlInsert =3D "INSERT INTO checks( PageNo, Template,= OriginFile, TargetFile, MICR, Account, Routing, CheckNumber,= CheckDate, CheckAmount, ScanBatchNum ) VALUES( '{0}', '{1}',= '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}'= )"; StringBuilder sb =3D new StringBuilder(); using( OleDbConnection cn =3D new OleDbConnection( m_ConnString )= ) { =09cn=2EOpen(); =09using( OleDbCommand cmd =3D new OleDbCommand( "", cn ) ) =09{ =09=09foreach( ChecksDS=2EChecksRow row in checkRecords ) =09=09{ =09=09=09sb=2EAppendFormat( sqlInsert, row=2EPageNo, row=2ETemplate,= row=2EOriginFile, row=2ETargetFile, row=2EMICR, row=2EAccount,= row=2ERouting, row=2ECheckNum, row=2ECheckDate, row=2ECheckAmount,= row=2EScanBatchNum ); =09=09=09cmd=2ECommandText =3D sb=2EToString(); =09=09=09cmd=2EExecuteNonQuery(); =09=09=09sb=2ERemove( 0, sb=2ELength ); =09=09} =09} =09cn=2EClose(); } Here's a generated sql statement=2E INSERT INTO checks( PageNo, Template, OriginFile, TargetFile,= MICR, Account, Routing, CheckNumber, CheckDate, CheckAmount,= ScanBatchNum ) VALUES( '3', 'Check', 'C:\Program= Files\FormStorm\urm\Queues\0120040901160314=2Etif', 'C:\Program= Files\FormStorm\URM\ImageExp\090920049091443253=2Etif',= 'A021204005A 0001538C 0404', '021204005', '0001538', '0404',= '', '20=2E00', '09092004909144325' ); I've tried with and without the ending semi-colon=2E What am I= missing? Thanks -------------------------------- From: Drew Burlingame ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>zvskhpv3zUqGe0ifvzh0ZQ=3D=3D</Id> Tag: DataSet - DataColumn MaxLength Tag: 97456
  - 16
    - OleDBCommand.ExecuteScalar() always returns 0 I am running MySQL 4.1 Gamma on WinXP under VS 2003 / ADO.NET and trying to use the OleDb ExecuteScalar() method (as opposed to the DataReader) and consistently failing - getting 0 always. Here is the code: catCMD.CommandText = "SELECT count(*) from MyTable;" long N = (long)catCMD.ExecuteScalar(); N is always 0, even though there are rows in the table. As a side issue, I find it rather painful to guess the type of data items returned by the OleDb objects ... initially I had: int N = (int)catCMD.ExecuteScalar(); This caused an exception - as if C# can't handle a conversion from int64 to int32 ... Thanks! Patrick Tag: DataSet - DataColumn MaxLength Tag: 97447
  - 17
    - OleDbCommandBuilder, ImportRow, DataTable.Copy() etc. etc. etc. I'm sure everyone's sick of DataSet, OleDbDataAdapter.Update(), INSERT INTO etc. etc. questions in this group, but I've been scanning the usually insta-problem solving Google Groups for hours now and I just can't seem to find a similar situation to mine. I'm trying to accomplish something that I thought would be easy enough: 1. Run a query on a table producing a DataSet of the data I want to replace 2. Delete all said data 3. Insert another DataSet full of records back into the table 4. Actually have the changes to the database friggin _UPDATE_. The trick is, and for reasons I won't bother getting into here, I need to use OleDbCommandBuilder to do the work instead of what otherwise would be a trivial SQL statement. The step I'm having trouble with is #3... and well, I suppose #4. What I'm discovering is that it's extremely difficult to get the OleDbCommandBuilder to notice when changes have been (are being?) made to the DataSet. I can manually DataRow.BeginEdit() make changes, EndEdit() and everything updates fine, so there's no problem with my peripheral code. I've tried the following ways of getting data from one DataSet (newDataSet) to the other (dsDBData), all to no avail: // Row-by-row copy attempts: foreach (DataRow curRow in newDataSet.Tables["Items"].Rows) { dsDBData.Tables["Items"].NewRow(); // #1 dsDBData.Tables["Items"].Rows.Add(curRow); // ERROR: row is already in another table // #2 dsDBData.Tables["Items"].Rows.Add(curRow.IndexArray); // ERROR: OleDbException (?) // #3 dsDBData.Tables["Items"].ImportRow(curRow); // RESULT: Data not updated (DataRowState is imported and thus "Unchanged") } // Whole table attempts: // #4 DataTable tmpTable = dsDBData.Tables["Items"]; // tmpTable = newDataSet.Tables["Items"].Copy(); // RESULT: Data not updated (?) The closest I seem to get is with #2 wherein an actual UpdateCommand is built by the OleDbCommandBuilder, but alas a pesky and vague OleDbException gets thrown. Apologies for the verbose post on what I originally thought would be an extremely simply problem to solve. Hopefully there is a quick answer out there somewhere about something I'm just missing. Thanks in advance. Tag: DataSet - DataColumn MaxLength Tag: 97445
  - 18
    - Sequential date-time data and ado.net I'd appreciate some general advice on using ado.net in a VB.net environment for a particular application: I need to store a large series of instrument-generated data for later retrieval and analysis and a database (probably Access to start with for ease-of-development, but maybe a more scalable DBMS later) seems to offer a number of advantages in being able to retrieve data flexibly. But because this is a rather different type of application from most business databases, I'm struggling a little for relevant advice. The idea is that new records will be created at defined time intervals (eg every 10mins, but conceivably as often as every minute) over potentially long periods of time, eg a year or more. So, in extremis, we could be looking at a million records or more, though 100 000 might be more typical. Each record will have its own explicit DateTime stamp as a column and records will be mostly retrieved by datetime so this column would be made the primary index. The records will be added to the database only in strict time sequence, though the processes of data collection and record creation may be decoupled, ie new data records created and added potentially in a batch some time after actual data collection. The database will probably only need to be queried by one or two users at a time. That's the background, but a couple of questions, one general and one specific: Q1 The general one is whether anyone would disagree with the use of database such as Access or MSDE for this type of application. I don't want to get too hung up on the exact choice of database right now. Provided eg MSDE could do the job ultimately and Access is adequate for smaller scale prototyping then I can live with that. It's more the principle of using an established database tool here rather than creating eg a custom binary file structure and having to explicitly code the update and query procedures where I'd appreciate any comments. Q2 One specific task will be to find out the datetime stamp for the last record previously added prior to doing the next update of the database. Not being an experienced database programmer I'm concerned that the brute force approach to doing this could be very slow. In other words, if I just ask for the MAX value of the datetime column is the database going to have to look through all of eg a million records to find the answer? Or are they cleverer than that and maybe maintain a separate index of eg min/max values, ie so a column MAX can be quickly returned? Or alternatively is there some other way of returning the datetime column value for the last record previously added? JGD Tag: DataSet - DataColumn MaxLength Tag: 97438
  - 19
    - ComponentOne DataObjects Hello Anybody has experience with ComponentOne DataObjects? Are they recommended as an extention to ADO.NET and to reduce time in developing data access objects? I have to migrate an access project with about 30 Tables and many realations to .Net. Thanks Marco Tag: DataSet - DataColumn MaxLength Tag: 97431
  - 20
    - Operation must use an updateable query I start ASP.net i have sample of Sams book it's Update SQL. but i got this ERR Operation must use an updateable query ERR In Line 42: nRowsAffected = cmd.ExecuteNonQuery(); !!!!!!!!!!! Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query. i tried my computer and in my Host !!!!!!!! it's very simple Source: ----------------------------------------------------------- OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Program Files\\Microsoft Office\\" + "Office\\Samples\\Northwind.mdb;" + "User ID=;Password=;"); con.Open(); OleDbCommand cmd = new OleDbCommand("Update Products Set UnitPrice = " + Price.Text + " where ProductName = '" + Name.Text + "'", con); int nRowsAffected = 0; nRowsAffected = cmd.ExecuteNonQuery(); con.Close(); ------------------------------------------- and i just finde one qoute in MSDN and try to explain this problem is for access97 but i have accessXP in both my computer and my HOST Tag: DataSet - DataColumn MaxLength Tag: 97423
  - 21
    - OleDbConnection, OleDbCommand and OleDbDataReader (one at a time?)... Hi NewsGroup, Hope this is the right news group for this. Programming data access code in C#, .NET Framework 1.1, using OleDb classes. As an example I'm doing something similar as such; Keeping it brief sorry about syntax... OleDbConnection oledbcon = new OleDbConnection(dataSource); OleDbCommand oledbcmd = oledbcon.Command(cmdText, commandType); //commandType=StoredProcedure oledbcmd.Parameters.Add("id", 5) OleDbReader oleread = oledbcmd.ExecuteReader(); if (oleread.HasRows) { OleDbCommand oledbcmd_2 = oledbcon.Command(cmdText, commandType); //commandType=StoredProcedure while(oleread.Read()) { oledbcmd_2.Parameters.Add("filterID", oleread.GetInt32(0)); oledbcmd_2.ExecuteNonQuery(); <----*******BANG (See below)********* oledbcmd_2.Parameters.Clear(); } } The rest is thoughtfully disposed of... I'm told by InvalidOperationException class that there's already an OleDbDataReader opened for the connection, close it before attempting another. Two questions, 1) Does .NET consider, int OleDbCommand.ExecuteNonQuery() a reader in a way? Despite returning an int. Can I only have one OleDbDataReader per OleDbConnection occuring at a time? Many Thanks and kind regards, SpotNet. Tag: DataSet - DataColumn MaxLength Tag: 97422
  - 22
    - A few thousands simple queries seem to clog SQL server (for a while) I am using the VS.NET 2003 OleDB objects and C# against MySQL 4.1 Gamma on Windows XP. The summary of the problem is this: I am doing a series of queries (no updates) using the OleDB DataReader, and after a few thousands queries, the SQL server seems to be clogged and starts failing all requests. Then, after a minute or two, things return to normal. It is as if my series of queries exhausted a resource on the server which time heals. I am a newcomer to OleDB and SQL so it is possible that I am misusing the OleDB .NET objects. Or am I expecting too much from MySQL? Details below. After successfully running a few thousands queries of the type: OleDbCommand catCMD = DatabaseConnection.CreateCommand(); catCMD.CommandText = SELECT t1.mysum FROM (SELECT SUM(negative) AS mysum FROM myTable WHERE time >='2003-08-22 16:00:00') AS t1; myReader = catCMD.ExecuteReader(); at some point, the ExecuteReader command stops working, with no specific error: System.Data.OleDb.OleDbException: No error information available: E_FAIL(0x80004005). at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() Note that I am always closing any DataReader I am using, but leaving the OleDBConnection open (and sometimes also reuse the OleDbCommand object on it). The first error materializes at random times (but always after a fair number of queries, maybe 10,000). When that first error happens, most subsequent queries fail as well, including attempts to re-open the connection to the database. Even a completely different application talking directly to the server, such as the mysql utility, stops working (fails to connect to the database). Then, usually, waiting a few minutes helps and things get back to normal. I went so far as inserting a 5 minutes delay in my code any time I would get an error ... and it completely solves the problem (although hardly a real-life solution)! I would appreciate feedback on: - is this likely to be a problem with my code? I mean, should ANYTHING I do in my code cause a separate application like mysql.exe to fail? - is it a MySQL 4.1 Gamma robustness issue? Should I stay away from MySQL for "serious" applications? - as I mentioned, nothing I am trying to do in the program at the point of error seems to help (except sleeping for a couple of minutes) - MySQL seems to be simply unreachable for a while, busy dealing with memory leaks or whatever. But for the more normal cases in the future where such an error could be transient, any good practices (such as closing + re-opening the connection to the database? Much obliged, Patrick Tag: DataSet - DataColumn MaxLength Tag: 97411
  - 23
    - Unable to Update with DataGrid I been trying (all day) to update a record with the DataGrid. .NetFramework 1.1 VS 2003 Ent. Table Name (SQL Server 2000) Users: Columns: Uid = int UserName = varchar (255) passwordHash = varchar (40) salt = varchar (10) Role = Varchar (40) FName = varchar (50) LName = varchar (50) DataGrid Name = dataUsr I run a StoredProcedure to get the columns Uid, UserName, Role, FName, LName only. Here is my UpdateCommand Codebehind: (Template Columns) BEGIN Sub Dim Uid As String = dataUsr.DataKeys(CType(e.Item.ItemIndex, Integer)) Dim txtRole As TextBox = CType(e.Item.Cells(3).FindControl("Role"), TextBox) Dim Role As String = txtRole.Text Dim txtFName As TextBox = CType(e.Item.Cells(4).FindControl("FName"), TextBox) Dim FName As String = txtFName.Text Dim txtLName As TextBox = CType(e.Item.Cells(5).FindControl("LName"), TextBox) Dim LName As String = txtLName.Text Dim txtUserName As TextBox = CType(e.Item.Cells(6).FindControl("UserName"), TextBox) Dim UserName As String = txtUserName.Text Dim DS As DataSet Dim objDB As New DBAccess.DAOObject Dim sample As Integer ' Run the StoredProcedure to Update the Table. sample = objDB.RunSPReturnInteger("UpdateUsers", New SqlParameter("@Uid", Uid), New SqlParameter("@Role", Role), New SqlParameter("@FName", txtFNameBox.Text), New SqlParameter("@FName", txtFNameBox.Text), New SqlParameter("@LName", txtLNameBox.Text), New SqlParameter("@UserName", txtUserNameBox.Text)) dataUsr.EditItemIndex = -1 BindGrid() END Sub Each time I receive the error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Index is always 0 when debugging. What am I doing wrong!!!!!!!!!!!!!!!!!! HELP! -Troy Tag: DataSet - DataColumn MaxLength Tag: 97410
  - 24
    - How notice user, that this record has change by another user? Under ADO.NET and SQL 2000 I build form that edit data, and i use with wizard to create Update query. What happen in this situation?: I read record into DataSet. The user 1 change value an field A in the record. Meanwhile, user 2 change and commit the same record in field B. Now the first user makes commit. I suppose that field B is become again as original value! If it is correct, what method I got to resolve this problem? How notice user, that this record has change by another user? Tag: DataSet - DataColumn MaxLength Tag: 97409
  - 25
    - DataGrid selecting rows My task is a little more complicated than that because of my user requirements. In my app I have made the DataGrid read only because there is concern that the users will inadvertently delete rows. I need the Delete to be a two-step process in which the user selects rows on the datagrid and then clicks a button to confirm that the selected rows will be deleted. So, my challenge is just to identify the rows that are selected and then pass these rows to a procedure for deletion. I thought I could do this with the IsSelected property but it doesn't seem to be working. Tag: DataSet - DataColumn MaxLength Tag: 97408

If I create a DataSet in the Visual Studio IDE, how do I specify the
MaxLength of a DataColumn?

Once I specify the MaxLength, I want to bind the DataSet to controls on my
Windows Form (TextBox controls). Will the MaxLength of the bound TextBox
automatically sync with the bound DataColumn? If not, how do I sync the two?

Thanks

Top

Re: DataSet - DataColumn MaxLength by Miha

Miha
Fri Oct 22 09:51:26 CDT 2004

Hi,

No, it won't be automatically synced.
You should do it manually.

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

"rparrella" <rparrella@discussions.microsoft.com> wrote in message
news:4DB61EF8-0BD7-42B7-ACE9-774090728FD3@microsoft.com...
> If I create a DataSet in the Visual Studio IDE, how do I specify the
> MaxLength of a DataColumn?
>
> Once I specify the MaxLength, I want to bind the DataSet to controls on my
> Windows Form (TextBox controls). Will the MaxLength of the bound TextBox
> automatically sync with the bound DataColumn? If not, how do I sync the
> two?
>
> Thanks

Top