| Null (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com I am getting the following code. Would like to figure out how to compare against SQLDB Null values. 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 D... |
|
| Stored Procedures with SqlDataAdapter (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdatagridrepeaterdatalist] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com I'm ashamed to say that the answer given to me before regarding this is lost (Sorry Alex). I have tried to nestle my way through the .NET Framework Class Library to find the right syntax. So please help me out, I will not lose it this time. HOW do I call a stored procedure when using the ... |
|
| Creating Database Tables. (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 005D 01C19DD1.D0E7EA70 Content Type: text/plain; charset "US ASCII" Content Transfer Encoding: 7bit Does anyone know how to create and alter tables in SQL Server with .net? I have been programming .net for a year and have not had to actually create da... |
|
| How can you write to the trace from an object. (11 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com Hi, I actually have two questions. In an object I have some data base access code where I am trapping for any errors. I would like to write the error message to trace but trace.write does not work? In addition I like to be able to send an error message up to the calling aspx page, do I have to 'throw' ... |
|
| A bit off the beaten track (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 004D 01C19F44.7FB81ED0 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable Pls excuse me for sending this to the ASPNG list but I am not sure where else to seek help. Seeing as most of us .NET junkies are u... |
|
| To ALEX LOWE - was ( RE: SQL isn't localhost anymore) (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com Alex, I finally got back to the office today. I have been "remotin'" for the past 22 days. I have installed client tools only on the web server (Tess). I work on Joe, a Windows 2000 Pro box that has neither SQL or ISS installed. Our SQL Server is Mariah. If I follow your plan below, I install client t... |
|
| ASP.NET beta2 (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com My code very well on .NET frame work beta 1, when i upgrade beta2, i was recived errors ! Dim objConn AS SqlConnection m Server 3D ConfigurationSettings.AppSettings("Server") m InitCatalog 3D ConfigurationSettings.AppSettings("InitCatalog") objConn 3D New SqlConnection("Server 3D" & m Server & ";Trust... |
|
| Best way (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com This is a multi part message in MIME format. NextPart 000 0112 01C1A456.7EEF01A0 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable Hi ppl.. What is the best way when using SqlCommand (C#) to see what is being sent to the server. I need to see if the Input par... |
|
| Getting OUTPUT params from a stored procedure in C# (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com This is a multi part message in MIME format. NextPart 000 00DC 01C1A44E.74263570 Content Type: text/plain; charset "iso 8859 1" Content Transfer Encoding: quoted printable Hi ppl.. I have just finished contructing a stored procedure on SQL Svr 7 and this is how I use it in Query Analyzer DECLARE @St... |
|
| C# and SProc help (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Alex I used the profiler as suggested and see the SProc is receiving the LadderID being passed and going through the normal cycle as it would if records were found based on the LadderID. Please would you look at my code and see if you understand why ExecNonQuery is getting 0 returned even though the... |
|
| asp.net, ado.net & c# question (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com hello, i'm very new to .net, so please bear with me. i'm getting the following error message: "Compiler Error Message: CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)" the code is below (i indicated the line where the erro... |
|
| another asp.net, ado.net & c# question (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| hello, i'm very new to .net, so please bear with me. i'm getting the following error message: "CS0117: 'System.Data.SqlClient.SqlDataAdapter' does not contain a definition for 'ExecuteReader'" the code is below (i indicated the line where the error occurs): %@ Page Debug "true" % %@ Import Namespace "System" % %@ Import Namespace "System.Data" % %@ Import Namespace "System.Data.SqlClient" % html h... |
|
| OT: decimal scale (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. NextPart 001 01C1A5B5.685B44C0 Content Type: text/plain; charset "iso 8859 1" Is it possible to change the default scale of the Decimal type in SQL Server 2K? It keeps de... |
|
| SQL Svr and datetime (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi ppl.. Can someone please tell me the easiest way to retrieve all records that fall on a specific day. IE: I have a date value of 26 Jan 2002 16:00. I want all records for the date range 26 Jan 2002 00:00 to 26 Jan 2002 23:59. Is the a way to do this with LIKE? TIA Mike |
|
| parameters in stored procs (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com is it possible to create a stored procedure with input parameters that are optional? I want to write an update procedure and have it only update the values of the parameters I feel like passing to it at the time. For example a stored proc: CREATE Procedure UpdateMyTable ( @id NUMERIC(18,0), @param1 ... |
|
| Stored Proc Prob in VB.NET (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com I have a simple stored proc that I am call to retrieve the first record that meets my flag criteria. The problem I am having the amount of SQL memoery it is using. If I run the query from the Query analyzer it returns in a split second and no new memory is really used. 20 When I call the proc from a... |
|
| retrieve Identity from SQL when Insertion (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles D. Carroll darthcarroll@asplists.com This is a multi part message in MIME format. NextPart 000 0056 01C1A6B8.F7E7EE50 Content Type: text/plain; charset "big5" Content Transfer Encoding: quoted printable I have a table with an Identity column(auto increment no.). While I want to select/retrieve this no. to the program WHEN I being 'INSERT'... |
|
| Sproc tuning (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Any ideas on how I could tune the performance of this sproc? It is working exactly as I want, just wondering if it can be sped up a bit. Thanks, Ryan CREATE Procedure GetRecordsSubset RunTime ( @ID int , @Count int , @Min int , @Max int ) As Declare @Mod int Declare @Step int Create Table #Temp ( id Int Identity(1, 1) Not Null , RunCount BigInt Not Null , RunTime Decimal(14,4) Not Null ) Insert In... |
|
| ASP.NET Identity Column Error (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hello List, below is a method from my Abstraction Layer i.e. DAL: **************************************************************************** ************* public DataSet GetEmploymentPageRecords(int pageSize, int pageNumber) { //Create all the data objects DataSet ds new DataSet(); SqlConnection conn ne... |
|
| Returning a value from a stored procedure (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll darthcarroll@asplists.com Hi all, I'm trying to create a stored procedure to validate a user held in a database. I just need it to return a 0 if the user and password doesn't match, or a 1 if it does. I know I have to use output parameters in the stored procedures but I don't get it. If someone could send me the code for returning a ... |
|
| Running SQL server as a database (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I live in South Africa and have asked people to explain the way SQL server 2000 licensing works, but have had no satisfactory answers. I am developing an ASP.NET intranet. It will run off SQL Server 2000. Now if the company has one web server running, and 50 users using my ASP.NET intranet application via their web browser, do they need one SQL Server license or do they need 50 SQL Server lice... |
|
