i pass the debug test in this page and then when i run t he website i get Eror 404 ... i checked it and its seems that the problem is in the insertion but i cant fined the mistake.... this is my code behind :
[Code]....
When I debug the project for viewing and fixing design issue than I see all the test are running as well. How I stop this so that my tests don't run while working on my UI project?
View 1 RepliesI am trying to create a page which uses formview to display an existing record
I want to add a gridview to the same page which will display records related to one of the fields in the formview.
In the select criteria for the datasource of the Gridview how do I reference the field from the formview?
for example something like this: Select * from table2 where table2.IDinstance =formview1.editbox1.tostring
[code]....
Is ther a way I can tie DataSource to SqlDataSource on aspx page and pass select parameters?
I am currently working on this situation that I could not find any other resources online to help me
Everything is working fine through VS2008 debug mode, or run without debugging ( database connectivity and everything works)but however when i copy the whole project and set up the IIS,
everything work except for database connectivity. I could not seems to read from the database which currently I am using a attached .mdf file
the error shown is as below :
Server Error in '/' Application.
Object reference not set to an instance of an object.
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 Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
Source File: Signup.aspx.vb Line: 23 Stack Trace:
[Code]....
but however when i run on VS 2008, I am able to read the data from the database successfully,
I want to debug EditPanel.debug.js file of HTML Editor, but it never shows in VS 08 and Im sure it executes to that line.What I did to enable debuggingUnchecked both 2 checkboxes for disabling the debugging
Set ScriptMode="Debug"
Change following line
[ClientScriptResource("AjaxControlToolkit.HTMLEditor.EditPanel", "AjaxControlToolkit.HTMLEditor.EditPanel.js")]
to
[ClientScriptResource("AjaxControlToolkit.HTMLEditor.EditPanel", "AjaxControlToolkit.HTMLEditor.EditPanel.debug.js")]
I need to somehow test if a table exists in a database. If it does not then I need to create the table. How can I test for existence of a table using SQL? It seems like some type of SQL logic is needed?
View 2 Replieshow to test to ensure a successful connection to SQL 2005 database (DB) before proceeding with getting user name from this sql2005 DB for example.
If connection failed don't let asp.net direct to my error page due to this in web.config.
<customErrors defaultRedirect="~/Error.aspx" mode="On">
</customErrors>
I would like to redirect user to check in as a guest when the sql2005 connection failed from the hoting company.
restore a master database from production to test server.
The reason to do this because I need to test and evaluate some login in master database.
I tried to restore master database to test server, but I got some errors regarding about user databases are not exists in test server. I don't want to restore user databases, I only need master database for evaluate user login.
I know the following sproc is vulnerable to SQL injection:
[Code]....
I would like to write a call to this sproc that uses SQL injection to execute the additional command:
[Code]....
That way, I can demonstrate the vulnerability of the sproc to SQL injection and test any revised implementations of the sproc using the same test call.
Problem is, SQL injection is harder than I thought! I just can't seem to do it.
Can anyone provide me with text for the sproc call to execute the additional command?
I have installed SQL Server 2008 at my machine.
When trying to debug....i am getting following message...
"Unable to start T -SQL Debugging. Could not connect to computer AMIT. The workstation service has not been started."
Can you test your connection from localhost to internet host Sqlserver Database
View 4 RepliesI'm developing an ASP.NET application which has allows users to search for other users based on their name. This search is done using Linq to SQL. At the moment, I've only got 10 or so users in my database, so I can't really test the efficiency of my search query. I'm new to testing and such, but what is the best way to simulate 100/1000/10000 users on a query? Is there a tool (preferably free) that would allow me to perform tests to see how quickly the database can be searched if it had x number of users?
View 1 RepliesI want to have the following URL pattern in my MVC application:
www.test.com -> display welcome page
www.test.com/5 -> display article with ID 5
I have set up my Home Controller like this:
[Code]....
When I request www.test.com, everything works as expected (the Index action is invoked with the ID parameter set to NULL).
But when I request www.test.com/5 it says: HTTP 404 Resource not found. When I request www.test.com/?id=5 it works.
I'm new with all stored procs - but I have a very basic Full Text Search going on...I created a stored proc, and linked it up to my application using Linq to SQL. If I use Linq to SQL to call the stored proc without any parameters (hard coded search string) i get results back, as soon as I add a parameter - the result set is 0 for some reason.
The funny thing is that I run Profiler and execute both queries its trying to do - and it looks identical
Here is the working parameterless query:
[Code]....
and according to Profile this is what it looks like when its called as a stored proc
[Code]....
I get 2 results as expected.
Here is the NON-working stored proc that takes in 1 string parameter
[Code]....
and here is the query that gets called when profiling
[Code]....
declare @p4 int
I have a query that I want to test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure. Does anyone have suggestions on how I would be able to closely watch the actual steps here? I was thinking of turning on tracing and adding Trace.Write for each of the events that fire along the way. This doesn't seem efficient and I wanted to see if there was a better approach.
View 2 RepliesOn my web form, I have a RadioButtonList nested within a ListView as follows:
Nested RadioButtonList, and Inconsistency between Debug and Run without Debug
I have added a web reference using the wsdl file that was provided to me. I also created an instance from the proxy class as follows :
Code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DLObj As New WebReference.DrivingLicenseInfoServiceService
But after this am totally confused on the next steps and how to pass username and password and test the service connectivity.I have attached the autogenerated code.
I have a page that has been working for sometime and now getting this error..
String was not recognized as a valid Boolean.
Im was working on a How-To document of the pages for our VP and now i cant get to page 2 to continue the document.
I have recently added 2 new radiobuttonlists(rel and relst) and im sure its one of them thats causing the issue. But sicne i cant debug not sure which one is failing. Here is my insert code and the error is occuring on the Line 376:
cmd.ExecuteNonQuery();
The fields for the radiobuttons are all setup as BIT in SQL. They all have default values of 0. They are all setup NOT TO ALLOW NULLS.
[Code]....
I am trying to implement a website that was developed on a test server and make it go live. I am running into an issue with a function within the DB that decrypts a password. Here is the function
USE [ward2004]
VS2008 ( vb.net ) I created a test page with a gridview and link button on it. in code behind i placed the following code
[Code]....
this works perfectly .. however, if i set up the same page, but use a master page as well ... then that code doesnt work. GridView1.Rows(e.CommandArgument.ToString).Cells(15).Text.ToString() is empty
I am getting return some data through stored procedure in a asp.net 3.5. Below is the method.
public DataSet GetDataSet(string strConnection,string strSPName, string param1)
{
DataSet ds = dataAccessLayer.getDataSet(strConnection, strSPName);
return ds;
}
In some cases, I have to pass 3-4 parameter. How can we do pass optional parameter here....
Would anyone know how to pass a variable to SqlDataAdapter. Here is my code.
TextBox1.Text = 1
Dim textboxval
As
String
textboxval = TextBox1.Text
connection.Open()Using connection
As
New SqlConnection("Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=TorGHL;Integrated Security=True")
Dim dapubcb
As
New SqlDataAdapter("SELECT [BarName], [MenuSubId], [Address], [PhoneNo], [BarURL], [Email]
[BarDescription], [Id], [bg_long], [bg_lat] FROM [BarDetails] WHERE [MenuSubId] = texboxval ", connection)
I have an objectDataSource which uses my stored procedure GetNotifications
And my GridView is bound to that objectDataSource
the only problem is that my stored procedure requires the variable @UserName and then returns the values for that username, but I do not know how to pass the variable to the objectDataSource, does anyone know the code for this?
I can get userName from HttpContext.Current.User.Identity.Name but how do I pass that to the objectDataSource?
I'm trying to pass default value to a sql parameter which is
[Code]....