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:
[Code]....
//Bengt
I have created a datatable with three fields namely TimeTask, TaskItem and Count (count of user) eg; {"12:30AM-01:00AM" , T1 , 3}.
dataTable.Columns.Add("Task Time", typeof(string));
dataTable.Columns.Add("Task", typeof(string));
dataTable.Columns.Add("Count", typeof(int));
dataTable.Rows.Add("12:00AM-12:15AM", "T1", 6);
dataTable.Rows.Add("12:45AM-01:00AM", "T1", 5);
dataTable.Rows.Add("01:00AM-01:15AM", "T1", 1);
dataTable.Rows.Add("01:15AM-01:30AM", "T2", 4);
dataTable.Rows.Add("01:30AM-01:45AM", "T2", 9);
GridView1.DataSource = dataTable;
GridView1.DataBind();
In this there is no task for the TimeTask "12:15AM-12:30AM" and "12:30AM-12:45AM" yet the TimeTask should be inserted as,
TimeTask TaskItem Count
12:00AM-12:15AM T1 6
12:15AM-12:30AM - -
12:30AM-12:45AM - -
12:45AM-01:00AM T1 5
01:00AM-01:15AM T1 1
01:15AM-01:30AM T2 4
01:30AM-01:45AM T2 9
How to chk for the missing rows? Is it possible to dynamically insert rows in an existing DataTable (No DataSource used) in this scenario.
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.
DataSet ds = new DataSet();
string qry = "select Name,Section,present from presentdays where id='" + TextBox1.Text;
qry += "'";
ds=mvl.GETDS(qry);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TextBox2.Text = dr["present"].ToString();
TextBox12.Text=dr["Name"].ToString();
TextBox13.Text=dr["Section"].ToString();
}
there is no data in id='1'i need to throw the error as there is nothing is found in id='1'
if (dt.Rows[i]["Code"] == code)
{
Label lblLang = (Label)(((e.Item as GridItem).FindControl("lblLang") as Label));
lblLang.Visible = true;
}
else
{
}
}
I am adding a new language Fr-FR in the code above. fr-FR already exists in my DB's Language Table. I do not want to add duplicate values in my table. There should be only one fr-FR.
I have a dataset that has around 5 rows. I also have another Datarow() array that has an additional 3 rows which I would want to add to the dataset. The structure of both the Dataset Rows and the Datarow arrays are the same.
Do I have to perform a loop on the datatrow arrays and add them one by one? or is there a better way of adding them in one go ?
To Add new row to a dataset table, I am using code below. Before adding this how do I check if that row has already been added to the dataset?
Example:
Dim newCustomersRow As DataRow = DataSet1.Tables("Customers").NewRow()
newCustomersRow("CustomerID") = "ALFKI"
newCustomersRow("CompanyName") = "Alfreds Futterkiste"
DataSet1.Tables("Customers").Rows.Add(newCustomersRow)
Note: The table I am dealing with does not contain a primary key!
I am trying to use a stored procedure to insert new records from aspx page. I have created an stored procedure for that and it works fine but I want to display an error message when record exist. It does not display any error message however it does not insert when record exist. How can I display an error message when record exist flag in stored procedure -
[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"));
iam working with gridview in asp.net3.5,Sqlserver2008 I am retrieving data from a SP into a datatable.i need to store this table into gridview. but am getting the last row from my datatable into my gridview.
here i need to add each row to the datatable.
my grid is like this:
[Code]....
I get the usual system.outofmemoryexception with the code below.
Is there a way to do this in small chunks?
public static void Serialize(DataTable dt, string filename)
{
FileStream fs = new FileStream(filename, FileMode.Create);
BinaryFormatter bf = new BinaryFormatter();
try
{
bf.Serialize(fs, dt);
fs.Close();
}
catch (Exception)
{
fs.Close();
fs.Dispose();
File.Delete(filename);
}
}
I am using untyped database bind to gridview in an edit form. Now user makes some changes to that datatable (update, delete, insert). How do I detect which rows he changes and which rows he deleted (so I drop them from DB). I know it can be done easily via table adapters but I am supporting a previously built app using untyped datatables/datasets.
View 9 RepliesI'm trying to add new rows to a data table and then use the sqldataadapter update method bu fund some problems. First, I written this code:
[Code]....
Excuse me but the most part of variable are in italian, however I think it is possible to understand how does it work. If I execute this code I obtain this error:
System.InvalidOperationException: Update requires a valid InsertCommand when passed DataRow collection with new rows.
After this I added these lines of code just above the last line:
SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
adapter.InsertCommand = cb.GetInsertCommand;
and I obtained this error:
Cannot convert method group 'GetInsertCommand' to non-delegate type 'System.Data.SqlClient.SqlCommand'. Did you intend to invoke the method?
Maybe this could be a simple questino, but for me it's difficult to do this action: I have a table in sql server 2005 with some records stored, for example 10 records. The primary key of this table, let's call it "Employee", it's a number field with an autoincrement constraint. I want to store more data into the table by using a OdbcDataTable object and OdbcDataAdapter and adding new rows to the datatable and afeter that use the "Update" method from the OdbcDataAdapter object.
The big deal is this: let's suppose that I want a add a new record to the datatable object, using any method or code sequence that you want. if I have 10 records stored on the data base table, when I retrieve this table schema by using the OdbcDataAdapter "Fill" method, I have a copy of the data base table schema in the DataTable object, right?. if I add a new row on the datatable object, it's suppose that the primary key column of that table must AUTO-INCREMENT the value of the key, I mean if the last value that I store on the table was the number 10 on the PK field, when I add a new row on the datatable object, the PK value on the datatable object must be the number 11 if the autoincrement constraint is present into the DataTable object, but in my case, it doesn't work
So, How can I define the conditions or set the c# data objects properties to wor in that way???. In this moment the PK column on the odbcDataTable doesn't auto-increment its value when I add a new row on it.
Please helpe with this.
PD: I have another question about the DataTable object, how many records can store this object?? I have some problems with this because sometimes when I use the Fill() method to get data into the DataTable or a DataSet object there's no problem if the Fill() method retrieves about 142000 records, but when I retrieve over the 145000 records, when I inspect the DataSet or DataTable object by using the debuging mode, they have null value. Any of you can tell me why this situation ocurrs??
Existing records can be updatedNew records can be insertedAll existing records can be deleted & new ones can be insertedExisting records have a primary key field
New ones are just blank inserts
All this detail is stored in a data table. On form update I only want to update existing (only modified rows) & insert new rows. I have gone about loading the changed records in a new data table
DataTable changedRecordsTable = dataTable_old.GetChanges();
How do I compare it with all the records in the old datatable and pass them to the save query ?
I have a list item collection. How to add this list item collection to a datatable.
The list item collection has the following fields:
Student Name, Maths Mark
John 20
Mac 30
John 35
I want to create a html table from the data table, which is grouped on the Student Name field.
my requirement is to update a duplicate record in datatable.in my website if anyone select a product more than one time then i have to check and update the quantity of that record.i use for loop for this but it is not working properly, it is running perfectly for one product but when i add another product it won't work.how can i do this?Here is my code part which is run on add button click
if (sc.dtcart.Rows.Count > 0)
{
for(int i=0;i<sc.dtcart.Rows.Count;i++)
[code]...
If I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 RepliesI want to delete the rows present in the DataTable by using LINQ (with out looping)
The deleted rows will be come from a LINQ as below
IEnumerable<DataRow> MobileQuery = (from d in dtBillDetail.AsEnumerable()
where (String.Compare(d.Field<string>("Destination"), "MOBILE", StringComparison.InvariantCultureIgnoreCase) == 0) select d );
The DataRows present in the "MobileQuery" should be deleted in the DataTable "dtBillDetail"
I am having a problem. I need to check to see if a row has been displayed once, and if so don't display it again. I have the following code:
[Code]....
This all works perfectly, but displays the body row repeatedly. So i need to add a counter or something to check this and make sure it is only displayed once..
I tried with DISTINCT in the sql but that didn't work, so i think it may be better doing it through iteration? Can this be done?
I have been handling everything in code which is not working consistently same in all scenarios.
View 1 RepliesI use a ItemDataBound for a repeater.But i use 2 kinds of linq querys to bind it.Some of them has a MerkID, and some doesnt have this item.So its easy i need to do this:
if(e.Item.DataItem.Contains("MerkID"))
{
//Code for linq query 1
} [code]...
So of course the if selection doesnt work, but how can i do that? I already tryed this:
DataRowView drv = (DataRowView)e.Item.DataItem; if (drv.Row.Table.Columns.Contains("MerkID"))
But that doenst work because he cant convert it to a datarowview because its a linq class.So what to do? Right now i use a try and catch, but there are better solutions i guess...
I have a DataTable which having some rows which bind from database. I would like to add some new rows to that datatable.
I used the following code.
conn.Open();
SqlCommand cmdDownload = conn.CreateCommand();
cmdDownload.CommandType = CommandType.Text;
cmdDownload.CommandText = "select SKUCode,'Image Available' as [Status] "
+ "from tblName"
[Code]...
But the new rows are not adding to the datatable.
Below is a beginning attempt to increment through a DataTable populated by a Stored Procedure and create a new DataTable where every Category is represented by exactly four products. I need to add dummy product entries for some and skip over those with over four products.
A) - I think I understand the basics but this builing from scratch is not my practice.
1) I do not know how to query a previous row in reference DataTable.
2) I do not know how to jump to next row from IF construct.
3) I hope I am able to build a DataTable row by row.
4) Partial sample data is at bottom of pseudo code
[Code]....
i have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 Replies