Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score What is DataBinder mean in DataBinding
ad - 5 Mar 2005 11:26 PM - 3 messages
When I modify the DataBingind is VS. It will result in a DataBinder.Eval(Container, FieldName) format What is the DataBinder mean? ...
Score integrated Secure
ad - 5 Mar 2005 10:26 PM - 5 messages
I want to set integrated Secure in my connect string to SQL Server I set the connect string as: workstation id=xxx;packet size=4096;integrated security=SSPI;initial catalog=vvv;persist security info=False and I have execute sp_grantlogin 'ServerName\ASPNET'  in Sql Query Analyzer ...
Score Returning fastes datastructure...
Anders S. Willumsen - 5 Mar 2005 12:59 PM - 3 messages
I need to return a fast datastructure from our datalayer (connected to a SQL-server) to middletier. What is the fastes one avalible? I'm don't think a can return a datareader (midd.layer might not close the reader) - but what ...
Score Performance: searching and updating
kh - 5 Mar 2005 10:45 AM - 4 messages
Hi. I have profiled my code and discovered where the bottlenecks are: 1. To find unique records I have been using DataTable.Select() but this appears to be quite slow. What is the fastest method of searching keyed data for a row with a particular key value? ...
Score Problem using Composite Key...
Ashwin Murali. T - 5 Mar 2005 9:35 AM - 4 messages
I have a table called orderdetails which has a composite key.  It is made of OrderID+ItemCode. The OrderID comes from the Orders table and the ItemCode comes from the Items table.(Foreign Key Constraints) I have a winform application where i have a combobox which displays the ...
Score Database Update
Vibhu Bansal - 5 Mar 2005 8:27 AM - 4 messages
Hello all, I am using ADO.NET and trying to update the MsAccess database but unable to do so. Here is the code below that I used.     Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As ...
Score Loosing ChildRelations when doing an update via remoting
Joe - 4 Mar 2005 11:36 PM - 6 messages
I have a method in my remote object which takes a DataTable. When the function returns my ChildRelations are gone. This means I have no way of updating the rows in the child table. Is there anyway around this? public override void UpdateTable(ref DataTable dt) ...
Score Merge 2 datasets,no duplicates ?
GATMAN - 4 Mar 2005 11:19 PM - 3 messages
hello i have 2 data sets and i only want to put the data from ds2 into ds1 that isn't in ds1 already, i used merge but that just appended the whole ds2 into ds1, is there a way ...
Score mergE 2 datasets, no duplicates ?
GATMAN - 4 Mar 2005 11:19 PM - 4 messages
hello i have 2 data sets and i only want to put the data from ds2 into ds1 that isn't in ds1 already, i used merge but that just appended the whole ds2 into ds1, is there a way ...
Score dataset and xsl transformation
NormD - 4 Mar 2005 10:35 PM - 4 messages
We have a webservice that has a method and this method returns a dataset. In the client we can change values of this dataset and send it back to webservices which in turn updates a database. Well we discovered a problem ...
Score Update Command works erratically
mkidd - 4 Mar 2005 9:54 PM - 3 messages
Hi, I'm very new at this, guessing I'm missing something simple-- I have an interface for a "Company" table that consists of a list box where the Company names appear, then a few text boxes that show the rest of the ...
Score Insert Commands SQL Server
Charles A. Lackman - 4 Mar 2005 8:24 PM - 3 messages
Hello, I have written quite a few programs that use Jet4.0 databases.  I just recently updated to SQL Server and have run into a problem with sending Insert commands. Using OleDb this works with no problems against Jet 4.0 and dBase and other ...
Score DataAccess Application Block
Robert - 4 Mar 2005 7:01 PM - 6 messages
Is it possible to return multiple output parameters form a stored proc using the Microsoft DataAccess Application Block?  I need 2 values back from a table and I do not want to bring back a dataset and I want to do it in one ...
Score What is SAPWD and how to use it
galb - 4 Mar 2005 5:49 PM - 2 messages
Hi, I'v tried to install MSDE 2000 and at the begining it requires a strong SA password. I don't know what it is or how to install/configure it so i can't install the MSDE 2000. If anyone knows how to dill with it  please specify the steps required ...
Score Home directory in IIS?
Krunom Ancini - 4 Mar 2005 5:03 PM - 5 messages
Hi, all stuff works fine if i define absolute paths but with relative i have some problems: i defined my at Internet Information Services (IIS) home directory of my "default web site" and I define in my application all file destinations ...
Score OleDB vs. SQL
Bill K - 4 Mar 2005 4:49 PM - 3 messages
I'm building an app in vb.net and connecting to a SQL Server 2000 Database.  Does it make a big difference if I use OleDb data adapters as opposed to SQL data adapters? Thanks, ...
Score Improving DataSet.Merge() performance
kh - 4 Mar 2005 3:31 PM - 9 messages
Hi. My users want to be able to be compare data. The data for each object to be compared is in identical DataSets so we decided to use DataSet.Merge() and then bind the resultant DataSet to a grid. By appending a number to the ...
Score Dataset: MultiUser Synchronization
Microsoft - 4 Mar 2005 2:19 PM - 3 messages
Hi, can any one pls tell me how can we use the DataSet in the MultiUser, or else web application, as it is a disconnected architecture. here is an example: I have a web App. and many user will be useing the same set of records lets imaging: Railway tickets ...
Score Problems when creating and using a ADODB.Recordset in a .NET assembly.
Magnus Strandberg - 4 Mar 2005 2:01 PM - 4 messages
Hello, We are developing a WEB - application in .NET to be hosted on a Windows 2000 Server platform. Internally we need to create and use an (Interop) ADODB.Recordset. We do this with the following code: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' using ADODB; ...... ADODB.Recordset oRS = new Recordset(); ...
Score nunit testing data reader
Darren Guy - 4 Mar 2005 1:29 PM - 3 messages
If this is in the wrong newsgroup, my apologoes, and please tell me the correct newsgroup to repost in Been using nunit for new project that I am working on, but have now hit a stumbling block. I am calling a routine that will return a data reader, but i do not know how ...
Score Problems to access data and saving date/time to database
Ruy Castelli - 4 Mar 2005 12:28 PM - 2 messages
I created a ASP.NET page using C# and I'm using two components to access a MS-Access database, which are: - oleDbConnection - oleDataAdapter The MS-Access database is in the correct directory (IIS has permission to read/write) and everything seems ok, but IIS says that it can't open the ...
Score Save tables in XML files
Reg - 4 Mar 2005 11:53 AM - 3 messages
Hello, I need to save my dataset in an XML file. I use a XSD file like 'books.xsd' that you can find everywhere in SDK. So, I have two tables and I save them Mydataset.WriteXml("fileName.xml") I have a xml file with all data of my first table and after all data of my ...
Score Why two connections?
Adam - 4 Mar 2005 11:29 AM - 4 messages
I have built a very simple single form Application, with a sqlDataAdapter, sqlConnection, dataSet and a Grid. As soon as I load the application and bind the data (Fill the dataset or Open the Connection) there are two connections from my App in SQL Server (sp_who2) ...
Score binding tables with relationes to 2 dropdownlist
barney - 4 Mar 2005 11:05 AM - 4 messages
Hi, I'm trying to get a kind of dependency to 2 dropdownlists in asp.net: After selecting a Vendor the 2nd Dropdownbox should only show Orders linked to the selected Vendor. ( Both Dropdowns do autopostback ) But it always shows all values ... ...
Score DataGrid Contents to Excel - Advanced Methods
MattC - 4 Mar 2005 9:56 AM - 4 messages
Hi, I am trying to export the contents of a DataGrid to Excel.  I have already found the following articles: [link] [link] ...
Score Return Value on a diffrent form
Rudy - 4 Mar 2005 4:15 AM - 2 messages
Hello all! I have SP that returns a value.   txtTableid.Text = cmdLog.ExecuteScalar is basicly the line of code to get this return to this text box.  Thanks again for the tip on that one.  Anyway, I want this text box to be on a diffrent form.  When the button is clicked, ...
Score What is the Right Database For Me??
Charles A. Lackman - 4 Mar 2005 12:41 AM - 10 messages
Hello, I am trying to find a database that will not cause me to go bankrupt. Looking for a database that: 1)  Has ADO.NET Drivers       (I have noticed that ODBC Drivers loose Data integrity if there are ...
Score IIS failure when Access DB linked to outside tables
chris - 3 Mar 2005 11:42 PM - 4 messages
I have an ASP application that relies on an Access database with linked tables. The application works fine on the internet (the site functions properly). In the testing environment I need to have the table links set to emulate the website, or change the links prior to posting a copy ...
Score Fields in Dataview
Andrew Mason - 3 Mar 2005 8:09 PM - 2 messages
I have a dataview created from a datatable and have a datagrid bound to that dataview. I don't want to display all the fields in the datatable in the dataview or datagrid. How would I be able to hide some of the fields in my ...
Score Returning cursor from stored procedure
Michael - 3 Mar 2005 5:40 PM - 5 messages
Hi all.. I have a stored procedure that needs to return a record from one of two tables. I'm using an outpur parameter of type cursor. In the proc, I test if the record exists in table 1, if so, retrieve and store in the output. ...
Score Does the DataSet have a future?
Greg Gates - 3 Mar 2005 4:50 PM - 5 messages
I have recently finished reading 'Hibernate In Action' by Christian Bauer and Gavin King. I'm quite impressed with the functionality that is available in Hibernate. I am now questioning if the DataSet has a future. While the DataSet certainly contains a good deal of very useful ...
Score Default VS NULL
Janaka - 3 Mar 2005 4:38 PM - 6 messages
I'm designing a table which has a foreign key field which may be nullable. This is the only field in the table that may be NULL and I prefer to use a default value instead if that's possible. ...
Score fails trying to update:'System.InvalidOperationException'
Barret Bonden - 3 Mar 2005 3:54 PM - 3 messages
I get "An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Update unable to find TableMapping['Table'] or DataTable 'Table'." in da.Update(ds) , the last line of code in the listing below, as I'm trying ...
Score Problem with writexml and typed dataset
Bastoune - 3 Mar 2005 3:27 PM - 2 messages
Hello, I genere a file xml since a typed dataset, my problem when the file is generated, it is created not the elements in the good order. This is a part of the XSD : <xs:element name="AA" minOccurs="0" maxOccurs="unbounded"> ...
Score Min and Max ADO.NET
11Oppidan - 3 Mar 2005 3:12 PM - 6 messages
Hello, What is the simplest way to get the minimum and maximum values from a specific column of data in a populated datatable in a dataset, using ADO. NET and VB.NET. Many thanks for your help ...
Score OracleDataAdapter doesn't read the whole content
pascal etter - 3 Mar 2005 6:21 AM - 3 messages
Hi together I have the following situation: I have a table in my oracle db called "actionattachments" which contains 2 columns, actionid (integer) and bytedata (long raw). To get the data I use the oracledataadapter but there is one problem. Tha ...
Score DataView Find fails??
Bruce A. Julseth - 3 Mar 2005 2:34 AM - 2 messages
Why does this "fail?" dvRecords.Sort = "PrimaryKey desc" intRecords = dvRecords.Find(16) Returns a -1. There is a 16 in the PrimaryKey Column Thank you... Bruce ...
Score Autoincremented value of the last record entered
Bruce A. Julseth - 3 Mar 2005 1:47 AM - 7 messages
I want to find the primary key (autoincremented) of the record I just saved (i.e.. the last record saved).  With SQL, I can do this with "Select Top 1 PrimaryKey from database Order by PrimaryKey desc."  How can I do this with ...
Score scope-identity value without using stored procedures?
Sue - 3 Mar 2005 12:47 AM - 3 messages
Is there a way to get my hands on the scope-identity value after a SQLCommand ExecuteNonQuery Insert to a SQL Server table with an auto-increment identity field without using a stored procedure - using VB.NET? tia, Sue ...
Score Does enforceconstraints mean errors or relations??
bjako - 2 Mar 2005 11:06 PM - 2 messages
Does the EnforceConstraints option on a dataset just basically turn on and off errors? I read the doco thinking it meant I could temporarily turn off the relations that were added to the dataset but it would appear it has no ...
Score How to create/edit tasks on an Exchange 2003 Server using vb.net
Daniel Walzenbach - 2 Mar 2005 10:09 PM - 2 messages
Hi, I want to build a website which allows me to create new tasks on an Exchange 2003 Server for any users. I also want to be able to request the status of the taks and display it on the website. Does anybody know ...
Score Multiple raiseerrors = SqlException.Errors
DW - 2 Mar 2005 8:35 PM - 4 messages
Hi all, I posted a question a couple of days ago, but did not receive any answers. I´ll try to explain my issue a bit deeper. I will also attach some example code. One stored procedure and some C# code. ...
Score set data connection to nothing
Kurt Schroeder - 2 Mar 2005 6:41 PM - 3 messages
I was just told that it is good practice to set a data connection to nothing after it is closed becaue this will clear the object. Other wise the dataset is closed but the object will remain until it times out. Is this really true  ...
Score Can a DataReader go against a SQL View, how about an UDF?
Mark Bosley - 2 Mar 2005 5:42 PM - 5 messages
The SqlCommand.CommandType property seems to accept only "Text" or StoredProcedure Am I missing something? Cheers, Mark ...
Score Select DataTable Row from datagrid
Andrew Mason - 2 Mar 2005 5:22 PM - 3 messages
I have a datagrid that is bound to a datatable. I would like to select the correct row in the datatable when a user clicks on a row in the datagrid. I thought that it would look something like this; ...
Score ExecuteReader() not firing exceptions from stored procedures, also HasRows() vs Read()
James Hokes - 2 Mar 2005 4:00 PM - 7 messages
Hi All, We're using the 1.1. Framework against SQL Server 2000, and are having a strange issue where we don't get errors back from the stored procedure, i.e. the exception never gets thrown. The scenario is this: ...
Score max Form Height
rbutch@coair.com - 2 Mar 2005 3:37 PM - 4 messages
hey guys, this is a VB.NET Windows Application question. i've got an application that needs to have a ton of controls on it. it's basically an employee timecard, so for each ee theres three rows of 16 textboxes, with corresponding dropdown boxes ...
Score Ado type updates in Ado.net
Byron Hopp - 2 Mar 2005 2:42 PM - 5 messages
Is there a similar way to append, delete, and update records via an object in Ado.net similar to a Adodb.Recordset in Ado? i.e. in ado I have done these tasks this way in Ado... *** not tested Append *** ...
Score Oracle Boolean
Jim Heavey - 2 Mar 2005 2:09 PM - 3 messages
I'm able to create a parameter with a type of Boolean in my Oracle stored procedure, but when I look at the data types that I have available to me when I am creating the parameter, I do not see a boolean data type.  What type do ...
Score Treeview and datagrid
Huahe - 2 Mar 2005 12:49 PM - 3 messages
Hello, I have a problem. I'm using a treeview and a datagrid. I'm adding the nodes dynamically to the treeview based on a dataset. The nodes have checkboxes. I want to display the data in the datagrid based on the checked nodes in the ...
Score ADO.Net SQL Update
Sam - 2 Mar 2005 8:49 AM - 6 messages
I want to perform SQL Update via ADO.Net but encounter error message. Coding ------- Dim okcon As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) Dim updatecmd As New SqlCommand() updatecmd.CommandText = "Update F0902 Set amount = gbawtd" updatecmd.Connection = okcon okcon.Execute() Please guide me the correct method of ADO.Net SQL Update based above coding. ...
Score General Network Error: query->restart server->query again
headsea - 2 Mar 2005 8:03 AM - 2 messages
connStr="Initial Catalog=EDEMO; Data Source=ELVIS;Integrated Security='sspi'" conn=new SqlConnection(connStr); conn.Open(); cmd=new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); ------------------------------- restart the Sql Server  (implemented by Process Object, abbreviated here) ------------------------------- connStr="Initial Catalog=EDEMO; Data Source=ELVIS;Integrated Security='sspi'" ...
Score ConnectionRead (WrapperRead()) timeout
Doug A. - 2 Mar 2005 5:29 AM - 5 messages
We have an application that runs fine for 2-3 days, then suddenly begins erroring out. This may continue for several hours/days until a job runs on the database being accessed, then begins running normally again. The time & ...
Score dataSet.ReadXML returns more tables than it should - HELP!!!
nish - 2 Mar 2005 5:14 AM - 2 messages
hi, so i have an xml file as follows: <Employees>   <name>         <empName>nisha</empName>         <state>NJ</state> ...
Score dataSet.ReadXML returns more tables than it should - HELP!!!
nish - 2 Mar 2005 5:12 AM - 2 messages
hi, so i have an xml file as follows: <Employees>   <name>         <empName>nisha</empName>         <state>NJ</state> ...
Score Events for ReadXML Method
Jeff B. - 2 Mar 2005 2:47 AM - 4 messages
Does anyone know if there is any way to trap some type of event that gets fired when the ReadXML method is called?  What I am doing is reading in an XML file (that was exported from an ADO.NET DataSet from another process) ...
Score Omit DataGrid Columns
Eric - 1 Mar 2005 10:36 PM - 8 messages
Is there a way to limit the columns that are viewable in a datagrid? The only thing I can think of is to create a new table and loop through the original table to fill the new table.  The problem with this is that if I ...
Score HasRows() vs. Read() and ERROR suppression
James Hokes - 1 Mar 2005 5:33 PM - 15 messages
Hi All, We're using the 1.1. Framework against SQL Server 2000, and are having a strange issue where we don't get errors back from the stored procedure, i.e. the exception never gets thrown. We use SqlDataReader objects to stream stored procedure results back when we ...
Score Does ADO.net have equivalent to ADODB.Recordset.GetString() in VB6
Beve Lyni - 1 Mar 2005 4:51 PM - 5 messages
Hi, This is a question about performance. We executed a SqlClient.SqlCommand to fill a dataset with 10 recordsets from SQL database and exported to the datafiles in text format. It is very slow with large data set. Then I changed to use datareader and had the speed ...
Score get stored procedure structure
St - 1 Mar 2005 4:24 PM - 3 messages
Hello, is it possible to get stored procedure from sql server ? For exemple, I am using GetSchemaTable to get schema from a table, but is it possible with a stored procedure ? Thanks St ...
Score Using OleDbDataAdapter Fill when INNER JOIN specified
Ian - 1 Mar 2005 4:10 PM - 3 messages
I want to produce a Crystal Report in ADO.NET that uses a dataset with data from more than one table.  There are references everywhere that ADO.NET datasets can use more than one table, such as the quote from the Crystal Reports walkthroughs reproduced on MDSN: "...the Fill method connects to the specified database, fetches the data, and disconnects from the database. If you want to add more than one table from the ...
Score Dataset performance
Alberto Ortega - 1 Mar 2005 3:02 PM - 11 messages
hi, i´ve got this situation: * One dataset with 5 tables * One of those tables has almost 140.000 records * No more than 5000 records on the other 4 tables Then I´ve got to do calculations over those 140000 records and it´s really ...
Score how to give proper permission for asp.net in sql server express
Chen Xiyang - 1 Mar 2005 2:50 PM - 3 messages
hi, i have a problem which bothered me for a long time. i tried to connect my asp.net page with sql server express 2005 and always got some error msg telling that the current nt account doen't have enough permission. ...
Score Merging typed datasets
liam - 1 Mar 2005 1:31 PM - 3 messages
I have two typed datasets, ds1 and ds2. ds1 is the original dataset. ds2 is another dataset with some updates. I call: ds1.Merge(ds2, False) ds1.AcceptChanges() But the information in ds2 has not be transferred to ds1!  Is there anything that I am missing here? ...
Score Can't get WHERE-syntax in place
Morten Snedker - 1 Mar 2005 12:57 PM - 5 messages
This is from my Query Analyzer: select * from tblDokument where CONTAINS(Content,'"*this-text*" and "*that-t*"') I can't seem to get the quotation right in my rs.Open: rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content, ??, cn) Thx in advance for your help! :-) ...
Score Updating with a Typed Dataset
liam - 1 Mar 2005 10:21 AM - 2 messages
Hi, My situation is this... I have a webservice which returns a typed dataset containing information that is to be used to update a database on the client.  The database on the server is the same as the database on the client (except for the ...
Score Fillschema does not import constraints
Danilo P. - 1 Mar 2005 10:21 AM - 2 messages
Hi everyone. I'm trying to interact with ADO.NET and its DataAdapter and DataSet classes to discover the potential this tool offers. After studied all concern the theory I start to play with compiler and in one of my code snippet I try to fill the schema of a SQL Server table in a ...
Score Copy one table from MSAccess to MySql via .NET
Mauro D. - 1 Mar 2005 10:03 AM - 3 messages
from the subject... Do I have to copy the table into a datatable and then copy it to Mysql via two different DataAdapter? Thanks Mauro ...
Score Difficulty reading data from MS Access
Joe Pace - 1 Mar 2005 9:57 AM - 2 messages
I have a small problem deploying a VB .net application. When I run the solution from within the development environment, it reads the data file without any problems from an .mdb file. When I run the executable directly, (debug or release versions) it halts when reading data from tables within the ...
Score which way is better?
Scott Reynolds - 1 Mar 2005 9:52 AM - 4 messages
Hello! I developed a web application to display results from the database. Now I need to add search function, to search, sort and filter data. My question is, which way is better... 1) Store all related data in a single DataSet and use DataView to filter and ...
Score Wrong version using Jet?
Magnus Blomberg - 1 Mar 2005 8:24 AM - 5 messages
Hello! I am trying to use OleDB or ODBC to connect to an Jet DB *.MDB file. I am using Windows Server 2003 and .Net 2005 beta, but I can't connect to it. Alla I get is "The .Net Framework OleDb Data Provider requires Microsoft ...
Score Limiting the # of rows returns by a query
DavidM - 1 Mar 2005 5:31 AM - 7 messages
ADO Classic had a MaxRecords property the allowed you to limit the number of rows being return by a query. If there is a similiar property in ADO.NET and if so, where is it? ...
Score Re: Problem in Updating records in DataGrid Control
Ganapathi Hegde - 1 Mar 2005 3:47 AM - 2 messages
Hi Elton wang, This was problem. I was facing. Thanks for your reply. It got resolved, as now I am binding datagrid only once. I have used IsPostBack property of page for this. Regards, Ganapathi ...
Score loading tab-delimited files...
gloria - 1 Mar 2005 1:38 AM - 15 messages
Hey kids, I need to work with a tab-delimited file and load and validate the data before inserting it into various tables.  Is there a way I can load it directly a temp table or load it into a DataSet?  This would be much ...
Score fails trying to save :unhandled exception of type "system.nullreferenceException.
Barret Bonden - 28 Feb 2005 11:45 PM - 4 messages
I get "An unhandled exception of type "system.nullreferenceException. Object reference did not set to an instance of an object" while trying to save back to the database -  relating to :  da.Update(ds) , the last line of code in this listing. Just starting tyring to learn data ...
Score Access datasource through forms
Hemang Shah - 28 Feb 2005 10:53 PM - 4 messages
Hello How can I access dataset defined on one form by all the other forms opened by that form ? Is that even possible ? if so, how ? Thanks ...
Score SQL timestamp column for concurrency
Ade - 28 Feb 2005 7:33 PM - 4 messages
Excuse my ignornance but I am relatively new to .NET. We have migrated a solution from Access to web based and have a fully working solution except that we failed to consider multi-user use in ceratain areas, although last-write is OK it has caused a few minor issues with some information being ...
Score C# and MySQL using ByteFX Data Provider
myUsername? - 28 Feb 2005 5:50 PM - 3 messages
hi all, I want to get an db connection to a mysql database, using the bytefx data provider. I want to use this provider because i have to migrate my webservice to Linux/Mono and as I know, the mono mySQL data ...
Score Integrated security
Arne - 28 Feb 2005 5:13 PM - 5 messages
How do I create trusted security between my web server and my sql server? I don't know the account and password that my web server is running under. ...
Score Autonumber Column in Insert
mh1mark - 28 Feb 2005 4:55 PM - 5 messages
I have an Access table I am doing an insert into.  The Insert  includes a select from another table, but does not include the column name of the autonumber column.  If I run the query in Access, it inserts correctly, ...
Score ADO.Net DateTime issue
Paul Yanzick - 28 Feb 2005 4:06 PM - 6 messages
Hello, I'm having some issues pulling a datetime object from a database and am looking for any suggestions I can get. I have written a function to make querying specific fields in a table as generic as possible.  The function is below: ...
Score Multiple table dataset
Bill K - 28 Feb 2005 2:57 PM - 6 messages
I have a classic scenerio - simliar to the Northwind Customer/Ordes/OrderDetails.  I want to select a customer from a combo box, display pertinent info, and display in a hierarchical datagrid the orders and ordertails (in to next layer).  I am creating 3 dataadapters, one for each ...
Score Populating Columns
Ian Frawley - 28 Feb 2005 1:16 PM - 3 messages
Hi All, I was just wondering if this is possible. I have a strongly types dataset that has a number of columns that are populated and a couple of columns that aren't populated. I was wondering if it is possible to populate the unpopulated coulmns using a SqlDataAdapter ...
Score OleDbException on Access DB Query
Nick - 28 Feb 2005 10:23 AM - 7 messages
Hi, I get this error where calling a query in an Access DB with the Nz function contained within it: System.Data.OleDb.OleDbException : Undefined function 'Nz' in expression. I don't believe this should happen.  How can I fix it. ...
Score Dataset for crystal report
Hemang Shah - 28 Feb 2005 9:49 AM - 14 messages
I have form1 which has the dsDataset  which is instance of dsDataSetClass.xsd I have a button called "report", which opens up another form, which has the Crystal Report Viewer. The datasource of the report is "current connection" dsDataSetClass ...
Score CommandBuilder generates incorrect SQL
enders - 28 Feb 2005 7:00 AM - 6 messages
Hi, I have the following SQL : Select AutoID, TS, Object, ActionType, ID, Property, OldValue, NewValue From Changes. When I use the commandbuilder (both OLEDB and SQL) I get the following result back (for delete) : (SQL) "DELETE FROM  Changes WHERE ( (AutoID = @p1) AND (TS = @p2) AND ((@p3 ...
Score Store Procedure return values to VB.net app
Rudy - 28 Feb 2005 6:45 AM - 5 messages
Hello All! I have a SP that returns a int value as an alias called "returnvalue". I can call the SP fine in my code. conLog = New SqlConnection("Server=localhost;uid=*****;pwd=*****;database=footbet")         cmdLog = New SqlCommand("loginStore", conLog) ...
Score How do I "refresh" my bound control?
Bruce A. Julseth - 28 Feb 2005 4:38 AM - 6 messages
After I've completed an update of my data to my database, how do I "refresh" bound controls.  Right now, I am doing EXACTLY the same as I did when I initially bound them, ie. setting up the DataAdapter, reFILLing the DataSet, ...
Score Transaction please ??
~Maheshkumar.r - 28 Feb 2005 4:29 AM - 4 messages
How can i include Transaction Directives. Will it work like same fashion of manual code. My appln is in lauching stage, i dont want to change the coding structure for manual transaction code inclusion. So i decided to include trasaction ...
Score Many data components - use one transaction?
Marty - 28 Feb 2005 4:11 AM - 5 messages
I need to use three data components to write to three different tables (same database).  But they must participate in the same transaction (all must succeed or rollback).  At the same time, each data component should be able to perform an update without a transaction if desired. ...
Score need simple help with Unicode
Kent Rollins - 28 Feb 2005 12:57 AM - 2 messages
I am trying to insert a Unicode string into SQL Server and then read it back out.  I wrote a simple little test app and somewhere my string is getting converted to ANSI or something similar.  Can anyone sport ...
Score how to construct a Schema
RayAll - 28 Feb 2005 12:21 AM - 9 messages
Hi, I have a table which has 3 forign keys to three other tables.I's to make an schema out of this table which contains all the constrainsts and all its relations and also I'l like to have the records from the look-up tables to ...
Score Problem to restore an SQL database....
Raphaël Désalbres - 27 Feb 2005 6:36 PM - 5 messages
Hello, I'm having the following problem. I have SQL Server Accounting database called 'db_Accounting' , and a form. This database is only accessed by one user at a time. I have made a menu to backup the database. Works fine. ...
Score Why does my Update not update?
Bruce A. Julseth - 27 Feb 2005 6:28 PM - 3 messages
After running the follow code, "intResult" is returned as "0" and the update does not take place. Could it be that my database column name, "Name", is not being related to the Procedure parameter, "@Name?" Is so, what do I need ...
Score Converting to Date format.
Srinivasa Rao - 27 Feb 2005 12:23 PM - 4 messages
I have a string which has a value "2/14/2005". I need to convert this string to "2-14-2005" format. How can i do this conversion? Regards G.V.Srinivasa Rao. ...
Score filling a dataset taking toooo much time
mich_stone - 27 Feb 2005 10:51 AM - 10 messages
Hi world. I have a dataadapter whose select statements does some joins between some tables and a view. Running this select statement in Query Analyzer gives me my result in under 2 seconds (i can digest it even if it takes 4 seconds which is ...
Next » 2 3 4 5 6 7 8 9 10