Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Why won't my dataadapter update update?
DavidA - 21 Jan 2006 10:38 PM - 4 messages
I am trying to copy data from a table in one database to an identical table in another database. The first table (WOS) contains 11 records, the second (WOSAdmin) is empty. The problem is that the data is never inserted into the second table. ...
Score ado.net 2.0 and MSSQL AppRoles
Jeff Jarrell - 21 Jan 2006 9:48 PM - 6 messages
I recall reading that in the ado.net 1.1 that connection pooling should be disabled when using app roles.  I have avoided the issue so far. Is this still the case in Ado.net 2.0?  The ERP system work with that I work ...
Score Multi User Application
Frank - 21 Jan 2006 8:49 PM - 3 messages
Hi,      I have been written an application in visual studio 2003 (c# winforms) with microsoft SQL Server. Cuncurrency is what I have somewhat problems with. I have though about the following to make my application the closest to real ...
Score DetailsView ObjectDataSource and strongly typed dataset
Spotnick - 21 Jan 2006 7:56 PM - 1 message
When I found out about the detailsview control, I thought it would save me a lot of time when doing basic table updates. All my business logic layer uses strongly-typed datasets, and I did plug a detailsview using an objectdatasource, seems to work fine, until the ...
Score Pass DATE NULL to Stored Procedure.
hemant - 21 Jan 2006 7:35 PM - 3 messages
I have a date parameter, and i want to pass Date as NULL to the stored procedure, I dont know how to pass null for the date field. All suggestions welcome and appreciated. ...
Score Bulk Inserts with Transaction
Jan Waiz - 21 Jan 2006 6:56 PM - 6 messages
Hi All, i am a little bit confused whats wrong with my Code - be so kind and have a look at this: I have to do a lot of Insert-Statements into a SQL-Database after few Select-Statements. This should run in a Transaction. I have implement this ...
Score Free Hot Phone Sex
AnimalSperm - 21 Jan 2006 4:20 PM - 1 message
+8613352960090 100% Free multi-lingual AnimalSperm Production el***@digi-art.de ...
Score Free Hot Phone Sex
AnimalSperm - 21 Jan 2006 4:20 PM - 1 message
+8613352960090 100% Free multi-lingual AnimalSperm Production el***@digi-art.de ...
Score Free Hot Phone Sex
AnimalSperm - 21 Jan 2006 3:42 PM - 1 message
+8613352960090 100% Free multi-lingual AnimalSperm Production el***@digi-art.de ...
Score Time zones: Pretending to be somewhere else
Nathan Sokalski - 21 Jan 2006 3:34 AM - 6 messages
I use a webhosting service that is something like halfway around the world from me and most of the people that will be viewing my site (and I am assuming their server is too). This obviously has very little effect on what ...
Score WAT Does Not Recognize minRequiredNonAlphanumericCharacters Attrib
EagleRed@HighFlyingBirds.com - 20 Jan 2006 9:15 PM - 2 messages
I am using a custom provider for an ASP.NET 2.0 application using SQL Server 2005 store.  I need to allow passwords that do not contain non-alphanumeric characters.  I am try to set the minRequiredNonAlphanumericCharacteres to  ...
Score datareader - connected or disconnected ^_^
Fred - 20 Jan 2006 8:03 PM - 6 messages
hi, some time ago in "the dot net show" i heard that microsoft has found no usages for connected data access and all ado.net is disconnected; on the other hand many ppl belive data readers keep open connection to the database ...
Score Parameter Order
Vayse - 20 Jan 2006 5:18 PM - 4 messages
I never realised before that parameter order is important. It was only I was posting another message in this newsgroup that I realised it. Has it always been this way? As in this will work: Using connAsset As New OleDbConnection(My.Settings.AssetsConnectionString) ...
Score Multi-User ASP.NET App and the connection object
klj_mcsd - 20 Jan 2006 4:10 PM - 3 messages
Alright just to get this clear in my head. Which construct is better? Function getData1() 'Open New Connection object ...... 'Close New Connection object End function Or Function getData2() 'Get Shared Connection object If cn.State = "Open" then 'Use Connection 'Close shared connection ...
Score Create an 1.1 style dataset in ASP.NET2.0
Dunc - 20 Jan 2006 4:04 PM - 1 message
I have an app that I've converted to ASP.NET 2.0 from 1.1, but I need to extend it - particularly in the data layer - using consistent functionality. I'm aware of the new Datasets and TableAdapters, but they only work as ...
Score dataset design
pax - 20 Jan 2006 3:26 PM - 1 message
Hi, NG! Is there any way to make a certain DataTable-based class (one that inherits from DataTable) appear on the design surface of the DataSet designer and behave like a normal DataTable? Thanks. pax ...
Score Reading Parameter Size from Schema
Vayse - 20 Jan 2006 3:17 PM - 2 messages
Is it possible to read the size of a field from the schema? For examle, I am running a query Dim stSQL As String = "UPDATE Assets SET StatusID = ? WHERE AssetCode = ?" Dim commandAsset As New OleDbCommand(stSQL, connAsset) commandAsset.Parameters.Add("@AssetCode", OleDbType.VarChar, 6).Value = ...
Score Passing 2 paramter to store procedure ???
serge calderara - 20 Jan 2006 12:45 PM - 7 messages
Dear all, What is the way to pass 2 input parameters to a store procedure ? I have donme the following, but got an error that @Start was expected but not provide ??? =============== m_SqlParam = New SqlClient.SqlParameter("@Start", SqlDbType.DateTime) m_SqlParam.Value = CType(sStart, DateTime) ...
Score Problem Deploying App That Uses ADOX
Wayne Wengert - 20 Jan 2006 11:42 AM - 6 messages
The following is from another post I found  in a different group (no answer was given). It is exactly the problem I am having. Is there a solution? =========================================== I used ADOX to implement a File New menu item that creates a new .mdb file. ...
Score Get Free Testking Exams
shane.lari@gmail.com - 20 Jan 2006 10:44 AM - 1 message
Get Free TestKing Exams At [link] Rush to register your free Testking Exams at [link] Limited Time offer ...
Score Get Free Testking Exams
shane.lari@gmail.com - 20 Jan 2006 10:42 AM - 1 message
Get Free TestKing Exams At [link] Rush to register your free Testking Exams at [link] Limited Time offer ...
Score Speed up Visual Studio
Vayse - 20 Jan 2006 10:14 AM - 5 messages
Anyone got some tips for speeding up Visual Studio 2005? I'm usually using Visual Basic. It pauses for several seconds when I switch between code and form view. Longer if I have data components on the form. Even typing makes the mouse pointer disappear sometimes, I guess the auto ...
Score VS2005: dataset wizard: tableadapter connectionmodifier to public
Jan DHondt - 20 Jan 2006 10:11 AM - 1 message
Hi, After I designed a dataset with tableadapter in a class library in VB.NET 2005, I want to set the connectionmodifier property to Public , to be able to modify the connectionstring property from within my calling winform/webform applications. ...
Score Error migrating to .NET 2.0 : OracleCommand DBCommand cast error
eclypse - 20 Jan 2006 8:28 AM - 2 messages
After migrating our application to .NET 2.0 we're getting the following error message Unable to cast object of type 'Oracle.DataAccess.Client.OracleCommand' to type 'System.Data.Common.DbCommand' I'm using Oracle.DataAccess.Client. I'm getting the same message whether I'm using ODP.NET 9.2  or 10 ...
Score new to .net 2005
szRoyman@hotmail.com - 20 Jan 2006 4:05 AM - 5 messages
hi all: I'm new to .net 2005, and just download the webapplication project setup file from msdn link , here are my questions: 1) inside the IDE 2005, we can find the "WebSite" instead of the webapplication project. If Microsoft defined that is the new web ...
Score the_difference_between_SqlConnection.IDisposable.Disp=ADose()_and_SqlConnection.Dispose()
jinfeng_Wang - 20 Jan 2006 1:56 AM - 18 messages
hi, I have a question about the difference between SqlConnection.IDisposable.Dispose()  and  SqlConnection.Dispose(). Both of them realize the function of releasing the connection to the ConnectionPool?  Do they have the same effection source code?  If they ...
Score ODBC connection works, but connection string doesn't
jonefer - 19 Jan 2006 11:48 PM - 9 messages
I'm testing an app at work, the app is installed appropriately on the server and the SQL Server is on my laptop. I've gotten a test ODBC to connect to my laptop (using named pipes) but the connection string which I have in a Web.Config file, isn't working. ...
Score strange things with adonet 2.0 abstract DataObjects
Elhanan - 19 Jan 2006 10:19 PM - 3 messages
hi... i have a typed a dataset which i'm trying to load with data using IDataAdapter:                IDbDataAdapter a = GetFactory().CreateDataAdapter();             a.SelectCommand = cmd; ...
Score Book on ADO.NET
Anthony Malt - 19 Jan 2006 9:22 PM - 4 messages
Hi, do you have any recommendations about literature about ADO.NET (1.1) Thanks Anthony ...
Score Query to find profile data in aspnet_Profile
VB Programmer - 19 Jan 2006 9:18 PM - 1 message
What is the SQL syntax to find a profile value in aspnet_Profile? (ASP.NET 2.0) For example I'm looking for all users WHERE the "UserRace" profile value is 'Caucasian'. Thanks. ...
Score Updating FoxPro Memo field
jweesies - 19 Jan 2006 8:30 PM - 3 messages
I'm using the oledbvfp.1 driver and trying to update a FoxPro table with data in a asp.net application.  The update works fine unless the data contains a question mark, which produces a "no value given for one or more required ...
Score Columns on a table
millner,kim - 19 Jan 2006 8:20 PM - 2 messages
I am a new programmer. Is it always a good idea to put columns on a seperate table which are not updated very often and very big in size. Likes Customer notes. Is is good idea to put notes on a another table with Customerid as the key. ...
Score Multiple Data Transactions in same page
Srini - 19 Jan 2006 4:59 PM - 5 messages
Would this be an okay practice in an aspx page (I am using oledb) oledbconnection cn = new ....... oledbcommand cmd = new ..... cmd.connection = cn oledbtransaction trans = cn.begin......... cmd.transaction = trans cmd.commandtext = "UPDATE..xx..." cmd.executenonquery() cmd.commandtext = "UPDATE..yy..." ...
Score How to add new row to typed dataset
SH - 19 Jan 2006 4:48 PM - 9 messages
How do I add a new DataRow to a typed DataSet? I would expect the following code to work: Dim drCustomer As NorthwindDataSet.CustomerRow drCustomer = NorthwindDataSet.CustomersDataTable.NewCustomersRow drCustomer.CompanyName = "xxx" But the NewCustomersRow method is not valid. It doesn't even come up in ...
Score SQL 2005 and ADO.NET 1.1 connectivity problems
dotnetfan - 19 Jan 2006 4:32 PM - 5 messages
Is there a configuration trick for getting ADO.NET 1.1 applications to work with: 2005 Express Server 2005 Standard Server Enzo ...
Score Call function
BGO.UGent - 19 Jan 2006 2:30 PM - 3 messages
If have created this function for SQL Server 2005 Express, and want to call it from C#. Function is called in SQL as :     SELECT pkstock, fkStock, dbo.fGetStockPositionByName('0.5') from tblStock where pkStock = '6' compleet sql script included. ...
Score Counter for "foreach"
Maya - 19 Jan 2006 1:27 PM - 9 messages
Hi, How do I find the number of the current row in a DataRow being looped in a foraech statement without manually creating an increment-by-one counter? Thanks, Maya ...
Score Add and use a reference in VS2005
Li Pang - 19 Jan 2006 10:59 AM - 2 messages
Hi, I have a third party dll, and I used it within VS2003/2003, it works fine. Now I try to some codes for VS2005, I lost myself by how to add the reference and use it. I added the reference by clicking Website - Add Reference and select Browse ...
Score Problem on reading .csv files using OleDbConnection
Ray - 19 Jan 2006 4:18 AM - 4 messages
Hi All I've tried to read a .csv file and bind the data to a datagrid. I am doing sth like this:       conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+        "Data Source=" + csvPath + ";" + ...
Score How to insert rows into tables with Autonumber PKey by using DataSet and DataAdapter?
A.M-SG - 19 Jan 2006 1:53 AM - 12 messages
Hi, I have a strongly typed DataTable that represent a table with database with a primary key. I am trying to use the DataTable to add a new row to the database table by using a DataAdapter. Since the primary key is autonumber, I have to leave ...
Score Insert or Update don't work
Diana E - 19 Jan 2006 12:05 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp , works ok and after I see the datagridview and the new row is there, but the problem ir that when I stop the application and look my database in SQL Server 2005 the table don´t have the new row. ...
Score Update or Insert in tableadapter not working
Diana Estrada - 19 Jan 2006 12:02 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp , works ok and after I see the datagridview and the new row is there, but the problem ir that when I stop the application and look my database in SQL Server 2005 the table don´t have the new row. ...
Score Update or Insert in tableadapter not working
Diana Estrada - 19 Jan 2006 12:02 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp , works ok and after I see the datagridview and the new row is there, but the problem ir that when I stop the application and look my database in SQL Server 2005 the table don´t have the new row.:( ...
Score Update or Insert in tableadapter not working
Diana Estrada - 19 Jan 2006 12:01 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp with : dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter prensa = new Prensas.dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter();             int i = prensa.Update(ID, this.txtNombre.Text, int.Parse(txtNumero.Text)); ...
Score Update or Insert in tableadapter not working
Diana Estrada - 19 Jan 2006 12:01 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp with : ____________________________________________ dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter prensa = new Prensas.dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter();             int i = prensa.Update(ID, this.txtNombre.Text, int.Parse(txtNumero.Text)); ...
Score Update or Insert in tableadapter not working
Diana Estrada - 19 Jan 2006 12:00 AM - 1 message
Hi, I have a store procedure to insert , and I use tableadapter to execute this store procedure, when I run the application and execute the sp with : ____________________________________________ dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter prensa = new Prensas.dbPrensas2006DataSetTableAdapters.spq_PrensaTableAdapter();             int i = prensa.Update(ID, this.txtNombre.Text, int.Parse(txtNumero.Text)); ...
Score DataAdapter.Update
A.M-SG - 18 Jan 2006 11:22 PM - 2 messages
Hi, I underestand that DataAdapter.Update acts based on RowState to insert/update/delete records. Is there any possibility that I can see the scripts that DataAdapter generates and sends them to database? Or can I possibly monitor the DataAdapter activity? If there isn't any, what would be ...
Score using command to pass old and new values
anonymike - 18 Jan 2006 11:04 PM - 3 messages
Hello, I'm trying to find an example of using oracle command utilizing both the original and new values of a dataset (datatable) to pass into a stored procedure. For example, ---------SNIP ---------------- OracleCommand updateCommand = new OracleCommand("UpdateLocations",conn); updateCommand.commandType = commandType.storedProcedure; ...
Score SQL Server Connection Pooling
Alan Pretre - 18 Jan 2006 9:43 PM - 5 messages
Does minpoolsize=0 in the connection string for SQL Server mean that there is effectively no pool?  Or would there always be one connection after the connection was opened and closed once? -- Alan ...
Score n-tier, connectionstring and web.config
Bobstar - 18 Jan 2006 9:12 PM - 2 messages
Hello Im trying to figure out how to build an n-tier application the best way. Many of the resources i've read all points to a not so elegant solution. Hopefully I can get a brilliant advice/ hint here. ...
Score Filtering DataView and DataTable
Yossi And Inbar - 18 Jan 2006 8:57 PM - 1 message
Hi, I am using VS2003 c# I am using DataView to change details by creteria and i can Edit,delete and insert details into the view, but when i am trying to change my creteria for other view ,I lost all my ...
Score using BindingNavigator and BindingSource in VS.2005 express edition?
Elhanan - 18 Jan 2006 7:53 PM - 1 message
hi.. can i use the binding navigator and bindingsource with out the wizards but code only? my data source is oracle so i can't create connections visualy in winforms. so i have to use code only. i allready know i can't use tableadapters ...
Score cool list of threads for clearing Software Interviews
suraj - 18 Jan 2006 6:53 PM - 1 message
..NET Interview Questions [link] [link] [link] [link] ...
Score Joins with Datatables
Nask - 18 Jan 2006 6:35 PM - 9 messages
Hi I have stored within dataset, the data modeling of a database, with the intention of being able to work of disconnected way (datatables, schema, relations..) It is possible to create a Dataview with join of several datatables including in dataset? ...
Score Deriving System.Windows.Forms.TabControl and TabPages
Stephan Zaubzer - 18 Jan 2006 6:27 PM - 2 messages
Hi For some reasons I needed to derive TabControl and TabPage to add some additional functionality in the background. When working in VS.net you can only add a TabPage to a TabControl by right-clicking on the TabControl and selecting "add TabPage" or by ...
Score GetSchemaTable w/join returns incorrect info -- MS Ole driver / Or
Jeff Waters - 18 Jan 2006 5:24 PM - 1 message
I have a sql statement that is a simple join between 2 tables.  GetSchemaTable() returns incomplete and erroneous information.  For example, assume I have 2 tables: create table TBL_A (   ID     number(10,0) not null, ...
Score shared, read-only data
pax - 18 Jan 2006 3:54 PM - 5 messages
Hi, NG! Is there any way to share DataTable "definitions" across multiple DataSets in the DataSet designer? To make it more clear I need to have a "master" DataSet that contains unrelated tables (that are read-only at runtime, reference lists...) At runtime an instance of this DataSet will be globally ...
Score Sql Native Client vrs SQLClient Namespace...
rob lynch - 18 Jan 2006 3:53 PM - 3 messages
I am just trying to bend my mind around this one, and would love any good input to the subject. It seems that SQL2005 introduced a "new" way to access SQLServer with "SQL Native Client" and it is being promoted as a "Better Mouse trap" providing ...
Score Table.Select and Strong Data Typed DataSets
Rafael - 18 Jan 2006 1:47 PM - 3 messages
I’m using Strong Data Types DataSets. Using it is great for several reasons, one of them is creating new rows using NewTableRow, this row is not a simple DataRow, but a complex DataRow with table fields as properties, ...
Score Resolving an IP address from a SQL Server Instance Name
michael - 18 Jan 2006 12:57 PM - 7 messages
I have a code snippet that searches for available SQL Server Instances on the network and returns the instance Name(s). (See Bill Vaughn's comments in "Finding Instances of SQL Server for DropDownList" below - it's a great demo ...
Score DataTable.Rows.Remove not working
trialproduct2004 - 18 Jan 2006 11:58 AM - 3 messages
Hi all I am having application where i am filling datatable with one table of my database. After retrieving all records of table into datatable i want to delete some records depending on particular condition. So i used remove method as this is only method i found which is ...
Score statechange event in code
Ant - 18 Jan 2006 7:31 AM - 4 messages
Hi, If i have a design time connection object, I can click the objects statechange event & write code in the event handler to respond to the event being changed. No problems. However, if I create a coded conenction object in the click event of a ...
Score Need advice for tracking down a general network error exception
Alan Pretre - 18 Jan 2006 7:19 AM - 8 messages
I have an application installed at a customer site that has been getting a general network error for a couple of years.  I was hoping that .NET 2.0 would clear it up, but unfortunately it didn't.  The .NET 2.0 exception does ...
Score datacolumn replace
plmanikandan - 18 Jan 2006 5:29 AM - 4 messages
Hi, I have a datatable with two datacolumns as below Name(text)   status(int) wws              0 ddd               1 ...
Score Free mp3's
Jickles - 18 Jan 2006 5:25 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="[link]">[link] ...
Score Another goofy datagrid issue
Earl - 18 Jan 2006 5:24 AM - 3 messages
Posted this in the WindowsForms.Controls forum and got zero reponses (maybe they don't use the datagrid over there) .... If I create a datagrid column with Format set to "c", I've noticed that currency changes within the cell are not retained IN THE GRID upon leaving ...
Score Why not a view...?
Zamdrist - 17 Jan 2006 9:04 PM - 9 messages
Could someone educate me why this code doesn't work if the text argument of the SqlCommand method is a view, as opposed to a stored procedure when the view returns the same field(s) of information? Unfortunately debugging in ASP.Net is beyond me at the moment and all I ...
Score SQL Server connection issue
Earl - 17 Jan 2006 7:59 PM - 5 messages
Interesting connection issue to SQL Server: I have several apps that connect to the same server, albeit different databases. One app is VB6, the others are VB.Net (VS2003). On the development system, and on two separate test systems at different locations, ...
Score Free music - games - movies - software!!!
yodaddy - 17 Jan 2006 7:43 PM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>Get free music, games, movies and software!!! 100% legal!</P> ...
Score Is there no support for the new ADO.Net 2 features in OLEDB?
Cyril Gupta - 17 Jan 2006 4:12 PM - 1 message
Something weird is going on... I have installed the Visual Basic 2005 along with the .Net framework 2.0 but somehow the features that I should have got along with ADO.Net 2 are all missing. I don't see the extra Execute methods ...
Score Using autonumber int PK together with TableAdapter - Concurrency error.
Ola Fjelddahl - 17 Jan 2006 3:48 PM - 2 messages
hejdig. Have anybody had any success with implementing TableAdapters together with tables with an int PK that is set by the database? The problem is that when the row is inserted into the dataset's datatable, it is set to a value automagically.  When the row then is persisted into the ...
Score Connection String Question
Andrew - 17 Jan 2006 3:21 PM - 5 messages
Hello, friends, We have a connection string in our .net app configuration file like the follows: "packet size=4096;data source=server349;persist security info=False;initial catalog=universalDB;user=everyone;password=everyone;" Since each server has its own database instance, each time we deploy app to ...
Score DataSet scan efficiency
Maya - 17 Jan 2006 3:10 PM - 6 messages
Hello, I have a dataset i need to insert new datarow in if the row is new and doesn't exist in the dataset, other wise i will only need to update the existing row. for example, dataset with "ID" and "Name" fields can have a new row ...
Score BindSource.Find on two columns?
Steven Spits - 17 Jan 2006 2:35 PM - 1 message
Hi, I have a BindingSource with an underlying table that has two keys. I would like to set the position, but BindingSouce.Position = BindingSource.Find("column1", key1) is not enough because I need to specify two keys. I also tried something like BindingSouce.Position = ...
Score BUG? SqlDecimal = Single/Double: 4.475 becomes 4.4749999999999996D ????
Pieter - 17 Jan 2006 10:18 AM - 5 messages
Hi, I have a variable (m_sngPrixNetUnitaire) which is of type Single. When I want to write the value to my SQL SERVER 2000, I put this value in my DAL (MyDal.PrixNetUnitaire), which is of datatype SqlDecimal. But during the conversion the value changes, and MyDal.PrixNetUnitaire ...
Score Access database ADO.NET and Binary fields
@win - 17 Jan 2006 8:57 AM - 2 messages
Hi, I'm writing a small app. that needs to write some string and binary data to an access database with ado.net. At this point i'm using oledb to make the connection. After that I'm composing the SQL query  as a string. This works fine for the string data but ...
Score HOW TO: Build a Connection String Programmatically
_DS - 17 Jan 2006 8:36 AM - 4 messages
There is an article on MSDN called: "HOW TO: Build a Connection String Programmatically in ADO.NET by Using Visual C# .NET" [link] The article outlines adding refs to MSDASC and adodb to a project in ...
Score scope problem, I think
barret bonden - 17 Jan 2006 5:16 AM - 1 message
Writing a little experiment for paging up and down through records , works fine but for the call to update (button 3 click on the bottom of the listing) ; seems like a scope problem. I did create a module and declare v ...
Score Wilson's ORMapper.. Someone who can help me!?
szRoyman@hotmail.com - 17 Jan 2006 2:46 AM - 5 messages
Anyone who got the experiences on Wilson's ORMapper, please give me some suggestions . really urgent, I wanna build a web application for move out the database's name,table,fields,procedures.. I didn't use vs2005 coz I'm afraid of my old project on 2003 would ...
Score Using Output Parameters from SQL Server Stored Procedure to ASP.NET SQLCommand
Mr Not So Know It All - 17 Jan 2006 2:32 AM - 2 messages
im new to SQL Server and ASP.Net. Here's my problem. I have this SQL Server stored procedure with an input parameter and output parameter CREATE PROCEDURE [safety].[_getRCList] @in_rc varchar(8) @out_eList varchar(7) output AS select @out_eList = ecuid from _organization where rccode = @in_rc ...
Score Is it possibly to specify store procedure parameters by position instead by name?
SammyBar - 16 Jan 2006 6:46 PM - 3 messages
Hi, I'm developing a new .NET application but using the same stored procedures (Sql Server 2000) that are in use by an old client server application. The problem is that it is common when refactoring stored procedures, to change ...
Score Modifier for QueriesTableAdapter
Dick - 16 Jan 2006 6:40 PM - 6 messages
I can find the modifier for a TableAdapter - so I can make it Friend - but I can't see the same for a QueriesTableAdapter. Am I missing something? ...
Score Update Command Question
Vayse - 16 Jan 2006 6:27 PM - 11 messages
I want to set up a form where a user can enter the Purchase Price for some Assets. No other data will be entered, just the PurchacePrice. But I also wish to display several other fields, like the AssetCode, So I load the form ...
Score Disable BindingNavigator's buttons
Dick - 16 Jan 2006 6:00 PM - 2 messages
I can use the form designer to disable (any of the) BindingNavigator's items, (i.e. the MoveFirst, MovePrev, Delete, Add, etc. items). In the designer the items are greyed out and the properties say they are disabled. However, when ...
Score TableAdapter's TableMappings?
Dick - 16 Jan 2006 6:00 PM - 19 messages
I like the new TableAdapter in .net 2005 but is there a designer-based mechanism that populates a DataSet's multiple DataTables from a stored procedure that returns multiple result sets. i.e. to configure the equivilant of a DataAdapter's TableMappings? ...
Score Resolving DataSource if IP has multiple SQL Server instances
michael - 16 Jan 2006 5:31 PM - 5 messages
When assigning values to DataSource in a connection string (say with the SqlConnectionStringBuilder), I have generally used either the IP address or the name of the SQL Server instance as a value. With SQL Server 2005 I understand that a given computer can have multiple ...
Score Multiple currency managers ?
Earl - 16 Jan 2006 5:14 PM - 2 messages
I'm using a datagrid to display results from different tables and views at different times. For example, at one point, the quotes might be displayed, at another, the notes, and yet another, a list of addresses. I've run into ...
Score DataAdapter.Update calling Insert Command with DbNull values
misfit815 - 16 Jan 2006 3:46 PM - 3 messages
This is so completely baffling me that I'd throw it out for general consumption.  I have an enterprise application with dozens of DataAdapters.  All are based off a common DataAdapterBase class I engineered to streamline and standardize how typical data access works across the solution.  All work ...
Score SQLServer: query by form
Peter Baranyi - 16 Jan 2006 12:54 PM - 5 messages
Hi, most of the times I face the following situation: I have a relatively large table (or a result of a joined tables) from what I have to display in a grid some records, what correspond to some criteria. So what I do is: I place some ...
Score Applying changes to table
Anthony Malt - 16 Jan 2006 12:39 PM - 3 messages
Hi, my client sends a dataset with changes to my server. These changes have been created by the GetChanges method of the dataset. What's the easiest way to update the table on the server with these changes? What a Stored Procedure look like to do this? ...
Score Displaying SQL Image data type information
Linda U - 16 Jan 2006 12:37 PM - 7 messages
Is there a way to Memory Stream Information into a WebBrowser Control? I have an SQL Image (could be any file type)  that I would like to display in a WebBrowser Control, currently I have to File Stream this ...
Score How to export the schema of a database
ad - 16 Jan 2006 11:59 AM - 1 message
I am using VS2005 with SQL2005. I want to write the document of my database. How can I export the schema form database? ...
Score How to remove a row of a Datarow()-Array
lvpaul@gmx.net - 16 Jan 2006 9:41 AM - 3 messages
Hello ! I have a Datarow()-Array ! Dim dvAuf As DataRow() dvAuf = dtAuftrag.Select("artnr = 'xyz'") while dvAuf.GetUpperBound(0) > 0    dvauf().delete end while Is it possible to delete a certain row of the Array ? Thanks aaapaul ...
Score Basic question about datasets
Chak - 16 Jan 2006 6:04 AM - 11 messages
If i am running a Windows Forms application from a remote PC, and the application creates a dataset, am i right in assuming that the dataset will reside in the memory of the remote PC ? And if the client is running the ...
Score TableAdapter and Identity Column Values after INSERT
Mark Olbert - 16 Jan 2006 1:48 AM - 7 messages
It appears that the neither the TableAdapter DbDirect methods nor the TableAdapter Update method update identity column values with the values after an INSERT operation. Is this correct? If so, what is the best way of retrieving the identity column value? ...
Score Question: moving around SQLExpress MDF file...
VB Programmer - 16 Jan 2006 12:11 AM - 2 messages
I have a SQLExpress MDF file that I'm using for membership data, etc... in my ASP.NET 2.0 website. 1.  If I want to use the website MDF during development on my local machine can I simply copy the MDF from the website and replace the one on my dev ...
Score Change color by line based on row column value in asp:DataGrid?
Randall Parker - 15 Jan 2006 11:59 PM - 3 messages
Using an asp:DataGrid on a per row basis is there a way to make a certain cell or row have red, yellow, or white background based on the value of one column in the data row? e.g. if myvalue < 0.0 ...
Score Simple problem passing nulls with ADO.net 2.0
Simon Harvey - 15 Jan 2006 5:20 PM - 5 messages
Hi everyone, I'm having a really simple problem - I can't seem to insert a null value into the database. When I do it tells me that the procedure expects the parameter and that I'm not providing it. ...
Score Finding Instances of SQL Server for DropDownList
michael - 15 Jan 2006 1:49 PM - 8 messages
I'm writnng a support routine which helps log on to instances of SQL Server. Currently I populate a DropDownList with known names of SQL Server Instances. What I would like is a simple way (if possible) to populate this control by ...
Score Where to put an event handler
Ant - 15 Jan 2006 10:44 AM - 3 messages
Hi, a simple question. Say I have a connection object in a button event handler. I want to add a message box that pops up to say the state of the connection has changed whenever I open the connection by pressing the button in which the instance ...
Next »