Adding A Column To Table Break .net App?
Feb 9, 2011
I've inherited an ASP.NET web app, and I am coming up to speed on being a DBA as well.Before I break anything, if I add a new column to a table, is there any chance it will break an existing page that does CRUD operations? The new column would not, of course, be part of the existing operations and grid controls, and if I allow it to contain a NULL (so inserts don't require value input), will I be OK?I realize that deleting a column could certainly break things. But adding a nullable column would seem to be harmless enough. (I think).
View 2 Replies
Similar Messages:
Jan 15, 2011
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 Replies
Dec 31, 2010
Is 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).
View 2 Replies
Nov 16, 2010
I am working on the user registration process which uses the asp.net membership provider. When users are registered with the application, the some of the user details(emailID, password, password salt, password question, answer etc) are stored in aspnet_Membership table.
We have a requirement of adding two additional columns in the same table for secondary password question and answer. I see that this table has a lot of dependencies with the membership stored procedures. Kindly let me know how some of the extra columns can be added to this table.
View 3 Replies
Jul 29, 2010
how can i put the value selected with a radiobutton in a datatable's column?
View 2 Replies
Apr 8, 2010
I am wondering what's the easiest way to go about doing this. I am using the user signup form control that comes with .net and they can create user through the application and once they do users see the "members area" of my site.
However, they are only trial members. using my paypal form, once they pay for service, they become a paid member.. so I want to keep track of this in the membership table by having a column in that table: bit registeredUser. Do I have to create my own overriden membership class for this, at first I thought there was already a column like this called isApproved, but seems thats for something else because if its set to false user cannot even login.
View 2 Replies
Jan 16, 2011
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].....
View 4 Replies
Feb 28, 2011
I might be just blind (very possible!) but i can't find any information on here/Google anywhere that me out at all :( First up, below is the code i'm using to send the email message:
MailMessage newMM = new MailMessage();
newMM.To.Add(new MailAddress(userEmail));
newMM.From = new MailAddress(getFrom, getFromName);
newMM.IsBodyHtml = true;
newMM.Subject = userSubject;
newMM.Body = userHTML;
if (chkEncoding.Checked)
{
newMM.BodyEncoding = System.Text.Encoding.UTF8;
newMM.SubjectEncoding = System.Text.Encoding.UTF8;
}
NetworkCredential basicAuthenticationInfo = new NetworkCredential(mUsername, mPassword);
SmtpClient smtp = new SmtpClient(mServer);
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.Credentials = basicAuthenticationInfo;
smtp.Send(newMM);
Which sends fine, and does UTF8 fine when enabled etc... however in the resulting email i get this (UTF8 or not):
MIME-Version: 1.0
From: "The name i want"
<fromname@fromdomain.com>
To: someone@atadomain.com
And this is from checking the files in MSSMTP Queue folder, so it seems to me its .NET adding the line break in or MSSMTP doing it when it receives the email.
[Code].....
View 2 Replies
Jul 15, 2010
I would like to know if someone can please help me with the followingI would like to create a bulk entering textbox...every sentence seperated by a line break should go in to the Database as a new column.....Im gonna use SqlDatasource for the inserting..How can I get all the sentences to break up at the linebreak and then get inserted in a separate database column?
View 3 Replies
Feb 25, 2016
[URL]
using above code i am able to print gridview directly without hidden fields.after added to hiddenfields to gridview , hiddenfield values are visible for printing.after i am using gridview.colums[i].visible=false column not visible while printingproblem is after print the gridview not visible whatever my columns set visible false.Example:at printing time i am set checkbox visible false, after printing i want reload same page with checkbox but check box not visible after printing gridview
View 1 Replies
Feb 2, 2011
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:
View 5 Replies
Mar 15, 2011
One of my apps is to document aircraft inspection at mil sites. The discrepancy report for any one tail number can be many pages long. The description of the discrepancy in a gridview cell can be several lines. Therefore when the gridview hits the bottom of the physical page, the print spooler frequently splits the gridview row leaving part on one page and the rest at the top of the following page. I have done my due-diligence in research before posting but maybe I'm using the wrong words. I found something on CodeProject but it is too complicated for me. Does anyone have a simple solution? I use C# and am not very sharp with Java script.
View 6 Replies
Jan 3, 2010
I am fairly new to ASP.Net and web programming in general and I am having issues trying to add values from a dropdown list in my gridview to another table.
Here is my scenario. I have 2 tables in my SQL Express DB. When editing the values of table2 in a gridview, I would like to show some data from table1 in a dropdown so users can select a value from table 1 and enter that value in table 2.
I have the Gridview setup to show table2 data.
I created a field template and inserted my dropdown list and linked it to my table1 data source.
When I run my web form, I can click to edit one of the fields in the gridview, and my dropdown list correctly displays the data from table 1, but when I try to update the table2 with the dropdown value, it doesn't correctly update. The row in table2 never updates.
posting the dropdown value from table 1 into the appropriate field in table2..
Again, I am new to this and have been following the tutorials etc on this site, but can't find one pertaining to this topic.
View 1 Replies
Jan 6, 2010
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?
View 2 Replies
Jan 24, 2016
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."
View 1 Replies
Mar 25, 2011
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
View 4 Replies
Oct 29, 2010
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
View 5 Replies
Dec 23, 2010
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
View 2 Replies
Aug 11, 2010
I 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]....
View 3 Replies
Mar 25, 2011
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?
View 2 Replies
Feb 10, 2011
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 Replies
Jun 21, 2010
How do you add an extra column in a datatable which will be used for another query
View 3 Replies
Dec 27, 2010
i have a sum column in my datatable and want to add the values?
is compute a good method to use?
View 1 Replies
Dec 10, 2010
Is there a way to format a column with an image?
View 3 Replies
Jun 1, 2010
I have a matrix report with a series of drugs across the top horizontally. I have series of diseases vertically down the report. In the detail, I have a percentage that is calculated. This all works. But I want to add a column that displays vertically down the page just to the right of the diseases and to the left of the first detail. This column will contain a count of all diseases. Not sure how this will appear on this forum but I will try to illustrate below:
Total Aspirin Penicillin Tylenol Cough Syrup
Flu 10 3 6 5 12
Cold 6 4 2 9 8
Pneumonia 11 2 5 15 6
Malaria 2 4 3 9 3
Presently, my report does not have the Total column. This is what I want to add to my matrix report. And this Total column has nothing to do with the other numbers in the detail. The Total column is the count of each disease. I have no idea how to do this on a matirx report.
View 1 Replies
