Displaying Data Via User Generated SQL At Runtime?
Feb 7, 2011
I have a Winforms app which provides the ability for users to create their own reports. At its simplest they design the query which gets encrypted and saved into a database.
The ability to view these reports via the web as now come upon us.
What is the best way to handle this? Ideally I want to use MVC but there will be no model or viewmodel because these queries can return data for any table across the application and so I cannot have hardcoded propeties etc. Obviously I have access to the SQL to execute it.
I wonder if tradtional ASP.Net may perform better in this scenario ie/execute the SQL and put it in a DataTable but was hoping to get some thoughts from the community.
View 2 Replies
Similar Messages:
Oct 27, 2010
I have able to generate several labels and textboxes based on a table in the database during runtime. My problem is that I could not get these values from these textboxes whenever a user changes these values and update them.
View 8 Replies
Feb 24, 2010
I have to show runtime genrated image on a View in ASP.NET MVC web application. how should i render this image.
I am using asp.net MVC 1.0 . how can show runtime generated image to user.
View 2 Replies
Oct 28, 2010
I have able to generate several labels and textboxes based on a table in the database during runtime. My problem is that I could not get these values from these textboxes whenever a user changes these values and update them.
View 4 Replies
Jan 14, 2011
I have a DataTable where the columns are generated programmatically at runtime. I then bind this DataTable to a GridView. What I'm wondering is how I can create the GridView to accommodate this, and if it's not possible, how I can output the DataTable into nicely formatted HTML.
View 3 Replies
Mar 14, 2012
Problem for me is that a tag is being generated that apparently just moves the treview a little bit. So I am thinking I should delete it at runtime. How do I do that?
Code:
<a href="#MainContent_TreeView2_SkipLink">
<img height="0" width="0" style="border-width:0px;" src="/.../WebResource.axd?d=2Lx-Wo-AmOSQUgrfkZW7jw2&t=634209174377343750" alt="Skip Navigation Links.">
</a>
View 1 Replies
Jun 24, 2012
I have try the code that you provide in article "Dynamically Generate and Display Barcode Image in ASP.Net"It is running, however, the barcode image is not there. Eg: I put "a" in the textbox, after push the generate button, its only show "*a*" without the barcode.
The error shows that it is invalid parameter in line "Using bitMap As New Bitmap(barCode.Length * 40, 80)"Â
I have install the application that been given too.
View 1 Replies
May 21, 2010
I'm an ASP newbie, so I'm trying to muddle through setting up this image gallery piece by piece as I learn the language. This particular issue has me completely stumped though. The site in question: [URL] I'm very confused as to why the navigation menu is listing out of alphabetical order. Here's the code that I'm -pretty sure- is governing this chunk of info:
[Code]....
View 2 Replies
May 19, 2010
In my application I am using Tab Container Control. But this Control is not displaying at runtime.Following is the Design Code:
<asp:Panel runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager> [code].....
View 4 Replies
May 26, 2010
I have this gridview made.But it gets populated with columns, column names and template fields dynamically. The template field tht I am using throught the field in each colum is a textbox. The user when loads this page sees a gridview with texboxes in all the columns. I need to be able to retrieve the data entered by the user in the textboxes on a button click.
public class GridViewTemplate : ITemplate
{
private DataControlRowType templateType;
private string columnName;
public GridViewTemplate(DataControlRowType type, string colName)
{
templateType = type;
columnName = colName;
public void InstantiateIn(System.Web.UI.Control container)
{
switch (templateType)
[code]...
View 8 Replies
Jan 24, 2011
I have a gridview on my aspx page with four columns from sql server.
Now my requirement is, whenever user click on button a barcode should be generated from the gridview and displayed in control.
I m totally clueless to how to achieve this and where to start.
View 1 Replies
Feb 19, 2010
I'm writing my web application in VB. Is there any way to allow the user to import data from a .CSV file at runtime - that is dynamically? I intend to have the table structures in place, then just have it such that they can append or replace the data that currently exists in the system.
View 2 Replies
Mar 9, 2011
You know how when you put your cursor over the line that seperates 2 columns of a grid, the cursor turns into a 2 headed arrow and allows you to adjust the width of the column? How do you allow this with a gridview?
View 4 Replies
Feb 3, 2010
Within an ASP.NET user control I have the line:
<div>Web: <a href="<%# Eval("Web") %>"><%# Eval("Web") %></a></div>
I'd like to change it so this HTML is only rendered if Web has a value.
I've tried wrapping String.IsNullOrEmpty(Eval("Web") as string) in server side script but Eval can only be used inside a "binding" tag.
What is the best way to do this?
View 2 Replies
Jan 21, 2010
hows the best way to display comments/user data from a db using mvc?do we just do our own for loop and manually display it or? will doing it this way cause paging problems in the future? any best methods or practice?
View 4 Replies
Aug 7, 2010
I am trying to display data from my database using FormView. However, I only want data for the currently logged in user to be queried. The database already contains the UserName for each user.
View 3 Replies
Jan 21, 2010
Having trouble with a web page and connecting to SQL DB. Basically I have a form view table connected up to a SQLDataSourceControl and what I want displayed in the form is only data that has been assigned to the user that is logged on now. I have a "ViewAll" page, which lists EVERY field, regardless of who it is assigned to, but the "MyTasks" page should only retrieve the data of the current user.
I have two tables in my DB, the "Users" table, with user data (including an ID number) - this is used again in the "Tasks" table as a foreign key called "AssignTo". Therefore if user Joe Bloggs with ID number 5 logs on, whenever someone assigns a task to him, they will select number 5 in the "Task" table, as this relates to his User ID.
View 10 Replies
Aug 5, 2010
i has an gridview with the columns userid, username and password, first column of the column is an image button when click it then under(it means innergridview) that particular row, based on userid i have to display City, Country & PhoneNo. how to do this?
View 2 Replies
Jan 11, 2010
I have Membership, Profile and Role providers setup for my .NET MVC website. I would like to say: this Role has access to that Page. How do I 'inject' this code to the RoleProvider? Or do I have to override it somehow? Any leads?(Roles are stored in the default ASP.NET SqlRoleProvider, Pages are stored in a seperate SQL database).
View 2 Replies
Sep 2, 2010
I'm trying to implement my own Membership provider. I don't want to dig in very details but only high level logic. And first I don't understand is how can I use the class User generated from database in my CustomMembershipProvider project?
I thought I shouldn't generate class User in my project which uses my custom provider because it just don't need any users. It's only for login/logout functionality which implements Membership provider, not project that uses it.
Then I thought that I should pass Connection String to my Membership provider in order to make UserEntity somehow and use it inside Membership provider. I have two separate project for Membership provider and for any else project using Membership.
How could I create and use ADO.NET Entity in CustomMembershipProvider project for User table which located in database in other project?
View 1 Replies
Jan 26, 2011
I'm using .NET 3.5 and C#.
I am not using the .NET Profile Provider.
View 1 Replies
Nov 23, 2010
A friend of mine gave me this task so I can learn advance programming a little bit easier. I am currently doing convertion of an html page to pdf using itext sharp and email the pdf as an attachement. My idea is to save the pdf first to the server machine in the folder name ToBeEmailedPDF folder before using it as an email attachment. The thing that bothers me is that this dialog as what you can see in the picture shows up using the code that I have below.
[code]....
View 2 Replies
Nov 16, 2010
I'm trying to add some user controls on a page. Thats easy, I just do it like this.
UserControl block = (categoryblock) LoadControl("categoryblock.ascx");
Panel1.Controls.Add(block);
But i want to access the label controls and more that are inside the categoryblock.ascx. How would i do that? I cant do it like this,
block.l_itemName.text = "blabla";
I managed to user FindControl("l_itemName") but i would rather like to have the intellisense.
View 1 Replies
May 26, 2010
I am trying to create a Forms Authenticated site and have already used the aspnet_regsql tool to create the necessary logic in my SQL Server DB to hold my data. Now, I am looking to create a custom Membership, User and Role provider for my DB model. I was looking at the following video: [URL]
Now, I get the concept on how to go about it but I notice that this guy uses custom DB Procedures as to the ones that are generated by the aspnet_regsql tool. Can anyone direct me on where I can find info on how to go about building the Membership, User and Role provider class using the DB structure that aspnet_regsql generates? So much junk on google that I am having a hard time finding good guidance.
View 1 Replies
Nov 23, 2013
I am generating report through report viewer.. I want show my record which date i select but it cant select data from date which are giving it taking system date to display data...
Example: I select 2013-11-15 it does not showing any data but when i change my system date to 15 it is showing data... Â
<body> <form id="form1" runat="server"> <table class="style1"> <tr> <td class="style4"> </td>
<td class="style3"> Â </td> <td align="right"> Date</td> <td> <asp:TextBox ID="TextBox1" runat="server">
</asp:TextBox> <asp:CalendarExtender ID="TextBox1_CalendarExtender" runat="server" Enabled="True" TargetControlID="TextBox1" format="yyyy-MM-dd"> </asp:CalendarExtender> </td> <td>
<asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click1" /></td>
[code]....
Here report is temporary table which save all the select data from purchase from.
View 1 Replies
