When I try to edit the Identity Specification from No to Yes there isn't a way to do so. No drop-down arrow or any way to edit the text. How can I change it so that I can actually change the value to 'Yes'?
View 2 Replies
In the tutorial I am doing I have been requested to change a field in the colums properties of a table. The ID column is currentl displaying NO and NO again for "is aIdentity. I can Highlight the values but cannot change to yes. either in the properties talbe or in the properties window on the right hand side of IDE interface. How do I change that value?
View 3 RepliesHow can I change Left and Top properties of Table control in a .rdlc file from code behind at Run-Time?
View 2 RepliesIf 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 RepliesI'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?
Can we change the table or column name of aspnet membership.If yes? then what will be the effects ?
View 1 RepliesI attempted to change a table columns data type and in the process caused a lot of issues. I had a date column in one of my tables and stupidly changed it from varchar to date. When I tried to run queries on it I keep getting the 'cant find column 3 error'. Now that tables structure is :
[Code]...
So column 4 is actually the date column. All other queries work for this table. I then tried to change it back and then copied all data to a new table and now I am using the new table and converting the dates as needed but I am still getting the error.
SELECT * FROM postlinks WHERE postlinks.date >= CONVERT(datetime,CONVERT(varchar(10),GetDate(),112))
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].....
according below thread
[URL]
I export xslx file from database from estate_p table in Estate_p table are below column
Id Name Behcode Estate
I want when it export these column into excel it change column name like below
Id CustomerName Code Estate
How I can do it?
I have a table with several columns i created,
How can i add a new column and specify its data type now? i using sql server and Gridview.
I tried to add one using GridView but it shows me columns called edit delete something is not like my bound fields i created early.
I have addded some different languages into database table column(NText), then im retrieving the data and display it on the Dropdownlist and Gridview but some of the languages(like Korea, Japan) displays as boxes.
View 12 Repliesi 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.
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.
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?
change the connection between data controls and database table?
View 2 RepliesI 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:
if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema. I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain
The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again.
Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.
I am planning to use grid view control, before was using datagrid, planning on switching to gridview:
<asp:TemplateField HeaderText="Deleted">
<ItemTemplate>
<asp:Image id=ImgDeleted runat="server" Height="13px" Width="21px" ImageUrl='<%# [code]...
I want to retrieve a single column from a table in a database(ms access) and then the value retrieved has to be converted to a string!!
View 4 RepliesI am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?
I have to add some columns which is not in the table and assign the values from code behind to that particular column
I have class Person, having two properties First Name and Last Name, if I set array of person as Data Source to GridView how can I show both First Name and Last Name in one column?/
View 2 RepliesI have a dgv with a column type = DataGridViewAutoFilterCheckBoxColumn. I want to know if there's a way to I can get that entire column to become disabled (or Enabled = False) so it won't let the user click on the checkboxes.
I tried looking in the "Bound Column Properties" but there isn't an option to disable the entire column.
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 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'm struggling once again to get something centered on a page, and fighting with recalcitrant browsers. I can fix the problem for one browser by adding a style. I can fix it for the other browser by NOT adding the style. I can determine which browser I'm using. If I can change the properties of a div in the code behind, I can create a class and apply it to the div as needed. I added an id to the class:
<div id="alignLV2" runat="server">
but in the code behind, alignLV2 doesn't seem to have a class property. Is there a way to add a class or change the style?
