SortOrder's column in GetOLEDBSchemaTable

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
    - nothing or dispose hi iam closing the connection and later iam using dispose method should i need to use nothin is it neccessary to use nothing for an object?????? pls give me suggestion Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87309
  - 2
    - creating a setup to install into GAC, where can I find an example? Could anyone suggest me some examples/articles on creating a setup program in VS.NET that can install the assembly into the GAC? I have done some search and research myself and have some basic understanding on how to create a setup program. All the articles about Windows Installer 2.0 is the best way to install your assembly into GAC but I haven't found one shows what exactly I need to do differently in my VS.NET setup project in order for it to stick the assembly into GAC. Bob Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87303
  - 3
    - Strongly typed DataSet with xsd.exe I generate an XML file with the WriteXmlShema method of the DataSet object. Then, I use xsd.exe to make it a strongly typed DataSet, witch generate a Visual basic code file, MyDataSet.vb. xsd.exe /d /l:VB "MyDataSet.xsd" When I add both files, MyDataSet.xsd and MyDataSet.vb, to my Visual Studio project, MyDataSet.vb does not appears as a child node of MyDataSet.xsd like when you create a strongly typed Dataset by dropping a table on the DataSet designer. Is there a way to tell VSNet that MyDataSet.vb is to be linked with MyDataSet.xsd? Thanks a lot Frederic Goulet Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87301
  - 4
    - Exporting XML Schema This is a multi-part message in MIME format. ------=_NextPart_000_00A3_01C4382A.B02408F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know there is a way to do this as I have done it before with Crystal = Reports tech support on the phone. I (mistakenly) have misplaced that = code. What I need to do is convert a dataset into an XML schema file = that I can use to generate another Crystal Report.=20 Thanks in advance for any help that you can give me. ------=_NextPart_000_00A3_01C4382A.B02408F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I know there is a way to do this as I = have done it=20 before with Crystal Reports tech support on the phone. I (mistakenly) = have=20 misplaced that code. What I need to do is convert a dataset into an XML = schema=20 file that I can use to generate another Crystal Report. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance for any help that you = can give=20 me.</FONT></DIV></BODY></HTML> ------=_NextPart_000_00A3_01C4382A.B02408F0-- Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87299
  - 5
    - What's the benefit of using VS.Net's "Generating Dataset..."? This may be a newbie question. I used to just define (VB.Net for example): dim dt as new DataTable dataAdp.fill(dt) But in VS.Net, You can also right click the SQLDataAdapter1 component and click "Generating Dataset...", after specify a name, the new xsd file will be created as well as a correspond vb file. The VB file basically created another class inherit DataSet class. But in the vb code, it seems still need to do: dataApt.fill(AutoGeneratedDataset, "SameNameOfTheTableWhenGenerating") What's the benefit to use this function of VS.Net? I know one is you can use the visual tool to do data binding after you have generated dataset placed on the form designer.... Others? Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87297
  - 6
    - Populating disconnected ADODB.Recordset with System.Data.DataTable data. I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a disconnected ADODB.Recordset from System.Data.DataTable data. Below is the source code I am implementing to test the process. I do not get any error, that I can see. The problem I have is that at the end, the recordset seems to be empty. Any suggestions are very much appreciated. At this moment I do not know what to do. Thank you so much for the time and effort you may spend on this matter. Elcc. private bool testConvertDT_RS() { System.Data.DataTable dt; ADODB.Recordset rs; // create dummy data table. dt = PopulateDataTable( ); // attempt to populate disconnected ADODB.Recordset with System.Data.DataTable data rs = ConvertToRS ( dt ); if( null == rs ) { throw new Exception(" Recordset is null."); } if( 0 == rs.Fields.Count ) { throw new Exception(" Recordset Field count is zero."); } return true; } private System.Data.DataTable PopulateDataTable() { System.Data.DataTable dt = new System.Data.DataTable(); System.Data.DataRow dr; string[,] ColValues = {{"R1-C1", "R2-C1", "R3-C1", "R4-C1", "R5-C1"} , {"R1-C2", "R2-C2", "R3-C2", "R4-C2", "R5-C2"} , {"R1-C3", "R2-C3", "R3-C3", "R4-C3", "R5-C3"}}; dt.Columns.Add(new System.Data.DataColumn("Column01", System.Type.GetType("System.String"))); dt.Columns.Add(new System.Data.DataColumn("Column02", System.Type.GetType("System.String"))); dt.Columns.Add(new System.Data.DataColumn("Column03", System.Type.GetType("System.String"))); for( int i = 0 ; i < 5 ; i++ ) { dr = dt.NewRow(); for( int n = 0 ; n < 3 ; n++ ) { dr[n] = ColValues[ n, i]; } dt.Rows.Add(dr); } return dt; } private ADODB.Recordset ConvertToRS(System.Data.DataTable dt) { ADODB.Recordset rs = new ADODB.Recordset(); try { rs.CursorLocation = ADODB.CursorLocationEnum.adUseClient; rs.ActiveConnection = null; for( int i = 0; i < dt.Columns.Count; i++) { rs.Fields.Append( dt.Columns[i].ColumnName, ADODB.DataTypeEnum.adBSTR, dt.Columns[i].MaxLength, ADODB.FieldAttributeEnum.adFldUnspecified, null ); } rs.Open( Type.Missing, Type.Missing, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach(System.Data.DataRow dr in dt.Rows) { rs.AddNew(Type.Missing, Type.Missing); for( int n = 0; n < dt.Columns.Count; n++) { rs.Fields[n].Value = dr[n]; } rs.Update(Type.Missing, Type.Missing); } rs.Close(); return rs; } catch(Exception e) { throw e; } } Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87295
  - 7
    - concurrency questions I am using an access db via ole db from an asp.net page. When I open a connection, if there are no more connections in IIS's connection pool it'll try and open a new connection. If there are no more connections available what exception get's thrown? By the same token, when using a data adapter to do an update, what exception gets thrown if the server (the access mdb) is busy? Lastly, where can I read up on this. I already know about switching the MSDE etc. Sounds great, but not an option for the near term. Thanks ... Ed Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87292
  - 8
    - Storing Date/Time with Daylight savings Dear All, I am developing an application that will save historical data; The table is very simple, it will have a Time Stamp column and other columns to save real values. The application should be able to work with several different databases. My problem now is to make a decision about the date/time to be saved in the Time Stamp; I can use either System Time (GMT) or Local Time; if I choose the first one, the users will get confused when they try to open the tables using a GUI other than mine. On the other hand, if I save using Local Time, I can have problems with Daylight saving. Does anyone have any idea about how to avoid problems with daylight saving other than saving the System Time? Note: I thought about using an additional field (maybe save both, System Time and Local Time), but I think that you experts should have a better solution. Thank you in advance, Lourenço. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87290
  - 9
    - How to handle NULL fields-error with fill method I have a data adapter that is using a stored procedure and when I get to the fill method to fill a dataset I get the following error Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. The results of the procedure has 6 columns by 50 rows with some NULL field values throughout so think the NULLs are causing the problem. Just wondering how to handle this? Thanks Paul. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87289
  - 10
    - OracleType.NVarChar parameters handled differently in framework 1.1? There appears to have been a change in behaviour between handling of OracleType.NVarChar parameters in 1.1? In my case this breaks code using DbType.String or the IDataParameter interface with strings over 2000 characters. A 2001 character string parameter, consisting entirely of 7 bit characters, sent to a 9.2.0.1 stored procedure works under the optional 1.0 Oracle driver. The exact same code and database now falls over with "ORA-01460:unimplemented or unreasonable conversion requested" using the supplied 1.1 OracleClient.dll. This change in behavior leads me to the conclusion that the biggest string you can now pass to an Oracle database using the IDataParameter interface is now only 2000 characters, primarily because OracleClient 1.1 maps the String native type to OracleType.NVarChar with a 4000 byte limit? This 2000 char limit would be required to handle the possibility that the database *may* be configured with a 16bit NLS_NCHAR_CHARACTERSET like AL16UTF16 as is sometimes recommended by Oracle? Even though you are could actually be inserting a plain old ascii string into a plain old varchar2(4000) column on a plain old USASCII7 Oracle instance? Assuming this is the case, can anyone think of a workaround, other than 1. Having to abandon the database independent IDataParameter interface and change all the client code to discover and use whichever native <database>Type is appropriate for the connection? 2. Stick to strings of less than 2000 characters. Rich. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87288
  - 11
    - Copy data between two dataadapters Hi, we want to build an application which copies all data from the source to the destination without changing anything. We use data adapters for this process. So we open both adapters, use "fill" on the source and give an "update" to the destination. The problem is that the table we want to copy is quite large. So we see quite a memory usage. So we decided to move the data in blocks, 1000 records at a time. We use the dataadpter.fill(dataset,0,1000,tablename) to read the first records, then we do an update, then the next fill (dataadpater.fill(dataset,1001,2000,tablename) and loop that till EOF. We see that the programm moves the first records quite quickly but gets slower and slower over time. Our idea is that the dataadapter take more and more time to skip the first records of the source to get to the real "payload". Is there anything we can do better? We simply want to move the first 1000 records, then the next 1000, and so on... Thanks, Thomas Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87287
  - 12
    - Help... last deleted row not updated Hi group, in a checklistbox I have some item that can occur(when checked) in a datatable. when I uncheck 3 items and press the update button a problem occurs. In the Buttonevent I make a loop where I search for still excisting unchecked(s) searching the id with dataviewtable.find(). If found the datatable.rows[found].delete() is called. I see this happen tree times in debug mode.... so far, so good.... But when I call the adapter.update(ds[table]) only the first two rows are really updated and the last one still is in the sql-server. Do I have todo something extra before calling update or has any one a solution to my problem? Thanks in advance, Rens Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87286
  - 13
    - Dataset WriteXML method I have a dataset that was created from a XSD schema. I populate it with data and use WriteXml method to create XML document. Problem is XML tags come out in the order that is different from the order of tags in the XSD. My client requires that XML validates against XSD, and the use XMLSPY to validate it. I ran the same test and XMLSPY complains that tags in the wrong order. Is there a way I can force order of tags with WriteXml method of Dataset? If not what ate the other alternatives? Thank you all very much Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87285
  - 14
    - DataSet/Table/Row questions Hi.. I'm trying to port an old application to .Net and I've been exploring the possibility of using the DataSet, DataTable, and DataRow classes to make an unconnected, in-memory database for a light-weight app. I can already get myself pretty much most of the way there, but there are some questions I have The data I'm trying to work with is serialized as XML and the XML has roughly this structure <Root><Client id="1" total="Sum(Child(rel).cost)" updated="Max(Child (rel).updated"><Order id="1" cost="12" updated="<date>"/><Order id="1" cost="3" updated="<date>"/ .. </Client .. </Root I have the schema to create the DataSet and the tables; it ends up with 2 tables, a parent/child relationship, and some columns in the parent table as operations on the child table For the most part this works pretty well, but there are a few things that are sub-optimal and I was wondering if there might be any suggestions to help smooth things out 1) I'd rather have it as one table, if I could, and then use a Select statement with something like a GROUP BY to create the summaries, but I don't see any easy way to do this. Also, there doesn't appear to be any xml serialization support below the DataSet level 2) Also, while we want to keep a certain amount of data in the in-memory database, we want to be able to select only particular nodes for serialization in xml (i.e. give me the xml tree structure only for nodes where Client.total > 100, for example). But the DataSet xml serialization doesn't seem to support any selection; it only serializes the whole database. Is the only way to work with this to serialize the whole thing out and suck it back into a DOM and do the selection with xpath? Seems a deficiency that the xml serialization doesn't support selection and/or there isn't any serialization support on the table level 3) Multiple part question a) how expensive is it to do a DataSet.Clone, a Select and a Merge? (i.e. a way of getting a dataset with only the data I want to return) b) Since I currently have 2 tables, I would guess I have to do separate selects on the the parent and child tables, resulting in 2 DataRow []. Is doing DataSet.Merge() going to get the row arrays into the right tables c) given a defined relationship between parent and child tables is there any way to write a select that would get both row sets in one call And generally, if anyone can give general tips on how to make this work better, I would appreciate it Thank Mark Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87281
  - 15
    - Multithreading: "There is already an open DataReader associated with this Connection" Hi all I am running multiple threads retrieving information from a SQL database, using sqlDataAdapter and DataSet. I regularly (but not constantly) get an exception "There is already an open DataReader associated with this Connection" thrown. Now, I know that the sqlDataAdapter uses DataReader under the hood, and that DataReader does not accept more than one connection open at a time. How might I work around this issue? Having the threads wait for eachother by calling Join() is not an option. I need to run a large number of threads calling this function I'll add some code to (hopefully) clarify my issue. The function PollSubscriptions is called by multiple threads private void PollSubscriptions(string devicePIN) ArrayList subscriptions = new ArrayList() ArrayList events = new ArrayList() string subscriptionIDs = "" XmlDocument XmlDoc = new XmlDocument() try { sqlListenerThreadDS.Clear() sqlListenerThreadDA.SelectCommand.Parameters["@PIN"].Value = devicePIN.ToUpper() sqlListenerThreadDA.Fill(sqlListenerThreadDS) foreach (sqlListenerThreadDS.subscriptionsRow subscription in sqlListenerThreadDS.subscriptions) subscriptions.Add(subscription.subscriptionID.ToString()) sqlSubscriptionsDA.Fill(sqlUserInfoDS) foreach (string id in subscriptions) sqlUserInfoDS.subscriptionsRow subscription = sqlUserInfoDS.subscriptions.FindBysubscriptionID(Convert.ToInt32(id)) subscription.lastPoll = System.DateTime.Now.ToUniversalTime() sqlSubscriptionsDA.Update(sqlUserInfoDS) catch (Exception ex) logEntry = "Failed to poll subscriptions for device " + devicePIN.ToUpper() + ": " + ex.Message + "\n" + ex.StackTrace eventLog.WriteEntry(logEntry, EventLogEntryType.Error) } Would anyone know a solution? sqlDataAdapter and DataSet are thread-safe, aren't they much regard Eri erik.removethisifyourenobot@thesixthhouse.nl Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87277
  - 16
    - connection string I apologize for such an elementary question. My connection string requires a data source. Is that the server name? The DB name is the Initial catalogue, so that isn't the data source. Thanks for the help SMK Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87269
  - 17
    - Query is too complex Hi, I'm using the querybuilder when updating a (rather wide) record in a table (Access). However, I get a "Query is too complex" message. It seems that for "optimistic locking " purposes, the WHERE Clause is very complex Any suggestions how to get this working? Thanks in advance, Ben Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87265
  - 18
    - How do I use store procedures? How do I create and use "store procedures" with an SqlConnection object? I need to create a procedure that will add a record and return the new ID of said record. I know that I can accomplish this with "store procedures." If you can direct me to a simple sample, I would really appreciate it. - Rashad Rivera Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87264
  - 19
    - Connection time out Hi all i´m opening a table with a few thousands of records and it allways gets me a connection timeout. my connection string is ( using sqlclient.sqlconnection and a SqlDatadapter) "User ID=sa;Initial Catalog=BD;Data Source=Server;Password =xxxx;Connect Timeout=30000" can someone help .. JSB Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87263
  - 20
    - DataSet Updates fails when there are non-printable characters in a field Hi When I try to update my changes found in a dataset I often get Concurrency violation: the UpdateCommand affected 0 records. Because one of the fields (varchar) contains a single TAB chr(9) or a single CRLF pair of characters. How can I fail-safe my update code so that even these characters can get updated? I guess it is because of the tests that the command-builder object creates that doesn't like non-printable characters. Perhaps they should be escaped properly? but how can I do that? It is frustrating moving to ADO.NET from ADO finding that now updates fails because there's some odd content in the fields! Any ideas for simple solution? //Andy Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87262
  - 21
    - Named Pipes alias in web.config I'm trying to use a named pipes alias in a connection string in a web.config file. At the moment, my string looks like this: "Application Name=test1;Data Source=richtest;Network=DBNMPNTW;Initial Catalog=richdb1;Integrated Security=SSPI" /> I'm guessing that the problem is the "richtest" alias seems to just be read as a DNS name - ie. I think it assumes it's a machine called richtest and it tries to resolve that name to an IP address. The richtest alias is set up in the SQL Client Network Utility as a named pipes connection and works fine for other applications. The connection string works if I use the actual pipe name (\\richserver1\pipe\MSSQL$SQ2\sql\query), but I want to avoid doing that if I can, just in case it changes. If I can use the alias, it means I only have to change the alias if the database location changes, and I don't have to worry about other things stopping working because of hard-coded pipe names. Any help with this would really be appreciated. Rich Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87261
  - 22
    - Request for details on XML-MSDATA Schema I request that Microsoft's .Net team publish the schema indicated by: 'urn:schemas-microsoft-com:xml-msdata', or at least publish a document describing all of the attributes (and elements?) defined in the said schema. I'm developing an ASP.net application using datasets, on a very time restriced schedule, and so the details of the said schema would be extremely helpful in manually crafting the XSD file used by my application. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87250
  - 23
    - commandBuilder Update SQL generation for > 1 table? In ADO, I could issue a query (using an MSS provider) which returned a result set from multiple tables, and update the data in a grid and post it. (I'm actually not quite sure how that works but it does). In ADO.NET I can't do this, I have to roll my own UPDATE, which isn't possible for ad-hoc queries. Does anyone know why this changed and if there is any technique to allow updates of ad-hoc queries in a data grid involving multiple tables? Thanks Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87247
  - 24
    - Application Global Datasets I am creating a dataset from xml on my main form using ReadXML. I have alot of other forms and want to use data from the tables in the main forms dataset. THIS IS NOT AN MDI APP. How can I set this up? reference the main form then the data set? put the dataset in its own class file? use the dataset xsd (which I don't know how to do yet)? something else I am not thinking of. Obviously the entire point is to get the disconnected dataset into memory and allow all my forms to hit the datables however they want. Also, since I am creating the dataset from XML I dont think I can use most of the normal wizards when doing this from server explorer. Many thanks, James M Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87240
  - 25
    - DataReader to ArrayList Hi, What would be the fastest way to transfer a one column DataReader into a ArrayList ? Thanks, Alan Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87223
- Next
  - 1
    - Prob with Param in UpdateCommand Greetings, I'm trying to update a detail table which does not have any unique fields (that is the exercise) and have a problem with parameters in the Where clause, message says my Where params not supplied. I have an int var and 2 string vars to retrieve the original values of the fields in the row to be updated. If I don't use a where clause, the params for the new values work OK except that all the rows get the same values. Thus, I have to use a Where clause but don't know to implement the Params in the Where clause. Here is what I have so far: sqlDA.UpdateCommand = New SqlCommand("Update tbl2 Set fld1 = @prm1, fld2 = @prm2 Where (ID = @ID And fld1 = @fld1 And fld2 = @fld2)", conn) ------------------------------------------------------- ---params with new values---------this works OK without Where clause---------- sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@prm1", SqlDbType.VarChar, 50, "fld1")) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@prm2", sqlDbType.VarChar,50, "fld2")) ----------------------------------------------------- ----------------------------------------------------- ---params for Where Clause with original values from variables--------- ---message says these params not being supplied to Where clause''--------------- sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@ID", SqlDbType.BigInt, 8, conID.ToString)) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@fld1", SqlDbType.VarChar, 50, strfld1)) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@fld2", SqlDbType.VarChar, 50, strfld2)) ----------------------------------------------------- Is there a way for me to reference the original field values without using vars, conID, strfld1, strfld2? How do I supply these params to the Where clause? Do I need to do anything to conID.ToString - supposed to be an Integer. Thanks for help, Jerry Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87218
  - 2
    - Data from Dataset into new table in SQL Hello: I am having trouble creating a table and then taking the contents of a dataset and insert it into the new table. I am looking for methods and exsamples I have read many different approches. 1. I read my data into the dataset from a Text file. I do some modifactions to the data. 2. I ask the user what table name they want. And then create the table with the same fields that the text file has and the table name that they specify. 3. I would like to take the data that is in the dataset and dump it into the table that was just created. How would I do that? Again, I have read many differnt ways with no success. Please help. :) Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87211
  - 3
    - dataset share between 2 user controls I have 2 user controls that both share the same typed dataset (which uses the typical parent child relationship). The first control fills the dataset and then passes a reference to it to the second control. There is a time when the first control needs to update the data in the dataset and re-fills it. However, when that is done, the second control does not "see" that change as the pointers to the memory locations are now out of sync. Does anyone know how to get it so that if my first control updates the dataset, the pointers will remain the same, so that the second control can "see" the new data? I tried creating a temporary dataset, filling it, and then copying it to the original, but that didn't seem to work either. Any thoughts would be greatly appreciated. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87205
  - 4
    - Typed DataSet names - length restriction Is there any restriction on the length of a DS name, Table name, Field Name, number of tables, etc. in a Typed Dataset? Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87203
  - 5
    - Concurrency in ADO.NET Hi all WeÂ´re developing an application will have a lot of concurrent users. I want to know whatÂ´s he best way to give a solution to this problem in .NET. Any idea will be appreciated Thanks a lot. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87190
  - 6
    - sp_help_job (HELP) Can anyone get sp_help_job to execute via ado.net ?? The following code produces a "severe error occurred on the command object" SqlConnection connection = new SqlConnection(connectionString) connection.Open() SqlCommand cmd = new SqlCommand() cmd.Connection = connection cmd.CommandText = "exec msdb.dbo.sp_help_job @job_name='My SQL Job',@job_aspect='JOB'" cmd.CommandType = System.Data.CommandType.Text cmd.CommandTimeout = 90 SqlDataAdapter da = new SqlDataAdapter(cmd) DataSet ds = new DataSet() da.Fill(ds) connection.Close() I can execute the same command Text in SQL Query Analyzer without a problem (using the same connection id and pwd) Even if I don't pass any parms I get the error. I've tried to execute it as a proc and as text Any ideas ?? Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87186
  - 7
    - connect to Access DB via IP address Hi, Like SQL Server, is it possible to build the connection string using IP address for retrieving data from Access DB(.mdb) ? Because I'm implementing an application in which the program installed on retail shops which has boardband internet access, but the database is located on Data Center, they have different subnet mask. So far I can think of using VPN is the only solution to connect Access database in data center. Thx in advance! Keith Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87185
  - 8
    - Using only one connection for several forms with VS.NET Hi, I have several forms in my project now, each with it's separate connection to a DB. I would like to have only one connection in a form or class that can be used by all the other forms and still be able to use the VS wizards for DataAdapter creation etc. I would also like to use the same DataAdapters and DataSets accross multiple forms. How can I do this most efficiently? Any good articles on this? I have not found any good information about this on the web yet. Any tips, hints, links or help will be greatly appreciated. Thanks in advance! Cheers, Trygve Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87176
  - 9
    - XML EXPLICIT Hello, I have a stored proc that takes two input params and returns xml using the "FOR XML EXPLICIT". I am at a loss how I can read this proc in .Net . I don't want to bind it or use a data grid etc, as its all on the server side. Does anyone know how to read a proc that returns XML ? Regards Danny Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87171
  - 10
    - Comparing two typed datasets Hi, I have a typed dataset for Employee named tdsEmployee. tdsEmployee has two columns named FirstName, LastName I want to compare two instances of tdsEmployee and get the differences. For Ex: tdsEmp1 might have data like Row1: 'Mike', 'Meyers' Row2: 'John', 'Doe' tdsEmp2 might have data like Row1: 'Mike', 'Meyers' Row2: 'John', 'Abe' Then after comparision, I want the result : 'John', 'Doe' is there any way to do this ?? TIA. :) Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87170
  - 11
    - Connections as Static??? Hi I am writing a fairly simple desktop app which will not be subject to great loads. Therefore this question is more for academic purposes I have implemented a class that declares only static members and functions. I use this class to control my connections. There are just 2 methods; Open and Close. The connection object within the class is static and has public scope. It is created when the app is started. (This obviously enables connection pooling This makes the code very simple. When I want to use a connection I just call myConnectionClass.Conn. No need to dimension anythinig, dispose etc. I just make sure I close it when the routine has finished Is this OK? I am worried that by declaring just 1 connection as a static there will be threading issues. i.e. There may be a que of users waiting to use the single, shared connection object What do you experts think Andy Newland (MCAD) Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87169
  - 12
    - Parameter causing error It's been a long night ... Hopefully someone can point out my mistake here. I'm getting a System.Data.SqlClient.SqlException system error when trying to pass the parameter to the database. Even substituting a hard-coded value causes the error. If I drop the parameter, no errors -- but of course, no parameter either. Dim cmdPayments As New SqlCommand Dim drPayments As SqlDataReader cnSQLServer.Open() cmdPayments = cnSQLServer.CreateCommand cmdPayments.CommandType = CommandType.StoredProcedure cmdPayments.CommandText = "GetPaymentHistoryByCustomer" 'this line causing the error cmdPayments.Parameters.Add(New SqlParameter("@CustomerID", cmbCustomers.ValueMember)) drPayments = cmdPayments.ExecuteReader(CommandBehavior.CloseConnection) Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87168
  - 13
    - unicode sorting How can I sort datatable according to unicode? I set corret regional and culture settings but Basic .Net sorts according Ascii. It sorts letters with accents like without them. thank you in advance Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87167
  - 14
    - .NET studio, add connection problem Hi, I use Microsoft Visual Basic .NET studio, and I created a VB project. I would like to create a new connection on the Server Explorer view. I select Data Connection item, and select "add connection ... " popup menu item, the "Data Link Properties" dialog box is not displayed. does anyone here have any idea ?? Thanks. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87164
  - 15
    - DataSet constraints Hi I have a typed DataSet that contains two tables. The second table has a foreign key that refers to the primary key of the first table. When i fill the first table there is no problem. But when i fill the second table i get the following error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Many thanks in advance Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87163
  - 16
    - ADO.NET and Localization Hi, I want work with local language in a VB.NET Application, like storing 'Arabic data' in the database as well as retrive it.Can any one help me out in this regard? Reny Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87161
  - 17
    - "Vertical Slice" of a DataSet I have a DataSet with three tables: (sorry, I'm at another PC and don't have access to my code to provide an XML snippet myDataSet.Tables[0].TableName = "AccountManagers" myDataSet.Tables[1].TableName = "NewsFeeds" myDataSet.Tables[2].TableName = "NewsFeedArticles" There are two DataRelations in this DataSet, they are defined as follows myDataSet.DataRelations.Add "AccountManagers_NewsFeeds", myDataSet.Tables["AccountManagers"].Columns["UserId"] myDataSet.Tables["NewsFeeds"].Columns["UserId"]) an myDataSet.DataRelations.Add "NewsFeeds_NewsFeedArticles", myDataSet.Tables["NewsFeeds"].Columns["SubscriptionId"] myDataSet.Tables["NewsFeedArticles"].Columns["SubscriptionId"]) The NewsFeedArticles table is filled with "articles" from an RSS feed. Here's what I need to do: (pseudo code for every entry in myDataSet.Tables["AccountManagers"].Row Generate some simple HTML as follows AccountManage NewsFee NewsFeedArticl NewsFeedArticl NewsFeedArticle .. NewsFee NewsFeedArticl NewsFeedArticl NewsFeedArticle .. It's easy to do the XSL transformation on a whole DataSet. My difficulty is coming from the fact that I have to do a tranformation on a vertical slice of the DataSet. So what I have to do is basically create a copy of the DataSet for each entry in .Tables["AccountManagers"]. I would fill the other tables using the two DataRelations. That seems inefficient. Is there an easier way to select a "vertical slice" of this DataSet? Hope I made sense, thank you. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87159
  - 18
    - Free Extensions Library Simplify application development with this free .NET framework extensions, which includes: + Straight-forward data access with in-memory databases: No need to manage connections, adapters, commands etc. + Soft XML rules + Extended controls library: Data control, progress bars, image buttons, explorer + Multilingual support with a single line of code + Intuitive data binding + Samples and utilities included Fully documented. Requires .NET framework 1.1 or later. You will be allowed to use the libraries in any application - private or commercial, and distribute them as part of your application, royalty-free. E-mail me for you free copy: ori@s-e-a.com.au Your acceptance of the license agreement will be required. Thank you -- Ori Millo Solutions Consultant SEA Software Ever After http://www.s-e-a.com.au Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87157
  - 19
    - Accessing Foxpro DBF and index files Please give me example to connect to DBF files and its indexes using OLEDB.NET Thank you. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87156
  - 20
    - Accessing Foxpro DBF and index files Please give me example to connect to DBF files and its indexes using OLEDB.NET Thank you. Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87155
  - 21
    - Preserving Lists in Product Description Fields I create lists in my products description field in SQL by pressing ctrl + j. I pull the information and find that I get one big long string in my dataset. Is there a way to preserve this lists? I'm dropping it into my html file and find that I can't break it up... Is there a way to do a string.indexof() for a ctrl + j? Maybe I can keep them working this way. Eg. Features: <ctrl + j> Ladder Back<ctrl+ j> Color option<ctrl + j> Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87147
  - 22
    - Cross -Site Scripting and SQL Data Reader I am using sqlDataReader for Showing data from the Data base But if the Data from sql is having tags like <script>alert()</script> then it shows an alert box while binding Is there any way of suppressing it this ..... ??? regard Vineet Batt Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87144
  - 23
    - integrated security and using NT credentials vs. ASP.NET My connection string is set to use integrated security. When I try to log into my data source via my asp.net application, I get the following error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" My NT login name is setup in the data source as a user and it has been granted the necessary rights against the database objects. I thinking that the default user name for asp.net application is the asp.net machine account, and because the database does not have this user established, I'm getting this permission error. Does anyone know the best way to avoid this and have the credentials of the logged in user be used via the integrated security connection string? Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87137
  - 24
    - ADO.NET the dataset and XML I have an XmlDatadocument (named rawXmlDataDocument ) which has been populated by a dataset (named searchResultDTO). This yields the following xml: <SearchResultDTO xmlns=\"http://tempuri.org/SearchResult.xsd\"> <SearchResult> <ID>182</ID> <Summary>Power User Account, Please enter your content here ...</Summary> <Path>This is the path!!</Path> </SearchResult> <SearchResult> <ID>185</ID> <Summary>Power User Account, Please enter your content here ...</Summary> <Path>This is the path!!</Path> </SearchResult> </SearchResultDTO> I am trying to parse with XSL using the XslTransform object. My XSL is the following: <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" > <xsl:template match="/"> <xsl:call-template name="DisplayResults"></xsl:call-template> </xsl:template> <xsl:template name="DisplayResults"> <xsl:for-each select="SearchResult"> <h1>HELLO!</h1> </xsl:for-each> </xsl:template> </xsl:stylesheet> This is done using the following code (Please note that the XslTransform was populated earlier) : rawXmlDataDocument = new XmlDataDocument(searchResultDTO); //return rawXmlDocument.OuterXml; transformedXmlDataDocument = new XmlDataDocument(); transformedXmlDataDocument.Load(XslTransform.Transform(rawXmlDataDocument,null)); Response.Write(transformedXmlDataDocument.OuterXml); I would expect this to produce the following HTML when the XMLDataDocument.OuterXml method was called (after the tasnformation): <h1>HELLO!</h1> <h1>HELLO!</h1> Instead no transformation occurs. I think my xslt is wrong. Can anybody halp me? Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87134
  - 25
    - HELP - Getting a Value Out of a DataTable This is a multi-part message in MIME format. ------=_NextPart_000_00BC_01C436AA.ACCF8D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have code to populate 1 data table in a dataset. The data table looks = something like: ParameterName ReportName ParameterValue Param1 Report1 1 Param2 Report1 2 Param3 Report1 3 ReportStartDate Report1 05/10/2004 00:00 ReportEndDate Report1 05/10/2004 23:59 After querying the DB and populating the dataset/data table, I now need = to get the "ParameterValue" for the "ReportStartDate" and = "ReportEndDate" rows to save to local variables, something like: value in local variable rptSDate =3D 05/10/2004 00:00 value in local variable rprEDate =3D 05/10/2004 23:59 But, I'm not sure how to navigate through this data table to find the = "ReportStartDate" and "ReportEndDate" rows and then get their associated = "Parameter" values. Help? Any suggestions? Thanks. ------=_NextPart_000_00BC_01C436AA.ACCF8D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have code to populate 1 data table in = a=20 dataset.  The data table looks something like:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ParameterName     =20 ReportName    ParameterValue</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>Param1     =20        = Report1      =20 1</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>Param2   =20         =20 Report1       2</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>Param3         &nbs= p;  =20 Report1       3</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ReportStartDate   =20 Report1       05/10/2004 = 00:00</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ReportEndDate     =20 Report1       05/10/2004 = 23:59</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>After querying the DB and populating = the=20 dataset/data table, I now need to get the "ParameterValue" for the=20 "ReportStartDate" and "ReportEndDate" rows to save to local variables, = something=20 like:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>value in local variable rptSDate =3D = 05/10/2004=20 00:00</FONT></DIV> <DIV><FONT face=3DArial size=3D2>value in local variable rprEDate = =3D 05/10/2004=20 23:59</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>But, I'm not sure how to navigate = through this data=20 table to find the "ReportStartDate" and "ReportEndDate" rows and then = get their=20 associated "Parameter" values.  Help?  Any = suggestions?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_00BC_01C436AA.ACCF8D40-- Tag: SortOrder's column in GetOLEDBSchemaTable Tag: 87132

Hi,

How do I know SortOrder(ASC or DESC) of key fields in ADO.NET?
I could get SortOrder by using ADOX.
I can't find near column by GetOLEDBSchemaTable.Primary_Keys/Foreign_Keys.

Thanks

Tom

--------------------------------
From: Tom Hadler

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>z96rY7znZU2INR0oSrCqQg==</Id>

Top