I have some data displayed in GridView and there are multiple (repeat) entires.
There are about 20 rows of the same data, but I only want to display 1 row.
I know can amend PageSize="1" but then it shows multiple pages which I also don't want.
The multiple rows - are all of the exact same data - but it should only appear once!
A user has multiple images which is stored in database(datatype varbinary ).I want to show all the images of that particular user in gridview.Can you people guide me how to achieve this?(Asp.net with c#)
View 4 RepliesI'm using Visual Studio 2008 with SQL Server Express databases in my .net 3.5 website
I have three tables I'd like to make entries to when the user completes a wizrd i've setup on a web form.
The First Step - The user enters basic information about their "Case". The table looks like so:
db_Cases - CaseId PK auto int, CustomerId, etc fields
The Second Step - The user enters information about the "Debtors" that are related to this "Case". Think of this as being products....The only difference is these records wont be used over and over again like a product would. The user may need to enter data about several "Debtors", just like if you needed to show several different products on an invoice. For example the user may need to enter information about a husband and wife. This means two entries in the "Debtors" table. The table looks like so:
db_Debtors - DebtorId PK auto int, etc fields
The Third Step - Here's my problem. This step needs to make entries into a third table called "CaseDetails". Again, this is just like if you were creating an invoice with several different products on it, where you would want to get a subtotal of each product's cost. The table looks like so:
db_CaseDetails - CaseDeatailId PK auto int, CaseId int, DebtorId, int
* When this table is later viewed, It will reflect all "Debtors" attached to the specific "Case" being viewed.
The first two steps aren't a problem, I pretty well have that handled in the wizard. BUT How do I create the entries in the "CaseDetails" table when the user finishes?
My idea right now is..... Considering the "Debtors" will be re-used but only on rare occations, I'm thinking I should just add the "CaseId" that was created in step one, to the "Debtors" table at the same time the "Debtor" is created. So the table would look like so.
db_Debtors - DebtorId PK auto int, CaseId int, Name, Address, etc
I'm creating a shopping basket in ASP.NET using session variables to pass the data from a shopping.aspx page to basket.aspx, currently I have the pages passing the primary key of the product with a gridview on the basket.aspx used to display the data from the database.However this only works for one item at a time, how can I extended the session variable so multiple products can be added, as well as quantities etc?
View 4 RepliesHere is what am trying to accomplish...I want to have a DropDownList that is populated by a field from a table. Then once a user selects one of the enteries, he/she then enters a value for that selection in a textbox, then clicks enter or add....now upon doing this, I want to have a GridView that tabulates all the entries the user adds, and keep a total of all entries as the bottomline in the GridView. I can't seem to wrap my head around how to get it done.Does anyone know how I can get this done, or are there examples out there that my searches have missed cause I haven't really seen any examples I could look at. I would think this should be a common solution that is used all over
View 4 RepliesI have a bulk editable gridview. I want to find a way of keeping a running total up to 100 in each row when the user is entering values into the editable columns. I then want to save this data.
The running total column (Total) is a bound column and not editable by the user.
i have a grid view and check box in it. and there are 5 columns in it. user name, first name, lastname city and ph no. and 5 text boxes... and a edit button NOW when i check any checkbox and press EDIT button i want the entries in grid view show be entered into text boxes.
View 10 RepliesI want to validate on client side if a GridView has entries (count ==0). If it doesn't, I want to show on my Validation Summary.
View 2 RepliesI am wondering how to handle and setup a means to submit multiple data entries via ASP.NET MVC.
Suppose I have a product database table such as: ProductId, ProductTitle, Price.
From the view, I was thinking to code the HTML form as:
<form ... >
<table>
<tr>
<th>ProductId</th>
<th>ProductTitle</th>.......
Suppose the form is to be submitted to Controller: Product, Action: Add. What sort of coding techniques can I use to handle this dynamic form, such that I follow good or best practice, and if possible also be elegant.
The solution I see so far is to test the Request.Form (or Formcollection) indexer/dictionary for existence for the dynamic input fields. E.g.
public ActionResult Add(Formcollection form)
{
int productEntry = 1;
string productPrefix = "Product";
while(true)
{........
An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.
Here I am using ASP.NET using C# and my backend in active directory.
I trying to solve this: I have a gridview where are real estates (houses, flats ...) and I need to "freeze" (not to show it) some of them just for a while ... I have an administration website, where is another gridview with edit/ delete ...It doesn't have to be checkboxes ... but I have an idea to put new column to the main page and makes it invisible ... every ordinary row will have empty entry in this column, but the one a need to freeze will have phrase "freeze" in it after the checkbox will be checked ... that I can do ... but I need help with SELECTCOMMAND of the main page gridview ... HOW TO PUT INTO a SELECTCOMMAND THAT I WANT TO SHOW WHAT I NEED TO SHOW EXCEPT OF THOSE WITH PHRASE FREEZE IN THE HIDDEN COLUMN ?this is my select command:
[Code]....
I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].
There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?
Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.
I am creating a web service that returns the list of states. How do I create an object in C# in the web service that will return multiple values (of properties of an object). Currently, the way I am doing it, it only returns the last value pulled from the database. Do I need store an array of properties?
[code]....
I have gridview with 3 columns and one textbox in each column. My requirement is when i paste 3 cells of copied data from excel to textbox in first column of gridview automatically 2nd cell data has to be pasted in textbox of 2nd column and 3rd cell data to textbox of 3rd column of gridview. How can it be done and can anyone provide the best code.
View 3 RepliesI have gridview and will show data like this :
|Year | Course Code | Teacher |
|2011| 001 | T01 |
|2011|002 | T02 |
How I can show name of course and teacher name? I'm using sqldatasource to bind gridview
I FORGOT TO ADD A DATASOURCE TO THE GRIDVIEW. GRIDVIEW NOW SHOWS. ****When I run my web page my gridview is not showing up. Don't know why. The page is nothing more than an image at top followed by a gridview below.
[Code]....
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
I create reports sometimes with a gridview and export the data to excel. Lets say I have like multiple gridviews and I wanted to export each gridview to excel under its own spreadsheet.
So gridview1, gridview2, gridview3 are exported to excel under $heet1, $heet2, $heet3.
I know how to export multiple gridviews to 1 excel sheet but I don't know how to export them separately under their own spreadsheet.
I've been researching online, and i'm continously searching, but does anyone know how to do what i'm trying to do with the gridview and excel or is this not possible?
I have a Company model and an Employee model and I want to create a Company and then create multiple employees for the company in one view.
How should I do this in the view?
And what should I do in the Create POST method to support this multi-entry view?
I have a gridview which enables editing. The editing sequence works fine. When the user clicks the edit button, I want ONLY the row to be edited to be shown, and all others to be hidden.
This is the code that I have, but it isn't working. Can anyone tell me why and how I can fix it? I am using a dataset to bring text from an XML file.
[Code]....
I have 2 tables named Months & Attendence; Their containing fields are-
#1. MonthsName, StartDate, EndDate (like- January-2011, 01-01-2011, 01-31-2011 ...and so on)
#2. EmpID, Date, Intime, OutTime (Holds a whole months of Data for all employees attendences)
Now I wish to show whole months of Attendence for a specific employee into a data gridview.
There should be shown each day of the month- loaded from a Dropdown.
I am trying to create a form that displays a dropdown and a password. The dropdown will act as the login for the password. If the password is correct the dropdown should be the variable for a gridview that should be visible? Can someone look at my code and see where I may be going wrong or any hints?
ASP Code
[Code]....
c#
[Code]....
I have a folder in my CMS (ektron) which has 95 entries.The public site is only showing 50 rows. Is there something I need to do to the GridView control to show the other 45 entries?
View 2 Replieshow am I be able to validate multiple entries (textbox control). It seems that using custom validate is not possible because each validator has one control to validate. In my case, I have to determine if at least one entry was filled with data.
View 4 Repliesi'm trying to show data in gridview through this code but everything appears except the images. I saved the image in sqlserver2005 as Image datatype and when i try to bind the gridview to the db by wizard the images appear when i press test query but nothing when running the app
In Class Named Admin: public DataTable Select_writer(string writer_name)
[Code]....