SQL Server :: Database Deletion Not Working When Parameter Involved?
Sep 2, 2010
I have a system in which users can enter records into a database via ajax. Each user may hold many values in the database, with different pageId and itemId values. Each user is identified by a GUID set to a cookie. The system needs to prevent the user from entering two pieces of data with the same pageId and itemId, so I've created a script to do two database updates:
Firstly, all records are deleted from the database where the memberGUID, pageId and itemId fields match (i.e. they've already added this item).
Secondly, the record is then recreated.
It all works brilliantly, except when the GUID value is passed into the delete statement, then I just get a caught exception.
So this works:
[Code]....
But this doesn't:
[Code]....
The weird thing is that because the GUID value is being saved in the second database call, it is definitely there and is definitely the right data type etc. Even if I hard-code it into the delete procedure it still causes the whole thing to fail.
why it's failing when I add the GUID parameter in the deletion process?
View 4 Replies
Similar Messages:
Nov 20, 2010
I have an sql table in which i have two columns enq_no and enq_serial.
for a particular enq_no, enq_serial should get incremented by one starting from 1.
What is the best approach to achieve this?
another issue is that after deletion enq_serial should get decremented by one.
How can i get this?
Is after delete trigger could be a good option?
If so? how can i get this with after delete trigger?
View 4 Replies
Aug 21, 2010
I've a MDX Query that has where clause as shown below.I'm designing report using SSRS 2008. How can i pass date as parameter? I tried to setup @from and @to as parameter but not working?
WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )
need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )
View 1 Replies
Jan 26, 2011
I have an application with 40 or so separate databases that share a number of identical table schemas. Each is for a separate agency that performs functions identical (nearly) to the others. I have a number of reports that involve complex queries that each agency is required to produce. There is a "top-level" agency that would like to run the same reports but have the data consolidated for ALL agencies. I have tried having the query generated simply re-produced for each sub-agency by using a "UNION" ..
SELECT .... FROM [Agency].[dbo].[Table] ... UNION SELECT ... FROM [Next Agency].[dbo].[Table]....
This works for a few agencies selected/included but when they try to select all agencies or more than a few, it fails because the query is too large. I have tested a stored procedure:
CREATE PROC Test @DB AS
SELECT ... FROM [@DB].[dbo].[Table]...
Thinking I can build a smaller query by having up to 40 items of "EXEC Test (db) UNION EXEC Test (next db)" That also fails.... won't permit the database specifier as a parameter (plus, I don't know if I can do a UNION on the EXEC results).
View 9 Replies
Nov 7, 2010
how to insert radio button selection into sql server database using parameter.
View 3 Replies
Mar 19, 2011
I would like to know what are the basic steps involved in setting up your application to able to read data from another application. Then take that data and modify it and send it back to the application.
The data being read will have over 100 fields.... what is the most efficent way to store them? Put them in a class object?
I know web services are involved..
The application is in .NET using vb
View 1 Replies
Jan 25, 2011
I am building a Web Forms application, it involves a database, so I have some sort of login.
I have put all the webforms to do with Account Login and Update into their own separate folder. The folder is called { Account } in the application root.
My Site.Master is also at the application root, along with other files (e.g. Default.aspx .. etc).
This image file path breaks when I view the pages inside the Account Folder:
[Code]....
I understand why it is happening, but I can't figure out how to avoid this problem, unless I put the Master page along with all the other files into a folder too.
View 2 Replies
Jun 9, 2010
I have created a new VS2008 ASP.Net Web service project, with the default name WebService1. If I right click on the Service1.asmx file and select 'View in Browser' what are the processes that go on to make this happen? I am asking because I have a situation where when I run this from a visual studio project started in our development shell (which sets up a common build environment) I cannot get the web service to show up in the browser.
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
ootc43ddc22268ae91bhashhash.web
View 1 Replies
Dec 27, 2010
i have in asp.net a few textboxes and i wish to update my database with the values that they encapsulate. The problem is that it doesn't work and although it doesn't work, the syntax seems correct and there are no errors present . Here is my linkbutton:
<asp:linkbutton id="clickOnSave" runat="server"
onclick="Save_Click" Text="Save Profile" />
and my update function
protected void Save_Click(object sender, EventArgs e)
{
SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = "DataSource=.\SQLEXPRESS;AttachDbFilename=C:\Users\alex\Documents\seeubook_db.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
String commandString = "UPDATE users SET last_name='" + Text4.Text.Trim() + "' , first_name='" + Textbox1.Text.Trim() + "' , about_me='" + Textbox5.Text.Trim() + "' , where_i_live='" + Textbox2.Text.Trim() + "' , where_i_was_born='" + Textbox3.Text.Trim() + "' , work_place='" + Textbox4.Text.Trim() + "' WHERE email='" + Session["user"] + "'";
SqlCommand sqlCmd = new SqlCommand(commandString, con);
sqlCmd.ExecuteNonQuery();
con.Close();
}
View 2 Replies
Mar 2, 2010
i am adding a connection in asp.net using visual web developer to sql server database file, it's an MDF file.
when i click test connection i get this:
View 2 Replies
Feb 23, 2011
Only books and of course these books will be stored in an SQL server database at a romote host. So farhere are the tables I haveBooks.. of course, which describe each book that will shop up on the web site.. The site will have the ability to show all books or search books by author, catagory, etc,..Book_Catagories or properties or? This is something that the person I'm writing the web site for wants and he wants the ability to add a book to more than one catagory such as a theme book, first edition, autographed, etc,.. He wants to be able to add the catagory or catagories at the same time he enters the book..
View 1 Replies
Mar 28, 2011
I have a button click event code block in which data should be updated to my database. After stepping through the code, the ExecuteNonQuery() executes, but no data in my database is changed. I don't think there is a problem with my code although I will include it just-in-case.
[Code]....
I'm confident that my command text and my parameter adding is correct.
View 11 Replies
Jun 23, 2010
Is it possible in my code behind,to remove one specific item from a dropdown box that is bound from a sqldatasource? I've tried, but can't figure this out.
View 3 Replies
Dec 21, 2010
The following is a note from Professional ASP.NET MVC 2 by Scott Hanselman ++
You might ask — why did we go through the effort of creating a <form> within our Delete Confi rmation screen? Why not just use a standard hyperlink to link to an action method that does the actual delete operation? The reason is because we want to be careful to guard against Web-crawlers and search engines discovering our URLs and inadvertently causing data to be deleted when they follow the links. HTTP-GET-based URLs are considered safe for them to access/crawl, and they are supposed to not follow HTTP-POST ones. A good rule is to make sure that you always put destructive or data-modifying operations behind HTTP-POST requests.
If web-crawlers and search engine have no access to the page containing deletion button, is it safe to use a standard hyperlink to link to an action method doing the actual delete operation?
View 6 Replies
Feb 16, 2010
I'm working with a ListView and I have a problem: When I click the delete button, I need to know before deletion takes, the index of the item, because I have to do something before this event happen
View 2 Replies
Oct 19, 2010
checkboxlist textbox from a data transfer,I want those people in the textbox before the deletion.
obviously...
The second update, not deletion textbox
View 1 Replies
Jul 9, 2010
am using asp.net3.5,C#. I am using this script in codebehind when mycheckboc is checked,now i want to give delte confirmation when checkbox is unchecked. so i need to catch whether it returns true/false for deletion in codebehind,,according to that i follow my steps.
I have written like this
[Code]....
I need to display other msg,functionality when it is checked n I need to do other msg,functionality when it is unchecked,,
I need to call a codebehind funtion if the confirmation returns true.how can i do this?
View 11 Replies
Oct 20, 2010
Whenever I write lines like this:
<%: Html.LabelFor(model => model.AccountName) %>
And save the file, some lines (some, not all of them, haven't figured out the logic behind this yet) will be converted to this:
<%: Html.LabelFor(model => model.AccountName)%>
View 1 Replies
Mar 14, 2010
Isn't the Bind attribute, preferable the Exclude parameter, define any properties that will be excluded from any form update? If so, why does the ModelState is not valid when I do this?
[code]...
View 1 Replies
Jun 22, 2010
have a search on my site, in which search type and search word are in URL like this: /search/t-someword.htmly route for search:
routes.MapRoute("Search", "searchj/{type}-{word}.html", new { controller = "Search", action = "Index"}, new { type = @"[t,s,p]"});
Everything works fine but when I change string to do not show spaces that word like "some words" looks like "some-words" it doesn't work. With spaces it works
View 4 Replies
Jul 1, 2010
I am using the stored procedure below for the select command of a SqlDataSource, and I'm trying to pass a query string parameter, but I get this error:
Procedure or function 'ActivationCampaignGetById' expects parameter '@campaignId', which was not supplied.
The parameter is present in the query string:
http://localhost:62681/Activations/ActivationCampaignDetails.aspx?id=98
Here is my DataSource code:
<asp:SqlDataSource ID="campaignDataSource" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ProVantageMediaManagement %>"
SelectCommand="ActivationCampaignGetById" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="98" Name="campaignId"
QueryStringField="id" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
And my stored procedure declaration:
ALTER procedure [dbo].[ActivationCampaignGetById]
@campaignId int
as
select
View 8 Replies
Apr 18, 2010
I am using the stored procedure below for the select command of a SqlDataSource, and I'm trying to pass a query string parameter, but I get this error:
Procedure or function 'ActivationCampaignGetById' expects parameter '@campaignId', which was not supplied.
The parameter is present in the query string:
http://localhost:62681/Activations/ActivationCampaignDetails.aspx?id=98
Here is my DataSource code:
<asp:SqlDataSource ID="campaignDataSource" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ProVantageMediaManagement %>"
SelectCommand="ActivationCampaignGetById" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="98" Name="campaignId"
QueryStringField="id" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
And my stored procedure declaration:
ALTER procedure [dbo].[ActivationCampaignGetById]
@campaignId int
as
select
View 1 Replies
Jan 22, 2010
I have a gridview which has bound fields and a template field for checkbox.I wrote a code for deletion of records as per checking checkboxes.My problem is
HtmlInputCheckBox chk;
foreach(GridViewRow dr in dgvdetails.Rows)
{
chk = (HtmlInputCheckBox)dr.FindControl("ch"); [code]...
View 2 Replies
Jul 27, 2010
I was expecting a parameter will become a empty string value if the parameter is missing, but it turn out to be null. have I done it wrong for the optional parameter?
[Code]....
View 3 Replies
Apr 13, 2010
I have a report where I need to select parameter values from dropdowns. Reports works fine when I run it on reportserver manager or when I do RUN.
The problem is when I try opening it in the MVC views to select parameters from a dropdown, its subsequent dropdown is not able to show its values
for example:
I am able to select first DD Country as it does not have any thing to select earlier.
The State DD is not rendering its relavent states from selected country. (it works in report manager and when I run it without debugging)
Question: how do code to make the dropdowns working.
View 1 Replies
