I am in need of proper way of representing my data. What I want is Grouping Sorting CollapsableI shouldn't use third party tools. From last 2 days I was searching net, but dint got the solution. Actually I am at the begining stage of asp.net. getting these functionalities using any kind of web data control(grid view, repeater, ..)
View 3 Repliesi want to add a column on to the end of the gridview that runs an sql query based on that ID i.e! select * from thistable where id = (0). so basicaly i want to bind a sql query as a column!! how would i do this?
View 5 Repliesi am doing a gridview which consists of 1 checkbox,1 linkbutton, 1 textbox and 1 image button. For all the cell which has the checkbox checked, i need to collect the data and update the database.
Form the gridview, i need to collect few information before i update the database. That is the cell informaion (checkbox and textbox), and also the Line information, shift (Grave/Morning) and also the date.
I am having problem in reading out the date of each cell belong to. By using the code GridView.HeaderRow.Cell(n). text , i only able to access shift information.
The Date Information is done by adding additional header row and its coding is as below:
[Code]....
The img of my gridview:
[Code]....
How to obtain additional information in label1? Data ID and last name, it works. How to obtain additional information ID2 in DropDownList?
The repeater below allows a visitor to click a [+] to add a textbox. They can add as many as they need. Each textbox will contain a name.
[Code]....
I want to be able to collect all of the additional textboxes and add it to an string:
[Code]....
If for example the visitor added two textboxes and typed in "Mary" in the first and "Sue" in the second, I'd like "myAdditionalRegistrants" in the above string to be replaced with:
Mary <br /> Sue
I have a grid view with the delete option enabled. When the user clicks on delete, that entry in the database is deleted. However, each entry in my database corresponds to 2 images on the server. When that entry in the database is deleted, I also want to delete the images. (the images consist of the ID for that database entry plus "right.jpg", and "left.jpg") Is there a simple way to do this? My thoughts are that I need to run some additional code when the user clicks the delete button, but how can I trigger this code?
View 2 RepliesI have been researching this issue for a couple of days and have found a lot written about it, but none of what I have found has fixed the problem I am having.
I work for a school system, and my principals are wanting to take a list of the staff members at their school and create staff lists for different activities they perform. I thought I would load the staff into Gridveiw1, and when they select a record have it move over into Gridview2 and "delete" from Gridview1.
I am loading my full staff into a datatable (SQL Server backend), and setting this datatable as my gridview1 datasource. At this point, it loads great, and cosmetically speaking sorts and pages fine. The problem occurs in the codebehind after a Sort or Page change has occurred -- when I select a record and move it over into Gridview2, it is moving the original record that was at that postion on Page 1 instead of the sorted or "new page" record.
So if the initial list comes in as:
Teacher 1
Teacher 2
Teacher 3
The sort button is hit so that the list now starts out like:
Teacher 7
Teacher 13
Teacher 5
If they select "Teacher 13" to be moved over after the sort, instead it is still moving over "Teacher 2" -- the initial teacher in that index before the sort.
The Gridview setup on my aspx page looks like this:
[Code]....
My codebehind:
[Code]....
i will display the data in gridview (like a summary) and then user will click a button to generate pdf of the data. the content in the pdf is different to gridview.i mean in a table format not in gridview format plus some paragraph of text below.i dont know how to generate.
View 1 RepliesMy data of gridview is exporting to excel sheet but it is exporting extra buttons in that page also and also exporting the navigation links that i have used in the master page, Below is my code:
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<cc2:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" > </cc2:ToolkitScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<div style="padding-left:20px;line-height:1.5em;";>
<div style="width:100%";>
<div style="float:left";>
[code].....
When I select the Search By dropdown, an additional gridview is created on auto-postback.I will ad a visual and code as soon as this is accepted for review.
View 1 RepliesI'm trying to setup is a News module with article listing paging and article detail paging. I have a GridView with paging that lists my articles just fine. In that list, some article titles have links that direct to an article detail page by passing in the articleID to the details page. I was able to setup my details page, which uses a DetailsView control, to use paging by using an ObjectDataSource with pageIndex and pageSize parameters from the querystring. Once on my detail page, I can use my navigation arrows to move through Next and Previous articles just fine.
No matter which article I click in my article list, my detail page always starts with pageIndex 0 and thus not the article I clicked on. I understand why that is because it's going by pageIndex value instead of articleID. What I need it to do is, set the detail to whatever articleID i pass in, then allow me to navigate Next and Previous to THAT particular article instead of starting me off from pageIndex 0.
[Code]....
I'm trying to create a class, DataCommon, to contain all my SQL Data manipulation functions. I've created a Subroutine called Init that initializes a SQLDataAdapter:
[Code]....
From my other classes I am creating an instance of DataCommon, calling Init, and calling another subroutine in DataCommon that pulls data from SQL and loads the data into my dataset. This part is working great -- no problems at all. I'm loading three different Datatables in the Dataset with no issues.
At this point, I'll perform my various manipulations on the datatables -- add/delete/modify rows -- again with no problems. All of this is creating postbacks...and this is where my problem begins. After I've done all my manipulations to the data and am ready to update my SQL tables, I have to re-initialize my SQLDataAdapter. I thought I could do something like:
[Code]....
But I get the error: Exception inserting Class. Thread was being aborted.
In my initial data load from SQL, each datatable is getting loaded from a single SQL table, so I was hoping to use the autogenerated Update/Insert/Delete statements by the SQLDataAdapter. As a test, as soon as I filled the dataset initially, I added a new row to one of the datatables and used the SQLDataAdapter.Update() method before a postback occurred, and it worked perfectly.
So, with all that being said, I guess my question is, how do I reconnect the table mappings between my SQLDataAdapter and dataset to autogenerate the updates after a postback occurs? I've tried researching this, but I get confused after reading about FillSchema vs TableMappings vs everything else I've read about.
I have made 3 web controls which need to be accessible between eachother. First control is main control (controlA). Other 2 controls (controlB and controlC) are referenced in controlA. Now i need to access function from controlC and call it in controlB. I tried adding new reference, but it doesnt work the way I want it.
ControlA is main control and it is merely a table to hold other 2 controls in place. I can access both controls from controlA, but since I need to modify controlC due to drop down menu in controlB i can't force controlA to respond to event in controlB every time it occurs and affect controlC. Or can i? :)
So whenever the event (SelectedIndexChanged) of drop down menu occurs in controlB, I need to set up/change controlC. Problem is, I don't know how to call function from controlC. It may sound very simple to solve and i tried to make a new instance of controlC class in controlB my webpage just wouldn't load.
I'm looking to add controls dynamically to a table across multiple functions. I'm trying to convert this from a C# app to a web app using asp.net, though this is my first time using asp.net with no web development background. I read the creating tables dynamically in the FAQ but I'm still not sure how to do this.
When pressing the submit button on my form, it will create a table in a place holder. Eventually I would like it to generate urls based on the users input and do this in a function other then the one I created my table in.
In my C# app I was able to add text to a listbox using: lstOutput.Items.Add("Text"); across multiple functions but I'm having trouble doing this with a table.
I understand that my table is a local variable in the submitButton_Click function, but how do I make it global to add rows, cells and controls to it in other functions?
My current code which doesnt work:
[Code]....
When we use CreateUserWizard, how can we most simply create a user with additional data like department id, location id, and preference mix(multiple checkboxes)?
View 3 RepliesI am getting started with Ap.net MVC. For that i chose to practice it by build an application. Im using MVC 2 and Linq To SQL, and i would like to passing another Query to the view. For example, i have this:
[Code]....
So i would like to pass data1 and data2 to the View. I can use return View(data1), but the View function accept just one data. So what technique i can use to pass the tow data to the view
I have implemented my own custom MembershipProvider with a custom data store. No problems so far. I would like for people to login using their email instead of a username. Because I have my own data store, this is not a major issue, I can just pass the email as the username for the MembershipProvider.
My question is, how do I store additional custom user data along in the FormsAuthenticationTicket? I want to store a couple of things that will never change, such as their UserId, First/Last Name and Country. I started looking into creating FormsAuthenticationTicket with the UserData, but quickly got confused. How do I store multiple things into this UserData, and how do I easily read this data back on every single ASP.NET MVC2 page. I found many samples, none that really seemed that great in terms of MVC2. There has to be a simple way to do this.
It would make no sense to read the UserId, First/Last Name and the Country from a database on each and every request because it would never change. Plus, while I want the user to login using their email, I'd want to store their UserId in the auth cookie so that it can be used in nearly every user related database query rather than the email (because in all the tables, the user data is stored along with the UserId - not the email because technically the email could be changed - I already figured that stuff out when it comes to the MembershipProvider).
What is the best practices for storing additional user data like this in ASP.NET MVC2?
I have a function:
public List<Car> GetFourWheelDrives()
{
return dataContext.Cars.Where(c => c.IsFourWheelDrive == true).ToList();
}
Firstly it's kind of obvious what I'm trying to do here. Any suggestions on how I'm doing this? Any improvements?
So now I want to unit test this. Well is it a unit test? A unit test isn't suppose to touch the database right? So this is a functional test?
So say I write a test
[Test]
public void GetFourWheelDrives_NoParameters_ReturnAListOfOnlyCarsThatAreFourWheelDrives
{
Assert.Greater(dataContext.Cars.Where(c => c.IsFourWheelDrive == false).ToList().Count, 0);
var cars = GetFourWheelDrives();
Assert.Greater(cars.Count, 0);
Assert.AreEqual(cars.Count, cars.Where(c => c.IsFourWheelDrive == true).ToList().Count);
}
So first Assert I'm making sure cars that aren't 4WD exist in the database otherwise it wouldn't be a valid test.
Second Assert I'm making sure at least one was returned.
Third Assert I'm making sure that all the cars returned were in fact 4WD.
I know this isn't a good test because I'm using the same logic in the test as the function I'm testing. However this is the only way I can currently think of to do this.
I would like to know how i could display data from an itemtemplate or any other form views/data-bound controls without having it render in tables? i know theres control adaptors, but is this reliable and will it work with asp.net 3.5?
View 4 RepliesI have a gridview that I bind on Page Load event.In the rowdatabound event I want to add a row to the gridview and bind it based on the value of the current record.The row is not being added. Is there a way to bind the extra row in the rowdatabound event?
Private Sub grdDocuments_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles grdDocuments.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
Dim dt As DataTable
Dim dv As DataView = grdDocuments.DataSource
[code]...
getting the Parameters declared in an sql function in the C# code. We can actually get the parameters from a Stored Procedure by giving SqlCommandBuilder.DeriveParameters
Similarly is there any way to get the Parameters from the SQL Function.
Is it possible to use Exec statement in SQL Functions
like..
[Code]....
I'm trying to view a list of uses that have the execute ability on a function, but I cannot find a method to do so.
View 2 RepliesI have an ASP.NET control (a button) in a WebApp. It has an onclick attribute:
onclick="SaveButton_Click"
SaveButton_Click()
is a C# function in the codebehind file. When the user clicks the button, SaveButton_Click() is executed.
What I would like to know is whether there's a way to set up a javascript callback junction. I know how this is done in AJAX, but I'm not sure in ASP.NET (with controls that run on the server) how (or if) this can be done.
i always get this error when ever i use DropdownExtender,Additional information:The Controls collection cannot be modified because the control contains code blocks
i.e. <% ... %>).this is my ASPX Code
[Code]...