| 1/1/1900 inserted rather than nothing (14 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I have tried several combinations of this (below) yet the date 1/1/1900 ends up posting to my dbase in a field I put up for birthdates. If Not txtEfBirthdate.Text Is Nothing Then cmdInsert.Parameters.Add("@efBirthDate", txtEfBirthdate.Text) The goal is to not insert any date if nothing is entered in the field. The column is a smalltimedate with allow nulls checked. Any advice on this is appreciate... |
|
| stored procedure not returning value... (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hey folks, Some gremlin has come and transformed my code overnight so that it no longer works. I swear I didn't touch it. :) Very simple: I have a sproc that should return a value. It's no longer returning that value. (the actual error message is 'can't transform from type DBNull to Integer', on the line with ***) Here's the code & sproc... can you see the problem? Dim cmd2 as new SQLCommand("sp P... |
|
| Select Statement Help (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [ngfx io] to [ngfx sqlclient] by Victor Von Doom doctordoom@aspelite.com Hey All, How 2 get a single record from a select statement which will produce 100 of records in output using T SQL. I want a 10th record from that output. Thanking U. Biplab Washington DC's Largest FREE Email service. http://www.DCemail.com A Washington Online Community Member http://www.DCpages.com Promote your gr... |
|
| trigger/sp to run dts (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlhowto] to [ngfx sqlclient] by Tim Tim.Musschoot@rug.ac.be Can I use a stored procedure to run a dts package? If yes, what context will the dts package be called under if the stored procedure is called from the web. My dts package uses a connection which accesses a local odbc connection. It will bomb if the context is not correct. I initially wanted to call the dts package from th... |
|
| Prevent a row from being deleted (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlhowto] to [ngfx sqlclient] by Tim Tim.Musschoot@rug.ac.be I am trying to write a trigger on SQL2K that will examine the values of a row that is attempting to be deleted and raise an error (and halt the delete) if the value of column A "FOO" Being the newbie to triggers I am, I have absolutely no idea how to do this. Heres what I have so far: CREATE TRIGGER GroupMembership Prevent... |
|
| Insert records whose values increment (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Let the good times roll bbilbro@hotmail.com I was wondering if someone can help me with the following code, which is behind a web form. String insertCmd "insert into dbo.ar gl mid lvl code new values (@major payor," " @sub payor, @patclass, @mid lvl code)"; // Initialize the SqlCommand with the new SQL string // and the connection information. SqlComma... |
|
| SqlCommandBuilder question (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Sheik Yerbouti peter@aspdll.com Hi all, I recently copied a snippet of code from a .Net web site which helped me convert a XML file to SQL. The code does work as planned. I notice this code uses a feature which I have not used before, specifically the SqlCommandBuilder. I have listed the code below. This code does the INSERT into my SQL database. My qu... |
|
| SV: RE: sp return value (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Is it totally unecessary to declare the stored proc? Cmd.CommandType 3D CommandType.StoredProcedure And is it also unecessary to declare that you want a return value? Dim pVal As SqlParameter 3D cmd.Parameters.Add("Returnvalue", SqlDbType.Int) pVal.Direction 3D ParameterDirection.ReturnValue Cmd.ExecuteScalar() int 3D cmd.Parameters("ReturnValue").Value Am I barking up the wrong tree in assuming t... |
|
| sp return value (11 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| hi all.. could some one tell me how do i access the stored procedure return value in ado.net thanx, hemant Original Message From: "David L. Penton" david@davidpenton.com To: "ngfx sqlclient" ngfx sqlclient@aspfriends.com Sent: Thursday, July 25, 2002 9:26 AM Subject: [ngfx sqlclient] RE: Dynamic WHERE Clause Couple of things to think about: 1) A varchar can only be 8000 characters. So, if @Thing1 ... |
|
| SV: Re: SQLDataReader: Is there a way to return a null string is a null is returned? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Bill, that is not correct, the SqlDataReader indeed has an .item pty. I am using both that and IsDBNull in this context with great success: If IsDBNull(myReader.Item("strFalt0" & i.ToString)) Then ....etc Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@so... |
|
| Reuse a connection? (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Tim Musschoot Tim.musschoot@rug.ac.be I have two drop down lists, both of which reflect the returns of the same stored procedure. How do I set the droip downs to use the same data? My code %@ Page Language 3D"VB" Debug 3D"true" % %@ import Namespace 3D"System.Data" % %@ import Namespace 3D"System.Data.SqlClient" % %@ outputcache duration 3D"12000... |
|
| instanciate a sqlconnection array (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Moved from [aspngfreeforall] to [aspngdata] by Tim Musschoot Tim.musschoot@rug.ac.be Hey, I have got a data access class where I need to have some connections available. Is there a better way to instantiate this array than looping trough each element in my array (vb or c#)? Code Dim mConnectionString As String Private... |
|
| SQLDataAdapter parameter not supplied during insert? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngstart] to [ngfx sqlclient] by Tony Stark IronMan@aspelite.com I'm trying to insert data from a form into SQL Server database. I dragged the fields from the database onto the form to create a SQLDataAdapter, which creates an automatic insert command. My submit button calls: SqlConnection1.Open() SqlDataAdapter1.InsertCommand.ExecuteNonQuery() SqlConnection1.Close() When I submit, I... |
|
| SV: Cannot Read Reader (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Where do you open (and close) the connection to your database? Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web.: www.sonnenburg.se B2B Web Solutions Specializing in .Net Ursprungligt meddelande Fr E5n: Neil Moodley [mailto:Neil.Moodley@u... |
|
| Incorrect syntax near ')'. I cannot find a missing ')' what could cause this (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Below is my code and Stored procedure Line 1: Incorrect syntax near ')'. 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: Line 1: Incorrect syntax near ')'. Source Error: Line 382: Line 383: myCom... |
|
| trusted SQL Server connection (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello list, I'm a novice with SQL Server admin. Can anyone tell me what might be causing the error message below and how to fix it? Login failed for user 'sanet'. Reason: Not associated with a trusted SQL Server connection Wes Be sure to visit us on the web at www.dwloukota.com Do You Yahoo!? Yahoo! Health Feel better, live better |
|
| Dynamic WHERE Clause (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello All, I am trying to develop a stored procedure that has a dynamic WHERE clause. Here is what I have currently, but it isn't working. The @Thing1 variable is a WHERE String that I develop on the fly on the website. The error I am getting is that the is a problem near the 'as' by @Thing1 CREATE PROCEDURE sp GetAsianMatches @Thing1 as VarChar(2000) AS Declare @Stuff2 VarChar(2000) Set @Stuff2 3... |
|
| SQLDataReader: Is there a way to return a null string is a null is returned? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Is there a way to return a null string is a null is returned or the actual value (other than null) when a value is present? myReader[3].ToString(); //returns a empty string when the field returned is null myReader.IsDBNull(3) // returns true when the field returned is a null while (myReader.Read()) { Label1.Text myReader.GetString(0); // throws an exception when a null value is encountered } |
|
| What do I need to select based on date only How do i convert the datetime to date.. (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| what do I need to select base on date only How do i convert the datetime to date.. string SQL "Select ID, Problem, Create Date,Version,Poll from dwKnowledgeBase where Lang '" Lang "' and Create Date ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND Create date (Convert(datetime,convert(varchar,getdate(), 1)) 1) order by category"; For 2002 ASP.NET Solutions & Articles goto: http://aspallianc... |
|
| How can I return the number of rows that where added during each day for the last 7 days (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| How can I return the number of rows that where added during each day for the last 7 days and rename the date to a day name SQLStatement.Text "Select Count(*) Create Date from dwDNS where Create Date ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND Create date (Convert(datetime,convert(varchar,getdate(), 1)) 7) order by Create Date"; For 2002 ASP.NET Solutions & Articles goto: http://aspalli... |
|
| ADO Command (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Tim Musschoot Tim.musschoot@rug.ac.be Hi all, Here is a sample, to summarize my problem: SQL Procedure CREATE PROCEDURE dbo.myProc ( @user id varchar (20) null, @start date datetime null, @cc1b text null ) as return 0 cm.CommandText "myProc" cm.CommandType adCmdStoredProc; cm.Parameters.Append(cm.CreateParameter("returnValue", adInteger, adParamR... |
|
| Date Q? (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Does anyone know of a query trick to get the difference between two dates from two different records from the same field. The date field is sorted ascending, and the date that is needed to find the difference always follows as the next record. There is no other criteria to match up the two records and same field. Thanks! Patrick |
|
| SV: sql server connection (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I thought a SQL server connection string should look like this: Dim objConn As New SqlConnection("Server 3Dsqlserver.quotamais.com.br;UID 3Dquotamais;PWD 3D webQ2 602";Database 3Dquotamais) Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web... |
|
| SV: RE: SV: sql server connection (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| That's no problem. You may well connect to a SQL Server remotely like this. Regards/Halsningar Andre Colbiornsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 78 80 Mob.: 46 (0)708 97 78 79 Mail: colbiornsen@sonnenburg.se Web.: www.sonnenburg.se B2B Web Solutions Specializing in .Net Ursprungligt meddelande Fr E5n: Graham Dobson [mailto:... |
|
| Trouble importing file (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I have copied a shortened version of the text file I am trying to import into my SQL Server database. I can't figure this file format out, can anybody help me here?, I have no documentation on this file. 2002/05/15 02:29:30 20020514 BD800390000006B 00 FINSTRUCT SECURITIES (PTY) LTD D 00000000 00000000 BD850390000006 BD860390000006 BD770390000006 00000000 0000000 0000000000000000OTH00019990929 BD78... |
|
| DataReader questions (21 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com 1. What method to use when want to specify a fieldname instead of an ordinal? 2. What are e.g. GetSqlInt32, GetSqlChar methods for? Should I use the types fro efficiency's sake when using SQL Server? * code snippets appreciated |
|
| Tracking back SqlClient accesses (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi! I'm using the SqlClient to read/modify/... data on my sql server. Intermittently some records are changed even though I wouldn't expect them to. If I were able to find out when and which modifications were sent to the sql server from my page, it could give some indications where to look for the bug. I tried to open/read the transaction protocol (LDF file) but to no avail. Any hints? (I hope th... |
|
| ASPNET cannot connect to SQL server accross the network (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Here is the situation: Machine A has SQL Server 2000 and ASP.NET Framework. Everything works like a charm. Machine B is connected to machine A via workgroup and has ASP.NET Framework. ASP.NET web applications on machine B cannot connect to SQL Server on machine A. When tracing the SQL on the server, I can see th... |
|
| Debugging Stored Procs... (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| V2hhdCBpcyBuZWNlc3NhcnkgdG8gZGVidWcgU1BzIHdyaXR0ZW4gaW4gU1FMIFNlcnZlcj8gIEkg a2VlcCBnZXR0aW5nIGENCm1lc3NhZ2UgdGhhdCBzYXlzIHRvIGVuc3VyZSB0aGF0IFNRTERCUkVH MiBhbmQgU1FMREJHLmRsbCBhcmUNCnJlZ2lzdGVyZWQuICBEbyB0aGV5IGhhdmUgdG8gYmUgaW5z dGFsbGVkIG9uIHRoZSByZW1vdGUgbWFjaGluZSAoU1FMDQpTZXJ2ZXIpIG9yIG9uIHRoZSBjbGll bnQgbWFjaGluZT8gICBXaGVyZSBjYW4gSSBmaW5kIHRob3NlIHRvb2xzIG9uIHRoZQ0KRFZEPw0K |
|
| CURSOR CLOSE ON COMMIT Problem (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I'm working on some code that fails to fetch from a cursor when it commits a transaction after the cursor is opened, but before the fetch. I've tried to make this work with "SET CURSOR CLOSE ON COMMIT OFF" for the connection, but it doesn't seem to do the trick. I can only make it work by moving the commit to follow all of the fetches. While each query is easy to fix, there are a lot of them and t... |
|
| ASP.Net & SQLServer (9 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngibuyspy] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com I have had my ASP.Net app and SQLServer working on the same machine with Windows Authentication No Problem. I am now working on moving the SQLServer to a separate machine. In my asp.net web.config file I have had the connection string spec as follows: add key "ConnectionString" value "server (local);Trusted Connect... |
|
| why would this function return a blank page when the same code worked when in a page load method. (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| why would this routine return a blank page when the same code worked when in a page load method. now that it is in a function it runs but does not show any datalist items on the page?? Is it because I am using a collection and need to import a namespace? %@ Import Namespace "System" % %@ Import Namespace "System.Data" % %@ Import Namespace "System.Data.SqlClient" % %@ Import Namespace "System.Web"... |
|
| MSDE dD: DOT.NET connection works but not ASP connection string! (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngsec] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com I'm running MSDE, Server is "(local)" machine name assume "machinename" and I'm connecting to IBuyStore Portal Database. This connection works in .NET work SqlConnection("server localhost;Trusted Connection true;database Portal" ) This same string doesn't work in ASP3.0 'cn.Open "server localhost;Trusted Connection tr... |
|
| Formatting data in DataColumn (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Tony Stark IronMan@aspelite.com Hi there I hope I'm posting this in the right place! What I'm trying to do is this: I'm importing SQL into various tables in a DataSet from a SQL2K Database, creating nested relations, and then ouputting XML via a XmlDataDocument. The problem is that all my date values (which are correctly formatted in the SQL DB) are en... |
|
| Any Articles on Record Locking ? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Does anyone have tips for implementing record locking for SQL server and OLEDB. Many feel that record locking will slow down things and easier to have a field indicating active user and active time (used for timeout) |
|
| id of last inserted record (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| working on a page where i have to update more then one table, in more then one database, one of which is going to be an access database most likely. When i sent a record into the sql2000 database, i need to get the id of the last inserted record so i can insert it into a lookup table in access. can anyone point out how i can get the last insert record id? Ian |
|
| Cascading Deletes (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I'm trying to set up constraints no SQL 2000 that will cascade deletes. Everything's fine except for the tables that are used to link two tables. For example, I've got a Customers and Accounts table. I've got a Custodians table that is just a many to many relationship linking the Customers and Accounts. It looks like: AccountId (PK, FK1) relates to the primary key of the Accounts table CustomerId ... |
|
| sql parameters (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| can i pass two parameters in a command text like this? SqlDataAdapter1.SelectCommand.Parameters("@x1111").Value Textbox1.Text SqlDataAdapter1.SelectCommand.Parameters("@x2222").Value "%" & Textbox2.Text & "%" SELECT * FROM table WHERE (@x1111 LIKE @x2222) thanks!!! |
|
| query and datetime question (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Tony Stark IronMan@aspelite.com I am having problems with a query that works in query analyzer... but not consistently in the code. select * from events where edate '6/23/2002' and Eclubid 3D 512 This query shows events for the end of this month and next, but this code: Dim MyCommand2 As SqlCommand 3D New SqlCommand("select ID,edate,Ename,eband,eclub f... |
|
| Executing Query that returns a parameter (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| OK, I'm being a bit thick here. I usually do Inserts and Updates to a database just by executing a query, however I now want to be able to get an Insert query to return the id value for the record that is created. Tim Musschoot over on the SqlHowTo list has suggested using the following: INSERT INTO TABLE (FIELD) VALUES (VALUE) SELECT @@IDENTITY AS IDCOL This seems logical, but how would I achieve... |
|
| Command Object/SQL Server Error in ASP page (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Gang....I am not yet up to speed with .NET. Will soon be in the middle of next month. But my problem is Inserting some data by calling a stored procedure from within SQL SERVER 7 using the Command Object within an .ASP page. Below is the CODE and the ERROR: Microsoft OLE DB Provider for SQL Server (0x80040E21) Invalid character value for cast specification. ERROR MESSAGE /Universal Arts/Marriot/Ne... |
|
| Converting comma-delimted files (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, Does anyone have a good example on how to convert a comma delimited file to a SQL 2000 table using ASP.net / VB.net? Thanks, Bob |
|
| Need help with SQL Server and the ASPNET user (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I'm having some problems with users/connection strings for a SQL Server database. Right now, I use SQL Enterprise Manager and add the ASPNET user with dbo permission and use a trusted connection and I'm able to access the database. The connection string looks like the following: add key "ConnectionString" value "server localhost;Trusted Connection true;database TASCBenef" / But the ASPNET user... |
|
| FillDataSet command (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Guys, I have this old code that used to work on B2/B1. But now keep getting stuck at FillDataSet (code below at the last second line). Can you please tell me where to find the doc for converting old commands to the new? Thanks much! %@ Page Language "C#" Debug "true" % %@ Import Namespace "System.Data" % %@ Impo... |
|
| retrive a single record and bind it to a text box (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com How do I retrive a single record and bind it to a text box. Whenever I am trying to use SqlDataReader, it gives me an error that "Invalid attempt to read when no data is present" The code that I am using is Dim dr As SqlDataReader med.GetFewMedium(theID) Dim snCount 0 'Do db call Do While dr.Read() snCount snCount 1 L... |
|
| Help with Data accress (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by devin devinr@drone interactive.com Hi I am trying to write to a database. Luck of knowledge is letting me down. I have three tables T PERSON, T SKILLS and T PERSON SKILLS. I have a page with a two textboxes for person name and person ID and a listbox containing skills user to select from. so far my code looks like this Private Sub cmdSubmit Click(ByVal... |
|
| Catching error in sql server from c# (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| hi is it possible to catch error from sql server in c# ? and have access to the error msg? james |
|
| dataset (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Tim Musschoot Tim.Musschoot@rug.ac.be Hi, I am populating a dataset that contains two tables and I use two dataadapters and two stored procedures to populate each of the tables. the stored procedures are these: CREATE PROCEDURE dbo.getRMAs AS SET NOCOUNT ON; SELECT* FROM RMA GO and CREATE PROCEDURE dbo.getRMADetails AS SET NOCOUNT ON; SELECT* FRO... |
|
| sql update command (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspdebug] to [ngfx sqlclient] by Cain Marco juggernaut@aspelite.com Private Sub DataGrid UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid.UpdateCommand Dim UpdateCmd As String ("Update test Set testone @test1, testtwo @test2 Where testone @test0") Dim MyCommand As SqlCommand New SqlCommand(UpdateCmd, MyConnection) MyC... |
|
| SV: Reusable method in C# to return the results of a Stored Procedure query - Help needed. (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| A DataView may well be used. Here is an example in VB.Net but I'm sure u get the drift: 1.' Publicly dim a DataSet and a Dataview Public dstClients As DataSet Public dvwClients As DataView 2. 'The Function Public Function BindMasterGrid() As DataView Dim conFamily As SqlConnection New SqlConnection(strConn) Dim dadClients As SqlDataAdapter dstClients New DataSet() Try dadClients New SqlDataAdapter... |
|
