Dump DataTable to text

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
    - ms access & ado.net Hello I have been developping datadriven applications for a while now. I used sql server and msde. but I am on the hunt for an integrated database for a web application I want to write: what I mean is I want to have a file based DB engine (if possible) and include the file in a directory of the web app and access it. I just do not want to deal with the install of a service when redistibuting the app. I am considering ms access but I want to know if I could have multiple connections to it via ado.net since the web app will have multiple users hiting it. I guess that my first question. the other one is : Does any body know of an file integrated DB engine ? I am looking at vistaDB and deseperatley looking for some xml based ones ? Tag: Dump DataTable to text Tag: 77727
  - 2
    - 'Convert' is not a member of 'Boolean' I used the designer in VS.NET 2003 to create a dataset. Within that dataset, there is an element "Tags", with a primary key and relationship: <xs:element name="Tags"> <xs:complexType> <xs:sequence> <xs:element name="TagName" type="xs:string" minOccurs="0" /> <xs:element name="TagDesc" type="xs:string" minOccurs="0" /> <xs:element name="System" type="xs:boolean" minOccurs="0" /> <xs:element name="FieldType" type="xs:string" minOccurs="0" /> <xs:element name="FieldLength" type="xs:integer" minOccurs="0" /> <xs:element name="Decimal" type="xs:integer" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:key name="pkTags" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Tags" /> <xs:field xpath="mstns:TagName" /> </xs:key> <xs:keyref name="TagsLabelsTags" refer="pkTags" msdata:DeleteRule="Cascade"> <xs:selector xpath=".//mstns:LabelsTags" /> <xs:field xpath="mstns:TagName" /> </xs:keyref> Nothing special, right? When I attempt to build the project I get a series of compile errors in the code behind: 'Convert' is not a member of 'Boolean'. Public Sub SetTagDescNull() Me(Me.tableTags.TagDescColumn) = System.Convert.DBNull <--- Here End Sub There is one error for each of the non-key fields, all in the Set_Field_Null() subroutines. I'm lost. Any ideas? Tag: Dump DataTable to text Tag: 77726
  - 3
    - SQL Server basics I have a Dataset containing a DataTable (say, 'dt1') that has all the fields that are contained in a SQL Server database's table. In addition, it contains a field (let's call it 'HasItems') of type boolean. I want to populate 'dt1' with all the records in the SQL Server table, and populate the 'HasItems' field with True if matching records exist in another SQL Server table (actually a view), and False if no matching records exist. I could do this easily in Access, but I'm new to SQL Server, and need to know the best way to go about it. (The way I'm doing it now has me thinking, "First the earth cooled, then the dinosaurs came..."). Specific help would be appreciated, but also a reference I could use to ramp up my SQL Server skills would be nice too. Thanks. Tag: Dump DataTable to text Tag: 77723
  - 4
    - Error: Cannot insert a non-null value into a timestamp column Hi, I have a typed dataset with tables including timestamp type field, when ready to commit the change back to the SQL server trough the data adapter and my storeprocedure, I receive the error. How can I force SQL server inside a storeprocedure a NULL value for that timestamp field? Is there a better solution from my c# code? I try the following, ---------------------------------------------------------------------------- ALTER PROCEDURE dbo.InsertUser ( @last_name char(25), @first_name char(20), @phone char(20), @login_name char(30), @email char(100), @last_login datetime, @datemodif datetime, @timestamp timestamp, @user_id uniqueidentifier OUTPUT ) AS SET NOCOUNT OFF; SET @user_id = NEWID() SET @timestamp = NULL INSERT INTO [user] (user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif) VALUES (@user_id, @last_name, @first_name, @phone, @login_name, @email, @last_login, @timestamp, @datemodif); SELECT user_id, last_name, first_name, phone, login_name, email, last_login, timestamp, datemodif FROM [user] WHERE (user_id = @user_id) Tag: Dump DataTable to text Tag: 77714
  - 5
    - login failure msg Just wondering if anyone knows what might be causing this login failure. I used the data-adapter wizard and selected use an existing connection(also tried new connection that test ok). I selected use existing stored procedure, for the select operation selected the stored procedure I want to use. It created the adapter and also an SQLconnection on the page. So for some reason am getting this login failure. I am able to connect to the dbase in the solution explorer and when I look at the connection string in the data adapter I noticed there is no password value. I have workstation id="xxxxxx";packet size=4096;user id=xxxxxx;data source="xxxx";persist security info=False;initial catalog=Vehicle_Mileage here is the error message. Login failed for user 'MileageWeb'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MileageWeb'. Source Error:= line 72 Line 70: Me.SqlDataAdapter1.SelectCommand().Parameters("@EndDate").Value() = "1/6/2003" Line 71: Me.SqlDataAdapter1.SelectCommand().Parameters("@StartDate").Value() = "1/1/2003" Line 72: SqlDataAdapter1.Fill(ds_vhist, "VehicleReservation") Thanks Paul. Tag: Dump DataTable to text Tag: 77711
  - 6
    - Converting Recordset to DataView I originally posted this question to the vb.net newsgroup, but it was suggested that I re-post here. I have an application that was converted from VB6 to .Net. The app uses a data access layer that returns data as disconnected recordsets. I'm adding new functionality to the app and want to use .Net controls and data binding. So, I'm converting a recordset to a dataview that can be bound to a listbox control. I'm doing this conversion via a data adapter using the following code: Public Shared Function GetViewFromRS(ByVal pRS As ADODB.Recordset) _ As DataView Dim sAdapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter Dim sTable As System.Data.DataTable = New DataTable sAdapter.Fill(sTable, pRS) GetViewFromRS = New DataView(sTable) End Function So far so good. The first time I call this function it works perfectly. However, I need to call it multiple times to update the DataView as the recordset is modified. The problem is that subsequent calls to this function for the same recordset always return a DataView that has no rows (Count = 0). Can anyone explain why this problem is occuring and how I might work around it? Thank you. Kees VanTilburg VanTilburg Enterprises Tag: Dump DataTable to text Tag: 77710
  - 7
    - ReadXML Dataset throws Insert Into error I'm in the process of learning ADO.net with Vb.Net and I've been stumped by the following problem. I created an XML file of an Access Table that is filled with 400 records (using .WriteXml("c:\HospitalList.xml", XmlWriteMode.WriteSchema)). I then purged the table of all the records, I thought I should be simply able to repopulate the table with the XML file, but when ever I try I get a "Syntax Error in Insert Into Statement". I'm allowing the DataAdapter to create the Insert command, here is what is being created: CommandText: "INSERT INTO HospitalList( Index , HospitalName , TransferAgency , Visible , HospCode , StateIndex ) VALUES ( ? , ? , ? , ? , ? , ? ) Thanks for you help, code belo Andy Moye ------Code snipet--- Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\Working_D\Lists.mdb Dim cn As OleDbConnection = New OleDbConnection(strConnection cn.Open( Dim strSelect As String = "SELECT * FROM HospitalList Dim dscmd As New OleDbDataAdapter(strSelect, cn ' Load a data set Dim ds As New DataSe Dim dsXML As New DataSe ' Set the data adapter object's UPDATE, INSERT, and DELET ' commands. Use the SqlCommandBuilder class's ability to auto ' generate these commands from the SELECT comman Dim autogen As New OleDbCommandBuilder(dscmd 'Simply fills an empty DS with the Select Statemen 'dscmd.Fill(ds, "HospitalList" 'OR Fills the Data set with the Scehma only, no dat dscmd.FillSchema(ds, SchemaType.Source, "HospitalList" dscmd.Fill(ds, "HospitalList" ds.ReadXml("C:\hospitallist.xml", XmlReadMode.ReadSchema dt = ds.Tables.Item("HospitalList" 'Simply do this to see if any records are flagged as change Dim dt2 As DataTable = dt.GetChanges(DataRowState.Added MsgBox("Rows Added " & dt2.Rows.Count dscmd.Update(ds, "HospitalList" Tag: Dump DataTable to text Tag: 77709
  - 8
    - Displaying Enumerated DB Integers as Strings In DataGrid Hi Quite a banal problem... But for some reason I have found no elegant solution.. I have enumerated integer values in my DB, and I would like to use DataGrid for displaying the contents of the DataSet (filled from the DB, of course) including displaying meaningful text strings for the enumerated integer values There are several levels in which this issue may be handled, So.. 1) Is there any way to force use of a specific user-defined type, which can be converted to/from a DB type (Int for instance) when generating typed DataSet? I mean possibility to use a user-defined type (Enum or other class, minding the conversion possibilities) in the XSD schema 2) Is there a simple way to force the DataGrid to perform conversions from integer values to strings, through using enums or something? (Without implementing some custom monstrosity DataGridColumnStyle or something) 3) I hate to think of putting conversions and giving the DataGrid other DataTable with converted string values.. Thank you. Tag: Dump DataTable to text Tag: 77708
  - 9
    - Getting changes from the database I'm using a DataAdapter to Update and Synchronize with the database. When I do a Fill on my dataAdapter I get the changed and new records from the database (changed by other users) into my dataset but not those which have been deleted at the database. Is this the way the DataAdapter should work (don't synchronize the deleted records from the database to the dataset) or is it my fault? If this is the way the DataAdapter act's what can be done, do get completely in synch? If I do a clear on my dataset before invoking the Fill method, my databinding get's lost for a Moment, because the dataset is completely rebuild. Thanks. Tag: Dump DataTable to text Tag: 77703
  - 10
    - insert decimal in Access Hallo Im learning VB.net 2003 and now I like to insert a decimal in Access, but the number 10,25 is in Access 1025. The Access field is also decimal with 2 digets behind. I think it will be on the regional settings, because whenn I try with 10,25 then it works. But my variable is always format as 10,25. What must I do? Can anyone help me? Tag: Dump DataTable to text Tag: 77691
  - 11
    - Datareader passed ByVal - OOP Basics question Hi All, I've a big doubt about reference to object destruction. In the test below I call 2 times a sub passing a datareader in 2 different ways. Who can tell me if datareader is destroyed in both cases and so connection closed (using dr behavior)? *-*-*-* Case 1 *-*-*-* Dim cm As SqlCommand Dim dr As SqlDataReader = cm.ExecuteReader(CommandBehavior.CloseConnection) ' Datareader is passed ByVal to MySub ' I have to close "dr" here and "otherdr" in MySub MySub(dr) dr.Close() dr = Nothing *-*-*-* Case 2 *-*-*-* Dim cm As SqlCommand ' No reference to datareader exist (?) at this level, ' I have only to close "otherdr" in MySub ? MySub(cm.ExecuteReader(CommandBehavior.CloseConnection)) *-*-*-* MySub *-*-*-* Sub MySub(ByVal otherdr As SqlDataReader) While otherdr.Read ' Do something End While otherdr.Close() otherdr = Nothing End Sub -- Giulio Tag: Dump DataTable to text Tag: 77687
  - 12
    - Newbie: Adding new rows to dataset Hi, I have a data-entry type form I created with textboxes bound to a dataset. I can successfully pull all the correct information up and change any existing data, and navigate through each record using the BindingManagerBase.Position. What I'm trying to do now is add a row to the dataset and then move to that row with the form to add new information. I've tried declaring a new row and adding it to the dataset, as well as doing BindingManagerBase.AddNew. Each of these adds a row to the dataset, but I can't get it to show on the form. When I close the form, the database is updated, and the new row appears in the database table correctly. How do I get the form to show the added row? Thanks, Nathan Tag: Dump DataTable to text Tag: 77682
  - 13
    - Databinding question hi all, Can we call our procedures when databinding is in process. I want to check all the checkboxes in a checkboxlist control while data is coming from dataset. I can do this after the binding is done.. and manully loooping through the checkboxlist control and checking all the checkbox.. but i want to ask if there's better way to do it.. thanks Noor Tag: Dump DataTable to text Tag: 77678
  - 14
    - Working with a dataset I have a dataset with tables in it that i have filled from my database. If i want to find the Max value from a column in my dataset how do i do this? ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Dump DataTable to text Tag: 77675
  - 15
    - UTF8 Character Set issues with Oracle Provider We are building an application with VB.NET on the .NET Framework 1.1 and the .NET Managed Provider for Oracle. We are connecting to an Oracle 9.2.0 server on HP-UX using the 8.1.7 client. The character set on the server instance is "AL32-UTF8". When we call OracleCommandBuilder.DeriveParameters(), we get the following exception: System.Data.OracleClient.OracleException: ORA-06550: line 1, column 72: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated KB 322158 seems to indicate that there are some issues when UTF character sets and NCHAR, NVARCHAR2, or NCLOB data types with the Oracle 8.1.7 client. In our case, we are using standard CHAR, VARCHAR2, and CLOB data types. If the Oracle client is upgraded to 9.2, the exception is not thrown. However, we would like to avoid upgrading the Oracle client, as there is a large number of machines with the 8.1.7 client already installed. Can anyone else shed some additional light on the issue? Thanks, Brian Baker -- Microsoft MVP -- ASP / ASP.NET Please post responses to the group Tag: Dump DataTable to text Tag: 77662
  - 16
    - GROUP BY date I think I need to format the date in the table when I use GROUP by to group the dates. The table has date and time stamp but I need it to group by the date alone without the time stamp. How do I format the date field in the SQL statement using SQL Server? I was able to do it in MS ACCESS but it is different in SQL Server then MS ACCESS or .net then VB6. The old way was "Select sum(tot) as total, dte from tblName group by format(dte, 'mm/dd/yyyy') " Thanks Tag: Dump DataTable to text Tag: 77649
  - 17
    - passing input parameter to sql server sproc I have a very simple Stored Procedure that isn't working for me: CREATE PROCEDURE FindTutors ( @LastName NVarChar ) As ( SELECT fn, ln FROM main WHERE ln = @LastName ) GO Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas? Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnString")) Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString() 'Cmd.Parameters.Add("@LastName", txtLastName.Text) cn.Open() Dim rdrContent As SqlDataReader gridTutors.DataSource = Cmd.ExecuteReader() gridTutors.DataBind() cn.Close() End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Dump DataTable to text Tag: 77648
  - 18
    - Filling dataset from text file. I am getting data from a text file using the folowing code. It uses the schema.ini file to define a structure of the datatable in the Dataset. The default file called schema.ini. I have about 10 or 15 tables i have to populate. Is there a way to specify an ini file i want to use? Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""") Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " & FileName, Conn) Dim DS As New DataSet Try Comm.AcceptChangesDuringFill = False Comm.Fill(DS) End try Tag: Dump DataTable to text Tag: 77647
  - 19
    - Dataset generation and relation rules In VS.NET 2003 if you use sqldataadapters at design time to create your dataset there is problem : after you regenrate a dataset the relation rules are set all to default. Any quick hint to avoid this? Tag: Dump DataTable to text Tag: 77643
  - 20
    - Adding Data To a Table That Isn't Part Of the Original SQL Query I am fairly new to ASP.NET so I think I am missing something fundamental. Anyway, quite often I am pulling data from a database, but then I need to use that data to produce more data. A simple example would be: Let's say Column1=StartDate and Column2=EndDate. In addition to displaying Column1 and Column2, I need to do some calculations and display in as Column3. The calculations are easy and can be done in the code-behind. How to display it is another question. However, they might not be math calculations. Take for example, a SQL query that returns a list of servers and then for each server I use WMI to get some additional information and then I need to display the servername (from SQL) and the OS and Service Pack Version (from WMI) on a web page. The way I have been handling it is creating a new table in memory and adding the columns from the original SQL query and then doing the calculations and adding that as a column. Then I'll use this new table to DataBind my DataGrid or DataList. Is this the best way to do it? I feel like this isn't the smartest way to acomplish this. Tag: Dump DataTable to text Tag: 77642
  - 21
    - getOleDbSchema Hi, I want to get the tables,columns and constraints in a database. I understand that the getOleDbSchema method of the Connection object helps. Could anyone help me with code samples or direct me to appropriate links where I could find out more ? Thank You Julian Tag: Dump DataTable to text Tag: 77641
  - 22
    - passing input parameter to sql server sproc I have a very simple Stored Procedure that isn't working for me: CREATE PROCEDURE FindTutors ( @LastName NVarChar ) As ( SELECT fn, ln FROM main WHERE ln = @LastName ) GO Very simple; just trying to pass the @LastName parameter from my ASP.NET code. Still, whenever I click the button that is supposed to show all results in a datagrid, nothing comes up. I have altered the Sproc to just be "SELECT fn, ln FROM Main WHERE ln = 'Damon' " and it works fine then - so I know it's a matter of passing this parameter. Here is my codebehind - anyone have any ideas? Public Sub FindTutors(ByVal sender As Object, ByVal e As EventArgs) Handles btnFind.Click Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnString")) Dim Cmd As SqlCommand = New SqlCommand("FindTutors", cn) Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value() = txtLastName.Text.ToString() 'Cmd.Parameters.Add("@LastName", txtLastName.Text) cn.Open() Dim rdrContent As SqlDataReader gridTutors.DataSource = Cmd.ExecuteReader() gridTutors.DataBind() cn.Close() End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Dump DataTable to text Tag: 77638
  - 23
    - ini files I am getting data from a text file using the folowing code. It uses the schema.ini file to define a structure of the datatable in the Dataset. The default file called schema.ini. I have about 10 or 15 tables i have to populate. Is there a way to specify an ini file i want to use? Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FilePath & ";Extended Properties=""text;HDR=NO;FMT=Delimited""") Dim Comm As New System.Data.OleDb.OleDbDataAdapter("select * from " & FileName, Conn) Dim DS As New DataSet Try Comm.AcceptChangesDuringFill = False Comm.Fill(DS) End try Tag: Dump DataTable to text Tag: 77629
  - 24
    - Connect to remote SQL server ... Can anyone give me the ADO.Net connection string to connect to a remote SQL server using it's IP address ? Any parameters and settings to be checked ? Tag: Dump DataTable to text Tag: 77624
  - 25
    - Dataset ExtendedProperties woes I'm working with a dataset to which I've added an extended property like so: Const KEY_SELECT = "selectquery" Dim strSQL as String = "Blah blah blah" dsetTemp.ExtendedProperties.Add(KEY_SELECT, strSQL) If I try to retrieve the value using the constant to specify the key, I get a "The parameter is incorrect" error, but if I hardcode the key name it works: Console.WriteLine(dsetTemp.ExtendedProperties.Item(KEY_SELECT).ToString) spits out: "The parameter is incorrect" Console.WriteLine(dsetTemp.ExtendedProperties.Item("selectquery").ToString) spits out: "Blah blah blah" Why doesn't it work when I specify the key with a constant? - Don Tag: Dump DataTable to text Tag: 77616
- Next
  - 1
    - Security through stored procedures I've just started reading "Microsoft ADO.NET" by David Sheppa. One of the lines in the overview caught my eye: "Because many database administrators allow users to modify the contents of a database only through stored procedures, many developers cannot submit updates through the ADO Recordset object". This is new to me - does it mean that you could revoke UPDATE access to a database table but allow EXEC access and that the code inside the sproc carries out the update? I rather like the idea of this. I've always had a problem with the conflict between security and open access to a database. For example, our users have UPDATE access to a table as they obviously have to write updates back. However, this means that anyone with a little knowledge could use ODBC to connect to the database and write whatever they want to the database table. Which from a security/audit point of view isn't good. I was thinking about adding an encryption code to each record so that whilst we couldn't stop users changing data directly, we could at least detect when it had happened. Another option was to carry out all updates via a service which had different security rights but that's getting very messy, an probably very inefficient. Regards, Rob. Tag: Dump DataTable to text Tag: 77606
  - 2
    - autonumber problem in my datatable Hello, I wanted some help on a dataset question. I have created a dataset and datatables and used the dataadapters 'fill' method on them. In my database the primary key is an autonumber. When i use the fill method and set a datagrid source to my datatable i can see 10 rows. The rows each have a primary key value from 0 to 10 (Autonumbers). When i try to insert a new row into my datatable, the primary key autonumber seems to start at the value 0 rather than continuing from the highest number. i.e 11 onwards. For this reason my inserts into the datatable keep failing. Why does it do this? Is there anyway i can make the autonumber start from the..... 'highest already generated number' (in this case 10) + 1 ??? Another question If i have an autonumber coloumn in my database, will this automaticcaly be created for my datatable if i simply use the dataadapters fill method? thx Tag: Dump DataTable to text Tag: 77598
  - 3
    - synchronizing 2 grids in two different forms Hi all! i have this problem: i need to synchronize 2 datagrids in 2 different forms upon the Master Details model. i want to do this using BindingContext, BindingManagerBase. can you give me any directions? (i've read the msdn topics concerning this stuff) Thank you, Bamse ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Dump DataTable to text Tag: 77595
  - 4
    - Automatically Generated Commands & Optimistic Concurrency Hello, I have created a dataadapter by specifying the select command and then used the SqlCommandBuilder to automatically generate the Update, Delete and Insert commands. I fill the dataset, close the DB connection, open the connection again, manually change the database, and then update the dataset and call the dataadapter update method, I was expecting it to raise a dbconcurrrency error but none was raised. why is this as the help on the Microsoft pages states "The logic for generating commands automatically for UPDATE and DELETE statements is based on optimistic concurrency. That is, records are not locked for editing and can be modified by other users or processes at any time. Because a record could have been modified after it was returned from the SELECT statement, but before the UPDATE or DELETE statement is issued, the automatically generated UPDATE or DELETE statement contains a WHERE clause such that a row is only updated if it contains all original values and has not been deleted from the data source. This is done to avoid new data being overwritten. In cases where an automatically generated update attempts to update a row that has been deleted or that does not contain the original values found in the DataSet, the command will not affect any records and a DBConcurrencyException will be thrown." any help would be appreciated, Kay. My code is as follows: Dim dataset As New DataSet Dim connectString As String = "db connection string is in here" Dim myConn As New SqlConnection(connectString) Dim SqlSelectCommand As New SqlCommand("SELECT ID, Description FROM optFrame WHERE (RoleAccessRevised = 1)", myConn) Dim dataadapter As New SqlDataAdapter(SqlSelectCommand) dataadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey Dim cmdBuilder As New SqlCommandBuilder(dataadapter) myConn.Open() dataadapter.Fill(dataset, "optFrame") myConn.Close() 'NOTE: At this point I go to sql server DB and manually change the data in the specified row, hoping it will cause concurrency myConn.Open() Dim rowToUpdate As DataRow = dataset.Tables("optFrame").Rows.Find(TextBox13.Text) 'NOTE : the row specified in textbox13 exists and is updated rowToUpdate.Item("Description") = TextBox14.Text Try dataadapter.Update(dataset, "optFrame") 'Note: concurrency is not caught here Catch ex As DBConcurrencyException Label28.Text = "concurrency error" End Try myConn.Close() Tag: Dump DataTable to text Tag: 77594
  - 5
    - Update datasource without using DataAdapter Hi All, I'm trying to find a way to update Dataset's datasource withtout using DataAdapter, does there exist any methods? Thanks! ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Dump DataTable to text Tag: 77587
  - 6
    - Connection Pool - Does not check for Server Status. hi All, Connection Pool - Does not check for Server Status. Here is the scenario : 1) SQL Server is up 2) Create a connection pool for a particular connection string by repeatedly executing the same query in .NET ( using SqlConnection and SqlCommand classes ) This involves following steps - Open a connection - Execute a Query - Close the connection 3) STOP the SQL Server. 4) Run the same query again. We notice that - Opening a Connection goes through fine. If the pool was not formed ( if we are opening the connection for the first time ), this would have FAILED by throwing SQL Server not found execption. - Execute Query , Throws an Exception - General Network Error, Error Number 11. 5) Now RE-START the SQL Server. 6) Run the same query again. We notice that - Opening a Connection goes through fine. BUT, - Execute Query , Throws an Exception - General Network Error, Error Number 11. An Exception is thrown even if SQL Server is UP! Once the Server is up, we want the connection to succeed. Now, How do we handle this scenario? How do we invalidate the Connection Pool? thanks, HiChetu Tag: Dump DataTable to text Tag: 77583
  - 7
    - Problem with sql server text data type Hi , I have a method in an asp.net application that calls a sql server stored procedure. The stored procedure inserts data to Text field. Here is the .net procedure... public int Insert(int articleId,string textData) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@articleId",SqlDbType.Int,4), new SqlParameter("@text",SqlDbType.Text), new SqlParameter("@pageId",SqlDbType.Int,4) }; parameters[0].Value = articleId; parameters[1].Value = textData; parameters[2].Direction = ParameterDirection.Output; try { RunProcedure("weeklyreport_inserttext",parameters,out rowsAffected); } catch(SqlException exc) { return 0; } return (int)parameters[2].Value; } My problem is that only so much of the text parameter gets stored and the rest is just cut off. Has anyone had a similar problem? Any help would be gratefully appreciated. Thanks, Kevin. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Dump DataTable to text Tag: 77577
  - 8
    - XML support in ADO.NET I've got a dataset with <xs:restriction> tags, custom elements and other stuff in it. I want to populate it using a dataadapter and data from SQL but it ignores the schema/tags. Apparently this is due to the way ado.net works with XML. To do it I have to revalidate the xml data using the XMLValidatingReader class, which then gives me a performance overhead and is a right programming pain. Does anyone know if Microsoft has plans to provide more complete support for xml documents in ADO.NET in a future release? Tag: Dump DataTable to text Tag: 77570
  - 9
    - Extract Excel Cell Properties in c# Hi, Can u help me to Extract Excel Cell Properties like Formula Functions and Data Type like Numeric,Accounting etc.. Tag: Dump DataTable to text Tag: 77565
  - 10
    - Sorting a DataTable... Hi, I have a DataSet whose default table, namely DataSet.Tables[0] which has a row for each day selected from a database, however not all the days are always there so I am iterating thro each day and if it is missing I add it to the table by way of a new row with default values. The DataSet is then passed thro a web service to a Web front end and then shown on a grid. The problem I have is that I want the days to appear Mon thro' Sunday, but as I am adding them at the end of the Rows, they will not appear in the right order. I thought about using InsertAt, but depending on the number of days already there or inserted it would be tedious to have to work out which position to InsertAt, to get them in the right order at that stage. So to save my little brain getting a buzzing noise is there an existing way to do this, I was thinking of using DataTable.Select, but wasn't sure how to get it back into the original dataset to pass thro'. Any ideas? TIA Colin B Tag: Dump DataTable to text Tag: 77561
  - 11
    - Whi can't I read config file I use the following app.dll.config file to store connection string. The string always returns null when I try to retrive it. Here is what I have for the app.config and base class code: I used a similar code in ASP.NET and it works fine. What is the problem ? <?xml version="1.0" encoding="utf-8" ?><configuration><appSettings><add key="connectString" value="data source=mimora; user id=scott; password=tiger" /></appSettings></configuration> using System; using System.Data; using System.Data.OracleClient; using System.Configuration; using System.Collections.Specialized; using System.IO; namespace Com.AAD.Business { /// <summary> /// Summary description for Class1. /// </summary> abstract public class DataLayerBase : IDisposable { private OracleConnection _connection; public DataLayerBase() { try { string connStr= System.Configuration.ConfigurationSettings.AppSettings["connectString"]; _connection = new OracleConnection(connStr); } catch (OracleException exep) { throw (exep); } catch (Exception exep) { throw (exep); } // _connection = new OracleConnection("data source=mimora; user id=scott; password=tiger"); } protected OracleConnection Connection { get { return _connection; } } public void Dispose() { _connection.Dispose(); } } } Tag: Dump DataTable to text Tag: 77559
  - 12
    - SQL Insert Syntax Error Hi, I can't see what is wrong with this statement. I have verfied the table and field names are correct and still have no idea. I am using the following code. Dim sSQLInsert As String = ("INSERT INTO Members (Member_ID,Password) Values(") & "'" & txtUserName.Value.ToString & "'" & "," & "'" & txtPassword.Value.ToString & "'" & ");" m_oOleDbCmd.CommandText = "" m_oOleDbCmd.CommandText = sSQLInsert m_oOleDbCmd.ExecuteNonQuery SQL Insert Statement: "INSERT INTO Members (Member_ID,Password) Values('chrisg','rckrll');" I compared this to other Insert statements I have that work and don't see anything wrong with it but yet I am getting a syntax error on the Insert statement. The data types of the fields are Text in an Access .mdb. Thanks, Chris Tag: Dump DataTable to text Tag: 77558
  - 13
    - Windows AUTH w/ASP.net My db admin has decided that he does not like sql logins. I would like to know if it is possible to have asp.net connect to a MSSQL datasource. But I was curious if it was possible for me to have it connect as the visitor to the site with out setting up asp.net to impersonate the connected user? Sorry if this does not make since or if I posted the question in the wrong location. Tag: Dump DataTable to text Tag: 77557
  - 14
    - mdac 2.9 when is mdac 2.9 coming out? thanks mcgs@guide2grants.biz Tag: Dump DataTable to text Tag: 77556
  - 15
    - Limit Connections Is it possible via code or within a access database to limit the number of connections involved with the database. I have a client who has asked me to write a program but is being dishonest (told by other sources) on the number of users involved. I do vb.net and windows applications. Tag: Dump DataTable to text Tag: 77544
  - 16
    - DataRowView To DataRow If I have a DataRowView record, how do I find the DataRow version of the row? Is there some property which will aloow me to get that? Thanks in advance for your assistance!!!!!!!!!!!! Tag: Dump DataTable to text Tag: 77541
  - 17
    - ADO error Cannot convert type 'DataLayer.WSTimeEntryLog.User_STDS' to 'StronglyTypeDSCreation.User_STDS' dataset Problem: The following line, StronglyTypeDSCreation.User_STDS myDS = myWS.EmployeListSTDS(); Give me the error, Cannot convert type 'DataLayer.WSTimeEntryLog.User_STDS' to 'StronglyTypeDSCreation.User_STDS' dataset Project description: One solution, with projects, one DataLayer class, one StronglyTypeDSCreation class, one BusinessLayer class, one Web service WS_TimeEntryLog The Web service is working properly and return a TypedDataset. Inside the DataLayer class I do have one reference to the web service WS_TimeEntryLog who return a StonglyTypeDataSet base on class StronglyTypeDSCreation for table User_STDS and also one reference to the class StronglyTypeDSCreation. I notice when I add that WebService reference, Visual Studio also add the schema file or the xsd file use to generate the class. Now I am unable to find the way to actually called the web service function returning one TypeDataset of type StronglyTypeDSCreation from the DataLayer class. I try to cast it, with the same result, any Idea on how to fix this ? ----------------------------------------------------------------------------------------------- namespace DataLayer public class DL { WSTimeEntryLog.WSTimeEntryLog myWS = new WSTimeEntryLog.WSTimeEntryLog(); // my Web Services ... public StronglyTypeDSCreation.User_STDS ListEmploye() { myWS.PreAuthenticate=true; myWS.Credentials= System.Net.CredentialCache.DefaultCredentials; StronglyTypeDSCreation.User_STDS myDS = myWS.EmployeListSTDS(); // Line with error return myDS; } } Tag: Dump DataTable to text Tag: 77533
  - 18
    - Better to pass dataSet1 or just GetChanges() to Update()? Hi again, and please pardon the silly question - new to ADO.NET... :-) When I call the DataAdapter's Update() method, am I better off passing the entire dataset, or call GetChanges() first? Is there a performance difference either way, either when A) all parts of the application are on the same machine B) a middle tier is set up on a remote machine. It seems to me that in this case it's better to just pass the changes (less data to serialize), but I want to make sure I'm correct in my thinking. Thanks! -Eric Tag: Dump DataTable to text Tag: 77518
  - 19
    - Need some help to figure out why record isnt updating I am working on content management system that allows the text in articles to be updated. On the main page of the cms (default.aspx) the article titles are shown with an edit hyperlink that sends the user to the edit page which has a textbox and an update linkbutton. All of my data access logic is a separate class file and i then call the appropriate routine. However the text in the textbox doesnt update. It only updates when a text value is hardcoded into the the sql statement. Maybe one of you can figure out what the heck is going on. Thanks in advance...Here is the code: 'this sub populates the textbox Public Sub ShowArticleText(ByVal ArticleID As String, ByRef ArticleText As String) Dim cmd As New OleDbCommand("Select * From Articles Where ArticleID = @ArticleID", RDConn) cmd.Parameters.Add(New OleDbParameter("@ArticleID", cmd)) cmd.Parameters("@ArticleID").Value = ArticleID da.SelectCommand = cmd da.Fill(ds, "Articles") ArticleText = ds.Tables(0).Rows(0).Item("ArticleText").ToString End Sub ' this is the sub to update the text in the texbox Public Function UpdateComment(ByVal ArticleText As String, ByVal articleid As String) As OleDbCommand Dim cmd As New OleDbCommand("UPDATE Articles SET ArticleText = @ArticleText WHERE ArticleID =@ArticleID", RDConn) cmd.Parameters.Add("@ArticleText", cmd).Value = ArticleText cmd.Parameters.Add("@ArticleID", cmd).Value = articleid da.UpdateCommand = cmd da.Fill(ds, "Articles") End Function And in the page w/ the textbox Dim Dal As New DataLayer.AccessDataLayer Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dal.ShowArticleText(Request.QueryString("ArticleID"), TextBox1.Text) End Sub Sub BindData() Dal.ShowArticleText(Request.QueryString("ArticleID"), TextBox1.Text) End Sub Private Sub LinkButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton1.Click If IsValid Then Dal.UpdateComment(TextBox1.Text, Request.QueryString("articleid")) End If BindData() End Sub Tag: Dump DataTable to text Tag: 77510
  - 20
    - Finding a row by ID - data view is not sorted by ID Hi, I have a bit of an issue that I don't know how to deal with. I have a dataview connected to a datagrid. I don't know exactly how the dataview might be sorted at any point in time, as the user can click on the grid headers to change the sort order. Regardless of how the grid/dataview is sorted, I have a routine that I call, which adds a row to the underlying table, using MyTable.NewRow(), MyTable.AddRow(), etc. The row shows up in the grid in the correct order, but I want to set focus to the newly added row. I know the ID (primary key) of the row just added, but the grid might be sorted by name, city, state, etc. What's the best way to find the index of the newly added item in the dataview/grid regardless of sort order, so I can set it as the current row? Thanks in advance for any help you can provide... -Eric Tag: Dump DataTable to text Tag: 77506
  - 21
    - Component class based DAL Hi I am into implementing my DALs using component based classes due to the drag drop capability. However, can I do the following with component based DALs; 1. Share a common dataconnection between datadapters in different component DALs? I have separate DALs for suppliers & clients but I want to share the same db connection? Or, should I make a single DAL for both clients & suppliers? 2. Filter a dataadpter result on any given value? For example can I filter client's by current or prospects? Users would like to switch between the two from time to time. 3. Sort a dataadapter result in any given order say by company id or company name? Thanks Regards Tag: Dump DataTable to text Tag: 77504
  - 22
    - ANN: MSDE 2000 Deployment Toolkit (RC) available It's a FAQ how to deploy MSDE 2002 with a .NET setup package. The Microsoft SQL Server 2000 Desktop Engine Deployment Toolkit will make deploying the MSDE 2000 DE using VS.NET 2003 easier. Currently, there is a release candidate version available for download: <http://www.microsoft.com/downloads/details.aspx?familyid=6e9a7403-c4ba-4d98 -bb0b-2c9d6414071f&displaylang=en> <quote> The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Deployment Toolkit (release candidate) is a plug-in to Microsoft Visual Studio that automates the process of creating an integrated package with both the application and the MSDE database. </quote> -- Herfried K. Wagner [MVP] <http://www.mvps.org/dotnet> Tag: Dump DataTable to text Tag: 77499
  - 23
    - DataRowCollection RemoveAt doesn't work in certain circumstances Hi all, I am using the following code to remove rows from a table. Only rows which match a certain value are removed. The code works in one form very reliable and fails in another. The only difference between the two usages seems to be, that in the one Form a typed dataset is used and an untyped one in the other. DataTable tab = ds.Tables[ tabName ]; DataColumn col = tab.Columns[ colName ]; DataRowCollection rc = tab.Rows; for( int idx = 0; idx < rc.Count; idx++ ) { DataRow row = rc[ idx ]; if( row.RowState == DataRowState.Deleted ) { if( row[ col, DataRowVersion.Original ].ToString() == id ) { rc.RemoveAt( idx ); idx--; } } else { if( row[ col ].ToString() == id ) { rc.RemoveAt( idx ); idx--; } } } The failure appears in the first RemoveAt statement: The row is just not removed. No exception is thrown, nothing happens, but the row just stays there. The code, as shown above, then produces an endless loop. As said above, in another Form this code works. Karl Tag: Dump DataTable to text Tag: 77498
  - 24
    - SELECT DISTINCT Hi, I'm using an oledb adapter to connect to Access. I need to select three columns from a database and load them to a dataset: Name, Number, and Category. Name and Number are unique for each record, but many records can have the same Category. But I want to do a SELECT DISTINCT for only the Name, but get the Number and Category as well. I first had only the first two columns, and this worked fine: SELECT DISTINCT Name, Number FROM DatabaseTable ORDER BY Name This works because the Name and Number are unique for each record. But now I have added Category to the table; how do I add it to the selection query? SELECT DISTINCT Name, Number, Category FROM DatabaseTable ORDER BY Name brings an error. Thanks for your help. Nathan Tag: Dump DataTable to text Tag: 77497
  - 25
    - how to save from textbox anyone know how to save record that is encoded from a textbox back to sql server 2000? i know how to display a record from sql server to textbox but don't know how to save the changes i made. thanks in advance Tag: Dump DataTable to text Tag: 77491

How can I dump my datatable to a comma delimited (or tab delimited) text file in VB.NET?

I was thinking I could simply call an (external) SQL 2000 DTS package, but since I have the data in the Datatable, it would be a waste to requery.

Div

Top

Re: Dump DataTable to text by Miha

Miha
Wed Jan 21 03:22:14 CST 2004

Hi Diva,

You might consider a simple loop through all rows and write directly to
file..

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

"Diva" <anonymous@discussions.microsoft.com> wrote in message
news:2AECAED7-884E-492F-A463-3DD589EC62FD@microsoft.com...
> How can I dump my datatable to a comma delimited (or tab delimited) text
file in VB.NET?
>
> I was thinking I could simply call an (external) SQL 2000 DTS package, but
since I have the data in the Datatable, it would be a waste to requery.
>
> Diva
>

Top