I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
How to handle this error
"An explicit value for the identity column in table 'UserActivation' can only be specified when a column list is used and IDENTITY_INSERT is ON."
I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.
So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.
However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.
And there's this Iqueryable interface that further confuses me...
Here's my function to get the Applicants only:
[Code]....
Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this
[Code]....
and then in the function I have no idea how to pass the values:
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
i have a table which showing the food data from my Model, including Name, Amount, Storage and Expiry Date. I wish to either:
1. Let user click on the column header and sort the column they want
2. Or default showing the food which almost expired on the top of the table
i have 3 tables which are Table A(a Id,b Id),
Table B(b Id,a Id,c Id),
Table C(c Id,b Id)
How can i select Table C column by using table A?
I want to create a temporary table where the columns of that temporary table needs to be dynamic (those columns needs to come from the rows of another table)
View 6 RepliesI have created a web project using asp.net and visual web developer 2008. On my local project I created a new column in one of my MS SQL data tables and populated it with data. How would I create a sql script of the new column and data? I want to insert this into my live database on Godaddy?
View 1 RepliesI am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
using Microsoft.Data.Schema.ScriptDom.Sql;
using Microsoft.Data.Schema.ScriptDom;
By using these namespaces or assembiles , i need to get
1. Params (Name, Length, and Type)
2. Clause Name (SELECT, FROM, WHERE, GROUPBY, HAVING,X-JOIN, etc)
3. Column Name
4. Table Name
5. Column Schema
using Microsoft.Data.Schema.ScriptDom.Sql;
I have a number of tables in the database and i have a column value as "abc" coming from one of the tables in the database, Now i need to find the table name from where this column value is coming?
View 8 Replieshow to access the first row and first column of a sql table
View 6 RepliesHow can I develop a table that has a UTC Column that increments. For history I will have to add rows, how can I go about doing that and then anything in future, I want it to keep increasing.
View 1 RepliesIs there a way to add a new column to the asp.net cache change notification (AspNet_SqlCacheTablesForChangeNotification)?
I wish I could do it so that generated trigger involve the new column. The minimum PollTime is 5 seconds (500 milliseconds) but this is not enough for us.
We have many customers working on the application and some times, some of them get logged out during operations.
We found that the problems come from the cache table (cacheId column).
Im using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'
when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?
[Code].....
I want to set the coulms size of all the columns in the table in the DB based on the maximum width/size of one of those columns of that particular table That is if I have three columns Name(nvarchar 50), Address(nvarchar 70) and Description(nvarchar 100), then I want Name and Address to also be nvarchar 100, can anyone give me the code for the same in VB.
View 1 RepliesHow can i select all columns of table but to distinct by one column? i am tryin to figure it out without success, i know how to make distinct (select distinct column from table, but i need all the values from the table and to distinct by Delcompany.
my line is:
[Code]....
I want to select the list of messagetext from the messages table where the message text contains any of the Carriage Return Characters?? (Eg: /r/n) what are the other Carriage Returns characters and how can i filter those from the message text?
View 8 Repliesis it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc? if so, how?
View 3 RepliesMy View has four columns with years, none of the rows have complete yearly data.
Current View
Columns 1-10, FY, Expr1, Expr2, Expr3
Some data, 2010 NULL,NULL, NULL
Some data, NULL, 2010, NULL, NULL
Some data, NULL, NULL, 2010, NULL
Some data, NULL, 2010, 2010, 2010
Some data, 2010, NULL, 2010, 2010,
Some data, NULL, NULL, 2010, NULL
Some data, 2010, 2010, NULL, 2010
Some data, NULL, NULL, NULL, 2010
A new column needs to relfect 2010 for each row in the View.
Goal New View
Columns 1-10, FY_NEW
Some data, 2010
Some data, 2010
Some data, 2010, etc. for each row in the view
I can not hard code the data as time moves forward next year rows will have 2012, etc.
How can I get lthe year, in this case 2010, into a new column regardless of the year?
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesI have tables:
MAILBOX
MailboxId int PK
MailboxTypeId int FK
MAILBOXTYPES
MailboxTypeId int PK
I can't make relationship between MailboxTypeId in table MAILBOXTYPES and MailboxTypeId in table MAILBOX why ?
I added a DateTime column to a table in my database through the Server Explorer. Because the team lead for this project wasn't savvy on nullable types, one of the requirements was that there be no null values in the database. This requires me to program all sorts of useless code into the system, but that's another story. My problem arises when assigning a default value to this column. I typed the following into the cell for the "Default Value or Binding":
1/1/1753 12:00:00 AM
When I went to inspect the content of the table, I found that all of the dates had been populated with:
1/1/1900 12:00:00 AM
i have a data table which is filled from data base, now i want to add new colum with name "Actions" and i want to add value for this column "Split". how can i do this.
View 2 RepliesI cannot add a new column in existing table.
I have a two tables ['ev_event_how' & 'ev_events_event_how'] has relationship between these table.
Ex:
Table: 'ev_event_how'
UID - Event[PK]
Ex:
Table: 'ev_events_event_how'
UID - Event[FK] - Desc
I want to add a one more column[IsDelete] in both table. But Sql server is not allowing to add the new column, Showing various errors like
1.cannot add a new column-Unable to modify table.Invalid object name 'MSED_Logs.DatabaseLog'
2.TITLE: Microsoft SQL Server Management Studio
User canceled out of save dialog (MS Visual Database Tools)
How can I make it add a new column in existing table?