Determining field type CHAR vs VARCHAR

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
    - How to execute SP with type of Table.. Guru's, I have oracle sp with the below types defined, and my sp uses these types for outparameter, i am using DAAB. Need to know how to execute this kind of SP. highly appreciate if you can get me solution for this.. Thanks in advance.. ------- TYPE SECTTABTYPE IS TABLE OF VARCHAR2(5) INDEX BY BINARY_INTEGER; TYPE MCHTABTYPE IS TABLE OF VARCHAR2(7) INDEX BY BINARY_INTEGER; TYPE NUMTABTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; ------------ PROCEDURE GET_CAP( P_SECTIONS IN VARCHAR2, P_NUM_DAYS IN NUMBER, P_PROC_ALL_MCHS IN VARCHAR2, P_SECTS OUT SECTTABTYPE, P_MCHS OUT MCHTABTYPE, P_RQDS OUT NUMTABTYPE, P_PLANCAPS OUT NUMTABTYPE) IS --some code ******** // .Net code for executing SP using DAAB.. DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("dcp_PKG.get_cap"); dbCommandWrapper.AddInParameter("P_SECTIONS", DbType.String, section); dbCommandWrapper.AddInParameter("P_NUM_DAYS", DbType.Int32,NumDays); dbCommandWrapper.AddInParameter("P_PROC_ALL_MCHS", DbType.String, Mac); dbCommandWrapper.AddOutParameter("P_SECTS", DbType.String,20); dbCommandWrapper.AddOutParameter("P_MCHS", DbType.String,24); dbCommandWrapper.AddOutParameter("P_RQDS", DbType.Int32,4); dbCommandWrapper.AddOutParameter("P_PLANCAPS", DbType.Int32,4 ); //Execute the stored procedure db.ExecuteDataSet(dbCommandWrapper); Tag: Determining field type CHAR vs VARCHAR Tag: 130870
  - 2
    - Any way to avoid using SP_EXECUTESQL in ADO.NET? Hi, Our development team has encountered some performance problems when using ADO.NET (using the SqlCommand and SqlDataAdapter objects) to perform queries on large data tables. We've drilled into the issue considerably, and the problem seems to be related to how ADO.NET uses the SP_EXECUTESQL when running text queries. I say this because when we run our query in Query Analyzer by itself the performance is less than a second, but when running it with the SP_EXECUTESQL command (which is what Profiler is telling us is being used), it takes nearly half a minute. >From what I know about SP_EXECUTESQL, it uses dynamic cursors to execute the command it is given. Our query involves User Defined Functions (UDFs) that call UDFs, Group By statements, and Aggregate functions that are not necessarily good for dynamic cursors (or at least that is what I have heard), so the issue seems to make sense. Anyways, what I was wondering was whether or not there is a way to have ADO.NET run our query without using SP_EXECUTESQL. If this is not possible, then I am interested in knowing whether or not it is a bad practice to have UDFs calling other UDFs, as opposed to having a larger query that does all the work but is not as reusable. Thanks for your time Tag: Determining field type CHAR vs VARCHAR Tag: 130869
  - 3
    - DataAdapter not updating underlying SQL Database! Help! Thanks in advance! I'm using Visual studio.net 2005 I can't get the underlying table (incoming) to update. I modify the datarows, checking the database before and after running (the code gets several hits while iterating the records), and it doesn't update it. What am I doing wrong? Sub scrubTrackedExclusions() 'Dim contactInfo As New contactStruct Dim sqlFindTracked As New SqlCommand 'Dim sqlUPDATE As New SqlCommand Dim intRec As Integer = 1 Dim dtIncoming As New DataTable Dim dtTracked As New DataTable Dim dtExclusions As New DataTable Dim dtCurrad As New DataTable Dim drvCurrad As System.Data.DataRowView() Dim drvRow As System.Data.DataRow Dim dsCurrent As DataSet = New DataSet Dim dsChanges As DataSet = New DataSet Dim drIncoming As DataRow Dim drTracked As DataRow Dim drExclusions As DataRow Dim dcPK1(0), dcPK2(0), dcPK3(0) As DataColumn Dim i As Integer = 0 Dim strSQL As String = "SELECT * FROM Tradoc.dbo.Incoming WHERE op = 'INSERT' or op = 'UPDATE'; " _ & "SELECT * FROM TRACKED Where Status = 'ACTIVE'; SELECT * FROM EXCLUSIONS; SELECT * FROM CURRAD;" Dim strSqlUpdate As String = "UPDATE [Tradoc].[dbo].[Incoming] SET [cn] = @cn, " _ & "[ou] = @ou, [dn] = @dn, [op] = @op, [adsPath] = @adsPath, [reasonCode] = @reasoncode " _ & "WHERE [targetAddress] = @targetAddress" opensql(1) Dim sqlCMD As SqlCommand = New SqlCommand(strSQL, sqlConnection1) sqlCMD.CommandTimeout = 30 Dim sqlDA As SqlDataAdapter = New SqlDataAdapter sqlDA.SelectCommand = sqlCMD Dim sqlUpdate As SqlCommand = New SqlCommand(strSqlUpdate, sqlConnection1) sqlUpdate.CommandType = CommandType.Text sqlDA.UpdateCommand = sqlUpdate sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100, "CN")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@ou", SqlDbType.VarChar, 400, "ou")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@dn", SqlDbType.VarChar, 400, "dn")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@op", SqlDbType.VarChar, 10, "op")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@adsPath", SqlDbType.VarChar, 400, "adsPath")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@reasonCode", SqlDbType.VarChar, 50, "reasonCode")) sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400, "targetAddress")) sqlDA.Fill(dsCurrent, "Table") dsCurrent.Tables(0).TableName = "Incoming" dsCurrent.Tables(1).TableName = "Tracked" dsCurrent.Tables(2).TableName = "Exclusions" dsCurrent.Tables(3).TableName = "CurrAD" dtIncoming = dsCurrent.Tables("Incoming") dtTracked = dsCurrent.Tables("Tracked") dtExclusions = dsCurrent.Tables("Exclusions") dtCurrad = dsCurrent.Tables("currAD") dcPK1(0) = dsCurrent.Tables("Incoming").Columns("targetAddress") dcPK2(0) = dsCurrent.Tables("Tracked").Columns("targetAddress") dcPK3(0) = dsCurrent.Tables("Exclusions").Columns("targetAddress") 'dcPK4(0) = dsCurrent.Tables("Currad").Columns("targetAddress") dtIncoming.PrimaryKey = New DataColumn() {dtIncoming.Columns("TargetAddress")} dsCurrent.Tables("Incoming").PrimaryKey = dcPK1 dtTracked.PrimaryKey = New DataColumn() {dtTracked.Columns("TargetAddress")} dsCurrent.Tables("Tracked").PrimaryKey = dcPK2 dtExclusions.PrimaryKey = New DataColumn() {dtExclusions.Columns("TargetAddress")} dsCurrent.Tables("Exclusions").PrimaryKey = dcPK3 'dtCurrad.PrimaryKey = New DataColumn() {dtCurrad.Columns("TargetAddress")} 'dsCurrent.Tables("Currad").PrimaryKey = dcPK4 Dim dvCurrad As DataView = New DataView(dsCurrent.Tables("Currad"), "", "targetAddress", DataViewRowState.CurrentRows) 'Example find... ' drFIND = dtTracked.Rows.Find("SMTP:brett.mack@usaac.army.mil") Dim iIndex As Integer = 1 For Each drIncoming In dtIncoming.Rows lblGeneral.Text = "Scrubbing record #: " & intRec & " for Tracking & Exclusions." 'Check & modify info if it's in the tracked database... drTracked = dtTracked.Rows.Find(drIncoming.ItemArray(8).ToString) 'Dim intIndex As Integer = dvAllad.Find(strcn) If Not drTracked Is Nothing Then 'If we get a hit, then check the current contacts db 'for a target address match... drvCurrad = dvCurrad.FindRows(drIncoming.ItemArray(8).ToString) 'Okay, if we get a hit on the targetAddress on the Current 'contacts, check to see if the objectGuid matches. If it matches, 'Go ahead and modify the data and set the op to Update... 'Check if it's empty... If drvCurrad.Length >= 1 Then For i = 0 To drvCurrad.Length 'If not, check for a Guid match.... If drTracked.Item(6).ToString = drvCurrad(i).Row(6).ToString Then 'if it matches, reset the appropriate incoming columns drIncoming.Item(1) = drTracked.Item(1) drIncoming.Item(25) = drTracked.Item(25) drIncoming.Item(26) = drTracked.Item(26) drIncoming.Item(27) = "UPDATE" drIncoming.Item(28) = drTracked.Item(28) drIncoming.Item(29) = "TRACKED" Else 'Not yet implemented End If Next End If drExclusions = dtExclusions.Rows.Find(drIncoming.ItemArray(8).ToString) 'Check & see if the contact is in the Excluded database. If so, then 'go ahead and mark it as excluded; this way it won't be touched. If Not drExclusions Is Nothing Then 'drIncoming.Delete() drIncoming.Item(27) = "EXCLUDED" drIncoming.Item(29) = "EXCLUDED" drIncoming.Item(33) = "EXCLUDED" End If iIndex += 1 intRec += 1 End If Next 'This is where I'm pretty sure it should update everything! dsChanges = dsCurrent.GetChanges If Not dsChanges Is Nothing Then sqlDA.Update(dsChanges, "Incoming") dsCurrent.Merge(dsChanges, True) End If sqlCMD.Dispose() sqlDA.Dispose() 'contactInfo = Nothing lblRejects.Text = "REJECTED " & intRejects & " Records." 'sqlReader.Close() closesql(1) End Sub Tag: Determining field type CHAR vs VARCHAR Tag: 130860
  - 4
    - Help - DataAdapter.Update is not updating Access database Hi all, I'm trying to update a table in an Access database with the records in a table from another Access database that both tables have exact schema. Table one has about 10,000 records and table two usually has 10-20 records. Here is the sample code that works for the most part, but not for the place that changes need to be sent back to the database: 'Table one Dim daGetRecords As New OleDbDataAdapter Dim dsGetRecords As New DataSet daGetRecords.SelectCommand = New OleDbCommand(strSQL, cn) daGetRecords.Fill(dsGetRecords) 'Table 2 from different database, using the same sql statement different conection Dim daRecords As New OleDbDataAdapter Dim dsRecords As New DataSet daRecords.SelectCommand = New OleDbCommand(strSQL, cn2) daRecords.Fill(dsRecords) 'Here I assign primary keys of two tables ' ' 'And merge rows Dim dr As DataRow For Each dr In dsRecords.Tables(0).Rows Dim drow(0) As DataRow drow(0) = dr dsGetRecords.Merge(drow) Next ' I've checked and dsGetRecords has been updated correctly. ' I'm ready to send changes back to the database. ' And this is the place that I'm having problem daGetRecords.Update(dsGetRecords) Please comment: 1. Why update method of dataadapter is not updating database? 2. Is there a better way to do the whole process? Thanks in advance, Roy Tag: Determining field type CHAR vs VARCHAR Tag: 130859
  - 5
    - Adding column description to Access table, HOW? Hi I'm trying to add a column and it's description to an Access table using the following code: objTable.Columns.Append("RefId", adInteger) objTable.Columns("RefId").Properties("Description").Value = "Reference Id" however I get the following exception: "Item cannot be found in the collection corresponding to the requested name or ordinal." Looking at the Column using a debugger, I can see that the column doesn't contain anything in the Properties collection... But how do I add a Description to this collection ?? TIA Søren Tag: Determining field type CHAR vs VARCHAR Tag: 130856
  - 6
    - Async Database methods with a Oracle or Postgres The ADO.NET 2.0 SqlDataProvider provides a nice set of async methods to perform database access. Unfortunatly this is the only database provider that I can find that supports these. Is anyone aware of an Oracle implementation that provides Begin/End versions of the Execute Methods? I need a real implementation of this, something similar to the SqlClient approach - so that callbacks happen on IOCP threads and threadpool threads aren't sitting blocked in a Wait the entire time a db operation is pending. It's somewhat surprising that Microsoft didn't provide this generically in the ADO.Net infrastructure, but rather grafted it directly into the SqlDataProvider. -- Chris Mullins Tag: Determining field type CHAR vs VARCHAR Tag: 130851
  - 7
    - How to Send XML to client I am using VS2005 to develop Asp.Net program. I use the codes below to create a XML stream: How can I set the Stream to client? //----------------------------------------------------------------------------- MemoryStream sm= new MemoryStream(); dsHealth.WriteXml(sm); Tag: Determining field type CHAR vs VARCHAR Tag: 130849
  - 8
    - Foreign key constraints from DB at runtime I'm trying to figure out how to discover foreign key constraints at runtime by asking the database. All the code samples I see in .NET have you manually create the foreign key constraints. I'm trying to detect them from the database's schema. I'm working with MySQL4.1. When I query the database, I get my UniqueConstraints but I don't get my ForeignKeyConstraints, and wondered if anyone knew how to do it. In my program, the business objects are associated in the database with a main table, and collections within this object are associated by foreign key constraints to other tables. So say I have an object, User. It's associated with the table "user", which is identified by a unique integer key, ObjectId. It contains no foreign key constraints. A User can belong to any number of Groups, and a Group can contain any number of Users, so I have a "groups" table keyed by its own integer ObjectId. It also contains no foreign key constraints. Connecting the two is a "usergroups" table, also keyed by integer ObjectId, and all it contains is two foreign keys. "UserId" refers to "user.ObjectId" and "GroupId" refers to "groups.ObjectId". My code looks like this: StringBuilder sb = new StringBuilder(); sb.Append( "SELECT * FROM " ); sb.Append( strTableName ); using ( OdbcCommand cmd = new OdbcCommand( sb.ToString(), connection ) ) { using ( OdbcDataAdapter da = new OdbcDataAdapter() ) { da.SelectCommand = cmd; // Get the schema for this table and add // the schema for any foreign key tables to the // dataset DataTable table = new DataTable( strTableName ); da.FillSchema( table, SchemaType.Source ); ds.Tables.Add( table ); foreach ( Constraint constraint in table.Constraints ) { if ( constraint is ForeignKeyConstraint ) { ... do stuff... } } } } When you run this code on the "usergroups" table, which has two foreign key constraints, no ForeignKeyConstraints exist. I have my UniqueConstraint on UserId but that's it. If I look in the debugger, table.Constraints.Non-Public members.fLoadForeignKeyConstraint is false, which looks like the culpret. Do I need to set this flag to give me the foreign key constraint? If I do, how do I do it? I see there's the DataTable.ParentRelations and ChildRelations properties but I haven't tried using them because I think they just access the ForeignKeyConstraints. I figured if there are no ForeignKeyConstraints in the collection, I'm going to get the same results if I rip out my code and rewrite it to use DataRelations. Does anyone know how to do this? Thanking you for in advance for your time and thoughts. Shelah Tag: Determining field type CHAR vs VARCHAR Tag: 130846
  - 9
    - Driver's SQLAllocHandle on SQL_HANDLE_ENV failed I'm trying to connect to an R:Base database on my machine. I created a system DSN using the R:Base provider which connects fine. In my project, I can browse the database by adding this connection in the server explorer so I know it connects just fine. However, when trying to use an ODBCConnection in my app, I get the following error when using the open() method on the connection: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed I was thinking that this was some sort of security error, but I gave the ASPNET account security access to the *.RBx files and even the *.dll provider files. Can anybody shed some light? Tag: Determining field type CHAR vs VARCHAR Tag: 130843
  - 10
    - Connection timeout - Sleeping Processes - Connection Pools? Why oh Why Hi Everyone, I have a problem with a system in production. Basically we are getting timeouts on getting a connection from the connection pool... I will give the background now... We have a Web Server and a Database Server with the below configurations. Web Server Win2k3 IIS6 Database Win2k3 Sql Server 2000 (8.00.2039 - SP4) We use MSMQ on the Web server to do message processing... So we have one HTTP Application sending messages to another HTTP Application. Lets call the first one MessageSender HTTP Application and the other the MessageProcessor HTTP Application. So we have asynchronous Queue Listeners in the MessageProcessor Application, and to make sure we never get overwhelm with messages I have implemented a thread counting approach to make sure we never have too many threads running at one... At the moment I have set the maximum to 5. Each thread calls a stored procedure on the Database... Anyway for some freak reason... the queue listener stopped listening... and we had a backlog of 8000 messages on one queue... When we restarted the MessageProcessor the queue listener was throttles so no more than 5 threads could run and after about 300 or so messages basically it took up the whole connection pool and then started throwing exceptions... I managed to stop the QueueListener before it brought down the whole application... And I had these observations ... There were similar amounts of "sleeping" processes which only ever disappeared when the Application Pool in IIS was recycled or after a considerable amount of time (I am assuming Garbage Collection Kicked in). So the simple answer is that we are not closing the connections... well we went through the whole application and all of the connections are closed... we tried a close and a dispose call on the connections...Which started throwing the below error (even though we do not reuse connection objects in each thread). ExecuteReader requires an open and available Connection. The connection's current state is Closed So we do not know where to look to next... What could be causing the connections to be held and not reused in the connection pool, is it linked with the sleeping processes? Any Help would be muchly appreciated... Regards Mark Tag: Determining field type CHAR vs VARCHAR Tag: 130840
  - 11
    - Proper resource deallocation through Dispose() Hi All, Trying to get a grip on the proper deallocation of unmanaged resources. I asked some general questions in another group, here's my ADO question: If I call Dispose on a DbDataAdapter, for example, am I correct in understanding that it will dispose of the DbConnection that it uses? This statement in the .Net 2.0 documentation for DbDataAdapter.Dispose() seems to imply that it does: "Releases all resources used by the Component". It would appear that I'm going to run into problems in this scenario: I have a single DbConnection as an instance variable in a class. Within that class, I have a method that creates, and then disposes of, a DbDataAdapter that uses this connection. The second time I call that method, it will fail because the disposal of the adapter also disposed of the connection (as opposed to just closing it). Or am I totally misinterpreting the documentation? Tag: Determining field type CHAR vs VARCHAR Tag: 130836
  - 12
    - generating crystal report from multiple tables hi all, i am working on a MS.access project, in this i need to generate a report from multiple tables. I have used stored queries for operation on database tables how to do generate Crystal report from multiple tables?. Regards, sai Tag: Determining field type CHAR vs VARCHAR Tag: 130834
  - 13
    - Prevent DataRow Deletion Hi! Scenario: A User deletes a row in a DataTable; a MessageBox comes up and asks if he/she really wants to delete the row; in case the answer is "no", the row deletion should be cancelled. There are straightforward solutions for this scenario when an intelligent control like the DataGridView is used, because such control exhibits a "UserDeletingRow" event that provides a CANCEL property to be set to TRUE. But in case no such control is used, I cannot see a clear solution. I have searched the newsgroups for this, and I find two proposals: 1) Use the RowDeleted event of the DataRow by calling DataRow.RejectChanges(). I admit this to be a feasible solution, but it has nasty side effects, like: - the row will first be deleted and only then be "un-deleted" - including possible child rows (possibly several generations of them), that also have to be un-deleted - after the delete, a lot of other actions occur, like position changes, for example, that also have to be undone I conclude that using RowDeleted is not a good a solution (and I guess that the architects of the DataGridView would agree, because they provided something better). 2) Use the RowDeleting event of the DataRow. This looks better, because the RowDeleting event is called before the row is actually deleted. But - helas - this event doesn't have a CANCEL property. In the newsgroups I found a solution based on this idea by David Sceppa (whom I truely admire), which goes like this (I cite): *******David Sceppa speaking****** You could trap for the RowDeleting event and call the DataRow's RejectChanges method if you do not want to allow the deletion. You could also throw an exception if that's appropriate in your application. Here's some sample code I used to accomplish this task: DataTable tbl = new DataTable(); tbl.Columns.Add("CustomerID"); tbl.Columns.Add("CompanyName"); tbl.LoadDataRow(new object[] {"Comp1", "Company #1"}, true); tbl.RowDeleting += new DataRowChangeEventHandler(DeleteHandler); Console.WriteLine(tbl.Rows.Count); try { tbl.Rows[0].Delete(); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine(tbl.Rows.Count); static void DeleteHandler(object sender, DataRowChangeEventArgs e) { e.Row.RejectChanges(); throw new Exception("Deletion disallowed"); } I hope this information proves helpful. *******End of Citation ******* The point here seems to be to throw the exception. As far as I can see, RejectChanges() doesn't do anything, because at this point in time, the row to be deleted still has a RowState of "Unchanged" (this is what my debugger tells me), and you cannot reject a change that has not yet taken place. In David's example, to throw an exception does the job, because the row is deleted *programmatically*, and hence, there is a point where the exception thrown can be caught. But what can I do when the row is deleted by a user action, like, pressing the Delete button on a BindingNavigator? I have no idea where I could catch the exception thrown. Does anybody have an idea? Thanks for any hints. Axel Hecker Tag: Determining field type CHAR vs VARCHAR Tag: 130828
  - 14
    - Copy all records from access MDB to others via ADONET I'm generating an MDB or XLS or CSV from an access database (MDB) I want to copy all records in the query over to the newly created database and (empty) table. I seen: http://www.w3schools.com/sql/sql_select_into.asp which only shows a basic select into.. Assume i have two connections open, the xls table i can create if it's a must. I wanted to use alias fieldnames so the target may have a different fieldname. Possibly even the target tablename could be different, while this is not an issue yet. Any idea? (besides some dumb and slow row/col loop) Remember, from MDB to XLS e.o.. Tag: Determining field type CHAR vs VARCHAR Tag: 130826
  - 15
    - Migration Dear All, What is the relevant way of migration of ASP to ASP.net Tag: Determining field type CHAR vs VARCHAR Tag: 130825
  - 16
    - run multiple SQL statement in OleDbCommand Hello: I am using 2 datagrid in a master-detail, now if I want delete a record in master, I should delete all child record of this master record before I delete the master. I don't know how to run mutiple SQL statement in my custom OleDbCommand? I really appreciate your help. here is the code: Dim cmdDelete As New OleDbCommand("DELETE FROM detail WHERE id = ?", _myUtilDB.irraConnection) 'Dim cmdDelete As New OleDbCommand("DELETE FROM master WHERE id = ?", _myUtilDB.irraConnection) With cmdDelete.Parameters.Add("@p1", GetType(Double)) .SourceColumn = "id" .SourceVersion = DataRowVersion.Original End With _da.DeleteCommand = cmdDelete Tag: Determining field type CHAR vs VARCHAR Tag: 130816
  - 17
    - Unspecified error OLEDB Hello, I developed an export to Excel that runs in an ASP.NET 1.1 page (code-behind). Sometimes, when calling the Open() method of the OLEDB connection to Excel, an "Unspecified Error" occurs. I have the impression that it has to do with some security on IIS, but cannot figure out exactly what it is. Has anyone encountered any problem and found a solution for the above problem? Thanks. Mike Tag: Determining field type CHAR vs VARCHAR Tag: 130811
  - 18
    - No dataview item property This was initially posted on the C# forum and was meant to be cross-posted here. Noting first that I'm coming from VS2003 and VB.Net to C# and VS2005 ... Using an untyped dataset, I create a dataview. When I try to use the Item property, "Item" does not appear on the Intellisense dropdown and I also get the build error "'System.Data.DataView' does not containt a definition for 'Item'." The documentation for VS2005 does show Item as a property of a dataview -- can anyone see the issue? DataView dvContacts = new DataView(ds.Tables["dtContacts"]); int intCounter = dvContacts.Count; for (intCounter = 0; intCounter < -1; intCounter++) { intContactID = System.Convert.ToInt32(dvContacts.Item(intCounter).Column["ContactID"]); ... } Tag: Determining field type CHAR vs VARCHAR Tag: 130810
  - 19
    - DataRelation left outer join different database types Hello, I'm trying to create an application that reads data from two tables, where the one table is stored in a MySQL database (Table 1) and the other is stored in SQL Server (Table 2). I need all the data from table 1 that doesn't exist in table 2, in other words I want to left outer join table 1 on table 2. I prefer not to use the linked server functionality or import the MySQL data into SQL Server. Is it possible to solve this using ADO.NET, for instance using the DataRelation? It seems like the DataRelation only supports inner joins, however maybe I'm missing parts of the functionality. Best regards, Tag: Determining field type CHAR vs VARCHAR Tag: 130809
  - 20
    - weird connection error This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6A4FD.93E69080 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Name have been changed to protect the innocent.=20 This is the only class that is causing me this issue and I can't figure = out why. Everything before this one loads fine, and the ones after this = load fine. I have checked the underlying tables and the user has proper = permissions. I do not get the error, but I have more permissions than he = does. The other person using the application does not get this error = either, but he has elevated privileges too...I have done everything I = can think of and it is still occurring ... The bit of code that is causing this is simply a matter of loading a new = instantiation of a product class from dsinvmgmt.products.getallproducts. The class that is actually the editor for that class loads before it but = in a different class. So I wouldn't think that would be interfering. = Below is the message of the ex.tostring. --------------------------- System.Data.SqlClient.SqlException: Login failed for user 'DOMAIN\user'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException = exception, Boolean breakConnection) at = System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateOb= ject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, = SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet = bulkCopyHandler, TdsParserStateObject stateObj) at = System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean = enlistOK) at = System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnect= ion owningObject, SqlConnectionString connectionOptions, String = newPassword, Boolean redirectedUserInstance) at = System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIden= tity identity, SqlConnectionString connectionOptions, Object = providerInfo, String newPassword, SqlConnection owningObject, Boolean = redirectedUserInstance) at = System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionO= ptions options, Object poolGroupProviderInfo, DbConnectionPool pool, = DbConnection owningConnection) at = System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbCon= nection owningConnection, DbConnectionPool pool, DbConnectionOptions = options) at = System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection = owningObject) at = System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection = owningObject) at = System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection = owningObject) at = System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection = owningConnection) at = System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection = outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, = DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String = srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, = Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior = behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at = dsInvmgmtDataSetTableAdapters.ProductsTableAdapter.GetAllProducts() in = dsInvmgmtDataSet.Designer.vb:line 16398 at Designers.Plant_Orders_Designer.initializeTables() in = Plant_OrdersDesigner\Plant_Orders_Designer.vb:line 260 ---------------------------------------------------------------------- this is line 260: SetProducts(ProductsTableAdapter.GetAllProducts) ------=_NextPart_000_0006_01C6A4FD.93E69080 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.2900.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><FONT face=3D"Times = New Roman"=20 color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">Name=20 have been changed to protect the innocent. </SPAN></FONT></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><FONT face=3D"Times = New Roman"=20 color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">This=20 is the only class that is causing me this issue and I can't figure out = why.=20 Everything before this one loads fine, and the ones after this load = fine. I have=20 checked the underlying tables and the user has proper permissions. I do = not get=20 the error, but I have more permissions than he does. The other person = using the=20 application does not get this error either, but he has elevated = privileges=20 too...I have done everything I can think of and it is still occurring=20 ...</SPAN></FONT></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><FONT face=3D"Times = New Roman"=20 color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">The=20 bit of code that is causing this is simply a matter of loading a new=20 instantiation of a product class from=20 dsinvmgmt.products.getallproducts.</SPAN></FONT></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><FONT face=3D"Times = New Roman"=20 color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">The=20 class that is actually the editor for that class loads before it but in = a=20 different class. So I wouldn't think that would be interfering. Below is = the=20 message of the ex.tostring.</SPAN></FONT></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><FONT face=3D"Times = New Roman"=20 color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'"></SPAN></FONT> </P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New = Roman'">---------------------------</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New = Roman'">System.Data.SqlClient.SqlException:=20 Login failed for user 'DOMAIN\user'.</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException = exception,=20 Boolean breakConnection)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateOb= ject=20 stateObj)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, = SqlCommand=20 cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet = bulkCopyHandler,=20 TdsParserStateObject stateObj)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean=20 enlistOK)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnect= ion=20 owningObject, SqlConnectionString connectionOptions, String newPassword, = Boolean=20 redirectedUserInstance)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIden= tity=20 identity, SqlConnectionString connectionOptions, Object providerInfo, = String=20 newPassword, SqlConnection owningObject, Boolean=20 redirectedUserInstance)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at=20 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionO= ptions=20 options, Object poolGroupProviderInfo, DbConnectionPool pool, = DbConnection=20 owningConnection)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at=20 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbCon= nection=20 owningConnection, DbConnectionPool pool, DbConnectionOptions=20 options)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection=20 owningObject)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection = owningObject)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection=20 owningObject)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection=20 owningConnection)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at = System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection=20 outerConnection, DbConnectionFactory=20 connectionFactory)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.SqlClient.SqlConnection.Open()</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, = DataTable[]=20 datatables, Int32 startRecord, Int32 maxRecords, String srcTable, = IDbCommand=20 command, CommandBehavior behavior)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32=20 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior=20 behavior)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at System.Data.Common.DbDataAdapter.Fill(DataTable=20 dataTable)</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at dsInvmgmtDataSetTableAdapters.ProductsTableAdapter.GetAllProducts() = in=20 dsInvmgmtDataSet.Designer.vb:line 16398</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'">  =20 at Designers.Plant_Orders_Designer.initializeTables() in=20 Plant_OrdersDesigner\Plant_Orders_Designer.vb:line = 260</SPAN></FONT></I></B></P> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New = Roman'">-----------------------------------------------------------------= -----</SPAN></FONT></I></B></P><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New Roman'"><FONT=20 size=3D2> <P><FONT color=3D#000000 size=3D3>this is line 260:=20 </FONT>SetProducts(ProductsTableAdapter.GetAllProducts)</P> <P> </P></FONT></SPAN></FONT> <P class=3DMsoNormal style=3D"MARGIN-LEFT: 58.5pt"><B><I><FONT=20 face=3D"Times New Roman" color=3Dnavy size=3D4><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 14pt; COLOR: navy; FONT-STYLE: = italic; FONT-FAMILY: 'Times New = Roman'"></SPAN></FONT></I></B> </P></DIV></BODY></HTML> ------=_NextPart_000_0006_01C6A4FD.93E69080-- Tag: Determining field type CHAR vs VARCHAR Tag: 130806
  - 21
    - First Connection To DB2 Hello, I have used mainly Oracle and VS, but now I am taking a crack at DB2. I am using DB2 Mainframe. If I go to the DB2 software which is installed on my machine amd bring up "information center", it brings back the following information. =========================================== About DB2 Administration Tools Environment =========================================== DB2 administration tools level: Product identifier SQL08015 Level identifier 02060106 Level DB2 v8.1.5.540 Build level special_10709 PTF WR21334 =================================== Java development kit (JDK): Level IBM Corporation 1.3.1 =================================== Is there a .Net provider for DB2? I have gone to their web site and I can see a reference to a .Net provided but I am unsure if it is applicable to the version of DB2 which I am using. What do I need to know to determine if I can/should loade the .Net provider for VS 2005? I am able to connect to DB2 using the DSN in the in the "ODBC Data Source Administration window". I am also seemingly able to connect from within VS 2005, but when I click on (+) on the tables object, I get an error message saying "[ERROR] 56072 .. Function not supported by server". Why am I getting this. I have used WinSql and it provides me this information (Table names, attribute names, etc.) just fine(although it takes about 5 minutes to retrieve all of the tables), so why doesn't VS 2005? Tag: Determining field type CHAR vs VARCHAR Tag: 130803
  - 22
    - how to query a .Net(2.0) dataTable? Hello, I pull sql server data into a .Net (2.0) dataTable (vb2005 app) using criteria like CompanyName = '3com%' which will return every variation of '3com' in the source data like '3com inc', '3com Group'.... The rows all contain a recordID column. The recordID column in this datatable will contain non-unique recordIDs. I need to retrieve/extract all distinct/unique recordIDs contained in this resultant dataTable. Is there a method/mechanism to perform this operation on my .Net dataTable from within my application? What is this method/mechanism? Maybe a control or some object? I looked at the dataview object, but that only perfroms sorting and filtering. Or am I limited to have to write an additional query against the source data in the sql server? THe issue here is that the source data tables are very large. I would like to keep the number of calls to the server to a minimum. Ideally, I would like to write a query against the .Net dataTable within the application. Select Distinct recordID From myDataTable Thanks, Rich Tag: Determining field type CHAR vs VARCHAR Tag: 130799
  - 23
    - Selecting Dates for database connection I have a calendar control that I am using to have a person select a date. Then I connect to a database and I want to display anything that is equal to that date or where the date selected is atleast between the start date and end date. I just don't know how I am suppose to get this to work in SQL. Here is my code Dim selectedDate As String = cldrEvents.SelectedDate.ToString("d") Dim sqlConnectionString As String sqlConnectionString = ConfigurationManager.ConnectionStrings("eventsConnectionString").ConnectionString.ToString Dim sqlConnection As New SqlConnection(sqlConnectionString) This below is the part I don't understand. I want selectedDate to be compared between events_startdate and events_enddate. If the selectedDate is between or equal to the events_starttime and events_endtime then display the event. How do I get this to happen? Should I be converting selectedDate to a DateTime object before putting it into the the sql command? Dim sqlCommand As New SqlCommand("", sqlConnection) sqlConnection.Open() Dim sqlReader As SqlDataReader = SqlCommand.ExecuteReader() gdvEvents.DataSource = sqlReader gdvEvents.DataBind() Tag: Determining field type CHAR vs VARCHAR Tag: 130795
  - 24
    - Enterprise Library - DataAccessApplicaitonBlock - Oracle I am using the Enterprise library DAAB in my applicaiton connecting to an Oracle instance, and all works fine on my development box, I can connect to the datbase and perform the functions I require. On my customers machine the connection fails, in the windows event log I get the following messages Data connection failed to open: server=abc.def.com; ORA-06413: Connection not open. In the package I ship to the customer I ship the enterprise library and my code, they have an Oracle 8.1.7 client installed on their server and tns names configured to connect to the server. Is there anything else I should be shiopping to install on their server? The only other difference is that my connection is not a dotted name ie not abc.def.com just abc, but I can't see how that woudl cause a problem. thanks for any help Gil Tag: Determining field type CHAR vs VARCHAR Tag: 130787
  - 25
    - Possible to tweake dataset (de)serialization .NET 2.0-->1.1? I'm getting an error when I try send a dataset from a .NET2.0 proces to a .NET1.1 proces: Type is not resolved for System.Data.Serializationformat, System.Data, .... It appears Microsoft does not support backward compatiblity on datasets in .NET2.0. I have seen more postings on this problem. Setting RemotingFormat of the DataSet to RemotingFormat.Xml does not help. I am investigating whether I can substitute custom (de)serialization in order to work around this. I would like to have some advice whether this is possible and how. Is it for instance possible to add remoting channel sinks to intercept and do your own serialization and deserialization? Any help would be greatly appreciated! Regards, Henk Tag: Determining field type CHAR vs VARCHAR Tag: 130785
- Next
  - 1
    - IsDBNull check -- translation from VB.Net to C# In VB.Net, I often check for a null in a dataview column before assigning a value from that column to a variable: If Not IsDBNull(dvContacts.Item(0).Item("LastName")) Then strLastName = CStr(dvContacts.Item(0).Item("LastName")) Else strLastName = "" End If But I have not figured out how to make the same IsDbNull check in C#. Tag: Determining field type CHAR vs VARCHAR Tag: 130784
  - 2
    - Typed DataSets in VS 2005 > Hi folks, > I created a Business layer which comprised of a type dataset with three > dataTables using the designer in VS 2005. I also created a relation between > table1 and table2; then I created another relation between table2 and table 3 > using the primary keys. > In my presentation layer I created a form and added a datagrid to the form. > After filling the dataTables etc... I set the datasource for the grid. When I > ran the appl. the grid displayed only table2 and table3, instead of a > hierachical relationsip beween table1, table2 and table3. Table2 is a child > of table1 and table3 is a child of table2.... > > Does anyone have any suggestion?? > Did I miss something??? > > Thanks in advance for you help > > RP Tag: Determining field type CHAR vs VARCHAR Tag: 130783
  - 3
    - How to get the connectionstirng form a TableAdapter We have to assign a connection string to a TableAdpater when we desgin a TableAdapter in desgin time. How can I get the connection string in run time? Tag: Determining field type CHAR vs VARCHAR Tag: 130782
  - 4
    - How can we insert a DataTable into database? I have a typed DataSet with a DataTable in it. The structure of the DataTable is from a table in a database. Now I have make the DataTble with about 10 new row. How can I insert the DataTable into database at once? Tag: Determining field type CHAR vs VARCHAR Tag: 130781
  - 5
    - Event: ADO.NET Provider Writer Tech Preview, July 31 - August 2, 2006 Attention ADO.NET provider writers! Microsoft is inviting third party ADO.NET provider writers to take part in our ADO.NET Provider Writer Tech Preview taking place at Microsoft Campus, Redmond, July 31 ? August 2, 2006. Please see details below and respond to me on this as per the mini form. Event: ADO.NET Provider Writer Tech Preview, July 31 ? August 2, 2006 What: The ADO.NET Provider Writer Tech Preview is an opportunity for ADO.NET provider writers to: * - Gain an in-depth understanding of the features planned for the next major release of ADO.NET * - Work with early version of the upcoming August CTP * - Review product plans as well as code * - Meet the Data Programmability team The event is also an opportunity for Microsoft to hear your feedback for this release. The event is geared towards helping provider writers get up to speed on how to enhance their providers to work with the next release of ADO.NET. There will be overviews of the features, but there will also be plenty of time for you to work in small labs to start enhancing your providers. Representatives from the development team will be available at various times during the day to answer questions that arise when working with the tech preview binaries. Attendees will also have the option to review specs and start working with a recent drop of the binaries prior to the event. There will be a more detailed schedule provided to attendees upon your attendance confirmation. All information communicated in this event is covered by a mutual NDA (Non-Disclosure Agreement) that we have in place with your org (or you as an individual). If we do not have an NDA with you or your organization, we will ask you to sign one. When: The 3-day event will take place on Monday July 31 through Wednesday August 2. Where: This event will take place on Microsoft's main Redmond campus. We will provide information for local hotels that offer Microsoft negotiated rates when you respond with your Mini Form (you can find some basic information at http://msdn.microsoft.com/events/pac/hotels/default.aspx) What is covered: Microsoft will provide a continental breakfast and lunches on the campus during the event, as well as one dinner during the week. The cost of travel and lodging is not covered by Microsoft. Please Respond Quickly: Capacity is limited. If we receive interest from more provider writers than we can accommodate, preference will be given to vendors who have previously shipped ADO.NET providers. Please respond to DavidSc@microsoft.com as soon as possible with the information in the Response Mini-Form below. We expect that most provider writers will want to send 2 or 3 representatives. Response Mini Form (one for each attendee): Contact Name: IT or Business Role/Title: Email Address: Phone Number: Please provide some background on your provider: We really hope you can join us for this. We look forward to your response. Best regards, David Sceppa ADO.NET Program Manager Microsoft Corporation Tag: Determining field type CHAR vs VARCHAR Tag: 130780
  - 6
    - Oracle 10g Express, 9i Client & Wireless Enet Hello, Just recently installed 10g Express and the latest release of ODP.net and found an issue or more of a nuisance. Everything works fine except for the connection time to the DB. Using: XP Professional Visual Studio 2003 Oracle 10g Express 9i Client ODB.net I tried to figure out all weekend what was causing the delay in the connection, which takes just over a minute. Decided to give up and just suffer. Yet, today when I get home, I open the vb project and run it. It takes about half a second to connect. It dawned on me that I was not connected to my wireless network at home. So I tried 5 more times with the same results. Then I enabled my wireless card and the connection time returned to about a minute. Also, while at work today (connected to the company wireless network), the connection time was about a second. I'm sure it has something to do with my wireless network, just don't know what. Any thoughts would be appreciated. Here is my connect code. Imports Oracle.DataAccess.Client Public Class ODP Public cn As New OracleConnection #Region "-- Connection to Oracle --" Public Sub New(ByVal User As String, ByVal Password As String, ByVal Source As String) 'Oracle Try Dim cnString As String = "User ID=" & User & _ ";Data Source=" & Source & _ ";Password=" & Password cn.ConnectionString = cnString cn.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Critical, "Open DB Error") End Try End Sub #End Region End Class Tag: Determining field type CHAR vs VARCHAR Tag: 130779
  - 7
    - How to Determine if a Record is Locked All, I have set a transaction lock on an Sql Server 2005 database as below: transaction = connection.BeginTransaction(IsolationLevel.RepeatableRead); I keep the connection and transaction open while processing data (done deliberately). When I launch another application I can read the record that is locked but cannot update the record (which is desired). However the only way I know it is locked is by throwing an exception on the write to the record (also had to wait for the timeout to occur). Is there a way using ADO.NET to query if that record is locked? Thanks in advance. Tag: Determining field type CHAR vs VARCHAR Tag: 130778
  - 8
    - Filling from inside a transaction? How can one fill a DataSet or DataTable from inside a transaction? I'm receiving an exception when the following Fill method is executed. DataTable dt = new DataTable(); OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM dual", conn); da.Fill(dt); ### EXCEPTION ### Execute requires the Command object to have a Transaction object when the Connection object assigned to the Command is in a pending local transaction. The Transaction property of the Command has not been initialized. Tag: Determining field type CHAR vs VARCHAR Tag: 130772
  - 9
    - connection pooling My understanding of ADO.NET connection pooling as it relates to Sql Server is that once a connection is created and opened, behind the scenes ADO.NET adds this connection to a pool of connections with identical connection strings. If a connection is closed in code this does not necessarily mean that the connection is closed in the pool. Connections in the pool stay open based on some other set of parameters which I don't remember much about (neither the exact config settings, nor where the config settings are stored). I do remember that connections in the pool are gradually dropped off (perhaps down to a lower threshold) due to lack of use ... however , the key point is that in a highly scalable app such as a web app , opening a connection in code does not necessarily incur the total overhead. On opening a SqlConnection that has a connection string identical to an available connection in the pool with an identical connection string, the overhead is extremely low. Is the above generally true ? If so, where are the connection pooling config settings stored ? And how have things changed between SS2K and SS05 ? Tag: Determining field type CHAR vs VARCHAR Tag: 130766
  - 10
    - cannot debug on the webserver Seems to me that a lot of people have had this problem. I went through http://www.gotdotnet.com/team/csharp/learn/whitepapers/howtosolvedebuggerproblems.doc but none of the solutions worked. I'm still not able to debug my asp.net app. Any help is welcome... thanks, Tag: Determining field type CHAR vs VARCHAR Tag: 130763
  - 11
    - Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sdsNames' because of security settings. Anyone know what is causing this? I've just deployed a fairly basic site onto a Win 2003 server (ASP.NET 2.0, MS Sql Server 2005). Thanks! Tag: Determining field type CHAR vs VARCHAR Tag: 130756
  - 12
    - ExecuteXmlReader I have a table that has some data that is being read is a column with XML data. It is typed 'text' and the server is running 2000 so I don't have an option to type the column as XML. I would however like to use ExecuteXmlReader but I get an exception indicating that the data must be XML. How do I convince the client that it is XML data? My current query looks like: SELECT XMLSent FROM dbo.OutboundTable WHERE documentTransactionID=xxx AND OrderNumber='yyy' Right now I am doing ExecuteScalar to read the XML string in. It seems silly to read in a large chunk of "string" data, pass it to a MemoryStream, build an XmlReader, and then use that to build an XML document (specifically an XPath document because I want to do some XPath searches on the data). If I can get an XmlReader directly from the SQL query via ExecuteXmlReader it seems more efficient. Is this possible with the data structured as I indicated? I have looked at FOR XML but I have not had good luck yet. Any suggestions? Thank you. Kevin Tag: Determining field type CHAR vs VARCHAR Tag: 130754
  - 13
    - SqlCommand and multiple SQL statements Is the capability of System.Data.SqlClient.SqlCommand to execute more than one SQL statement (two SQL statements in CommandText separated by semicolon and just one Execute call) a supported feature that we can expect to continue to work in the future ? Arne Tag: Determining field type CHAR vs VARCHAR Tag: 130750
  - 14
    - Problem with Login control and web.config Hello everyone, I am desperate to solve this problem. I have built my website using Visual Web Developer. The website works perfectly fine when I test it on my computer. However it doesn't work when I upload to my website and test it over the internet. The website contains a simple login page and another page that is the destination page after logging in. The login page was built using a login control. This is my web.config file: /**********************************************************************/ <?xml version="1.0" encoding="utf-8"?> <configuration> <system.web> <compilation debug="true" /> <authentication mode="Forms" /> <customErrors mode="Off"/> </system.web> </configuration> /**********************************************************************/ I get an error on the login page, sometimes I get the following error: Could not load type System.Web.UI.WebControls.Login from assembly System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. And sometimes I just get a question mark in the error field. Another problem is when I change the top of the web.config file <configuration> to the following <configuration xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0 > The error on the login page changes and specifies that I should set <customErrors mode="Off"/>. But I already have done that in the web,config file. Any help is much appreciated I am really struggling with this. Tag: Determining field type CHAR vs VARCHAR Tag: 130748
  - 15
    - Querying a join (Which method is better?) Hey folks, I have a quiz in my mind... When u have a query that u have 3 ou 4 tables involved (tables), I figure there r 2 solutions: 1) You write a SELECT for capturing fields in just one table, and then, based on values of FKs fields, u then go gathering information (always based on single SELECTs) in other tables. 2) You fire all in once 1 SELECT containing all the joins needed, bringing all the fields needed. Is 1st method so slower than second one? Currently I follow method 1, since my framework I created to abstract data access does not work with joins... Tag: Determining field type CHAR vs VARCHAR Tag: 130747
  - 16
    - Query Help - Distinct Row with Date Portion of a DateTime I have a table with a DateTime column and both the date and time portions of the field are used in the entries. But I want to write a query that'll do the following: Get a list of each distinct DATE from all of the rows of the DateTime column. So, for example, let's say the column is named "PurchaseDate", and some of the values look like: PurchaseDate 1/12/2006 3:25pm 1/12/2006 6:45pm 3/3/2006 12:05am 3/3/2006 1:22am I'd like the result of this query (for this example) to be a list as follows: DistinctDates 1/12/2006 3/3/2006 I know this is more of a SQL question than an ADO question but... help? Alex Tag: Determining field type CHAR vs VARCHAR Tag: 130739
  - 17
    - Vishual Studio.NET 2005 and Vishual Studio.NET 2003 I tried this code" Imports System.Windows.Forms " on VB 2005. My project type was class library. When I compile I had an error massage by saying that this type of code doesn't exists. But when I use the VB 2003 version My class library was sucssesfully compiled. Is there any coding differences between the two versions. Tag: Determining field type CHAR vs VARCHAR Tag: 130737
  - 18
    - Can't Use Typed Dataset from Class Library in .Net 2.0 - Help! I need to have several different applications on a multi-tiered system access a common data infrastructure. I'm trying to store a strongly typed dataset in a class library (dll) which contains resources common to all of the applications. I'm having problems. Right now I've got three projects in a solution. This is all .Net 2.0/C#. 1) asp.net web site. 2) win forms app 3) class library (dll) I've got a typed Dataset in the class library. The asp.net web site is able to reference the DLL and the contained Dataset without any problems. It works perfectly. The win forms app however is having problems. If I manually (programatically) add the data adapter then I can access the data, so I know the connections are good, but when I add it to the "data sources" menu and try to drag a gridview over to the web form, the only thing that shows up is a ClearBeforeFill check box... all of my table columns go away. To add the data source I'm going to Add New Datasource/object, browsing into the dll, and selecting the table data adapter for a specific table. I can see the table columns by adding the Dataset as the DataSource instead, but that doesn't get me anything since I need the adapter to do the work of actually getting the data... Has anybody else experienced this? How can I get my winforms app to properly use the Dataset? Thanks! Tag: Determining field type CHAR vs VARCHAR Tag: 130735
  - 19
    - Why do we serialize business objects ? Why do we serialize business objects? Tag: Determining field type CHAR vs VARCHAR Tag: 130734
  - 20
    - Adding new Strongly typed Row - BindingSource Errors This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6A26B.03227CB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to add a new item to a table based on another item in the = same table. To do this I have the user click on the + button on the = navigator. A form is displayed where they enter the new primary key = information, tell it what type of templated Item to use and then press = ok. In the real world it is adding the row correctly to the database, = however I keep getting binding source errors whether it is positional = errors(no row at position 837) or invalid object errors(you can only add = the same item type to a binding list) depending on how I try rearanging my code it varies the error. Below is = the current itteration of my code. I have also had the = bindingsource_addnew function too ... Hope this is somewhat clear..... Private Sub ProductsBindingNavigatorAddNewItem_Click(ByVal sender As = System.Object, ByVal e As System.EventArgs) Handles = ProductsBindingNavigatorAddNewItem.Click Try fillProductInformation() Me.ProductsBindingsource.MoveLast() Catch ex As Exception End Try End Sub Fill Product information: Private Sub fillProductInformation() Try Me.Product =3D getProductData() If Not IsNothing(Product) Then Me.Products.AddProductsRow(Product) Me.ProductsTableAdapter.Update(Products) End If Catch ex As Exception End Try End Sub GetProductData: Private Function getProductData() As dsInvmgmtDataSet.ProductsRow Dim frm As New NewProductEntryForm Dim dlg As New DialogResult Try frm.ShowDialog() frm.Owner =3D Me dlg =3D frm.DialogResult If dlg =3D Windows.Forms.DialogResult.Cancel Then Return Nothing End If If frm.UseTemplate =3D True Then Product =3D getTemplateData(frm.TemplateProductCode) End If If frm.UseTemplate =3D False Then Product =3D getDefaultData(frm.NewProductCode, = frm.PrePackCheckBox.Checked) End If Catch ex As Exception End Try Return Product End Function Private Function getTemplateData(ByVal pluno As Integer) As = dsInvmgmtDataSet.ProductsRow Dim NewDataRow As dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow Dim Template As dsInvmgmtDataSet.ProductsRow Template =3D Me.Products.FindByPLUNo(pluno) NewDataRow =3D Template With NewDataRow .PLUNo =3D pluno .ProdCode =3D pluno .ItemNo =3D pluno .CustNo =3D 1 End With Return NewDataRow End Function Private Function getDefaultData(ByVal pluno As Integer, ByVal isPrePack = As Boolean) As dsInvmgmtDataSet.ProductsRow Dim NewDataRow As dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow Dim Template As dsInvmgmtDataSet.ProductsRow Try If isPrePack =3D True Then Template =3D = Products.FindByPLUNo(My.Settings.TrayPackDefaultProduct) Else Template =3D Products.FindByPLUNo(My.Settings.IcePackDefaultProduct) End If NewDataRow.ItemArray =3D Template.ItemArray.Clone With NewDataRow .PLUNo =3D pluno .ProdCode =3D pluno .ItemNo =3D pluno .CustNo =3D 1 End With Catch ex As Exception End Try Return NewDataRow End Function --=20 --Eric Cathell, MCSA ------=_NextPart_000_0006_01C6A26B.03227CB0 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.2900.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>I am trying to add a new item to a table based on another item in = the same=20 table. To do this I have the user click on the + button on the = navigator. A form=20 is displayed where they enter the new primary key information, tell it = what type=20 of templated Item to use and then press ok. In the real world it is = adding the=20 row correctly to the database, however I keep getting binding source = errors=20 whether it is positional errors(no row at position 837) or invalid = object=20 errors(you can only add the same item type to a binding list)</DIV> <DIV> </DIV> <DIV>depending on how I try rearanging my code it varies the error. = Below is the=20 current itteration of my code. I have also had the bindingsource_addnew = function=20 too ...</DIV> <DIV> </DIV> <DIV>Hope this is somewhat clear.....</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Private Sub ProductsBindingNavigatorAddNewItem_Click(ByVal sender = As=20 System.Object, ByVal e As System.EventArgs) Handles=20 ProductsBindingNavigatorAddNewItem.Click<BR>  Try<BR> &nbs= p; fillProductInformation()<BR>   Me.ProductsBindings= ource.MoveLast()<BR>  Catch=20 ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> End Sub</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV><STRONG>Fill Product information:</STRONG></DIV> <DIV>Private Sub=20 fillProductInformation()<BR>  Try<BR>   Me.Produ= ct =3D=20 getProductData()</DIV> <DIV> </DIV> <DIV>   If Not IsNothing(Product)=20 Then<BR>    Me.Products.AddProductsRow(Product)<BR>&n= bsp;   Me.ProductsTableAdapter.Update(Products)<BR> &= nbsp; End=20 If<BR>  Catch ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> </DIV> <DIV> End Sub</DIV> <DIV> </DIV> <DIV> </DIV> <DIV><STRONG>GetProductData:</STRONG></DIV> <DIV>Private Function getProductData() As=20 dsInvmgmtDataSet.ProductsRow<BR>  Dim frm As New=20 NewProductEntryForm<BR>  Dim dlg As New DialogResult</DIV> <DIV> </DIV> <DIV>  Try<BR>   frm.ShowDialog()<BR> &nbsp= ; frm.Owner=20 =3D Me<BR>   dlg =3D frm.DialogResult</DIV> <DIV> </DIV> <DIV>   If dlg =3D Windows.Forms.DialogResult.Cancel=20 Then<BR>    Return Nothing<BR>   End=20 If<BR>   If frm.UseTemplate =3D True=20 Then<BR>    Product =3D=20 getTemplateData(frm.TemplateProductCode)<BR>   End = If</DIV> <DIV> </DIV> <DIV>   If frm.UseTemplate =3D False=20 Then<BR>    Product =3D = getDefaultData(frm.NewProductCode,=20 frm.PrePackCheckBox.Checked)<BR>   End = If<BR>  Catch ex=20 As Exception</DIV> <DIV> </DIV> <DIV>  End Try<BR>  Return Product</DIV> <DIV> </DIV> <DIV> End Function</DIV> <DIV> </DIV> <DIV> <STRONG>Private Function getTemplateData</STRONG>(ByVal pluno = As=20 Integer) As dsInvmgmtDataSet.ProductsRow<BR>  Dim NewDataRow = As=20 dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow<BR>  Dim=20 Template As dsInvmgmtDataSet.ProductsRow</DIV> <DIV> </DIV> <DIV><BR>  Template =3D=20 Me.Products.FindByPLUNo(pluno)<BR>  NewDataRow =3D = Template</DIV> <DIV> </DIV> <DIV>  With NewDataRow<BR>   .PLUNo =3D=20 pluno<BR>   .ProdCode =3D = pluno<BR>   .ItemNo =3D=20 pluno<BR>   .CustNo =3D 1<BR>  End With</DIV> <DIV> </DIV> <DIV>  Return NewDataRow</DIV> <DIV> </DIV> <DIV> End Function</DIV> <DIV> </DIV> <DIV> <STRONG>Private Function getDefaultData</STRONG>(ByVal pluno = As=20 Integer, ByVal isPrePack As Boolean) As=20 dsInvmgmtDataSet.ProductsRow<BR>  Dim NewDataRow As=20 dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow<BR>  Dim=20 Template As dsInvmgmtDataSet.ProductsRow</DIV> <DIV> </DIV> <DIV><BR>  Try<BR>   If isPrePack =3D True=20 Then<BR>    Template =3D=20 Products.FindByPLUNo(My.Settings.TrayPackDefaultProduct)<BR>  &= nbsp;Else<BR>    Template=20 =3D=20 Products.FindByPLUNo(My.Settings.IcePackDefaultProduct)<BR>  &n= bsp;End=20 If<BR>   NewDataRow.ItemArray =3D=20 Template.ItemArray.Clone<BR>   With=20 NewDataRow<BR>    .PLUNo =3D=20 pluno<BR>    .ProdCode =3D=20 pluno<BR>    .ItemNo =3D=20 pluno<BR>    .CustNo =3D 1<BR>   End=20 With<BR>  Catch ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> </DIV> <DIV><BR>  Return NewDataRow</DIV> <DIV> </DIV> <DIV><BR> End Function</DIV> <DIV> </DIV> <DIV><BR>-- <BR>--Eric Cathell, MCSA</DIV></BODY></HTML> ------=_NextPart_000_0006_01C6A26B.03227CB0-- Tag: Determining field type CHAR vs VARCHAR Tag: 130725
  - 21
    - Access Date Format Hi guy, How can we make sure the date format that we pass in MS Access are constantly the format that we wish. I ask this is because My select statement work in some computer and some not. Even I have check the computer system date format there are same. What will effect the date format in MS Access. How to prevent this thing happen. I can't use access anymore if it work like that. Thanks in advance, With regards, Goh Tag: Determining field type CHAR vs VARCHAR Tag: 130722
  - 22
    - SQL connection timeout -- is it pretty useless or what? I'm trying to code a routine that will test the connection to a server and I would like to specific how long (aka timeout) the .Open() should wait before a timeout error is triggered. I've tried "connection timeout=10;" in the connect string, but that still doesn't timeout til 30 seconds have passed. I can't set the Connection.ConnectionTimeout as that is a read only property. So am I out of luck? Is there no way to quickly test a SQL connection in .NET 2.0? Operative being quickly as in I can define how long to wait? Please tell me I don't have to initiate a thread for the SQL connection and have the thread stop after xx seconds. There must be a more simple approach no?? VS 2005 is supposed to be RAD (rapid application development) not WAAD (work around application development). Thanks, Rob. Tag: Determining field type CHAR vs VARCHAR Tag: 130712
  - 23
    - How to set the SmallDateTime field I have a Table with a SmallDateTime field name OrderDate. I want to insert a record into this table, I use the SQL below: sSqlLogIns = "Insert Into hInfLog (OrderID, OrderDate) values ('{0}',{1}) "; sSqlLogIns = string.Format(sOrderID, DateTime.Now.ToString()); Was I use DateTime.Now.ToString() OK? or I must I use ToShortDateString() or others? Tag: Determining field type CHAR vs VARCHAR Tag: 130711
  - 24
    - DataView Filter Problem Running VB.Net I pass a datatable from a form.list to a form.item and use a dataview to show a selected row in text boxes. The row to show usesthe dataview's filter property with the selected row's row id. This works fine except for a row that has been added. The dataview correctly indicates the selected row and has a count of 1. However, the text boxes are showing a different row. The dataview's RowStateFilter is CurrentRows. Thanks. Tag: Determining field type CHAR vs VARCHAR Tag: 130706
  - 25
    - One table not updating after a few insertions Hello All, I'm having this problem which deals with 2 tables in a database. Both tables have a primary key set as an autonumber but also both tables are dependent on each other by having their primary key as a value in their tables. The problem is after a few insertions of records into the event table the rowcount always stays the same. When I open the event table a new row is present and the new autonumber is there. The new value of the 'headerid' from the HeadOrder table overwrites the previous 'headerid' record in the Event table. Could it be because of the autonumber? The eventid autonumber starts at 39 while the headerid autonumber starts at 49 and increments by 1. When the new row in the Event table 'eventid' reaches 46, the headerid overwrites the previous record of 55 and becomes 56 but the headerid at new row stays empty. Example of the table Event before new row is inserted EventID HeaderID 29 39 30 40 . . 45 55 after new row is inserted EventID HeaderID 29 39 30 40 . . 45 56 'The value of HeaderID is overwritten whereas it should of 46 been inserted in the next record here is the code where this happens: 'Fill required headerid to event table dbInventaire.Open() sqlstring = "select * from Event" updater2 = New OleDb.OleDbDataAdapter(sqlstring, dbInventaire) CmdBuilder = New OleDb.OleDbCommandBuilder(updater2) CmdBuilder.QuotePrefix = "[" CmdBuilder.QuoteSuffix = "]" updater2.UpdateCommand = CmdBuilder.GetUpdateCommand Try updater2.Fill(ds2, "Event") table2 = ds2.Tables.Item(0) row2 = table2.Rows(table2.rows.count - 1) 'Problem is in this line row2("HeaderID") = CInt(headeridx) updater2.Update(ds2, "Event") dbInventaire.Close() Catch ex As Exception MsgBox(ex.Message) dbInventaire.Close() EndTry I'm using VB.NET 2005 with ADO.NET and MS Access 2003. Tag: Determining field type CHAR vs VARCHAR Tag: 130704

Is there a way to programmatically determine if a SQL Server field is
of type CHAR vs. VARCHAR?

I'm able to use the DataColumn.DataType property to determine that a
field is a string, and to retrieve its max length. As far as I can
tell, however, both CHAR and VARCHAR fields look the same when using
the DataColumn object.

This for a stored procedure code generator that is complete except for
this one feature.

TIA
Jared

Top

Re: Determining field type CHAR vs VARCHAR by Marina

Marina
Thu Jul 13 15:27:32 CDT 2006

You can query the sql server system tables to find out. Try looking at
syscolumns.

"Jared" <google@tripletreesoftware.com> wrote in message
news:1152821579.889154.28430@p79g2000cwp.googlegroups.com...
> Is there a way to programmatically determine if a SQL Server field is
> of type CHAR vs. VARCHAR?
>
> I'm able to use the DataColumn.DataType property to determine that a
> field is a string, and to retrieve its max length. As far as I can
> tell, however, both CHAR and VARCHAR fields look the same when using
> the DataColumn object.
>
> This for a stored procedure code generator that is complete except for
> this one feature.
>
> TIA
> Jared
>

Top

Re: Determining field type CHAR vs VARCHAR by Jared

Jared
Thu Jul 13 17:34:57 CDT 2006

Hi Marina,

I was hoping this would be exposed in DataColumn, but querying the
system tables should work, too. Thanks for your quick response!

Jared

Marina Levit [MVP] wrote:
> You can query the sql server system tables to find out. Try looking at
> syscolumns.
>

Top

Re: Determining field type CHAR vs VARCHAR by Mark

Mark
Fri Jul 14 14:30:39 CDT 2006

Bear in mind that the DataSet and the actual table within SQL are very
different things - a DataTable is not an SQL table, it just so happens that
you can fill a DataTable from an SQL table - therefore the DataTable column
types aren't the same as the SQL column types and the DataTable attributes
don't neccessarily represent the associated SQL table.

You'll see the same problem with default values in SQL tables - they aren't
represented in the associated DataTable at all.

--
Best regards
Mark Baldwin

"Jared" <google@tripletreesoftware.com> wrote in message
news:1152830097.676054.120200@p79g2000cwp.googlegroups.com...
> Hi Marina,
>
> I was hoping this would be exposed in DataColumn, but querying the
> system tables should work, too. Thanks for your quick response!
>
> Jared
>
> Marina Levit [MVP] wrote:
>> You can query the sql server system tables to find out. Try looking at
>> syscolumns.
>>
>

Top