Building User Driven Query Interface?
May 6, 2010
I am somewhat of a novice at ASP.NET, but have a lot of database experience. I want to build a web query interface to allow users to get data back from a database. The idea would be to choose various fields (I have about 20+ fields and 200,000 records in the database, and use either the checkbox, listpicker, radio, etc. to select the fields they want). Then the person could search by date, or search by greater than/less than statements in a particular field.
For example: the user could select: Temerature as the variable, and then Greater than and then enter a value and hit submit. I'd like the option to be able to include all the other fields from the table as well (maybe with a check box or something).
View 14 Replies
Similar Messages:
May 6, 2010
I have several tables in a database (6-7 tables and ~200,000 records, MS SQL) that I'd like users to be able to use a web based query form and return information/datagrid/download csv/excel files. I'd like the user to be able to query the table they want and fields they want, time they want (maybe datepicker)or by selecting a field and perform a GT/LT operation on it. Has anyone done this and if so are there any resources/templates for this type of thing?Here is an example:I have a 'weather' table with 20 variables in it. I'd like a user to be able to select the fields they want to export (radio/check box) by using a date picker A user could select the variable "Temperature" and use GT/LT, etc. some value they enter. in a perfect world, the user could select a checkbox to include all other fields in the output.
View 1 Replies
Aug 22, 2010
1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
View 11 Replies
Jan 13, 2010
I have table having data like:
ID Date Name
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
I need to get result something like...
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
4 1/4/2009 Null
5 1/5/2009 Null
6 1/6/2009 Null
7 1/7/2009 Null
8 1/8/2009 Null
............................
............................
............................
30 1/30/2009 Null
31 1/31/2009 Null
I want query something like..
Select * from tbl **where month(Date)=1 AND year(Date)=2010**
Above is not completed query.
I need to get all the record of particular month, even if some date missing..
I guess there must be equi Join in the query, I am trying to build this query using Equi join
View 3 Replies
Apr 28, 2010
If not what are alternatives in asp.net mvc to make reusable components? Which of those alternative is recommended to use?
View 1 Replies
Aug 23, 2010
I have one SQL Query and it is working fine. Now, I want to access another table using One of the columns in this table.How can I access that value and How to put that in the existing SQL Query
View 4 Replies
Jan 15, 2010
Here is my table and data of these tables
Table name: Code
CID Code
1 abc
2 def
3 xyz
Table Name : Details
ID Name CID
1 a 1
2 b 2
Resultant Table:
ID Code Name
1 abc a
2 abc Null
3 def b
4 def Null
5 xyz Null
6 xyz Null
I nned to get all record from the code table and against each code I have to get all the rows from the details table, if some code have value their need value and if not then Null
View 1 Replies
Mar 17, 2011
One thing I would like to improve on for many of my web applications, is the user interface design and the "look and feel" of the sites. To begin looking at how to do this, I thought I would start by asking the community what additional software they use or would recommend to combine with either VS2008 or VS2010.
View 2 Replies
Apr 4, 2010
how to create a guestbook user interface
when user click the submit button, all the content of the textarea will be display in nest table.
is it done by javascript? or just div or span tag can do this.
i am using jsp/java servlet to do guestbook, but i had no idea to build the guestbook, so leave msg here.
View 2 Replies
Mar 25, 2011
I am new in developing using asp.net.
I use java(struts2) to do the web application before,it is easy to control this use the jsp tag or struts2 tags: For example(suppose the "do something" operation need use login):
<s:if test="#session.user!=null">
<span>do something</span>
</s:if>
So if a user did not login,he will never see the menu of "do something".
Now I wonder how to make it in the asp.net?
Is this controled in the xx.aspx.cs?
View 1 Replies
Feb 28, 2010
I have a webpart with asp.net control within.I would like to hide some parts of that control, some asp:net panels etc. regarding one of the TextBox's value. The issue is that I don't know to change the visibility of asp:panel wrapper without any postback, and how to refresh page to see the changes on the UI.I was trying to implement TextChanged event but it dosen't work.
View 2 Replies
May 4, 2010
I'm looking for advice on what .NET user interface components are out there on the market. I have been developing asp.net websites and have mainly been using the Visual studio toolbox build in controls supported by the AjaxcontrolToolkit and the applications have been mainly used inhouse running on our company intranet.
But now a new client wants a much more professional looking, commercial web application and they have a budget for some user components for use in the application. Any recommendations where value for money will be realised.
Interested in components that will integrate well with ASP.NET 3.5 SP1 or even .NET 4.
View 2 Replies
Feb 18, 2011
I want to deisgn a user memebership management interface which allows the Site Admin to:
View all the users and the role the are assigned. Also I want to have a Manage/Edit linkbutton which shows a Popup Modal, allowing the Admin to update the users details.
I come across [URL]. Are there any similar Open Source free components? Or tutorials which i can follow to achieve this?
View 1 Replies
Mar 25, 2011
I'm staring to learn T4 .I want to create a framework for my self that enable me to generate DAL and UI.Like Code generator softwares that maps Codes and User Interface from database .i don't have any question about generating data access layer.my challenge is to generate UI ( asp.net controls and HTML)
View 1 Replies
May 3, 2010
I have an Interface that has its concrete class defined via a factory. Because of this I found no way to use the Interface tpye directly in my LINQ quesry so I had to use the concrete class types to creat a generic list. The LINQ query works but after calling.ToList() on the LINQ query result I get a List(of MyConcreteClass), but I need a List(of IMyConcreteClass). I have tried everything I can find: .Cast, Ctype, implicit casting, etc. but I always get back one of the (2) messages (depending on if I attempt to cast)message:
"Unable to cast object of type 'System.Collections.Generic.List`1[MyConcreteClass]' to type 'System.Collections.Generic.IEnumerable`1[IMyConcreteClass]'."
...or
"Unable to cast object of type '<CastIterator>d__aa`1[IMyConcreteClass]' to type 'System.Collections.Generic.List`1[MyConcreteClass]'."
Here is the sample code:
[Code]....
View 2 Replies
Aug 6, 2010
I am not sure how the user defined class objects are garbage collected. Do I need to implement IDisposable interface on every class and call the dispose() method on it to free the memory?
View 7 Replies
Mar 26, 2010
I'm build a web page in ASP.net is supposed to work just like Query Analyzer. It has basically a textarea to input the sql command, and an Execute button.I'm using SMO to execute the command in the database, as follows:
//Create object SMO
Microsoft.SqlServer.Management.Smo.Server server = new Microsoft.SqlServer.Management.Smo.Server(new Microsoft.SqlServer.Management.Common.ServerConnection(oConn));
//To execute the command
server.ConnectionContext.ExecuteNonQuery(tbx_cmd.Text);
//OR
myDataset = server.ConnectionContext.ExecuteWithResults(tbx_cmd.Text);
The problem is that the textarea command can contain anything, from a stored procedure (with GO's statements) and any select command that return resultsets, just like Query Analyzer.But, if I have GO statements, I only can perform the query using ExecuteNonQuery method. If I use the ExecuteWithResults method, it raises errors because of the GO statements.And if I want the resultsets to be available, of course I can only use the ExecuteWithResults method. how can I do to execute the same command texts at the same time?
View 2 Replies
Feb 18, 2011
I am creating a interface for User Role Management based on built in membership provider.I want to display all the roles as check boxes for a selected user. I am able to display all the roles in the database, but not able to load the specific user roles. For example, I am able to publish role 1 role 2 role3 role 4 as check boxes. But if the user is already flagged as role 1 and role 3, I am not able to show that data (role1 and 3 should be checked when form loads, but right now, they are not checked)...How do I get the roles as checked boxes display on a page.I am using a repeater control to display roles as check boxes on the page..
<asp:Repeater ID="UsersRoleList" runat="server">
<ItemTemplate>
<asp:CheckBox runat="server" ID="RoleCheckBox" AutoPostBack="true" Text='<%# Container.DataItem %>'
[code]...
View 1 Replies
Aug 20, 2010
I am having problems with a user control. I want my solution to have a separate project for holding my user controls.The main project can get a reference to this user control project and can import this user control dll into my main project.
View 3 Replies
Mar 25, 2011
My intention is to give the user a flexible user control on a master page that does the following:
When navigating, a child page will pass the URL (with querystring) and PageTitle to the user control. The user control will take those two parameters and insert them as a "breadcrumb" object at first index of a List<breadcrumb> collection
This part works fine through the use of a Repeater with a LinkButton contained in an ItemTemplate. The user sees each of the pages he has been visiting in descending order, the provided benefit is a quick way to re-open records they have recently modified or created.
The part I'm having trouble handling is what happens when the user clicks the LinkButton, which is that the child page adds a new reference to the URL at the beginning of the List<> collection and I cannot seem to control the behavior of removing the LinkButton before it gets re-created. What I've tried doing is:
List<>.RemoveAt(RepeaterCommandEventArgs.Item.ItemIndex);
Repeater1.Controls.Clear();
Repeater1.DataSource = List<>;
Repeater1.DataBind();
While that should work, my CreateBreadCrumb(string url, string title) function gets called by the child page before the UserControl detects the Repeater1_ItemCommand event, so in effect it appears that the wrong ItemIndex is being used for removal.
View 1 Replies
Jul 7, 2010
I'm working on a portal, and I need to check users conection on the ldap.
And if users are members of a special group then it works.
I've exactly used this link to make it works : http://msdn.microsoft.com/en-us/library/ff649227.aspx (almost work)
My point is : my ldap path seems good, no error anymore, when I log with my username and password.But when I querry it, it returns null, but I'm sure my user is in the group :
// Bind to the native AdsObject to force authentication. Object obj = entry.NativeObject; DirectorySearcher search = new DirectorySearcher(entry); search.Filter = "(SAMAccountName=" + username + ")"; search.PropertiesToLoad.Add("cn"); SearchResult result = search.FindOne(); if(null == result) { return false; }
I'm a normal user, i test with my account. I'm a member of the group that I'm looking for.
View 8 Replies
Dec 1, 2010
I'm looping through an array of controls and need to know which controls an end-user has the ability to (via JavaScript or directly) change the value that gets posted back. Where can I find such a list?
So far I have this:
Private Function IsEditableControl(ByVal control As Control) As Boolean
Return TypeOf control Is IEditableTextControl _
OrElse TypeOf control Is ICheckBoxControl _
OrElse GetType(ListControl).IsAssignableFrom(control.GetType()) _
OrElse GetType(HiddenField).IsAssignableFrom(control.GetType())
End Function
View 2 Replies
Feb 22, 2010
I have a requirement for building an instant messenger application for the selected user.
I have googled for the solution but without any sucess.My requirement is once a user initiates a chat with another user,the another user needs to get a popup of the chat window,where the two users can start chatting.
View 4 Replies
Nov 25, 2010
Sample web application code where content(like forms) is generated based on user role like admin,priority1 user,priority2 user.
View 1 Replies
May 24, 2010
So, after all and after all these projects that have been done. What is the best way and I should consider as standard in the furute to start any further ASP.NET Projects that are database driven.
I have done many using
1. Store procedures and classes
2. One class to handle all the add,delete,update ...etc functions
3. ADO.NET
4. Using sql statements directly on the code (I know not recommended, it was my first project) :))
..and so on
What method you recommend in the future that will save me code and errors and optimize my application speed as well.
View 2 Replies