OleDB returning DBNull for certain cells

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
    - Can Sql Server 7 be used with ADO.Net? Does ADO.Net work with SQL Server 7 or is it only compatible with SQL Server 2000? Thanks in advance Chris Pearce Tag: OleDB returning DBNull for certain cells Tag: 73546
  - 2
    - OleDB troubles reading Excel spreadsheet I'm trying to use an OleDbConnection to read some data from an Excel Spreadsheet. I create my connection string, and open the connection, but when i query the sheet/table i get the error that OleDb could not find the sheet. I've now tried to get a list of the sheets (to see if i was using the wrong sheet name or something) but my list of sheets comes back with 0 entries. Any Help! this spreadsheet DOES have 2 sheets inside it... What am i not doing? Are there any good examples/resources out there for reading Excel in this way? Private _connectionString as String Dim rs As OleDbDataReader Dim cmd As New OleDbCommand Dim query As String Dim table As String Dim lookup As DataTable 'I build my connection string newConnectionStr.Append("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=") newConnectionStr.Append(fileName) newConnectionStr.Append(";Extended Properties=Excel 8.0;") _connectionString = newConnectionStr.ToString 'I open my connection and attempt to see what sheets are available _connection.Open() lookup = _connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing) If lookup.Rows.Count > 0 Then table = CStr(lookup.Rows(0)("TABLE_NAME")) End If _connection.Close() _connection.Dispose() This returns me nothing, 0 rows end up in 'lookup'. If i try and run the query "Select * FROM [$Sheet 1$]" I get the "not able to find" error. Help? Thanks! jeffpriz Tag: OleDB returning DBNull for certain cells Tag: 73543
  - 3
    - Programmatic access to control in DataGrid HeaderTemplate FindControls does not work for a server control in a DataGrid HeaderTemplate. Doing the following: <DataGridName>.FindControl("<controlId>") This brings back null for a HtmlInputCheckBox or a CheckBox Web control. How do you programmatically access a server control in the header of an DataGrid? Or can you? Thanks, Tommy. Tag: OleDB returning DBNull for certain cells Tag: 73541
  - 4
    - DataBinding Format Question I am using the following code to apply the databinding format for Date (04/12/2003) **********************CODE***************************** Private WithEvents DateBinding As Binding DateBinding = New Binding("Text", Me.DsReport1, _ "Report.Date") Me.RichTextBox.DataBindings.Add(DateBinding) Sub Format(ByVal sender As Object, ByVal e As ConvertEventArgs) Handles _ DateBinding.Format Dim dt As DateTime = CType(e.Value, DateTime) e.Value = dt.ToString("dd/MM/yyyy") End Sub ********************************************************* It works perfectly but every time I load the form on design mode, the following messages appear: "The variable DateBinding is not declared or it was not assigned never" "The type System.Windows.Forms.Form does not have a field named DateBinding" Now, this can't be right and I sure don't want to leave it like that but I can't figure it out. Any recommendations please? Thanks! Tag: OleDB returning DBNull for certain cells Tag: 73539
  - 5
    - FIND like old ADO method Is there any kind of FIND in ADO.NET that works the same way as the old ADO Recordset FIND? The old ADO Find would accept a criteria string, and then find the first record that matches the criteria. For instance, rs.Find("text_value like '* | *') would position me on the first record that contained a bar (' | '). It didn't filter anything, but just positioned the database at that record (or, in ADO.NET, would give me the row index of the first record matching this criteria). I see SELECT on a datatable and ROWFILTER on a dataview, but these all filter... I simply want to find the first record matching this criteria. I can probably get around it by simply reading all the records and programatically searching for the first one that matchs, but was hoping for a built-in solution. Thanks in advance. Tom Tag: OleDB returning DBNull for certain cells Tag: 73535
  - 6
    - Using SqlCommandBuilder with Transactions Hi, i have a DataSet with 3 Tables. For each table i have defined a SqlDataAdapter Object. The SqlCommands for Deleting, Inserting und Updating were created by the SqlCommandBuider Object. I have wrote the following Code, to write the Content DataSet. public void WriteData() { SqlCommandBuilder buildCmd1; SqlCommandBuilder buildCmd2; SqlCommandBuilder buildCmd3; buildCmd1 = new SqlCommandBuilder(this.adapter1); buildCmd2 = new SqlCommandBuilder(this.adapter2); buildCmd3 = new SqlCommandBuilder(this.adapter3); this.sqlConn.Open(); this.adapter1.Update(this.dataSet, table1); this.adapter2.Update(this.dataSet, table2); this.adapter3.Update(this.dataSet, table3); this.sqlConn.Close(); } Now i want to encapsulate the three Updates in one Transaction? How can i assign the dynamic generated SqlCommand Objects to a SqlTransaction Object? Thanks Andreas Tag: OleDB returning DBNull for certain cells Tag: 73524
  - 7
    - Datareader and Getint32 does not work Using VS.2003 and ODBC I make a SELECT count(*) from table1. with ExecuteSQLSelect This must return always !!! a number-value . But if I try to read from the datareader with GetInt32 a get always a inValid cast operation exception . Only Getstring(0) works fine. Is there any solution for this behavior ??? Thanks for any help Peter *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: OleDB returning DBNull for certain cells Tag: 73520
  - 8
    - Attaching a table to a remote Database Hello ! I'm trying to make a link between two Access databases. Actually there are a few Tables in one of them I want to attach to the other (attach or add) knowing that the schema of the tables changes depending of which database is opened in the first place. Consequently I can't write a SQL script I can run against the second database. Can anyone help me doing this ? I don't have an idea on how to program such an operation in Visual Basic.NET :/ -Pulse Tag: OleDB returning DBNull for certain cells Tag: 73519
  - 9
    - codegen:nullValue not working for me Hello, Have a datset returning a null value in a text string and crashes app. Used article 318039 as a guideline to modify dataset.xsd. (part of a WebService) Still Get Null. Excerpt follows. <xs:schema id="MASpedDataSet" targetNamespace="http://www.tempuri.org/MASpedDataSet.xsd" xmlns:codegen="urn:schemas-microsoft-com:xml-msprop" Other namespaces follow that were produced by Gen DataSet The other altered line: <xs:element name="BusRider" codegen:nullValue="N" type="xs:string" minOccurs="0" /> Have also tried nullValues of " ", _empty and "_empty". All out of ideas (for modifying XML, I know I can use IIF statements for each and every assign to a form control, but will likely throw self from window after doubling source code size as well as the time to complete each Form. mklapp Tag: OleDB returning DBNull for certain cells Tag: 73515
  - 10
    - codegen:nullValue not working for me Hello, Have a datset returning a null value in a text string and crashes app. Used article 318039 as a guideline to modify dataset.xsd. (part of a WebService) Still Get Null. Excerpt follows. <xs:schema id="MASpedDataSet" targetNamespace="http://www.tempuri.org/MASpedDataSet.xsd" xmlns:codegen="urn:schemas-microsoft-com:xml-msprop" Other namespaces follow that were produced by Gen DataSet The other altered line: <xs:element name="BusRider" codegen:nullValue="N" type="xs:string" minOccurs="0" /> Have also tried nullValues of " ", _empty and "_empty". All out of ideas (for modifying XML, I know I can use IIF statements for each and every assign to a form control, but will likely throw self from window after doubling source code size as well as the time to complete each Form. mklapp Tag: OleDB returning DBNull for certain cells Tag: 73514
  - 11
    - Detached DataRows and Relationships Hi, Does anybody know how to set the parent row of a child table's row to a detached row? I'm using Forms DataBinding. If I add a new row for editing, using BindingContext(someDataSet,"ParentTable").AddNew() the row's RowState is Detached. Now, if I try to add any child rows to a child table with this row set as the child rows' parent, an InvalidConstraintException will be thrown, telling me that the child's key value must exist in in the parent table (which it doesn't because the parent row is still detached). Is there a way around this, without having to first add the parent row to its table (by calling bindingcontext(someDataSet, "ParentTable).EndCurrentEdit())? Hope that all made sense Thanks, Dave Hagedorn Tag: OleDB returning DBNull for certain cells Tag: 73513
  - 12
    - Detached Row And Relations in DataSet Hi, Does anybody know how to set the parent row of a child table's row to a detached row? I'm using Forms DataBinding. If I add a new row for editing, using BindingContext(someDataSet,"ParentTable").AddNew() the row's RowState is Detached. Now, if I try to add any child rows to a child table with this row set as the child rows' parent, an InvalidConstraintException will be thrown, telling me that the child's key value must exist in in the parent table (which it doesn't because the parent row is still detached). Is there a way around this, without having to first add the parent row to its table (by calling bindingcontext(someDataSet, "ParentTable).EndCurrentEdit())? Hope that all made sense Thanks, Dave Hagedorn Tag: OleDB returning DBNull for certain cells Tag: 73511
  - 13
    - sproc with output param and a trigger We have been using the same sproc for an insert for quite some time. The sproc create a new key for the record to insert, uses the key for the insert and then has an output param for the key. The key field in the DataTable is 'names_id'. The is the sourcecolumn for the sql output param. Yesterday, one of our developers added an insert trigger to the table the sproc inserts into. Now, we are getting an exception that state 'name_id' cannot be Null. Very strange as his usually suggests to me I am passing in a parameter that is NULL. Well, names_id is not a param to the sproc. It's the source column for the sql output param. I am new to triggers so I have no idea what introducing the trigger has done. Anyone know what the source column for an output param would all of a sudden be NULL? Strange thing to is I no longer see the sproc running in SQL Profiler. Tag: OleDB returning DBNull for certain cells Tag: 73499
  - 14
    - SP works when debugged/execute via query analyser but not when called from ADO.NET Hi, Okay heres a bit of background. Running WinXP Pro SP1, IIS5.1, SQL Server 2000 SP3, VS.NET 2003, Framework 1.1. This is porting job from VB6 webclass app to VB.NET httphandler DLL. I have a database wrapper class which has methods like RunSP etc... so all my DB calls use the same code so the problem is not that I am coding the command object differently or anything like that. Any way I call an SP that both creates and deletes data. The SP in fact calls other SPs and the SP uses BEGIN TRANS etc... However for some reason after it has been run the data is not correct, its almost as if one of the inner called SPs has failed or been passed the wrong ID or something. However if I pause the code on the line that calls my .RunSP method, and then go to query analyser and either debug and step through the SP or just execute it straight and then manually by hand set variables in my code to those values that would normally be set by the output parameters of the SP then it all works fine!!! I tried taking out all the BEGIN TRANS from the SPs and inner SPs involved but still the same problem. I am a bit new to the whole .NET thing, and while I like using it a lot, things that should be simple are really P*£"ing me off. Any help about what to look for or check would be much appreciated. Regards, Peter Tag: OleDB returning DBNull for certain cells Tag: 73498
  - 15
    - datagrid I have a select stmt as follows SELECT qty, qty * 2 AS qty1, qty + 10 AS tuir FROM sales I have to bind table values which I obtain by running the query to a datagrid (web control)Item template column How should i give the expression for my datafrid columns ? Tag: OleDB returning DBNull for certain cells Tag: 73497
  - 16
    - One DS, two tables and two XML files? Greetings, I would like to know please how can I create two xml files from one dataset with two tables in it? The WriteXML method of the DataSet creates one XML file with BOTH tables of the dataset. Dim ds as new dataset Dim da as new dataadapter 'code goes here for declaration and database connection da.fill(ds,"table1") da.fill(ds,"table2") ds.WriteXML(C:\text.xml) 'this will create ONE XML file...problem! I need TWO MTIA, Grawsha Tag: OleDB returning DBNull for certain cells Tag: 73488
  - 17
    - ODBC.net Vs OleDB.net which is Better can some one tell me why is that ODBC.net is faster than OleDB.net??? Tag: OleDB returning DBNull for certain cells Tag: 73481
  - 18
    - ADO XML and .NET Hello I want to read an XML file that was created with ADO into an ADO.NET dataset. The file was created using ... rs.Save "titles.xml", adPersistXML and is read into the dataset using... ds.ReadXML("titles.xml") My problem is that although the data is read OK, the inline schema is ignored and all columns are infered a DataType of String. Can ADO.NET read the ADO schema? If so, how? Thank you Tag: OleDB returning DBNull for certain cells Tag: 73476
  - 19
    - Serializing/Deserializing a typed DataTable existing in a DataSet I want to serialize a DataTable that exista within a typed Dataset into an XML file and later deserialize it. I am not able to do that.... any pointers? Tag: OleDB returning DBNull for certain cells Tag: 73475
  - 20
    - sqlCommand.ExecuteScalar problem on return value Hi "Select UserId from users where userid = 2" How come it return Undefined value if the select doesn't return any result? How can I know if the select succeded or not? Thanks, Ronen Tag: OleDB returning DBNull for certain cells Tag: 73472
  - 21
    - HTTP 404 Error for ASP.NET pages The web server is running Windows Server 2003 Standard Edition, and it returns HTTP 404 error when running ASP.NET pages, but ASP pages are working fine. I also installed Visual Studio .NET, and the framework version should be 1.1. I am sure ASP.NET is enable in the machine by checking the following methods: 1) Go to manage your server window, click add/remove a role, and choose application server, and it only have choices disable ASP.NET, that means ASP.NET is enable already. 2) In IIS manager, click right pane, and I cannot see ASP.NET. I enabled all the followings: All Unknown CGI Extensions All Unknown ISAPI Extensions Active Server pages Front Page Server Extensions 2002 Internet Data Connector Server Side Includes WebDAV I really have no idea whats going on. I am using Standard Edition, I dont know if it has 32-bit and 64-bit versions. Since the following link says ASP.NET is disable in 64-bit Windows Server 2003. How can I tell if Windows Server 2003 is 32-bit or 64-bit?? http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/proddocs/entserver/unsupported64BitFeatures.asp Tag: OleDB returning DBNull for certain cells Tag: 73470
  - 22
    - Getting @@Identity from an Access table My code below always returns 0 for the Identity. Any idea why. The database is in Access 2k. int ID=0; OleDbConnection conn=new OleDbConnection(); OleDbCommand aCommand=new OleDbCommand(); conn.ConnectionString =ConnectionString; conn.Open(); aCommand=conn.CreateCommand(); aCommand.CommandText =strSQL; aCommand.ExecuteNonQuery(); strSQL = "SELECT @@IDENTITY AS ID"; aCommand.CommandText = strSQL; ID=(int)aCommand.ExecuteScalar(); conn.Close(); return (ID); Tag: OleDB returning DBNull for certain cells Tag: 73469
  - 23
    - SCOPE_IDENTITY () return value I have an identity column defined as int in sql 2000. I use SCPOE_IDENTITY () to get the new inserted column id. The problem is that the object returned from the ExecuteScalar is of type Decimal? why is that happens? Thanks, Ronen Tag: OleDB returning DBNull for certain cells Tag: 73468
  - 24
    - How to get the ID of an item inserted into a database right after it has been inserted I am inserting rown into my data table and would like to be able to retriever id of the row inserted immediatelly after it has been inserted. How can I do that? Regards, Dino -- ------------------------------------------------------------------------- FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com Tag: OleDB returning DBNull for certain cells Tag: 73467
  - 25
    - This SqlTransaction has completed; it is no longer usable. This error happens every once in a while. I cannot figure out what is wrong or why this happens. This SqlTransaction has completed; it is no longer usable. public void InsertVisitorTargeter() { MyUtils.SqlClient sqlClient = null; SqlTransaction tran = null; try { sqlClient = MyUtils.SqlClientFactory.CreateSqlClient(); tran = sqlClient.SqlCommand.Connection.BeginTransaction(IsolationLevel.RepeatableRead, "VisitorTargeter"); sqlClient.SqlCommand.Transaction = tran; CommitToDatabase(sqlClient); tran.Commit(); } catch(Exception ex) { tran.Rollback(); throw(ex); } finally { // release resources MyUtil.SqlClientFactory.DisposeSqlClient(sqlClient); } } //edited method for ease of reading a bit. private void CommitToDatabase(MyUtil.SqlClient sqlClient) { System.Diagnostics.Trace.Write("Inside CommitToDataBase", "Targeter"); System.Diagnostics.Trace.Write("Visitor is " + visitorID, "Targeter"); sqlClient.SqlCommand.CommandText = "[dbo].[usp_VisitorTargeter_ins]"; sqlClient.SqlCommand.Parameters.Clear(); // create parameters sqlClient.SqlCommand.Parameters.Add("@RETURN_VALUE", SqlDbType.Int,4); sqlClient.SqlCommand.Parameters.Add("@ID", SqlDbType.UniqueIdentifier); sqlClient.SqlCommand.Parameters.Add("@Email", SqlDbType.VarChar, 256); sqlClient.SqlCommand.Parameters["@Email"].Value = email; sqlClient.SqlCommand.Parameters["@RETURN_VALUE"].Direction = ParameterDirection.ReturnValue; sqlClient.SqlCommand.Parameters["@ID"].Direction = ParameterDirection.Output; sqlClient.SqlCommand.ExecuteNonQuery(); // check that sproc ran successfully by returning 1 and affecting one table row only if ( 0 != (int)sqlClient.SqlCommand.Parameters["@RETURN_VALUE"].Value) //|| } I also have a begin tran and then a rollback/commit tran in the sp. Tag: OleDB returning DBNull for certain cells Tag: 73463
- Next
  - 1
    - Merge dataset into query call in dataadapter???? Hi everybody - This may seem like an easy question to the .NET gurus out there but it has me very much stumped on how to accomplish. I have a dataset that I have merged together from separate queries. What I want is to include it in my final query so I can include other fields but I'm trying to do a join on certain fields in this dataset I've generated. How can I accomplish this? So for example, I'd like to do something like this: Select FirstName, dsQueryC.InitDate From Employee INNER JOIN dsQueryC etc...... (Being able to reference the dataset within the query of a data adapter) I'm completely lost on how to do this in ADO.Net Any thoughts are appreciated, Ben Tag: OleDB returning DBNull for certain cells Tag: 73457
  - 2
    - Create XSD Dataset with child table in two nested relations. It's a commonly known problem that XSD.exe cannot parse the following XML into either an xsd file or class <Data><One><File><Name>Test1</Name></File></One><Two><File><Name>Test2</Name></File></Two></Data Because it can't cope with the fact that the <File> element appears in two places (the Custom tool error: Unable to convert input xml file content to a DataSet. The same table (*TableName*) cannot be the child table in two nested relations. error). The MS provided tool "Infer.exe" WILL create an .xsd schema for this XML, but doesn't provide a way to generate a strongly-typed DataSet for it. Can anyone point me to a good workaround? There must be some way (other than me creating the typed DataSet completely manually) that I can get a repeated element into a DataSet using the XSD tool combined with some custom code. Any ideas would be appreciated Richard Tag: OleDB returning DBNull for certain cells Tag: 73446
  - 3
    - Web Services with large datasets I'm designing an app that will need to run in environment where different data is on different DB servers and OS'es (SQL Server, Oracle, Windows, AS400 etc). My app will need to pull together data from a few separate databases and then run some reports on the data. My original thinking was that XML and webservices would be the route to go. I could have someone provide a webservice that would give me some XML that I could turn into a dataset to be analyzed to create the reports. This is great in theory, but when I look at the sizes of the XML files, I'm not so sure. Webservices seem to be better suited to passing around small datasets or scalar values. How to people generally deal with this? Is the XML file size less of an issue than it seems to me? Or, do I need to look at figuring out a way to get a more direct connection to datasources in cases like this (i.e. reporting)? I know on the DB end I can quickly switch providers, but the SQL for one DB backend never seems to translate to a different DB backend, so you're stuck modifying much of the SQL too. Chris Tag: OleDB returning DBNull for certain cells Tag: 73441
  - 4
    - Crystal Reports: binding to ado.net w/ multiple tables Firstly: I am using crystal version that comes with visual studio .net 2003, SQL Server and ADO.Net I am trying to create a report that takes information from more than one table: for example, if you have a customer table and an orders table, based on a sql join query, i want the report to display all orders for a particular customer. Now, i know my main code is not the problem because if i try to connect to just one table, it works. As soon as i try to add another table, link it in the dataset and write a join query, nothing comes up. Here is my main code: ********************** Public Class WebForm1 Inherits System.Web.UI.Page ''CR Variable (the actual physical report file- in this case CrystalReport1.rpt- don't specify extension Dim crReportDocument As CrystalReport4 ''ADO.NET Variables Dim adoOleDbConnection As OleDbConnection Dim adoOleDbDataAdapter As OleDbDataAdapter Protected WithEvents CrystalReportViewer1 As CrystalDecisions.Web.CrystalReportViewer Dim dataSet As Dataset7 #Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here ''Build a connection string Dim connectionString As String = "" connectionString = "Provider=SQLOLEDB;" connectionString += "Server=WEBMASTER;Database=Pubs;" connectionString += "User ID=sa;Password=thames" ''Create and open a connection using the connection string adoOleDbConnection = New OleDbConnection (connectionString) ''Build a SQL statement to query the datasource Dim sqlString As String = "" sqlString = "SELECT TOP 5 dbo.pub_info.pr_info, dbo.publishers.pub_name, dbo.publishers.city, dbo.publishers.state, dbo.publishers.country FROM dbo.pub_info INNER JOIN dbo.publishers ON dbo.pub_info.pub_id = dbo.publishers.pub_id" ''Retrieve the data using the SQL statement and existing connection adoOleDbDataAdapter = New OleDbDataAdapter (sqlString, adoOleDbConnection) ''Create a instance of a Dataset dataSet = New Dataset7 ''Fill the dataset with the data retrieved. The name of the table ''in the dataset must be the same as the table name in the report. adoOleDbDataAdapter.Fill(dataSet, "Pubs") ''Create an instance of the strongly-typed report object crReportDocument = New CrystalReport4 ''Pass the populated dataset to the report crReportDocument.SetDataSource(dataSet) ''Set the viewer to the report object to be previewed. CrystalReportViewer1.ReportSource = crReportDocument End Sub End Class Thanks so much Neile Tag: OleDB returning DBNull for certain cells Tag: 73436
  - 5
    - Navigating a dataset 'randomly' Hello, I retrieve all the Ids from a DB table. The 'current' Id is used to retrieve all the columns associated with that Id. I need to Move Next and Move Previous. The DBEnumerator is a Forward-only tool. A "For Each Row" solution would enclose nearly the entire application in the loop and still would not work. Since a "Find" is supported, maintaining a Global index to step through the rows collection would not be effective. There are upwards of 14,000 rows in the table, so I am not eager to use an array. I must use a Web Service and ADO.NET disconnected datasets. How does one navigate forward and backward relative to the current row without knowing the index (or can we learn the index? The DBEnumerator was promising, but it is forward only. mklapp Tag: OleDB returning DBNull for certain cells Tag: 73435
  - 6
    - UNION statement with run-time queries. Greetings all - I'm fairly new to working with UNION queries within ASP/VB .NET and I'm struggling with trying to find suggestions on how to implement a solution to this issue. I'm developing 4 queries .........1 from 1 data source, 1 from a separate data source, 1 to UNION the first two together and the last to query against the 3rd query to populate into a Crystal Report (which I haven't figured out how I'm going to accomplish yet). Since I'm running these queries in the code-behind as run time queries, is it even possible to run a UNION statement in this setup without having issues with the FROM clauses in the UNION since I'm wanting to pull from the data tables in the first 2 datasets that I have created already? If I try to fill them, wouldn't it error when it reads the FROM clause tables? Any thoughts are greatly appreciated at this point. Thanks, Clark Tag: OleDB returning DBNull for certain cells Tag: 73430
  - 7
    - OdbcConnection in Multithreading Hey, Hi all friends!!! I've got an application which executes an stored procedure using an OdbcCommand object, but it has to executes several stored procedures at the same time, so i decided use multithreading, so that the application creates a thread for each stored procedure and start it in this way class ClassWithMethod { public void MyMethod() { //here stored procedure executes } } class Test { static public Main (string[] args) { ClassWithMethod obj = new ClassWithMethod(); Thread myThread = new Thread (new ThreadStart (obj.MyMethod)); myThread.Start(); } } But in the application a new thread is created each time an event happens, and each time a thread is created the application is creating a new OdbcConnection (ODBC 'cause it uses a Sybase 10 database) and it is closing the connection in the finally block of the method MyMethod (describe before) but, to close the connection the application is verifying that the connection it is gonna close be an open connection, if it is not an open connection it throws an exception, and my problem is that this exception i mentioned is throwing in some cases, i.e. just in some cases, i.e. in some thread which the connection is trying to be closed, the application detects that this connection of this thread is closed. So, anyone can undarstand why is happennig this??? or is there a better or more efficcient way to manage connections in multithreading???? Any help i will thank!!! Regards!!!! Tag: OleDB returning DBNull for certain cells Tag: 73429
  - 8
    - Problem with RichTextBox and Access Db I have an application that gets data from a Access database and displays it on a form. I have a slightly odd and annoying problem that stems from the fact that the program I'm replacing with my program was writing in VBA in Access. The problem is that the RichTextBox control in Access uses '/n/b' as an end of line character while the RichTextBox in C#.NET uses just '/n'. The reason why this is a problem is because it tricks my app into thinking that a field has been changed because between moving the data from the database to my RichTextBox control and then back to the database again all the end of line characters get changed. Now dealing with this would be very simple, but I have code that checks each control and tries to determine if really has changed before updating the dataset and I want a solution that is very general and doesn't require me to cludge up my program with a lot of checks for this one case. Any ideas? Tag: OleDB returning DBNull for certain cells Tag: 73413
  - 9
    - Handling SqlException during DataAdapter.Update I am using ADO.NET datasets to transfer information between my client and business logic. When I fill the dataset and some dataset contraint is triggered, then the FillError event is triggered, that can be handled. My database contains some constraints that can be triggered when propagating the dataset changes back to the database. I use the SqlDataAdapter.Update to send this information to the database. Unfortunately, there is no UpdateError event that can be handled. I would have liked an event for these errors that specify the datatable, row and SqlException (a bit like the FillErrorEventArgs). I have created a workaround, but this looks horrible. I call the dataadapter's Update method and catch the SqlException. Then I will iterate through the dataset and find the first non-Unchanged row. That should have been the row that has failed. Things become even more complex when relational datasets are being updated, because they are updated in a different order. When a UpdateError event would have existed, then this would have been much more easy. Now I investigate the SqlException by checking the message number and parsing the message string. I don't like this behaviour, but I don't think there is a better way. Anyone have a suggestion? Tag: OleDB returning DBNull for certain cells Tag: 73410
  - 10
    - DataTable contraints Hello, If I name a table in the Fill method and that table exists in the DB (in my case, SQL Server), must the structure and rules be the same as the database table or are the DataTables totally independent and defined solely within the context of the SQL Command executed by the Fill method? mklapp Tag: OleDB returning DBNull for certain cells Tag: 73405
  - 11
    - Connecting to SQL Server DB Hi all, I'm missing something, probably stupid, on connecting to a SQL Server database from an aspx file. I haven't really done much w/ SQL Server and suspect that it's a problem on that side. I've installed the SQL Server developer edition locally and do have a pubs database. The connection I'm attempting is the following: SqlConnection objConnection = new SqlConnection( "server=localhost;database=pub;uid=sa;pwd=admin" ); try { // Open the connection. objConnection.Open(); /*snip*/ } catch( Exception ex ) { ErrorMessage.Text = ex.Message.ToString(); } The exception caught indicates (whether or not 'sa' is the uid I'm trying to connect with): Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (w/Windows-only Authentication) or Login failed for user 'sa'. (Windows and SQL Server Authentication) I have been able to create a connection through VFP (though using ODBC). The connection string it creates is: DSN=SQLServer1;UID=sa;PWD=admin;APP=Microsoft Visual FoxPro;WSID=J2K, which indicates to me that the sa/admin login is correct (which is what Iset at installation). Any ideas? TIA, John Tag: OleDB returning DBNull for certain cells Tag: 73396
  - 12
    - accessing cobol data files from .net hi i need to access cobol data files from .net, the files have no or .vix extention (i think thats a acucobol or something like that) (/me has completely no experience in cobol) i heard that there should be an odbc connection for that. Dous anyone have any ideas on how to do this?? -- Juchtmans Eric Omnipack Tag: OleDB returning DBNull for certain cells Tag: 73393
  - 13
    - How To Set Date Field back to NULL Hi, On my webform is a DOB text box. If the user wants to clear out the field, how do I write a NULL back into the SQL Server Database field. Thanks, MDM Tag: OleDB returning DBNull for certain cells Tag: 73391
  - 14
    - Viewing Binary Image from SQL ! This is a multi-part message in MIME format ------=_NextPart_000_75830417 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi ! I wonder if there is a simple solution to how to dynamically view an image from a SQL DB. It´s a binary file and the insertfunction into SQL works fine. I can easily view all the text from the SQL DB. I can also view the image separatly. I load the text in a separate file : details.aspx I load the image in another file : showpic.aspx In the details.aspx file I put an <img> tag to the showpic.aspx as follows: <asp:Image id="Image" runat="server" ImageUrl="showpic.aspx?id=22"></asp:Image> In the above example the imagefile is static "id=22". How can I make it dynamic so that the "id" changes when I click on details in the Datagrid? How does the syntax look like ? Help much needed ! OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! ------=_NextPart_000_75830417 Content-Type: text/html; name="_alt.0" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="_alt.0" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4=2E0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html;= charset=3Diso-8859-1"> <META content=3D"MSHTML 6=2E00=2E2800=2E1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Thank you Miha,  it now= works=2E  You are always quick to respond and are very helpful to somebody who is= new to =2E=2ENET=2E</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Brad</FONT></DIV> <BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;= BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Miha Markic" <miha at rthand com> wrote in message= <A = href=3D"news:OfWmuWXuDHA=2E4060@TK2MSFTNGP11=2Ephx=2Egbl">news:OfWmuWXuD= HA=2E4060@TK2MSFTNGP11=2Ephx=2Egbl</A>=2E=2E=2E</DIV> <DIV><FONT face=3DArial size=3D2>Hi Brad,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>You sure that your code is= correct - I mean you look at the right guid?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>NewGuid generates random GUID= and not empty one=2E</FONT></DIV> <DIV><FONT face=3DArial size=3D2>You should do:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Dim g as Guid =3D= Guid=2ENewGuid()</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Console=2EWriteLine(g)</FONT></DIV> <DIV><FONT face=3DArial size=3D2><BR>-- <BR>Miha Markic - RightHand= =2E=2ENET consulting & software development<BR>miha at rthand= com</FONT></DIV> <BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;= BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Brad Allison" <<A = href=3D"mailto:ballison@ukcdogs=2Ecom">ballison@ukcdogs=2Ecom</A>>= wrote in message <A = href=3D"news:%23PkA%23hRuDHA=2E4056@TK2MSFTNGP11=2Ephx=2Egbl">news:%23Pk= A%23hRuDHA=2E4056@TK2MSFTNGP11=2Ephx=2Egbl</A>=2E=2E=2E</DIV> <DIV><FONT face=3DArial size=3D2>Jennifer,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks for the help, but every= time I run this method, I get the following for a GUID: 00000000-0000-0000-0000-000000000000=2E  I was under the= understanding that this method was in a way like RANDOMIZE=2E  Am I= missing something?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks again for the= information=2E</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Brad</FONT></DIV> <BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT:= 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Jennifer Perret [MSFT]" <<A = href=3D"mailto:jenp@online=2Emicrosoft=2Ecom">jenp@online=2Emicrosoft=2Eco= m</A>> wrote in message <A = href=3D"news:uigstNRuDHA=2E3496@TK2MSFTNGP11=2Ephx=2Egbl">news:uigstNRuD= HA=2E3496@TK2MSFTNGP11=2Ephx=2Egbl</A>=2E=2E=2E</DIV> <DIV> <DIV><FONT face=3DArial size=3D2>Check out the Guid=2ENewGuid Method:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><A = href=3D"http://msdn=2Emicrosoft=2Ecom/library/default=2Easp?url=3D/library= /en-us/cpref/html/frlrfSystemGuidClassNewGuidTopic=2Easp">http://ms= dn=2Emicrosoft=2Ecom/library/default=2Easp?url=3D/library/en-us/cpref/htm= l/frlrfSystemGuidClassNewGuidTopic=2Easp</A></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></DIV> <DIV><FONT face=3DArial size=3D2></FONT><BR>--= thanks~<BR>Jennifer Perret [MS]</DIV> <DIV> </DIV> <DIV>This posting is provided "AS IS" with no warranties,= and confers no rights=2E <BR>Use of included script samples are subject to= the terms specified at <BR><A = href=3D"http://www=2Emicrosoft=2Ecom/info/cpyright=2Ehtm">http://www=2Emic= rosoft=2Ecom/info/cpyright=2Ehtm</A></DIV> <BLOCKQUOTE dir=3Dltr style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT:= 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Brad Allison" <<A = href=3D"mailto:ballison@ukcdogs=2Ecom">ballison@ukcdogs=2Ecom</A>>= wrote in message <A = href=3D"news:#YZ76YQuDHA=2E2180@TK2MSFTNGP09=2Ephx=2Egbl">news:#YZ76YQuD= HA=2E2180@TK2MSFTNGP09=2Ephx=2Egbl</A>=2E=2E=2E</DIV> <DIV><FONT face=3DArial size=3D2>I usually use numerics with= a random number generator for my unique ID fields in my tables, however I= have an instance where I would like to use GUIDs (since this key= will never be used or seen by the end user)=2E  Here is the start of= my code:</FONT></DIV> <DIV> <P><FONT face=3DArial size=3D2>    Dim myGuid1= As New Guid()</FONT></P> <P><FONT face=3DArial size=3D2>    JrEventID =3D= myGuid1=2EToString</FONT></P> <P><FONT face=3DArial size=3D2>   = txtEventID=2EText =3D JrEventID</FONT></P> <P><FONT face=3DArial size=3D2>How do I generate a new= GUID?  Is is a simple process?</FONT></P> <P><FONT face=3DArial size=3D2>Thanks for the= information=2E</FONT></P> <P><FONT face=3DArial = size=3D2>Brad</FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUO= TE></BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_75830417-- Tag: OleDB returning DBNull for certain cells Tag: 73390
  - 15
    - RowFilter with decimal value Hi, i try to set a rowfilter with dezimal values like 2,7. ... vw1.RowFilter = "Key='" & Me.C1FlexGrid1.Item(cellZeile, cellSpalte) & "'" After run this row, it crash thx Rene Tag: OleDB returning DBNull for certain cells Tag: 73386
  - 16
    - Can't run Data Form Wizard. I'm getting an error message "Could not run the c:\program files\... \WinDataForm.vsz wizard" when I attempt to add new item and select Data Form Wizard as the template for a new project. Any ideas what might be causing this? I just re- installed and tried again, but same issue. I'm running Visual Studio 2002. Thanks. Tag: OleDB returning DBNull for certain cells Tag: 73379
  - 17
    - Reading Data from EXCEL Workbook/WorkSheets Using ADO.Net Hello, Can anybody please tell me how to read the data from Excel Work Book using ADO.Net so that these Records can be persisted back to the SQL Server 2000 Database. Regards, Anonymous Tag: OleDB returning DBNull for certain cells Tag: 73377
  - 18
    - DataAdapter number of columns limitation? Hi I'm trying to write strongly typed dataset. Ma DB has Tables with more then 100 columns each. Creating DataAdapter, DataSet and DataAdapter Commands by wizard fails. Doing it manually is not pleaserfull. I've discovered that when number of columns in table exceedes 100 Then DataAdapter fails on creating Insert, Update, Delete, Commands. Why is it happening? Can I avoid it somehow I'll add that I'm using C# and Access 2002. Thanks for help Kamil Tag: OleDB returning DBNull for certain cells Tag: 73372
  - 19
    - SQL Server Timeout error on deployment/production server This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3B9BF.20552950 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello All, I am facing SQL Server related problem. Here is the scenario: 1. We have a windows application (24x7) that has timer running on = the form. The timer interval is set at 3 minutes. On every timer tick, a = method is called that executes a stored procedure. On execution of the = stored procedure, certain tables are updated, that causes triggers on = the tables to run. These triggers are in turn executing a stored = procedure and so on resulting in a lot of database activity.=20 2. We do not have control on the database (tables, triggers etc = cannot be modified by us).=20 3. Also, another C++ application is running in background that = constantly pumps data into the database. This application updates many = tables at a time in a transaction (and hence holds locks on the database = tables).=20 Issue : After running a single instance of Windows application for about = 8-9 hours, the following error was received: System.Data.SqlClient.SqlException: Timeout expired. The timeout period = elapsed prior to completion of the operation or the server is not = responding. I am not sure as to what could be the cause of this problem?? This problem is not faced on development server. I am facing this = problem only on production server. Can someone suggest a solution to the above problem or provide valuable = tips/new approaches to counter this problem. I need to solve this problem ASAP. Please reply ASAP. ------=_NextPart_000_0008_01C3B9BF.20552950 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.3790.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Verdana">Hello=20 All,<?xml:namespace prefix =3D o ns =3D = "urn:schemas-microsoft-com:office:office"=20 /><o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Verdana"><o:p> I</o:p></SPAN><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> am facing SQL = Server related=20 problem. Here is the scenario:<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Verdana"><o:p> 1.   =20 </o:p></SPAN><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">We = have a=20 windows application (24x7) that has timer running on the form. The timer = interval is set at 3 minutes. On every timer tick, a method is = called that=20 executes a stored procedure. On execution of the stored procedure, = certain=20 tables are updated, that causes triggers on the tables to run. These = triggers=20 are in turn executing a stored procedure and so on resulting in a lot of = database activity. </SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana"></SPAN><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">2.    We = do not=20 have control on the database (tables, triggers etc cannot be modified by = us).=20 <o:p></o:p></SPAN></P> <DIV class=3DMsoNormal style=3D"mso-list: l0 level1 lfo1"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Verdana">3.   Also, another=20 C++ application is running in background that constantly pumps data into = the=20 database. This application updates many tables at a time in a = transaction (and=20 hence holds locks on the database tables).<o:p></o:p></SPAN><FONT = face=3DVerdana=20 size=3D2> </FONT></DIV> <DIV class=3DMsoNormal style=3D"mso-list: l0 level1 lfo1"><FONT = face=3DVerdana=20 size=3D2></FONT> </DIV> <DIV class=3DMsoNormal style=3D"mso-list: l0 level1 lfo1"><SPAN=20 style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Issue = :</SPAN><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> After = running a=20 single instance of Windows application for about 8-9 hours, the = following error=20 was received:<o:p></o:p></SPAN></DIV> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: = Verdana">System.Data.SqlClient.SqlException:=20 Timeout expired. The timeout period elapsed prior to completion of the = operation=20 or the server is not responding.<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana"><o:p><FONT = face=3DVerdana=20 size=3D2></FONT></o:p></SPAN></P> <P class=3DMsoNormal> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana"><o:p><FONT=20 face=3DVerdana size=3D2></FONT></o:p></SPAN></P><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">I am not sure as to what = could be=20 the cause of this problem??<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana"><o:p><STRONG>This = problem  is=20 not faced on development server. I am facing this problem only on = production=20 server.</STRONG></o:p></SPAN></P> <P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: = Verdana">Can=20 someone suggest a solution to the above problem or provide valuable = tips/new=20 approaches to counter this problem.<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">I need to solve = this problem=20 ASAP. Please reply ASAP.<o:p></o:p></SPAN></P></BODY></HTML> ------=_NextPart_000_0008_01C3B9BF.20552950-- Tag: OleDB returning DBNull for certain cells Tag: 73370
  - 20
    - datatable deletion I need to collect all thedeleted rows of a datatable How can I collect the deleted rows of a datatable? Tag: OleDB returning DBNull for certain cells Tag: 73367
  - 21
    - Restore via SQLDMO fails after ADO.NET access Hi, I have written an utility that makes a backup (via SQLDMO) of a SQL Server database, then issues various ADO.NET Commands to this database. In case of any error it restores the database from the backup (also via SQLDMO). Problem is, when I want to do the Restore after an Error, the Restore fails with the following error message "Exclusive access could not be obtained". I have made sure that all ADO.NET Commands close their respective connections (via the using statement) so what am I missing here? If I don't issue any ADO.NET Commands the Restore works just fine. Stefan Tag: OleDB returning DBNull for certain cells Tag: 73366
  - 22
    - Typed DATASET help I have typed dataset and i don't know how to filter rows of table A according to children rows in table B Example TABLE USER has columns ID,Name Table USERNICK has columns nickname, ID Relationship is : each user can have many nicksname. (1,N) using dataview, i want to show ALL user in table USERS which has nickname " MAT" Anyone can help?? Tag: OleDB returning DBNull for certain cells Tag: 73363
  - 23
    - In ADO.NET connection, why DRIVER type is dropped? Hi experts! In ADO.NET connection, why DRIVER type is dropped?. Only PROVIDER is used. Pls i need a big explanation. thanx in advacne. Tag: OleDB returning DBNull for certain cells Tag: 73362
  - 24
    - how to encode the password included both single and double quotions in connection string how to encode the password included both single and double quotions in connection string? How to build connection string for the password ["']? I tried to enclose it by a quotion and double enclosed quotion as MSDN says but .Net tries to connect using the password without quotions at all. I tried: a\ new SqlConnection("server=(local);user id=user;pwd='\"''"); b\ new SqlConnection("server=(local);user id=user;pwd='\"'''"); c\ new SqlConnection("server=(local);user id=user;pwd=\"\"'\""); d\ new SqlConnection("server=(local);user id=user;pwd=\"\"\"'\""); In cases a\ and c\, the exception is "Format of the initialization string does not conform to specification starting at index ..." In cases b\ and d\, the exception is "Login failed for user 'user'.", and .Net tries to connect with the password ["] in the case b and ['] in the case d\ Tag: OleDB returning DBNull for certain cells Tag: 73361
  - 25
    - ADO .NET - novice needs help Hi There, I am trying to execute some stored querys in my access 2000 database, I would like to do them in ADO .net but I am haing syntax troubles. This is how I would normally do it in .asp, could someone post the equivilent of this code in ADO.net please? Sean set objConn = server.createobject("adodb.connection") objConn.open db_conn Set objRec = Server.CreateObject("ADODB.Recordset") Set oCMD = Server.CreateObject("ADODB.Command") oCMD.ActiveConnection = objConn oCMD.CommandType = adCmdStoredProc oCMD.CommandText = "sp_UpdateCatagorie" oCMD.Parameters.Append oCMD.CreateParameter("pCatid",adInteger) oCMD.Parameters("pCatid") = intTheCatid oCMD.Parameters.Append oCMD.CreateParameter("pCatDesc", adVarChar, adParamInput,255) oCMD.Parameters("pCatDesc") = strTheCatName oCMD.Execute Tag: OleDB returning DBNull for certain cells Tag: 73350

Hi,

I'm using OleDBConnection to read data from
Excel. I'm able to read everything except when a cell has
numeric value and the column has alphanumeric data. I get
DBNull when it encounters a numeric value. I'm sure many
people have seen this. Does anyone know how to address
this issue?

Thanks,
Paul

Top

OleDB returning DBNull for certain cells by mklapp

mklapp
Thu Dec 04 12:31:49 CST 2003

Hello,

You can use the IIF statement, although with some
object hierarchies each statement can get pretty long.

There is also a KB article explaining how to modify a
Dataset's XML to supply a default value when a DBNull is
encountered. The article ID is : 318039
Fair warning, though, I followed the instructions
exactly and I do not get the reported results, so if you
can use the KB solution and get it working, let me know.

mklapp

>-----Original Message-----
>Hi,
>
>I'm using OleDBConnection to read data from
>Excel. I'm able to read everything except when a cell
has
>numeric value and the column has alphanumeric data. I
get
>DBNull when it encounters a numeric value. I'm sure
many
>people have seen this. Does anyone know how to address
>this issue?
>
>Thanks,
>Paul
>.
>

Top