I have one problem with my shopping cart that I really can't figure out all by myself.I want, if a item already exist in the datatable, the quantity to be updated for that item with the new number instead of creating the same item again.I have done a foreach loop because I think that is where I should start.Notes: MyRow[3] is the column holding the quantity.Code:
I am using Compute for summing up a datatable which has a condition. Sometimes, there are no rows inside the datatable matching my criteria so I get an exception on ComputeObject cannot be cast from DBNull to other types.Is there a way to check/filter the datatable to see if it has the desired rows, if yes only then I apply Compute.
total = Convert.ToDecimal(CompTab.Compute("SUM(Share)", "IsRep=0"));
I need your help / guidence for doing custom paging in c#, through sqlserver. so that i can have data in dataset/datatable according to the pagesize given, not all the data in dataset. some code /url .......with full discrption if possible.
I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).
What is the best and fast way to do it?
I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?
I'm also looking for example in code how to select/delete rows from DataTable.
MembershipUser m_user = Membership.GetUser(); DataTable dt = new DataTable(); dt.Columns.Add("SenderUser"); dt.Columns.Add("RcvUser"); dt.Columns.Add("Message"); foreach (ListItem li in lst_Users.Items) {
[Code] ....
I am calling "Application object" from above aspx page into web service page as below:
[WebMethod(EnableSession = true)] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public string WebMessage() { List<string> list = new List<string>(); DataTable dt = ((DataTable)HttpContext.Current.Application["Message"]);
[Code] ....
I want to know that the approach im using in Web service page to fetch top 5 messages from Datatable is correct or not? How to do that without using LINQ as I am using framework 2.0 ...
I am working a project, it requires me to select everything from a table, one of the fields contains dates. I have to take each take and add negative 6 months if the result equates to today's date then i add that row in the dataset to a listview else i remove that row from the dataset.
The problem i am having is removing the entire row from the dataset before binding it to the listview.
I have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).
ASPX CODE
[Code].... C#
When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it
I have 7 different category pages and although the Cart Page shows selected items From the 1 category , when i select other category page it only shows the selections of first page and not the others. How can i make the DataTable Draw values from all the pages and display them on the Cart? code in first category
[Code]....
i m trying to put the same in each category but it doesn'twork
I want to Get multiple selected column from datatable using c#. Below I have added data of datatable and I want red marked rows from datatable. Green marked text is column name of datatable.
Parameter Value GetTempFilenameResult 0 tempFilename 0 data 0 fid 0 useid 0 filename 0 tempFilename 0 userName 1 pwd 1 LoginResult 1 useid 2 usename 2 address 2 mobileno 2 emailid 2 organization 2 city 2 country 2 password 2
i am using vb.net 2008 i need to know about datagridview ......Is it to possible to add a data through vbcode in datagridview without using any datatable or dataset....
I'm using a table adapter to perform my queries. I'm sure I'm missing something really easy, but I can't figure out how to return the number of rows returned from a query to a dataset used for a GridView.Basically, I want to display a message "No records exist for your selection" by testing for ReturnedRows = 0.
Excerpt of C# code:
handoutDSTableAdapters.handoutTableAdapter handoutsAdapter = new handoutDSTableAdapters.handoutTableAdapter(); gv_Handout.DataSource = handoutsAdapter.GetDataByDoctor(Int32.Parse(ddl_MD.SelectedValue)); gv_Handout.DataBind();
I have a following scenario - A use selects criterias from a webform (C#) - a result is then returned from the sql. Say, to start, there are 2000 data returned from the sql and are stored in a dataset.
Now, the user wants to choose a number of drops (up to 6) - with the number of drops selected, they can enter their own quantity in each box. So, they can divide the 2000 records into 6 different drops. With each drop, there is campaigncode created based on the mail date and the job number they provide.
So, now i have the 2000 records in a dataset. What i want to do is loop through the gridview where the user fill out the quantity depending on the number of drops (for ex: if they say 3 drops, then there will be 3 rows in gridview with 3 quantity box to fill).
In the loop, I am getting the quantity, dropdate and the job number. The Campaigncode is created as well. Then, i am looping through the datarow in the dataset; updating the Campaign Code column with the CampaignCode for the number of records thats set in a loop. It works but the Campaign Code is not populated for the next set of records.
Here is the code:
[Code]....
I think its this line right here thats causing the problem. But i don't know how to tweak this so as to accomplish what i want to do.
if (Convert.IsDBNull(DSAEFile.Tables[0].Rows[i]["Campaign Code"]))
I am trying to delete row(s) from the DataTable conditionally but I cant.
Actually I have DataList with CheckBox (default value checked=false). I am bindind DataList at run time using DataView (Dataview is created fromDataTable).
I also have <asp:Button ID="btnDelete" ....> which I am using to delete checked items in the DataList (But this functionality is not working).
The user first "checked" items in the DataList and click the the button "btnDelete". Here nothing is being deleted (?) and the DataList appears with all the items"unchecked" (even those which the the "checked" by the user). protected void btnDelete_Click(object sender, EventArgs e) . In this function I am checking state of the checkbox before deleting the row in the DataTable.
On PostBack generated by the "btnDelete", DataList appears with checkboxes unchecked therefore nothing is being deleted
i could bind the data form tables to dropdownlist in asp .net using linq.
ex: var res=from n in dc. contacts where n.location==Hyd select new{n.Id,n.Name}; var res1=from n in dc. Morecontacts where n.location==Hyd select new{n.Id,n.Name}; dropdown1.Datasouce=res; dropdown1.DataTextField="Name"; dropdown1.DataValueField="Id";
