Add array of rows to datatable

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
    - SQL Concatenation (||), Query builder in VS 2005 Hi, I need concatenate values of two fields in select command, but if I use this select command in Query builder in VS I get error. I concatenate two string values using SQL concatenation operator (||). It's a bug in Query builder? I think.... Tag: Add array of rows to datatable Tag: 136560
  - 2
    - ExecuteXMLReader I have a Sql2000 Stored Proc. that returns the result in the form of XML. I am calling this SP in my .NET application(webservice) using ADO.net. Can you please suggest me if I should be using the ExecuteReader or ExecureXMLreader method? Also, what are the advantages of using ExecureXMLreader over ExecuteReader In my .NET application, I need to populate the xml returned by SQL SP in a XML document. Thanks. Rajiv Tag: Add array of rows to datatable Tag: 136559
  - 3
    - Firebird Upper function VS.NET 2005 - Firebird 1.5.3 - Firebird.Net data provider I'm trying to add a fill commandText like this to an FBDataTable in the database designer. Select <field list> from CONTACTS where ("UPPER"(NAME) like @Name) The database designer put the quotes around "Upper", not me. And I get this error: ________________________________________ Failed to update CommandText: The schema of data returned by your new command could not be retrieved. Schema of table "CONTACTS" was not changed and might not reflect data retrieved by your command. The database returned the following error: Dynamic SQL Error SQL error code = -804 Function unknown UPPER Can I use "Upper" in the form designer or is there some other way? Rick Tag: Add array of rows to datatable Tag: 136539
  - 4
    - There is no Original data to access when updating a DataTable with computed columns Hi all, this was driving me crazy! I've a datatable its related sqlDataAdapter, if I call the .Update method of the adapter everything is ok, but if I add a compute column to the DataTable (a columns computed via a DataRelation) I receive the "There is no Original data to access" Tag: Add array of rows to datatable Tag: 136536
  - 5
    - How to Insert the date function in asp.net to sql serevr i have 3 dropdown lists.from this dropdown list to { }{day[first dropdown list],month[second dropdown list],year [third dropdown list]. how insert the day,month,year to sql server databse EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: Add array of rows to datatable Tag: 136531
  - 6
    - DataTable. Foreign key does not works. Hello to all. I have simple form with DataGrid binded to DataTable. DataTable has foreign key to itself. When I'm deleting one row it's child rows stay in Table. (It deletes only parent row, not child). Here is code: DataTable TestTable = new DataTable("Test"); TestTable.Columns.Add("ID", typeof(Int32)); TestTable.Columns.Add("ParentID", typeof(Int32)); TestTable.Constraints.Add("PARENT_TO_ID", TestTable.Columns["ID"], TestTable.Columns["ParentID"]); DataRow TestRow = TestTable.NewRow(); TestRow["ID"] = 1; TestRow["ParentID"] = DBNull.Value; TestTable.Rows.Add(TestRow); TestRow = TestTable.NewRow(); TestRow["ID"] = 2; TestRow["ParentID"] = 1; TestTable.Rows.Add(TestRow); dataGrid1.DataSource = TestTable; Is it DataTable bug? Thanks in advance! Tag: Add array of rows to datatable Tag: 136530
  - 7
    - best practice for data display VS 2005 designing a WinForm. I have a typical CUSTOMER, ORDERS, ORDERDETAIL database. I want to show these related items on a winform with either textboxes or datagridview controls. If I use the dataset designer to create a strongly-typed DS it will bring into memory ALL the records in each table and then select a subset according to the relations I have set when the user selects a CUSTOMER. Of course, this is completely impractical when you have any quantity of rows in any of the tables since they cannot all be brought into memory. All the examples I see use the above approach for demonstration, but this doesn't seem practical in a real world app. So how do I do this right from the beginning? Do I create queries with a param for the relation between the parent and child table and then respond to a row change event? I'm confused since I don't see any demo apps that use this senario which surely must be quite common. Thanks for any guidance, Rick Tag: Add array of rows to datatable Tag: 136529
  - 8
    - RowChanged event fires after that the current cell is changed Hi all, I've a DataGrid wich DataSource is a DataTable declared with the "WithEvents" clause, I've write some code to handle the RowChanged event. My DataGrid has a boolean column (wich not allows null value) and a TextBox column with some decimal values, I wish that when a user checks the boolean column a TextBox in the form will display the computed sum of the rows "checked". But I have noticed that the RowChanged event fires when I change a row (doh!) but only after I've changed the current cell or after the grid has lost the focus. I want that when I check or uncheck a row, the textbox displayng the computed sum suddenly changes, is there a way to accomplish this? Tag: Add array of rows to datatable Tag: 136527
  - 9
    - MI5 Persecution: what people said (3927) From: aa1gha@zen.sunderland.ac.uk (gillian.hardy) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Date: Mon May 13 21:27:26 1996 : In article <Dr5sDI.50x.0.bloor@torfree.net>, bu765@torfree.net wrote: : |> This site is now running brilliantly. It will be updated with new : |> information regarding this case and is well worth including in your : |> bookmark file. For my sins I had a look and it's quite good actually. Nicely set out and presented. Didn't read it though, having read the rants a million times before. By the way, anyone noticed Chris Tarrant looking at you funny during Man O Man yet? Thought not... Gillian ------------------------------- From: franco@elea.demon.co.uk (Francis Devonshire) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Reply-To: franco@elea.demon.co.uk Date: Tue May 14 19:17:26 1996 In message <4na2d0$dho@leofric.coventry.ac.uk> Stephen Hopkins wrote: :Yes, I have to be honest: that page is one of the best examples of how to :present a long document on the Web that I've seen. Hopefully, frames will :become more and more prevalent and this style of presentation will become :the norm for long documents such as that. My html thingy doesnt seem to do frames so all I got was a blank page. Then again, maybe someone, somewhere doesn't want me to read it. BTW does 'troll' bring to mind a fishing lure (ie you are American), or an ogre type thing (ie you are European). I much prefer the image of the latter. +--------------------------------------------------------------------------+ | Francis Devonshire Titchfield, Hampshire, United Kingdom | +--------------------------------------------------------------------------+ ------------------------------- Newsgroups: uk.misc,uk.legal,uk.politics.misc,soc.culture.british From: duncan@yc.estec.esa.nl (Duncan Gibson) Subject: Re: MI5 Persecution: Bugging Date: Wed Jun 12 06:46:41 1996 Mike Corley <bu765@torfree.net> wrote: > Read about the MI5 Persecution on the Web Now, whatever you might think about the content, this is a very well designed and presented web page (if you use Netscape to look at it anyway - Mosaic couldn't handle it). This is my article, not my employer's, with my opinions and my disclaimer! -- Duncan Gibson, ESTEC/YCV, Postbus 299, 2200AG Noordwijk, The Netherlands Tel: +31 71 5654013 Fax: +31 71 5656142 Email: duncan@yc.estec.esa.nl 3927 -- Posted via a free Usenet account from http://www.teranews.com Tag: Add array of rows to datatable Tag: 136523
  - 10
    - MI5 Persecution: £20,000 Reward (3057) 20,000 Reward Offered to Expose the Conspiracy I am making a pledge for information directly leading to the exposing of the "BBC Newscaster Conspiracy". The exposing would specifically need to lead to a legally binding admission from Martyn Lewis or Michael Buerk of the BBC they they were watching me through the TV set. I would be happy (delighted, in fact) to pay GBP 20,000 sterling in reward for the above admission. -------------------------------------------------------------------------------- 3057 -- Posted via a free Usenet account from http://www.teranews.com Tag: Add array of rows to datatable Tag: 136522
  - 11
    - dataset fill brings all records? VS 2005 pro. I have a strongly typed dataset which I generate using the designer. From the xsd file I set the relations between the CONTACTS table to the ORDERS table to the ORDERITEMS table. Then I put some DataGridViews on the form and open. In the Load event of the form the Fill methods are used in the three tables. As I step through by line, I can see the CONTACTS (1500 rows) is pretty quick and the ORDERS (55,000 rows) is slower but the ORDERITEMS (5 million + rows) churns on and on until I run out of memory. If I leave out the ORDERITEMS datagridview, the form opens and the parent-child relations are good. It seems like the Fill method is taking ALL the rows from the DB and only displaying the subset I want based on CONTACT. I would have thought that it would only "hit" the DB when it had a record in the CONTACTS table as a parent. Do I have to setup my relations with a parameter to not retreive all rows from the DB, or is this what is happening? Rick Tag: Add array of rows to datatable Tag: 136519
  - 12
    - Paging controls won't show up when using FormView I have a very simple FormView control, but when I view the page it does not show the Paging controls, although it does show the data. Here is my code: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="FormViewTest.aspx.vb" Inherits="family.FormViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> </head> <body> <form id="form1" runat="server"> <asp:FormView ID="fviewTesting" runat="server" AllowPaging="true" PagerSettings-Visible="true"> <rowstyle HorizontalAlign="Center"/> <ItemTemplate> <asp:Image ID="imgPhoto" runat="server" BorderWidth="0px" ImageAlign="Middle" ImageUrl='<%# DataBinder.Eval(Container,"DataItem.filename","images/photoalbum/{0}") %>'/><br/> <asp:Label ID="lblPhotoCaption" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.caption") %>'/><br/> <asp:Label ID="lblPhotoDate" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.photodate","Photo taken on: {0:D}") %>'/> </ItemTemplate> </asp:FormView> </form> </body> </html> Partial Public Class FormViewTest : Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim photoalbum As New DataTable Dim dataadapterSelect As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM babyphotos ORDER BY photodate,filename", System.Configuration.ConfigurationManager.AppSettings("connectionstring")) dataadapterSelect.Fill(photoalbum) Me.fviewTesting.DataSource = photoalbum Me.fviewTesting.DataBind() End Sub Private Sub fviewTesting_PageIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles fviewTesting.PageIndexChanged Dim currfile As String = CType(Me.fviewTesting.DataItem, DataRowView)("filename").ToString() Dim photo As System.Drawing.Image = System.Drawing.Image.FromFile(MapPath("images/photoalbum/" & currfile)) CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Width = photo.Width CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Height = photo.Height CType(Me.fviewTesting.FindControl("lblPhotoDate"), Label).Text = CDate(CType(Me.fviewTesting.DataItem, DataRowView)("photodate")).ToLongDateString() End Sub End Class What am I doing wrong? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Add array of rows to datatable Tag: 136513
  - 13
    - More efficient way of getting this aggregate data? Hi all, Our database contains daily data going back for years, which I need aggregated into weekly averages. I came up with the code below to get it, but I don't like it - mostly because hitting the the database with a couple thousand queries feels wrong somehow. Is there a way to somehow send a "bulk query" to the DB through ado.net, and receive the response in a "bulk" package? (No need to tell me about parametrizing the query.) Thanks for any ideas, cdj ================ private void GetWeeklyAverages(DateTime theLastMonday) { DateTime currMon = theLastMonday; DateTime currFri = currMon.AddDays(4); int i=0; int numZeroAvgsInARow = 0; while (i<2000 && numZeroAvgsInARow<10) { string strConn = "user id=ID;password=PASSWORD;data source=SOURCE"; OracleConnection dc_UAT = new OracleConnection(strConn); string avg = "0"; try { dc_UAT.Open(); string oracleTable = "TABLE"; string oracleSelectString = "select round(avg(DATA),5) from " + oracleTable + //variable " where indexid='" + "1" + //variable "' and as_of_date between '" + currMon.ToString("dd-MMM-yyyy") + "' and '" + currFri.ToString("dd-MMM-yyyy") + "'"; OracleCommand cmd = new OracleCommand(oracleSelectString, dc_UAT); avg = cmd.ExecuteScalar().ToString(); } catch(Exception ex) { MessageBox.Show(i.ToString() + ": " + ex.Message, "Error getting average"); } finally { if (dc_UAT != null) { dc_UAT.Close(); } } //Print out info txt_Output.Text += i.ToString() + ": " + currMon.ToString("MM/dd/yy") + " -" + currFri.ToString("MM/dd/yy") + "\t\t" + avg + Environment.NewLine; //Next week back currMon = currMon.AddDays(-7); currFri = currMon.AddDays(4); //Take care of loop vars if (avg == "0") { numZeroAvgsInARow++; } else { numZeroAvgsInARow = 0; } i++; } Tag: Add array of rows to datatable Tag: 136511
  - 14
    - Reading catalog of IBM DB2 hi all, i have a problem with returning all tables included in IBM DB2 database. i'm using OleDbConnection to connect to IBM DB2, aRds As DataTable = CType(aConn, OleDbConnection).GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing) this line returns datatable with no rows, but it's schema is right, and the connection string is right. plz, i need ur help very quickly.. thanx in advance.. Ola Tag: Add array of rows to datatable Tag: 136507
  - 15
    - setup master-detail tables VS.NET 2005 I'm not having an intuative experience trying to get the hang of how to setup a strongly typed master/detail relationshipe between tables. I have two tables CONTACTS with PK=IDNUM and ORDERS with a field CUSTNUM. Both tables have CommandStrings like "Select <field list> from TableName..." (neither has a where clause) In the visual designer for the xsd file I have set a relationship between CONTACTS->IDNUM and ORDERS->CUSTNUM. In a Windows form I have two DataGridView controls, one for each table. When I run the program, the Orders table never follows the Contact table when it scrolls. To me, setting the data relation should have resulted in the child table filtering its results based on the parent, but obviously not. What else do I need to do to get the child table to really be a child? Rick Tag: Add array of rows to datatable Tag: 136506
  - 16
    - Gridview deletion problem I created a form, a datasource (Product table from AdventureWorks) from the Data Sources tab, and dragged the Product table from the Data Source tab to the form's designer surface. This created a dataset, bindingsource, tableadapter and bindingnavigator. I placed the following code in the click event of the delete button on the bindingnavigator: Me.Validate() Me.ProductBindingSource.EndEdit() Me.ProductTableAdapter.Update(Me.AdventureWorksDataSet.Product) When running the app, I select a row and click the delete button on the navigator. It disappears. However, when I exit the app and re-enter, the row is still there. As another test, if I select the row again, and click the delete button, and click it once more, the row is actually deleted from the database. In debug I place a stop after the Validate method above. The underlying dataset shows false for HasChanges after the first click of the delete button and the selected row shows Unchanged for its RowState. However, after the 2nd click of the delete button, the dataset shows true for HasChanges and Deleted for the RowState associated with the row. What is wrong with my code? Thanks Tag: Add array of rows to datatable Tag: 136505
  - 17
    - UpdateRowSource.FirstReturnedRecord not working on .Net 2.0 using System.Data.OracleClient I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work correctly using the OracleClient. It works correctly on 1.1 and the DataSet is updated correctly after a DataAdapter.Update, but although the insert happens to the database on 2.0, the DataSet is not updated. The InsertCommand is a PL/SQL stored procedure as follows PROCEDURE insert_orders ( p_b IN INTEGER, p_c IN VARCHAR, p_d IN NUMBER, p_e IN INTEGER, p_f IN INTEGER, p_g IN VARCHAR, p_h IN INTEGER, p_i IN VARCHAR, p_results OUT REF CURSOR) AS v_currentValue NUMBER; BEGIN -- Insert a row to orders table INSERT INTO orders ( b, c, d, e, f, g, h, i) VALUES ( p_b, p_c, p_d, p_e, p_f, p_g, p_h, p_i); -- Get the order_id of the inserted row using the sequence SELECT seq_id.currval INTO v_currentValue FROM dual; -- Get the inserted row as output OPEN p_results FOR SELECT id, b, c, d, e, f, g, h, i FROM orders WHERE id = v_currentValue; END insert_orders; The value of Id is populated during a Pre-Insert Trigger from an Oracle Sequence. Has anyone else encountered this problem? Many thanks Richard Tag: Add array of rows to datatable Tag: 136503
  - 18
    - Insert Command My data adapter will not create the INSERT Statement. It creates the Select, Update, Delete and table mappings though. Why is this? Tag: Add array of rows to datatable Tag: 136493
  - 19
    - DataRowVersion.Original and RowState quesions. I'm fairly new to ado.net, using SQL Server stored procedures, asp.net, and all that entails, so I'm sure I'm missing something simple and fundamental. Hopefully you can point it out to me. Ultimately the problem is I am getting an error: "There is no Original data to access." when trying to execute the following line: if (drCur["Contact", DataRowVersion.Original].ToString() != "") this.sqldaAddSite.UpdateCommand.Parameters["@Original_Contact"].Value = drCur["Contact", DataRowVersion.Original].ToString(); You ask a lot of questions as to why I'm doing this in the first place that I'm not sure I can answer and I'm sure down the road I'll find better methods. Still... The webform that is having this problem is almost identical in logic to one that works just fine. One difference I have noticed is that when I execute these 3 lines: this.sqldaAddSite.SelectCommand.Parameters["@SiteID"].Value = (string) Session["SiteID"]; this.sqldaAddSite.Fill(this.dsAddSite1); drCur = this.dsAddSite1.scs_GetSiteUpdate.Rows[0]; The rowstate of drCur is "Added" while on the webform that works it's "Unchanged". Both are using store procedures for select commands. Can anybody give me clues as to what's going on and what to do about it? Tag: Add array of rows to datatable Tag: 136487
  - 20
    - 29 Books and Tutorials for DotNET, C#, VB.NET and ASP.NET Hi here is a list of 29 Books and Tutorials for DotNET, C#, VB.NET and ASP.NET. Download fast at http://free-tech-ebooks.blogspot.com/ Tag: Add array of rows to datatable Tag: 136485
  - 21
    - Error trying to use Oracle Procedure Hello All I'm trying to use the DBMS_DATAPUMP.OPEN procedure but it keeps failing with this message: 1) Exception Information ********************************************* Exception Type: Oracle.DataAccess.Types.OracleNullValueException Message: Invalid operation on null data Number: -2502 Source: Oracle Data Provider for .NET Data: System.Collections.ListDictionaryInternal TargetSite: Int32 get_Length() HelpLink: NULL StackTrace Information ********************************************* at Oracle.DataAccess.Types.OracleString.get_Length() at Oracle.DataAccess.Client.OracleParameter.GetBindingSize_Char(Int32 idx) at Oracle.DataAccess.Client.OracleParameter.PreBind_Char() at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, IntPtr errCtx, Int32 arraySize) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at DAO.OracleConcreteFactory.ExecuteNonQuery(DAORequest request) in F:\Sunit\CSharpFiles\Scripts\DAO The procedure signature as per Oracle docs is: DBMS_DATAPUMP.OPEN ( operation IN VARCHAR2, mode IN VARCHAR2, remote_link IN VARCHAR2 DEFAULT NULL, job_name IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE' compression IN NUMBER DEFAULT KU$_COMPRESS_METADATA) RETURN NUMBER; In code I do this: _conRequest.Command = "DBMS_DATAPUMP.OPEN"; _conRequest.CommandType = CommandType.StoredProcedure; _conRequest.AddParameter("operation",OracleDbType.Varchar2, "EXPORT", ParameterDirection.Input); _conRequest.AddParameter("mode", OracleDbType.Varchar2, "SCHEMA", ParameterDirection.Input); _conRequest.AddParameter("remote_link", OracleDbType.Varchar2, OracleString.Null, ParameterDirection.Input); _conRequest.AddParameter("job_name", OracleDbType.Varchar2, "EXP_TEST", ParameterDirection.Input); _conRequest.AddParameter("version", OracleDbType.Varchar2, "LATEST", ParameterDirection.Input); _conRequest.AddParameter("jobhandle", DBDataType.DBInteger, null, ParameterDirection.ReturnValue); I think it fails when trying to evaluate the remote_link parameter. Any hints are greatly appreciated. Sunit Tag: Add array of rows to datatable Tag: 136469
  - 22
    - OleDbException.ErrorCode lookup The OleDbException.ErrorCode is supposed to be an HRESULT. What scope of errors this HRESULT maps to. I tried: catch (OleDbException ex) { string test = ex.Errors[ex.ErrorCode].Message; } However, ErrorCode is a negative int and the indexer expects an unsigned int, and HRESULTS shouldn't be negative(using the Convert namespace for ToUint32 gives me an exception on trying to convert errorcode). I am getting an error which indicate an object not found, and the named object is a table name referred to in a query. So I'm thinking that this error code applies to all cases where a table does not exist, or it might be broader and apply to other types of failures. In order to make my error message specialized for the error code, I'd like to identify what scenarios it may apply to. My hope was the Errors[errorCode].Message would give me a better idea of the scope of the ErrorCode. So what do I need to do to find out what scenarios would produce this ErrorCode. If I craft an informative error message to display to the user, right now it would read as "Table " + tablename + " does not exist in the database." but if I do this based on errorCode, then I'm afraid the errorCode may be produced in other situations where the error message is not necessarily true. So what would be a good process for manually looking up these error codes? I have the Error lookup utility from VS6 but it doesn't like the negative int values. This particular one is -2147217865 but I would really like to have a process for doing this in the future. I haven't worked much with HRESULTS in previous languages either, so take it easy on me if I sound ignorant. Thank in advance. Tag: Add array of rows to datatable Tag: 136467
  - 23
    - ADO.net Orcas Samples Install Problem I installed the August CTP, after the LINQ Preview. Everything installs correctly. I opened the solution in VS2005 and built it, everything compiled. I mapped a virtual directory to the installation folder of the webapp sample (on my machine - 'C:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample') The first time I try to access the sample it takes a long time, then errors out to this : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Source Error: Line 78: using(var con = new System.Data.SqlClient.SqlConnection(sqlb.ConnectionString)) { Line 79: try { Line 80: con.Open(); Line 81: } Line 82: catch(System.Data.SqlClient.SqlException ex) { Source File: c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax Line: 80 Stack Trace: [SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +173 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +345 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +159 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +406 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +184 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +49 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 ASP.global_asax.InitSample() in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:80 [Exception: Failed to open an initial database connection. This initial connection is used to attach the sample database to the SQL Server instance if it's being used for the first time. There are two common reasons for this: 1) you do not have a SQL Server default instance (e.g. you're running SQL Server Express or you installed a named instance). To fix this simply update the server name in the connection string (in the web.config file). 2) If you're using SQL Server Express, by default the service runs under the NETWORK SERVICE account which doesn't have permissions to write to the Program Files directory. That might be the cause of this error. To fix the issue, open Windows Explorer, go to the '\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\Data' directory and add NETWORK SERVICE with read-write permissions to it. Actual error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] ASP.global_asax.InitSample() in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:105 ASP.global_asax.Application_Start(Object sender, EventArgs e) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:12 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 Upon page refresh the error message changes to this : Value cannot be null. Parameter name: connectionString 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.ArgumentNullException: Value cannot be null. Parameter name: connectionString Source Error: Line 32: /// Initialize a new Northwind object. Line 33: /// </summary> Line 34: public Northwind(string connectionString) : Line 35: base(connectionString, "NorthwindLib.Northwind") Line 36: { Source File: c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\NorthwindLib\obj\Debug\NorthwindLib.Model.cs Line: 34 Stack Trace: [ArgumentNullException: Value cannot be null. Parameter name: connectionString] System.Data.ADP.CheckArgumentNull(T value, String parameterName) +23 System.Data.Objects.ObjectContext.CreateMapConnection(String connectionString, String defaultContainerName) +39 System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) +16 NorthwindLib.Northwind..ctor(String connectionString) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\NorthwindLib\obj\Debug\NorthwindLib.Model.cs:34 Products.Page_Load(Object sender, EventArgs e) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Products.aspx.cs:24 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 It seems the problem is that the connection string isn't being set at all, judging by the second error mentioning it is null. I have SQL server express, do I need to attach the northwind DB to use it, or am I better off with a full SQL Server install. If the latter, do I need to do anything special on install or config to get the Northwind DB from the samples to work? Thanks for the help, looking very forward to playing with the samples. Tag: Add array of rows to datatable Tag: 136466
  - 24
    - Reading a single field from table Hi I need to run a simple select query like below; select field1 from mytable where id = 123 and assign the returned value of field1 to a variable. What is an easy way to do this? Thanks Regards Tag: Add array of rows to datatable Tag: 136459
  - 25
    - Fill-Method changing DBNULL-values to other values Hi, i am writing a small interface to import some data from one database to an other database. unfortunately is the data in the source not very "nice". you have boolean-columns and those boolean-columns have as a default value DBNULL. it wouldn't be a problem if there was one boolean field, i would have a if (table.iscolumnNull()) but i have about 70 boolean fields and only ONE is true all others are false. that means i have many of those ifs already if (table.column1) { } else if (table.column2) the problem is, i don't want to have a structure like this: if (table.column1IsNull()) { if (table.column1){} } else if (table.column2IsNull()) .... I hope you can see where I am going. So I think there must be a possibility to change the DBNULL-values within the fill-method of the table-adapter. something like select case when column1=null then column1=false else column1 endcase from foreigntable i have tried to write such a statement but it didn't work out. If somebody had some hint, that'll be great! Greetings Chris Tag: Add array of rows to datatable Tag: 136456
- Next
  - 1
    - Creating Multi-directory Sites Using Multiple Projects In A Solution I have a Visual Studio Solution that contains multiple ASP.NET Projects. I do not want to put all of the pages (*.aspx files) in the root directory of my site, because that would be very disorganized. However, I am having trouble getting any projects other than the one that I place in the root directory to work. What extra steps do I need to take to place a project in a directory other than the root? I am using a webhosting service (hostway.com), so if there are any changes that need to be made on the server I need to know exactly what they are so that I can either request them for my site or make them by logging into my account. If anyone can help me with this or knows of a website that gives good instructions on doing this, I would appreciate it. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Add array of rows to datatable Tag: 136453
  - 2
    - Creating a new dataprovider I'm fairly new to ADO.NET, I've written a couple client/server applications that use the factory pattern in ADO.NET to work with MSSQL and Oracle databases. Beyond that I'm fairly green. My quest is to create a new community opensource project that consists of an ADO.NET dataprovider to communicate with Windows Installer ( .MSI ) databases. Currently you have to P/Invoke to the MSI SDK API's for opening databases, creating fiews, fecting records, accessing records and so on and so on. I'd like to create a framework class that I can share that is very ADO.NET friendly ( as much as applies to the limitd abilities of an MSI database package ). My goal is to create a framework for creating MSI applications/utilities/tools much easier to design and develop. Can anyone reccomend some good reading on how to go about this? I'm guessing that there are a bunch of interfaces to derive from and implement but I thought I'd ask for a point in the right direction instead of spending alot of time in the sand traps. Thanks, Chris Tag: Add array of rows to datatable Tag: 136444
  - 3
    - Timeout problem with SS2K, VS03 I'm working with SS2000 on Server2003, Visual Studio 03 on XP and getting a timeout issue that I cannot identify the source of. The specific message is "General error getting subscriptions" (or other table) "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." There's quite a bit of code so rather than try to post the whole lot I'm going to try to describe it, basically when this happens there's multiple classes and forms running (basically it's a form editing a related entity from a main form, each with multiple classes). After editing data in the subclass, the code saves to the database within a transaction, the transaction is committed and the connection is closed cleanly and all appears to be well. Occasionally, however, after editing and saving from the subform I get the above message and once that happens, I cannot seem to connect to the database until I close that copy of the application. What I've tried to figure out so far; initially I believed the error message that the pool max size was reached. This does not appear to be true; the timeout only effects this instance of the application, I can connect with other applications or other instances of the same application with no problem. So unless the pool is something within the scope of the application, the message is incorrect. When I look at sp_who2 for blocking, none shows. When I trace my calls to the server with sql profiler, the queries never reach the server, which (I believe) indicates that it's a problem with the application rather than a server setting. It's almost as if the connection string stops working but we get that from app.config so I don't see how it could change from one call to the next. Similarly, waiting a few minutes and trying the same search again from the application makes no difference. Because the 'timeout' appears indefinite, rather than just a long running query, I don't believe tweaking timout settings will help. The queries take at most a few seconds when it's working, yet once I hit the exception not even the shortest query will run. I tried to reduce the number of connections used, and initially that seemed to help, but not eliminate the error. But the number I'm dealing with is ridiculously small, I pass the connection by reference to the subclasses so I went from using 3 total to using only 2. Searching the web I found that if I have SQL Debugging enabled that would cause the error, sure enough in this project I did have it enabled so I disabled it and thought that I had fixed the problem. But after a day or so the problem cropped up again, and SQL Debugging is still disabled. So everywhere I turn appears to be a blind alley; it's does not appear to be the connection pool, it's definitely not a long running query and it's not a connection or connections being left open that I can see. SQL Debugging is not enabled and I'm running out of places to look for the source of this problem. Has anyone else seen this type of timeout error? If not does anyone have any idea where I can look from here? Thanks for listening; David Craig ABC-Clio. Tag: Add array of rows to datatable Tag: 136443
  - 4
    - Webmethod to save data to SQLServer I have a Webservice written in C# that provides data to both a web browser through ASP.net and to a VC++ client. I have been able to retrieve data from SQLServer and passing to my C++ client as XML without a problem using the SqlDataAdaptor and the DataSet. I am a bit confused how to save data to SQL Server from my client. I figured if I could create a DataSet, I could save it to the database. I wrote a WebMethod that takes a string (the XML) as input, reads that string using an XMLReader, then creates a DataSet from that reader. [WebMethod] public Boolean SaveStaff(string sStaffXML) { XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Fragment; settings.IgnoreWhitespace = true; settings.IgnoreComments = true; XmlReader reader = XmlReader.Create(sStaffXML, settings); // Create a new DataSet. DataSet staffDataSet = new DataSet("Staff DataSet"); // Read the XML document into the DataSet. staffDataSet.ReadXml(reader); // Close the XmlTextReader reader.Close(); SqlDataAdapter dataAdapter; SqlConnection conn; conn = new SqlConnection("Server =localhost;uid=stmUser;pwd=mypw;database=STMDB"); string cmdString = "SELECT * FROM Staff"; // NOT SURE IF I NEED THIS! dataAdapter = new SqlDataAdapter(cmdString, conn); dataAdapter.Update(staffDataSet); return true; } Is this the right approach? I also wasn't sure exactly how to build the XML string so that I can pass it into the DataReader and then let .NET do its magic. Do I need to use an XSD file? Can I just emulate the XML that .NET passes to the client when it calls a data retrieval method that returns XML with Staff records in it? Are there any good articles about how to do this. most of the stuff out there about using web services use examples of retrieving data, not saving it. Regards, -Rob Tag: Add array of rows to datatable Tag: 136440
  - 5
    - GridView timeout - how to raise it? I have GridView1 attached to a SqlDataSource1 (everything done automatically via VS2005). The problem occurs after launching the page because timeout is risen. The question is how to increase the timeout limit using properties of SqlDataSource1 or GridView1 objects? Best Regards Dariusz Tomon Tag: Add array of rows to datatable Tag: 136438
  - 6
    - TableAdapter.Update not working but no exception thrown Hi I can't figure this one out. I'm using TableAdapters quite successfully with the rest of my app but I have one where the insert just doesn't work when the TableAdapter.Update(TypedDataTable) is called. When I set the break point on the method I can see that it initializes the adapter in the DataSet.Designer.cs file. Can someone suggest how I can work out what's going wrong? I've recreated the table adapter in the xsd wizard page but it's always the same. No exception is thrown but the update method is definitely called and the insert stored procedure works too. The code is ScsDataSet.NotificationEmailsDataTable notifyTbl = new ScsDataSet.NotificationEmailsDataTable(); ScsDataSet.NotificationEmailsRow notifyRow = notifyTbl.NewNotificationEmailsRow(); // account.AccountID retrieved from another TA update notifyRow.AccountID = account.AccountID; notifyRow.CreateDate = DateTime.Now; notifyRow.ModifyDate = DateTime.Now; notifyRow.NotifyType = 0; notifyRow.Email = email.Trim(); notifyRow.IsLogin = true; // row is populated above ok NotificationEmailsTA.Update(notifyTbl); // notifyRow.EmailID == 0 and the record is not inserted if (notifyRow.EmailID == 0) throw new ApplicationException("NotificationEmailsTA not inserting"); Thanks Andrew Tag: Add array of rows to datatable Tag: 136433
  - 7
    - How to get field size from DataSet Hi, I dont know how to get the orginal DB column size from the dataset. Can anyone please show me the code for this? Many thanks Doug. Tag: Add array of rows to datatable Tag: 136426
  - 8
    - Which are valid options for System.Data.DataColumn.DataType? Hello all, I am a bit puzzled about the data type of the type of a System.Data.DataColumn in ADO.NET. When I try to Add a column to a data table, there are 5 overloads and one of them has the following hint: 2 of 5 Add(ColumnName As String, type As System.Type, expression As String) As System.Data.DataColumn type: The System.Data.DataColumn.DataType of the new column. Now I am confused and I am afraid I am missing a major OO concept. I would have hoped for a picklist to choose a System.Type from. Why is this not available? Also, where do I have to look to find out valid options? System.Type seems to be an abstract type. Could any type that inherits from System.Type be passed as the second parameter to Add. If not so, why does ADO.NET ask for a System.Type? Explanations would be appreciated. Tag: Add array of rows to datatable Tag: 136424
  - 9
    - Problem running query in code Hi I am using the below code to run a sql on an underlying access table; insStr = "INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) " & _ "VALUES (""Modify Client"", 93, ""Administrator"", Now())" Dim insCmd As New OleDbCommand(insStr, dbConContacts) insCmd.ExecuteNonQuery() I get a 'Syntax error in INSERT INTO statement.' error on the last line. But if I run the same query as below directly in access it works fine. INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) VALUES ("Modify Client", 93, "Administrator", Now()) What is the problem and how can I fix it? Thanks Regards Tag: Add array of rows to datatable Tag: 136414
  - 10
    - DataAdapter Fill Method Query Hi All, I have a SQL Server stored procedure that return the results of two select statements e.g. SELECT * FROM first_table SELECT * FROM second_table The first_table has lots and lots of rows, so I only want to return the first 100 from any start point. However, in the second table I want to return all rows. I have used a DataAdapter to fill a dataset, and implemented the overload that allows you supply a DataSet, Start Record, Max Records and Source Table. If I specify a start record and a maximum number of records, will this record criteria apply to the first SELECT, the last SELECT or BOTH? Landers Tag: Add array of rows to datatable Tag: 136413
  - 11
    - Dataset.Merge ..... Accepts changes I am trying to use Dataset.Merge BUT the new dataset has its state according to the source dataset. I would like that state in the new dataset is amended or added according to if it is amended or added in the new dataset!!! Evan Tag: Add array of rows to datatable Tag: 136411
  - 12
    - DefaultValue vs. NoNullAllowedException Hi, I defined in my Sql Server db a table with 2 int columns that don't allow null values + their default values are set to 0. I'm using a DataAdapter to read data, but it doesn't bring the default setting : using (SqlConnection conn = new SqlConnection("MyConnectionString")) { SqlDataAdapter adapter = new SqlDataAdapter("Select * from MyTable", conn); DataSet result = new DataSet(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; conn.Open(); adapter.Fill(result); conn.Close(); if (null != result && result.Tables.Count > 0) { DataRow dr = result.Tables[0].NewRow(); dr["Column1"] = 11; result.Tables[0].Rows.Add(dr); // <= NoNullAllowedException for Column2, even it has a DefaultValue defined } } I don't want to set manually in the code the AllowDbNull or DefaultValue properties. What am I doing wrong ? I can this sql statement without pbs : INSERT INTO [Test] ([Column1]) VALUES (11) Thanks for any advice Tag: Add array of rows to datatable Tag: 136404
  - 13
    - newbie really needs help with ado.net access [C# 05] Hi , Im a selftaught C# programmer. I have a hotel management project to do, and i'm stuck! In One of my classes, called data! =S , from my project i initilize vars like this: public Data(string databaseURL , string xmlURL) { con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseURL); resAdapter = new OleDbDataAdapter( "SELECT * FROM customers WHERE ? BETWEEN fromDate And to", con); resAdapter.SelectCommand.Parameters.Add("?", OleDbType.Date); resCmdBuilder = new OleDbCommandBuilder(resAdapter); myDataSet = new DataSet(); } So , now i have a unbound datagridview i need to fill , i have a fill() function in this same class which takes a dgv [Fill(DataGridView theDgv) ] and fills it based on myDataSet. The adapter loads like this : resAdapter.SelectCommand.Parameters[0].Value = theDay; Now: 1. The datatset has customers based on the top SQl statement , how do i load into it customers based on other values , or just ALL customers??! ("SELECT * FROM customers)?? load resAdapter again!?? 2. How do i MAKE a NEW table in an access database???(i know how to add and delete columns in a table) 3. I have to have a bills table with ALL BILLS , how do i link them to a customer (customers have a customerID) Thanks Gideon Tag: Add array of rows to datatable Tag: 136398
  - 14
    - vs2003 to vs2005 Hi I have a vb.net 2003 database winform app which uses non-bound controls and the associated plumbing is done in code. If I move it to vs 2005 would it work without any change? Thanks Regards Tag: Add array of rows to datatable Tag: 136387
  - 15
    - VS 2005 SP1 Hi I am almost finished with a vs 2005 (pre sp1) project which I need to deliver in the next couple of days. I am wondering if I should deliver project with sp1. Is it safe to install sp1 at this late stage? Thanks Regards Tag: Add array of rows to datatable Tag: 136383
  - 16
    - Review and contribute to my site Hi all I have set up a forum site..www.xcessdotnet.com. This is in initial state and I would like you people to contribute to it. Also I would like you to give suggestions on how can I improve it Thanks and Regards Chris Tag: Add array of rows to datatable Tag: 136382
  - 17
    - How to add a new row to typed datatable. I am using the datatable adapter of VS2005. How can I add a new row to a typed datatable? Tag: Add array of rows to datatable Tag: 136378
  - 18
    - Programmatically modifying the controls in FormView's PagerTemplate I am trying to create a FormView controls in which I access and modify the the controls in the PagerTemplate programmatically. However, I continue to recieve the following error: Object reference not set to an instance of an object. I am attempting to access the controls in my PagerTemplate using the following code: CType(Me.fviewPhotoAlbum.FindControl("lnkPhotoAlbum"), LinkButton) I have tried doing this from all the events that I could think of and that I noticed mentioned on any help sites I could find, but it didn't help. I don't know what I am doing wrong, if anyone could help me I would greatly appreciate it. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Add array of rows to datatable Tag: 136363
  - 19
    - Validating an XML file Hi there, I've created a strongly-typed "DataSet" using VS. If I save the data via "DataSet.WriteXml()" and later prompt my users for the name of the file in order to read it back in again (using "DataSet.ReadXml()"), how do I validate that the file they enter is valid. That is, while "DataSet.ReadXml()" throws a "System.Xml.XmlException" if they enter a non-XML file, a valid XML file results in no exception even though the schema may be completely incorrect (if they enter some random XML file on the system that is). Is there a clean way of detecting this situatiion. Thank you. Tag: Add array of rows to datatable Tag: 136359
  - 20
    - Does TableAdaper.Fill() call Connection.Close() internally? The Microsoft online help is full of TableAdapter examples like customersTableAdapter1.Fill(northwindDataSet1.Customers); I would expect the next line to be something like customersTableAdapter1.Connection.Close(); But I haven't seen that in the code samples, and VS doesn't generate it. Tag: Add array of rows to datatable Tag: 136357
  - 21
    - ReadRepeatable .Net v1.1 Can someone tell me if I have ReadRepeatable IsolationLevel right? Say I begin a transaction with ReadRepeatable. I select a row from table FRUIT. Another user tries to UPDATE the same row in table FRUIT... Are they blocked until I end the transaction? Or their update goes thru, but if I reselect inside the transaction I wont see their update? thx --- Posted via DotNetSlackers.com Tag: Add array of rows to datatable Tag: 136353
  - 22
    - =?UTF-8?B?VGVzdCBNZXNzYWdl?= from Indy This is a test message. Tag: Add array of rows to datatable Tag: 136351
  - 23
    - =?UTF-8?B?VGVzdCBNZXNzYWdl?= from Indy This is a test message. Tag: Add array of rows to datatable Tag: 136350
  - 24
    - know if a datatable is being schemafilles but not ever filles Hi all, in my program I initialize a lot of datatable (member of the same dataset) with the .FillSchema method of the adapter at the startup. After when a user trough the guy requests a such data, I populate the datatable with the .Fill method. If I have a such datatable (I'me sure it have been schemafilled) can I know if that table is have been filles with .Fill method? If the table has 0 rows is it because the sql table has 0 rows or because it hasn't been filled? Tag: Add array of rows to datatable Tag: 136331
  - 25
    - Copying from one db into another Hi I am trying to copy data from one db into another. Thanks for everyone who suggested ways to do that. After some more research I have come up with the below simple looking way. My question in, is it supposed to work this way and will it work? LocalConn.Open() Dim DBCommand As New System.Data.OleDb.OleDbCommand("SELECT id, name, date INTO (localtable) FROM remotetable IN [Data Source=<ip address>;Initial Catalog="RemoteDB";Persist Security Info=True;User ID="username";Password=password];", LocalConn) DBCommand.ExecuteNonQuery() LocalConn.Close() The remote db is a sql server. Many Thanks Regards Tag: Add array of rows to datatable Tag: 136325

Hi, I need to add array of rows to datatable. Have I use for cycle? Because
Datatable can add only one row into collection. Thanks.

Top

Re: Add array of rows to datatable by Cor

Cor
Sat Jan 20 08:45:28 CST 2007

Juri,

A datatable can not add any row in a collection.

A dataadapter or tableadapter fill can add as much rows in a datatable as
there is sufficient memory.

Cor

"Jirí Neuzil" <meuzil@seznam.cz> schreef in bericht
news:4F7E49B8-FF8E-43C1-9D38-BA57FC9EF1BD@microsoft.com...
> Hi, I need to add array of rows to datatable. Have I use for cycle?
> Because Datatable can add only one row into collection. Thanks.

Top

Re: Add array of rows to datatable by William

William
Sat Jan 20 12:54:32 CST 2007

Ah, if there is some way to expose a DataReader on an array, you could use
DataTable.Load...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jirí Neuzil" <meuzil@seznam.cz> wrote in message
news:4F7E49B8-FF8E-43C1-9D38-BA57FC9EF1BD@microsoft.com...
> Hi, I need to add array of rows to datatable. Have I use for cycle?
> Because Datatable can add only one row into collection. Thanks.

Top