| Dynamic Arrays (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Copied from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi all.. Can someone help me with a solution to the following. I would assume a dynamic array would suffice, but .NET has bought us so many new ways of doing things perhaps one of you could suggest a better alternative :) I have a SqlDataReader var reader that has a list of records with 2 fields (U... |
|
| how to extend timeout period for SQL query? (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| i'm using a SqlDataReader & SqlCommand, but i'm not sure how to configure the connection so it won't timeout so quickly. i think it's timing out after 90 sec or so. this is the SqlClient timing out not the ASP.NET page i've already extended the httpRuntime attribute so the page doesn't time out quickly. i'm running some perf tests pulling down a large # of records this isn't a normal issue with my... |
|
| Dataset not populating from stored procuedure (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com I am having some issues with a dataset not populating from a stored procudure. What happens is that I have created a class that takes the reference to a dataset, and other parameters, does the fill, then ends. Below I have the code and would appreciate any comments on why this isn't working. Oh, the store... |
|
| SQLDMO (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Alex Lowe webmaster@asp grandrapids.net I've used SQLDMO in the past to manage some things in sql through code. I'm trying to use the SQLDMO objects is .NET, but I'm having trouble. It complies ok, but Here is my code that it blows up on when I run it. SQLDMO.SQLServer mySqlServer new SQLDMO.SQLServer(); int myCount mySqlServer.Databases.Count; I get t... |
|
| Download image file (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Alex Lowe webmaster@asp grandrapids.net Hi i have an image file store in the SQL server as binary data if i want to retrieve this image file from the SQL server and to be dowloaded from the web. how can this be done in VB.NET? Thanks! |
|
| SQL 2000 Standard edition install in Windows XP ? (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngstart] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Can I install a SQL 2000 Standard edition in Windows XP Profession? Since Sql 2000 DB Server Standard/Enterprise can be installed in Win2K Server or above only. While it can't be installed in Win2K Pro. And I have to install a SQL 2000 Personal Edition in Win2K Pro only. Is there have similar requirement in Windows X... |
|
| SV: How to test a SqlDataAdapter object (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| This could be a way to do it: Dim sqlAdapter As New SqlDataAdapter(strQuery, strConnection) Dim type As New DataSet() sqlAdapter.Fill(type, "YourTable" ) Dim RowCount As Integer 3D type.Tables("YourTable").Rows.Count If RowCount 3D 0 Then responsE.redirect("toto.aspx") mContext 3D HttpContext.Current mContext.Response.Redirect("toto.aspx") End If Regards/H E4lsningar Andr E9 Colbi F6rnsen 3D 3D 3D... |
|
| Executing a stored procedure from ASP.NET (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hey Gang, I'm trapped at home without any books and I've got a problem that's killing me, I wonder if anyone can help me? I need to execute this stored procedure from ASP.NET: CREATE PROCEDURE [dbo].[creatependingcontent] 20 (@userID int, @subject varchar(255), @url varchar(300), @description text) AS INSERT INTO tbl pendingcontent (pendingcontent usersID,pendingcontent subject,pendingcontent url,... |
|
| Easy way to do a tough task? (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com The prototype that I have been developing will become a published application on Monday. Is there a way to import a comma delimited text list into the database. 17 school districts will each have over 300 records that I have to put into the SQL database. I can get them to export their temporary databases to a CS... |
|
| stored procedure (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com greetings trying to execute a stored procedure which inserts a record into a table and returns the primary key of the record as an ouput parameter. But when trying to excute the sp, an exception is thrown saying 'Object must implement IConvertible.' Can't figure out what is the cause of this exception. I ... |
|
| orphan sessions unanswered (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, I have a VB class that gets a data reader among other functions. When I call this function, it leaves an orphaned session on SQL Server. I will appreciate any help. My code looks like this VB Class Public Class DataManager . . . Public Function Get DataReader(ByVal The Qry As String) As SqlDataReader G Xion New SqlConnection(ConfigurationSettings.AppSettings("XionStr")) G Kmd New SqlComman... |
|
| SQL Connection (7 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, I am just beginning with ASP.Net and databases. I am using Sams TYASP.Net in 21 Days. I was trying to use SQL 7 instead of Access. and i tried the following code for connection which i found in the docs and quickstart. ' set up the connection dim objConn as new SQLConnection("data source srini;database banking;Trusted Connection yes") 'Open Connection dim objCmd as new SQLDataAdapter("sele... |
|
| Saving Html Content to Sql table (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Charles M. Carroll charlesmarkcarroll@yahoo.com GlacierHi im trying to save whole html contents of web page urls listed without HTML tags and punctuations to a sql server table... I ve been trying to insert whole html content by replacing \n and ' with empty char but for some reasons when i do an insert, only first n number of char are inserted..... |
|
| SQL Server driver timeout error (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| My boss is complaining that he keeps getting this error when running a very long script from a web page. Which timeout settings is likely the cause of this error? Thanks in advance, Francesco Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/world... |
|
| How Create A SQL Stored Procedure from ASP.NET C# (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Does anyone know how to create a SQL stored procedure programatically in SQL2000 from Asp.Net C#? Thanks in advance! David MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx |
|
| Getting the row count from a SqlDataReader (4 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Alex Lowe webmaster@asp grandrapids.net Hey, I'm trying to get the row count of a data reader, I can't see a way to do it what do I need to do. Here is the code I'm currently using: 'Set up the Command Object Dim objCommand As New SqlCommand(strSQL, objConnection) 'Set up the DataReader object Dim objDataReader As SqlDataReader 'Use a Try Catch E... |
|
| Returning an Identity after INSERT (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I am trying to retrieve a records identity after I insert it. Heres the code: SqlConnection m SqlConnection new SqlConnection(myDSN); SqlCommand m SqlCommand new SqlCommand(sql, m SqlConnection); SqlParameter returnParam m SqlCommand.Parameters.Add(new SqlParameter("@thisId",SqlDbType.Int)); returnParam.Direction ParameterDirection.Output; try { m SqlConnection.Open(); m SqlCommand.ExecuteScalar()... |
|
| Batch Insert in DB very slow (12 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngdata] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com It takes 4 seconds to insert a batch of just 700 rows from a dataset into a SQL2000 database using a stored procedure see code below. I traced it in SQL profiler and it takes 10 milliseconds per row (you can see all rows in Profiler). Shouldn't this take considerably less than a second? What am I doing wrong? Are ther... |
|
| Error Connecting Using sqladapter1 (2 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspngfreeforall] to [ngfx sqlclient] by Marcie Jones marciejones@yahoo.com Following the creation of a new SQLAdapter1 on my aspx form, I receive the message that the sql account could not logon. When I click on preview the data displays without a problem. When I configured the SqlConnection1 I simply entered my name and password etc. Is there something I need to set to tell .Net to us... |
|
| Stored Procedure and ASP.NET (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Will all fields marked OUTPUT be returned by the sproc or just the last? Jon |
|
| Test a Stored Procedure exists and run .sql script (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi all, I want to see if a sql server stored procedure is installed in the database. If it is not found, then I want to read a xxx.sql file and run the executenonquery method to install the stored procs. Appreciate any links on getting me started. Regards, Paul |
|
| reals, doubles (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Got a table with a column of type real : dbo.table1 .... [Rate] [real] NULL, .... in code i have a class that represents this table : public class yadda { ... public double rate; ... } in code i access the table via SqlDataReader : SqlDataReader result command.ExecuteReader; if (!Convert.IsDBNull (result ["Rate"]) { yadda.rate (double) result ["Rate"]; } Initially while testing the code this colum... |
|
| Getting the ID of record added without using a stored proc (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hi there, I asked on a list the other day about getting the auto number ID of a record just added. I got an answer for using a stored proc (which I realise is a better route) but I would still like to know how to do this without using SPs. In the past I could have done the following (which I know isn t the fastest etc..) rstemp.Open "ChartReviews",Conn,adOpenkeyset,adlockoptimistic rstemp.AddNew r... |
|
| Security Exception (3 replies, VIP) |
| ASPFriends.com 'ngfx-sqlclient' list |
| I've been trying to get a connection to SQL Server from my ASP.NET web page. I've even tried connecting to the Northwinds database and received the same error. Here's the output from my error page: 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. Exce... |
|
| SV: Getting the ID of record added without using a stored proc (4 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| You can always use MAX right after the insert of a new record like so: Select MAX(your id) As LastId From yourtable Regards/Hälsningar André Colbiörnsen Sonnenburg Communications Bergsgatan 3, SE 211 54 Malmö 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 Ursprungligt meddelande Från: ... |
|
