I have to generate several simple reports using simple sql statements and present the result in a gridview. I would like the user to be able to select each report from a single drop downlist, once selected the report is viewable in the grid. Is it possible to have one single grid that can display multiple reports?...if so how? Also how can I select each report from a dropdownlist?
View 1 Replies
I want to show the user defined Data table created at runtime in code behind C# and i want the load the datatable values in the crystal report ....
View 1 RepliesOne part of the app I'm building enables the user to select from a range of reports (step 1) then select criteria (step 2). It then needs to pop the results onto the page and allow exporting to Excel/CSV (step 3).Step 2 isn't easy to do generically and there aren't that many reports to make it worthwhile for me to build a framework to do this at this point. The CSV export code is easy enough.For Step 3 I have in my mind a page such as DisplayReport.aspx?Report=ThisReport&Parameters=a,12,43,c or similar which builds a GridView on the page. At least that part can be generic. The complexity I see is in formatting the fields. I know I can build up the report consisting entirely of strings in the database and return it to the GridView all pre-prepared, but that really isn't what I was looking to do architecturally
View 2 Repliesi have a gridview binded with data when i hover mouse to row i want to display a image button to display date ,and when i click the button i want to display calender control for choose date, and next step after i choose date it will be must insert into database. and mean while a hidden label control will display and date shuld be display in it
View 2 RepliesActually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
View 1 RepliesI have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#
If the gridview binds to empty dataset, I need to still show a gridview so that users can ADD more using the textfields in the bottom of the footer template. Since the gridview is empty it won't bind not allowing rendering of the <footer template> I guess I should create a empty dataset if the gridview is empty. How do I check for this and can this be done in GridviewRowEventArgs
View 5 RepliesI have 3 grid views in my ASP.net application Viewing the data from different tables and search input with button( for all 3 grid view One input field), when i give input and click on serach button only one Grid view should be appear rest of the 2 gridviews should be hide but for me when i change the input values previous Grid view also remain stationed on the screen.Gridviews are GVOpenorder,GVShip,GvSchedule and input field name is txtSearch,button name is btnSearch.
View 8 RepliesAfter saving image in db how can we retrieve it in gridview like thumbnail size image and by clicking on image in gridview its open as preview. How can we do this in asp.net using c#.
View 1 Repliesobject og = GridView_EmployeeTimeSheet.DataSource;
System.Data.DataTable dt = new System.Data.DataTable();
dt = (System.Data.DataTable)og;
But getting null in og(object) and at run time Gridview is showing its required data...
Why we are mostly use gridview not prefer crystal report for displaying report.
View 1 RepliesHow to display empty GridView to insert new record if no data retreived for some record on the result from data table?Actually i am trying to give a user an option to add recrod from Gridview. On result of some query it is perfectly displaying data and a footer row with the insertion textbox but when there is no data in the gridview it is not displaying. It should display with footer having insert textbox.
View 5 RepliesWhy does the GridView does not display the value 0?
View 1 RepliesI have a problem with CR on server; I have reports that read connection string from web.config. On my development computer, everything is ok.
On server, report page opens normally, report template (I mean Print, Export etc.) is displayed but data is not shown there. Interesting point is data is loaded even though it is invisible, I understand that for reports more than 1 page, toolbar page buttons becomes enabled. Additionally, when I make a postback, by changing page number or changing zoom ratio, data becomes visible.
I have written this code for CrystalReportViewer but this not work
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim scon As String = "server=(local);database=my;User;Password=sa"
sqlcon = New SqlConnection(scon) [code]....
I'm using the following code to upload images, pdf files, word files and excel to a sql table as binary data. However, I can only figure out how to display the images but am clueless about the other type of files. What adjustments do I need to make so that with a button click I can access the other files? 't By the way, I'm using an image control to display the binary data and I'm aware that that will only work to display images, I just don't how to access all the other types of files once uploaded.
[Code]....
I have a datatable with the following column names
ProviceID, ProvinceName, Year,
TPM, PM 10, PM 2.5, B(a)p
I'm trying to display data from this table in a gridview using template fields. Here's an example of a label in my item template
[Code]....
When i bind data to this grid view, i get an error saying column "PM 2" was not found. For some reason, the program is dropping the .5 from the column name. I am exploring the possibility of replacing the number with alphabets only but this may not be possible as the end user may not find it user friendly. Is there a way for me to get around this problem? I get a similar problem with B(a)p, it drops everything after the B. Any ideas on how to get the gridview to bind column names with special chars in it?
I'm having a problem with the results of a Gridview. The SQL statement I use works in SQL Management Studio, but in my .NET app, it only display a few of the results. The part of the SQL that seems to be effecting it is in the where statement I use like:
[Code]....
@Consultant comes from the value of a selected dropdown.
i have a gridview in each row of gridview row i hve 2 columns. in each row i need a button to enter date, when i click button one calender shld popup and data shld be display at end of the row
View 7 RepliesI'm quite new to ASP.NET programming, so excuse me if my question is dumb.I have the need of showing a grid (A GridView ?) of boolean values. But instead of showing checkboxes, I want to show the cells filled with black (value is true) or white (value is false). I understand I can do that by crafting a TemplateField and changing the style of the cell to select the correct background color and never displaying an actual value. I have not tried but I think it could work. The grid will contains 99% of boolean values and will contain something like 20 rows of 100 columns (2000 cells).
Now I would like to have that grid edited in place at client side, that is with JavaScript, changing the style of the cell when the user clicks on the cell. There would be a submit button somewhere to postback the whole thing.Is that possible ? Any hint for programming it ?Since I have a lot of webforms which needs to display that kind of grid, I would like to go further and design a custom GridView (or other control) that I could install in the toolbox and reuse easily.
I m trying to display image in gridview using following code with ADO.NET. What changes are require?
[Code]....
Just a bit of advice needed really in terms of how I should handle my current scenario:
I have a web page that searches for products/category information the results of which are at present displayed in a gridview on the same page.
However, said gridview is a bit of a beast and as such, I would like to have a page that the user searches for, a button is pressed and the subsequent gridview is displayed in a new window.
Ultimately, I would like the user to be able to make multiple searches so that new windows can have multiple gridviews containing different data sets.
My current thinking is to create session variables that can be pulled through onto 'the gridview page'. Having said that, I'm not sure that would work if multiple searches are created?
I am also thinking I might be able to create said 'gridview window' using javascript but my concern here is the potential loss of functionality of the gridview i.e. paging, sorting, editing, etc.
Does anyone have any thoughts or theories on this? What would be "best practise"?
Here i have problem in Bed management in HOspital Management System, how to display the the image in Grid view, when ever a Record has been entered in to the Database.if the entered person is MALE, "M"(Image) should be displayed,if FEmale is entred in to Database "F" ,Image should be added to Grid view.. and if i right click on the "M" or "F"(image), corressponding details should be come like when he joined, Place ,city ,address should come.
View 10 Repliesi want to display images in grid view whoes source path is in MS access database and the images are in image folder how i can do this ?
View 3 RepliesI had a problem before with GridView displaying picture and it was solve as post [URL] shows. I am trying to apply the same coding to another GridView with a different configuration and I am having a hard time making the adaptation. May someone take a look at it. What I am trying to add to this GridView is code as:
DataImageUrlFormatStringl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif")
%>'
And the GridView code is the following at the present time:
<
asp:GridView
ID="ClassifiedsDisplayGridView"
runat="server"
DataSourceID="srcClassifieds"
AutoGenerateColumns="False"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
EnableSortingAndPagingCallbacks="true"
>
<Columns>
<asp:ImageField
DataImageUrlField="AutoNumber"
DataImageUrlFormatString="~/UploadedImagesClassifieds/{0}Pic1.jpg"
HeaderText="Picture"
ReadOnly="True"
>
<ControlStyle
Height="50px"
/>
</asp:ImageField>
<asp:BoundField
DataField="Category"
HeaderText="Category"
/>
<asp:HyperLinkField
DataNavigateUrlFields="AutoNumber"
DataNavigateUrlFormatString="~/Classifieds/DetailPage.aspx?AutoNumber={0}&FlagForm=NoSubmitted"
DataTextField="ItemTitle"
HeaderText="Listing
Title" />
<custom:LongTextField
DataField="ListingComment"
Width="400px"
Height="75px"
HeaderText="Listing
Comment" HtmlEncode="false"
/>
<asp:BoundField
DataField="EnterDate"
HeaderText="Listed
on" SortExpression="EnterDate"
/>
<Columns>
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
</asp:GridView>
<asp:ObjectDataSource
ID="srcClassifieds"
TypeName="SearchUtility"
SelectMethod="GetClassifiedsSimpleSearch"
runat="server"
OnSelected="srcClassifieds_Selected"
EnableViewState="False">
<SelectParameters>
<asp:QueryStringParameter
Name="Category"
QueryStringField="Category"
Type="String"
/>
<asp:QueryStringParameter
Name="Activity"
QueryStringField="Activity"
Type="String"
/>
<asp:QueryStringParameter
Name="KindOfSearch"
QueryStringField="KindOfSearch"
Type="String"
/>
<asp:CookieParameter
CookieName="Country"
Name="Country"
Type="String"
/>
<asp:CookieParameter
CookieName="CityTown"
Name="CityTown"
Type="String"
/>
<asp:SessionParameter
Name="State"
SessionField="State"
/>
<asp:Parameter
Direction="Output"
Name="SelectRows"
Type="Int64"
/>
</SelectParameters>
</asp:ObjectDataSource>
