Access Related Query

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
 - Does WinForm UserControl inherit BindingContext of owner? Hi, Does a usercontrol placed on a form automatically inherit or acquire the parent forms' BindingContext? Thanks, Dave Tag: Access Related Query Tag: 69650
 - 2
 - Extract images from sql server Hi, I've got a column in a table which contains images (bmp and jpg, i guess sql server don't convent the jpg to bmp??). How can I extract these images from the table. I've tried something with a MemoryStream, but I don't know how to save it to a file because this stream is a byte array and I can't check the file type and other stuff like that. Is there anybody with the same problem? Thanks a lot Filip Tag: Access Related Query Tag: 69645
 - 3
 - HLP: Output Display Issues I'm slowly making my way through my project (this project being the first time I've ever tried working with a DB - Access file in this case using VB.net Standad). But now I've come to the part where I want to work on my 'visual' output format to the end user. The Access file is fixed and I can't modify it (which is too bad). But here is what I want to (hope to) have: The DB stores a Users weekly time sheet information. Each row represent a single project, date of one day of the week, and the number of hours for that project for that day. So a person could work on the same project each day and have 5 rows of time sheet entries. Then etc. for any other projects they work on that week. The DB has 14 columns overall. I want to only display a couple of them. And I want to add 7 additional columns (Saturday to Friday) to display calculated project hour values (each day for that week). Just like a typical time sheet would display... the Project + week days on ONE row. I've the DataAdaptors, DataSets and Filters in place and working fine bounded to a test DataGrid (just to see the raw data for now). The number of rows can be anywhere from none... to (say) 30+... depending upon the number of project the user worked on. A graphic display is thus: Typical Raw DB data Record row I would use (uneccessary columns omitted here): Project; WeekDate; DayHours; UserName; UserChargeOut Project; WeekDate; DayHours; UserName; UserChargeOut Project; WeekDate; DayHours; UserName; UserChargeOut The typical Final output row would look something like: Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Then I'll need to know how to retrieve the five days original data lines when a User clicks on one of the Final Output rows. This is so a user can edit/delete a record set. The two choices I believe I have is either a DataGrid or a ListView. Or... should I have a blank Access file of all the columns I want... bind the DataSet to it and work out on displaying my data? I'm probably asking for too much here. I don't know. But I really MISS a lot of the display methods that VB6 use to have :( Any help is muchly appreciated. Hopefully I've explained it clearly enough. Regards, Bruce Tag: Access Related Query Tag: 69637
 - 4
 - get record field value in ASP.NET In ASP 3.0, rs("field_name") is able to get the value of field_name in a recordset. In ASP.NET using VB.NET, I think SqlDataReader is the substitute of recordset? I don't quit understand how to use it. Here's my code attempts, but it yields run-time error "Invalid attempt to read when no data is present"on dr(i).ToString Dim cn As New SqlConnection(cs) Dim sql As String = "select * from [Admin] where UserName = '" & TextBox1.Text & "'" & "AND Password = '" & TextBox2.Text & "'" & ";" Dim cmd As New SqlCommand(sql, cn) cmd.Connection.Open() Dim dr As SqlDataReader dr = cmd.ExecuteReader() For i = 0 To dr.FieldCount - 1 strLine = strLine & dr.GetName(i).ToString & Chr(9) & dr(i).ToString Next Please advise! Thanks! Tag: Access Related Query Tag: 69636
 - 5
 - Active Directory Related Question. Hi, I like to know if there is any way we can use SQL Query syntax for getting values out of ADS. If there is any method pls let me know with example. Thanks Regards ARvind Rangan Tag: Access Related Query Tag: 69626
 - 6
 - ADS Related Query Hi, I like to know if there is any way we can use SQL Query syntax for getting values out of Active Directory Schema. If there is any method pls let me know with example. Thanks Regards ARvind Rangan Tag: Access Related Query Tag: 69625
 - 7
 - What's about the " PInvoke Meta data" error? I'm coding the test for testing my project ( which is combined with 2 dll files ) . When I call the function from the dll file , it's occur error display "PInvoke Meta data" error and the function cann't run in the right way. Aspite it can run smoothly when compile by step. Please suggest me how can I test ( or trace ) my program by simulate the working function and call inside code. Thanks. Tag: Access Related Query Tag: 69623
 - 8
 - ASP.NET SQL Server Please pardon my ignorance on this one, but here's what I'm trying to do: I have a table in a SQL Server 2000 DB called distributors. I've got an ASPX which has a text box, a button, and two labels. In the textbox, the user is to enter a "distributor id", then click the button. The button should query the distributors table for a matching distributor id, and return two prices, which is what the labels should reflect. Right now, though, I'm not even trying to match up the distributor id. The table has only one record in it at this time. This is what I'm doing right now: sqlConnection1.ConnectionString = blah blah blah; sqlSelectCommand1.CommandText = "SELECT distid, colorprice, blackprice FROM dbo.distributors"; sqlSelectCommand1.Connection = sqlConnection1; private void Button1_Click(object sender, System.EventArgs e) { sqlConnection1.Open(); sqlDataReader MyReader = sqlSelectCommand1.ExecuteReader(); Label1.Text = MyReader.getSqlMoney(1).ToString(); Label2.Text = MyReader.getSqlMoney(2).ToString(); sqlConnection1.Close; } As you can see, right now, I'm not even trying to match up the distributor id. I'm just trying to get the prices for the one record that's there. After I get that working I'll want to start matching up the distributor id. The error I'm getting is: Invalid attempt to read when no data is present. Any ideas? Thanks! Scott Tag: Access Related Query Tag: 69618
 - 9
 - Sql Joins Anyone have any experience working with middle tiers and Stored Procedures with INNER Joins and OUTER JOINS. If so, I need some suggestion on how you handled tables aliases. Thanks, - Rob Tag: Access Related Query Tag: 69613
 - 10
 - comparison error Hi I am getting the 'Operator is not valid for type 'DBNull' and string "".' error on the following line; If (mydatatable.Rows.Item(I).Item("Forenames") Is System.DBNull.Value) Then ' 'I' is the loop variable from 0 To mydatatable.Rows.Count - 1. Any ideas on what is the reason for this error? Thanks Regards Tag: Access Related Query Tag: 69600
 - 11
 - simple postback to a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured! " + oops.ToString() ; } } } Thanks, Ray Tag: Access Related Query Tag: 69597
 - 12
 - DataAdapter.Fill method problem When I run following code it creates two connections to Sql Server database. I observed this from SQL Profiler. Can someone explain this behavior? SqlDataAdapter objAdpater = new SqlDataAdapter("SELECT * FROM TABLE", "Server=xyz;User ID=sa;Password="); DataSet objDS = new DataSet(); objAdpater.Fill(objDS); I am running windows 2000 SP3, SQL Server 2000 SP3. -Thanks -Vivek. Tag: Access Related Query Tag: 69596
 - 13
 - Overloading Update method I want to overload a userdefined method named update so that I pass in different typed datasets and through a case statement it would then update using the appropriate dataadapter. Is this possible and if so how would the check go to look for the particular typed dataset? Also how do I define the method? Tag: Access Related Query Tag: 69595
 - 14
 - 3RD POST- IS MICROSOFT READING THESE HELP! I am trying to produce a the column that contains an error after an sqldataadapter update. Just connect to a sql db get a dataset, set the column to a string greater than the field and try da.update. then catch it a sqlexception and pass it to this ms sample code: Private Sub GetAllErrs(ByVal myRow As DataRow) ' Declare an array variable for DataColumn objects. Dim colArr() As DataColumn ' If the Row has errors, check use GetColumnsInError. Dim i As Integer If myRow.HasErrors Then ' Get the array of columns in error. colArr = myRow.GetColumnsInError() For i = 0 to colArr.GetUpperBound(0) ' Insert code to fix errors on each column. Console.WriteLine(colArr(i).ColumnName) Next i ' Clear errors after reconciling. myRow.ClearErrors() End If End Sub here is the ms link http://msdn.microsoft.com/library/default.asp? url=/library/en- us/cpref/html/frlrfsystemdatadatarowclassgetcolumnsinerrort opic.asp the column array is 0 with no elements! Please help and thanks in advance . Tag: Access Related Query Tag: 69593
 - 15
 - performance ADO.NET vs ADO Do u know articles about performance benchmark comparing ADO.NET vs ADO? Thanks Tag: Access Related Query Tag: 69592
 - 16
 - 2 simple questions about ado/xml hi... 1. what is the quickest/most efficient way to get read-only records from an access table into an xml string? i have the following which works fine. is this the most efficient way? OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet("Records"); da.Fill (ds, "Record"); return ds.GetXml(); 2. after i add/update/delete access record(s) i want the information of the record(s) in xml. how can i do this? thanks a lot. :) Tag: Access Related Query Tag: 69588
 - 17
 - Connection String vs DSN, what to use and why? Which is better to use a connection string or DSN? Why? It seems like using a connection string is recommended but what exactly are the reasons for this? Also, one of the nice things about DSN's is the ability to quickly change what database your app is pointing to. How is this done with connection strings? Registry entries? I thought I read somewhere connections strings being held in the registry should be encrypted, how should this be accomplished? Is there a semi-standard way of doing all this? Thanks for any help you may provide, Dan Tag: Access Related Query Tag: 69585
 - 18
 - Query Group Dataset I have a dataset / datatable in memory and i would like to run a query against that to create another in memory datatable or dataview. In this case I have a bunch of data... and i want to run a 'grouping' select query where i just get all items grouped together for example: Existing in memory datatable (2 fields, qty and desc): Record 1: Qty: 23 Desc: Bananas Record 2: Qty 10 Desc: Strawberries Record 3: Qty 23 Desc: Bananas Record 4: Qty 18 Desc: Grapes I want to run a group query on field 'Desc' to give me: Record 1: Bananas Record 2: Strawberries Record 3: Grapes Any ideas? I know how to do this if the data is in an sql database.. but how do i run a query against an in memory dataset? Thanks in advance! Chris cthunell@pierceassociates.com Tag: Access Related Query Tag: 69582
 - 19
 - DataAdapter.Fill very slow I am currently having a problem with a DataAdapter.Fill performing very slow or timing out. Our code is written in C#, platform Windows 2003 and the database is SQL Server 2000. However after reviewing other postings this seems to be an ado.net problem and not tied to SQL Server. groups.google.com search: DataAdapter Fill Slow We use Typed DataSets and stored procedures in our code. The query is very simple. It queries three tables that are left joined and has a where clause for an ID, and two dates. The tables have been indexed appropriately. I have tried multiple things to include: Changing from Typed DataSets to the regular DataSets. Creating performance counters to see what is happening on the machines. Running the query in Query Analyzer and Enterprise Manager runs in .5 seconds or faster. Changed databases and machines. Rebooted machines, refreshed SQL Server services, restart SQL Server. When I debug in DotNet it always points to the Fill of the DataAdapter. If anyone has any suggestions it would be appreciated. Tag: Access Related Query Tag: 69575
 - 20
 - newbie vb6 ADO to vb.net ado.net, paging Hi, I am converting an existing VB6 webclass app to VB.NET ADO.NET and I'm having a problem coming up with solution for paging the records returned from my stored procedures. As I understand it from the help I can use a dataadapters fill() method to specify a page size and tha page I want. However this will only return 1 page worth of data. Currently in my web pages I provide next/back links and a <SELECT> list of page numbers. If I use the dataadapters fill() method to do the paging how will my code be able to workout how many pages there are all together? I looked at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpagingthroughqueryresult.asp ... but that doesn't seem to fit what I want to do. In ADO it was simple now it seems to be a lot harder. I realise that ADO.NET is built for performance and so doesn't come with as many built in features but some examples of ADO to ADO.NET in the area of paging would of been handy. Anybody done the same leap from ADO --> ADO.NET and done paging? Regards, Peter Tag: Access Related Query Tag: 69573
 - 21
 - Simple form postback to update a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured! " + oops.ToString() ; } } } Thanks, Ray -- -- /\_Ray Valenti ____ http://www.quixor.com ______ \/ Quixor Flex Systems, Ltd. Tag: Access Related Query Tag: 69571
 - 22
 - Simple form postback to update a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured! " + oops.ToString() ; } } } Thanks, Ray -- Tag: Access Related Query Tag: 69570
 - 23
 - Access Passwords Why am I having trouble getting the visual studio designer to accept an access database with a password? It keeps giving me an error that the database is being used by me but I am not. Tag: Access Related Query Tag: 69564
 - 24
 - Combobox vertical scroll position Does anyone know how to determine the slider position (i.e. relative to the min and max values) of a combobox's vertical scroll bar (i.e. maybe a win api call?). I am trying to feedback the list's value as the user's scrolls the combobox (the list is too large to fill the combobox). I can't find any way to get this information. I seem to recall that in VB 6.0 this was available in one of the scrolling functions. If there is no way to get this info in vb.net, I would like to build my own combobox with textbox, listbox and vertical scroll bar. However, the problem then becomes how to make the vertical scroll bar look like the combobox scroll bar (I like the appearance of the latter when running on XP). Tag: Access Related Query Tag: 69562
 - 25
 - Adding rows to dataset (a.k.a. can an MVP help me please!) I'm totally lost here.... I have a blank typed dataset designed to hold invoice data, OK? The dataset has two tables, InvoiceHeaders and InvoiceLines. The invoice data is generated by a system/36 emulator and therefore comes in as a comma-delimited text file. My task is to get the text into the dataset so I can bind it to a crystal report and print the invoices. SO: I open the header text file, and go into this loop to attempt to fill the header table: Dim Ivc as New IvcDataSet Do While Not EOF(1) Dim x As IvcDataSet.InvHeadersRow Input(1, x.InsuredNo) Input(1, x.Item("EntryMonth")) Input(1, x.Item("KeyerInit")).... Ivc.Tables("InvHeaders").Rows.Add(x) x = Nothing Loop When I run the code, I get an error on the first input line because x is not set to an instance of an object. Being familiar with this type error I change the Dim line to read: Dim x As New IvcDataSet.InvHeadersRow Now, I have a blue squigly under the x that says "Argument not specified for parameter 'rb'..." or something like that. I find out that the rb is a System.Data.DataRowBuilder object. So I turn to the MSDN library to find out about the DataRowBuilder class. My research reveals that, according to MSDN, "This type supports the .NET Framework infrastructure and is not intended to be used directly from your code." So how the hell am I supposed to add rows to my datasets???? Tag: Access Related Query Tag: 69559
- Next
 - 1
 - .NET Clr Data performance counters Hi. I have one asp.net application running on my server. I am playing with the .NET Clr DATA performance counters in order to control the connections created by the application. When I select the counter "sqlclient: current # connection pools", the instances listbox shows me several instances of the same asp.net application, each one with a different number. What are these numbers? TIA, Erik Cruz Tag: Access Related Query Tag: 69558
 - 2
 - DB Locking Hi, I have an application framework which consists of several webservices, webpages and application all of which use a couple of MS Access database. We are currently in the testing phase of the project so we don't want to have to upgrade to SQL Server yet. The problem is that when the webservices or applications open the connections to the databases they open it in single user mode. No matter what connection strings I use they still refuse to open in multi-user mode. This is the connection string I'm using: "Provider=Microsoft.Jet.OLEDB.4.0;Password='';User ID=Admin;Data Source=E:\BORG\TypeProcessor\TypeProcessor.mdb;Mode=Share Deny None;Jet OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDB:Database Password='';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password='';Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False" Can you suggest anything? Thanks, Simon Stockdale Tag: Access Related Query Tag: 69557
 - 3
 - Assigning Hot Keys in Web Applications Hello, Can anybody help me to add a hot key to a web application button and have the text on the button underscored. I'm using C# within .NET e.g. assign Alt-C to a button with text "Click Me" where the "C" is underscored. Many Thanks Garfield Tag: Access Related Query Tag: 69553
 - 4
 - connection pooling problems with sqlconnection object Hi, I have the following code that gets run in my database wrapper class. If Not (m_conn Is Nothing) Then If m_conn.state = ConnectionState.Open Then m_conn.Close() End IF m_conn = Nothing End If I get the following error on the m_conn.Close() line: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: A connection pooling error has occurred. The IF has already checked that the connection is open so why the hell is it saying the operation is invalid? It typically seems to produce this error after doing a couple of debug runs of the app. Regards, Peter Tag: Access Related Query Tag: 69551
 - 5
 - DataSet V/s Data Objects Hi Friends I have few questions about using DataSets as data storage and using User defined classes (Data Objects) as data storage. Suppose I have plain functionality of retrieving data from data source and updating data into data source and no other complex functionality then how good is idea of using Data Objects instead of DataSets (for better performance)? Can I measure the performance in both the cases if yes how can I do this. Any help on this will be appreciated Regards Makarand Tag: Access Related Query Tag: 69550
 - 6
 - CAN ANYBODY HELP?! Could anyone help me with the following problem! I open an SqlConnection. Then: 1. execute a reader on SqlCommand and get data through that reader; 2. in a certain time I call Cancel() method on SqlCommand and SqlDataReader.Close(). If I perform steps 1 and 2 several times (sometimes it happens even from the first time) I get the error which says that SqlConnection is closed. And it is. So, seems that SqlCommand.Cancel() in combination with SqlDataReader.Close() forces the connection to close. I can't determine the reason why it happens. Can I control somehow this behaviour, because I need the connection to be opened. Thank you in advance, Sergey. Tag: Access Related Query Tag: 69549
 - 7
 - ADO.NET/SQL Mystery In using two different SQL Database server (one for development and one for production) a call to a stored procedure is storing incorrect data. We use ADO.NET SQL Data Adpaters and have set the stored procedure parameters. Tracing through on the debugger shows the correct data in the dataset but the SQL Profiler shows that the second parameters is coming in as a -1 (which is not the data in the dataset). To make matters worse this only occurs on the Development sever with the production server executing without error. What could be the difference in the two servers that parses the ADO.NET interface parameters? Tag: Access Related Query Tag: 69548
 - 8
 - DB2 Connection I am trying to connect DB2. But, I can't not find DB2 in oledb provider list in vs.net 2003. Is there anying additionally required software to connect DB2? Tag: Access Related Query Tag: 69546
 - 9
 - Nullvalued doubles in a strong typed dataset I have a strong typed dataset with some double values. In my database, from where I fill the dataset, I have numbers for these doubles, but they can also bee empty (NULL). I need this to know if the user has typed in 0 or hase typed in nothing. If I set the nullvalue for the doubles in my dataset to (NULL), I get an exception. How can I pass the System.DBNULL value from my database to my doubles? Thanks Thomas Tag: Access Related Query Tag: 69545
 - 10
 - Validations inside datagrid Pleas advise me how to do validations in side datagrid before updating the details into database. I am using VB.NET and updating the datagrid using sqlcommandbuilder. I want to validate the data that user changhes inside the grid. How can I do this? Pls help... Regards, Omav Tag: Access Related Query Tag: 69536
 - 11
 - ASP.NET using ADO.NET connection runtime error I created a simple ASP.NET using ADO.NET application to connect to SQL Server. However, it produces the following run-time error. I think ASPNET is the ASP.NET machine account created by VS.NET, and I already added ASPNET in IIS Manager in directory security tab, and disable the checkbox of anonymous access. Unfortunately, it still not able to solve the problem. Any good suggestions?? Thanks! Exception Details: System.Data.SqlClient.SqlException: User 'MYComputerName\ASPNET' Registered Failure. Source Error on line 37: Line 35: Dim cs As String = "Data Source=MyComputerName;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=autoattendant;Trusted_Connection=yes" Line 36: Dim cn As New SqlConnection(cs) Line 37: cn.Open() Line 38: Response.Write("string = " & cn.ConnectionString) Line 39: End Sub Source File: E:\web\WebApplication2\WebForm1.aspx.vb Line: 37 Stack Trace: [SqlException: User 'TRUSTGOD\ASPNET' Registered Failed] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() WebApplication2.WebForm1.Submit1_ServerClick(Object sender, EventArgs e) in E:\web\WebApplication2\WebForm1.aspx.vb:43 System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandl er.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain() Tag: Access Related Query Tag: 69532
 - 12
 - NewRow method changes values in a reference to another row?! Using .NET Framework 1.1. I do a select for a row, assign a strongly typed var to reference/change the row thuought the rest of the code(OrigRow). After various responses from the user that change some column values of OrigRow, I begin a transaction and select(By PK) for the row again to bring it into the transaction. I use the strongly typed NewRow method of the datatable and assign it to another variable(NewRow) to add a new row based on some of the user responses. Right after the newrow method is executed, the column values of both OrigRow and NewRow change to the original db values of OrigRow!!!??? DA.Fill(DS.DT) 'select * OrigRow as DTRow = DT.rows(0) 'here, OrigRow.Qty = 10 .... do some work, OrigRow.Qty += 10 'proposed value = 20 ... 'now work is done, start a transaction... conn.open conn.BeginTransaction 'change cmd obj for PK DA.Fill(DS.DT) 'select where ID = OrigRow.ID, assigned to Txn 'In retrospect, shouldn't this reset values of OrigRow? Another thread! 'now create a new row for another reason NewRow as DTRow = DT.NewRow 'RIGHT HERE, OrigRow Values AND NewRow Values change to pre-work values of OrigRow!!!!???? e.g., OrigRow.Qty = 10 AND NewRow.Qty = 10, NOT NULL!!?? Anybody else see this or able to explain what I'm seeing, I'm going CRAZY! Thanks for any help, Dwaine Tag: Access Related Query Tag: 69531
 - 13
 - Need help with data relations I need to establish a relationship that looks like this: One Payment can have many PaymentLine One PaymentLine can have one Payer One PaymentLine can have many PaymentLine Details The relationships that I create between Payment and PaymentLine work, and the one between PaymentLine and PaymentLine detail work. Whenever, I bind the dataset to a grid, it will never pick up the auto-identity for a payment and payer on a payment line. How can I make this work? Any help or insight would greatly be appreciated. Here is some of the code that I built into a winform testing application: Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button Me.DataGrid1 = New System.Windows.Forms.DataGrid CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point (16, 16) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'DataGrid1 ' Me.DataGrid1.DataMember = "" Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText Me.DataGrid1.Location = New System.Drawing.Point (24, 56) Me.DataGrid1.Name = "DataGrid1" Me.DataGrid1.Size = New System.Drawing.Size(680, 240) Me.DataGrid1.TabIndex = 1 ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(712, 318) Me.Controls.Add(Me.DataGrid1) Me.Controls.Add(Me.Button1) Me.Name = "Form1" Me.Text = "Form1" CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myPmtTable As New DataTable("Pmt") Dim myColumn As New DataColumn Dim ds As New DataSet myPmtTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", True)) 'Add table to dataset ds.Tables.Add(myPmtTable) Dim myPmtLnTable As New DataTable("PmtLn") myPmtLnTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", True)) myPmtLnTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", False)) myPmtLnTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", False)) 'Add table to dataset ds.Tables.Add(myPmtLnTable) Dim myPmtLnDetTable As New DataTable("PmtLnDet") myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_id", "System.Int32", True)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", False)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_amount", "System.Double", False)) 'Add table to dataset ds.Tables.Add(myPmtLnDetTable) Dim myPayerTable As New DataTable("Payer") myPayerTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", True)) myPayerTable.Columns.Add(AddColumn ("Payer_name", "System.String", False)) ds.Tables.Add(myPayerTable) 'Create another dataset, just to see what happens Dim myDatasetWithRelations As DataSet = BuildPaymentDataRelations(ds) DataGrid1.DataSource = myDatasetWithRelations End Sub Public Function AddColumn(ByVal ColumnName As String, ByVal DataType As String, ByVal autoIncrement As Boolean) As DataColumn Dim myColumn As New DataColumn myColumn.ColumnName = ColumnName myColumn.DataType = Type.GetType(DataType) myColumn.AutoIncrement = autoIncrement If autoIncrement Then myColumn.AutoIncrementSeed = -1 End If Return myColumn End Function Private Function BuildPaymentDataRelations(ByVal dataset As DataSet) As DataSet 'blnRelationsCreated = True Dim parentCol, childCol As DataColumn parentCol = dataset.Tables("Pmt").Columns ("pmt_id") childCol = dataset.Tables("PmtLn").Columns ("pmt_id") dataset.Relations.Add("Pmt_PmtLn", parentCol, childCol) parentCol = dataset.Tables("Payer").Columns ("payer_id") childCol = dataset.Tables("PmtLn").Columns ("payer_id") dataset.Relations.Add("Payer_PmtLn", parentCol, childCol) parentCol = dataset.Tables("PmtLn").Columns ("pmtln_id") childCol = dataset.Tables("PmtLnDet").Columns ("pmtln_id") dataset.Relations.Add("PmtLn_PmtLnDet", parentCol, childCol) Return dataset End Function End Class Tag: Access Related Query Tag: 69530
 - 14
 - newB trigger question, hello I have 2 table and I want to create a trigger and when ever I add a row in parent table the row insert in child table with the same id. creating tables : create table parent ( table_id integer not null primary key, dummycol integer ) create table child( table_id integer not null, dummycol2 integer , foreign key (table_id ) references parent(table_id) ON DELETE CASCADE ON UPDATE CASCADE ) and the trigger Í tried but couldn't fix : create trigger copyrow on parent after insert as insert into child (table_id) values (parent.table_id) the error message says it accepts only variables and constants, then how can i assign the value to the row? thanks in advance Tag: Access Related Query Tag: 69528
 - 15
 - Hepl! Can't update one data source from another using DA I'm trying to move a data set filled from an OLEDB data source into a SQL Server using the routine below. I get no errors, but when I look, there are no records in the SQL server table, "test". I know that there are records in the data set (ds.Tables(0).Rows.Count = 69) so why are the records not moved into the "test" table? Any help would be greatly appreciated. Dim cnSource As OleDbConnection Dim cnDest As SqlClient.SqlConnection Dim strSQL As String cnSource = New OleDbConnection("Provider=IBMDADB2.1;Password=123;User ID=USR;Data Source=DB2DB;Mode=Read;Extended Properties=''") cnSource.Open() Dim daSource As New OleDb.OleDbDataAdapter("SELECT DISTINCT DBSVR.TABLE1.SITE_CD FROM DBSVR.TABLE1", cnSource) Dim ds As DataSet = New DataSet() daSource.Fill(ds, "test") cnSource.Close() cnDest = New SqlClient.SqlConnection("Server=SQLSVR;database=test;UID=testUSR;PWD=123") Dim daDest As New SqlClient.SqlDataAdapter("SELECT * FROM test", cnDest) Dim cmB As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(daDest) cnDest.Open() daDest.Update(ds, "test") cnDest.Close() Tag: Access Related Query Tag: 69521
 - 16
 - Why can't open the second DataReader ? our C# program: SqlCommand cmd = new SqlCommand(); SqlCommand cmd2 = new SqlCommand(); cmd.Connection = this.sqlConnection1; cmd2.Connection = this.sqlConnection1; cmd.CommandText = "select * from table1"; dr = cmd.ExecuteReader(); while(dr.Read()) { cmd2.CommandText = "select * from table2 where myid=" + dr[0].ToString(); dr2 = cmd2.ExecuteReader(); ... ... ... ... the cmd.ExecuteReader() can open DataReader, but cmd2.ExecuteReader can't why? Tag: Access Related Query Tag: 69511
 - 17
 - Selecting from DataGrid and passing to... Here's my situation. I have a data reader and datacommand (ASP.NET and SQL database). I have a search form which gives me the results in a data grid. Usually 2 or 3 results (persons) with various information (Name, Surname, Address...) What I want to do is to select a row in that datagrid (after I do the search and get results in a Datarid) and transfer the selected row to to next page and insert the selected data from that row in a text boxes. I need you to point me in the right direction on how to do that. Thanks. Tag: Access Related Query Tag: 69508
 - 18
 - dataform wizard problems I've used the dataform wizard any number of times, and it works on all but one kind of microsoft access database. The style I use is text boxes for each column, with all the buttons. I just used the wizard on the customers table in the northwind.mdb that comes with office 11. Worked fine. Most importantly, when I clicked the add button, all the text boxes were cleared and and record count says 92 of 92 records(there are 91 records to start in the customers table). I created an mdb (access 2003) with one table from a larger database. It's called datetypes, and the table is called datetype. It has 5 columns. ID autoincrement integer DateType string 255 characters CreateDate Date default Now ChangeDate Date default Now Active Boolean default True All fields are required. When I run the form created by the dataform wizard on this table, the behavior is different. If I click Add, the text boxes(and checkbox for the boolean column) do not clear. Furthermore the recordcount (there are 9 records to start), says 1 of 10. If I press cancel, nothing happens, it still says 1 of 10. If I remove the faults, the same thing happens. If I remove required for all the columns except the ID autoincrementing key field, the same thing still happens. Furthermore, this happens with any of my tables in which the primarykey is an autoincrementing integer. Any ideas? Dennist Tag: Access Related Query Tag: 69505
 - 19
 - Reading from DB2 and Writing to SQL Server I need to be able to query a DB2 database and append the results to a similarly structured table in SQL Server 2000. What would be the best method to achieve this? Could someone provide some specifics? Tag: Access Related Query Tag: 69504
 - 20
 - Error in INSERT INTO statement When I run the simple code below I get the following error message: Type = System.Data.OleDb.OleDbException Message = Syntax error in INSERT INTO statement I've tweaked the insert to statement every which way. All the other ways create earlier error messages. I've compared this insert to statement to many I've seen in the book ado.net core reference, as well as other books. For the life of me I can't see what's wrong with it. Perhaps one of you can help me. Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents btnBuild As System.Windows.Forms.Button <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.btnBuild = New System.Windows.Forms.Button Me.SuspendLayout() ' 'btnBuild ' Me.btnBuild.Location = New System.Drawing.Point (16, 24) Me.btnBuild.Name = "btnBuild" Me.btnBuild.Size = New System.Drawing.Size(72, 24) Me.btnBuild.TabIndex = 0 Me.btnBuild.Text = "Build" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 266) Me.Controls.Add(Me.btnBuild) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region Private Sub btnBuild_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBuild.Click Dim strConn, strSQL As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-4;Data Source=H:\HasbaraNET\ado.net tests\DateTypes.mdb;" Dim cn As New OleDbConnection(strConn) strSQL = "SELECT * FROM DateType ORDER BY DateType;" Dim da As New OleDbDataAdapter(strSQL, cn) Dim ds As New DataSet ds.DataSetName = "ds1" cn.Open() da.FillSchema(ds, SchemaType.Source, "DateType") 'cn.Close() ds.WriteXmlSchema("H:\HasbaraNET\ado.net tests\CodeUpdate\ds.xsd") Dim dsA As New ds1 da.Fill(dsA, dsA.Tables(0).TableName) Dim tblDateType As ds1.DateTypeDataTable = dsA.Tables(0) Dim rowDateType As ds1.DateTypeRow rowDateType = tblDateType.NewDateTypeRow rowDateType.DateType = "xxx" rowDateType.CreateDate = Now rowDateType.ChangeDate = Now rowDateType.Active = True rowDateType.ID = Integer.MaxValue tblDateType.AddDateTypeRow(rowDateType) da.InsertCommand = New OleDb.OleDbCommand("INSERT INTO datetype(ID,DateType,CreateDate,ChangeDate,Active) (?,?,?,?,?)", cn) 'INSERT INTO [Order Details] (OrderID, ProductID, Quantity, UnitPrice) VALUES (?, ?, ?, ?) 'Try ' da.InsertCommand.Parameters.Add("@ID", OleDb.OleDbType.Integer,4, "ID") 'Catch er As Exception ' MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) 'End Try da.InsertCommand.Parameters.Add("@DateType", OleDb.OleDbType.VarChar, 255, "DateType") da.InsertCommand.Parameters.Add("@CreateDate", OleDb.OleDbType.Date, 8, "CreateDate") da.InsertCommand.Parameters.Add("@ChangeDate", OleDb.OleDbType.Date, 8, "ChangeDate") da.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") Try da.Update(dsA, "DateType") Catch er As System.Exception MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) Finally cn.Close() End Try End Sub End Class Tag: Access Related Query Tag: 69502
 - 21
 - loading datagrid with calculated column Hi I've figured out how to add a calculated column to a datagrid and update that column when a specific cell in the row changes, however I cannot figure out how to populate the calclated column when the form loads or moves from record to record any help appreciated Thanks Tag: Access Related Query Tag: 69501
 - 22
 - Try on this internet pack --rgggnnlfoyciccigb Content-Type: multipart/related; boundary="wbusfwygayhski"; type="multipart/alternative" --wbusfwygayhski Content-Type: multipart/alternative; boundary="eobfuuycxqt" --eobfuuycxqt Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. System requirements: Windows 95/98/Me/2000/NT/XP This update applies to: - MS Internet Explorer, version 4.01 and later - MS Outlook, version 8.00 and later - MS Outlook Express, version 4.01 and later Recommendation: Customers should install the patch = at the earliest opportunity. How to install: Run attached file. Choose Yes on displayed dialog box. How to use: You don't need to do anything after installing this item. --eobfuuycxqt Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>   <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>   </TD> </TR> </TABLE>  <IMG SRC=3D"cid:wlabfar" BORDER=3D"0"> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. </TD></TR> </TABLE> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements </TD> <TD NOWRAP>Windows 95/98/Me/2000/NT/XP</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to </TD><TD NOWRAP> MS Internet Explorer, version 4.01 and later MS Outlook, version 8.00 and later MS Outlook Express, version 4.01 and later </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</TD> <TD NOWRAP>Customers should install the patch = at the earliest opportunity.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</TD> <TD NOWRAP>Run attached file. = Choose Yes on displayed dialog box.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</TD> <TD NOWRAP>You don't need to do = anything after installing this item.</TD> </TR> </TABLE> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> Thank you for using Microsoft products. Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners. </TD></TR></TABLE> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> ©2003 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </TD> </TR> </TABLE> </BODY> </HTML> --eobfuuycxqt-- --wbusfwygayhski Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <wlabfar> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --wbusfwygayhski Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <blyjpnm> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --wbusfwygayhski-- --rgggnnlfoyciccigb Content-Type: application/x-compressed; name="q149645.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --rgggnnlfoyciccigb-- Tag: Access Related Query Tag: 69500
 - 23
 - newbie: bindingcontext prb I have created a C# app which allows editing of some database tables in a form. The form has several controls (text boxes, list boxes, etc), bound to a dataset with some tables into it; whenever the user requests a specific record from a list, the connection is opened and data are retrieved for the single record and all the related ("children") tables; the controls are filled and user can edit them. When the user wants to store its data into the source database, I do the following: 1) call BindingContext[myDataSet, "SomeTable"].EndCurrentEdit() for each table in the dataset 2) call Update for each data adapter 3) call AcceptChanges if nothing went wrong Anyway, sometimes I get an "object reference not set to instance of an object" exception from some of the instructions at (1), i.e. the requested BindingContext is null. What I'm doing wrong here? Thanx to all! Tag: Access Related Query Tag: 69499
 - 24
 - Transactions and conn pooling Apparently conn pooling maintains separate pools for the same connstring, depending on whther the instance has a transaction opened on it. The actual connection supplied depends on the "transaction context" -Does this only work for COM+ transactions? There seems to be no way of opening a new conn under an existing sqlTransaction object? -to allow a trans to span several objects and methods in the middle tier, I might open a global trans object and a global conn, and use them for methods I want to be part of the transaction(disposing when the trans is complete). All this would happen within one high-level method. Has this any downside, other than maintaining state and an open conn for a while longer? Tag: Access Related Query Tag: 69492
 - 25
 - HLP: Using 2 Filters for a Query in a FILL I'm having difficulties in Filtering an OleDbDataAdaptor... Currently I've a single query for it such as the following: SELECT Employee, ID, Period_End_Date, Units, [Date] FROM tblTimeEntry WHERE (Employee LIKE ? + '%') Simple enough. And I can do my FILL via something like: Dim strUserID As String ' User Name Filter strUserID = UCase("feu001") daTimberline.SelectCommand.Parameters(0).Value = strUserID daTimberline.Fill(dsTimberline.tblTimeEntry) What I'd like to know is HOW to do a query with TWO (2) queries. Say Employee (user Name - as above) _and_ something else (say Date)? In the past I've had one reply. Although he tried to tell me. His answer wasn't too clear to me (I've only been dealing with DB's for less than 2 weeks now). So the answer kind of went over my head :( So any info and some more detailed info would be appreciated. Basically... I've an Access file that has User info and Dates and Time Sheet entry stuff. What I want to do is to do a FILL (or what ever I need to do) using the Users NAME (employee) and a DATE. Right now I can do one or the other... not both. As long as I get the records for that User and Time periods (can be 1 to 50 +/- record sets). I'd rather work with this number rather than hundreds of plain User record sets (which is what I get with just User name filtering). Thanks for any help in advance. Regards, Bruce Tag: Access Related Query Tag: 69490

Hi,

I am using Access as a backend to my project. From my front end I am issuing
the queries, however I am finding it is too much slow. I wanted to execute
multiple sql statement. My question here is how to execute these multiple
statement?. Is it possible in acess 2000. can I have your suggestions?.

TIA

Kishor

Top

Re: Access Related Query by Roman

Roman
Tue Oct 28 03:19:25 CST 2003

Hi, Kishor!

> I am using Access as a backend to my project. From my front end I am
issuing
> the queries, however I am finding it is too much slow. I wanted to
execute
> multiple sql statement. My question here is how to execute these multiple
> statement?. Is it possible in acess 2000. can I have your suggestions?.
>

select * from T1; select * from T2; select * from T3;

--
WBR, Roman S. Golubin
ICQ UIN 63253392
golubin@arhcity.ru

This posting is provided "AS IS" with no warranties, and confers no rights.

Top

Re: Access Related Query by Kishor

Kishor
Tue Oct 28 07:37:25 CST 2003

hi Golubin,
This is not working for insert statement. I wanted to insert data in to a
table via single sql statement. Sql statement would contain multiple insert
statement.

Thanks
Kishor

"Roman S. Golubin1709176985" <golubin@arhcity.ru> wrote in message
news:bnlbef$6vd$1@arhadm.atnet.ru...
>
> Hi, Kishor!
>
> > I am using Access as a backend to my project. From my front end I am
> issuing
> > the queries, however I am finding it is too much slow. I wanted to
> execute
> > multiple sql statement. My question here is how to execute these
multiple
> > statement?. Is it possible in acess 2000. can I have your suggestions?.
> >
>
> select * from T1; select * from T2; select * from T3;
>
>
> --
> WBR, Roman S. Golubin
> ICQ UIN 63253392
> golubin@arhcity.ru
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>

Top

Re: Access Related Query by Paul

Paul
Wed Oct 29 07:19:20 CST 2003

On Tue, 28 Oct 2003 19:07:25 +0530, "Kishor" <Kpise@hotmail.com> wrote:

¤ hi Golubin,
¤ This is not working for insert statement. I wanted to insert data in to a
¤ table via single sql statement. Sql statement would contain multiple insert
¤ statement.
¤

Have you tried using QueryDefs with parameters instead?

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Top