Additional functions in DataColumn.Expression

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
    - Dataset for specific table structure for CheckBoxList This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3C561.D82B93E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello! I wonder what is the best way to create a dataset for the table = structure below and use it with a CheckBoxList. Table structure Contacts Events ContactEvents ContID EventID _ContID ContName EventName _EventID =20 Example of data Contacts Events ContactEvents 230, Elvis Presley 13, Golf 230, 29 234, Bill Clinton 14, Soccer 234, 29 237, Stuart Graham 17, Hockey 234, 28 21, Basket 234, 17 28, Fotball 237, 13 29, Music 237, 14 In example above you can see, that Elvis likes Music. Bill likes Music, = Fotball and Hockey. Stuart likes Golf and Soccer. I have a CheckBoxList with all the Events where the user should be able = to check or uncheck the different events. If I want to add Music event = to Stuart my save function deletes all rows in ContactEvents with = _ContID=3D237, return the CheckedItems, and inserts three new rows with = _ContID=3D237. This doesn't seem to be the best solution. I don't get = how to do this, and how to write the select query for the dataadapter to = get all Events (so a commandbuilder can be used). I think I should be = able to use less code and letting the components do the work?!?! The = CheckBoxList has the Datasource property (and Displaymember/Valuemeber), = but I can't find the benifits of using it. Should I use another component? Regards Magnus ------=_NextPart_000_0008_01C3C561.D82B93E0 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.2713.1100" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hello!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I wonder what is the best way to create = a dataset=20 for the table structure below and use it with a = CheckBoxList.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><U>Table structure</U></FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2><FONT=20 face=3D"Courier = New">Contacts          =      =20  <FONT=20 size=3D2>Events         &nbs= p;=20 ContactEvents</FONT></FONT></FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  =20 ContID           &= nbsp;   =20   =  EventID         =20 _ContID</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  =20 ContName          &nbsp= ;  =20    EventName       =20 _EventID</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  </FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2><U>Example of = data</U></FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2> <DIV><FONT size=3D2><FONT=20 face=3D"Courier = New">Contacts          =     =20   <FONT=20 size=3D2>Events         &nbs= p;=20 ContactEvents</FONT></FONT></FONT></DIV></FONT><FONT face=3D"Courier = New"=20 size=3D2>   230, Elvis = Presley       13,=20 Golf         230, = 29</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   234, Bill=20 Clinton        14,=20 Soccer       234, 29</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   237, Stuart=20 Graham       17,=20 Hockey       234, 28</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;     21,=20 Basket       234, 17</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;    =20 28, Fotball      237, 13</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;    =20 29, Music        237, 14</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2><FONT = face=3DArial></FONT></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>In example above you can see, that = Elvis likes=20 Music. Bill likes Music, Fotball and Hockey. Stuart likes Golf and=20 Soccer.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have a CheckBoxList with all the = Events where the=20 user should be able to check or uncheck the different events. If I want = to add=20 Music event to Stuart my save function deletes all rows in = ContactEvents=20 with _ContID=3D237, return the CheckedItems, and inserts three new = rows with=20 _ContID=3D237. This doesn't seem to be the best solution. I don't get = how to do=20 this, and how to write the select query for the dataadapter to get = all=20 Events (so a commandbuilder can be used). I think I should be = able to=20 use less code and letting the components do the work?!?! The = CheckBoxList has=20 the Datasource property (and Displaymember/Valuemeber), but I can't = find=20 the benifits of using it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Should I use another = component?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards = Magnus</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3C561.D82B93E0-- Tag: Additional functions in DataColumn.Expression Tag: 74869
  - 2
    - ANN: Report Sharp-Shooter 1.6 has just been released! 9Rays.Net is pleased to announce: Report Sharp-Shooter 1.6 has just been released! New features include: -New report designer - Unlimited undo/redo - Document tree - Data Sources tree with drag'n'drop - Possibility of building custom designer from blocks (ToolBox, ToolBar, PropertyGrid, DocumentTree etc.) - Full design time for third party business objects (not ADO.NET) - Many improvements -New fast excel export filter (does not require installing of Microsoft Excel) -RichText control -More stable work in ASP.NET applications -New exception handling mechanism with easy bug-tracking -New examples Visit us at www.9rays.net for more info. -- Eugene Akinshin, PhD 9rays.net (Reporting and instrumentation components) Tag: Additional functions in DataColumn.Expression Tag: 74867
  - 3
    - TextBox databinding (using endcurrentedit) Hi, I have a .NET textbox bound to a DataColumn (String data type). What I want is that when the the user leaves the focus from the textbox, the changes are automatically updated to the the DataTable (ie containing the Datacolumn to which the textbix is bound). The method I use is to call the 'EndCurrentEdit' method for the corresponding CurrencyManager. This method works fine except under the following condition: The textbox undergoes a modification such that the length of the Text property in the TextBox does not change (ie is the same as that of the String in the DataColumn). This happens for example when a user makes a type and changes one letter (or two) instead of adding new words or deleting words. In this case, the datarowview (referenced by the 'Current' property in the corresponding CurrencyManager) is not in edit mode (ie 'IsEdit' is false). Calling 'EndCurrentEdit' will not update the DataColumn at all. Can anyone confirm this is a .NET bug? Is there a workaround for this? Does this happen in any other .Net controls? Thanks in advance. A sample code is available. John Tag: Additional functions in DataColumn.Expression Tag: 74864
  - 4
    - Oracle Client Namespace I am getting an error ORA-12154: TNS:could not resolve service name the following code i am using Dim oraconn As New OracleConnection("server=exxxx1;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") The following code generate the error below: Dim oraconn As New OracleConnection ("server=xxxxx1.xx.xx.com;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") ORA-01004: default username feature not supported; logon denied Dim oraconn As New OracleConnection("Data Source=xxxxx1.xx.xx.com;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") ORA-01004: default username feature not supported; logon denied I tries using oledb and odbc also. I am unable to connect to the oracle. I read in one of the articles that since the ASP.NET is running a impersonate account in the windows it may not access OCI. But i given Admin acess to asp.net account. Am i missing something? Thanks Ravi Tag: Additional functions in DataColumn.Expression Tag: 74858
  - 5
    - Auto Incrementing Values I have an Invoice table in my database with 'InvoiceID' as its primary key. I would like the InvoiceID field to auto increment values in the format INV1, INV2, INV3........INV100.so on and so forth. How do I go about it? Thanks! Tag: Additional functions in DataColumn.Expression Tag: 74851
  - 6
    - Multiple Fill() calls crash system I'm using ODBC with MySQL, and am having difficulties updating a DataSet when using a parameterized query multiple times. The SELECT queries I'm using work fine with multiple Fill() commands if they don't have parameters, but the param. versions generate the following ODBC error when run the second time: [MySQL][ODBC 3.51 Driver][mysqld-3.23.40-nt] SQLBindParameter not used for all parameters I've tried calling Clear() on the DataSet to no avail. In stepping through the code, I've found that everything is initialized and all parameters have values, the only difference seems to be that a few internal variables of OdbcParameterCollection named CollectionIsBound and BindingIsValid start out False before the first Fill() and end up True after it. Furthermore, and ODBC trace shows that before the first Fill(), there are some calls to: SQLBindParameter. Before the second Fill(), there are no such calls. It seems like ADO is not sending the parameters to the ODBC driver after the first Fill(). Any suggestions? Thanks, Jim Tag: Additional functions in DataColumn.Expression Tag: 74850
  - 7
    - insert failes I'm tring to insert a new row to a table but it seems that it failes (I think) because the values of the new Row are null. here is the defenition of the table, I suspect that my problem is in the defenition. create table aa.dbo.Tasks ( ID int primary key identity(1,1), Done bit, TaskGroup varchar(30), Subject varchar(40), Initiator int, Resource int, Note varchar(200) ) Do I need to define default values? Yoramo Tag: Additional functions in DataColumn.Expression Tag: 74848
  - 8
    - default value in SQL Hi all, Does anyone know how to retrieve the default value set in Sql server in ASP.Net? any help or guildence will be appreciated. Calvin Tag: Additional functions in DataColumn.Expression Tag: 74847
  - 9
    - SQL Server Desktop Installation I recently bought a copy of Visual C#.NET Deluxe Learning addition. I was under the impression that this comes with SQL Server Desktop Engine. I installed everything I should have (I think), but when I type the commands to grant access to SQL at the DOS prompt, it tells me that SQL Server doesn't exist. The actual error message reads as follows: [DBMSLCPN]SQL Server does not exist or access denied. [DBMSLCPN]ConnectionOpen (Connect()). The problem might be that I also bought a learning addtion of Visual Basic.NET, and it told me it was installing "different" components than those already installed. However, I have two DIFFERENT installations of the .NET framework now; one that allows for C# development and one that allows for VB development. I can't imagine that ALL components were overwritten. I suppose I could re-install C# and hope for the best. Does anyone out there have any experience with this? Thanks in advance for your help. Tag: Additional functions in DataColumn.Expression Tag: 74844
  - 10
    - No Results Hello, I have looked at this and then looked at it somemore, but I can't see anything wrong... Here is my senario. I wrote a stored procedure to return information about the parms in a stored procedure. The idea being is that I will build all my Parameters for any stored procedure mechanically. I run this procedure in Query Analyzer and it runs fine I run the procedure in VS.Net as a stand alone proc and it runs just fine (says it returned 2 rows). I run the same procedure in a C# program, and it executes but no results ever comeback. I get a return code of 0, but no results. I put some code in and wrote all all the parm names and their values in the debug window, cut and pasted those values into Query Analyzer and ran those exact same parm names and values - and it ran fine - bringing back results. The only difference is that there were two parms in which I loaded "DBNull.Value" and I had to type "null" in query analzer. I have tried using a DataReader and a DataAdapter with each running successfully, but still no rows. How in the world could it run everywhere else other in my c# code? Here is some code... Set up my parms... cmd.Parameters.Add("@procedure_name",SqlDbType.NVarChar,390).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_name"].Value= ProcName; cmd.Parameters.Add("@procedure_owner",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_owner"].Value=dbOwner; cmd.Parameters.Add("@procedure_qualifier",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_qualifier"].Value=dbName; cmd.Parameters.Add("@column_name",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@column_name"].Value=DBNull.Value ; cmd.Parameters.Add("@ODBCVer",SqlDbType.Int,2).Direction = ParameterDirection.Input; cmd.Parameters["@ODBCVer"].Value=System.DBNull.Value ; cmd.Parameters.Add("@RETURN_VALUE",SqlDbType.Int).Direction = ParameterDirection.ReturnValue ; My Command... cmd = new SqlCommand(); cmd.CommandText= dbName + "." + dbOwner + "." + ProcName; cmd.CommandType = CommandType.StoredProcedure; My Open cmd.Connection.Open(); The DataReader SqlDataReader dr = cmd.ExecuteReader(); The Read... while (dr.Read()) { Do Somthing - never get in here } Any Ideas? Tag: Additional functions in DataColumn.Expression Tag: 74835
  - 11
    - Connection won't disappear from SQL Server until app closes I have no problems connecting to SQL Server 2000 from VB.net and using all it's functions. However, when I close the connection, it stays active on the server until the application is closed. I have tried running commands with the drop connection parameter, closing the connection with close, dispose and setting it to nothing. Here is a sample of the code. The results of the code below is that the connection stays active. Is there a setting in VB, ADO.NET or SQL Server I can tweak to fix this? thanks in advance! Dim myConnection As New SqlConnection("data source=SRV-DC-MULTI1;database=Technical;Integrated Security=True") myConnection.Open() MessageBox.Show("ServerVersion: " & myConnection.ServerVersion & ControlChars.Cr & _ "State: " & myConnection.State.ToString()) myConnection.Close() myConnection.Dispose() myConnection = Nothing MsgBox("pause 2") Tag: Additional functions in DataColumn.Expression Tag: 74834
  - 12
    - Bug in SqlConnection, SqlClient connection pool or DTC? SqlConnection throws an exception when disposed if it is manually enlisted in a distributed transaction: System.InvalidCastException: Specified cast is not valid. Server stack trace: at System.Data.SqlClient.ConnectionPool.PutConnectionManualEnlisted(SqlInternalConnection con) at System.Data.SqlClient.ConnectionPool.PutDeactivatedConnection(SqlInternalConnection con) at System.Data.SqlClient.SqlConnection.Close() at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() The error occurs when the transaction is cast to UCOMIConnectionPoint. I have tried to enlist in a distributed transaction created by a serviced component and a transaction created by the DTC proxy. Both yield the same error. The problem seems to be that the transactions created by my DTC doesn't support IConnectionPoint (I use Windows XP pro). I guess that the connection point is used to get a notification when the transaction ends and it is safe to return the connection to the connection pool. (OracleClient doesn't fail (the same way). It doesn't need the connection point. It returns connections directly to the connection pool when the they are disposed even if they still participate in a distributed transaction!) Is this a bug in SqlConnection, the SqlClient connection pool, the DTC or my code? Below is a short sample that generates the error. I need to enlist in the distributed transaction manually, because I want to use distributed transactions without using COM+. Any suggestions? Regards Søren Mondrup -----demo.cs---------------------------------------------- using System; using System.Reflection; using System.Data; using System.Data.SqlClient; using System.EnterpriseServices; using System.Runtime.InteropServices; [assembly: AssemblyKeyFileAttribute("demo.snk")] class App { static void Main(string[] args) { if (args.Length == 0) { Console.WriteLine("Usage: demo.exe <server_name>"); return; } try { string connStr = "Server=" + args[0] + ";Trusted_Connection=SSPI;Database=pubs;Enlist=false;"; using (ServicedFoo foo = new ServicedFoo()) { foo.DoTransaction(connStr); } } catch(System.Exception e) { Console.WriteLine(e); } } } [Transaction(TransactionOption.RequiresNew)] public class ServicedFoo : ServicedComponent { public void DoTransaction(string connStr) { ITransaction tx = (ITransaction) ContextUtil.Transaction; if( tx == null ) throw new Exception("Failed to create transaction."); using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); conn.EnlistDistributedTransaction(tx); Console.WriteLine("Enlisted in transaction"); using (SqlCommand cmd = new SqlCommand("update sales set qty = qty + 1", conn)) { cmd.ExecuteNonQuery(); } ContextUtil.SetComplete(); Console.WriteLine("Has voted in favor of commit. Now disposing connection."); } // conn.Dispose() is called and an exception is thrown } } ----------------------------------------------------------- compile sample with sn ?k demo.snk csc demo.cs Tag: Additional functions in DataColumn.Expression Tag: 74829
  - 13
    - Binding forms? Hi, Do I have to release binding of form controls to dataset every time I do form search of filling?I mean, is there a shorter way than this? 'Binde textbox1 to dataset textbox1.databindings.add("text",ds,"Employees.firstname") 'unbinde for ReUse of binding prpty. Loop through all controls that were bound. textbox1.databindings.clear MTIA, Grawsha Tag: Additional functions in DataColumn.Expression Tag: 74828
  - 14
    - DataReader Hello, I am transitioning from VB to C# and I can't tell if my problem is to do with the format of my command or something else. I am getting an error of "Object reference not set to an instance of the object" when it hits this line of code.. int rtnValue = (int) cmd.Parameters["@RETURN_VALUE"].Value; I set my Parameter up as follows: cmd.Parameters.Add("@RETURN_VALUE",SqlDbType.Int).Direction = ParameterDirection.ReturnValue ; I used a "foreach" to loop through each of my parms, with the @RETURN_VALUE being the last one. Each time this loop generates the same error when it gets to the "@RETURN_VALUE". I do not see anything wrong with how I have set it up. Does the procedure that I am executing "HAVE TO" use the "return statement in order to properly populate the parm? Any ideas? Thanks inadvance for your assistance!!!!!!!!! Tag: Additional functions in DataColumn.Expression Tag: 74825
  - 15
    - GUID as parameter to stored proc causes Invalid Cast I am using the Microsoft Data Access Application Block for .NET code to interface to our SQL database. I have a stored procedure (CREATE procedure ixe_MarkBranchStatus @NodeState int = 0, @rootnode uniqueidentifier = null). I have the data for rootnode store as a string representation of a GUID in my C# program. I use the following code to supply the parameters: ********************************************************* storedParams = SqlHelperParameterCache.GetSpParameterSet (connStr,SQL_Name); for (int i = 0; i < storedParams.Length; i++) { switch (storedParams[i].ParameterName.ToUpper()) { case "@NODESTATE": storedParams[i].Value = newStatus; break; case "@ROOTNODE": storedParams[i].Value = GUID; break; } } if (SqlHelper.ExecuteNonQuery (connStr,CommandType.StoredProcedure,SQL_Name,storedParams) > 0) return true; *********************************************************** The SQLHelper (Microsoft supplied code) bubbles up an error: Invalid cast from System.String to System.Guid. The line that causes the error is: int retval = cmd.ExecuteNonQuery(); but a lot has gone on before this. This was not a problem until I recently converted from VS .NET, framework 1.0 to VS 2003, framework 1.1 Tag: Additional functions in DataColumn.Expression Tag: 74823
  - 16
    - Multiple transactions on the same connection? Hi, Wanted to know if I can have multiple transactions over the same connection. I am planning to have only one connection object in my application. For multiple users I want to begin different transctions over the same connection. I would be storing the transaction objects by userid in a hashtable. All the methods would then take in the userid and also know the right transaction object to be associated to the command object. Would this work.. ?? I do not think the transactions would be nested..as do not know what each user might do.. Thanks in advance. Tag: Additional functions in DataColumn.Expression Tag: 74822
  - 17
    - C# Training Videos Currently our C# Videos are free. Check them out at: http://www.vtmag.com We will be adding additional topics in the next few days like: ADO.NET ASP.NET VB.NET WinForms Application Blocks P.S. After viewing the videos go back to the website and rate them or send an email to let us know how we are doing! Thanks, Wade Beasley *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Additional functions in DataColumn.Expression Tag: 74821
  - 18
    - DbType To SqlDbType Is there some documentation which identifies how to translate a DbType to a SqlDbType and vice versa? Tag: Additional functions in DataColumn.Expression Tag: 74814
  - 19
    - SqlDataType Mone/SmallMoney In a VB.Net client, what datatype do you use in to supply a parameter of type "Money" or "smallMoney" Thanks in advance for your assistance! Tag: Additional functions in DataColumn.Expression Tag: 74808
  - 20
    - DataTable row changed Hi Is there a way to know if rows has been added/deleted from a DataTable (not using the exevts)? Thanks, Ronen Tag: Additional functions in DataColumn.Expression Tag: 74803
  - 21
    - ADO.Net Connection Strings Does anyone know the full connection string to use with ado.net for Sybase as well as PostGresql 3.0? Thanks Tag: Additional functions in DataColumn.Expression Tag: 74798
  - 22
    - Beginner question: run .sql I'm starting with ADO.NET and I found several samples where they ask to run .sql files (for creating stored procedures or so). I have the MSDE SQL Desktop engine and do not know how to run a sql script for this DB. Can I do it from inside VS.net ? Thanks Tag: Additional functions in DataColumn.Expression Tag: 74786
  - 23
    - navigation bar does not pass to added rows Hello I have created a simple application that has a form that displays one row each time. I have used the wizard to generate the code. my problem is that I can not navigate to added rows, I see the count of rows increasing but the navigation controls refuse to point on them. Can any one advice? Yoramo Tag: Additional functions in DataColumn.Expression Tag: 74779
  - 24
    - Updating hierarchical data I'm working with the Northwind database tables 'Customers', 'Orders', and 'Order Details': 'CustomerID' relates 'Orders' to 'Customers', and 'OrderID' relates 'Order Details' to 'Orders'. For displaying this hierarchical data I create a DataSet, append and fill a DataTable for each database table, and finally set up two Relations. Say, I want to bind the dataset to a flat (WebForms) DataGrid where each row consists of the columns 'CompanyName' (from table 'Customers'), 'OrderDate' (from table 'Orders'), and 'Quantity' (from table 'Order Details'). The grid should be editable, i.e. each data modification should be send back to the database. Are there any guidelines for implementing this efficiently? Is it possible to bind datagrid columns to different DataTables (which in turn belong to the same DataSet)? How can I retain the relationship between columns and DataTable items? Thanks in advance, PontiMax Tag: Additional functions in DataColumn.Expression Tag: 74772
  - 25
    - Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers The driver and provider lists (below) have recently been updated and moved to a new web site (www.SQLSummit.com): ODBC drivers http://www.sqlsummit.com/ODBCVend.htm .NET Providers http://www.sqlsummit.com/DataProv.htm OLE DB Providers http://www.sqlsummit.com/oledbven.htm JDBC drivers http://www.sqlsummit.com/JDBCVend.htm DB2 Extenders http://www.sqlsummit.com/extenven.htm Tag: Additional functions in DataColumn.Expression Tag: 74771
- Next
  - 1
    - BUG? OleDb AccessMdb Localization I think I found a bug in .NET 1.1 using the OleDb classes using: .NET 1.1 Access MDB file (2000 format) Localization set to Dutch (or probably any localization where the , is used for decimal and . is used for thousands) steps to reproduce problem: Create a OleDbCommand with a sql statement like INSERT INTO [TABLENAME] ( [DECIMALFIELDNAME] ) VALUES( ? ) Then use the Parameters.Add on the OleDbCommand to add a number for the ? variable, that uses a decimal. For example 2.75m After the insert executed the record appears as if no decimal sign was there, in this case it would be 275 instead of 2.75 probable cause: I think oledb (or access?) expects the value in local format, while OldDbCommand.Parameters supplies the InvariantCulture version. Tag: Additional functions in DataColumn.Expression Tag: 74770
  - 2
    - Object reference not set to an instance of an object What's wrong with this code? it would work perfect in vb. VB.net seem to be filled with error triggers... <script language="VB" runat="server" src="/scripts/main_lib.vb"></script> <script language="VB" runat="server"> Public PollMode As string = "vote" ' ***** the code below fails as object reference not set! Public urlRedirect As String = Request.ServerVariables("SCRIPT_NAME") </script> Please help. Tag: Additional functions in DataColumn.Expression Tag: 74753
  - 3
    - filtering child records How can you get the child records of a master record and then further filter the returned array down to more specific records? For instance, I search the array containing the child records for rows that have a value of "Today" in the Date column. I then want those identified rows copied to another array. Thanks for all responses. Regards, Martin Williams Tag: Additional functions in DataColumn.Expression Tag: 74752
  - 4
    - Unleash XML support from native Oracle Database driver Download Oracle Data Provider for .NET (ODP.NET) (http://otn.oracle.com/tech/windows/odpnet/index.html) today to empower your .NET applications with the Oracle Database! Try out the new features for XML support like: - Store XML data natively in the database server as the Oracle database native type, XMLType. - Access relational and object -relational data as XML data from an Oracle database instance into Microsoft .NET environment, process the XML using Microsoft .NET framework - Save changes to the database server using XML data. - Apply XSL Transformations while querying and retrieving relational data as XML from Oracle 8i or higher database into .NET Developers get started, learn about ODP.NET XML support features using comprehensive sample applications available at http://otn.oracle.com/sample_code/tech/windows/odpnet/index .html For providing feedback please use discussion forum at ODP.NET: http://forums.oracle.com/forums/forum.jsp? forum=146 Sample Code: http://forums.oracle.com/forums/forum.jsp? forum=133 Tag: Additional functions in DataColumn.Expression Tag: 74750
  - 5
    - Problem w/ SQL server's default value Hi all, I have a problem when creating a new record in SQL database when the column is Non-Nullable w/ default value. What I did was create SqlDataAdapter and DataSet, filled the DataSet w/ data AND schema. However, when I try to create a record with those default columns empty (i.e. not assigning value to them), the Update method of Adapter raises an exception that I am trying to creating a record w/ the non-nullable column set to null, even tho I have create a default value for them in Sql server. Any help would be appreciated. Calvin Tag: Additional functions in DataColumn.Expression Tag: 74748
  - 6
    - SqlServer: How to know if a a column is a primary key ? I have a database-generic application. CommandBuilder is not satisfactory. I try to generate my own command automatically but: I can't get PrimaryKey information ! I create a IDbCommand cmd;. cmd.CommandText = SELECT * FROM Table IDataReader dr = cmd.ExecuteReader(CommmandBehavior.SchemaOnly) and then I analyse dr.GetSchemaTable() the column "IsKey" is always set to DBNull.Value, at last on the PocketPC (with the compact framework) I know there is plenty of meta table in SqlServer. which one should I query to get primary key information ? Tag: Additional functions in DataColumn.Expression Tag: 74737
  - 7
    - SqlServer schema table erroneous ? I have a very basic test SqlServer table: Key ID Name DataType X id_0 int X id_1 int id_3 char I use the DataReader's method: GetSchemaTable() to get this information from the database in my .NET program (on the PPC, I use the compact framework) the column "IsIdentity" seems to be correctly filled. whereas the column "IsKey" seems to be not in fact I run the method in the debugger, querying manually all the column, I have no particular info on the "id_0" column, absolutely no way to know it's a primary key column !.... is it a bug of SqlServer in general ? or on the Compact frameqork in particular ? is there an other way to know a column is a primary key ? Tag: Additional functions in DataColumn.Expression Tag: 74734
  - 8
    - to make datetime nullable Dear all, how can i pass an null or empty-value to datetime object? I need to use a datatable to update an oracle table, and the datatable contains a datacolumn, e.g. orderdate, which is of type datetime. Any suggestion will be appreciated. Alex Tag: Additional functions in DataColumn.Expression Tag: 74733
  - 9
    - Importing XML data into SQL Server table. I just converted an Access 2002 application into VB.NET (don't ask). VBA in Access has a nifty command for importing XML into an Access table called, unsurprisingly ImportXML(). It works like this: Application.ImportXML ([XML Filename]). The table name is a field in the .xml file. So, my question is, how do I do this in VB.NET using ADO.NET into SQL Server? There's a DataSet command called ReadXml that (supposedly) loads a DataSet with data from a .xml file. But how do I save that data in my SQL Server database? I've tried this: Dim da As DataAdapter = New DataAdapter("SELECT * FROM [tblName]", sqlDBConn) Dim ds As New DataSet ds.ReadXml([XML Filename]) da.Update(ds) ...to no avail. And I've tried: Dim da As DataAdapter = New DataAdapter("SELECT * FROM [tblName]", sqlDBConn) Dim ds As New DataSet Dim dt As DataTable = ds.Tables.Add"([tblName]") ds.ReadXml([XML Filename]) da.Update(ds) ...also to no avail. Please help. Thank you. Tag: Additional functions in DataColumn.Expression Tag: 74732
  - 10
    - Bulk Copy Does ADO .NET have a feature like BCP? Tag: Additional functions in DataColumn.Expression Tag: 74712
  - 11
    - Oracle stored procedure from ADO.NET Hi All, Here is the oracle sp... procedure budget_report(report_cursor out rdsrefcur.genrefcur, report_teva_id varchar2, report_year number, report_start_month number default 1, report_end_month number default 12) ************************************************************************* Here is the vb code... Dim cn As New OleDbConnection("connect string") cn.Open() Dim cm As New OleDbCommand cm.Connection = cn cm.CommandType = CommandType.StoredProcedure cm.CommandText = "TN_ADMIN.REPORTS.BUDGET_REPORT" Dim parmReport_id As New OleDbParameter parmReport_id.DbType = DbType.AnsiString parmReport_id.Direction = ParameterDirection.Input parmReport_id.ParameterName = "report_id" parmReport_id.Value = "A001987" Dim parmReport_year As New OleDbParameter parmReport_year.DbType = DbType.Double parmReport_year.Direction = ParameterDirection.Input parmReport_year.ParameterName = "report_year" parmReport_year.Value = 2003 Dim parmReport_start_month As New OleDbParameter parmReport_start_month.DbType = DbType.Double parmReport_start_month.Direction = ParameterDirection.Input parmReport_start_month.ParameterName = "report_start_month" parmReport_start_month.Value = 2 Dim parmReport_end_month As New OleDbParameter parmReport_end_month.DbType = DbType.Double parmReport_end_month.Direction = ParameterDirection.Input parmReport_end_month.ParameterName = "report_end_month" parmReport_end_month.Value = 11 cm.Parameters.Add(parmReport_id) cm.Parameters.Add(parmReport_year) cm.Parameters.Add(parmReport_start_month) cm.Parameters.Add(parmReport_end_month) Dim rdr As OleDbDataReader = cm.ExecuteReader DataGrid1.DataSource = rdr DataGrid1.DataBind() cn.Close() ************************************************************************* When I run this thing I get... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'BUDGET_REPORT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored ************************************************************************* Does anyone have any idea what is wrong? This thing is driving me nuts. Thanks, Jeff Tag: Additional functions in DataColumn.Expression Tag: 74710
  - 12
    - Initializing ADO.Net SQL connection in Windows Service. I am trying to initialize an ADO.Net SQL connection to an sql server in my Windows service and I'm getting the following exception while trying to initialize the SqlConnection Object. The language is C#. System.ArgumentException: Unknown connection option in connection string: user. at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String conString, Hashtable values) at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in c:\documents and settings\carlo razzeto\my documents\visual studio projects\notifyexpiredresume\expiredresume.cs:line 111 Here is what my connection string looks like and initializer looks like: private string ConnectionString = "Data Source=(local); User=sa; Password=****; Initial Catalog=JobSite"; public SqlConnection SQLConnection; try { SQLConnection = new SqlConnection(ConnectionString); } catch(Exception ex) { EvntLog.WriteEntry("There has been an exception trying to init SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error); EvntLog.Dispose(); return; } Tag: Additional functions in DataColumn.Expression Tag: 74698
  - 13
    - ADO.NET Behavior Hello, I am developing a web-based application for filtering rows of data in a datagrid and am running into a problem with deployment of the app. The application has a DropDownList that is populated from an SQLReader from a SQL 2000 Database. Once an item is selected from the DropDownList, the web site performs a postback then populates a DataGrid from another SQLReader that is filtered on the SelectedItem.value from the DropDownList. It is a fairly simple application and it works fine on my test box. However, when I copy the project to the server and try to execute it, the DropDownList does not populate, it is just blank, I do not get any warnings, errors, etc... My Machine is a 3.2Ghz, 1GB Ram, Windows XP Pro SP1 with Visual Studio .NET 2003, Framework 1.1. It also has an installation of Macromedia ColdFusion 5 Server, but that is not used often. It also has VirusScan 7.1 Enterprise for Scanning. The server is Dual 1Ghz with 2GB Ram, Windows 2000 server, .NET Framework 1.1, and ColdFusion 5 Server. Unlike my box, this version of ColdFuction is highly utilized. It also has VirusScan 4.5.1 for Scanning. I am stumped since the configurations are so similar. Also both boxes are at the latest system patches and have ADO 2.7 SP1 and the Microsoft SQL 2000 Client tools installed. If anyone has any ideas, I would greatly appriciate any input. Thanks in advance, Nathan The server Tag: Additional functions in DataColumn.Expression Tag: 74696
  - 14
    - Many records in ADO.NET Hi ! Has anyone any idea how can I do paging with ADO.NET, or any other way. I want to use it in a project that it has to load approx. 9000 records and they would grown up. Chris Tag: Additional functions in DataColumn.Expression Tag: 74694
  - 15
    - This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row. I receive this message when I try to execute a valid delete command against a dataset for which I have marked a row as Deleted. I have been struggling with this for a couple of days, and every bit of the documentation say that it should work. The sql is generated with an OleDbCommandBuilder object and populated using the original values of the columns in the row to delete (like this:) System.Guid linkToID = (System.Guid) curLinkRow[0]["LinkToID", DataRowVersion.Original]; . . . objectObjectsAdapter.DeleteCommand.Parameters["@p3"].Value = linkToID; Anyone found a way around this? Scott Tag: Additional functions in DataColumn.Expression Tag: 74681
  - 16
    - How to get list of all databases on a SQL Server? Can anyone tell me how to query a SQL Server for a list of the databases hosted by that server? Also, is there a method in the .Net Framework to query the network for a list of SQL Servers that are available? Thanks! Tag: Additional functions in DataColumn.Expression Tag: 74676
  - 17
    - Thoughts/advice on select optimizations I'm looking for thoughts/advice on how to build the fastest search + (paged) results-page in an .NET + SQL Server 2000 environment. I hope this is the proper group for this, otherwise i appologize for the spam. I have one table with around 100.000 records containing some text fields. What i need to do is free-text search through these records, and return a paged result to the client. The user should be able to select which field to sort by. I'm estimating 10.000 concurrent users on the system. My initial approach to this would be to do the initial search once (selecting records using a full-text indexing), and throw the result into a TEMP table. Each paged result the user requests would then be taken from this table, using DataAdapter.Fill(DataSet, startRecord, numberOfRecords) I am, however, not sure if this is the right approach. Not using a TEMP table would probably increase performance on the first results page, but I would assume the TEMP table helps decrease system load a lot on subsequent page requests. Also, I'm not completely sure if DataAdapter.Fill with startrecord, numberofrecords does only transfers the selected records to the web server, or if the entire resultset is transfered to the webserver, and the dataset THEN populated with the selected records. Does anyone have any thoughts on the best way to implement a system like this? Cheers, Thomas Tag: Additional functions in DataColumn.Expression Tag: 74671
  - 18
    - More XML Miha, First, thanks for your help. Without it, I would still be running in circles. I created the date datatypes as varchar(10) in the dataset. Of course in the table they are datetime. The problem I am having is I cannot get the dates to insert. All it does is put in null values. The XML document looks fine. Below is a date row that inserts as a null instead of a date. <LastPaidDate>06/19/2000</LastPaidDate> How much is this appreciated???? Well, if I ever get married again, you can dance at my wedding. How is that? J Thanks so much, Roy Tag: Additional functions in DataColumn.Expression Tag: 74669
  - 19
    - System.Data.OracleClient Problem: Could not create an environment: OCIEnvCreate returned -1 Below is the error message I am receiving on a production server with the Oracle 9.2 client installed. However, on a Oracle 9.0 client installation on the development server the problem does not occur. System.Exception: Could not create an environment: OCIEnvCreate returned -1. This occurs when trying to connect. using System.Data.OracleClient this.connection = new OracleConnection("Data Source=" + ConfigurationSettings.AppSettings["db_orac"] + ";User ID=" + ConfigurationSettings.AppSettings["db_user"] + ";Password=" + ConfigurationSettings.AppSettings["db_pass"] + ";"); this.connection.Open(); this.command = new OracleCommand(); this.command.Connection = this.connection; ds = new DataSet(); command.Parameters.Clear(); command.CommandText = "MyTableSpace.MyPackage.get_list"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new OracleParameter("io_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output; this.da = new OracleDataAdapter(this.command); this.da.Fill(ds,"List"); this.connection.Close(); I am desperately trying to find a solution. Any help would be much appreciated!! Regards, Ben Tag: Additional functions in DataColumn.Expression Tag: 74667
  - 20
    - Unspecified error: E_FAIL(0x80004005) I apologize for the duplicate post in Data Access NG. I get Unspecified error: E_FAIL(0x80004005) when trying to update Deleted and Modified Dataset records using the OleDB Command Builder. I have been successful with insert objects. The target database is DB2/400 with Client Access v5r2. Here is the partial code: dr = dsAs400.Tables("RSSC").Select("SCID = " & ScId) ''Resulting array length = 1 dr(0)("NAME") = "TEST" cnAs400.Open() Try Dim cmdBuilder As New OleDbCommandBuilder(daRssc) daRssc.UpdateCommand = cmdBuilder.GetUpdateCommand daRssc.Update(dsAs400, "RSSC") Catch ex As Exception Console.WriteLine(ex.Message) End Try cnAs400.Close() Thanks for any help. Tag: Additional functions in DataColumn.Expression Tag: 74666
  - 21
    - Row deletion and DataRowVersion.Original Sort of a newby question... I have a read only list view that is populated with information from a dataset. If the user selects a listview item and presses the delete button, then the item is removed fromt he list, and the underlying dataset is marked as delete (all conditional and error checking has been removed for this post): expr = "RelationshipName ='" + relationshipName + "' AND LinkFromID = '" + linkFromID + "' AND LinkToID = '" + linkToID + "'"; DataRow[] rows = this.objectObjectsTable.Select(expr, relationship.LinkFromIDColumn, DataViewRowState.Unchanged); rows[0].Delete(); According to all of the ADO.NET references I have seen, this does not physically remove the data from the dataset, but simply marks its RowState as deleted. And true to its word, when I interogate it in the quick-watch window, it is marked as deleted. Later in the session, I want to update the database to reflected the deleted row. This is done as follows: .. Method Name .. curTable = this.dataSet.Tables[relationship.TableName]; curAdapter = new OleDbDataAdapter(); OleDbCommand deleteCmd = this.deleteRelationshipCmds[0]; deleteCmd.Connection = oleDbConnection; deleteCmd.Transaction = dbTransaction; curAdapter.DeleteCommand = deleteCmd; DataView relationshipView = new DataView(curTable, "", "", DataViewRowState.Deleted); IEnumerator enumRelationships = relationshipView.GetEnumerator(); while (enumRelationships.MoveNext() && !bAbort) { DataRowView curRelationshipView = (DataRowView) enumRelationships.Current; objUpdateRows[0] = curRelationshipView.Row; try { if(objUpdateRows[0].RowState == DataRowState.Deleted) { curAdapter.DeleteCommand.Parameters.Add(relationship.Name, objUpdateRows[0][relationship.Name, DataRowVersion.Original]); curAdapter.DeleteCommand.Parameters.Add(relationship.LinkFromIDColumn, objUpdateRows[0][relationship.LinkFromIDColumn, DataRowVersion.Original]); curAdapter.DeleteCommand.Parameters.Add(relationship.LinkToIDColumn, objUpdateRows[0][relationship.LinkToIDColumn, DataRowVersion.Original]); } rowCount += curAdapter.Update(objUpdateRows); } catch { ... } } The building of the delete statement is done like this: private static OleDbCommand GenerateDeleteCommand(Elsinore.Engine.ClassRelationship objRelationship) { OleDbCommand cmd = null; if (objRelationship != null) { string relationshipTableName = objRelationship.TableName; if (relationshipTableName != null && relationshipTableName.Length > 0) { if (objRelationship.TableName == "Object_Objects") { string sqlText = "DELETE FROM " + Constants.DbOwner + Constants.DbEscapePrefix + Constants.DbNamePrefix + objRelationship.TableName + Constants.DbEscapeSuffix; sqlText += " WHERE RelationshipName=? AND LinkFromID=? AND LinkToID=?"; cmd = new OleDbCommand(sqlText); cmd.Parameters.Add("@p1", OleDbType.Char, 64, "RelationshipName"); cmd.Parameters.Add("@p2", OleDbType.Guid, 16, "LinkFromID"); cmd.Parameters.Add("@p3", OleDbType.Guid, 16, "LinkToID"); } } } return cmd; } So, what I want to do is during the OleDBAdapter.Update call, is remove the rows that are marked as Deleted. Since the current version of the Row's ItemsArray is inaccessible (I assume because it is marked as deleted), then I ask each column in the row to return me the original version of the data for which I can manually add as parameters to my delete command. Alas, this does not work, the original version of the row does not support access to the items array. So, does anyone have a suggestion about this problem that they could share with me? Thanks in advance. Scott Tag: Additional functions in DataColumn.Expression Tag: 74665
  - 22
    - Building parameters type conversion question. Im attempting to use the datareader.getschema table in order to create the schema table which supposedly produces a reference to the essential values. I will be able to map most of the SQLparameters using the values from the "DataType" and ColumnSize" but will not be able to differentiate between the char and nchar, varchar and nvarchar, and text and ntext values. I notice the "ProviderType" column probably refers to the sql data type and hesitate to use it for fear of changes down the road. Any way to truly map the required SqlParameter.dbtype or sqlparameter.sqldbtype from the datareader.getschema values or from a datatable created with fillschema using a dataadapter? Any info appreciated. Tag: Additional functions in DataColumn.Expression Tag: 74662
  - 23
    - Executing Master Stored Procedures I am going to run of the "Master" stored procedures, say "sp_sproc_Columns". It has a parameter with a datatype of "sysname". What exactly do I map this column to in the SqldbType? If some parms are set up in the procedure as accepting nulls, do I have to create an entry in the command.Parameter collection for these parms if I do not plan to pass any values? Thanks in advance for your assistance!!!!!!!! Tag: Additional functions in DataColumn.Expression Tag: 74661
  - 24
    - Problem with DBNull values for binary images Hi ! I´ve this code in my application for checking null values when inserting a [BinaryArray] (picture) into my SQL DB: If (ImageFile.PostedFile.ContentLengt =< 0) then sqlCommand.Parameters.Add("@Bild", sqlDbType.Image).Value = System.DBNull.Value Else sqlCommand.Parameters.Add("@Bild", sqlDbType.Image),Value = byteData End If I get a errormessage. Any suggestions how to solve this I would be much greatful..! The code works fine if I apply it to ordinary textfields controls like name.txt but not with the ImageFile - Why ? OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Additional functions in DataColumn.Expression Tag: 74657
  - 25
    - An error occured after loading the page when i use the RequiredFieldValidator object... i tried to use RequiredFieldValidator the page gives a alert after loding.. alert("Unable to find script library '/aspnet_client/system_web/1_0_3705_288/WebUIValidation.js'. Try placing this file manually, or reinstall by running 'aspnet_regiis -c'."); i have located the folder "aspnet_client" at desired location, but nothing is changed. i couldn't run the "aspnet_regiis -c" command from the command line from c:> what is the problem ? thanx... Sedat Eyuboglu www.bestflashdesigns.com www.18reklam.com Tag: Additional functions in DataColumn.Expression Tag: 74654

Any one know of a way to make additional functions
available in a DataColumn.Expression? I'm thinking of
things like date manipulation (DateDiff, etc.).

Is it possible to inherit from DataColumn?

Would I have to handle Changed events in the columns on
which the Expression was dependant, and then do the
calculation myself.

Are there any third party DataSet controls that would do
this kind of thing?

Top

Re: Additional functions in DataColumn.Expression by Miha

Miha
Thu Dec 18 07:17:23 CST 2003

Hi Sam,

Why don't you compute manually the field?
Just use ColumnChanged event and beware of recursion.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

"Sam" <samuel_d_jack@alias.com> wrote in message
news:08aa01c3c560$470ecb30$a601280a@phx.gbl...
> Any one know of a way to make additional functions
> available in a DataColumn.Expression? I'm thinking of
> things like date manipulation (DateDiff, etc.).
>
> Is it possible to inherit from DataColumn?
>
> Would I have to handle Changed events in the columns on
> which the Expression was dependant, and then do the
> calculation myself.
>
> Are there any third party DataSet controls that would do
> this kind of thing?
>
>
>
>

Top

Re: Additional functions in DataColumn.Expression by anonymous

anonymous
Thu Dec 18 09:43:57 CST 2003

I am hoping there is a 'nicer' solution than that.
Does anyone else have any other ideas?

>-----Original Message-----
>Hi Sam,
>
>Why don't you compute manually the field?
>Just use ColumnChanged event and beware of recursion.
>
>--
>Miha Markic - RightHand .NET consulting & software
development
>miha at rthand com
>
>"Sam" <samuel_d_jack@alias.com> wrote in message
>news:08aa01c3c560$470ecb30$a601280a@phx.gbl...
>> Any one know of a way to make additional functions
>> available in a DataColumn.Expression? I'm thinking of
>> things like date manipulation (DateDiff, etc.).
>>
>> Is it possible to inherit from DataColumn?
>>
>> Would I have to handle Changed events in the columns on
>> which the Expression was dependant, and then do the
>> calculation myself.
>>
>> Are there any third party DataSet controls that would
do
>> this kind of thing?
>>
>>
>>
>>
>
>
>.
>

Top

Re: Additional functions in DataColumn.Expression by v-kevy

v-kevy
Thu Dec 18 21:31:23 CST 2003

Hi Sam,

As far as I know, in the DataSet in ADO.net, the only way to achieve this
is to handle the ColumnChanged event.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Top