Have an objectdatasource that I need to iterate through and tally up values in certain catagories how would I do this.In short I need to grab each row check specific fields then increment counters I startted off below trying to use IEnumerable.is this the correct start?
View 4 RepliesI 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've got a datatable in a dataset which contains 44 rows. I can iterate through the rows and add the data to a placeholder - it's all there. However, if I bind a control (say a gridview or dropdownlist) to the datatable, all I get is one record (from the "middle" of the table). I get the same result when I create a dataview of the table - one row.
View 4 RepliesI'm using the MVC 2 RC. I have a custom model binder that used to iterate over posted form values in MVC 1.0 like this:
[Code]....
How can i insert data into tally using C# .net. I could select data from tally, but how can I insert data?
View 13 Replies I want to send data to Tally, I realised that it can only be done by converting the data to an xml format. In a VB6 application I found the sending data using the code
ServerHTTP.Open "POST", "http://localhost:" + PortNumber
ServerHTTP.send xmlstc
how can I use the code in C#.net
In .Net ServerHTTP not found
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
i have 6 textboxes which i want to iterate.
they are however in a TD in a TR in a TABLE in a PANEL etc.
the only way i've figured out to iterate them is in this way:
this.Controls[0].Controls[3].Controls[7].Controls
that's not only errorprone, but also hard to come up with.
but this.FindControl (to find one by name) doesn't work either, does findcontrol also only search in the direct child, and not the whole hierarchie?
so basicly what i'm looking for is to iterate ALL controls in the page, no matter in which level of the hierarchie, to check if it's a textbox.
I wrote(attempted) a sub to disable all linkbuttons in a column in my GV. It seems code #1 just disables the LB in 1 row only.
[Code]....
how to iterate through all the controls in just my Content place holder ? What I'm looking to do is to Enable/Disable all the controls in my Content place holder (WEbControls as well as HTML Controls).
View 2 RepliesI am using listview which looks like below:
col1 col2 col3
ow1 textbox1 textbox2 textbox3
dropdown1 dropdown2 dropdown3
row2 textbox1 texbox2 textbox3
dropdown1 dropdown2 dropdown3
i.e. I have two rows and three columns in each column I have 1 textbox and 1 dropdownlist.
What I want is this, When a user selects something from dropdownlist , in selectedindexchanged event, I need to check if selected value from the sender dropdownlist is equal to any of the textboxes of the listview.
i.e. in selectedindexchange event of dropdownlist , I need to find all the textboxes of listview and then iterate them to match with selectedvalue.
Previously, I have done this for 1 row only by using namingcontainer but how to find all textboxes of listview .
I am a total novice to VB so bear with me.In my web-based project, I pass an ID field as a parameter in my URL and go through each row in my gridview to find the correct row that matches the ID parameter, like so:
[Code]....
[Code]....
The problem is that this code only works if the corresponding ID is in a row displayed on the first page. I want to loop through each page in the gridview's rows until either the correct ID is found or it reaches the end of the data set. How do I do this? I assume I need another For loop that looks something like...
[Code]....
...that will go right before my other for loop, and one will loop through each page in the gridview. But obviously I've got that For Loop completely wrong. How do I do this correctly?
I want to know that how can i sum All values from same months to a single month. Like all Jan. values should be summed as 'Jan' and all feb. values should be summed as 'Feb'. I am using below query to only get the current year's values
[Code]....
Have been trying to update some key fields but cannot get it working. I have the form working fine updating non key fields. I found some old threads on similar topics but none answering my question. I am using a FormView and a sqlDataSource
Question: What steps do I need to take to update key fields using a formview and a sqldatasource?
Additional Information: I have tried the following
Adding OldValuesParameterFormatString="old_{0}" to sqldatasource Adding to update parameters the old_myfield reference Adding DataKeyNames to the formview (note all key fields are in datakeynames and I only want to update the one)also when using the asp parameters do they need to be in same order as query and repeated as many time as used? Or just the same order as first referenced i.e. only defined once? Or any order?
i am using dataset,i retrived the values from the database and i deleted from the data set .is it possible to get values back?
how can i get those values?
MY CODING
string studentno = "select regno from stu_ref where batch='" + dropbatch.SelectedItem.ToString() + "'";
SqlDataAdapter dastudent = new SqlDataAdapter(studentno, cn1);
DataSet dsstudent = new DataSet();[code]....
form the above coding i will get all values form the table stu_ref of regno of student now i need to get the first and the last regno from the table
for eg TextBox1=103301
TextBox2=103378
the total no of student=78
public static DataSet GetSubCategories(int category_id)
View 4 Repliesi dont know why this happens and when happens......i have one employee table that contain date field and that field contain two different values one is -'2008-10-01 00:00:00.000' and second is '2008-10-01 12:00:00.000'.can anyone explain when this type of value insert in database.
View 2 Replies I have a database table with three columns of interest
slottypekey (integer)
taskkey (integer)
permission (string)
Lets's say I have a stored procedure that gets this data and puts it into a dataset.
I would like to write a function that has input parameters of slottypekey and taskkey
and that returns the associated permission. What is the best way to do this?
I have 2 Linq to Entity queries, here they are:
[Code]....
In "query" there are several columns, 2 of them are NIIN and Qty. In "objViewDDRT" there are only 2 columns, they are NIIN and AvailBalance.
What I need to do is for each row in "query" check to see if the NIIN is in "objViewDDRT", and if it is get the AvailBalance for that NIIN from objViewDDRT.
How can i get the values even when the Source or url is null from the below query
SELECT a.id,
isnull((SELECT STUFF((SELECT
'<li><a href="'+url+'">'+Source_Name+'</a>
<span>(' + k.Source +')</span></li>' end
FROM table1 i, table2 k, table3 j where
i.CategoryID = j.Category_ID and i.CategoryID = c.Category_ID and i.Source = k.ID
FOR XML PATH('')),1, 0, '')), '') AS Source_url,
FROM @table4 c INNER JOIN table5 v
on c.Category_ID = v.Category_ID
how can we store the value which i entered in a textbox to table dynamically.
View 3 RepliesI am returning a dataset from a method and trying to set one of the columns as Primary Key.
CategoryList.Tables[0].PrimaryKey = new DataColumn[] { CategoryList.Tables[0].Columns["CategoryNodeId"] };
Interestingly it gives me this error at run-time, These columns don't currently have unique values.
Now I perfectly know why this error should error, but there are no duplicate keys in this data column. I broke the code in between and bound the dataset to gridview to check if this column contains any duplicates and this is not the case. Here is the result set underneath. Have a look at the first column 'CategoryNodeId'.
CategoryNodeId
CategoryId
Name
ParentCategoryNodeId [code]...
unable to find a work around for now.
I have a table with a lot of records - it has a column called CallID I have another table with no records, but one that also has a CallID column I want to insert all the values from the CallID column in the first table into the CallID column of the second table.
View 6 RepliesI am creating an online employment application, and instead of creating a table with 20 columns for job duties that may or may not receive values, I simply want to create 3 columns
ApplicantID
EmployerName (Name of Work history Employer)
JobDuty
I want to create a form on a page with 10 textboxes so the applicant can type in some job duties they had at that job.
Is there a way in C# or SQL to then cycle through and insert the textbox values as separate rows?