I have two tables customers and sales . I have a formview that inserts to customers (new customers). I want every time I insert a new customer automatically redirect to another page where I will make a sale. On table sales I have a column CustomerID which I want to automatically take the auto numbered CustomerID from Customers table.
View 2 RepliesI have a textbox that takes an integer value, and a submit button that when clicked passes the value to a detailsview to display the database record at that index.
What I'd like to do is, when the button is clicked, compare the number to the keys in the detailsview's datasource so that if the record ID doesn't exist, I can display a label telling the user that the ID# doesn't exist.
How would I go about doing this? Is there some sort of compare method for the datakeynames property?
I'm getting up to speed with MVC. In all examples that I find, the database tables always seem to have a single autoincrement column as the key. Is this the standard for DB Design when the intent is to use MVC or can MVC cope with compound primary keys that dont necassarily have autoincrement?
Typical DB Design:
[code]....
It's just that obviously in the real world many companies already have a good DB design populated with data based on the classic design style. If I get clients contemplating updating their applications and want to use the MVC framework, will they also need to consider the redesign of the DB?
If MVC can cope with compound key's are there any good examples. I thought that by using binding exclude/include that compound keys are possible, but it wasn't clear to me.
i'll make a simple website. in my website i have two kind of products to sell
1. Projects
2. Documents
These Tables are available in my database :
[code]...
now i will make an order table. should i make differentt order table?
or i could save order information of both tables in one table?
Cannot seem to find a good fit for my question so I will ask here.
Does Asp.Net 4.0 solve the problems with using Views with EntityFramework is not able to recognize primary keys.
I have started my new mvc project with entity framework,Must say it is very diffcult to work with entity framework.
"I am trying to create new custom entity in .edmx file,Now i have made one column as Entity key,Which is already entity key another entity set."
"Error 3033: Problem in Mapping Fragment starting at line 3081: EntitySets 'Entityset name' and 'Entityset name' are both mapped to table 'Entityset name'. Their Primary Keys may collide."
Using a very run-of-the-mill database, with identity int for primary keys, a Dynamic Data Entities Project (EntityFramework) displays the primary key for view and edit. When using Linq to Sql, the primary key fields are not displayed.
I would like to hide the primary keys and use Entity Framework (VS 2008, .Net 3.5 sp1).
i was given a form in which empid is varchar and i m supposed to auto increment it using a function and calling it ....i have never done this. plz help me out the way .
View 9 RepliesIn LINQ to SQL, can primary and foreign keys be autopopulated from an associated key?I'm using the asp.net userID assigned by the create user wizard as the primary key/foreign key in several tables. Right now, when a new user is created, their userID shows up in the asp.net tables but not the ones I created. I thought it would be easier if the keys could fill themselves in, like cascade, so as I have the user fill out forms, they would already have a row in the table created and it would be an of an update instead of an insert row.
View 2 RepliesIf its posible I want to create a table with a primary key with auto-increment and a fixed value to differentiate the table from others tables
ex:
table 1 | table 2
ID | ID
----------|-----------
a1 |b1
a2 |b2
a3 |b3
auto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.
View 2 RepliesI have a DataGrid that I need to be able to use to delete records form a file
[Code]....
[Code]....
I use
((TextBox)GridMenuOptions.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
To access the data in the Grid for updating, but it doesn't work for deleting
I can use
string id = GridMenuOptions.DataKeys[e.RowIndex].Value.ToString();
but that only returns the first key.
How do I access the rest of the keys?
Have an SQL database. Need to pass the next id for the identity column.
My db doesn't use identity seeding so it doesn't auto increment the next id as you normally would.
What I'd like to do is simply use linq to get the last id then add 1 type thing.
then pass it to my model. If I set the db to increment the insert works as expected. When I try to manually pass the id (disable the auto-increment obviously in the column) it fails.
So say in your controller for the "Create" action id like something like the following:
[code]....
This fails but say I update a different field (anything other than the PK) it works just fine.
I'm building an incident reporting site in ASP. I have a gridview listing incidents, with a unique dynamic number for each incident. SQL generates a report for each incident, and I need to create a hyperlink at the end of each gridview row linking to the associated numbered document so the report can be opened and printed.
Incident Number Incident Name Incident Description Incident Report
112 fred tall link
111 frank short link
110 bill wide link
The fields are populated by pulling data from SQL (names have been changed to protect the innocent!). The link for the document needs to contain the number from the dynamically generated Incident number. SQL creates a folder full of docs:-
IncidentReport112.xml
IncidentReport111.xml
IncidentReport110.xml
I'm guessing I need to add a hyperlink field to my gridview, and then need something to tell the url to point to IncidentReportxxx.xml, where xxx is the database's Incident Number field. I am very new to coding, I'm working in ASP, language VB, using Visual Studio 2008.
I have the following gridview (ID=Gridview1)
I have added pid (primary key), chkblood,chkurine,chkstool,chkmalaria as datakeynames.
what I want to pull off here is .... when I click select I'll be redirected to this wizard
[Code]....
I did that....now I want to hide / skip steps in the wizard depending on the condition of checkboxes (chkblood, chkurine,chkstool,chkmalaria)
but I cant get the value from these non-primary datakeynames...
My current project has many peripheral systems and many different environments (testing, integration, development etc). As expected, we're using .config files to dynamically manage everything.
Instead of updating each relavant key when deploying to an environment, I was hoping there was a way to change 1 key only. Such as:
<add key="Environment" value="Development"/>
<add key="WebServiceLocation" value="http://<<Environment>>/text.asmx"/>
I've done some searching and haven't come up with an elegant solution. I'm aware that .config files can make use of system variables, but this seems like a bit of a high wire act.
I have a wcf service and method returns a string array as follows
[Code]....
How can I pass required multiple parametes (name, cuo, year ) to this service using ajax AutoCompleteExtender.
If I could not use autocopleteExtender what would be the best way to achieve this.
i get the following exception (missing primary key) in the line of using Find() method "Table doesn't have a primary key." I've rechecked the Database and all Primary Key columns are set correctly.
DataTable dt = p.GetAllPhotos(int.Parse(Id));
DataTable temp = new DataTable();
temp = dt.Clone();
temp = (DataTable)(Session["currentImage"]);
DataTable dtvalid = new DataTable();
dtvalid = dt.Clone();
DataRow[] drr = new DataRow[1];
drr[0] = dt.Rows.Find((int.Parse(temp.Rows[0]["photoId"].ToString()))+1);
foreach (DataRow dr in drr)
{
dtvalid.ImportRow(dr);
}
dtvalid.AcceptChanges();'
In the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
View 6 RepliesI am working on lazy loading page the problem is
when i bind first time page (10) records then primary properly bind with records and when my next 10 records load using lazy loading then the primary key not change it shows 1st records primary key
check the below code in which i am assigning assetid (primary key) but its not assigning properly...
function OnSuccess(response) {
//alert('testing');
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
pageCount = parseInt(xml.find("PageCount").eq(0).find("PageCount").text());
var customers = xml.find("AssetSummary");
[Code].....
I have a "database explorer" page that is desgined to be pointed to an unknown database and allow users to browse the data, so it basically uses the SQL system tables to develop its queries and pull in data to tables using auto-generate columns.The problem that I have is that I would like certain types of columns to have certain formats and I'm wondering the best way to go about it. I could format the column in code in the RowDataBound event I assume, but I'm wondering if there some better standard way to do this? Is there a setting of any kind that I can use? For example I want all of the datetime fields to be formated for short date, like {0:d}, I want decimal fields to have 4 decimal places, etc.
View 2 RepliesI have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.
What I want is to be able to reset this database with my default values (table data) every n hours.
So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.
I want this task to be done every day at 12 pm or every n hour.
Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).
I have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details
railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously
I'm trying to implement automatic lockout after 3 password failure attempts and then to auto unlock after 3 mins. But it does not auto lockout, I can still login if i use the correct password within the 3 mins.
Here is the Web.Config file
[Code]....
Here is the Login Control Logic.
[Code]....
is it possible to change my debuging kyes instead of function keys..
because am using the laptop and always i have to press "fn" key to prss the f10 or f11
is there any solution ..or can i permanantly press the fn click event ?