f i have one item in my dripDown list and i want to select it like to delete from the db. but the function didnt work because,it didnt change is "selected item", or if my drop downlist starts with somethins that i want to delete but i need to change the index first but i dont want to delete other items.
View 8 RepliesI have made a DetailsView which in DetailsView there is action to add the data, change data and delete the data ..how to save, change, delete data, which is in the DetailsView without saving it in the database?so far I use viewstate, but I do not know how to apply it in DetailsView ..
how to create insert , update , delete . in detailsview without saving in database ..
private void Bindemptydt() {
//Declare a datatable for the gridview
DataTable dt = new DataTable();
//Add Columns to the datatable
dt.Columns.Add("report_id");
dt.Columns.Add("param_field");
dt.Columns.Add("param_label");
[code]....
i have used one query like this
Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0%'
it is working fine. But while giving
Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0,C#%'
It is not filtering data from database. It is only checking starting and ending Character.In my database some keyskill are like that
Asp.net 3.5,4.0,C#,Sql server 2008,Silverlight 2.0,3.0.
My requirement is to check each word in "SkillReq" text.
Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.
My current statement is as follows (there are alot more fields but I have shortened it ):
SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........
I want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 RepliesI'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Repliesi have two tables named
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
2.Messages (MessageId,MessageText,ChannelID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
select LookupPageInfoId,
PathMessageID,
pagemessageID,
(select messagetext from Messages where MessageID=PathmessageId) as TEXT from LookupPageInfo
What is difference between select { } and select new {} In Linq Query
View 3 RepliesI am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
How can I SELECT second if first SELECT returns nothing?
View 8 RepliesI have a SQL Data Source that displays records after going through the Query Builder and select "Test Query" yet when I save it, go back to the design mode and select View in Browser I get nothing but a blank screen.
View 3 RepliesI am trying to search how to select rows from a datatable. When selecting these rows I should be able to delete the row or edit (update) the row.
I am using the following code to load the data from MsSql 2008 to a dataGridView;
DataTable dtTypes = new DataTable();
SqlConnection con = new SqlConnection(Settings.Default.JLTrackConnectionString);
SqlCommand cmd = new SqlCommand("SelectJobTrackForDate", con); [code]....
Is there any good article which tackles this because I am searching for the bad keywords I think.
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 RepliesThis is my House_p table
Iamge3 Image2 Image1 Name ID
3.JPG 2.JPG 1.JPG SARA 1
With linq to entities, how can I delete and update data inside a database without first selecting the complete entity at first?
View 4 RepliesI'm using Access 2007 for a project and I'm trying to run the following parameterized query:
string sql = "DELETE * FROM participants WHERE participant_id = @participant_id"
OleDbCommand command = DataAccess.NewCommand(sql);
command.Parameters.Add("participant_id", 1);
command.ExecuteNonQuery();
The really weird thing is that it will work if I hard code the value:
string sql = "DELETE * FROM participants WHERE participant_id = 1"
a user loged in and he wants to delete his user. how do i make a delete query that refers to his userID how do i get the user id of the current logedin user?
View 4 RepliesIn subsonic 2 we could do this:
public static void DeleteTable(SubSonic.TableSchema.Table table)
{
new Delete().From(table).Execute();
}
How can we do the same thing in v3? I can only seem to find documentation about using generics to target a specific table in the database...I want to be able to use it with a parameter as above.
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?
I'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
View 4 RepliesHow to display edit and Delete View in J Query Light box in MVC 3.0 razor view engine?
View 5 RepliesLot of times I did edit, delete, insert in my webproject in different pages but I am very surprised that why I am not remembering the technique to do these task. Actualy I never take any course on asp.net/vb.net, what I did in my project just to take help from forum or asp.net website etc. I get a task again to make a web interface having functionality to view data and provide Edit functionality also. The other task is to click a link in the same page to open a new page with the fields of the same table to insert new record.
Q1: Is it necessary to take a dataset or I simply do it using sqlDatasource?
Q2: Could anyone give me a very basic and simple vb.net/asp.net project with all above tasks so that I will do a practice project and never miss it?
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