Delete Specific Records From Specific Table Randomly
Dec 18, 2013
My application for "Members subscriptions registration" working online and different users using it.
Database type is Mssql Server 2008 R2, Size is around 1 Gb
What happen exactly there is specific record delete from table "Members" in random times, For example I add 100 new subscriptions with around 800 records and make confirm and checking next day find it loss 3 records find it deleted.
I checked all the applications no any delete query, I removed all delete query from application to make sure no any delete also I save any delete query happen in system inside table for log.
I have a data table with 20 records i have to get the 15 unique records randomly and have to store it in Arraylist but now problem is that how i select the 15 unique records from Data table each time .
This is my Controller Action which takes a Page entity from database and shows it in the Show.aspx view using the "Site.Master" master page:
[Code]....
This is the "Show" view rendering "Page.Title" in the "MainContent" content placeholder:
[Code]....
And this is the "Site.Master"
[Code]....
Using this approach i can show "Page.Title" in Show.aspx using any master page that has a "MainContent" placeholder, but my real goal is if i can when i choose the MasterPage for that particular Page to also see a list of available ContentPlaceHolders and when i choose one to then render "Page.Title" in that particular ContentPlaceHolder.
I have an ASP.NET GridView in a Web Form. This GridView using a SqlDataSource and utilizes paging and searching. For the sake of reference, here is the trimmed down version of it:
<asp:SqlDataSource ID="myDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DB %>" SelectCommand="SELECT p.[ID], p.[Name], p.[Email], l.[State], l.[City] FROM [Person] p, [Location] l WHERE p.[LocationID]=l.[ID] ORDER BY p.[Name]" UpdateCommand="UPDATE [Person] SET [Email] = @Email WHERE [ID] = @ID" /> <asp:GridView ID="myGridView" runat="server" DataSourceID="myDataSource" AllowPaging="true" AllowSorting="true" PageSize="25" AutoGenerateEditButton="true"
[Code]....
The data source has a lot of records. At least 25,000. Because of this, I want to allow the user to filter by state. I want to provide a drop down list with a list of states. When a user changes the drop down list, the results in the grid view will be filtered by the selected state. However, I do not know how to do this with a SqlDataSource.
I am creating an application with html using vb as the back end. Microsoft Visual Studio is the application I am using.
My question: I have two drop down boxes...one called department, the other program. When a department is selected, I want the program dropdown to only display the programs that are associated with the department chosen. I have found several different codes to do this but nothing has worked so far.
I have a button in my gridview recurring through the rows which requires confirmation before it deletes a record. Instead of it asking, "are you certain you want to delete this contact?" I want it to specifically ask the user, "are you sure you want to delete <the name of the contact>?" This is the button that I have at the moment and I have no idea how to place the contact's name in there:
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.
How to start at a specific record and returning only the next 5 records with T-SQL command
[Code]....
That is my concatenated SQL statement but it obviously does not work because it only looks at the top 5 records in the entire table instead of what I intended which would be to look at the top 5 records starting with the record where PostNumber equals the value of lastPost. I have been searching for a T-SQL statement that will allow me to do this but I can't find one.
I have an asp:Table and around the mid point of the table there is a DDL with values 2-5. What I want to do is add the selected amount of rows using AJAX right after the table row that has the DDL in it. I know how to dynamicly crate the rows, the info in the rows, and how to use AJAX to make things. Problem is I can not put the ContentTemplate tag inbetween the asp:TableRow which would mark the location I want the dynamic rows to start being added. I did some searching on here but most posts I find start with making the table from code and not the asp:Table tag
My Company registered in certain services on the Web and are relying on the company's Ip to use these services, Director asked me to allow some staff to enter these sites from outside the company,after authorized staff enter to comany's site, How could they use the company's Ip to allow them to browse services sites ? Do I need to use a method such as proxy sites like youtube proxy? or there is another way?How do I do this in asp.net?
My Company registered in certain services on the Web and are relying on the company's IP to use these services, Director asked me to allow some staff to enter these sites from outside the company, after authorized staff enter to comany's site. How could they use the company's IP to allow them to browse services sites? Do I need to use a method such as proxy sites like youtube proxy? or there is another way?How do I do this in asp.net?
What's the best method to allow a user to search in a specific field for a record(s) containing the keywords they enter into a textbox? I am considering using the streamreader to obatin the values from textbox into an array, so I can build dynamic query using the stringbuilder. Is there a cleaner or more efficient method to approach this common search functionality?
In my asp.net gridview i want to count how much peoples are qualified in MCA Â and display the value in a lbel in same page. The qualifications are in COURSE field in my table anme persadata
table name is PERSDATA
PNO Â Â NAME Â Â Â Â Â Â COURSE Â COMPANY
121 Â Â Â RAJU Â Â Â Â Â Â BCA Â Â Â Â Â TCS 234 Â Â Â RK SINGH Â Â MCA Â Â Â Â Â Â TECHNO 525 Â Â Â P RAJ Â Â Â Â Â Â MCA Â Â Â Â Â Â KELTRON 325 Â Â Â ANIL Â Â Â Â Â Â BBA Â Â Â Â Â Â BPL 235 Â Â Â KUMAR Â Â Â Â Â MCA Â Â Â Â Â Â TATA
currently I am doing a web application such that after user search for all the contracts,the contract id is a hyperlink in which user can click on it to view the results tied to it. There is 2 pages. One is for the search page and after searching results is populated below. The contract id in the grid view is a hyperlink so that when user clicks on it, they will go to another page and view the specific records tied to it. How shld I do this as I am creating this web application in 3-tier formatting.
This is the search.aspx:
[Code]....
This is the next page that will display the results tied to this particular ID:
is there any way to search the table name containing a specific data in a given database.
for example, if i have any data, say "Euro" in hand, and i know any of the table in database contain the given value, however i'm not sure which table. So if i can list out the table anyhow containing the data in hand.
I have the following implementation and I'm sure there is an easy way to do what I want to do but I can't figure it out.
1. I use forms based authentication to authenticate to my site
2. I use active directory to authenticate the users
3. I use the Allow Users="xxx" tag to authorize the users limited to the list that can access my site. (e.g.. even though Mary is an AD user she can't access my site unless I put her credentials in the allow users tag in the web.config file)
All is working well but I want to move the users access list (e.g.. <allow users="john" />" from the web.config to a database table so that I can create a user maintenance page for my admins to add and delete user access. For the life of me I can't figure out how to do this and I can't seem to find an article on it either.
im trying to copying specific record from one datatable to another datatable i used below code
public System.Data.DataTable selectspecificdatarow(System.Data.DataTable dtg, int count, int startindex) { System.Data.DataTable dtn = dtg.Clone(); for (int i =startindex; i < count; i++)
[Code]....
its taking too long time in cloneing is there any better way to do this task which is Time effecent
