| Execute Scalar (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, What exactly does the excute scalar do? how different is it from the exceute reader of a command object. Regards Srini Do not go where the path may lead, go instead where there is no path and leave a trail. R W Emerson |
|
| SQL Functions and Stored Procs (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello All, I am trying to find a way to query the system tables to return a table that would include the names of all of the user defined functions, created date, and last modified date. Any ideas would be greatly appreciated! Marcus A Johnson |
|
| SV: HasMoreRows (10 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I.e. like this: //////////////////////////////////////////////////////////// %@ import namespace 3D"System.Data" % %@ import namespace 3D"System.Data.SqlClient" % script runat 3D"server" Sub Page Load Dim DBConn As SqlConnection Dim cmdData As SqlCommand Dim dtrData As SqlDataReader DBConn 3D New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) DBConn.Open() cmdData 3D New SqlC... |
|
| Can anyone help with a query? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I have two tables TableA dataElementID int industryID int title nvarchar(50) TableB Id int categoryID int dataElementID int TableB basically holds which dataElements a category has. I need to return all dataElements that Where TableA.industryID @IndustryID And that are not already associated with a category. Something like this but I know this doesn't work SELECT TableA.dataElementCategoryID, Tabl... |
|
| Help Please! - problem with Response.Redirect ( I believe!) (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, I have a stored proc to validate my users when they have to login. I am getting the user name & password from two text boxes and verifying againts the database and if the the user is validated, a cookie is set with the value of the UserId. When i enter the correct user name & password, the user is validated but the response.write statements that I have in the code do not print anything and... |
|
| XML IN A SQL NTEXT FIELD (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com THIS MAY BE A ODD WAY OF DOING THINGS but if i post a load of xml data into a ntext field what is the best way if parsing this (primarily to format it) when i return it as a string Thanks Bryan |
|
| IIS SQL integrated security (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspserver] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com I am trying to make a trusted connection from my ASP page. The IIS server and SQL server are located on different boxes. Since I am using datareaders (ASP.Net) on my pages, I do not want to use COM service. Does anyone know of another solution. I would really appreciate any help on this. Take care, JD Do You Yahoo!? Y... |
|
| Stored Proc Exceptions (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Can anyone help me figure out why I keep getting this exception: "Input string was not in a correct format." SqlCommand command new SqlCommand( "sp InsertProjectFile", connection ); command.CommandType CommandType.StoredProcedure; SqlParameter param; param new SqlParameter( "@fileName", SqlDbType.VarChar,250 ); param.Value inputName; command.Parameters.Add( param ); param new SqlParameter( "@fileT... |
|
| Middle Tier construction with Stored Procedure XML (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hello All, I am working more in the .NET environment and have been re examining how I get data from the database. In this case the data will ultimately feed an ASPX page. My plan is use a stored proc to return an XML result set into a VB class and then feed that up to an ASPX page. I have a database table structure as follows: Table A Table B Table C Table D In this case I have a master row in Tab... |
|
| Database n' ASP.Net (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com What's the best/fastest/safest way to work with SQL7 databases from the web using the dotNet framework? Also, anyone have a generic ADO.net wrapper using VB.net/C# that would be willing to share? Join the world s largest e mail service with MSN Hotmail. http://www.hotmail.com |
|
| Using Stored Procedure with Parameter to SELECT (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, Does anyone know the code I would use to call this stored procedure and load the results into a DataSet with ASP.Net? CREATE PROCEDURE AAP GetArticleCommentsByArticle @Article ID int AS Select * From AlexASP ArticleComments Where Article ID @Article ID Cheers, Alex |
|
| Replicating data (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I have SQL2K installed on WinXp and Win2k on my D & C respectively. I want my databases and data in WinXP imported into Win2k. ANy pointers as to how i can accomplish it. Thanks Regards Srini Do not go where the path may lead, go instead where there is no path and leave a trail. R W Emerson |
|
| VS.NET Generated SQL Not working! (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Greetings I've build a site which makes use of the data concurrency built into VS.NET and ADO.NET, and it seems to work fine in development. That is I used VS.NET to automatically generate the Update and Insert stored procs for me. As mentioned it works fine in dev, however we have now moved the cod... |
|
| Upate and ExecuteNonQuery (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngvs] to [ngfx sqlclient] by devin devinr@drone interactive.com i have a sub called update user which handles my add, edit and delete. update user works for add and delete but not update. if i response.write my sql statement a run it in query analyzer it works. I don't get any errors. anyone have an idea. Private Sub btnEdit Click(ByVal sender As System.Object, ByVal e As System.Eve... |
|
| System.Data.SqlDbType (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by devin devinr@drone interactive.com How do you convert a System.Data.SqlDbType to a System.Type? |
|
| Paging through data (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I have a stored procedure that returns a subset of a list of data. To clarify, suppose i have 100 records that match my query and I will display 4 pages with 25 records each, the subset of data i will return from my stored procedure will be records 1 to 25 and when the procedure is called again 26 to 50, etc. In addition to returning the subset, I also need to return the total number of record... |
|
| Last record ID inserted? (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlhowto] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Moved from [aspngfreeforall] to [aspsqlhowto] by devin devinr@drone interactive.com How can I grab the ID of the last record I have inserted (and know that no one else has inserted a record)? My code is: strInsert 3D "Insert Documents ( title, DateCreated, VenueID, EventDate, Content ) Values ( @title, ... |
|
| sp parameters (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| hi guys. i am looking out to build a small utility that will take stored procedure name as an input and emit code (VB/C#) for creating its parameters . In ADO, i used to use the ADOX object used to get the parameter details of the stored procedure . IN ADO.Net is there any such equivalent thing?? any pointers would be highly appreciated. regards, hemant |
|
| database connection class help (9 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Douglas Reilly doug@accessmicrosystems.net I have a class for making database connections: Imports System.Data Imports System.Data.SqlClient Public Class conn Public Sub New() End Sub Public Function open() As System.Data.SqlClient.SqlConnection Dim conn As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings ("strConnect")) c... |
|
| How to write search condition? (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi,all I am writing a simple Web APP about search.Look at: DataObj data new DataObj("server (local);database en resources;uid sa;pwd "); mySelect Area.DataSource data.GetItemArea(); mySelect Time.DataSource data.GetItemTime Produ(); mySelect Area.DataBind(); mySelect Time.DataBind(); mySelect Area.Items.Insert(0, new ListItem("All")); mySelect Area.SelectedIndex 0; mySelect Time.Items.Insert(0, ne... |
|
| ASP.Net Question (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| RE: [aspngfreeforall] Re: CounterHi people, Does anyone know how I could make the following ASP.Net code behind script/SQL 7 stored procedure work... it is all good except that I want to get the values out of the "Select * From AlexASP Users Where User ID @UserID". The stored procedure checks to see whether a useremail/password combination is valid and returns a paramater @UserID 0 if invalid and ... |
|
| SQL Server Access (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by devin devinr@drone interactive.com Hi, I have this method: public SqlDataReader getArticles() { SqlConnection myConnection new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand new SqlCommand("articleList", myConnection); myCommand.CommandType CommandType.StoredProcedure; myConnection.Open(); SqlDataReader... |
|
| Get Sql Identity with Insert + Select (5 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi, I'm trying to get the identity field by executing a insert with a select statement piggybacked using sql server 2000, asp 3.0 iis 5 The command object is NOT returning a recordset for the select scope identity() ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed. /vpnr... |
|
| ExecuteScalar is not returning value. (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngconfig] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hello, I am trying to check whether user exist or not, But it is not returning any value. Any Idea where I went wrong. Dim MyConnection as SqlConnection dim mycommand as sqlcommand dim count as integer MyConnection new SqlConnection("server balaji;uid sa;pwd h0llywood;database abacbill") dim strsql as s... |
|
| Hierarchical XML from SQL-Server (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi, I need to generate some XML for a custom tree view control on my asp.net webpage. In my database I have an objectTree table with a structure like this: objID (Identity column) parentID (points to objID) objName (varchar(255)) The data in the databse would look somewhat like this: objID parentID objName 1 Null Root 2 1 Information 3 2 Press releases 4 2 Annual Reports 5 2 News Items 6 5 bla bla... |
|
