Visual foxpro

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
    - How to fill a dataset from an inline function ? I want to read a table into a dataset using an SQL inline function (which returns a table). Can anyone tell me how to do it ... have been trying all sorts of combinations with no luck. Tag: Visual foxpro Tag: 94049
  - 2
    - .Net trick everyday! (N.161: Saving the binary file to Database) Dear Member, Today, the hot.Net members received both C# and VB.NET code with subject "N.161: Saving the binary file to Database". If you didn't receive it, this means you are not a hot.Net member. "HotDotNet" is a Yahoo group which sends to its members both C# and VB.NET code (fully tested). Please click the link below to join. http://groups.yahoo.com/group/hotdotnet/join Regards Nuri Yilmaz Tag: Visual foxpro Tag: 94047
  - 3
    - Typed Dataset and BrowsableAttribute Hi. I have a typed dataset in a windows forms app with a PropertyGrid control in which I am displaying the currently selected item from one of the tables in the dataset. By default, this means that all properties of the currently selected item are displayed, including RowState, HasErrors, etc. Ordinarily you can show/hide properties such as these in the property grid using BrowsableAttribute. Is there any way to decorate the dataset schema to do this, or will I have to wrap the currently selected item in a class that exposes column values as properties (with BrowsableAttribute appropriately applied)? Thanks kh Tag: Visual foxpro Tag: 94044
  - 4
    - Converting ADO.NET DataSet to ADO Recordset - How do I set default values Hello, I'm working on a project where we are converting between DataSet (actually DataTable) and Recordset to support existing VB6 code. We define the Fields of the Recordset by calling aRecordset.Fields.Append(...). However I have not been able to find out how I also can set the default value to be used for a Field when creating new rows. I appreciate any help in solving this - thanks. Best regards, Bjørn Egil Hansen Tag: Visual foxpro Tag: 94034
  - 5
    - DataGrid with ComboBox - won't allow me to add more than one new row??? G'day, After doing much searching and pinching bits of ideas from here there and everywhere I came up with a fairly 'clean' solution of including a comboBox into a dataGrid column. You can download a fully working C# sample with the Northwind.mdb here: www.insightgis.com.au/web/stuff/DataGridCombo.zip The whole thing works like a charm, but I have a slight problem: When the user navigates to the new row, fills in some data, subsequent new rows are not displayed! Meaning you can only add just ONE record! It seems as if the DataGrid is not detecting changes made by the ComboBox, but if you physically type some value in through the keyboard then its's happy, it displays a subsequent new row. Any ideas what might be causing that? Here's the code if you don't feel like downloading the ZIP: (Note, dataAdapers and dataGridColumnStyles have have been configured through the IDE so you'll need the full source code to make this work) -------------------------------------------------------------- private void Form1_Load(object sender, System.EventArgs e) { dbConnection.ConnectionString = @"provider=Microsoft.Jet.OLEDB.4.0; data source=C:\NWIND.MDB"; // Load the ORDERS and CUSTOMERS tables from the Northwind demo database. myDataSet = new DataSet(); daOrders.Fill(myDataSet, "ORDERS"); daCustomers.Fill(myDataSet, "CUSTOMERS"); myDataGrid.DataSource = myDataSet.Tables["ORDERS"]; // Create the comboBox to be used by the 'Customer Name' column in the grid. comboCustomers = new ComboBox(); comboCustomers.SelectionChangeCommitted += new EventHandler(comboCustomers_SelectionChangeCommitted); comboCustomers.Top = -4; // position the combo so that it's text is aligned with the cell's text. comboCustomers.Left = -4; comboCustomers.DropDownWidth = 150; comboCustomers.Cursor = Cursors.Arrow; comboCustomers.DropDownStyle = ComboBoxStyle.DropDownList; // Set the datasource for the comboBox comboCustomers.DataSource = myDataSet.Tables["CUSTOMERS"]; comboCustomers.DisplayMember = "CompanyName"; comboCustomers.ValueMember = "CustomerId"; // Databind the combBox to the ORDERS table. comboCustomers.DataBindings.Add("SelectedValue", myDataSet.Tables["ORDERS"], "CustomerId"); // Assign the new comboBox to the dataGrid column. // ... NOTE, I've defined dataGrid column styles through the IDE. colCustomer.TextBox.Controls.Add(comboCustomers); // Assign event handler when the user enters the 'Customer Name' cell. colCustomer.TextBox.Enter += new EventHandler(colCustomer_Enter); } private void comboCustomers_SelectionChangeCommitted(object sender, EventArgs e) { // Set the text in the 'Customer Name' datagrid cell (underneath the comboBox). myDataGrid[myDataGrid.CurrentCell] = comboCustomers.Text; } private void colCustomer_Enter(object sender, EventArgs e) { // This event handler is triggered when the user clicks on the 'Customer Name' cell // The purpose here is to simply display the comboBox. if (myDataGrid.ReadOnly) { // Don't display the comboBox if dataGrid is readOnly! comboCustomers.Visible = false; return; } comboCustomers.Width = colCustomer.Width + 3; comboCustomers.Visible = true; comboCustomers.BringToFront(); } -------------------------------------------------------------- Cheers, PeterZ Tag: Visual foxpro Tag: 94032
  - 6
    - RowState on Child Row Problem - also question regarding DataContraints I have a dataset with 2 tables... A Child relation between both, with cascase update. After using the getchange on a temporary dataset and using both dataadapters update method, i don't know if/when to use the merge method on the main dataset so that the updated returned values (Namely Identities returned but the sql server) will be displayed on the form. As it is right now, I use the values from the temporary dataset, but I am sure I am missing something. Here is my code... Me.BindingContext(Me.objdsOrders.Orders).EndCurrentEdit() Me.BindingContext(Me.objdsOrders.OrdersDetails).EndCurrentEdit() Dim Changes As dsOrders = Me.objdsOrders.GetChanges If Not Changes Is Nothing Then daOrders.Update(Changes.Orders) daOrdersDetails.Update(Changes.OrdersDetails) Me.objdsOrders.AcceptChanges() Me.ID = Changes.Orders.Rows(0).Item("ORD_ID") Me.Text = "Order # " & Me.ID Me.objdsOrders.EnforceConstraints = True Also, the only way i figured out to allow the user to create children in the grid before saving is to turn off constraints on new order records. Is that a proper way to do this ? Thanks Tag: Visual foxpro Tag: 94029
  - 7
    - "Specified cast is not valid" when MyTable.Select is used I get this error with the code below. I think it is the line that strExp is declared. I have tried the ID and not the tYear column and still get the error. All I want to do is sort the years. Thanks, ripripal Private Function GetYears() Dim myRow, dr As DataRow Dim str As String Dim i, ib, ie, icnt As Integer Dim myDataTable As New DataTable 'Declare DataColumn ID Dim myColumn1 As New DataColumn("ID") myColumn1.DataType = System.Type.GetType("System.Int32") 'Add Column to table myDataTable.Columns.Add(myColumn1) 'Declare DataColumn tYear Dim myColumn2 As New DataColumn("tYear") myColumn2.DataType = System.Type.GetType("System.Int32") 'Add Column to table myDataTable.Columns.Add(myColumn2) 'Get rid of duplicates Dim myUC As New UniqueConstraint("UC", myDataTable.Columns("tYear")) myDataTable.Constraints.Add(myUC) icnt = 0 For Each dr In dsAutos.Tables("tAutos").Rows icnt = icnt + 1 ib = Val(dr("tBYr")) i = ib ie = Val(dr("tEYr")) Do Until i = ie + 1 Try myRow = myDataTable.NewRow() myRow("ID") = icnt myRow("tYear") = i Console.WriteLine(myRow("tYear")) myDataTable.Rows.Add(myRow) 'Me.ListBoxYear.Items.Add(CStr(i)) i = i + 1 Catch i = i + 1 End Try Loop Next Console.WriteLine(icnt) Console.WriteLine("-----") For Each dr In myDataTable.Rows Console.WriteLine(dr("tYear")) Next Dim strExp, strSort As String 'Sort strExp = "tYear > 1900" strSort = "tYear" 'Use the Select method to find all rows matching the filter. Dim drsort As DataRow() = myDataTable.Select(strExp, strSort, DataViewRowState.Added) For Each drsort In myDataTable.Rows Console.WriteLine(drsort("tYear")) Next End Function Tag: Visual foxpro Tag: 94027
  - 8
    - ARE U LONELY? Looking for love? Are you lonely???? Looking for love... or just a bit of fun ;) Then visit: http://www.up-date.co.uk FREE dating sites and exclusive special offers such as FREE membership... Meet single people from your area for love, romance and more! Dating guides - how to attract and seduce your ideal partner... Why wait? Find someone today... http://www.up-date.co.uk Tag: Visual foxpro Tag: 94024
  - 9
    - Sybase ASA .NET provider vs. ODBC Has anyone here done any benchmarking with the iAnywhere.Data.AsaClient provider versus using System.Data.Odbc (or Oledb for that matter)? Initially I thought that the iAnywhere provider was going to be the better way to go, but in learning that it's just a .NET dll layer (iAnywhere.Data.AsaClient.dll) over a Win32 DLL (dbdata9.dll), I was just wondering how much it would buy us. <thinking_out_loud> Additionally, it seems that if we want to use other databases (like SQLServer, for instance), then our best bet for compatibility is to use the ODBC provider (and use T-SQL). </thinking_out_loud> Does this all sound reasonable, or am I way off base here? Thanks! -Evan Tag: Visual foxpro Tag: 94022
  - 10
    - Paging a SqlDataReader in C# This is a multi-part message in MIME format. ------=_NextPart_000_0056_01C4860D.6271F9B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a way to setup paging with a data reader? For instance, I only = want 10 records at a time, and I can move through the next ten when I = need them. From the members that I saw listed in the MSDN library, it = does not appear that there is. Can someone please help? Also, is there a = way to find out the number of results that a stored procedure returns? ------=_NextPart_000_0056_01C4860D.6271F9B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Is there a way to setup paging with a = data reader?=20 For instance, I only want 10 records at a time, and I can move through = the next=20 ten when I need them. From the members that I saw listed in the MSDN = library, it=20 does not appear that there is. Can someone please help? Also, is there a = way to=20 find out the number of results that a stored procedure=20 returns?</FONT></DIV></BODY></HTML> ------=_NextPart_000_0056_01C4860D.6271F9B0-- Tag: Visual foxpro Tag: 94021
  - 11
    - Datasets? Properties? Values? Hello, I have been working with an application that sends a dataset to other forms that are called from individual DLL's. I have noticed that, a dataset that is passed to another form, when changed, changes the dataset in all of the forms. But, if you send a string to the other forms, that the value is independant on each form.. I.E. Called Form from a DLL: Dim ADataset As New DataSet() Dim FormNumber As String Public Property RefDataset() As DataSet Get Return RefDataset End Get Set(ByVal Value As DataSet) ADataset = Value End Set End Property Public Property WhatForm() As String Get Return WhatForm End Get Set(ByVal Value As String) FormNumber = Value End Set End Property If I change the data inside the 'ADataset' the Main App's and the called form's datasets change together (all of them) which is good and fine for what I need it for. But if I change the FormNumber only the called form's FormNumber Changes and not all of them. Is this normal? Does this have something to do with how datasets are created that makes it work for a Dataset and Not other values? Any suggestions will be greatly appreciated, Thank, Chuck Tag: Visual foxpro Tag: 94020
  - 12
    - How to delete all rows in a dataSet, Update problems In ASP.net Is there a way of deleting all the rows in a table in the dataset. In regards to deleting all the rows is there a Delete/Remove function similar to the simple update function of an DataAdapter i.e objDataAdapter.Update(objDataSet, "TableName")? In relation to updating is there anyway to update into a column with spaces in its name using the simple update function - i.e objDataAdapter.Update (objDataSet, "TableName") Also is there a way finding out how many rows in a dataset? Thanks Tag: Visual foxpro Tag: 94015
  - 13
    - Questions on SQLXML Hello all, Newbie here and have a few questions. I wish to use the classes SqlXmlAdapter,SqlXmlCommand,etc in my ASP.NET project but when I add 'using Microsoft.Data.SqlXml', the IDE doesn't see the namespace. I tried to add the reference but I dont see it. 1. Why is that? Do I have to download and install SqlXml 3.0 SP2? Does that add the namespace? I searched for Microsoft.Data.SqlXml.dll on my hard drive and didn't find it. 2. If I do need to install this patch, why can I do a "Select * from Product FOR XML AUTO" and have it work already? Does SQL need this patch or is it a development thing. 3. What does this patch change. I don't mind installing it on my development PC but kinda worried about my production server. Can I uninstall this if anything goes wrong? 4. Production server is Windows Server 2003. I am using Windows Professional. Does WinSvr 2003 need this patch? 5. The patch has XML 3.0 in it. Is this install xml 3.0 or 4.0? I have already installed MSXML 4.0 on my production server, would installing this patch downgrade it to xml 3.0 if in fact it is install xml 3.0? Thanks Ralph Krausse www.consiliumsoft.com Use the START button? Then you need CSFastRunII... A new kind of application launcher integrated in the taskbar! ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg Tag: Visual foxpro Tag: 94013
  - 14
    - cannot refer to data table In the Page_Load event of web form, I create a DataSet and fill up by a DataAdapter. Then I can retrieve data by the following command : ds1.Tables(0).Rows(0).Item("accno") However, when I issue the same command in DataGrid1_SelectedIndexChanged, error occurs, Tables(0) cannot be reference. How can I fix it? Thanks. Tag: Visual foxpro Tag: 94006
  - 15
    - SqlDataAdapter & Stored Procedure Can we use SqlDataAdapter.InsertCommand or Delete, Uptade command with stored procedure ? For example: if i use this code then I get a error message Procedure : CREATE PROCEDURE SpDeneme AS DECLARE @Alan1 int INSERT INTO TblDeneme (Alan1) VALUES (@Alan1) GO Code: SqlCommand oCmdInsert = new SqlCommand(); oCmdInsert.Connection = Db.CNN; oCmdInsert.CommandType = CommandType.Text ; oCmdInsert.CommandType = CommandType.StoredProcedure; oCmdInsert.CommandText = "SpDeneme"; oCmdInsert.Parameters.Add("@Alan1", SqlDbType.Int,4,"Alan1"); oAdp.InsertCommand = oCmdInsert; oAdp.Update(oTbl); But if I use this code then all is ok. I use here CommandType.Text SqlCommand oCmdInsert = new SqlCommand(); oCmdInsert.Connection = Db.CNN; oCmdInsert.CommandType = CommandType.Text ; oCmdInsert.CommandText = "INSERT INTO TblDeneme (Alan1) VALUES (@Alan1)"; oCmdInsert.Parameters.Add("@Alan1", SqlDbType.Int,4,"Alan1"); oAdp.InsertCommand = oCmdInsert; oAdp.Update(oTbl); GD... Tag: Visual foxpro Tag: 94004
  - 16
    - DataSet.DataTable.FindBy() returns <undefined value> Hi! I have a table "USER" (in SQL database) with primary key "USR_ID" and DataSet filled with that table. When I call dataSet.USER.findByUSR_ID(x) it returns <undefined value>. What is the problem? <code> private void Page_Load(...) { checkBox1.checked = IsUser(); } public bool IsUser() { Decimal x = 1; DataRow temp = dataSet3.DP_USER.FindByUSR_ID(x); if (temp != null) return true; else return false; } </code> If I wrote to little of code to solve the problem, say what is missing. Best regards, Dejan Tag: Visual foxpro Tag: 94001
  - 17
    - can u pls suggest me, which is better hi my intention is to display absentees in a asp.net using vb.net from database first column as Name of the employee and follows on each column header as date, and below the rows with values. iam having a single table, consists of date,emp_name, i want this format ------------------------------------------------------------ No. EmpName 1 2 3 4 5 6 7 8 9 .....(dynamically dates).................... ------------------------------------------------------------- 1 emp1 x 2 emp2 x 3 emp4 x -------------------------------------- and some features, if i click empname it has to do something based on empid. if i go for datagrid, how should i get the top column no's with dates dynamically and results with the below column if i go htmltable, how should i generate. pls help me. thanks Tag: Visual foxpro Tag: 93999
  - 18
    - General network error - SqlInternalConnection.OpenAndLogin This is a multi-part message in MIME format. ------=_NextPart_000_0076_01C485C4.9954EB20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We are having some major issues with supisuous errors while using = Biztalk that we beleive may be linked to network issues or possibly a = bad NIC. So we wrote a small app to continuously "ping" - really it = issues a small select against a table - the DB every 2 seconds. We had = lots of errors crop up doing this. In doing so seemed to narrow some = issues down to ADO.NET's pooling along with problems in teh network. = Appearently if there were network issues and the pooled connection got = "hosed", the whole connection was doomed and we'd recieve errors = "General network errors" on the next attempt to use the hosed = connection. Now, we have disabled pooling and getting the below exception. Does = anyone know what normally causes this exception to occur out of the = "OpenAndLogin" method? Kevin -------------------------------------------------------------------------= ------- Event Type: Error Event Source: DatabasePing Event Category: None Event ID: 0 Date: 8/18/2004 Time: 6:04:35 PM User: N/A Computer:=20 Description: System.Data.SqlClient.SqlException: General network error. Check your = network documentation. at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection = connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at DatabasePing.DatabasePing._IssueSelect(String query, String = connectionString) at DatabasePing.DatabasePing._IssuePing(Object stateInfo) For more information, see Help and Support Center at = http://go.microsoft.com/fwlink/events.asp. ------=_NextPart_000_0076_01C485C4.9954EB20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DVerdana size=3D2>We are having some major issues with = supisuous=20 errors while using Biztalk that we beleive may be linked to network = issues or=20 possibly a bad NIC.  So we wrote a small app to continuously "ping" = -=20 really it issues a small select against a table - the DB = every 2=20 seconds.   We had lots of errors crop up doing this.  In = doing so=20 seemed to narrow some issues down to ADO.NET's pooling along with = problems=20 in teh network.  Appearently if there were network issues and the = pooled=20 connection got "hosed", the whole connection was doomed and we'd recieve = errors=20 "General network errors" on the next attempt to use the hosed=20 connection.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Now, we have disabled pooling and = getting the=20 below exception.  Does anyone know what normally causes this = exception to=20 occur out of the "OpenAndLogin" method?</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Kevin</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2> <HR> </FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Event Type: Error<BR>Event=20 Source: DatabasePing<BR>Event Category: None<BR>Event=20 ID: 0<BR>Date:  8/18/2004<BR>Time:  6:04:35=20 PM<BR>User:  N/A<BR>Computer: <BR>Description:<BR>System.D= ata.SqlClient.SqlException:=20 General network error.  Check your network = documentation.<BR>  =20 at = System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()<BR> &nbsp= ; at=20 System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection = connection,=20 SqlConnectionString connectionOptions)<BR>   at=20 System.Data.SqlClient.SqlConnection.Open()<BR>   at=20 DatabasePing.DatabasePing._IssueSelect(String query, String=20 connectionString)<BR>   at = DatabasePing.DatabasePing._IssuePing(Object=20 stateInfo)</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2>For more information, see Help and = Support Center=20 at </FONT><A href=3D"http://go.microsoft.com/fwlink/events.asp"><FONT = face=3DVerdana=20 size=3D2>http://go.microsoft.com/fwlink/events.asp</FONT></A><FONT = face=3DVerdana=20 size=3D2>.<BR></FONT></DIV></BODY></HTML> ------=_NextPart_000_0076_01C485C4.9954EB20-- Tag: Visual foxpro Tag: 93998
  - 19
    - ADODB Fails with Run-time error '-2147024769 (8007007f) Hi, this is simple access 2000 stuff. Sub OpenDB() Dim strConn As String Dim objConn As New ADODB.Connection strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\aspdatastore\database.mdb" objConn.Open strConn * * Do something here * Set objConn = Nothing End Sub I have three systems with access2000 on them. Two of them work as expected. One system fails with a Visual Basic Run-time error Method 'Open' of object '_Connection' failed. I've run MDAC 2.8 and Jet service pack 8 upgrade to no avail. Has anyone got any ideas ? Taa. AndyB Tag: Visual foxpro Tag: 93997
  - 20
    - NaN (Not a number) and DataSet I have a typed dataset with a field (represented as an xml attribute) of type float (xs:float). The value is at some point float.NaN (Not a number). I do: myDataSet.WriteXml(theNameOfTheXmlFile, XmlWriteMode.IgnoreSchema); In the xml file, this is now represented as: MyNameSpacePrefix:MyFloat="NaN" So far so good, but when I try to read this xml file into the dataset later, by: myDataSet.ReadXml(theNameOfTheXmlFile, XmlReadMode.IgnoreSchema); a System.FormatException (additional text: Input string was not in a correct format) is thrown due to this "NaN". Anyone knows if it is possible (and how) to read back a "NaN" from an xml file and make it be represented as float.NaN ? Tag: Visual foxpro Tag: 93996
  - 21
    - Creating New Row When using own columnStyle Hi, I am new in using the DataGrid that windows has provided. I have a question that when I have set Property of AllowNew for the DataGrid as ((DataView)this.ListManager.List).AllowNew = true it will automatically creates a DataRowView whenever i changed the row. But the problem i am getting is that when i have created my own ColumnStyle for the grid with some UserControl...when the focus is on that control it is not creating any new row... can anyone help me regd. this issue. Thanx Tag: Visual foxpro Tag: 93994
  - 22
    - Problem with DataView.RowFilter Property (.NET Framework) Hi, I'm trying to use the RowFilter property...but with no luck... Dim pdstSample As New DataSet pdstSample.Tables.Add(New DataTable("tblSample")) Dim pdtbSample As DataTable = pdstSample.Tables(0) pdtbSample.Columns.Add(New DataColumn("fldSample")) Dim pdrwSample As DataRow = pdtbSample.NewRow() pdrwSample(0) = "Sample" pdtbSample.Rows.Add(pdrwSample) pdrwSample = pdtbSample.NewRow() pdrwSample(0) = "Elpmas" pdtbSample.Rows.Add(pdrwSample) Dim pdvwSample As New DataView(pdtbSample) MsgBox(pdvwSample.Table.Rows.Count) pdvwSample.RowFilter = "fldSample = 'Sample'" MsgBox(pdvwSample.Table.Rows.Count) The two msgbox lines return 2 even though it should filter 1 row...please help....... Jag Tag: Visual foxpro Tag: 93992
  - 23
    - Removing repetivite code for connection, trans, exeception etc. I have a lot of code which follows the general pattern below. Is there an easy (or hard) way of avoiding repeating the same code over and over. I do need to manage the connection at this level, but I am worried developers will forget to commit and/or close the connection. If I could auto wrap around it somehow..? public void SomeUpdate() { OracleConnection connection = null; OracleTransaction trans = null; DataSet ds = null; try { connection = GetConnection(); trans = connection.BeginTransaction(); //6-10 lines of code trans.Commit(); connection.Close(); } catch (Exception e) { trans.Rollback(); connection.Close(); LogError(this,e.Message + Environment.NewLine + ids); throw new Exception(e.Message + Environment.NewLine + e.StackTrace.ToString()); } } Tag: Visual foxpro Tag: 93988
  - 24
    - Insert data from TataTable to a table in SQL I am trying to insert all the data in DataTable to a table to the SQL Server. I looked around the internet and found ways to insert row by row. Rather than doing this way, I want to simply "copy" data to a table in the SQL Server. If possible, it would be convenient if the table is also created. I cannot use Select Into because I don't think I can use that statement from DataTable. If you know a good way to copy table, can you let me know? Thanks! Tag: Visual foxpro Tag: 93986
  - 25
    - Probelm Quering Access Database Hi, i have a query that works normal from access query window but when i execute if from my code with cmd.executereader it give me error "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect." the query is below, if someone is interested Thanks in advance!! SELECT a.MACH AS MACHINE, a.ST AS STATE, ROUND(a.DURATION1/(60*60), 2) AS DURATION, ROUND((a.DURATION1/b.DURATION2)*100, 2) AS PERCENTAGE, a.OCC AS OCCUR, a.YEAR, a.PNUM, a.PERIODSTART, a.PERIODEND FROM (SELECT MACHINE AS MACH, STATE AS ST, SUM(OCCUR) AS OCC, SUM(DURATION) AS DURATION1, DATEPART('yyyy', CURDAY) AS YEAR, DATEPART('m', CURDAY) AS PNUM, MIN(CURDAY) AS PERIODSTART, MAX(CURDAY) AS PERIODEND FROM test_DCXTMP WHERE CURDAY BETWEEN #2004-3-1# AND #2004-3-15# AND MACHINE = 'ARS' GROUP BY MACHINE, STATE, DATEPART('m', CURDAY), DATEPART('yyyy', CURDAY) ) as a INNER JOIN (SELECT MACHINE AS M, SUM(DURATION) AS DURATION2, DATEPART('yyyy', CURDAY) AS YEAR, DATEPART('m', CURDAY) AS PNUM FROM test_DCXTMP WHERE CURDAY BETWEEN #2004-3-1# AND #2004-3-15# AND MACHINE = 'ARS' GROUP BY MACHINE, DATEPART('m', CURDAY), DATEPART('yyyy', CURDAY) ) as b ON a.MACH = b.M AND a.YEAR = b.YEAR AND a.PNUM = b.PNUM ORDER BY a.YEAR, a.PNUM Tag: Visual foxpro Tag: 93983
- Next
  - 1
    - updatestatus.skipcurrentrow I'm using the following code per kb313540 but i keep getting an error: a.. Check and update each row manually instead of using the AcceptChanges method on the DataSet. a.. Use the RowUpdated event of the DataAdapter object and skip the duplicate rows. If e.StatementType = StatementType.Insert Then e.Status = UpdateStatus.SkipCurrentRow a.. The error i'm getting is: expression does not produce a value (Visual Studio.Net 2003 has an line under "updatestatus"a.. Any ideas?? Thanks for your help!a.. Chris Thunella.. cthunell@pierceassociates.com Tag: Visual foxpro Tag: 93982
  - 2
    - OleDb Insert Query Hi all, Having a lil problem with the OleDbConnection + Command. The whole thing is done im c# and uses Access datbase, it builds a SQL string from stuff that user typed in then calls OleDbCommand.ExecuteNonQuery with the folowing string. "INSERT INTO Trans (rID, [Number], Price, [Date], Month, Year, [Percent]) VALUES (6,1,5.95,18,8,2004,100)" at which time the try-catch wraping comes up with an error "Synatx error in INSERT INTO statement". I have tryed putting that string directly into MS Office Access and it executes perfectly......so wheres the problem? Thank you! Tag: Visual foxpro Tag: 93981
  - 3
    - SQLDMO attachDB error with filenames including space character Hey everyone! I'm trying to use SQLDMO to programmatically attach a database. I have a problem when the file name includes a space character, for example: @"C:\Program Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" Here's a sample of code: string tmp = @"C:\Program Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking.mdf" +"," +@"C:\Program Files\Microsoft SQL Server\MSSQL\Data\DM_0814_ABCTrucking_log.ldf"; SQLDMO.SQLServer sqlDMOConn = new SQLDMO.SQLServer(); sqlDMOConn.Connect("(local)", "sa", ""); sqlDMOConn.AttachDB( "DM_0814_ABCTrucking", tmp ); When I do this, the AttachDB call raised the following exception "Device Activation Error. The physical file name 'C:\Program' may be incorrect." I think what's happening is that SQLDMO doesn't like the space character in the filenames. How can I formulate the file name correctly? --steve Tag: Visual foxpro Tag: 93980
  - 4
    - Mail problem Hi ! I have 2 textboxes that I use on my site to let people send mail to their friends for promotion. They fill in their name and their E-mail. Now the question..! This is how it looks, I use ordinary SMTP mail : objMM.To = tboxTipsEmail.Text objMM.From = tboxTipsName.Text Is this the right way to do it or must I have it like : objMM.To = "donald.duck@hotmail.com" objMM.From = tboxTipsName.Text It works without errormessages but the mail doesn´t arrive to "objMM.To = tboxTipsEmail.Text". OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Visual foxpro Tag: 93973
  - 5
    - Alter Table Add Column Trying to implement this for an Access.mdb file. It worked on development machine but failed on two user machines. Dim alter As OleDb.OleDbCommand daConn.Open() alter = New OleDb.OleDbCommand("ALTER TABLE BillableTimesheet ADD COLUMN Submitted BIT", daConn) Try alter.ExecuteNonQuery() Catch ex As Exception MessageBox.Show(ex.Message) End Try daConn.Close() Tag: Visual foxpro Tag: 93969
  - 6
    - Help: SQL syntax error??? When I run an SQL statement with ADO.NET it gives me this error: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at DMSI.SqlHelper.ExecuteSql(String strSql, String strCnnString) in c:\inetpub\wwwroot\DMSI\SqlHelper.vb:line 9 When I copy/paste the SQL directly into an Access query and run it it runs PERFECT. Here's the SQL: INSERT INTO Employees(EmployeeId,TitleId,FirstName,MiddleInitial,LastName,Address,City,S tate,Zip,CellPhone,Fax,EmailAddress,UserName,Password,RegionalDirectorId) VALUES(8,3,'c','c','c','c','c','c','c','c','c','c','c','c',6); Ideas? Thanks! Tag: Visual foxpro Tag: 93964
  - 7
    - Generic DataBase Tool I'm new to .Net and need to create a generic (free) way to update lookup tables in SQL Server (using C#) in ASP.Net pages. I found an article at: http://www.dotnetjunkies.com/Tutorial/0C968B48-44E8-4637-9F19-8490B0429881.dcik which explains how this can be done but does not supply enough example code my newbie self to go through in detail where I understand it. So, does anyone have some example code I could use to accomplish this or know where I can find something to get me started? Thanks, Jeff Tag: Visual foxpro Tag: 93961
  - 8
    - Problems with extracting Data from DataRow Hello everyone, I have a DataSet in which I have extracted a row, within the row there is a column called "Text". This is taken from a table within SQL 2000 whose column has a data type of "text". When I try to retrieve the value using row["Text"].ToString() It retrieves a blank string. However when I use row[3].ToString() the command works. I cannot understand why using row["Text"] does not, I have looked at the row variable through the watch and column 3 has a "_columnName" equal to "Text". When I try the other columns using the field name to extract the value works. However it does not with the column named "Text", does anyone have any idea why as I am completely stumped. Many Thanks in advance for your answers Phil Tag: Visual foxpro Tag: 93956
  - 9
    - Cannot Initialize SSPI Package I had the same problem, suddenly my ASP.NET will stop working connecting to SQL Server (Especially after the security updates from Microsoft (automatic)). I installed SP3A, things are back again normal. Tag: Visual foxpro Tag: 93953
  - 10
    - command object hi, iam using vb.net code this is my stored procedure in sql server. create proc t1 (@q as int) as select * from test where id=@q GO ------ i am using vb.net code below like this Dim s As SqlClient.SqlDataReader Me.SqlCommand1.Parameters("@RETURN_VALUE").Direction = ParameterDirection.Output Me.SqlCommand1.Parameters("@q").Value = 1 s = SqlCommand1.ExecuteReader Do Until s.Read MsgBox(s(0)) Loop iam wondering how come iam not able to display msgbox, even though the data is there. any changes in the code need or any changes in the stored procedure. where should i change... thanks Tag: Visual foxpro Tag: 93951
  - 11
    - Parameter Field Order Does anyone have any expreience with the order of fields in a OleDb INSERT command being significant. It seems that db.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("INSERT INTO StagesProcessing (ptrOrder,StageDate,fromStage,toStage) VALUES (@p_ptrOrder,@p_StageDate,@p_fromStage,@p_toStage)",cn); will work but db.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("INSERT INTO StagesProcessing (ptrOrder,fromStage,toStage,StageDate) VALUES (@p_ptrOrder,@p_fromStage,@p_toStage,@p_StageDate)",cn); will not work? ptrOrder is a GUID fromStage is a TEXT toStage is a TEXT StageDate is a DATETIME the database is Access 2002 I've never had any problems using dates before. Thanks Tag: Visual foxpro Tag: 93950
  - 12
    - Selecting table in typed dataset Hello. I've populated a typed dataset and now I only want to bind one of the tables inside to datagrid - how is this accomplished? My code: private void FillDataGridTDS() { BLTask blTask = new BLTask(); DSTaskSchedules dsTaskSchedules; blTask.GetAllTasks(out dsTaskSchedules); // dsTaskSchedules is holding all my tables with relation etc. And now i only want to use one of these tables as a datasource. dgTasks.DataSource = dsTaskSchedules; dgTasks.DataBind(); } This is a snippet from my presentationlayer. And I dont want to set the datamember of the datagrid in this layer. So it's to be done in the BLL :O) The BLL: public void GetAllTasks(out DSTaskSchedules dsTaskSchedules) { dsTaskSchedules = null; DATask daTask = new DATask(); daTask.PopulateTDSTaskSchedules(out dsTaskSchedules); dsTaskSchedules.DataSetName // dsTaskSchedules is holding all my tables with relation etc. And now i only want to use one of these tables as a datasource. } Kind regards Tag: Visual foxpro Tag: 93943
  - 13
    - 836874 hotfix / problem under windows xp Hi, one of my applications has the problem described in KB article 836874. As the application is running under Win2000, WinXP and Win2003 and the patches are only available for Win2000 and Win2003 (according to German MS Support sources) I cannot solve the problem for WinXP systems. Does anyone know if there is a workaround: applying the Win2000 oder Win2003 patch ? Appreciating any help. Thanks in advance, Frank Tag: Visual foxpro Tag: 93942
  - 14
    - How to make the binding active? have a form with a TabControl with two TabPages and a TextBox control on each TabPage. Each of the TextBoxes are bound to a datasource like TextBox1.DataBindings.Add("Text", MyObject, "FirstName"). The problem is that the binding of the TextBox on the *second* TabPage is not active immediately (IsBinding = False), it only becomes active once the second TabPage is clicked?? This means that if I have a button on the form that does a MsgBox(TextBox2.Text) the Text is nothing until I click on the second TabPage. Any help on this question would be appreciated! Thanks, Thomas Tag: Visual foxpro Tag: 93940
  - 15
    - Help with SQL problem: match where other record is flagged I need help with a SQL problem. This is "problem" as in like math problem. (And no, this isn't for class, it's a contract that I've lost a lot of time on by spending it pulling my hair out.) I have a database with one catch-all table, something like as follows: string Username string Key string SubKey bool/bit BoolValue int IntValue A unique record is determined by Username + Key + SubKey. I have two sets of many records. The first set looks like this: [username], MyBoolValueRecord, [subkey], [1/0], [null] The second set looks like this: [username], MyIntValueRecord, [subkey], [null], [#number#] The problem that I'm having is that I need the second set to be directly corresponding the first set, so that I only retrieve the [subkey] + [username] values of [key:MyIntValue] where [username] + [key:MyBoolValue] + [subkey] is 1/true, and ignore the [subkey]+[username] values of [key:MyIntValue] where [username] + [key:MyBoolValue] + [subkey] is 0/false. Since I have to refer to separate records of the same table, I cannot use JOIN (can I?). Surely this can still be done with a single SQL query? I can settle with a stored procedure if I have to, but I'd prefer not. I've tried WHERE ... IN (SELECT...), but that only supports one field match and I need both [username] and [subkey] to match. Sorry if this is hard to follow ... now you know my plight!! Thanks, Jon Tag: Visual foxpro Tag: 93924
  - 16
    - DataSet Select or Dataview Filter gives max performance???? Hello all.. i've got 2 options 2 filter my data in a dataset....either user Select method of the dataset or create a dataview and then apply the filter criteria....Which gives the maximum performance...can anybody help?? smiles, Laiju Tag: Visual foxpro Tag: 93923
  - 17
    - RowFilter - HowTo? Hi, I have a DataGrid bound a DataSet containing a Number of tables. The DataGrid contains a singles DataTableStyle mapped to one of the tables. I would like to be able to dynamically constrain the DataTableStyle to a subset of the rows in the DataSet. Can RowFilter be used to do this is how? TIA Steve Tag: Visual foxpro Tag: 93922
  - 18
    - how to loop through a data table I use data adapter to fill up data set. How can I count the no. of record, which matches a specific condition, of a data table in a data set? And how can I loop through the data table? Thanks. Tag: Visual foxpro Tag: 93917
  - 19
    - Merge() confusion hello folks, I have one dataset that I have modified (update, insert, delete). I also have another dataset that I just reload fresh from the database. Both datasets come from the same table. The idea with merge is to merge the modified dataset and new dataset together with preserving the changes made to the old one. When I do that, i got duplicate result instead of the merged one. What did I do wrong? -Agung Tag: Visual foxpro Tag: 93916
  - 20
    - System.invalidOperationException I have 2 data adapters, 1 connection , and one data set. I use the same connection for all this data adapters. I'm using an access database and windows forms when I change from one record to other on the table JOBS it triggers one event. In this event, I have a code like System.Windows.Forms.BindingManagerBase bc; bc = this.BindingContext[this.ds1, "jobs"]; this.ds1.WorkEmp.Clear(); if (bc.Count>0) { System.Data.DataRow drv; drv = this.ds1.jobs.Rows[bc.Position]; this.daWorkEmp.SelectCommand.Parameters["njob"].Value=Convert.ToInt16(drv["njob"]); try { this.daWorkEmp.Fill(this.ds1.WorkEmp); // ERROR HAPPENS HERE } catch (Exception e3) { MessageBox.Show(e3.ToString()); return ; } } I got this message "System.invalidOperationException: there is already an open DataReader associated with this connection which must closed first" WorkEmp.SelectCommand is like SELECT b.firstname, b.lastname, a.empid, a.njob, b.empid AS Expr1 FROM WorkOn a INNER JOIN employee b ON a.empid = b.empid WHERE (a.njob = ?) I'm missing something??? I use the same logic in other modules and it works. I'm not using any DataReader!!! i'm not opening or closing by code the connection!! TIA Tag: Visual foxpro Tag: 93914
  - 21
    - DataView.Sort Dilemma - A bit long I have a dataset contining sorted data in mutilple tables from which I am selecting rows to action. I use the Find method of the DefaultView from a specific Table to get the position of a row in the table. I then set the position of the BindingContext to action the row. eg. Table.DatafaultView.Sort = "ColumnName" pos=Table.DatafaultView.Find(key) BindingContext(DataSet,Table).Position = pos This works fine to switch between existing rows. When I add a row to the DataSet (without updating the DataAdpter, because I don't want to save the changes at this point) the above method returns incorrect rows. eg. If the existing data looks like this pos Key ------------ 0 123 1 234 2 345 and I then add the record 111 pos=Table.DatafaultView.Find(111) will return 0 as it should. BindingContext(DataSet,Table).Position = 0 will bind to 123 pos=Table.DatafaultView.Find(123) will return 1 BindingContext(DataSet,Table).Position = 1 will bind to 234 So it appears that the data in the DataSet looks like pos Key ------------ 0 123 1 234 2 345 3 111 Is there something I need to do, after an Table.Rows.Add(row), to the DefaultView or DataSet to have it rebuild its sort index? TIA Steve Tag: Visual foxpro Tag: 93913
  - 22
    - Ideas on storing and retriving files in a Windows Application I'm looking for some ideas, I have a project to complete that has a requirement to store just about ANY type of document. Most common documents include Word, Excel, HTML, images, pdf, media files, etc. I was thinking of storing these into SQL Server 2000 as image type but my delimma lays with retrieval. I was thinking of using a Microsoft Web Browser control to display the item to the user. This works ok for 2 reasons, 1. The browser will open the appropiatte application to display the file and 2. I can just use the Navigate(2) method to display the item. The problem with this I don't want the requirement of storing the item to a file (filestream) before displaying (Navigate needs somewhere to go). I was thinking of memoryStream but I see no good examples (other than image files) on how to do this, espcially on how to handle large files. Is this a good approach? Or should I just stick with files stored on the server? THANKS -- Ken Beard MCSD, MCP Tag: Visual foxpro Tag: 93905
  - 23
    - How call crosstab query in Access I have a crosstab query that I've created in MS Access. How do I run the query and stick the results into a datatable using ado.net? Can I reference the query just like a regular table? Tag: Visual foxpro Tag: 93902
  - 24
    - DataSet Losing Data when Column Name Contains Colon Hi, Somebody else has posted something in regards to this before, but that was back in 2002. You can see his post at: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=0f0c01c233f2%24988a7c30%24a4e62ecf%40tkmsftngxa06&rnum=4&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26q%3Ddataset%2Bcolon%2B.net Microsoft has also made mention of this same problem. You can see Microsoft's FIX at: http://support.microsoft.com/default.aspx?scid=kb;en-us;818962 The FIX was posted in late 2003, but I have not seen any resolution to the problem. The problem must still exist since I am experiencing it today (2004). So, my problem is this: I have a dataset that gets populated by calling multiple stored procedures. The dataset is successfully populated. The stored procedure returns column names that contain colons (":"). When I do WriteXml(fileName, WriteSchema), I the dataset is saved successfully. When I load the file back, using ReadXml(fileName, ReadSchema), the dataset (its datatables, rather) have appropriate structures. The problem, though, is that the datatables that have column names that contain colons, result in the column being completely populated with DBNULL. I need help finding a work around to this. Any help is greatly appreciated. Keep in mind that I cannot change the stored procedure (in order to return appropriate column names). I hope I was clear as to what my problem is. Again, any help is greatly appreciated. Regards. Jacques Tag: Visual foxpro Tag: 93900
  - 25
    - know the MappingName of a clicked Column in a Parent-Child DataGrid Hi, I have in my VB.NET-application a DataGrid with two DataTables in with a Parent-Child-relationship defined. When the users clicks on a call in the DataGrid, i want to know the MappingName of the Column. This is easy with only one table, but with 2 tables defined I'm not able to know on which Table the User is currently looking (the parent of the child), so I don't know if I should look at the Parent-tablestyle or the Child-tablestyle for my mappingname. does anybody has any suggestions how to know on which Table the user is lookin,g or how to find the MappingName without any need of the TableStyle or soething else? Thanks a lot in advance! Pieter Tag: Visual foxpro Tag: 93895

can anyone help me with using ado.net to connect to visual fox pro tables.
i believe i am just missing the connectstring informaiton.
i can not seem to find any thing on this.

any help would be greatly appreciated

tony

Top

Re: Visual foxpro by Cindy

Cindy
Fri Aug 20 10:15:57 CDT 2004

Hi Tony,

Check out http://www.able-consulting.com/ADO_Conn.htm .

As an alternative, use Notepad to create a file called MyConn.udl. Then you
can double click on the file to set up the connection. Save and open again
with Notepad and copy the connection string you made.

The tricky part is knowing whether to connect to a DBC or use the free table
option. Generally, if a DBC is present you want to use that option,
otherwise use the free table option.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

"T Perkins tperkins@rogersandhollands.com>" <<nospam> wrote in message
news:eWIhrxrhEHA.2624@TK2MSFTNGP12.phx.gbl...
> can anyone help me with using ado.net to connect to visual fox pro tables.
> i believe i am just missing the connectstring informaiton.

Top