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 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
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 RepliesBelow 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 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.
I have following issue: I have a datatable with a column which I would like to encrypt. This table has about 10.000 rows, and this particular column is storing 14 digit keys. Is there any way to encrypt all those keys in this particular column (just to make them useless if someone steals by db)?
View 6 RepliesI 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 need to add rows to an existing (maybe) datatable in a dataset that combines the IIS6 index search with my own sql table. I keep getting object reference errors.
[Code]....
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 ?
I have on my page a fileUpload control. -
<asp:FileUpload ID="FileUpload1" runat="server" />
and a save button.
When I browse and pick a file and press save the code works fine. However if I manually type rubbish into the fileupload and press save nothing happens.How can I get the save button to work so that I can check what is in the fileupload is a proper and existing file?
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 a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
i have two datatable, while adding rows in second datatable, i want to first check whether the id in the second datatable matches as in the first datatable, if not only then it should be added in the second datatable, else it should display a message...
i dont have any Primary Key defined on any column, so the rows could be repeatative.
Im using "string user = Database.GetMostRecentReply(id).Rows[0][2].ToString();" to get the username from the most recent reply in my forum.
But how do I check if the row is empty? Im using a try catch at the moment, but there must be a better way to do this.
I have Check Box list in Asp.Net, contains week days like as (Monday to Sunday)
I want to store the checked values as 1, non checked values as 0, as Binary format.
Say for example: 0000011 (Monday ,Tuesday selected)
[code]
how can i check distinct val in col_1 of datatable and assign seq no to each distinct val of col_1 to col_2?
View 6 RepliesI 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 have an image (consider the image of a clock). I would like to change the position of the dials depending on values retrieved from database. (This will probably be done using a service which will run every minute or so.) I just want to know how I can change the image (i.e modify the existing image).This is for a dashboard screen. The images would be refreshed every minute to get the latest data.
View 3 RepliesDataSet 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'
check if variable exists in dataset ?
View 1 Repliesmy 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]...
How to add new column to existing datatable which is inside dataset using C# .Net ....
View 1 RepliesHow to fetch data in gridview and add newly added item column in same column? As I know fetch data in gridview, my prob is add new data in new column in gridview.
View 1 RepliesI cant seem to figure out what is wrong with my check digit code!
At times, it produces 2 length check digit values
Example
1277531815000110 <-- check digit is double value??????
1277532495000110 <-- check digit is double value???????
1277534649000110 <-- check digit is double value???????
127753185300011 <-- good!
127753208500019 <-- good!
All generated numbers are valid, it can be checked at http://www.ee.unb.ca/cgi-bin/tervo/luhn.pl?N=127753224800013
CODE: http://tinyurl.com/352acpj
In my asp.net project currently i have business logic and and data access code in two sub folders(BLL,DAL) which are itself located web site project's app_code folder. I need to segregate them to two separate projects(one project for business layer and one project for Data access code).
How can I maintain connection strings necessary to Data access project which are currently in web.config file?(i.e if I choose Class library template for creating DAL and BLL projects) How can I maintain various other web.config key values that are currently used in BLL, DAL code files?How can I deploy compiled project? (ie Web site project I am currently deploying bin folder to Staging> production but this way where should i put DAL.dll and BLL.dll and relevant config files)