i am working with a database to create a website i know how to display the data into tables on my website but is there a way of changing the database layout when a button is pressed. i.e. so that when a button is pressed on the website the program sorts all of the first names into order (A to Z) in the database - so that the information is displayed A to Z
View 4 RepliesThe AjaxToolkit has a ReorderList. I'm searching for a jQuery solution that does the same and found this page. I would like to change the order of divs (vertically) and upload the new order to the database (ajax).
View 2 RepliesI have a function in sitefinity that returns a list of categories.
//return list of categories
private IList<ICategory> GetCategoryDataSource() {
var cntManager = new ContentManager(CaseStudyManager.DefaultContentProvider);
IList allCategories = cntManager.GetCategories();
List<ICategory> filteredList = new List<ICategory>();
foreach (ICategory category in allCategories) {
filteredList.Add(category);
}
return filteredList;
}
What I want to know is how to sort this list.
Categories in Sitefinity are as far as i can tell just a string, there are no other fields associated with a category. Therefore I have nothing to sort the categories on, other than appending each category with a number, like:
1 - Legal
2 - Financial
3 - Property
When these categories are displayed on the website I can then at least trim the parts i need.
I have the following classes in my Model:
public abstract class Entity : IEntity
{
[ScaffoldColumn(false)]
[code]...
how to create a list order and unorder using database
View 2 RepliesI am developing Online Food Ordering web application[asp.net+Sql]. I want to show automatic popup at admin side when user order for food. (Like fb notification). When user place order that time admin should get automatic popup.
View 1 RepliesI have 5 hard corded texboxes in a page in a sequence with sequence Number . Now i want to add re-order /re-arraning functionaly .. but i can't use ajax reorder list because i have 5 hard corded texbox. how can i maintain the order in Insert/Update cases. And also suggest me control that i can use, another than ajax re-order list. coz i not using any list items i have hard corded items on the page.
View 1 RepliesI have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
In C# I need to connect to a database. How do I find out the username and password to use for that database? I know that sometimes the "sa" username can be used. I don't know how to find the password though. I am working on a contract and no DBA, and the developer left for a different job.
View 1 RepliesI`m making an online order project.Clients can chose products of some categories and than they can order it.
I have a database with tables: Clients,Products,Categories,Orders,A table that connects orders with products,etc etc.Now if a client cliks in category (for excample motherboard) than all kinds of motherboard will show in aspx page.
I want to ask you how to do this:how to take products i want from database and put them into an aspx page and after that clients need to click in one product and then order it.
From my testing, it appears that the order of parameters for the UpdateParameters must match both the order of the bound fields on the form (asp:Formview), and the order of the parameters in the UpdateCommand. Is that correct? If so, why do the parameters have names if all that matters is the order? I tried both asp:ControlParameter and asp:Parameter. Maybe the more relevant question is why aren't the names used instead of the order, particularly for the form order?
So, given I display the Identity field (CID), and need that for the update, I cannot get the update to work without including it in the UpdateCommand. Of course, since it is an autonumber field in Access, I cannot actually set it. So, I had to add another field to the db (lngUpdateCID) that I could set. That can't be how it has to be done, but I could not figure out another way to do this.
The relevant code is below:
[Code]....
I wanna save the order of my list to the sql server database in jquery drag & drop using asp.net c#. How can I do this?
View 1 RepliesI need to populate my textfields from values in database. I also need navigation buttons to scroll through all records, similar to an access form. Below is what I have on the OnLoad event:
[code]....
i have three pages named first.aspx, second.aspx, third.aspx. i fillup some fields in first.aspx, then click next,i fillup some fields in second.aspx then click next, i fillup some fields in third.aspx and here i click submit button.now i want to save those all fields in to the database at once.
View 5 RepliesI have created a basic website using ASP.net VB in order to display a diary of various user inputs to a website, I have created a register page, home page and once the user logs in it will direct them to a user logged in page where the diary entries that they have been created or been added to are displayed from the built in SQL database. I am trying to work with roles to ensure that when a certain login user is logged it will link them to a certain page (sort of like a basic admin page, but really its just to link to a page that only they can see).
I have used a session variable to take the username input and to display the diary entries they are linked to. How can I use another session variable to compare the role of the user that is logged in to allow me to direct them to the webpage that should link to their role. I have written code on the .aspx.vb that I thought would have worked, but it complies fine but doesn't work correctly. How can I write the code so that when the person inputs their details in, it would compare the username/password then to the role that they have been associated with in the database (these areas are all in the same table) that will then link to the webpage.
This is the error message I get on running the login page.Input string was not in a correct format.
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.FormatException: Input string was not in a correct format.
Source Error:
Line 46:
Line 47:
Line 48: ElseIf Session("LoginRole") = ("Diary Owner") Then
Line 49:
Line 50: Response.Redirect("DiaryPage.aspx")
Code:
Sub LogBut(sender As Object, e As System.EventArgs) Handles LogButton.Click
Dim connection As New SqlClient.SqlConnection
Dim command As New SqlClient.SqlCommand
Dim adaptor As New SqlClient.SqlDataAdapter
Dim dataset As New DataSet
[code]...
I have taken over development of a asp.net 3.5, c#, MSSQL website, which I did not create.
There is a form on the website which adds all kinds of information into my SQL database. I have added two fields to the database, two corresponding extra form questions and added to the c# code behind so that these new fields are treated in exactly the same way as the existing ones.
I am therefore completely stumped as to why those two fields aren't populated in the database when I submit the form.
No page errors or anything, it's just the fields remain empty when the other pre-existing ones are populated just fine.
Is there something obvious I'm missing - for example is there a setting in the database I'm not enabling to allow the two new fields to be written to by my c# file?
I was not a programmer before this, I'm just picking it all up as I go along.
If I am going to use the AdRotator with Database and set the properties from the table fields, how can I set the impression?
View 5 RepliesHow can i make this work like i have 5 fields in my database table . 2) i created a model for validation with datannotation and created the compare password field as well with comparepassword attribute. (now my model has 6 fields including one external field compare password and 5 database fields)3) i created a view with that model.(User)4) now i created a controller as well but the problem arise here that when calling that actionmethod the compiler complains about the external field and tells it cannot find any extension method . how can i create the extension method or solve this error?
[Code]....
Have created a Webform based on a master page.The code executes OK and sends data to the database, but inserts null values for all entries except the GetDate.
If I use exactly the same code in a new webform which isn't based on the master page, it inserts everything correctly.Here is a snippet from the form which uses the master page: -
<%@ Page Title="" Language="C#" MasterPageFile="~/SpeedDateMasterPage.master" %>
<script runat="server">
private void AddToDatabase(object source, EventArgs e) [code].....
I have an SQL datasource that successfully enters customer details into a table. What it includes is the persons address. First of all we add the persons address, then we add the persons name to that address in a seperate physical procedure. i.e. on a different form.
What I need to do is try and stop users entering the same address twice. The way I have thought of doing this is by making a string field called AddressIdentity and have this contain the door number and the postcode of the address with all the spaces stripped out. Then when adding the address, it checks if this exists before adding it. However I cannot work out how to put the 2 fields together without using the codebehind file, which I don't mind doing if I need to, but I'm sure its avoidable.
Here is my code - I have only included the relevant parts:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo)"
<InsertParameters>[code]......
So how do I do it? I was trying:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo], [AddressIdentity]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo, @Postcode + @DoorNo)"
but of course AddressIdentity is a string. Do I use ' ' marks with an & sign? Or can't I do this?? Maybe I need to use the codebehind anyway to see if the field exists before inserting it?
how to disabled and uncheck the checkbox values from database fields..if i have entry in my database records as :Name Seats DateSumit 1,3 11-Dec-2010Sanjeev 2,4 12-Dec-2010Manish 1,3,4 11-Dec-2010I want on page load event the default date for todays is 11-Dec-2010 then checkbox1, checkbox2, checkbox3, checkbox4 will be disabled and unchecked state for 11-Dec-2010as you see on the above database structure the seats for 11-Dec-2010 is 1,2,3,4 so the chekbox1, checkbox2, checkbox3, checkbox4 will be disabled..
View 1 RepliesI have an issue where I am running out of database space on my hosting provider. As it turns out, the aspnetdb database is more than 6x our application database. We are using anonymous profiles and there are 21 fields stored in each user profile.
Upon analysis, most of this data is not required to be stored - it is simply wasting space. The part that is wasting the most space (5 binary objects) are not even used by any of the public users. I would like to remove these binary objects from all of the user's profiles without deleting the profiles, but I can't seem to find any documentation on how to do this.
I can remove the fields, which will take care of users going forward, but I need to retroactively delete these fields from the aspnetdb database to free up space. Since each user manages their own profiles, I am unsure how to create an automated procedure to delete these fields out each anonymous user's profile.
I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?
View 5 Repliesi want to make sure all product names are unique so i tried to do the following. but it is causing an infinity loop at the lambda expression.
public partial class Product
{
partial void OnProductNameChanging(string value)
{
using(var ctx = new MyEntityContext()){
var val = value;
var item = ctx.Products.Where(o=>o.ProductName == val).FirstOrDefault();
if(item != null)
throw new ValidationException("Product Name existed.");
}
}
}
i'm using asp.net 4.0 with dynamic data and entity framework.
I'm not sure if I can explain this properly, I just need some advise. I'm working with a formview and datasets to populate the information. However I have a table specifiying which fields to display. In my table If cell, work and home fields are selected then those fields must be populated in the formview if they not selected then it shouldn't be shown. These are 2 different datasets being pulled into the formview.
Right now I have a datasource populating the formview via the wizard, not sure what to do next.