CHEWSTAN@nyc.rr.com

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
    - CSV.. Just curious to know is there any ole db provider for reading csv/text files... i know i can use Ole DB for ODBC ( Text Driver ) or also i can use DTSFlatFile ( ships with sQL Server ) but i don't want to install sql client on each of the client machine.. in addition is there any managed way of creating a DSN rather than going trhu p/invoke... thx in advance for your help... regards yogesh s Tag: CHEWSTAN@nyc.rr.com Tag: 75081
  - 2
    - General information on Enterprise Application design? Could someone give me a hint where to find *good* information, samples, tutorials, hints, whatever on design of multi/three-tiered applications, business layers etc (mainly winforms but web application information isn't bad, too)? ok, that isn't especially on enterprise size application but on applications that are well designed, changeable and maintainable. the things that interest me are especially - database abstraction, where it makes (not) sense, to use advanced db functions or use it only as backend, and why in which case - how and which layers/baseclasses to use in the code, best with code samples through the layers - how and at which level to let the different (data)objects interact with others - how to make sql queries. directly as strings or via classes that could make porting to other databases more easyly guess this are things that the most companys make themselves without knowing the drawbacks of their sw-designs.i'd like to know how to make it real good and not to write some code without any good concept and in the hope that it "seems to work" somehow in the end :) thx in advance, Daniel Tag: CHEWSTAN@nyc.rr.com Tag: 75069
  - 3
    - Converting an Oracle Data Reader into a SQL Server Data Reader Hi everybody, Does anybody know if it is possible to convert an Oracle Data Reader into a SQL Server Data Reader. I unsucessfully tried using the Ctype function. My problem is that I am developing a system that should work with both SQL Server 2000 and Oracle 9i. So I would like to use the same classes and methods to access both databases. Does anyone did it before? Thanks a lot, Amintas Tag: CHEWSTAN@nyc.rr.com Tag: 75068
  - 4
    - C#, Stored Procedure and Parameter Hi, I have a bug defined as below: * Northwind database, Customers table create a procedure GetCompanyName as below: ALTER PROCEDURE GetCompanyName @CustomerID nchar(5) AS SELECT CompanyName FROM Customers WHERE CustomerID = @CustomerID The procedure has been tested with right result. * The corsponding C# code is as below: string cn = ....; SqlConnection connection = new SqlConnection(cn); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "GetCompanyName"; command.Parameters.Add("@CustomerID", "ALFKI");//needed SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; adapter.TableMappings.Add("Table", "Customers"); DataSet ds = new DataSet(); adapter.Fill(ds); * The purpose is to demonstrate to use line 5. * When I ran it, I got an exception. The message is "Line 1: Incorrect syntax near GetCompanyName". Please advice. Peter Tag: CHEWSTAN@nyc.rr.com Tag: 75066
  - 5
    - Query Performance Problems with OracleClient OracleParameters Hello, I am querying an Oracle database using the Microsoft Oracle Data Provider for .NET and I am seeing significant performance penalties when I us parameter based queries rather than pure text dynamic SQL. Below is an actual query that demonstrates the problem - the first query, which embeds the target value directly in the query executes in abou1 1/10 sec. When I run the exact same query using a parameter I get hung up for 25 seconds. Has anyone seen a problem like this or have any idea what could be causing this delay? Is it endemic to using the Microsoft provider as I have seen hinted at in other messages? Being that we are close to deployment, I would really prefer not to switch providers and have security concerns about abandoning parameters. //--------------------------------------- // Doing the query with Dynamic SQL is very quick //--------------------------------------- string connectionString = "Data Source=ValidateConnectionStringOmitted"; using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandText = @"SELECT DISTINCT I.COL1, I.COL2, E.COL3, E.COL1 FROM TABLE1 I, TABLE2 E WHERE I.COL1 = E.COL1 AND I.COL2 LIKE 'AVALUE%'"; cmd.CommandType = System.Data.CommandType.Text; OracleDataAdapter a = new OracleDataAdapter(cmd); DataSet d = new DataSet(); // Timing on this call shows execution time of around 100 ms a.Fill(d); } //--------------------------------------- // Using a parameter has a performance hit of 2 orders of magnitude! //--------------------------------------- string connectionString = "Data Source=ValidateConnectionStringOmitted"; using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = cn; cmd.CommandText = @"SELECT DISTINCT I.COL1, I.COL2, E.COL3, E.COL1 FROM TABLE1 I, TABLE2 E WHERE I.COL1 = E.COL1 AND I.COL2 LIKE :LastName"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.Add(new OracleParameter("LastName", OracleType.VarChar, 7, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, "AVALUE%")); OracleDataAdapter a = new OracleDataAdapter(cmd); DataSet d = new DataSet(); // Timing on this call shows an execution time of over 25 seconds a.Fill(d); } Thanks in advance for any advice. Biff Gaut Gaithersburg, MD Tag: CHEWSTAN@nyc.rr.com Tag: 75054
  - 6
    - Connection String Storage? Hi, what will be the place to store connection string properties (server name and db)? .Net know offers other good alternatives to the registry. MTIA, Grawsha Tag: CHEWSTAN@nyc.rr.com Tag: 75053
  - 7
    - is there any standard way to.. Data Types Hi: Is there any standard way to ask for the data types on a data base: Something like: SELECT * FROM INFORMATION_SCHEMA.DATA_TYPES to get something like: char, int, image, varchar, money.... So later I can do something like: CREATE TABLE NewTable (NewField _Field_Type_selected_by_user_from_a_combo_box_) Thanks Tag: CHEWSTAN@nyc.rr.com Tag: 75050
  - 8
    - understanding IsolationLevel Hello, Would someone out there point me to a place where I can get a good understanding of when to use which IsolationLevel in SqlConnection.BeginTransaction()? I read it from a couple of places but none gave me some sort of guidelines when to use which. At this point, I do my datalayer reading with RepeatableRead and saving with Serializable. So far, occasionally I see some deadlock exception from sql server, not sure if it's the cause; another concern is the performance cost of Serializable when I don't have to. Thanks! Tag: CHEWSTAN@nyc.rr.com Tag: 75046
  - 9
    - ReadOnly Hello, I have a some TextBox bind to Access database via DataAdapter and DataSet. I'd like not allow edition, edition will be available via an "Edit" button. Is there an another way than change the ReadOnly property of these TextBox to false (because the background color change) to not allow edition ? Thanks, Tag: CHEWSTAN@nyc.rr.com Tag: 75045
  - 10
    - how to get return valued from stored procedure? I have problem to get return valude from my stored procedures. For example, if I insert a polygon and want to get the return primaty key genrated by @@IDENTITY, I have my stored procedure here: REATE PROCEDURE dbo.sp_Add_Polygon_i @Name as varchar(30) , @Area as float, @Primary_Key as int Out, @errCode int Out AS declare @HostProcId as nchar(8) INSERT INTO My_Polygon (Polygon_Name, Area) VALUES (@Name, @Area) Set @errCode = @@error if (@errCode = 0) Set @Primary_Key = @@IDENTITY else Set @Primary_Key = 0 GO it works fine if I call the sp from my SQL Query Analyzer. When I call it my my C# code, I did: oleCommand.CommandText = "sp_Add_Polygon_i"; oleCommand.CommandType = System.Data.CommandType.StoredProcedure; oleCommand.Parameters.Add("@Name", strName); oleCommand.Parameters.Add("@Area", (float)0); oleCommand.Parameters.Add("@Primary_Key", (int)1); oleCommand.Parameters.Add("@errCode", (int)1); oleCommand.ExecuteNonQuery(); this inserts a record to my table. How do I get the returned "@Primary_Key"? oleCommand.Parameters["@Primary_Key"].Value is always 1. should I pass a reference when I add this Parameter ("@Primary_Key")? how? Thanks a lot. Linda Chen Tag: CHEWSTAN@nyc.rr.com Tag: 75029
  - 11
    - How do I insert a NULL value inside an INSERT statement How do I insert a NULL value inside an INSERT statement in an SQL Server database? Thank you, Dino -- ------------------------------------------------------------------------- FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com Tag: CHEWSTAN@nyc.rr.com Tag: 75028
  - 12
    - SQL connection string containing server name no longer connects since framework 1.1 installed. Since upgrading to .Net Framework 1.1 I can no longer connect to my local sql server using a sql connection string that contains the actual server name (Error: SQL Server does not exist or Access Denied). If I use (local) or localhost as the server name then the connection is made. Does anyone know what caused this to stop working with the installation of framework 1.1 and how I could resolve it? Thanks in advance, Terry Tag: CHEWSTAN@nyc.rr.com Tag: 75025
  - 13
    - Passing Parameters to Access Query Help!!!!!!! Does anyone know where I can find documentation on how to pass parameters to an access query from a Web page using VB.net code? Any Examples, etc would help! Thanks in Advance Lea Tag: CHEWSTAN@nyc.rr.com Tag: 75016
  - 14
    - Passing Parameter to Access Query Help!!!!!!! Does anyone know where I can find documentation on how to pass parameters to an access query from a Web page using VB.net code? Any Examples, etc would help! Thanks in Advance Lea Tag: CHEWSTAN@nyc.rr.com Tag: 75015
  - 15
    - SqlException while Connecting to mySQL Dear Group, I have a C# client connecting to a remote mySql database and I'm getting the following exception: Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exi st or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransactio n) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn ectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at MainClass.Connect() in e:\NET\db\dbaccess\Main.cs:line 35 at MainClass.Main(String[] args) in e:\NET\db\dbaccess\Main.cs:line 65 This is what my my connect method looks like: SqlConnection sqlCon = null; string conStr1 = "Data Source=" + ipAddress + " ; Database=hightechzen" + " ; User ID=userid" + " ; Password=password"; sqlCon = new SqlConnection(conStr1); sqlCon.Open(); This is my namespace definition: using System.Data; using System.Data.SqlClient; Using a mySql client UI (navicat), I can connect to mySql. So my machine is setup for access. What do I need to do in my c# client to connect. Thanks in advance, Cindy Tag: CHEWSTAN@nyc.rr.com Tag: 75013
  - 16
    - Not able to edit Oracle data using Server Explorer I'm sure this has been discussed here many times before, but I just can't seem to find a thread with information regarding this. In a connection to an Oracle database using the MS OleDB Provider for Oracle, I used to be able to see Database Diagrams, Tables, Synonyms, Views, Stored Procedures, Functions, Package Specifications, and Package Bodies (like mentioned in the MSDN Library) in the Server Explorer, but ever since I upgraded to VS.NET 2003, all I see in the tree is Tables, Views, and Stored Procedures. I am not even able to update data anymore. Am I using the wrong provider? I do not see the native Oracle provider in the list of providers to choose from, even after installing it separately. This is really annoying and makes the Server Explorer (which I have come to love) virtually useless for me. Thanks for any suggestions, Sacha Korell Tag: CHEWSTAN@nyc.rr.com Tag: 75011
  - 17
    - Viewing data from many tables Hello! I have a following problem. I have a dataset with many tables, with master-detail relations. I want to display in a DataGrid a view, that is composed from many columns from many tables (ie. Col1, Col2 from Table1 and Col2, Col3 from Table3 ). I don't want to use a navigation feature, but rather to display a normal table. I can't use a DataView, because it operates on a single table. I found a DataSetHelper class in MSDN, but this code generates new table and COPIES ALL DATA to the new one. I find it at least not optimal to hold duplicate data in memory ( all data is in the dataset ). Do anyone have any idea, how to display a multi-table view WITHOUT data duplication. Best X-Mass and New Year wishes to all of you, Jakub Konecki Tag: CHEWSTAN@nyc.rr.com Tag: 75007
  - 18
    - DataReader and Returned Parms I have found that I am unable to read the parms until after I do a close on the DataReader. Is that accurate? In the instance where you are executing a procedure which returns multiple answer sets, would this still be true? So if I wanted to get the return value for each of the answer sets, I would in the Procedure create a variable which would hold the RETURN_Value into something like RETURN_VALUE1, RETURN_VALUE2....etc? Then after all the answer sets have been returned I could then read the parameter return values? Thanks in Advance for your assistance.... Tag: CHEWSTAN@nyc.rr.com Tag: 75003
  - 19
    - best practicies to validate a DB data Please, i need to develop an webservice wich deploy a method that must do lots of validation on a database. What can i do? 1. Create an Stored Procedure and inside of it validate everything and return a error code to method and to user or 2. Create lots of Stored Procedures wich one validate a specific data and return a error code or else to user or 3. Create lots of SQL statement and validate through a SQLCommand what i need. I fear the performance, best code, and state-of-the-art programm practicies. tks in adv. Fabiano Tag: CHEWSTAN@nyc.rr.com Tag: 74997
  - 20
    - populate dataset using collection Can any one point to a code in which a dataset is populated with a collection. Tag: CHEWSTAN@nyc.rr.com Tag: 74991
  - 21
    - SQL formatting variables This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3C629.AD311660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a set of variables (varies in type) which I will need to take and make "SQL-safe", that is, if the variable is a string i need it to be converted to 'string' and if it's a bool then it should be coverted to 0 or 1 etc etc.. The reason for this is that I need to build a query dynamicly and need the conditions (after the where clause) to be right formatted. I thought I might be able to use the types in System.Data.SqlTypes but it seems they are unable to return "SQL-safe" formatted values (what a shame actually). I would reeaaaaaaaally like not to have a huge switch (c#) statement which checks for the type and makes the correct formatting. So does anyone know of any solution I could use? I've looked and looked in the System.Data namespaces without any luck.. I've even tried to use the SqlParameter class since when using with for instance a SqlCommand, they help give the right format, without any luck =3D/ --=20 ANDREAS H=C5KANSSON STUDENT OF SOFTWARE ENGINEERING andreas (at) selfinflicted.org ------=_NextPart_000_0008_01C3C629.AD311660 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.59" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have a set of variables (varies in = type) which I=20 will need to take</FONT></DIV> <DIV><FONT face=3DArial size=3D2>and make "SQL-safe", that is, if the = variable is a=20 string i need it</FONT></DIV> <DIV><FONT face=3DArial size=3D2>to be converted to 'string' and if it's = a bool then=20 it should be</FONT></DIV> <DIV><FONT face=3DArial size=3D2>coverted to 0 or 1 etc = etc..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The reason for this is that I need to = build a query=20 dynamicly and</FONT></DIV> <DIV><FONT face=3DArial size=3D2>need the conditions (after the where = clause) to be=20 right formatted.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I thought I might be able to use the = types in=20 System.Data.SqlTypes</FONT></DIV> <DIV><FONT face=3DArial size=3D2>but it seems they are unable to return = "SQL-safe"=20 formatted values</FONT></DIV> <DIV><FONT face=3DArial size=3D2>(what a shame actually).</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I would reeaaaaaaaally like not to have = a huge=20 switch (c#) statement</FONT></DIV> <DIV><FONT face=3DArial size=3D2>which checks for the type and makes the = correct=20 formatting. So does</FONT></DIV> <DIV><FONT face=3DArial size=3D2>anyone know of any solution I could = use? I've=20 looked and looked in</FONT></DIV> <DIV><FONT face=3DArial size=3D2>the System.Data namespaces without any = luck.. I've=20 even tried to</FONT></DIV> <DIV><FONT face=3DArial size=3D2>use the SqlParameter class since when = using with=20 for instance a</FONT></DIV> <DIV><FONT face=3DArial size=3D2>SqlCommand, they help give the right = format,=20 without any luck =3D/</FONT></DIV> <DIV><FONT face=3DArial size=3D2><BR>-- <BR>ANDREAS = H=C5KANSSON<BR>STUDENT OF SOFTWARE=20 ENGINEERING<BR>andreas (at) selfinflicted.org</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3C629.AD311660-- Tag: CHEWSTAN@nyc.rr.com Tag: 74989
  - 22
    - Accessing Remote MSAccess Database with ADO.Net Hi, How can I connect to an access database located over a remote server through internet? Is it possible if updating a remote database is done in background and application doesn't affect by delay in accessing remote Server? Best Regards, Wasim Tag: CHEWSTAN@nyc.rr.com Tag: 74988
  - 23
    - ComboBox Values! I would like my ComboBox to display the 'CustomerName' value but it should store the 'CustomerID' value whenever it is assigned to the DataTable.LoadDataRow. Also, I need to trap the 'CustomerID'value in the ComboBox_SelectedIndexChanged Event whenever that event is fired. Thanks! Tag: CHEWSTAN@nyc.rr.com Tag: 74984
  - 24
    - Controls Binding Inquiry? Hi, If controls (textboxs,combos,etc...) are dataset-bound and dataset is used interchangeably (rowfilter on and off), do I have to clear bindings when user get different no. of records, or binding context will adjust itself to this?? That is, do I have to call this sub each time row filter is changed (on and off) Sub clearbinding() Dim ctl As Control Dim txt As Control ds.Tables("employees").clear For Each ctl In frmemp.Controls If TypeOf ctl Is GroupBox Then For Each txt In ctl.Controls If TypeOf txt Is TextBox Then txt.Text = "" txt.DataBindings.Clear() End If Next End If Next ds_changexposition() End Sub MTIA, Grawsha Tag: CHEWSTAN@nyc.rr.com Tag: 74974
  - 25
    - intermittent Oracle numeric errors Hello, We had run into intermittent "ORA-01858: a non-numeric character was found where a numeric was expected" and "ORA- 06502 PL/SQL: numeric or value error string" error on few of our store prodcedures. We are using .Net Framework 1.1 with MS Oracle Provider and Oracle 9i (9.2.0.1.0). The same data and same store procedure always works on developer's desktop. Hand executing those store procedures with the same data works fine. So we know it's not the data problem or incorrect store procedure problem. But the exact same thing would work fine on an integration server, and then suddenly throws the oracle exception intermittently. And it might work a couple of hours latter or after the SP was recompiled. Dumping the OracleParameters in the OracleParameter array before calling the SP reveals nothing wrong with the input parameters. The Oracle exception does not indicate which parameter is the offender. Since it's itermittent and we have a large parameter list, one-by-one elimination would be difficult. We do not specify the OracleType for our OracleParameters because OracleProvider documentation says: 1. "The DbType, OracleType, and Size properties of a parameter can be inferred by setting Value. Therefore, you are not required to specify them." 2. "Setting the Precision or Scale properties has no effect." So my questions are: 1. How can we pinpoint the offending parameter? DB tracing? 2. Is the omission to sepcify OracleType a problem? 3. If this is a bug in the OracleClient, any fix? 4. Will Oracle ODP solve this problem? Thanks, GT Tag: CHEWSTAN@nyc.rr.com Tag: 74973
- Next
  - 1
    - Is this Valid? I have written the following method.. public IDataReader CreateDataReader(IDbCommand cmd) { if (ProviderType == 0) { OleCommand oCmd = (OleCommand) cmd; OleDbDataReader dr = oCmd.ExecuteReader; return (IDataReader) dr; } } Would it be valid to write it like this? public IDataReader CreateDataReader(IDbCommand cmd) { if (ProviderType == 0) { IDbDataReader dr = cmd.ExecuteReader; return dr; } } The IDbCommand being passed is ultimated either a OleDBCommand or a SqlCommand - so is it valid to use the IDbCommand prior to changing it to the appropriate class? If that is valid, Since the type of object which is returned by the cmd.ExecuteReader is either an OleDbDataReader or a SqlDataReader, must I first get that and then "reclass" it to the IDataReader. Thanks IN Advance for your assistance!!!!!!!!!! Tag: CHEWSTAN@nyc.rr.com Tag: 74968
  - 2
    - How do I do this...? Hi, I have a database that needs a whole bunch of records added. The data comes from an XML file. I have grabbed the nodes in question, looped through them and I now want to populate SQL. Obviously I can pass each nodes data to a stored proc which will add to the table but this means lots of network traffic and I am sure it is not as efficient as dumping the data into SQL in one go. So, my question is, how do I create a client side recordset, populate the data into it, and then update the server, using ADO.Net via VB.Net. This would be more efficient, right? This is probably pretty basic but if someone could show me a sample that dumps several records into a table (just make one up - I'll be able to follow) it would really help clarify a few things. Thanks to all in advance... Tag: CHEWSTAN@nyc.rr.com Tag: 74959
  - 3
    - Anyone tried async ADO.NET in Whidbey ? Hi, I've read in a number of articles on MSDN and elsewhere that the Whidbey version of .NET+framework will support true async calls for ADO.NET. Has anyone tried this in Whidbey? I'm looking for something like a DataAdapter.BeginFill()/EndFill() but can't seem to find anything in the documentation. Have any articles been written on this topic? I can't seem to find any. [I know this product is pre-beta, but hey, it never hurts to plan ahead for this stuff!] Sincerely, Xavier Mendez Lecture Snoddddgrass Tag: CHEWSTAN@nyc.rr.com Tag: 74952
  - 4
    - DataReader Troubles I think I must be going crazy?! I am using a DataReader (OleDb in this case) to select some records from a table. When I let the code execute it runs fine (via an ASP.Net page). When I step through it using the debugger - the DataReader acts very strange... My table has 5 records and while debugging it will iterate 2 out of the 5 records before the call to Read() returns false. This has been driving me nuts for a few hours now - hoping I am just really beat and doing something obvious. Any insights, etc would be greatly appreciated. Below is a simplified block of code that reproduces the issue on my machine. OleDbConnection oConn = new OleDbConnection( System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"] ) ; oConn.Open(); OleDbCommand oCmd = new OleDbCommand("SELECT * FROM tblClients Order By ClientID", oConn); OleDbDataReader oReader = oCmd.ExecuteReader(); string a = ""; //--this block executes correctly unless I decide to step through it //--the results read "1,2,3,45," when I just let it go //--when I step through it I get "2,5," while( oReader.Read() ) { a = oReader.GetValue(0).ToString(); Response.Write( a + "," ); } oReader.Close(); oConn.Close(); Thanks, G. Herrell Tag: CHEWSTAN@nyc.rr.com Tag: 74945
  - 5
    - DataSet Xml persistency does not support the value '0x20' as Char value In all my previous experience a space, ' ', was considered to be a character, but I'm having trouble filling a dataset if a 'char' column contains a space. Example cmd.CommandText = "create table spacetab(c1 char)"; cmd.ExecuteNonQuery(); cmd.CommandText = "insert into spacetab values (' ')"; cmd.ExecuteNonQuery(); [vendor]DataAdapter da = new [vendor]DataAdapter("select * from spacetab", conn); DataSet dataSet = new DataSet( "dataset" ); da.Fill( dataSet ); The error (with snippet of stack trace) that is returned is System.ArgumentException: The DataSet Xml persistency does not support the value '0x20' as Char value, please use Byte storage instead. at System.Data.Common.CharStorage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store < > in c1 Column. Expected type is Char. In other tests, this vendor's datareader is returning the column as a Char; GetValue() returns a char and GetChar() works as well. This seems to make sense since it is a char column and a .Net Framework definition of char is any 2-byte value between 0 and 65535. So, why would the Fill reject a Char with the value ' ' == 0x20? Any information much appreciated. -Chris Tag: CHEWSTAN@nyc.rr.com Tag: 74944
  - 6
    - dynamic grammar question I need to modify a grammar according to some per-user settings. The grammar is fairly complicated so I don't want to construct it entirely in code. So I constructed it in the grammar editor and placed a tag where I want to insert my <one-of> branch. At runtime, I then use StreamReader to load the grxml file, and do a replace on <item>replaceme</item> with my dynamically constructed <one-of> branch. this doesn't seem to be working. I keep getting a -1 error (generic error). Any idea on how to better handle this? Thanks Reggie Tag: CHEWSTAN@nyc.rr.com Tag: 74943
  - 7
    - Set active row thru code I have a dataset bound to a grid and some other controls. Databinding is responsible for all updates. I add a row using code and want that to be the active row displayed in the controls. How do I set the active row for databinding? Tag: CHEWSTAN@nyc.rr.com Tag: 74941
  - 8
    - SuspendBinding/ResumeBinding Hello, I have a form where the controls are linked to a Access database via Dataset Adapter and DataSet. I can navigate in the dataset. Now I'd like to use the same form to insert data. For that, my idea is : - SuspendBinding - Clear TextBox - User fill in the Textbox - Insert in DataRow and after in Database - ResumeBinding But I have a problem, when I do this (see below) I receive this error message (exception raised): System.Windows.Forms DataBinding could not find a row in the list that is suitable for all bindings. An idea ? Thanks, Christian, The code, in the event button (ADD) click : try { BindingManagerBase binMng=BindingContext [dsMyMovie, "MOVIE"]; binMng.SuspendBinding(); } catch(Exception ex) { MessageBox.Show(ex.Source); MessageBox.Show(ex.Message); } Tag: CHEWSTAN@nyc.rr.com Tag: 74933
  - 9
    - Problem with GUID's Hello all, I have an application that reads guids from sql server and stores them as the value in a drop down list. Once they are stored as strings I can't figure out how to get it back to a guid type for the sql server's sproc. I keep getting an invalid cast from string.....type string cannot be converted to guid. The problem is that I need the string converted back to guid so that I can qry the db using the guid. Any ideas would be greatly appreciated. Thanks in advance Pat Tag: CHEWSTAN@nyc.rr.com Tag: 74931
  - 10
    - Clearing SQL-Server connection pool We use an automated testing tool and I restore the database before each testcase that modifies the database. Therefore I need to kill all open connections to the SQL- Server database (using the T-SQL KILL statement). Unfortunately, the SQL connection pool isn't notified that the connection is cancelled. So when a new connection is opened (that is retrieved from the pool) a 'General Network Error' occurs. I have solved this to disable connection pooling while testing (setting "pooling='false'" in the connection string). I would rather flush the connection pool, but I cannot find a way to do this from a .NET environment. Does anyone know how to manage the connection pool from within a .NET application? Tag: CHEWSTAN@nyc.rr.com Tag: 74919
  - 11
    - Get a String for a month in a drop down I want to do a Stored Procedure or query from an SQL database that fills a drop down list. The text member will be the month, and the value member will be the number of the month. I can get the number out of SQL, but how about the month? Tag: CHEWSTAN@nyc.rr.com Tag: 74918
  - 12
    - DataTable Column DataType If I am going to be retrieving a "UniqueIdentifier", what should the "typeof()" value be in the constructor for the Datacolumn dtSkaters.Columns.Add("EventID",typeof(int)); Thanks in advance for your assistance... Tag: CHEWSTAN@nyc.rr.com Tag: 74917
  - 13
    - Creating DataTables through the IDE in an inherited DataSet In the IDE, if you create a DataSet, you can drag tables from the Server Explorer and it will automatically create a DataTable for you inside the DataSet. Is there a way for it to automatically create a DataTable for you from a "SELECT" statement that you give it. For example, I have a SELECT statement that has a bunch of JOINs in it. I would like to have a DataTable that perfectly matches the columns that are returned from the query. Thanks in advance. Tag: CHEWSTAN@nyc.rr.com Tag: 74916
  - 14
    - Binding a ComboBox in a Windows Form to a Hierarchical DataSet I have two tables in a parent-child relationship. Details on the tables are as shown below: Table1 ------- Item_ID (primary key) Item_Owner (foreign key to Table2) Table2 ------- Owner_ID (primary key) Owner_Name I wish to display, on a form designed for maintenance of the data in Table1, a combobox which displays owner names (Table2.Owner_Name), but returns as its bound ValueMember the item owner's ID (Table1.Item_Owner). Can I do it? Thanks! -- Greg Dunn Tag: CHEWSTAN@nyc.rr.com Tag: 74913
  - 15
    - Efficient find in dataset Can I set up a primary key on a dataset after it has been populated - like after the query has been run? I'm trying to do a look up on a dataset, but I believe that using the find method is more efficient than looping thru the dataset. Is this correct? Generally speaking? -- Regards, Alvin Bruney Got DotNet? Get it here http://home.networkip.net/dotnet/tidbits/default.htm Tag: CHEWSTAN@nyc.rr.com Tag: 74912
  - 16
    - Using SetDataBinding question Hi If a Table row is being changed in the code after the call has been made for grid.SetDataBinding, do I need to call this grid SetDataBinding method again after I call the Table.AcceptChanges (), or will it automaticaly update the grid info? The DataRow is being changed in the code and the grid is read only. Thanks, Ronen Tag: CHEWSTAN@nyc.rr.com Tag: 74910
  - 17
    - Win98 memory bottleneck for using XML in MSDE2000 Used to read newsgroup for answers, now have to ask for them as well. I have an application (C#, .NET 1.1) that connects to local db on MSDE 2000 SP3a (using ADO from MDAC 2.71) on one side and to a web service on the other (not relevant I guess). Some stored procedures consume xml produced by DataSet objects (values as elements) using OPENXML statements. The application should be distributed among users having also Win98. Established that I require min 128 MB of physical memory to run it. However on Win98 I need to set 'min server memory' value to 128 otherwise even small OPENXML statement, which is first in the application lifecycle (so I could not have missing sp_xml_removedocs statments before) ends up with an error 'server memory low, use sp_xml_removedocument ...'. It turns out that users having even 256MB get that error as well, when larger XML is consumed by MSDE. That I could understand, but I managed to configure application to run on Win98 with 128MB!!! Only after some time users started to receive that errors, and even restarts and running the application without any other applications running at the same time, didn't help. What could have changed in memory management assuming no other apps were installed? Tried setting up 'min memory per query' to even 32MB; tried to set up 'min/max server memory' to 128 (and more); tried to set up 'min/max server memory' and 'set working set size' to 1 (it should reserve memory for SQLserver process). I used 'reconfigure' statments and performed restarts after having set above values as well. Is there any other way I could force Win98 to give memory to MSDE or to parsuade xml parser to be more memory efficient? What I also know: - MSDE instllation does not have msxml2.dll, so I included it in my installation package (downloaded msxml2.msi from Microsoft with dll file ver 8.30.9523.0, looks pretty new to me) - XML parser in MSDE 2000 (any SQL 2000) uses 1/8 of memory available for SQLserver, and that value cannot be changed (or can it?) - MSDE 2000 cannot use XML other than MSXML2, and nothing can change it, so I guess no help comes from MSXML upgrade - XML parser uses A LOT of memory, and can consume several times more memory that XML size - memory management in Win98 sucks, but I cannot leave Win98 out of my application distribution list If you got that far in my post, thanx for that. Rgds, Andrzej Tag: CHEWSTAN@nyc.rr.com Tag: 74907
  - 18
    - Sorting DataTable without DataView I'm using DataTable in console application and I have to sort the rows. Is it possible to sort DataTable without using DataView.Sort property? I'm accessing DataRow by DataTable->Rows->Item[int] Is it possible to avoid additional layer that DataView enforces? I don't have any logical or GUI controls that I bind data to. Thanks in advance for any solution. Tag: CHEWSTAN@nyc.rr.com Tag: 74903
  - 19
    - Dumb question about strongly typed datasets Okay, I am sure this is right in front of my nose, but I cannot figure out how to do this... I have a strongly typed dataset (STDS) generated by xsd in CSharp. I have the code in place to populate the various tables (7 of them) with datarows. How do I now update this back to the database? Do I need 7 SqlDataAdapters, each one with the appropriate Command members? If so, where can I get the 7 SELECT statements? They are not stored in the STDS anywhere. If I have to remember the queries used to generate the STDS, then where is the benefit? I should be able to tell the STDS to 'save yourself' back to the table(s) you were designed from'. Tag: CHEWSTAN@nyc.rr.com Tag: 74902
  - 20
    - Moving in DataSet...Manually (code)?? Greetings, After an ugly expiernce with form data-binding, I will be very thankfull if someone please can show me how to move in dataset manually, through code?? MTIA, Grawsha Tag: CHEWSTAN@nyc.rr.com Tag: 74901
  - 21
    - Generate Tables and Sproc with vb.net Hi, I need to generate my sql tables and stored procedures. I have made a .sql file where I have all my tables and stored procedures with Sql Server Enterprise Manager So the question is how to generate all of them from a vb.net ? The best would be to read the file from the disk and create the different tables and sproc. Thanks for your help Stan Tag: CHEWSTAN@nyc.rr.com Tag: 74900
  - 22
    - Database Access Base Class I thinking that I want to write a class which handles all database access hiding from the calling program what type of database which is being accessed and all of the database specific things. I would include methods to bind the dataset/datareader to the control, returning a datatable and the dataset if necessary. All updates would be done through methods, etc. One of the problems that I can see which is somewhat of a challenge to deal with are stored procedure parameters. There is some commonality of the datatypes across the various databases (OleDB, SQL, Oracle), but there is not uniformity. I was thinking that I would use the generic DbType and have the calling program pass this data type and then translate it to the appropriate type of the database which is actually being accessed, but this would not handle all situations. Any idea how I can overcome this? Is there a better design approach? Tag: CHEWSTAN@nyc.rr.com Tag: 74899
  - 23
    - XML and SqlServer Hello, I trying to use the For XML for the first time and am trying to figure out the "Explicit" option. Going over the example in the documentation, they show a sample which looks like the following: SELECT 1 as Tag, NULL as Parent, Customers.CustomerID as [Customer!1!CustomerID], NULL as [Order!2!OrderID] FROM Customers I am hoping someone can confirm my interpertation here. The first line, the "1" is used merely for sorting purposes to sort the "structure" in front of the data. The second line is specifying that for the first field retrieved, it has no parent. The 3rd line is telling that it should map the "CustomerID" field as an attribute of the Customer Element. The forth line is saying to map an attribute of OrderID to a Element of Order. Is that about right? Questions.. Why does the 4th line specify "Null" while the 3rd specifies "Customers.CustomerID". I guess I really do not understand how to properly use this column. In the output, below - where did "cid=C1" come from? I am guessing this is CustomerID field? How did it get associated with "cid". Does the "pid='P1'" is this related to the Tag Number? Why is it needed? This is the output they are creating in this example... <Customer cid="C1" name="Janine"> <Order id="O1" date="1/20/1996"> <OrderDetail id="OD1" pid="P1"/> <OrderDetail id="OD2" pid="P2"/> </Order> <Order id="O2" date="3/29/1997"> ... </Customer> Thanks in advance for your assistance!!!!!!! Tag: CHEWSTAN@nyc.rr.com Tag: 74894
  - 24
    - Switching from ADO to ADO.NET example needed I've been developing in VB6 & DAO for quite some time. I have figured out how to use ADO (see the following code sample) but want to drop ADO and move to ADO.NET. Can someone please point me to an article or book or re-do the code below so I can move on. I have the MSDN article "ADO.NET and You" which got me started, I have a good connection string but just can't figure out how to get a single record, grab it's value, and update it if necessary. Thanks! Rick Lederman, rick@soaringsoftware.com, www.soaringsoftware.com Dim cnFAMax As New ADODB.Connection cnFAMax.Provider = "Microsoft.Jet.OLEDB.4.0;" cnFAMax.CursorLocation = ADODB.CursorLocationEnum.adUseServer cnFAMax.Open("Data Source=" & sCDatabaseName & "; Jet OLEDB:Database Password=" & sMasterDatabasePassword & ";") sSql.Remove(0, sSql.Length) sSql.Append("SELECT PARAMETERS_.* FROM PARAMETERS_;") Try rsSearch.Open(sSql.ToString, cnFAMax, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) Catch ex As Exception MsgBox("The Recordset failed to open") End Try 'MyOptions.PercentRemainingRed() rsSearch.Find(("NAME_ = 'MyOptions.PercentRemainingRed'")) If rsSearch.EOF = True Then MyOptions.PercentRemainingRed = 30 rsSearch.AddNew() rsSearch.Fields("NAME_").Value = "MyOptions.PercentRemainingRed" rsSearch.Fields("VALUE_DOUBLE").Value = 30 rsSearch.Update() Else MyOptions.PercentRemainingRed = rsSearch.Fields("VALUE_DOUBLE").Value End If rsSearch.MoveFirst() ' Then I do another .Find to find the next appropriate record & test it's value the same. Thanks again! Tag: CHEWSTAN@nyc.rr.com Tag: 74893
  - 25
    - [ANN] PgSqlClient 1.0 Beta 5 released. Hello: Beta 5 version of PgSqlClient an ADO.NET Data Provider for PostgreSQL 7.4+ released. Beta 5 ( 18-12-2003 ) ---- - - -- -- ---- - * Bug fixes. * Minor improvements in PostgreSQL 3.0 protocol implementation. PgSqlClient 1.0 Beta 5 source code is available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-Src.zip?download PgSqlClient 1.0 Beta 5 binaries for .NET 1.0 available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-NET1.0.exe?download PgSqlClient 1.0 Beta 5 binaries for .NET 1.1 available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-NET1.1.exe?download -- Best regards Carlos Guzmán álvarez Vigo-Spain Tag: CHEWSTAN@nyc.rr.com Tag: 74890

CHEWSTAN@nyc.rr.com

Re: CHEWSTAN@nyc.rr.com by Cowboy

Cowboy
Sat Dec 20 18:34:24 CST 2003

That would be "How to get your email address stolen from Usenet by
SPAMMERs", Alex.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
<CHEWSTAN@nyc.rr.com> wrote in message
news:004501c3c732$0b0bc9c0$a501280a@phx.gbl...
> CHEWSTAN@nyc.rr.com

Top

Re: CHEWSTAN@nyc.rr.com by Miha

Miha
Mon Dec 22 02:29:02 CST 2003

Who's Alex?

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:eEINwo1xDHA.2500@TK2MSFTNGP09.phx.gbl...
> That would be "How to get your email address stolen from Usenet by
> SPAMMERs", Alex.

Top

Re: CHEWSTAN@nyc.rr.com by Cowboy

Cowboy
Tue Dec 23 12:08:52 CST 2003

Alex Tribeck, host of Jeopardy!

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
"Miha Markic" <miha at rthand com> wrote in message
news:ucKgmWGyDHA.2620@TK2MSFTNGP09.phx.gbl...
> Who's Alex?
>
> "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
> message news:eEINwo1xDHA.2500@TK2MSFTNGP09.phx.gbl...
> > That would be "How to get your email address stolen from Usenet by
> > SPAMMERs", Alex.
>
>

Top

Re: CHEWSTAN@nyc.rr.com by Miha

Miha
Wed Dec 24 03:14:08 CST 2003

:)

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:%23SoSR$XyDHA.3416@tk2msftngp13.phx.gbl...
> Alex Tribeck, host of Jeopardy!

Top