ms access & ado.net

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

Hello

I have been developping datadriven applications for a while now. I used sql
server and msde.
but I am on the hunt for an integrated database for a web application I want
to write: what I mean is I want to have a file based DB engine (if possible)
and include the file in a directory of the web app and access it. I just do
not want to deal with the install of a service when redistibuting the app.
I am considering ms access but I want to know if I could have multiple
connections to it via ado.net since the web app will have multiple users
hiting it. I guess that my first question.
the other one is :
Does any body know of an file integrated DB engine ? I am looking at
vistaDB and deseperatley looking for some xml based ones ?

Top

Re: ms access & ado.net by Miha

Miha
Tue Jan 20 15:55:41 CST 2004

Hi simo

The commercial one:
http://www.turbodb.de/en/turbodb/dotnet.html
there is also mySql - i believe that they have an embedded version
http://www.mysql.com/
Plus, there is Firebird (sourceforge son of Interbase) - FREE
http://firebird.sourceforge.net/
The .net provider guy will/has been working on .net provider for embedded
version.

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

"simo sentissi" <simo_sentissi@skc.edu> wrote in message
news:eJstPn53DHA.1752@tk2msftngp13.phx.gbl...
> Hello
>
> I have been developping datadriven applications for a while now. I used
sql
> server and msde.
> but I am on the hunt for an integrated database for a web application I
want
> to write: what I mean is I want to have a file based DB engine (if
possible)
> and include the file in a directory of the web app and access it. I just
do
> not want to deal with the install of a service when redistibuting the app.
> I am considering ms access but I want to know if I could have multiple
> connections to it via ado.net since the web app will have multiple users
> hiting it. I guess that my first question.
> the other one is :
> Does any body know of an file integrated DB engine ? I am looking at
> vistaDB and deseperatley looking for some xml based ones ?
>
>
>

Top