Update/insert one table from another

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 SQL 2005 Configuration ??? Greetings, I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues with the help of some nice folks here. Now, I'm starting a clean Web site project but am having trouble right off again. I'm trying to create a new database using MS SQL Server 2005. I entered localhost as the Server name, selected Use Windows Authentication, and entered a new name for my database. When I click OK, I get the following error: Microsoft Visual Studio 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) As far as I know, localhost does not indicate a remote connection. I eventually connected to a database previously with SQL Express Edition, so I'm guessing this might have to do with my SQL configuration. I'm using Visual Studio 2005 on a new C#/ASP.NET project. I'm running Windows XP Professional w/SP2. Sorry, but virtually every suggestion I get will probably need to include instructions on how to do--I'm quite new to this. Any help greatly appreciated! -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Update/insert one table from another Tag: 136641
  - 2
    - Leftover Connections in Connection Pool (connection leak) This never happened before in .NET Framework 1.0 nor .NET Framework 1.1, but connection leak happens if you don't close the connection when you use SqlTransaction. I would like to share this information with the MS dev community. We had this issue of SQL Server performing very poorly while running our application. My colleague found out that connection leak was happening whenever the .NET code executed transactions. So I created a small console program that does a transaction like the following. Imports System.Data Imports System.Data.SqlClient Module Module1 Sub Main() Begin: Dim Conn As SqlConnection = GetConnection() Conn.Open() Dim Trans As SqlTransaction = Conn.BeginTransaction(IsolationLevel.ReadUncommitted) Dim Cmd As New SqlCommand("tblTest_ins", Trans.Connection, Trans) Cmd.CommandType = CommandType.StoredProcedure For i As Integer = 1 To 50 Console.WriteLine("Executing stored proc. (" & i.ToString() & ")") Dim parTestCol As New SqlParameter() With parTestCol .ParameterName = "@TestCol" .Direction = ParameterDirection.Input .SqlDbType = SqlDbType.NVarChar .Size = 50 .SqlValue = "TestValue " & DateTime.Now.ToString() End With Cmd.Parameters.Add(parTestCol) Cmd.ExecuteNonQuery() Cmd.Parameters.Clear() Next Trans.Commit() Console.WriteLine("Execution Completed") Dim Entry As ConsoleKeyInfo = Console.ReadKey() If Entry.Key = ConsoleKey.Y Then GoTo Begin Else Return End If End Sub Private Function GetConnection() As System.Data.SqlClient.SqlConnection Dim Conn As New SqlConnection("server=(local);database=Test;Pooling=true;user id=sa;password=whatever;Application Name=HelloConnPool;connection reset=true;") Return Conn End Function End Module I ran this code many times, and connection leak was happening. So I added Conn.Close() right after Trans.Commit(), then the leak was gone. Well, I could have done Trans.Connection.Close(), but the thing was that right after the transaction was committed, Connection property was null. So as we have a data layer that doesn't expose the underlying connection, we had to define a variable as SqlConnection and hold onto the reference to the connection from the transaction and the close it after commit. I hope I explained this issue well, but this never happened in .NET Framework 1.1. We converted our code from 1.1 to 2.0, and didn't change a thing, but this issue came out. I hope this will help people who experience the same kind of issue. If you have any question, please just post it here. Tag: Update/insert one table from another Tag: 136640
  - 3
    - Queries to an Access db from vs2005 Hello, I just have a form in which there's a textbox for queries. I need to use the SQL statements for an Access db, like this, which works fine in a SQL db: SELECT * FROM table WHERE name LIKE @name + '%' I just need to query the db to find names that start with letters I digit in the textbox. This query comes from dataset designer. If I use it in my Access db I get a syntax error from framework. Which is the Access equivalent? Thanks. Max Tag: Update/insert one table from another Tag: 136634
  - 4
    - Append Room numbers fields by Building Hello, I have a table as follows- BUILDING ROOM_NUMBER MAIN 100 MAIN 101 MAIN 102 SUB 200 SUB 202 The Resultset should be as follows- BUILDING SUMMARY_ROOMNUMBE MAIN 100,101,102 SUB 200,202 I know I need to use the group by clause but I dont know how to append the summary room number. Any help would be greatly appreaciated. Thanks. -jay Tag: Update/insert one table from another Tag: 136633
  - 5
    - Timeout error when inserting and reading from same table in sql server and .net Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=servername;Database=ProjectServer;UID=sa;pwd=pwd" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: Update/insert one table from another Tag: 136628
  - 6
    - Timeout when reading and updating / inserting to same table Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=jktgrhxsapps1;Database=ProjectServer;UID=sa;pwd=ProjectServer" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: Update/insert one table from another Tag: 136627
  - 7
    - DateTime Filter Expression Hi, is there anyway of selecting rows with a particular date but ignoring the time within a date time column? something like... DataTable.Select("DateTimeColumn".Date = '28/12/06') ? thanks in advance for any advice. Sharat Koya Tag: Update/insert one table from another Tag: 136617
  - 8
    - Adding new object to Typed Data Set and return the primary key Hi, I have started using Typed Data Sets with VS2005 and so far so good, however I am having a problem with adding a row to a data table and returning the new Primary Key value. My data set has been auto generated from a DB table and has an auto generated Primary Key for the ID field. I create the row using ProjectsDataTable.NewProjectsRow() However the code that returns this Project Row does not persist the data table as it is a method on my singleton object. Once the new row has been populated with data I call an update method on the singleton which then creates a new table adapter. My problem is how to add this orphaned row to the database and return the Primary Key that the database creates for it. I have tried many of the different methods that are created by default in the TypedDataSet however so far the only one that works is the TableAdapter.Insert() method and this does not return the primary key. Method 1: DataAdapter.Update(myProjectRow) // fails I guess because the row has no connected DataTable Method 2: newDataTable = DataAdapter.GetData(); // returns eg a data table containing 4 rows. newDataTable.ImportRow(myRow); // data table still contains 4 rows no error generated. DataAdapter.Update(newDataTable); // does nothing as there is nothing to update Please does anyone have any insight into this or do i have to go back to the good old way of manually executing the SQL or dumping my data singleton and manually creating and persisting the data table for the form that creates the new project ? Another strange thing is that the if i return a project from the singleton (which does not persist the data table) then call the same update method ( on the singleton which creates a new data adapter) the updates are commited. Is something strange with the primary key going on ? Sudo Code Snippet: public class DataObject { private static DataObject this_Data; public static DataObject getInstance() { if (this_Data == null) this_Data = new Data(); return this_Data; } public TypedDataObjectProject newProject() { Projects.ProjectsDataTable db_ProjectsTable; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_TableAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectsTable2 = db_TableAdapter.GetData(); return db_ProjectsTable2.NewProjectsRow(); } public TypedDataObjectProject getProject() { Projects.ProjectsRow db_Project; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectTable2 = db_ProjectAdapter.GetData(); db_ProjectAdapter.Dispose(); return db_ProjectTable2[0]; } public int updateProject(Projects.ProjectsRow Project) { int int_Return = 0; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); db_ProjectAdapter.Update(Project); db_ProjectAdapter.Dispose(); } } This works: ob_Prog = DataObject.getInstance().getProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); This Fails not with error but no new row is added: ob_Prog = DataObject.getInstance().newProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); Many thanks in advance for you help. Nic Tag: Update/insert one table from another Tag: 136616
  - 9
    - Why can't the .NET Datagrid show datetime columns with time ? Hi, I am using .NET Framework 1.1 and VS.NET 2003 I am pulling a recordset from an ORACLE database into a Windows Forms form and displaying the data in a datagrid.. Trouble is, even though the data includes datetime fields, the datagrid absolutely refuses to display them at runtime in proper datetime format (just shows . I know the time information is there because I can export to csv and the time is in each field. I even got some code from Kelly in another thread to force datetime fields to be formatted properly like this: >>> CODE >>> Public Shared Sub Format(ByRef grd As DataGrid, ByRef dt As DataTable) Dim ts As New DataGridTableStyle() Dim tc As DataGridTextBoxColumn Dim dc As DataColumn For Each dc In dt.Columns tc = New DataGridTextBoxColumn() tc.MappingName = dc.ColumnName tc.HeaderText = tc.MappingName If dc.DataType Is GetType(System.DateTime) Then tc.Format = "MM/dd/yyyy hh:mm:ss" tc.Width = 125 End If ts.GridColumnStyles.Add(tc) Next grd.TableStyles.Clear() grd.TableStyles.Add(ts) grd.DataSource = Nothing grd.DataSource = dt <<< END CODE <<< Now, when I run this, several fields are identified as system.datetime and these get the special format. But nothing happens in the datagrid. Is there anything else I can do to show the time with the dates? thanks for any help or assistance Philip Tag: Update/insert one table from another Tag: 136611
  - 10
    - MSAccess DB and DataSets - help Hi, I have VS.net 2005 express and I have created a new project. I made a new folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily went and created a DataSet class for me (MaintenanceDataSet). My question is: How do I load the data from the Access DB so I can access it from the application? Thank you in advance. Tag: Update/insert one table from another Tag: 136598
  - 11
    - Unicode and long data type I have an application where a limited amount of Unicode data is being inserted into a long data type field by an AIX program. I have written a dotnet program that copies the data from one domain to another with parameterized data. Everything works except for the Unicode data in the long field. My Characterset info is: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 Regional Settings are English (United States) A basic default U.S. installation of Windows. I do not have much control over the database. I have read that long data types do not support Unicode. Is there anyway I can insert Unicode data into a long data type from a dotnet program? Tag: Update/insert one table from another Tag: 136595
  - 12
    - dataset question Hi I am a newbie in ado.net 2005. Is it possible to do a Group By in a dataset? thanks E. Tag: Update/insert one table from another Tag: 136592
  - 13
    - Why can't I get the FormView control's Paging controls to show? I have tried everything I can think of, I have even tried copying examples from books and websites I have found, but every Formview control that I have tried to create does not show the Paging controls. The first record from the DataSource is displayed, but not the Paging controls. I have tried doing it with both automatically generated Paging controls as well as using the PagerTemplate, but neither one is displayed. What is the problem? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Update/insert one table from another Tag: 136591
  - 14
    - Reader ordinal problem Hi I am getting the System.IndexOutOfRangeException was unhandled error on the last line of below code; Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM [Update Control]", LocalConn) Reader = Cmd.ExecuteReader() Console.WriteLine("{0}", Reader.GetOrdinal("[Last Staff Update From Site]")) What is the problem and how can I fix it? Thanks Regards Tag: Update/insert one table from another Tag: 136588
  - 15
    - 36 Microsoft Certification Tutorials and Free Practice Exams 36 Microsoft Certification Tutorials and Free Practice Exams For complete Microsoft Certifications ebooks go to http://free-tech-ebooks.blogspot.com/search/label/Microsoft%20Certifications All the best !! Tag: Update/insert one table from another Tag: 136582
  - 16
    - Have alternative to CommandDataBuilder? I realize that Microsoft not intend to fix problems of Commandbuilder: +not deal with SQL calculated fields +not deal with Identity field to retrieve it and also cannot be inherit! there someone wrote Alternative? Tag: Update/insert one table from another Tag: 136577
  - 17
    - SqlCommand Parameters with SqlDbType and VarChar(MAX) If I have a field in MS SQL 2005 called "data" with type VarChar(MAX), how do I add a parameter using the syntax below if SqlDbType doesn't have a VarChar(MAX) type. If I use SqlDbType.VarChar will the value get truncated or is that what I should use? SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@data", SqlDbType.VarChar).Value = largeTextData; Or am I supposed to use the size parameter? cmd.Parameters.Add("@data", SqlDbType.VarChar, 1000000).Value = largeTextData; Also how many characters does VarChar(MAX) hold? Tag: Update/insert one table from another Tag: 136575
  - 18
    - Accessing sql server behind proxy Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks Regards Tag: Update/insert one table from another Tag: 136573
  - 19
    - HowTo Convert Array to Binary I have an array of an array of doubles and need to save this as a single byte array. Then save this byte array as a BLOB to an SQL 2005 database. Array allocation code shown below: Array myArray = Array.CreateInstance(System.Type.GetType("System.Double[]"), 3); Double[] dblArray1 = new double[4] { 23.56, 24.56, 25.56, 26.56 }; Double[] dblArray2 = new double[4] { 33.56, 34.56, 35.56, 36.56 }; Double[] dblArray3 = new double[4] { 43.56, 44.56, 45.56, 46.56 }; // Place above three double arrays in an myArray myArray.SetValue(dblArray1, 0); myArray.SetValue(dblArray2, 1); myArray.SetValue(dblArray3, 2); I have tried serialize the myArray object however the byte array is almost twice the length of the array of doubles: MemoryStream stream = new MemoryStream(); BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(stream, dblArray1); BinaryReader reader = new BinaryReader(stream); reader.BaseStream.Position = 0; byte[] inputBytes = reader.ReadBytes((int)reader.BaseStream.Length); However the byte count of the byte array is almost doubled that of the array of doubles. inputBytes byte count is 175 should of been 96 bytes. Does anyone know a better way to save an Array of an Array of doubles to a byte array? Thanks in advance, Scott Tag: Update/insert one table from another Tag: 136571
  - 20
    - TransactionScope Questions Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? What is the performance like using a TransactionScope object for multiple consequetive connections to a single database as compared to using a standard ADO.NET transaction object? I'm guessing it would be slower... but by how much? Thx! Tag: Update/insert one table from another Tag: 136569
  - 21
    - Add array of rows to datatable 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. Tag: Update/insert one table from another Tag: 136564
  - 22
    - 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: Update/insert one table from another Tag: 136560
  - 23
    - 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: Update/insert one table from another Tag: 136559
  - 24
    - 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: Update/insert one table from another Tag: 136539
  - 25
    - 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: Update/insert one table from another Tag: 136536
- Next
  - 1
    - 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: Update/insert one table from another Tag: 136531
  - 2
    - 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: Update/insert one table from another Tag: 136530
  - 3
    - 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: Update/insert one table from another Tag: 136529
  - 4
    - 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: Update/insert one table from another Tag: 136527
  - 5
    - 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: Update/insert one table from another Tag: 136523
  - 6
    - 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: Update/insert one table from another Tag: 136522
  - 7
    - 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: Update/insert one table from another Tag: 136519
  - 8
    - 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: Update/insert one table from another Tag: 136513
  - 9
    - 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: Update/insert one table from another Tag: 136511
  - 10
    - 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: Update/insert one table from another Tag: 136507
  - 11
    - 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: Update/insert one table from another Tag: 136506
  - 12
    - 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: Update/insert one table from another Tag: 136505
  - 13
    - 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: Update/insert one table from another Tag: 136503
  - 14
    - 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: Update/insert one table from another Tag: 136493
  - 15
    - 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: Update/insert one table from another Tag: 136487
  - 16
    - 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: Update/insert one table from another Tag: 136485
  - 17
    - 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: Update/insert one table from another Tag: 136469
  - 18
    - 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: Update/insert one table from another Tag: 136467
  - 19
    - 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: Update/insert one table from another Tag: 136466
  - 20
    - 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: Update/insert one table from another Tag: 136459
  - 21
    - 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: Update/insert one table from another Tag: 136456
  - 22
    - 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: Update/insert one table from another Tag: 136453
  - 23
    - 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: Update/insert one table from another Tag: 136444
  - 24
    - 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: Update/insert one table from another Tag: 136443
  - 25
    - 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: Update/insert one table from another Tag: 136440

Hi

I need to perform following querie in vb.net

The queries are;

NSERT INTO [destTbl] (field1, field2)
SELECT srcTbl.field1, srcTbl.field2
FROM srcTbl
WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl])));

In access I just run these query and job is done without any need for
datadatpters etc. What is the easiest way to execute these two queries in
ado.net/vb.net?

Thanks

Top

Re: Update/insert one table from another by RobinS

RobinS
Tue Jan 23 02:06:33 CST 2007

Use the ExecuteNonQuery method of the Command object.

Robin S.
---------------------------------
"Eashrak" <eashrak@gmail.com> wrote in message
news:Op6U0GqPHHA.1604@TK2MSFTNGP05.phx.gbl...
> Hi
>
> I need to perform following querie in vb.net
>
> The queries are;
>
> NSERT INTO [destTbl] (field1, field2)
> SELECT srcTbl.field1, srcTbl.field2
> FROM srcTbl
> WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM
> [destTbl])));
>
>
> In access I just run these query and job is done without any need for
> datadatpters etc. What is the easiest way to execute these two queries
> in
> ado.net/vb.net?
>
>
> Thanks
>
>

Top