| ASPNET User Hath No Privileges... (12 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngwebservices] to [ngfx sqlclient] by Michiel van Otegem mvo@mail.aspnl.com I just got here, and checked the archives for the list, but couldn't find anything matching my problem. I'm sure it has occurred to someone before, however! I am learning webservices, and using VS7 have built one that accesses a Sql Server database. Just doing a select on it, but I get the following... Syste... |
|
| populating asp:dropdownlist with datareader from sql stored procedure (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Douglas Reilly doug@accessmicrosystems.net Hi, I hope someone can help me here: I am learning ASP.NET and finally wrote some code that looked promising, but the code did not populate the dropdown list on my Web page. I am trying to drop data from a stored procedure into a datareader and then populate a dropdownlist web control with that data. Her... |
|
| datareader/stored procedure error (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by devin devinr@drone interactive.com Hi, I am trying to build the following web page. Two drop down lists: ListPayerProd is populated by a datareader from a stored procedure on pageload (this works by itself); the second dropdownlist ListProviders is then populated when an item is selected from the first dropdownlist, by a datareader from a stored ... |
|
| TreeView ,Connection string problem. (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I have created a tree view control on my local machine accessing local Sql Server Database working fine But when I change my connection for connecting with database on other machine it display this error. SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information ab... |
|
| Incorrect Data Type in a DataGrid (9 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I'm creating an updatable datagrid and I'm having trouble updating new values entered into the grid. Specifically, when I specify the data type for a date field when I add a new date, I get the error message "Incorrect syntax near the keyword 'WHERE'" I'm my SQL dbase, the data type is "smalldatetime." In my code I've tried using SqlDbType.DateTime, SqlDbType.SmallDateTime, and SqlDbType.NVarChar,... |
|
| DataReader (5 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by devin devinr@drone interactive.com Hi folks. The following DataReader code keeps giving me an error. I'm posting both the code and error messages. Any ideas? Thanks in advance. Richard M. CODE: Dim sqlText as String "SELECT id, dateentered, Description, email date closed FROM support requests WHERE id '" & Request.QueryString ("id") & "' " Dim db... |
|
| NOTANSWERED: Typecasting problem (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, I am using a component to add a user to the DB. When i fill the fields and press enter, I set a Cookie and redirect the user to the default page. But What is happening is that the values entered by the User are added to the db, but instead of redirecting the user to the default page, I get the following error. Exception Details: System.InvalidCastException: Cast from type 'DBNull' to type ... |
|
| multiple sqldatareaders (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Douglas Reilly doug@accessmicrosystems.net Hi, Does anyone have any examples of populating multiple dropdownlists from multiple datareaders on page load? I am using datareaders because the data is only available to the user for selection purposes; I understand that you can import from multiple tables into a dataset but I don't believe the same is... |
|
| Null values (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Finally getting into the swing of this .net stuff. First question. I'm trying to retrieve data from a SQL stored procedure into a datareader and then placing it into a form to be edited. I know the connection is working because it's trying to put a null value into one of the form textboxes. Obviousl... |
|
| Connection problem (5 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi Can anyone help me as I can't connect to the SQL server from my Web Server using ASP .Net. Facts: 1. I can't ping the SQL server from the web server (Request timed out), but I can see the SQL server and access its shared folders in the network neighbourhood 2. Attempts to use SQLConnection to connect to the SQL server always result in the error 'The specified SQL server is not found' (using bot... |
|
| Connection not closing w/ Windows Service, any ideas? (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I'm having a weird variation on the sqldatareader/connection closing thing. I understand the whole explicitly closing the data reader when finished to make sure the connection gets closed. I have a simple Windows service where I pull back some queued rows in a SqlDataReader for processing. (This process runs on a thread that processes various data queues and then sleeps for 2 minutes). Althoug... |
|
| DropDownList (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| How can I bind a Drop Down List to a SqlDataReader???? The reader is pulling just one row of information. |
|
| Problem in getting Data using WebService (9 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi Folks, I have problem in getting data by using Webservice Here is the code: *************************************************************************************************************** Private Const CONNSTR As String "SERVER ABC;TRUSTED CONNECTION Yes;DATABASE TESTING" WebMethod() Public Function GetProblems(ByVal sProdID As String) As DataSet Dim sSQL As String Dim bSelectedWorked As Boolea... |
|
| Time-Out Error (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdatagridrepeaterdatalist] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Moved from [aspsqlhowto] to [aspngdatagridrepeaterdatalist] by Dana Coffey denigma@bellsouth.net Hi all, I have a program that I am running that gets a sqldatareader and loops through it The recordset is approximately 100 records. For each record a process takes place that lasts anywhere from 1 to ... |
|
| Deploying .Net (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngstart] to [ngfx sqlclient] by Douglas Reilly doug@accessmicrosystems.net Moved from [aspngwebcontrols] to [aspngstart] by Devin devinr@drone interactive.com I am trying to deploy a .Net application on an IIS server and am having a problem. The web application installs correctly and the main login page is presented. The problem occurs when the login is submitted and the IIS server ... |
|
| Adding a New Record (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by devin devinr@drone interactive.com I simply want to add a new record to my sql dbase using a web form. I'm getting the error message "Index (zero based) must be greater than or equal to zero and less than the size of the argument list." I think it's related to the ID column in my database which is the identity key and seeded automatically. How do... |
|
| SV: <asp:dropdownlist> problem (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Do like this: Server id.DataSource 3DServerList Server id.DataValueField 3D "Server id" Server id.DataTextField 3D "Server name" Server id.Databind() Hth Regards/H E4lsningar Andr E9 Colbi F6rnsen 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D 3D Sonnenburg Communications Bergsgatan 3, SE 211 54 Malm F6 Sweden Tel.: 46 (0)40 97 78 80 Fax.: 46 (0)40 97 ... |
|
| .NET / SQL Server & XP Professional (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlserver] to [ngfx sqlclient] by Clint Barton hawkeye@aspelite.com Moved from [aspngfreeforall] to [aspsqlserver] by devin devinr@drone interactive.com We have a Universal MSDN Subscription @ work. So I have access a lot of development software. My question is: can I load SQL Server on a XP Pro box? Given the XP Pro box has enough memory, etc.. etc.. What version (SQL Server) can I... |
|
| sql connection in web.config (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I am new to ASP.NET and moving my SQL database connection string to the web.config file: configuration appSettings add key "ConnectionString" value "server xxx;uid xxx;pwd xxx;database xxx" / /appSettings /configuration In my .aspx file this is how I call the connection: Dim dbconn As SqlConnection dbconn ConfigurationSettings.AppSettings("ConnectionString") And this is my resulting error: A v... |
|
| <asp:dropdownlist> problem (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Douglas Reilly doug@accessmicrosystems.net I'm trying to fill in a drop down list from a SQL db. As you will see from the source code I can get one field in there, but that's only a number at this point. I'd like to be able to list both a number and a title in the dropdownlist from the db table. Is there a way to actually do this? The other trick... |
|
| Problem in Inseting Data into Database using Webservice (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi All, I have written a Webmethod to insert data into the table . Connection is established. Here is the code. WebMethod() Public Function SubmitProblem(ByVal iUserID As Int64, ByVal sDesc As String, ByVal sSteps As String, ByVal iSeverityID As Int32, ByVal sVersion As String, ByVal iProductID As Int64) As Boolean If sDesc "" Or sSteps "" Or iUserID 1 Or iProductID 1 Then Return False End If sDes... |
|
| Best ways to deploy MSDE and ASP.NET Web pages (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi I have a intranet site which i want to deploy with MSDE i would like to make a setup app taht creates the web application/virtual directory installs MSDE runs the script to make sps and tables and finally copy the bin folder and aspx pages to the virtual directory. IS there any program that allows you to do this? or is this really really complex not worth trying? James |
|
| Comparing Dates in a SQL Table (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Chaz charlesmarkcarroll@yahoo.com If anyone has an answer to this questions I would appreciate it I have a MSSQL table that has a list of orders which have an associated date with each order in the format of 5/1/2002 2:01:01 PM. I am pulling the order information and displaying it in a data grid. What I would like to do is put a drop down list ab... |
|
| Getrows (asp) alternative for asp.net (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello, I have a SQL Server 2000 table and I'm using the System.Data.SqlClient classes to retrieve data from it. I want to retrieve all ID's from a specific table that meets a number of requirements. These should be stored in an Array object. Is there a way to store them in an array without stepping through all the records ? In ASP, the GetRows method does this kind of work, but is there an alterna... |
|
| Anyone know of a good SqlClient Data Class? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngdata] to [ngfx sqlclient] by Dana Coffey denigma@bellsouth.net Hello all! I am in need of a good data class. I am still learning ADO.NET and would like to separate my data layer from my business layer in most cases. Does anyone have or know of a sample data class that I can learn from and build upon? It could be provider agnostic or just SqlClient. Thanks in advance, Beren, MCP b... |
|
