| Visual FoxPro ConnectionString (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| hi guys i am very tired due to tring to establish a connection with a Visual FoxPro Database/Table. is there anyone know how can i connect with a Visual FoxPro Database/Table by using a connection string on VS.Net (VB.NET)...? thanks for all |
|
| Concurrency strange problem (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have a database that contains a fields called SetupStep, which is a tinyint. I have code that initially fills the dataset fine, and at a point in my ASP.NET app I change that value using the following code: Dim dsInvestigators As dsInvestigators New dsInvestigators() dsInvestigators CType(Session("dsInvestigators"), dsInvestigators) With DsInvestigators .jctUserProject.FindByUserProjectID(Se... |
|
| Is data binding overrated? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello All, When binding a dataset to a datagrid in asp, does this help or hurt scalablility. Doesn't the dataset stay in memory on the server? |
|
| To Choose between Dataset and Command Object (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi , I need to choose between using a Dataset or a Command object for data access in my application. My requirement is as follows : I have a set of around 20 web pages displaying data. While navigating between the pages, all the data needs to be maintained in the session, so that when a user comes back to a previous page, the data previously entered is shown. There is no database access while navi... |
|
| "Value cannot be null" error (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| When i try to fill a dataset using the ado.net stored procedure(i know the usp works) i get this error: Error: System.ArgumentNullException: Value cannot be null. Parameter name: dataSet It's a very simple query like: "SELECT TournamentID, TournamentName FROM tblTournament ORDER BY TournamentName" When I run the stored proc by itself, it works fine. The code generated to set up the stored proc is ... |
|
| Add New Row using Typed dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've wrote a simple WebService which use an Update function (update) and strongly typed dataset (dsBooks). [WebMethod] public void AddNewBook(dsBooks dsNewBook) { try { Update(dsNewBook); } catch { throw; } } Does anyone have some consumer code for this service which will create a new datarow based on the dsBooks dataset. I'm having create difficultly getting the consumer code below to work. myWeb... |
|
| create table without using SQL Statement (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Is it possible to create a new table from the dataset in the database without using "CREATE TABLE" statement ? Thanks |
|
| datarow identity (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi all I'm reading Microsoft ADO.NET (CH6) and have following question : The merge method looks for the datarow using its PK or unique value (as it says in CH2), how then can it find the row when the datatable doesn't contain a PK nor unique value ? Does a datarow have some sort of unique index ? thx Kris Outgoing mail is certified Virus Free. Checked by AVG anti virus system (http://www.grisoft.c... |
|
| Stored Procedure With Encryption and ADO.NET (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello everyone, I hope someone could help me figure out why I encounter an error when calling from ADO.NET a stored procedure that is encrypted. The error says "stored procedure is missing". Thanks. bitman |
|
| Connection Pooling + DataReaders - Question (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I'm developping an intranet system, that will be used by over 200 users in a near future. 50 % of those users will be using the system daily. This means that at least some of them will be executing the same modules at the same time... Now, I know that SqlCliet manages connection pooling automatically. This is great. But I also know that when a DataReader is executing, you cant use the same conn... |
|
| Trivial help needed. MS Access connection (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am so completely new to ASP and .net, but have managed to get my asp pages completed and working on my local system. My problem though is that I have copied my Access mdb file to my host web server into a data directory but I don't know what path I should be using to connect to it. My web sit is for example, http://www.MySite.com and the data directory is http://www.MySite.com/Data. Oh yes, one ... |
|
| sqlDataType.Int, Int32, Long ? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi All, Should I use Int32 or Long in VB.Net for sqlDataType.Int in SP. It seems they all work without problem. Thanks for any suggestion. Kind regards, Zhen |
|
| Doubt's regarding Connection Pooling (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| hai friends, i am creating a connectionstring with pooling option in it. When i use that connection string a connection pooling is created. When this POOL will be destroyed. I was using the performance monitor to watch number of objects(connections) in the POOL. whenever i rerun the program the POOL size increases. !)What is the life time time of a pool. 2)when a created pool will be disposed. My ... |
|
| SQL Server database structure update (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Our application uses SQL Server desktop edition. There are dozens of them out there. Now we need to add more tables and columns to the application. How can I update (programmatically via update application) the SQL servers? I used SQL DMO before but it is very limited. Can I do this with XML schema? If yes, what mechanism do I use to parse the schema and update the SQL Server? I appreciate any sug... |
|
| SqlParameter question (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I want to write a sort of generic function that executes a stored procedure against a SQL2K database. I want to pass it the name of the stored procedure and the parameters (only the values, not the names of the params). Problem is that I always seem to know the name of the parameters. I always have to do something like : oCmd.Parameters.Add ( new SqlParameter( "@paramname", "paramvalue" ) )... |
|
| Multiple datareaders, same Dbconnection (again) (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Please help and tell me exactly why I am receiving the ... 'There is already an open DataReader associated with this connection which must be closed first.' I have written a cut of the code below where you can see I do actually close the datareader. Both cat1 and cat2 in the Page Load are of type New Category. The database opens and successfully reads and sets cat1. When the database tries to use ... |
|
| announcement: need an asp.net developer in Dallas (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I've been a regular poster on these groups, and I am leaving my current position and I need to find an asp.net developer to fill my old position. Let me try to help someone here out. If you have ALL of C# (VB.Net and Java experience might do) ASP.Net (essential) ADO.Net (essential) worked with Dataset/DataAdapter (essential) please send resume to eric@pdi home.coTAKEOUTm WITH salary requirements. ... |
|
| Sum Of the Column (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I have couple of columns and rows in a DataTable. The dataTable is bound with the DataRepeater. Iwant to display the sum of columns in the Data Repeater's last row. How do I do this? Thanks in advance. Chakra |
|
| OracleClient, Update: OracleException (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi! I try to update rows using OracleClient. I have the following table in my Oracle 8i database: SQL desc COUNTER; NAME NOT NULL CHAR(32) VAL NUMBER(18) The code responsible for updating looks like that: Dim cn As OracleConnection New OracleConnection("...") cn.Open() Dim da As OracleDataAdapter New OracleDataAdapter("SELECT * FROM COUNTER", cn) Dim strUpdateCommand As String "UPDATE COUNTER SET ... |
|
| OUTPUT Parameters in Access using Insert query (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| How to get OutPut parameter from an Insert Query in Access???? i Need to get the RowCount value...much as i do in SQL Server using @@Identity Value. Regards Gianmaria |
|
| CANNOT UPDATE TABLE WITH COLUMN NAME "User" ? (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I finally got my search & replace across all tables working. It works fine for every table, except for 1 table which has a column name of "User". In design view I change this name to "User1" and it works fine. I would prefer not having to change the column name if possible. WHAT'S THIS ABOUT? NOTE: e1.Message returns "Syntax error in UPDATE statement" when column name set to "User" OleDbCommandBui... |
|
| Passing parameter to SQL (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have a SQL stored procedure which is.. CREATE PROCEDURE expireLead @cli NVARCHAR(30) AS Copy the details from leadsPending into expiredLeads INSERT INTO expiredLeads SELECT cli, title, forename, surname, callStarted,callEnded, caller, outcome, notes FROM leadsPending WHERE cli @cli Delete the record from leadsPending DELETE from leadsPending WHERE cli @cli Copy all instances from callHistory int... |
|
| DataColumn with Managed OLE DB Provider (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| We are having problems populating the ADO.Net DataColumn with our OLE DB provider. What interfaces are used to get this information? For example, the DataColumn.AllowDBNull is always set to true, regardless of what is returned by IColumnsInfo::GetColumnInfo (or IColumnsRowset.. although, it is never QI'd or used). Thanks, Darin |
|
| Deleting an inserted row (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have found that if I insert a row into a DataTable (into a position that is not the last row), then delete this new row, the corresponding row in the default view is not deleted. It references a 'Detached' row in the underlying DataTable. Even if I attempt to delete the new row in the default view (using the DataView.Delete() method) it is not removed from the view (even with AllowDelete set to ... |
|
| ASP vs. VB .NET Connection (6 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Connection below will work on the vb.net windows app, but connection will fail if Asp.net application. Can Someone please help me out here. Thanks Dim oConn As New SqlConnection() oConn.ConnectionString "user id tt;password xx;initial catalog nw;data source SQL2\test;Connect Timeout 30" oConn.Open() |
|
