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 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 an html table in an aspx page (C#) that has columns like
1.CheckBox 2.Text 3.Text 4.TextBox
I want to iterate through the table one row at a time and process (run a stored procedure based on column2) based on whether the checkbox is checked or not. How will I be able to do that?
I have a Telerik RadGrid with a GridTemplateColumn that contains a checkbox, as follows:
<telerik:GridTemplateColumn HeaderText="MINE" UniqueName="MyTemplateColumn">
<ItemTemplate>
<asp:CheckBox id="MyCheckBox" runat="server"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
I want to set the box to be "checked" based on a value read from the database. I could handle the ItemDataBound event and read the database when each row is bound, but that results in n lookups. Instead, I want to handle DataBound, and then set all the values at once. So, in that method, I want code like this:
[code]....
I want to select many rows from my SQL Server database and combine them in a certain manner. Currently, I've been using the following method to get these rows:
[code]....
Suppose I have a temporary table (Shown below). The table is defined and populated in my stored procedure. After it is populated, I need to go through every row in the table. Here is what I need to do :
Check if Amount2 > Amount1 If Amount2 > Amount1 then set Amount1 = Amount2
It feels a little akward for me to use the temp table.
[code]....
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 using list view to display the the data but i am getting an error like An item placeholder must be specified on ListView 'ListView1'. Specify an item placeholder by setting a control's ID property to "itemPlaceholder". The item placeholder control must also specify runat="server.Even i have specified the itemplaceholder id but no use still same error.
[Code]....
Actually what i am doing in my Data Access Layer dragging store procedure to TestDbml to display records and creating data context instance in BAL to retrieve records and my method in BAL is like this
public IEnumerable display()
{
using (TestDataContext db = new TestDataContext())
{
var display = obj.USP_Actor_View_Speciality(p_UserName, 1);
return display as IEnumerable;
}
Now the problem is that how can i iterate or fetch over the records and display accordingly in my Presentation Layer so that i could return all the field parameteres Like ield1=val.field1,field2=val.field2.
how to maintain state of placeholder. i have a placeholder in which i add many image controls dynamically but when my page get refresh all controls from placeholder gets removed from it. the enableViewstate of placeholder is set to true.
View 3 RepliesI 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.
[Code]....
In above query I want to have top 10 rows as well as count of all rows.
I need to be able to check programatically if a SqlDataSource contains no rows, and make a Placeholder visible if it does contain rows, and invisible if it doesn't. I seem to be able to return the affected rows using SqlDataSource1_Selected, but turning the placeholder invisible never works.
turning the placeholder off and on depending on whether the data source contains rows?
I have an object data source that is being used by an rdlc report, and the object data source uses a filter that is built from session variables passed to the page.
The report displays correctly, with the filter applied; however, I want to mark each of the rows as "printed" in a bit field in the database table.
In the table adapter, I have the following Update command that is used by the object data source:
UPDATE dbo.WorkOrder
SET boolWorkOrderPrinted = 'True'
WHERE (WorkOrderID = @Original_WorkOrderID)
And in the Page Load event, I run:
ObjectDataSource1.Update();
However, no records are updated.
How to delete related data.
Ex:
Tables:
1) Account: ID,UserName,Pass
2) Campaign: ID,AccountID,Date,Balance
3) CampaignSpec: ID,CampaignID,Spec,Color
Note: Account.ID = Campaign.AccountID and Campaign.ID = CampaignSpec.CampaignID
How do I remove duplicate rows from a data table based upon a two column values;I want to pass in a Data Table and a column names and get the data table back with data rows where that columns value are unique.
I have a Data Table with Duplicate Rows i want to delete the duplicates rows based upon two column values if both columns values are there then Delete the row.
I have a Gridview that has Paging enabled, and I need to loop through all the rows of the data. Therefore, I assume I need to loop through the datasource instead of through the Gridview.
I change the datasource of my gridview at various times when running.
How can I get a DataView of the GridView's current DataSource, so that I can loop through it?
Something like:
Dim dv as DataView = DirectCast(GridView1.DataSource, DataView)
except that this comes back as Nothing, probably because a Datasource isn't a dataview.
Im struggling with a way to bind multiple rows of sql data to specific controls, what im trying to acheive is having a list of questions / answers in my SQL db and loading them into my web form to build a questionaire.
The data i load into the form depends on criteria like which questionaire is it (there will be 2 seperate ones) and what language should it be loaded in, this will be controlled using drop down lists and passing these parameters to the SQL select statement.
The problem i have is i am unsure which method to pull the data out of the question column in my table, and bind it to seperate controls row by row, should i use a SQLDataReader or load the data into a dataset, or run a stored procedure to pull the data?
Which is the best way to get data from sql and bind it to controls in this situation?
For example:
label1.text = sqlcolumn1.row1.value;
label2.text = sqlcolum1.row2.value;
Etc...
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]....
I 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 have sqldatabase tables.I am reading table data and putting in a tabconatiner(wth tabs containing textbox, checkbox etc) specific to a client. If a client has more than one row i want to iterate through the rows and read each row data. Basically I want to use a button-click to read the next row data at put it in the tabs and so on. I used sqldatareader and a while loop.I can read the data but while loop iterates through the rows and show the last row data / i want to use a button to go to the next row and show data.
SqlDatareader reader=null;
reader=cmd.ExecuteReader();
while(reader.Read())
{
txtboxName.Text=reader["Name"].ToString();
}
protected button_Click(Object sender,EventsArgs e)
{
//I want to read row data in this button click
}
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 hav a gridview ... now i need to add certain number of rows... say 5 rows .... which would b blank .. the rows consist of itemtemplate of textboxes.. here is the grid ...
[Code]....
now i am binding this gridview with certain data say :
[Code]....
now the problem is if the row contains 2 data originally ... then it alwz shows up with only two rows with binded data... but what i want is 2 (databinded rows ) + 5 (empty rows with textbox ) = 7 grid view rows .... now how to do it ... after i hav binded the textbox with data already....with some empty columns corresponding to the above code ?
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
View 1 RepliesI have been handling everything in code which is not working consistently same in all scenarios.
View 1 Replies