I have Data table Populated from database with Column Month which contains values .
and i have an other Array list which contains the Months from 1 to 12.
Now i have to insert the missing months into Data table from Arraylist.
how i do that because i have to shown the 12 months on report .
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].....
Is there a quick way to query a database table in c# and push all the results into an arrayList?
View 3 Replieshaving trouble only adding the checkboxstatus's that are checked to the gridview.
Protected Sub atasks_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim tasknamelist As New List(Of Boolean)
For Each row As GridViewRow In GridView1.Rows
' Selects the text from the TextBox
Dim checkboxstatus As CheckBox = CType(row.FindControl("tasknamebox"), CheckBox)
tasknamelist.Add(checkboxstatus.Checked) [code]....
How do you go about removing multiple items from a array list?
I'm using the RemoveAt() method to remove but doing that resets the ArrayList's index which cause me problems if the user selects to remove 1 & 3 out of a 3 list array since once it removes 0 the array list now just has 0 & 1.
ArrayList list = acontroller.ListForDisplay(articleModule.expireDate);
How can I get the "list" only display 10 items?
I don't want to set the number to display with stored procedure.
I've got another unrelated question, - from performance perspective, is it more efficient to sort data in stored procedure than sort using "icomparable" after I got a list of data into an arraylist? (30,000 record to sort.
i want to show the arrayliust items in the listbox, for that i had stored some data in array list, and now i want that if i gv any id which is in the array list its corresponding details are displayed in listbox. I had two fields ID, Name, and when i give id its corresponding name should be shown in list box.
View 3 RepliesI need to create a public bool that checks a string for items in an arraylist.
Here is a vague sample of what I'm talking about..
[Code]....
I'm not experienced enough with the foreach statement to quite figure out what I'm doing wrong here.
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 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]....
loop table depending on arraylist and load datagrid?
View 1 Repliesi want to create a arraylist which will able to store user info like (username,machineIP,port ) for each user in the list & retrive this data when needed . any one tell me how i can do it or any alternative way without database or xml file.
View 6 RepliesI'm trying to remove the first 5 or "a predefined number" of items from my Arraylist. I tried the following but I noticed It removed index 1,3,5 because the each time an item is removed, the index 1 will become 0. remove the index 0 a number of times?
for (int i = 0; i < numberToSkip; i++)
{ newList.Remove(newList[i]); }
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 am using C# , ASP .NET 2.0 and i have to avoid the datagrid view items from being wrapped.
View 4 RepliesI have a grid containing images loaded from database. the images are displayed in the order as they are stored in the database. Is there any way to change the order of the images manually once after they are uploaded to the database.. the admin before publishing the images to front end, should be able to arrange the images as he/she wish and then finally stores them in database.
View 5 Repliesi build some shopping cart. I have Datalist that display products from SQL table (id, productName, productPrice) and "Add" button. After the user click the button the product appear in the GridView (im using Session DataTable) until now all fine and work greate! in every product i need to add 2 checkboxlist from SQL tables (its some extra to the product). How can i get the items the user was checked and put them with the product name in the same datatable coloumn? the aspx code:
[Code]....
this is the code behaind:
[Code]....
in my button4 click event, i want to insert checboxlist items to data table. first i want to delete all of the exisiting and then insert again.
my code is below but it is not working if you could explain anyone ?
in page load I have written code so that existing checkbox items are selected.
[code]...
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 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 have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
<asp:TemplateField HeaderText="Debug">
<ItemTemplate>
<asp:DropDownList ID="grdDebug" runat="server" AutoPostBack="false" SelectedValue='<%# Bind("Debug") %>'>
[code]...
I 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 have created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
I've got a gridview that is databound with LINQ in the code behind. One column shows the id from the table. I would like to show a more human friendly product name that is associated with that id number but is from another table. Thought I had it figured out by entering a Template field in the gridview tags (in the .aspx page) and an item template within that with
<ItemTemplate>
<%Eval(Products.productName")%></ItemTemplate>
but when I try to build it says this can only be done in the context of a databound control.
Can I add this column within the gridview tags or does it have to be done from the code behind?