| Help with SP to Dataset (17 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| The error: "Too many arguments were supplied for procedure LingerieProductCodes" The Code: Dim selectcommand as sqlCommand Dim con as New SQLConnection(conString) Dim myParam as sqlParameter Dim myDs as dataset Dim myDataAdapter as sqldataAdapter con.open() myDataAdapter New SQLdataAdapter("lingerieProductCodes",con) myDataAdapter.selectcommand.commandType CommandType.StoredProcedure myParam myDat... |
|
| muitiple table join (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Ok this might sound easy to some of you but I'm racking my head right now. Ok I have two tables "and no I can't change the design", they have records for example one has a record with a bunch of float type fields that hold $ values ok, the other table that has a one to many relationship with the first table Table1 is One the Table2 is many has a due date a Seq number and a Type field. Now table1 f... |
|
| Object reference not set to an instance of an object. (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Does anyone see why I would receive the error 'Object reference not set to an instance of an object.' in the following code? The error is listed as occurring on the line marked '**'. snip protected System.Web.UI.WebControls.Label MFApps; private void Page Load(object sender, System.EventArgs e) { string SQL "SEL... |
|
| Function Display (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello, Does anyone know if there is a way to determine the last modification date of a stored proc or user defined function? Also, is there a way to pull all the names of stored procedures or functions out of the system tables? Marcus A Johnson |
|
| SQLdataReader locking records (15 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I have the code below for a sub calls a datareader, then calls another sub to run an insert statement while that reader is still open. The insert statement times out, I'm assuming because the reader has the records locked. But I didn't think a datareader was suppose to lock the records. If I run the appenditems function with the datareader closed, it works fine. Anyone know why? Private Sub Button... |
|
| GROUP BY problem (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, the stored procedure below returns me many copies of the same [Part Number] with different Group Areas and Part Areas. Is it possible to remove these duplicates and just display each [Part Number] once. Someone on another list recommended GROUP BY but I cannot get this to work. Jamie CREATE PROCEDURE sp newProductGroupSearch ( @inputbrand nvarchar( 10 ), @inputyear nvarchar( 4 ) ) AS SELECT a.... |
|
| SQL Svr going down. (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi ppl... I have a little problem that I do not understand. I have a web application at http://ladder.elemental3.co.za that is used every night by local online gamers. It works perfectly until it is hit too many times. When there are too many hits to the site the web app can no longer connect to SQL... |
|
| date time format! (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi All, How can I extract only the date part out of the datetime SQL field ? Many thanx. Cheerz! Mazen |
|
| Loading Data into a SQL Server Database (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngstart] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com I have a SQL Server database that will be accepting data from a CD once every three months. Can someone give me the best way approaching this for the SQL Server database to accept data into the relational database?.....I never created aprogram that will accept data from a CD. The data was always inserted into the dat... |
|
| SQL Insert Statement Problem (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I am trying to do a simple insert statement with the following code but get a Object reference not set to an instance of an object." on the MyCommand.Connection.Open() line. The Insert statement works in query analzyer. Any ideas? Thanks in advance. Scott Dim tmp As String Dim nowDate As Date Dim sqldate, sqldate2 As String nowDate Now sqldate Format(nowDate, "u") sqldate2 Convert.ToDateTime(sqlda... |
|
| ExecuteReader: Connection property has not been initialized. (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngfreeforall] to [ngfx sqlclient] by James Avery javery@deluxeeng.com can someone pls help me on this one. below is the err message im getting. what does "ExecuteReader: Connection property has not been initialized" mean? TIA, rOnNeL Server Error in '/PortalVSVB' Application. ExecuteReader: Connection property has not been initialized. Description: An unhandled exception occurred d... |
|
| Invalid object name 'SQL Server Table Name' (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello, I'm just starting to use ASP.NET, and having problem INSERTING rows to a table in SQL server. myConnection New SqlConnection("server MyComputer;database MyDB;Trusted Connection yes") myConnection.Open() myCommand New SqlCommand("INSERT MyTable (@Variables) Values (@Values)", myConnection) myCommand.Parameters.Add(New SqlParameter("@Variables", SqlDBType.Varchar, 300)) myCommand.Parameters("... |
|
| Using NT authentication in connection string (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I'm trying to authenticate to SQL server 2000 using NT Authentication in an asp.net page. Here's my connection string: Dim oConn As SqlConnection New SqlConnection("Data Source localhost;Integrated Security True;nitial Catalog SvrCheckList") I'm getting the following error: Login failed for user 'WDCNTSQLTEST2\ASPNET'. the user should be usoffice\walterm (that is what I'm logged in as). Can some o... |
|
| Can't figure out why max pool size is being reached (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com I'm running into behavior that I can't explain, based on the reading I've done and my understanding of the connection pool. I have a data tier class that has some methods that return a SqlDataReader. (I know this may not be the most desirable, but I am playing around with some different techniques to figure out which ... |
|
| Question on the typing of NULL (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlservergurus] to [ngfx sqlclient] by James Avery javery@deluxeeng.com I'm not sure what is the best group to post this to, but I will start here... When I get a dataset from SQL, the datatype assigned to UniqueIdentifier is System.Guid. Why is it not System.Data.SqlDbType.UniqueIdentifier or System.Data.SqlDbType.Guid? The main issue I have is a VB function that that has a paramet... |
|
| Dropdownlist fill problem (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com Hi I got the following code that I use to fill a dropdown asp control, BUT the result is that I get four rows of data saying; System.Data.DataRowView Why? Private Sub BindListDropDown() Dim oData As DataSet GetData() drpList.DataSource oData drpList.DataBind() End Sub Private Function GetData() As DataSet Dim strSQL A... |
|
| "...all pooled connections were in use..." (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hello. I get this error message in my web forms now and then: "System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." I almost exclusively... |
|
| multiple where clause (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| hi guys, i need help! i need to search for users who has RoleID 2, pJobTitle to whatever the users enters to the textbox and whatever the users choose on the dropdownlist. the below code doesnt do any good, anybody pls help me on this thing. note: i think im having difficulties on quatations, both the (') and (") TIA, Ronnel Santiago Private Sub Button1 Click(ByVal sender As System.Object, ByVal e... |
|
| StoredProc Parameter reurning only first character of string (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Alex Lowe webmaster@asp grandrapids.net Hello List I have a data component which queries a table via a stored proc. The column is of varchar (50) datatype. And the problem is that only the first character of the entire string is retrieved. The data component contains the code to execute the stored proc, of which is a snippet: SqlParameter parameterTitl... |
|
| failed Login for user (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngwebservices] to [ngfx sqlclient] by Bob Levittan blevittan@hotmail.com Hello All, I have just moved my VS .NET solution from Beta2 to final release VS .NET. My solution consists of web services. When I build the solution it is not giving any problem, but when browse the web service through the test web service page it give me following error System.Data.SqlClient.SqlException: Log... |
|
| HELP! Insert problem Part 2 (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Sorry, I forgot to include the error code: Line 64: Line 65: Try Line 66: MyCommand.ExecuteNonQuery() Line 67: Line 68: 'Message.InnerHtml " b Record Added /b br " Source File: c:\inetpub\wwwroot\housing\ra\add request.aspx Line: 66 Stack Trace: [FormatException: Input string was not in a correct format.] System... |
|
| Debugging Store Porcedures using SQL 2000 and MS Visual C#. net Standard Version 2002 (5 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, The documentation of Visual C#. net Standard Version 2002 says that it is not posible to debugg a Store Porcedures (SQL 2000) with the Standard Version. that is only possible with the profesional edition of the product ? Is there some way to enable the debugging of Store Porcedures (SQL 2000) in MS Visual C#. net Standard Version 2002 ? Thanks FDC |
|
| Fwd: HELP! Insert code (9 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| From: Richard Method II rmethod@emory.edu To: aspngfreeforall@aspfriends.com Sent: Mon, 18 Mar 2002 20:36:16 0500 Subject: HELP! Insert code Hello all, I have a simple form that I am using to input data into SQL Server. But, it doesn't work. I've posted the code. Does anyone see anything wrong? Thanks in advance. Richard M. CODE: %@ Page Trace "True" % %@ Import Namespace "System.Data" % %@ Import... |
|
| Create a SQLDataAdapter based on an update Stored Procedure (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hello all, Is there a trick to this? I have a update Stored Procedure and when I try to create a SQLAdapter using the wizzard I cannot. When I select the stored procedure in the update drop down list it displays no parameters and I cannot advance next. This works ok with simple select statements but... |
|
| db updates (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Got a winform client/server app that uses ADO.NET. In the client app I gather data from the controls and build an array list of text SQLCommands as necessary. When a db update button is invoked I peel off each command and do an ExecuteNonQuery to update the db. The problem is that the app works as expected when the db is on the same box as the client app. When running the client app on a different... |
|
