Do DataTable's in ASP.NET 2.0 support "blob" datatypes?

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
    - Copy a table using ADO.Net OK, I think the answer is no, but I need to ask. I have a table structure defined in my Access database (SQL Server is not available), I would like to take that table and create a new table with a unique name. Can I do this using ADO.NET? Thanks, Dave Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119902
  - 2
    - Newbie with Database Connection Problem Hi, Wonder if Somebody could help me? I`ve been searching all over for a solution but am totally lost. I have a Class called Connection as below: Public Class Connection Private Shared mConnectionsstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" Private Shared mLocation As String Private Shared connArray As ArrayList Public Shared Sub setString(ByVal ind As Integer) Dim connArray As New ArrayList connArray.Add("J:\Database\MasterDB.mdb") connArray.Add("J:\Database\TestDB.mdb") mLocation = connArray(ind).ToString End Sub Public Shared ReadOnly Property [String]() As String Get Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mLocation & ";" End Get End Property End Class On my Main Form I have my Database Connection Setup as: Dim UP As New OleDb.OleDbCommand() Dim Con As New OleDb.OleDbConnection() Connection.setString(Me.cboSelectDB.SelectedIndex) Con.ConnectionString = Connection.String UP.Connection = Con UP.CommandType = CommandType.Text UP.CommandText = "Select * From Passwords Where Users_Name=? and Users_Password=?" End Sub But when I run my App it Errors on line "mLocation = connArray(ind).ToString" with the following error: "Additional information: Index was out of range. Must be non-negative and less than the size of the collection" Anybody point me in the right direction? Many Thanks in Advance Regards Not_So_Clever Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119899
  - 3
    - Adding deleted rows back to a DataTable I'm trying to add rows marked as deleted back into their parent DataRowCollection by using DataRowCollection.Add. The behavior I was expecting was having the DataRowState switch back to it's last value before the delete, i.e. Unchanged->Deleted->Unchanged, Modified->Deleted->Modified, etc. Instead I get an ArgumentException with the message "This row already belongs to this table." Obviously the row does belong to the table, however it is not currently part of it's row collection. How would I go about implementing this? I know I can use RejectChanges but that will revert the state back to the last Original, which will undo any field changes as well. All I want to do is undo the last Delete action. I was considering adding a duplicate new row and loading the deleted row's values into it, but that might result in constraint violations when running the related stored procedures against the data source. Thanks in advance. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119893
  - 4
    - Hierarchical search of tree flattened to dataset--advise pls I have a search problem that I'm seeking some advice in. I'm dealing with the need to search node names in a tree structure that is flattened into a database table (I have no say over the design, just over how to search). The tree consists of nodes that represent rooms, cabinets in each room, drawers in each cabinet, etc. The flattened representation is as what you would expect--each data row has a column representing the room, cabinet, drawer, etc. When I search this data, I need to do it in a hierarchical fashion--I look at the first room, then the first cabinet in that room, then the first drawer in that cabinet, etc. If I search the dataset linearly, I end up showing the same hit multiple times (if I hit on the room name, once I finish showing hits on that row, I encounter the room again the next row). I could, once a hit is found, move vertically down the column in the dataset, erasing all names that match, but that isn't easily done without performing multiple checks to make sure I'm still in the same branch of the tree. Any hints on a better way to perform this search would be appreciated. I could convert the data to xml and use xpath, or create a normalized dataset and fill it appropriately, but I'm not sure this will ease the search later. Thanks. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119890
  - 5
    - SQL Server Raiserror and .NET SqlDataAdapter Running SQL Server 2000 SP4 and .NET Framework 1.1.43322 SP1 I have a trigger that does some work and then, when it decides there is a problem does: if @ErrMsg is not null BEGIN RAISERROR (50001,16,1, 'AssetConfig', 'AssetKey/Site', @ErrMsg) ROLLBACK transaction In my Windows Forms application I have try { SqlTransaction sqlTrans = â?¦.BeginTransaction(); Update several tables, including the one with the trigger sqlTrans.Commit(); } catch (SqlException e) { sqlTrans.Rollback(); } When the trigger raises the error, I do not get the @ErrMsg because the SqlDataAdapter does not trap the error. Instead, I get System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.Rollback() at the Rollback statement. This is because the Commit threw this SqlException Message # 3902 "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION." What I WANT is to have the SqlDataAdapter.Update throw the error that I have specified, just as it would do if, for example, a primary or foreign key had been violated. Then the catch block would do the rollback and handle the error. I tried taking the Rollback out of the trigger, but then I got no message, no error, and the database was updated with bad data. What is the secret to making SQL Server Raiserror work with the Framework to return a meaningful error? Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119889
  - 6
    - Data Grid - Style Hi All! How can i add styles like combo box, checkbox in my datagrid control TIA Viswanathan S Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119884
  - 7
    - Datagrid - format Hi All! I want to display the currency symbol in the datagrid for all the rows of the salary (currency) field. How to do this? 'This is my sample code Dim cm As New OleDbCommand Dim da1 As New OleDbDataAdapter Dim ds1 As New DataSet Try cm.CommandText = "select distinct d.dept_name as deptname ,sum (e.salary) as salary from department d ,employee e where d.dept_id=e.dept_id group by d.dept_name" cm.Connection = Con da1.SelectCommand = cm da1.Fill(ds1, "employee") dg.DataSource = ds1.Tables("employee") Catch ex As Exception MsgBox(ex.Message) End Try TIA Viswanathan S Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119883
  - 8
    - build SQL text from SqlCommand Hi, is it possible to retrieve exact sql text which will be executed from a prepared SqlCommand or DBCommand? I need this for logging all activity. Something like this would be helpfull: Command.CommandText = "ExecProc" Command.Paramaters.Add..... SQL = Command.GetInternalSql 'or Command.GetType.InvokeMember ("GetInternalSql") Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119874
  - 9
    - vs2k5 Beta2 'Code Analysis' returns warnings on generated code I built a simple Data Access Layer with the Visual Studio 2005 DataSet Designer using the wizard. All who I have talked to who use it, articles I haver read by those who use it speak very highly about the quality of code that vs2005 creates. Before adding any code of my own I ran "Code Analysis" (from debug menu) against the code and got (no errors but) 90 warnings! I know nothing about the "Code Analysis" and can find nothing in the help. Some of the warnings are just good suggestions that the user should consider based on best coding practice and the users intension for the code such as; Warning 4 CA2210 : Microsoft.Design : Sign 'NorthwindDataAccess' with a strong name key. 1 Other warnings point out things I think the Wizard should have handled; Warning 42 CA1804 : Microsoft.Performance : EmployeesTableAdapter.GetData(Nullable`1<System.Int32>):EmployeesDataTable declares a local, 'GetData', of type NorthwindDataAccess.EmployeeDataSet+EmployeesDataTable, which is never used or is only assigned to. Use this local or remove it. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1229 NorthwindDataAccess More Examples: Warning 10 CA1801 : Microsoft.Performance : The 'this' parameter (or 'Me' in VB) of EmployeeDataSet.ShouldSerializeEmployees():Boolean is never used. Mark the method as static (or Shared in VB) or use 'this'/Me in the method body. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 188 NorthwindDataAccess Warning 48 CA1709 : Microsoft.Naming : Correct the casing of parameter name 'LastName'. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1333 NorthwindDataAccess Warning 89 CA1706 : Microsoft.Naming : 'Id' is an abbreviation and therefore is not subject to acronym casing guidelines. Correct the capitalization of 'ID' in parameter name 'EmployeeID' by changing it to 'Id'. C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\NorthwindDataAccess\NorthwindDataAccess\EmployeeDataSet.Desig= =ADner.vb 1460 NorthwindDataAccess Can anyone who knows more about this comment on this feature and the results I am getting.=20 Thank you,=20 dbuchanan Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119873
  - 10
    - Concurrency management in XML Files Hi, I was wondering how it is possible to manage optimistic concurrency in XML files. Indeed, i store my data in xml files in an asp.net application. My data access layers accepts custom entities, and then uses dataset.WriteXml() to write the new data. The problem is that this way of doing erases all file content, and writes the content of the dataset. If a user wrote his changes just before we write ours his changes are lost. Is there a simple way to manage optimistic concurrency, like what we can do with a DataAdpter with SQL databases? Thanks a lot for your help PS: I use .net v1.1 ;) Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119870
  - 11
    - Where namespace have ObjectSpace? Where namespace have ObjectSpace? I need to write application using ObjectSpace, but I cannot find it on VS.NET 2005. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119863
  - 12
    - Some newbie questions Hi All Wondering if someone might have a few seconds to clear up some newbie queries I have with VB.NET and ADO.NET. I know their are limitless situations that require different approaches but would love to know some of the fundementals as a place to start. Have been through quite a few examples but are unsure about the following. 1. For a simple database with a couple of tables do you create a dataadapter for each table and then create a dataset that includes each of these tables? 2. Do you use the same adapters and datasets througout the application on different forms? If so how do you make them available to the other forms if you have used the wizard to create them? 3. Is it best to reference rows/records by ID number in the table or the row index? 4. Should you link tables in the database using views/queries in the database or by creating a separate datatable in the dataset that joins the tables from the database? 5. Any other advice on best practices for learing this stuff. Appreciate any assistance. ilr Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119858
  - 13
    - calling a stored procedure in ADO.NET 2.0 How can I calling a stored procedure (say "sp_example") in ADO.NET 2.0? I used to do this in ADO.NET 1.1, but in 2.0 (beta2 vs2005), after the following ... sqlConnection con = new sqlConnection(strCon) sqlCommand cmd = sqlCommand("sp_example", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.??? under the Parameters property, I only find the AddRange() and AddWithValue() method, but not the Add() method which is in ADO.NET 1.1. Does anyone have an idea how to call a stored procedure in the new 2.0 framwork? Thanks in advance. David Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119856
  - 14
    - How do I retreive warnings? If I do something like this: SqlConnection connection = new SqlConnection( ... ) SqlCommand command = new SqlCommand( ... ) // initialize command object. command.ExecuteNonQuery(); How do I determine if the sql server generated a warning, and how do I "read" the warning? Thanks in advance, Peter Strøiman Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119850
  - 15
    - Datagrid forecolor from dataview. Hi, How do I associate a column in the dataview with a color property of datagrid forecolor, more specifically a particular cells forecolor. I'm associating a dataview with the datagrid and the values are showing OK. But I want the fore color of a cell being set on specific condition. I'm thinking of adding a new column to the table which has an expression to determine the color. And if this is associated with the cell fore color, it should work great as I just need to keep on updating the data. I tried but couldn't find a way to do this. Any help would be of great use. Thanks in advance, Gobi. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119848
  - 16
    - question i use enterprise services for having transaction management. i use one transactional component that is creating an ado.net connection, and i pass this connection to not enterprise services components to use and have transaction control in a central place in the project. i can commit or rollback the operations from outside those objects. as i tested this works. i need to work this way since my programming model requires the use of friend properties/methods that are not supported by enterprise services. is there some reason why not to work this way? TIA! Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119847
  - 17
    - System.Data.OleDb.OleDbException: Unspecified error My ASP.NET web page was working just fine connecting to an Access DB and displaying data in a DataGrid. Couldn't be much simpler really. Then, I had to move the page and its underlying database file to a new server. Now it ceases to work and gives me ... Unspecified error 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.OleDb.OleDbException: Unspecified error It is NOT a security issue, I assume, since I gave the ASPNET user full access to the database folder. What else could cause this error? Anyone know? Thanks. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119844
  - 18
    - Modeless Form Lose Accelerator and Tabbing Keys All, I am using COM Interop with C# to display a modeless form via a COM call from an application written in Visual studio C++ 6.0. I can display the form as modeless however the accelerator and tab keys do not work. Interestingly, if the form is modal the accelerator and tab keys work properly. Also if the same form is launched from a C# appication (not using COM) the forms accelerator and tab keys work properly. The form is a Class library (DLL) that has a COM interface. There is a COM method that calls .Show() for the form. Does anyone know how to get the accelerator and tab keys to work when calling the form through COM? Thanks in advance, Scott Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119841
  - 19
    - Find duplicate rows in datatable Hi All I need to detect duplicate rows in a datatable in VB net 2003 using MS Access 2K I can do it at database level with sql e.g sql = "select membernumber from members group by membernumber having count(membernumber) > 1" dt = getdata(sql, "dupes") ' getdata is my sub routine which returns a datatable Can you do a similar thing querying an Ado.net Datatable? i.e can you do advanced querying on a populated datatable? Any tips appreciated Regards Steve Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119832
  - 20
    - Querying a scalar in DataTable Hi, I have a DataTable with three columns (2 int, and 1 string). Now I would like a query that return the total number of different integers in one of the interger columns. For example Name Age Class A 12 4 B 13 5 C 11 3 D 12 3 Now if I select the total number of different integers in the Age column the answer is 3(because 11, 12 ,13). I hope someone understands my problem. Can some one help me out Thanks in Advance Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119831
  - 21
    - Help with using DataView to insert Record..Please! I'm new to ado.net/asp.net and have been on a crash course these last few days. I've been stuck on this current problem for over a day and it seems pretty simple, but I can't get it to work. I'd like to create a data view from a data table, insert a record into that data view and have it inserted back into the actual database (Access 2000). Following tutorials online, I've been able to use a dataadapter to connect to the database, then using a datatable, insert new rows and have them inserted in the actual database. But when it comes to doing that same functionality via a dataview, I've had no luck. Here is the code I've been using. It generates no errors, and a new row is added to the underlying datatable, but nothing is ever sent back to the database. I think it might have something to do with the myAdpater.InsertCommand code (are these used the same way in DataViews as in DataTables?). Thanks in advance for any advice. Public Sub editLevelProgressFromView() 'Objects used to connect/read from database Dim cs As ConnectionStringSettings Dim myConnection As OleDbConnection Dim myAdapter As OleDbDataAdapter Dim myTable As DataTable Dim myView As DataView Dim myRow As DataRowView Dim sqlStr As String cs = ConfigurationManager.ConnectionStrings("strConn") myConnection = New OleDbConnection(cs.ConnectionString) sqlStr = "Select * from tblTest" myAdapter = New OleDbDataAdapter(sqlStr, myConnection) 'Set up insert commands for use on myAdapter.Update method myAdapter.InsertCommand = New OleDbCommand("INSERT INTO tblTest (c_name, c_number) VALUES(?, ?)", myConnection) myAdapter.InsertCommand.Parameters.Add("@c_name", OleDbType.VarChar, 15, "c_name") myAdapter.InsertCommand.Parameters.Add("@c_number", OleDbType.VarChar, 30, "c_number") 'Fill Table and create View myTable = New DataTable() myAdapter.Fill(myTable) myView = myTable.DefaultView 'Add Row to myView, insert data via BeginEdit and EndEdit methods myRow = myView.AddNew() myRow.BeginEdit() myRow("c_name") = "testName" myRow("c_number") = "testNumber" myRow.EndEdit() 'Accept changes in table from view myTable.AcceptChanges() 'Commint changes to database (does not work, but no error thrown) myAdapter.Update(myTable) End Sub Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119827
  - 22
    - DataSet and Grid I want to hook up a DataSet to a grid but control the error display to the user. An exaple is user inputs invalid data and program puts up special message display instead of default eror messge from DataSet/grid combinatio. Thanks, Marc Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119822
  - 23
    - Confused about the DataAdapter I'm trying to learn/use ADO.Net and am puzzled by the DataAdapter. It has a TableMappings property which is a collection of mappings from the source into the DataSet. This implies that the DataAdapter can retrieve many tables from a source and store each in a single DataSet. But it only has a single SelectCommand so Fill() will only return single result set. I want to read 4 tables out of an access db. Do I need to create 4 DataAdapters to do it? Confused Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119811
  - 24
    - C# function within DataReader query Hi, I've a parameterised query that is used as the basis for an Excel export. I need to add an additional column that doesn't map to a field in my SQL table. What I have done in the past in my Access apps is to include a function I've created in the query SQL. Is there a way to achive the same with C#/ado.net? Many thanks, Simon Lane Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119810
  - 25
    - Optimistic Concurrency and TimeStamp Hi, I would like to implement optimistic concurrency where I retrieve the timestamp of a record in a table with a stored procedure and save the timestamp value into a vb.net variable. This represents the original timestamp for the record. When a user updates the record, I would like to pass the original timestamp to a stored procedure that performs the update to ensure the record has not been changed by another user. The problem is, how do I store the original timestamp value from SQL Server 2000 in vb.net? I have tried: Dim OrigTstamp() as Byte I can assign an incoming timestamp to a byte array but I'm not certain if anything is there. I then have great difficulty passing the OrigTstamp() to the update stored procedure. -- Thanks, Scott H. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119806
- Next
  - 1
    - Parameterized query nightmares I'm having a very strange problem with a parameterized query failing. I grabbed the query in Profiler to see if something weird was going on. Here it is, nonsense stripped out for brevity: exec sp_executesql N'SELECT CabinetID, CabinetName FROM Cabinets WHERE (CabinetName LIKE N''%@SearchText%'') ORDER BY CabinetName', N'@SearchText nvarchar(16)', @SearchText = N'tech' If I manullay change the LIKE statement to replace @SearchText directly with tech (i.e., "LIKE N''%tech%''), the command completes successfully in Query Analyzer and I get back the data I expect. If I run it as is in QA, I get back nothing. I've checked my authentication, and that's not the problem (if I go back to a concatenated select statement in my program it works fine), I've tried different sizes (and no size at all) for the nvarchar, and that doesn't change the result. I'm probably missing something very simple, but I haven't been able to figure it out thorugh research. Help! Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119799
  - 2
    - SQL Server Parameters I have a typed DataSet with say 50 fields in it. On the form, I only show 40. I have a stored procedure that takes in all 50 parameters. When I call SqlDataAdapter.Update(ds.Tables(0).GetChanges(DataRowState.Modified)), I get a SQL error back that Procedure XYZ is expecting Parameter '@myParameter' which was not supplied. In looking at Profiler, I can see that this parameter is being passed to SQL Server as Default, not as the value that the field has in the Original DataSet. Any suggestions? - I know that I can set the Default values inside of SQL Server, but that isn't going to work for this situation. Thanks in advance Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119794
  - 3
    - How to find out what the column's data type is? Hi all, How would I find out what the data type is for the below column? I'm using ADO.NET, C# and MS Access 2000. col_Source.ColumnName Thank you. -- Message posted via http://www.dotnetmonster.com Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119784
  - 4
    - Setting Oracle Schema At present, when I write Oracle SQL in .net, I have to embed the schema name as a prefix for all of the table names so I end up with code like "select * from " + GetSchemaName() + ".mytable". It would be much neater if I could change the schema for the connection. I could add a "alter session set current_schema="+GetSchemaName() every time a connection is opened, however as we open a new connection for almost every statement (and rely on connection pooling), this would double the number of db round trips. Is there any other way of setting the current schema without a round trip or only only running the "alter session" command when the connection is a new connection rather than one in the pool (I presume this would work)? Thanks, Jonathan Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119780
  - 5
    - Displaying n:m relation without showing the in-between table. Hi, I want to display an n:m relation in Windows without showing the in-between table. As an example, I used the Orders, Order Details and Products tables from the Northwind database. I use a ComboBox for the parent and want the details in a DataGrid I have set up a form and added some SqlDataAdapters and a DataSet, ComboBox and DataGrid. (using Visual Studio 2003). Here is the code I added: System.Data.DataColumn masterCol; System.Data.DataColumn detailCol; DataRelation dr; // Let the DataAdapters fill the DataSet DA_Orders.Fill(dataSet11); DA_Products.Fill(dataSet11); DA_OrderDetails.Fill(dataSet11); //add relation Orders - Order Details masterCol = dataSet11.Tables["Orders"].Columns["OrderID"]; detailCol = dataSet11.Tables["Order Details"].Columns["OrderID"]; dr = new DataRelation("OrdersToOrderDetails",masterCol,detailCol); dataSet11.Relations.Add(dr); //add relation Order Details - Products masterCol = dataSet11.Tables["Order Details"].Columns["ProductID"]; detailCol = dataSet11.Tables["Products"].Columns["ProductID"]; dr = new DataRelation("OrderDetailsToProducts",masterCol,detailCol,false); dataSet11.Relations.Add(dr); // Let the ComboBox display the OrderID comboBox1.DataSource = dataSet11; comboBox1.DisplayMember = "Orders.OrderID"; // Let the DataGrid display the OrderDetails dataGrid1.DataSource = dataSet11; dataGrid1.DataMember = "Orders.OrdersToOrderDetails"; When the DataGrid has "AllowNavigation" set to true, everything works fine. I get 3 Order details records, and by pressing "+" I can go to the Products information. !!!! However, I don't want to see the in-between table Order Details !!!!! So I tried setting dataGrid1.DataMember = "Orders.OrdersToOrderDetails.OrderDetailsToProducts", in an attempt to leave out the in-between table, and directly show the Products. But now I don't see 3 Products anymore, I only see the first one. What is the best way to hide the Order Details? Thanks in advance, Alexander van Buitenen. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119774
  - 6
    - Question Hi All, I got an error here, and don't know what might have caused this. any input is gladly appreciate it Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30002: Type 'selectCompanyEvents' is not defined. Source Error: Line 7: <script runat="server" language="VB"> Line 8: Sub Page_Load() Line 9: Dim objWebService As New selectCompanyEvents() Line 10: dgCompanyEvents.DataSource = objWebService.selectEvents() Line 11: dgCompanyEvents.DataBind() Source File: c:\inetpub\wwwroot\project\index.aspx Line: 9 Show Detailed Compiler Output: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.1.4322\vbc.exe" /t:library /utf8output /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\-o3a17q8.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\qitahgw0.dll" /R:"c:\windows\assembly\gac\system.web\1.0.5000.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.web.services\1.0.5000.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.web.mobile\1.0.5000.0__b03f5f7f11d50a3a\system.web.mobile.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.5000.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\project\90c16606\11e52b47\inoglfew.dll" /out:"c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.dll" /debug- /win32resource:"c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.res" "c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\project\90c16606\11e52b47\w6q0mkhc.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.10.6001.4 for Microsoft (R) .NET Framework version 1.1.4322.2032 Copyright (C) Microsoft Corporation 1987-2002. All rights reserved. c:\inetpub\wwwroot\project\index.aspx(9) : error BC30002: Type 'selectCompanyEvents' is not defined. Dim objWebService As New selectCompanyEvents() ~~~~~~~~~~~~~~~~~~~ Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119773
  - 7
    - How do I get the SqlDbType from a DataTable? I need to know what the native SQL data type is. How can I figure this out once I have filled a dataset? Thanks in advance. -- Robert Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119770
  - 8
    - DDL via Command.ExecuteNonQuery Hello all: Consider the following: CREATE PROCEDURE procname @input1 int, @input2 int AS execute some stuff here --this is a comment END Suppose this were entered in a text box, including the line feeds and carriage returns. If I pass this to the ExecuteNonQuery method of a command object, it will fail. If I strip out the comment and also replace the line feeds/carriage returns with spaces, it will succeed, but if I review the stored procedure with, say, Enterprise manager, the procedure looks like this: CREATE PROCEDURE procname @input1 int, @input2 int AS execute some stuff here END in other words, not having included line feeds in the command, they do not end up in the script either. What I would like to do is have the script execute, as it appears, just as though I had entered it in, say, Query Analyzer. Suggestions? Thanks much, zdrakec Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119769
  - 9
    - Sorted data is not sorted I have a table [CoverageLimits] with the following columns Coverage, Limit, LimitDescription, PerPerson, PerAccident I load the data from a stored procedure into a datatable Select Coverage, Limit, LimitDescription, PerPerson, PerAccident From CoverageLimits Order By Coverage, PerPerson, PerAccident. I have manually executed this procedure in Query Analyzer and the data comes out in the desired order. 'A', 'J', '20/40', 20, 40 'A', 'K', '25/50', 25, 50 'A', 'C', '100/300', 100, 300 While the data is actually stored in the heap in this order 'A', 'K', '25/50', 25, 50 'A', 'C', '100/300', 100, 300 'A', 'J', '20/40', 20, 40 When I attempt to populate a combobox with this data from my datatable dim drs() as datarow drs = mydatatable.select("Coverage = '" & A & "'") cbo.DataSource = drs cbo.DisplayMember = "LimitDescription" cbo.ValueMember = "Limit" The data is displayed in its natural ordered state. So then I attempted to sort the data in the table dim drs() as datarow mydatatable.defaultview.sort = "Coverage, PerPerson, PerAccident" drs = mydatatable.select("Coverage = '" & A & "'") cbo.DataSource = drs cbo.DisplayMember = "LimitDescription" cbo.ValueMember = "Limit" The data is still displayed in its natural ordered state. Now I can attempt to sort the array of datarows, but this seems kind of a wasted step, I would prefer the data be ordered by my stored procedure. Anyone have any ideas how I can achieve the desired result? TIA Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119766
  - 10
    - HOW FILL A DATATABLE FROM THE DATASET ??? Hi, I usually work with dataset I fill from SQL Server through a SQLDataAdapter. I would like to fill a table of my dataset reading the records from another table of the dataset, because I would like to change the order of the column without reconnect to SQLServer. The first time I connect to import the records through a parametric stored procedure stored in SQL Server.Is there a specific dataadapter to read and fill datatable from the dataset control ??? Any suggest ??? Many thanks Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119762
  - 11
    - ADO.Net data adapter doesn't allow a table of more than 100 column In our VB.Net project, we are using VS.Net's data adapter wisard to generate SQLDataAdapter. What we find out is that if the table we use for this contains no more than 99 columns, everthing will be fine. But as soon as you go beyung that, the process will error out with a message indicating that generating select statement failed. I wonder is that a limitation of ADO.net? But I can run select query against the same table without any issue. What is wrong? Thanks in advance Feng Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119746
  - 12
    - SQL Server does not exist or access denied I have developed a small application using ASP.NET and VB.NET on my development machine it works great. When I copy across the files manually to my test machine and create a Virtual Directory all of the functionality works well except for a page with a datagrid that retrieves data from an MSDE database (error message is detailed below). I have checked the connection string and that looks good and MSDE is properly installed and configured on the test box. By the way I have tried this on two separate test machines I get the same error. At a loss to understand why. Do I need to run some exe that lets my ASP.NET application to use MSDE, is it a permissions thing or what? By the way the error I get is as follows: SQL Server does not exist or access denied. 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: SQL Server does not exist or access denied. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119745
  - 13
    - DB insert problems with apostrophe in a Surname and Datetime value Iâ??m copying data across from an Access database to an MSDE database through the use of some vb.net code. Unfortunately the application crashes when it goes to copy across data, in particular surnames that have an apostrophe such as Oâ??Shay etc. Also I have a â??date/timeâ?? value in my Access database that I have to copy across to my MSDE database in a field that is of datatype â??datetimeâ?? and length â??8â??. How do I get this right I tried to get this working and the page would crash every time. The code Iâ??m using is as follows. Dim conAuthors As OleDbConnection Dim cmdSelectAuthors As OleDbCommand Dim dtrAuthors As OleDbDataReader Dim txt_RC_TITLE, txt_RC_GIVENNAME, txt_RC_SURNAME, txt_RC_MOBILE, txt_RC_EMAIL, txt_RC_GROUPS as Object Dim dte_RC_DATESTAMP as object 'the dte_RC_DATESTAMP is a datestamp that is in the Access database that I have to copy across but Iâ??m having a lot of trouble not sure how to do it 'open Access database with customer details conAuthors = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\CustomerDatabase.mdb") conAuthors.Open() cmdSelectAuthors = New OleDbCommand( "Select * From CUSTOMERTABLE", conAuthors ) dtrAuthors = cmdSelectAuthors.ExecuteReader() 'loop through all customer details in Access database, copy these details to a new set of two tables in the MSDE database While dtrAuthors.Read() 'set up read in values from Access database txt_RC_TITLE = dtrAuthors( "txtTITLE" ) txt_RC_GIVENNAME = dtrAuthors( "txtGIVENNAME" ) txt_RC_SURNAME = dtrAuthors( "txtSURNAME" ) txt_RC_MOBILE = dtrAuthors( "txtMOBILE" ) txt_RC_EMAIL = dtrAuthors( "txtEMAIL" ) 'dte_RC_DATESTAMP = dtrAuthors( "dteDATESTAMP" ) 'insert details into CUSTOMERDETAILS table in MSDE database and get that intCUSID(customer id) that is a unique integer that is created for each record that is inserted into the table Dim conDB As SqlConnection Dim strInsert As String Dim cmdInsert As SqlCommand conDB = New SqlConnection("SERVER=xxx.xxx.xxx.xxx;UID=sa;PWD=xxxx;DATABASE=customerdb") strInsert = "Insert into CUSTOMERDETAILS (txtTITLE, txtGIVENNAME, txtSURNAME, txtMOBILEPHONE) Values ('" & txt_RC_TITLE & "', '" & txt_RC_GIVENNAME & "', '" & txt_RC_SURNAME & "', '" & txt_RC_MOBILE & "'); SELECT SCOPE_IDENTITY()" cmdInsert = New SqlCommand(strInsert, conDB) conDB.Open() Dim intCUSID As Integer intCUSID = cint(cmdInsert.ExecuteScalar()) conDB.Close() 'Add the customers email address and the intCUSID(customer id) to the CUSMARKETING table Dim strConn As String = "SERVER=xxx.xxx.xxx.xxx;UID=sa;PWD=xxxx;DATABASE=customerdb" Dim cmd As New SqlCommand("INSERT INTO CUSMARKETING (intCUSID, txtEMAILADDRESS ) VALUES('" & intCUSID & "', '" & txt_RC_EMAIL & "')", New SqlConnection(strConn)) cmd.Connection.Open() cmd.ExecuteNonQuery() cmd.Connection.Close() End While dtrAuthors.Close() conAuthors.Close() Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119744
  - 14
    - SQL Server 2000 SELECT COUNT(*) Issue Ok. I can't figure this one out, but maybe someone has some experience with this. Seperate boxes (1 running SQL Server 2k, 1 app server, both running win Server 2003). .Net app that connects from app server to SqlServer box, does a select count(*) from a table, if count == 0, then process aborts, else process continues. For the last two wednesdays in a row, at the same time, the process counts 0 instead of the actual number. I can take the Sql for the count and run it manually through QA and get back the correct count. I can take the app down to my dev environment and run it, everything runs as expected. The app is able to connect to the DB, but when it runs the select count(*), then it returns 0. Has anyone ever experienced this behavior, know what causes it? TIA AP Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119739
  - 15
    - Insert Into Syntax error Hi all, Please can someone tell me what's wrong with the following INSERT INTO statement. The error message return that an 'INSERT INTO syntax error' I have a feeling that it is because of the 'Sensor offset' field name having a space between the two names, although it is like that in the MS Access 2000 database that I'm using? But I would like someone to clarify or suggest the problem. da_Target.InsertCommand.CommandText = "INSERT INTO Layouts (Name,Picture, Sensor offset) VALUES ('David',' ',7)"; Thank you. -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200510/1 Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119730
  - 16
    - Howto move in a datatable rows Hi All, I come from Microsoft Access programming, so when I use a recordset from code, I can use MoveFirst, MoveLast, MoveNext, MovePrevious So my question is: In a DataTable, how can I simulate this methods? TIA Erny Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119715
  - 17
    - DataGridViewButtonColumn with REAL button! (image-property) Hi, I want to use the DataGridViewButtonColumn of VS.NET 2005, but this button isn't a n'ormal' button, but some minor and inusable version fo the button-control. I want to show an image in my button, which is normally I standard proeprty of the button, but it doesn't have this proeprty. Does anybody knows how to do this? Actually: these columnstyles of the DataGridView makes me really angry. I can't understand why for god's sake Microsoft suddenly invents minor versions of there controls to put them in these columnstyles! Why the hell did they do this? why put time in a product that is worse than the orginal? The same with the DataGridViewComboBoxColumn! Which idiot decided to delete all the (very usefull) proeprty's of the normal combobox? You can't even chose the DropDownStyle! Grrrrrrrrr But anyways, Thanks a lot in advance to those who can help me :-) Pieter PS: Please let somebody make 'normal' custom columnstyles with the normal controls in it! Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119696
  - 18
    - Oledb Connection from ASP.Net on Windows 2003 does not work The following code does not work from an ASP.Net application on Windows 2003 IIS 6 (application isolation mode). Basically I am trying to connect to a Sharepoint catalog through the oledb provider for Internet publishing (WebDAV) It works fine from a windows application on Windows 2003. It works in ASP.net web application on Windows2000 public void Connect() { string connString = "provider=msdaipp.dso;data source=http://myServer/mycatalog"; OleDbConnection conn = new OleDbConnection(connString); try { conn.Open(); } catch { throw; } finally { conn.Close(); } } I have also tried the following and none of these works on 2003/IIS6 Changed the website to run in IIS 5 isolation mode added NT AUTHORITY\NETWORK SERVICE to the administrator group tried opening the connection in the asp.net in a secondary thread Impersonated the asp.net web application to run as a user with administrator privileges Turned anonymous authentication off and ran the website with integrated authentication so it takes the logon user credentials Any help to point me in the right direction would be greatly appreciated Thanks Sriram V Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119692
  - 19
    - Question about-> Keyword not supported: '"database'. Hi All, I need your inputs and help. Somehow I get these following error when running my page.aspx: Keyword not supported: '"database'. 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.ArgumentException: Keyword not supported: '"database'. Source Error: Line 59: Dim con As New SqlConnection("Server=IBM-5E0E937420B\NETSDK;""Database=Test;""User ID=sa;Password=aaaaaaa") Line 60: Protected WithEvents txkOtherCond1 As System.Web.UI.WebControls.TextBox Line 61: I really don't have any more idea of what might have cause this. Do I have to configure IIS when using MSDE database? Thank you all for the inputs, I really appreciate it Armand Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119687
  - 20
    - TURN $6 INTO $15,000 IN ONLY 30 DAYS...HERES HOW - "paypal.rtf" 12.4 KBytes yEnc It Will Work? If you do as I have done! Just Do It! follow the 4 steps? $6.00 to $15,000.00 in 30 days! Steps: Follow the Logic, Just Do it and It will work? $$$ in 4 easy steps? 1. Set Up a Free Paypal Account. 2. Send $1.00 to six Email Accounts from your Paypal Account 3. Delete email address #1 and add your email address as #6. Move all others #2-#6 up one number 4. Copy and Post this entire Letter to Newsgroups, Messages Boards etc? Copy this exactly for you guidance to completing steps 1-4. You are in Business for yourself and you are Creating an E-mail List Company TURN $6 INTO $15,000 IN ONLY 30 DAYS...HERES HOW! PAYPAL VERIFIES THAT THIS $6 INVESTMENT SCHEME IS 100% LEGAL AND IS A BIG HIT THIS YEAR SEE THEIR NOTE BELOW OR ASK THEM DIRECTLY... THIS SCHEME MIGHT TAKE 15-30 MINUTES AND JUST $6, BUT IT IS 100% WORTH IT TO MAKE THOUSANDS SO QUICKLY. THIS IS NOT ANOTHER SCAM THAT TAKES LOTS OF YOUR HARD EARNED MONEY; THIS IS A NO RISK INVESTMENT THAT WILL MAKE YOU THOUSANDS OF DOLLARS VERY EASILY AND QUICKLY. >From PayPal: "Dear Member, it has come to our attention that there is a paypal scheme floating around at the moment you may have heard or seen the $6 scheme. You may have even taken part in it well we have been asked a lot of questions about this scheme the answer is yes it does work and yes it is safe to use providing you follow the rules it is legal and has made a big hit on the internet this year. If you would like to take part in this scheme or would like a bit more information then please see the attached file that was kindly donated to us. Thank you for using PayPal!" TURN $6 INTO $15,000 IN ONLY 30 DAYS...HERES HOW! This is a Money Scheme and Not, I repeat? This is Not a Scam!!! You have most likely seen or heard about this project on TV programs such as 20/20 and Oprah, or you may have read about it in the Wall Street Journal. If not, here it is below - revealed to you in step-by-step detail. This program is by no means new. It has been in existence in many forms for at least a decade. But in the early days, it required a lot more time and effort, as well as an investment of a few hundred dollars. However thanks to PayPal and the Internet, the investment is now virtually ZERO! And what's more, the entire process is FASTER, EASIER, and MORE LUCRATIVE than it has EVER been! Below is the email sent to me: How to Turn $6 into $15,000 in 30 Days with PayPal I WAS SHOCKED WHEN I SAW HOW MUCH MONEY CAME FLOODING INTO MY PAYPAL ACCOUNT I turned $6 into $14,706 within the first 30 days of operating the business plan that I am about to reveal to you free of charge. If you decide to take action on the following instructions, I will GUARANTEE that you will enjoy a similar return! STILL NEED PROOF? Here are just 3 testimonials from the countless individuals who decided to invest nothing more than $6 and half an hour of their time to participate in this program: "What an amazing plan! I followed your instructions just 3 weeks ago, and although I haven't made 15 grand yet, I'm already up to $9,135. I'm absolutely gob smacked." -Pam Whittemore , Ohio "Well, what can I say?... THANK YOU SO MUCH! I sent 40 e-mail's out like you said and then I just forgot about the whole thing. To be honest, I didn't really think anything would come of it. But when I checked my paypal account a week later, there was over $5,000 in After 30 days I now have over $11,000 to spend! I can't thank you enough!"-Juan Tovar, NY,NY "I was shocked when I saw how much money came flooding into my paypal account. Within 3 weeks my account balance has ballooned to $12,449. At first I thought there had been some sort of error with my account!" -Richard Barrie , Boulder,CO The only things you will need are: An email address. A Business PayPal account with at least $6 deposited in it, and just 15 to 30 minutes of your time. This program takes just half an hour to set up. After that, there is absolutely no work whatsoever to do on your part. You have absolutely NOTHING to lose, and there is NO LIMIT to the amount of income you can generate from this one single business program. Let's get started, just follow the instructions exactly as set out below and then prepare yourself for a HUGE influx of cash over the next 30 days! Here's what you need to do. . . REQUIREMENTS #1) an email address #2) a Premier or Business PayPal account (It's simple and free to get a Premier or Business account, if you need help doing it just email me.) Now follow the steps: 1-4 ________________________________________ Follow these easy steps EXACTLY and just watch what happens STEP #1 - Setting up your FREE PayPal Account It's extremely safe and very easy to set up a FREE PayPal account! Copy and paste this to the address bar https://www.paypal.com (notice the secure "https" within the link) Be sure to sign up for a free PREMIER or BUSINESS account (and not just a PERSONAL account) otherwise you won't be able to receive credit card payments from other people. STEP #2 - Sending PayPal money "It is an undeniable law of the universe that we must first give in order to receive." Now all you have to do is send $1.00 by way of PayPal to each of the six email addresses listed below. After setting up your free paypal account and confirming or verifying YOUR ACCOUNT AND putting (six Dollars) $6.00 into your Paypal Account use the Account tab on Paypal to send $1.00 to each of the Names on the List then move the top one and place yours in the #6 spot on the list of names #1-#6. Remember your name becomes #6. Make sure the subject of the payment says... *PLEASE PUT ME ON YOUR EMAIL LIST* (this keeps the program 100% legal.. so please don't forget!) Note: (If you do not see the full email address for the 6 members, just hit reply to this email and they will show up.) (Just in case you still haven't opened your PayPal account yet, use this link to open one in your name), https://www.paypal.com #1) faithmichelle_mo@yahoo.com #2) reesefork@yahoo.com #3) artofficial@grics.net #4) msw27@cox.net #5) fredwdjr@yahoo.com #6) maintenanceman69@aol.com Remember, all of this is ABSOLUTELY LEGAL! You are creating a service! A Business? An Email List Service Business If you have any doubts, please refer to Title 18 Sec. 1302 & 1241 of the United States Postal laws. STEP #3 - Adding Your Email Address After you send your six $1.00 payments, it's your turn to add your email address to the list! Take the #1) email off the list that you see above, move the other addresses up one (6 becomes 5 & 5 becomes 4, 4 becomes 3, 3 becomes 2, 2 becomes 1, your email becomes #6) put YOUR email address (the one used in your PayPal account) as #6) on the list. **MAKE SURE THE EMAIL YOU SUPPLY IS EXACTLY AS IT APPEARS IN YOUR PAYPAL ACCOUNT.** STEP #4 - Copy Message to 200 Newgroups, message boards,etc?? The Pure Joy of Receiving PayPal Money! ________________________________________ You are now ready to post your copy of this message, to at least 200 newsgroups, message boards, etc. (I think there are close to 32,000 groups) All you need is 200, but remember, the more you post, the more money you make - as well as everyone else on the list! In this situation your job is to let as many people see this letter as possible. So they will make you and me rich!!!! You can even start posting the moment your email is confirmed. Payments will still appear in your PayPal account even while your bank account is being confirmed. HOW TO POST TO NEWSGROUPS & MESSAGE BOARDS Step #1) You do not need to re-type this entire letter to do your own posting. Simply put your CURSOR at the beginning of this letter and drag your CURSOR to the bottom of this document, and select 'copy' from the edit menu. This will copy the entire letter into your computer's temporary memory. Step #2) Open a blank 'Notepad' file and place your cursor at the top of the blank page. From the 'Edit' menu select 'Paste'. This will paste a copy of the letter into notepad so that you can add your email to the list. Or copy to a Word Document. and Place in the email upon completion. Step #3) Save your new Notepad file as a .txt file. If you want to do your postings in different sittings, you'll always have this file to go back to. Step #4) Use Netscape or Internet Explorer and try searching for various newsgroups, on-line forums, message boards, bulletin boards, chat sites, discussions, discussion groups, online communities, etc. EXAMPLE: go to any search engine like yahoo.com, google.com, altavista.com, excite.com - then search with subjects like? millionaire message board? or money making message board? or opportunity message board? or money making discussions? or business bulletin board? or money making forum? etc. You will find thousands & thousands of message boards. Click them one by one then you will find the option to post a new message. Step #5) Visit these message boards and post this article as a new message by highlighting the text of this letter and selecting 'Paste' from the 'Edit' menu. Fill in the Subject, this will be the header that everyone sees as they scroll thru the list of postings in a particular group, click the post message button. You're done with your first one! Congratulations! THAT'S IT!! All you have to do is jump to different newsgroups and post away. After you get the hang of it, it will take about 30 seconds for each newsgroup! REMEMBER, THE MORE NEWSGROUPS AND/OR MESSAGE BOARDS YOU POST IN, THE MORE MONEY YOU WILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money within days! **JUST MAKE SURE THE EMAIL YOU SUPPLY IS EXACTLY AS IT APPEARS ON PAYPAL.** Explanation of why it works so well: $$$$$ NOW THE WHY PART: Out of 200 postings, say I receive only 5 replies (a very low example). So then I Made $5.00 with my email at #6 on the letter. Now, each of the 5 persons who just sent me $1.00 make the MINIMUM 200 postings, each with my email at #5 and only 5 persons respond to each of the original 5, that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my email at #4 and only 5 replies each, I will bring in an additional $125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my email at #3 and only receive 5 replies each, I will make an additional $625.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my email at #2 and they only receive 5 replies that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my email at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625.00! With an original investment of only $6.00! AMAZING!! When your email is no longer on the list, you just take latest posting in the newsgroups, and send out another $6.00 to emails on the list, putting your email at number 6 again. And start posting again. The thing to remember is, thousands of people all over the world are joining the internet and reading these articles everyday, JUST LIKE YOU are now!! So can you afford $6?? And see if it really works?? I think so? People have said, what if the plan is played out and no one sends you the money? So what are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users everyday, with thousands of those joining the actual Internet. Remember, play FAIRLY and HONESTLY and this will work. This really isn't another one of those crazy scams! As long as people follow through with sending out $6.00, it works! With warm wishes, bless you and your loved ones, https://www.paypal.com =ybegin line=128 size=12350 name=paypal.rtf ¥????[?????????????[\_\?????Z????????[Z]]¥????????¥??Z????????????????ZJ~????Jx?¡J|????e§¥??[???¡????????????ZJk????e§§74¥?T???? ??????Jw???????J_X^[X[_X[_Zae§? ??¡????^???[????????[ZZ???[ZZ??Z???\^Js?J????J?????Qb_Js?J£??J??J??JsJ?? ?J????KJt???Jn?Js?KJ??? ??¡J???J^J??????Qb_JN`XZZJ??JN[_VZZZXZZJ??J]ZJ??£?KJ????74}????dJp????¡J???Jv????VJt???Jn?J??J???Js?J¡???J¡????Qb_JNNNJ??J^J???£ J??????Qb_J????74[XJ}??J?J?Jp???Jz?£???Jk??????XJ\XJ}???JN[XZZJ??J??¢Jo????Jk???????J????J£???Jz?£???Jk??????J]XJn?????J?????J? ??????JM[J???J???J£???J?????J???????J??JM`XJw? ?J???J??????JM\WM`J??J???J??????J^XJm??£J???Jz???J????J??????Jv?????J??Jx?¡?????? ?VJw???????Jl?????J????Qb_J????74m??£J????J?¢????£J???J£??J????????J??J??????????J?????J[W^XJ???J???J??Jl???????J???J£???????J?? ?J£??J???Jm???????J??JoW????Jv???Jm?????£J~|xJN`Jsx~yJN[_VZZZJsxJyxv?J]ZJnk?}XXXro|o}Jry?KJ????74zk?zkvJ?o|spso}J~rk~J~rs}JN`Js x?o}~wox~J}mrowoJs}J[ZZOJvoqkvJkxnJs}JkJlsqJrs~J~rs}J?ok|J}ooJ~ros|Jxy~oJlovy?Jy|Jk}uJ~rowJns|om~v?XXXJ~rs}J}mrowoJwsqr~J~kuoJ[_ W]ZJwsx~o}JkxnJt}~JN`VJl~Js~Js}J[ZZOJ?y|~rJs~J~yJwkuoJ~ry}kxn}J}yJ{smuv?XJ~rs}Js}Jxy~Jkxy~ro|J}mkwJ~rk~J~kuo}Jvy~}JypJ?y|J rk|nJok|xonJwyxo?eJ~rs}Js}JkJxyJ|s}uJsx?o}~wox~J~rk~J?svvJwkuoJ?yJ~ry}kxn}JypJnyvvk|}J?o|?Jok}sv?JkxnJ{smuv?XJ????74hp???Jz?£ z??dJ????74Ln???Jw?????VJ??J???J????J??J???J?????????J????J?????J??J?J??£???J??????J????????J??????J??J???J??????J£??J??£J?? ?J? ????J??J????J???JN`J??????XJ???J??£J?? ?J? ??J?????J????J??J??J¡???J¡?J?? ?J????J?????J?J???J??J?????????J?????J????J??????J???J ???¡??J??J£??J??J????J¡???J???J£??J??J??J????J??J???J??? ?????J£??J?????¡J???J?????J??J??J?????J???J???J????J?J???J???J??J???J?? ??????J????J£???XJs?J£??J¡????J????J??J????J????J??J????J??????J??J¡????J????J?J???J????J???????????J????J??????J???J???J??????? ?J????J????J¡??J?????£J???????J??J??XJ~????J£??J???J?????Jz?£z??KLJ????74~|xJN`Jsx~yJN[_VZZZJsxJyxv?J]ZJnk?}XXXro|o}Jry?KJ~???J ??J?Jw???£J}?????J???Jx??VJsJ???????Qb_J~???J??Jx??J?J}???KKKJ????74???J?? ?J????J?????£J????J??J?????J?????J????J???????J??J~?J ????????J????J??J\ZY\ZJ???Jy????VJ??J£??J??£J?? ?J????J?????J??J??J???J????J}?????Jt??????XJs?J???VJ????J??J??J????¡JWJ?? ?????J ??J£??J??J????W?£W????J??????XJ~???J???????J??J?£J??J?????J??¡XJs?J???J????J??J?¢???????J??J???£J?????J???J??J?????J?J??????XJl? ?J??J???J????£J??£?VJ??J????????J?J???J????J????J???J??????VJ??J¡???J??J??J?? ???????J??J?J??¡J???????J???????XJr?¡? ??J??????J? ?Jz?£z??J???J???Js???????VJ???J?? ???????J??J??¡J ???????£J?o|yKJk??J¡???Q?J????VJ???J??????J???????J??Jpk}~o|VJok}so|VJ???Jwy|o Jvm|k~s?oJ????J??J???Jo?o|J????KJl???¡J??J???J?????J????J??J??dJ????74r?¡J??J~???JN`J????JN[_VZZZJ??J]ZJn?£?J¡???Jz?£z??JsJ?k}J }rymuonJ?roxJsJ}k?Jry?JwmrJwyxo?JmkwoJpvyynsxqJsx~yJw?Jzk?zkvJkmmyx~JsJ??????JN`J????JN[^VaZ`J¡?????J???J?????J]ZJ??£?J??J???? ?????J???J????????J????J????JsJ??J?????J??J?? ???J??J£??J????J??J??????XJs?J£??J??????J??J????J??????J??J???J?????¡???J????????? ???VJsJ¡???Jqk|kx~ooJ????J£??J¡???J????£J?J???????J??????KJ}~svvJxoonJz|yypiJr???J???J????J]J????????????J????J???J?????????J?? ?? ??????J¡??J???????J??J?? ???J???????J????J????JN`J???J????J??J????J??J?????J????J??J???????????J??J????J???????dJ????74L????J ??J???¤???J????KJsJ?????¡??J£???J????????????J????J]J¡????J???VJ???J????????JsJ?? ??Q?J????J[_J?????J£??VJsQ?J??????£J??J??JNcV[ ]_XJsQ?J?????????£J???J???????XLJWz??J??????????JVJy???J????74L????VJ¡???J???JsJ??£iXXXJ~rkxuJ?yJ}yJwmrKJsJ????J^ZJ?W????Q?J?? ?J????J£??J????J???J????JsJ????J??????J?????J???J¡????J?????XJ~?J??J??????VJsJ????Q?J?????£J?????J??£?????J¡????J????J??J??XJl?? J¡???JsJ???????J?£J??£???J???????J?J¡???J?????VJ?????J¡??J? ??JN_VZZZJ??Jk????J]ZJ??£?JsJ??¡J?? ?J? ??JN[[VZZZJ??J?????KJsJ???Q? J?????J£??J??????KLWt???J~? ??VJx?Vx?J????74LsJ¡??J???????J¡???JsJ??¡J??¡J????J????£J????J????????J????J?£J??£???J???????XJ????? ?J]J¡????J?£J???????J???????J???J?????????J??JN[\V^^cXJk?J?????JsJ???????J?????J???J????J????J????J??J?????J¡???J?£J???????KLJW| ??????Jl?????JVJl??????VmyJ????74~??J???£J??????J£??J¡???J????J???dJk?J?????J???????XJkJl???????Jz?£z??J???????J¡???J??J?????JN` J?????????J??J??VJ???J????J[_J??J]ZJ???????J??J£???J????XJ~???J???????J?????J????J????J??J????J??J???J??XJk????J????VJ?????J??J? ????????£J??J¡???J¡?????? ??J??J??J??J£???J????XJ???J?? ?J?????????£Jxy~rsxqJ??J????VJ???J?????J??JxyJvsws~J??J???J??????J??J??? ???J£??J???J????????J????J????J???J??????J????????J???????XJ????74v??Q?J???J???????VJ????J?????¡J???J????????????J?¢????£J??J??? J???J????¡J???J????J???????J£???????J???J?JrqoJ?????¢J??J????J? ??J???J??¢?J]ZJ??£?KJr???Q?J¡???J£??J????J??J??XJXJXJ????74|o{ s|owox~}J????74M[SJ??J?????J???????JM\SJ?Jz??????J??Jl???????Jz?£z??J???????J?????JRs?Q?J??????J???J????J??J???J?Jz??????J??Jl?? ?????J???????VJ??J£??J????J????J?????J??J????J?????J??XSJ????74x?¡J?????¡J???J?????dJ[W^J?????J????????????????????????????????? ???????J????74p????¡J?????J???£J?????Jo?km~v?J???J????J¡????J¡???J???????J?????J}~ozJM[JWJ}??????J??J£???Jp|ooJz?£z??Jk??????J?? ??74s?Q?J?¢??????£J????J???J ??£J???£J??J???J??J?Jp|ooJz?£z??J???????KJm??£J???J?????J????J??J???J???????J???J?????dYY¡¡¡X??£??? X???JR??????J???J??????JL?????LJ¡?????J???J????SJ????74l?J????J??J????J??J???J?J????Jz|owso|J??Jl}sxo}}J???????JR???J???J????J? Jzo|}yxkvJ???????SJ?????¡???J£??J¡??Q?J??J????J??J????? ?J??????J????J??£?????J????J?????J??????XJ????74}~ozJM\JWJ}??????Jz?£z?? J????£JLs?J??J??J??????????J??¡J??J???J??? ????J????J¡?J????J?????J?? ?J??J?????J??J????? ?XLJ????74x?¡J???J£??J?? ?J??J??J??J?? ??JN[XZZJ?£J¡?£J??Jz?£z??J??J????J??J???J??¢J?????J?????????J??????J????¡XJk????J???????J??J£???J????J??£???J???????J???J??????? ???J??J ????£???J?y|Jkmmyx~JkxnJ???????JR??¢Jn??????SJN`XZZJ????J£???Jz?£???Jk??????J???J???Jk??????J???J??Jz?£???J??J????JN[X ZZJ??J????J??J???Jx????J??J???Jv???J????J?? ?J???J???J???J???J?????J£????J??J???JM`J????J??J???J????J??J?????JM[WM`XJ|???????J£? ??J????J???????JM`XJ????74w???J????J???J???????J??J???J??£????J??£?XXXJTzvok}oJz~JwoJyxJ?y|JowksvJvs}~TJR????J?????J???J?????? ?J[ZZOJ?????XXJ??J??????J???Q?J??????KSJ????74x???dJRs?J£??J??J???J???J???J????J?????J???????J???J???J`J???????VJ????J???J????£J ??J????J?????J???J???£J¡???J???¡J??XSJ????74Rt???J??J????J£??J?????J?? ??Q?J??????J£???Jz?£z??J???????J£??VJ???J????J????J??J??? ?J???J??J£???J????SVJ?????dYY¡¡¡X??£???X???J????74M[SJ????????????????j£????X???J?????JM\SJ?????????j£????X???J?????JM]SJ??????? ????j?????X???J?????JM^SJ??¡\aj??¢X???J?????JM_SJ????¡???j£????X???J?????JM`SJ??????????????`cj???X???????74|???????VJ???J??J??? ?J??Jkl}yv~ov?JvoqkvKJ???J???J????????J?J??? ???KJkJl????????Qb_Jk?Jo????Jv???J}?? ???Jl???????J????74s?J£??J?? ?J??£J??????VJ? ?????J?????J??J~????J[bJ}??XJ[]Z\JPJ[\^[J??J???J?????J}?????Jz?????J??¡?XJ????74}~ozJM]JWJk?????J????Jo????Jk??????J????74k???? J£??J????J£???J??¢JN[XZZJ??£?????VJ??Q?J£???J????J??J???J£???J?????J???????J??J???J????KJ????74~???J???JM[SJ?????J???J???J????J? ???J£??J???J??? ?VJ?? ?J???J?????J?????????J??J???JR`J???????J_JPJ_J???????J^VJ^J???????J]VJ]J???????J\VJ\J???????J[VJ£???J????? J???????JM`SJ???J?y|J?????J???????JR???J???J????J??J£???Jz?£z??J???????SJ??JM`SJ??J???J????XJ????74TTwkuoJ}|oJ~roJowksvJ?yJ} zzv?Js}Jo?km~v?Jk}Js~Jkzzok|}JsxJ?y|Jzk?zkvJkmmyx~XTTJ????74}~ozJM^J???????JJm??£Jw??????J??J\ZZJx?¡??????VJ???????J??????V??? ?Qb_?Qb_J~??Jz???Jt?£J??J|???? ???Jz?£z??Jw???£KJ?????J????????????????????????????????????????J?????J???J???J??¡J????£J??J????J £???J???£J??J????J???????VJ??J??J?????J\ZZJ??¡???????VJ???????J??????VJ???XJRsJ?????J?????J???J?????J??J]\VZZZJ??????SJ????74k?? J£??J????J??J\ZZVJ???J????????VJ???J????J£??J????VJ???J????J????£J£??J????JWJ??J¡???J??J? ??£???J????J??J???J????KJs?J????J????? ????J£???J???J??J??J???J??J???£J??????J???J????J??????J??J????????XJ}?J???£J¡???J????J£??J???J??J????KKKKJ???J???J? ??J?????J??? ????J???J??????J£???J?????J??J?????????XJz?£?????J¡???J?????J??????J??J£???Jz?£z??J???????J? ??J¡????J£???J????J???????J??J????? J?????????XJ????74ry?J~yJzy}~J~yJxo?}q|yz}JPJwo}}kqoJlyk|n}J????74}???JM[SJ???J??J???J????J??J??W?£??J????J??????J??????J??J??J £???J?¡?J???????XJ}????£J???J£???Jm|}y|J??J???J?????????J??J????J??????J???J????J£???Jm|}y|J??J???J??????J??J????J????????VJ?? ?J??????JQ???£QJ????J???J????J????XJ~???J¡???J???£J???J??????J??????J????J£???J????????Q?J????????£J?????£XJ????74}???JM\SJy???J ?J?????JQx??????QJ????J???J?????J£???J??????J??J???J???J??J???J?????J????XJp???J???JQo???QJ????J??????JQz????QXJ~???J¡???J?????J ?J???£J??J???J??????J????J???????J??J????J£??J???J???J£???J?????J??J???J????XJy?J???£J??J?J????Jn???????XJ???Jz????J??J???J????? J????J??????????XJ????74}???JM]SJ}? ?J£???J??¡Jx??????J????J??J?JX?¢?J????XJs?J£??J¡???J??J??J£???J????????J??J?????????J??????? ?VJ£??Q??J??¡?£?J?? ?J????J????J??J??J????J??XJ????74}???JM^SJ??Jx???????J??Js???????Jo¢??????J???J??£J?????????J???J ??????J?? ¡???????VJ??W????J??????VJ???????J??????VJ????????J??????VJ????J?????VJ???????????VJ??????????J??????VJ??????J???????????VJ???XJ o?kwzvodJ??J??J??£J??????J??????J????J£????X???VJ??????X???VJ???? ????X???VJ?¢????X???JWJ????J??????J¡???J????????J????iJ??????? ????J???????J?????iJ??J????£J??????J???????J?????iJ??J??????????£J???????J?????iJ??J????£J??????J???????????iJ??J????????J?????? ??J?????iJ??J????£J??????J?????iJ???XJ???J¡???J????J?????????JPJ?????????J??J???????J??????XJm????J????J???J?£J???J????J£??J¡??? J????J???J??????J??J????J?J??¡J???????XJ????74}???JM_SJ?????J?????J???????J??????J???J????J????J???????J??J?J??¡J???????J?£J???? ????????J???J??¢?J??J????J??????J???J?????????JQz????QJ????J???JQo???QJ????XJp???J??J???J}??????VJ????J¡???J??J???J??????J????J? ??£???J????J??J???£J??????J????J???J????J??J????????J??J?J??????????J?????VJ?????J???J????J???????J??????XJ???Q??J????J¡???J£?? ?J?????J???KJ????74m??????????????KJ~rk~Q}Js~KKJk??J£??J?? ?J??J??J??J????J??J?????????J??¡???????J???J????J?¡?£XJk????J£??J???J ???J????J??J??VJ??J¡???J????J?????J]ZJ???????J???J????J??¡??????KJ????74|owowlo|VJ~roJwy|oJxo?}q|yz}JkxnYy|Jwo}}kqoJlyk|n}J?yJ zy}~JsxVJ~roJwy|oJwyxo?J?yJ?svvJwkuoKKJl~J?yJrk?oJ~yJzy}~JkJwsxswwJypJ\ZZTTJ????74~???Q?J??KJ???J¡???J?????J????? ???J????£J ¡?????J??£?KJ????74TTt}~JwkuoJ}|oJ~roJowksvJ?yJ}zzv?Js}Jo?km~v?Jk}Js~Jkzzok|}JyxJzk?zkvXTTJ????74o¢?????????J??J¡?£J??J¡???? J??J¡???dJ????74NNNNNJxy?J~roJ?r?Jzk|~dJy??J??J\ZZJ????????VJ??£JsJ????? ?J???£J_J???????JR?J ??£J??¡J?¢?????SXJ}?J????JsJw???JN _XZZJ¡???J?£J?????J??JM`J??J???J??????XJx?¡VJ????J??J???J_J???????J¡??J????J????J??JN[XZZJ????J???JwsxswwJ\ZZJ????????VJ????J¡? ??J?£J?????J??JM_J???J???£J_J???????J???????J??J????J??J???J????????J_VJ????J??J???????JN\_XZZJ???J??VJ??¡J?????J\_J????J????J\Z ZJwsxswwJ?????J¡???J?£J?????J??JM^J???J???£J_J???????J????VJsJ¡???J?????J??J??J??????????JN[\_XZZKJx?¡VJ?????J[\_J???????J????J ??????J???J????J???JwsxswwJ\ZZJ¡???J?£J?????J??JM]J???J???£J????? ?J_J???????J????VJsJ¡???J????J??J??????????JN`\_XZZKJyuVJ??¡J ????J??J???J???J????VJ????J??J?????J`\_J???????J????J?JwsxswwJ\ZZJ???????J¡???J?£J?????J??JM\J???J???£J???£J????? ?J_J???????J? ???J????J????J??JN]V[\_XZZKKKJ~????J]V[\_J???????J¡???J???J???? ??J????J???????J??J\ZZJ??¡???????J¡???J?£J?????J??JM[J???J??J??? ??J_J???????J???J\ZZJ??¡???????J?????JsJ¡???J????? ?JN[_V`\_XZZKJ????J??J????????J?? ???????J??J???£JN`XZZKJkwk?sxqKKJ????J£???J ?????J??J??J??????J??J???J????VJ£??J????J????J??????J???????J??J???J??¡???????VJ???J????J???J???????JN`XZZJ??J??????J??J???J???? VJ???????J£???J?????J??J??????J`J?????XJk??J?????J???????J?????XJ????74~??J?????J??J????????J??VJ?????????J??J??????J???J? ??J?? ?J¡????J???J???????J???J????????J???J???????J?????J????????J? ??£??£VJt}~JvsuoJ?yJ???J??¡KKJ????74}?J???J£??J??????JN`iiJk??J? ??J??J??J?????£J¡????iiJsJ?????J??iJz?????J?? ?J????VJ¡???J??J???J????J??J???£??J???J???J??J???J?????J£??J???J????£iJ}?J¡???J??? J???J???????J??J????J?????????J¡???J?????J???J????J??J??¡J??????J?????J???J??¡J??????J??????J¡??J???J???????J???J????????J???J?? ¡???????J? ??£??£J???J???J¡??????J??J?? ?J??J?J??£iJo????????J???J??J\ZVZZZJ??J_ZVZZZJ??¡J?????J? ??£??£VJ¡???J?????????J??J???? ?J???????J???J??????Js???????XJ????74|???????VJ???£Jpks|v?J???Jryxo}~v?J???J????J¡???J¡???XJ~???J?????£J???Q?J???????J???J??J??? ??J???¤£J?????KJk?J????J??J??????J?????¡J???????J¡???J???????J???JN`XZZVJ??J¡????KJ????74????J¡???J¡?????VJ?????J£??J???J£???J?? ??J????VJ?????dYY¡¡¡X??£???X???J????74???????[???\Z????74§74* =yend size=12350 crc32=15a8634 Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119681
  - 21
    - DateTime Problem I'm selecting some columns using a .net dataadapter using Select myDate from myTable. then I... DIM dt as new datatable myda.fill(dt) Now in dubugging I am examining the dt.rows(0).ItemArray (because I didn't trust what was displaying in my datagrid) It shows my date as being 8/31/2005 1:26:45 PM. The problem is that the real date in the database is 8/31/2005 1:26:45:197 PM !!! Something in the data adapter or something somewhere else is cutting off the 197. This is a big problem for me because I use this date later in a where clause for an update and the lack of the 197 is causing the where to fail. Why is the 197 being cutoff? What can I do about this? Thanks, T Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119678
  - 22
    - Dynamically cast native datatypes without switch statement? I return (as a DataTable) the table schema information on various columns in the database. For any column that has one I am accessing the DEFAULT value specified in the database for that column. The default value is returned as a string (e.g. "0" on a boolean or "getdate()" on a datetime). In addition, because I have a working dataset including schema, I can easily look up the DBType of the column whose default I am working with. I would like to dynamically cast the default value without using a switch statement. foreach(DataRow row in rows) { string tablename = row["TABLE_NAME"].ToString(); string columnname = row["COLUMN_NAME"].ToString(); object defaultvalue = row["COLUMN_DEFAULT"]; DataColumn dc = ds.Tables[tablename].Columns[columnname]; // the following line does not work, but illustrates my intent dc.DefaultValue = Convert.ChangeType(defaultvalue, dc.DataType); } In the past I have accomplished this with a switch statement similar to: object CastValue(DataColumn dc, string value) { object castvalue = null; switch(dc.DataType.ToString()) { case "System.Boolean": castvalue = bool.Parse(value); break; case ... case ... // and so on... } } Obviously, the switch statement poses more work than seems necessary. Any shortcuts for accomplishing the same? Even if the specifics of this example are not practical, it seems useful to be able to "dynamically cast" object values to native datatypes. I would truly appreciate any feedback. Thanks. Mario T. Lanza Clarity Information Architecture, Inc. CROSS POSTED FROM: microsoft.public.dotnet.csharp.general Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119674
  - 23
    - OleDb Provider for Excel Not Reading Properly I am having a problem with an Excel spreadsheet import using the Jet OLEDB Provider. One of the columns has a "Text" type in Excel, and the values are all numeric or have a character in the first position (but they should be read as character). A sample is ABC123 3904600098 My connection string looks like this (client is ADO.NET, .NET Framework v1.1 on WinXP-SP2): Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\....;Extended Properties="Excel 8.0;HDR=YES;IMEX=0;" When the "Select *" happens in my code, the data comes across like this: null 3904600098.0 Both are unacceptable because the first should not be null and the second should not be a decimal. If I change the connection string to this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\....;Extended Properties="Excel 8.0;HDR=YES;IMEX=1;" When the "Select *" happens in my code, the data comes across like this: ABC123 3.9046e+009 The first value is OK, but the second is unacceptable. I have set the Regisry Key at HKLM\Software\Microsoft\Jet\4.0\Engines\ Excel\TypeGuessRows to 85 to make sure enough data is being sampled by the provider. ImportMixedTypes is also set to "Text". How can I get consistent results for this data read? Thanks. Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119666
  - 24
    - Duplicate insert problem When using a datagrid on a simple form I get another entry that is exaclty the same to be inserted. The actual database values are correct (no duplication). Why is the datagrid showing me two of the same records even if the database has one correct insert. It is driving me insane. I checked the following: I checked my insertcommand statement and it is working exaclty like a new dataform that I created which is functioning correctly. I checked the ds object and dataadapter objects' properties and the form that works with the table has the same properties. If I refresh or reload the dataset the datagrid shows everything correctly. Its only when I run the following that the duplication shows in the datagrid. And again I noticed this wasn't happening on a form that I newly created using the wizard ( I basically modified my version for checking rows and other stuff) if ((objDataSetChanges != null)) { try { // There are changes that need to be made, so attempt to update the datasource by // calling the update method and passing the dataset and any parameters. if (MessageBox.Show("Do you want to save the changes?", "Save Changes", MessageBoxButtons.YesNo ) == DialogResult.Yes) { this.UpdateDataSource(objDataSetChanges); objdsTimesheet.Merge(objDataSetChanges); objdsTimesheet.AcceptChanges(); } } catch (System.Exception eUpdate) { // Add your error handling code here. throw eUpdate; } // Add your code to check the returned dataset for any errors that may have been // pushed into the row object's error. } Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119663
  - 25
    - DataReader vs DataSet Performance. hi Folks, I am about to start development on a new framework, and contemplating whether to use datareader to create objects or to use DataSets to create object. For a test scenario i created two classes , with each having 8 properties. Then i created two Data creation logics, one that fetched dataSets from DAL and creates the objects, and second one creates objects from DataReader. the dataaccess is done through the microsoft dataaccess application block these are my performance results. Objects created 4 220 22000 DataReader 1.40 2.006 50.59 (Avg Time in secs) DataSets 1.42 2.01 50.2 (Avg Time in secs) the code is exactly the same (except the actual creation logic) , the database is SQL Server 2000 so the question is , are datareaders really fast (as microsoft says) or am i missing something. ? Please comment Tag: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? Tag: 119656

I have potentially large PDF legal files (up to 10MB) that will be passed to
an imaging system via a webservice. Does anyone know which datatype I should
use for this? IOW, is there something akin to a "blob", since this is binary
data.

Top

Re: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? by Robbe

Robbe
Mon Oct 24 19:45:11 CDT 2005

byte[]

byte arrays and yes it would. 1.1 supports it too.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.masterado.net

"Ray Stevens" <nfr@nospam.com> wrote in message
news:OmLh3yL2FHA.2880@TK2MSFTNGP12.phx.gbl...
>I have potentially large PDF legal files (up to 10MB) that will be passed
>to an imaging system via a webservice. Does anyone know which datatype I
>should use for this? IOW, is there something akin to a "blob", since this
>is binary data.
>

Top

Re: Do DataTable's in ASP.NET 2.0 support "blob" datatypes? by Sahil

Sahil
Tue Oct 25 00:11:16 CDT 2005

Just do

byte[] myDoc= (byte[]) dr.Rows[0][0] ; // assuming column 0, row 0 holds
your PDF.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------

"Ray Stevens" <nfr@nospam.com> wrote in message
news:OmLh3yL2FHA.2880@TK2MSFTNGP12.phx.gbl...
>I have potentially large PDF legal files (up to 10MB) that will be passed
>to an imaging system via a webservice. Does anyone know which datatype I
>should use for this? IOW, is there something akin to a "blob", since this
>is binary data.
>

Top