C# - Creating A List Of Checkboxes Using MVC For A Table Without A Primary Key?

Mar 14, 2011

I have a table that get populated via an external text file. I am not sure of the exact process as I'm relatively new to the company.

The table does not have a primary key as the entire table is dumped and re-loaded every quarter when there is a new text file.

Enter ASP.NET MVC. I need to display that table with checkboxes in a grid so the user can select some rows and send it back to the server. It sounds relatively easy, but I am really not sure what to put as the value for the checkboxes as I am pretty sure I'll need to use multiple columns to create a unique. Yep, I know, I know :).

OldTable
- Field1
- Field2
- Field3
...
- FieldN

The View

...
<input type="checkbox"
name="bunchOfStuff"
value"Field1Value,Field2Value,Field3Value"/>
...

Would something like this work? If I can create a key with a few fields, can I use those fields as the value in the checkbox? I realize my action will be a bit ugly as I'll have to split and parse each value in the array of values.

View 3 Replies


Similar Messages:

C# - Exception (missing Primary Key) In The Line Of Using Find() Method "Table Doesn't Have A Primary Key"

Aug 25, 2010

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();'

View 1 Replies

Forms Data Controls :: Creating Dynamic Rows In A Table From List?

Sep 7, 2010

am creating dynamic rows in a table from List<Productos> but this list have repeats same objects depending of quantity for one product.

[Code]....

I like that the products are not repeated but instead that show the quantity in a label.

View 2 Replies

SQL Server :: Creating Foreign Key And Primary Key?

Dec 7, 2010

I am new to sql. I got this task to design a table in sql. It has for columns user_ID(PK, FK1) , WebSite_ID (PK, FK2), Create_Dt, Update_Dt How do I create PK and Fk1 and PK FK2 in sql server 2008 R2

View 3 Replies

SQL Server :: Creating Sequence As Primary Key?

Aug 29, 2010

I need to have a running number of 12 digits to be acted as ref number.

it needs to be increment by 10.

May I know how can I do that?

Eg:

Record 1 000000000001

Record 2 0000000000010

View 4 Replies

DataSource Controls :: How To Use Primary Key Table And Foreign Table

Jan 1, 2010

How i use primary key table & foreign key table data for retriving the data with each other.I had make both table i confuse how to use it.

View 1 Replies

SQL Server :: Creating Store Procedure - How To Insert The Primary Key From The Product_Table Into The foreign Key

Aug 28, 2010

I have two tables. Product_Table with ProductID as the primary key. My other table, ProductSKU_Table which has SKU as the primary key and ProductID as the foreign key. I am trying to create a store procedure to insert into both tables. How do I insert the primary key from the Product_Table into the foreign key of the ProductSKU_Table? This is what I have so far:

[Code]....

View 15 Replies

ADO.NET :: How To Map A Table Without Having Primary Key In NHibernate

Oct 20, 2010

How can we map a table without having primary key in nHibernate.I have a table which does not contain any primary key, so how can i map this table in .hbm.xml file.

View 1 Replies

SQL Server :: Get Primary Key Value From The Table?

Oct 26, 2010

I am inserting data into two tables on a button click.

I need to insert the primary key generated for Table A into the Table B as a foreign key.

How do i get the primary key value and insert into Table B?

View 10 Replies

ADO.NET :: Using Table With No Primary Key In CTP4?

Aug 25, 2010

Does anyone knows if CTP 4.0 supports table with no primary key. I know Entity framework does.

View 3 Replies

SQL Server :: Duplicating Row Of Table (with Primary Key)

Mar 24, 2011

I need to copy the records of a row to the next available row in the same table. I tried with "Insert ...Select " but it throws me a error since the pk is auto-increment. Also, i cant specify each and every column inside the insert...select statment cause i've almost 30 columns.

View 5 Replies

SQL Server :: Dropping Primary Key On A Table?

Mar 29, 2011

I am working on a database with about twenty tables. In one of the tables "Customers" their is a column with

a primary key. Call it "CustomerNumber".

The problem is that we log customers from multiple vendors and so we might have the same customer number, but from different vendors. So really this would be a perfect situation where we could set up the primary key to be a composite key consisting of the Vendor and CustomerNumber combination.

The integrity of the database is not very well maintained because the Primary Key CustomerId is never used as a secondary key in any of the other tables.

So here is my question. Instead of making a primary composite key, can I just drop the primary key all together?

This is one of those questions I really hate to ask, because typically I would never lean tword this drastic of a measure to solve a problem. Because of other situations I can't discuss this might be the best alternative. So would it be okay to drop the primary key constraint all together?

View 1 Replies

MVC :: Composite Primary Key + Editing Of A Table?

Feb 1, 2011

I have a table with composite primary key and this key includes two values referring to two other tables. Now I need to implement Edit feature for this Original Table but I wanted to have dropdown lists while editing pointing to look up tables(composite key values are primary keys for two lookup tables). for eg.

Table1(table1_primarykey, table1_field1)

Table2(table2_primarykey, table2_field1)

Table3( table1_primarykey,table2_primarykey, table3_field1) - composite primary key

while editing I wanted to display table1_field1, table2_field1 instead of original primary keys as numbers in Dropdowns.

View 4 Replies

VS 2010 - How To Set Primary Key In New MySQL Table

Jun 20, 2012

I have a data connection to an existing MySQL database. The database has various tables. I am creating a new table, and want to set the ID field to be the primary key. I can not see a way of doing this inside Visual Studio. I saw one suggestion to right click on my ID field in either the Server Explorer or XSD and select Set As Primary Key (or something like that), but I don't have that option displayed.

View 4 Replies

DataSource Controls :: Make A Three Primary Key In One Table?

Jan 3, 2010

i have to make a three primary key in one table

View 2 Replies

List Of Checkboxes Each With Associated Textbox?

Mar 4, 2011

I'm trying to build a list of checkboxes, each one with a textbox/textarea associated to it. The plan is for it to look something like this

[checkbox]
[textbox]

[checkbox]
[textbox]

[checkbox]
[textbox]

The title of each checkbox & textbox will be populated from the database. I'm not really sure how to go about doing this.

View 2 Replies

SQL Server :: How To Create Two Primary Key In A Table Using Sql Query And Manually

Feb 18, 2011

How to create two primary key in a table using sql query and manually?

View 3 Replies

Web Forms :: CallBack Eventhandler With Primary As Dropdown List And Secondary As Radio?

Jan 8, 2011

I was trying to get the callback eventhandler work for me with Dropdown and either of the radio(s). I know the sample of this in asp.net 2.0 where both the contorls are dropdownlists. Please help me to know is it possible?

View 2 Replies

List Of Grouped (nested) Checkboxes?

Mar 11, 2011

I want to create List of Grouped Checkboxes as follows:

[]Group1
[] Item1
[] Item2
[]Group2
[]Item1
[]Item2
[]Item3

Here Group# and item# are checkboxes. Does anyone know how to do this in asp.net. I am getting data from DataSet. One limitation is that I am not allowed to use third party tool/controls or jQuery.

View 1 Replies

SQL Server :: Stored Procedure Is Not Passing In A Primary Key Into A Foriegn Key In Another Table?

Jul 14, 2010

I am a rookie developer here and I have tried looking around for an answer but I am little confused. I have a stored procedure that calls multiple stored procedures when I go to create a new contact.[Code]....

I though I could use the OUTPUT Command to copy out the NewContactID but I am getting all kinds of syntax errors. I am confused as to what I am missing here.

View 3 Replies

SQL Server :: How To Auto Increment Alphanumeric Primary Key In Database Table

Sep 30, 2010

auto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.

View 2 Replies

DataSource Controls :: Attribute To Be The Foreign Key Which Is Not A Primary Key In The Original Table?

Jul 2, 2010

attribute to be the foriegn key which is not a primary key in the original table?

View 1 Replies

How To Insert The Value That Is Not In Textbox Into Database Which Is Primary Key For Table Without Identity Column

Dec 21, 2010

i have created a web form, where i have 3 textboxes into a table and one submit button.

i would like to store values from the textboxes into my database (sql server) when i click the submit button.

but how to insert the value that is not in textbox into database which is primary key for table without identity column.

View 11 Replies

SQL Server :: How To Change Database Table Primary Key DataType From Integer

Mar 7, 2011

There is one table which primary key is ID and its data type is Integer with auto increment. Gradually the value has increased and I want to change it to hold large amount of value.

So, Which in data type I have to change from Integer without effecting the previous values?

View 2 Replies

MVC :: Handling Primary Key Field When Creating An Edit View (using Add View Dialog)?

Apr 7, 2010

When using the "add view" dialog in vwd is there a common practice for presenting any primary key fields as readonly to the user in the view?

By default it appears the user could change the key field value (as it is presented in a textbox) and overwrite data for that record for which the key was accidentally changed to.

Do we have to store the original record's key and then make the key presented as a label and then on the update subtitute the original key value back in for the record? Or is there something simpler?

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved