DataSource Controls :: Delete Query Where [First] + ' ' + [Last] = @FullName, Asks For Original_ID?
Jun 10, 2010
I have a table of solicitors with three fields: ID, First, Last.
I created a page with a dropdown that has all the solicitors by their full name (First + ' ' + Last, example "John Dow") and a delete button to delete them from the above mentioned table.
I added a delete query to the solicitors table adapter in the xsd that looks like this:
[Code]....
I named the query "DeleteByFullName"
Here is the vb code for the delete button click event:
[Code]....
The problem is that the xsd expects the Original_ID as an argument and not @FullName
View 2 Replies
Similar Messages:
Dec 16, 2010
I am trying to display in the Gridview the Full Name of a person.
I have MemberFirstName and MemberLastName as fields in the Table.
Is it possible to display the FullName based on the member fields of the table ?
View 2 Replies
Aug 22, 2010
1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
View 11 Replies
Jan 15, 2010
[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
View 1 Replies
May 17, 2010
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies
Mar 10, 2010
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 Replies
Jan 21, 2010
I've got a query such as
Dim MediaQuery =
From m
In dB.DOWNLOADS _Where m.ID = id _Select
which returns a record from the database. One of the fields in the record is a FK to another table. I need to read this value to be able to set a dropdown based on the ID but I can't work out how to access it. For a standard record I can just do the following txtTitle.Text = MediaQuery.FirstOrDefault().TITLE
However with the foreign key it doesn't work like that. I've tried drpGroup.SelectedIndex = MediaQuery.FirstOrDefault().DOWNLOAD_GROUPS.ID where DOWNLOAD_GROUPS is the FK field but it returns Object reference not set to an instance of an object. If you're simply wanting to read some values from a single db record in the entitiy framework and one is a foreign key how should I go about getting the value?
View 2 Replies
Mar 24, 2010
VS 2008 ASP.NET 3.5 app connecting to an MS SQL 2005 backend. The app contains a strongly typed dataset with a number of TableAdapters. I'm trying to add a query to one of the TableAdapters that deletes from table A, then related entries from table B, then related entries in the master table - table C. The query looks like this:
[Code]....
When I try to run that query to test it out, an error dialog box pops up that says "Unable to parse query text" followed by a second error dialog box that says "Must declare scalar variable @ID". Will the TableAdapters not run sequential Delete statements like this or did I do something wrong?
**Side note: A cascading Delete foriegn key relationship would be ideal, and was configured on the development database, but the DBAs messed up when replicating the database on the production server and getting them to fix something like this can be a difficult process.
View 2 Replies
Sep 15, 2010
have trouble to add delete column to gridview when using specific query.I have PK set up at the table, I need add specific query to display dataat gridview:
SELECT [PID], [GID], [TID], [SID], [NEWSID] FROM [TableOne] WHERE ([NAME] = ?)
After builder this query, I click advanced button. However, generate insert, update, and delete Statements is not enabled.
View 19 Replies
Nov 29, 2010
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Replies
May 7, 2015
In a grid view me bind the data .if i click the update it throw the error like this
Server Error in '/bramandam site' 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:
Line 81: TextBox tfn = (TextBox)dv.FindControl("tsn");
Line 82: Label lb = ((Label)dv.FindControl("Label4"));
Line 83: string qry = "update section set sectionid='" + tbf.Text;
Line 84: qry += "',sectionname='" + tfn.Text;
Line 85: qry += "' where pk='" + lb.Text;
Source File: d:jquery themesramandam siteSection.aspx.cs Line: 83
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
Section.GridView1_RowUpdating(Object sender, GridViewUpdateEventArgs e) in d:jquery themesramandam siteSection.aspx.cs:83
System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e) +133
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +720
[Code] .....
Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971
if i click the update i need to throw the error edit and update the contentĀ
my gridview isĀ
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="sectionid" onrowdeleting="GridView1_RowDeleting" onrowcommand="GridView1_RowCommand" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
[Code] ....
View 1 Replies
Feb 10, 2010
Dim
wi As
System.Security.Principal.WindowsIdentity = _System.Security.Principal.WindowsIdentity.GetCurrent()
[code]....
this code works fine when it is running in my local machine. when i try to open the sam eapplication from remote system its giving error.even i am getting the erron after changed the web.config file with
<authentication mode="Windows"/>
<identity impersonate="true"/>
<authorization>
<deny users="?"/><allow users="*"/>
</authorization>
The network path was not found.
View 2 Replies
Dec 13, 2010
Is there a better way to do this than to check for Exception string?
I would rather have this catch-all error handled on the page, but for SOAP exceptions (web-service calls) I need to log the details of the actual exception that occured on the server, not the client.
The ".Detail.InnerText" property isn't in a generic exception, and can only be gotten after casting a generic exception to a SOAP exception.
[Code]....
I would think there is a way to get at the underlying Exception's type without using string comparison.
View 3 Replies
Mar 5, 2010
I have 3 pages, one to add a category, one to edit the category, and one to delete the category. The add and edit work fine. The delete is not working for some reason. I click the link on my site to delete it, and I'm just staring at the green bar in my browser taking a long time. The add and edit don't take long at all to perform their function. I'm thinking this is a connection string issue, but I don't see how it can be the case. It relies on web.config for it just like the other pages. Following is the delete page code behind and also delete cascade from the business logic area. After the page refreshes, I'm not getting any diagnostics or error messages which I have in the code. Doesn't this have to mean a db connection issue?
[Code]....
View 10 Replies
Jan 10, 2011
I am trying to delete a row of records in a gridview. The selectMethod works perfectly fine, but the DeleteMethod doesn't. When I delete a row, only 1 row of records should be deleted, but the whole gridview was deleted! (I have about 3 -5 rows of data). I am using ObjectDataSource.
Data Access Layer
[Code]....
Business Logic Layer
[Code]....
Presentation Layer
Design:
[Code]....
Presentation Layer
Code Behind:
[Code]....
View 6 Replies
May 31, 2010
i am trying to create an asp.net service where it can delete specific records from the databas, this is by code so far:
[Code]....
this is the error i am getting
[Code]....
the code that it refers to by line 134 is myDataAdapter.Fill(delds, "comments"); so i guest is somthing to do with the .fill
View 15 Replies
Mar 12, 2010
I am running a SP that entries that are older than 6 months. These entries have a file associated with them. Is there anyway I can delete that physical file with SQL server too? Its a Win2K3 server with sql server 2000.
View 3 Replies
Apr 14, 2010
Could you teach me how to make girdview pass my object (with all it properties) to my ObjectDataSource delete method please?So far the object received by the delete method has only the datakey value, other properties are null.From this article indicates that this is default behaviour - ttp://www.manuelabadia.com/blog/PermaLink,guid,c72852ae-1fdd-4934-a715-f565ceaf21cc.aspxBut i need the other properties pass to the delete method too so i can do other thing before I actually delete the record.
View 3 Replies
Feb 18, 2011
I am trying to run a delete command from multiple tables and cant seem to get it to work. When you run the delete it just refreshes the gridview... Below is my delete command and parameters along with the code behind that I run.
DeleteCommand="DELETE FROM RecipeBox, Recipes WHERE (RecipeBox.ID = @RecipeID) or (Recipes.RecipeID = @RecipeID)">
<DeleteParameters>
<asp:Parameter Name="RecipeID" />
[Code]....
View 3 Replies
Jun 28, 2010
im doing an album page just like facebook album
Now im trying to allow deleting album function in which, when i click a button or linkbutton,
the entire album will be deleted including all the photos within that particular album
Album and photo is in two different table in my sql
im using the sqldatasource to set the delete parameter
DeleteCommand="DELETE FROM [Album] WHERE [AlbumID] = @AlbumID"
is there any way i can insert another delete command in the same sqldatasource or other way to do it?
i duno how to do with store procedure.
View 5 Replies
Jun 4, 2010
I have a table that have LibraryID and LibraryParentID.
LibraryID int Unchecked
Name varchar(50) Checked
Description varchar(200) Checked
LibraryLevel int Checked
LibraryParentID int Checked
LibraryTypeID int Unchecked
I want to write a sql to delete the currrent select parent and well as all child record, how can I do that?
View 4 Replies
Jan 24, 2011
I am working with asp.net 2008 and sql server 2005 . I get a situation where i have to delete data after 30 days. a suitable query how to do the same. I have go through different query but nothing going right for me.
View 2 Replies
Apr 28, 2010
First time using a ListView control, I have it inside an UpdatePanel:
[Code]....
[Code]....
[Code]....
[Code]....
When the UpdatePanel Loads, it feeds the data to the ListView. Whenever the user clicks on a row in the ListView, a new window displaying a "note" pops up, the ItemDataBound event ties it all together. What I'm trying to do is add a button to each row so that the user can delete the row. This would call a Sql statement and then the row should disappear. I followed a couple of articles I found on ListView on how to do this, so I added a button called imgBtnDeleteNote (see markup above) and set the CommandName = "Delete", hoping that it would trigger the ItemCommand and ItemDeleting event (I have some bogus code in them, first I wanted to see if they would trigger).
The problem is that they don't seem to get triggered when I click on the delete button. All the rows in the listview disappear, and when I manually refresh the page they come back. My guess is that the events are not firing because I'm not using a DataSource object in the aspx code, but I'm not sure.
View 5 Replies
Mar 18, 2010
I have three tables:
Colour(Colour ID, Colour)
DogColours(ColourID, Dog ID)
Dog(Dog ID, Breed)
Colour ID and Dog are primary keys.
I have three web forms, one for each table. Dog colours consists of data that is already in the system from the other two tables. It basically joins a breed to a colour. My problem is this:
When i try delete a dog which is being used in dog colours the program crashes. How can i prevent this crash?
The second problem, the data source in the dog colours web form has the insert, update and delete tick boxes greyed out in the 'configure the select statement' so i am unable to delete a colour and dog joined together. how can i delete something in the dog colours?
View 13 Replies
Apr 11, 2010
I have a sqlDatasource with a SelectParameter ControlParameter linked to a dropdownlistIs there an a way to select all records like *
[Code]....
So I can select records by year, but is there a value that will select all records for the @Year Parameter so I can display all records?
View 3 Replies