DataSource Controls :: A Query Generator To Search In The DB?

May 27, 2010

I'm looking for something similar to EasyQuery. Some sort of control that lets the user or the admin to select some tables, then some columns for the tables and the conditions, so he can do the query without entering the mysql sentence, only selecting the tables and the rows...

View 1 Replies


Similar Messages:

DataSource Controls :: Sql Query Syntax For Advanced Search With Dropdownlists

Feb 16, 2010

I want to be able to make a query from three dropdownlists but not all three have to be selected to create results. This is what I have so far :

sub getdata (src as object, e as eventargs)
dim strsql as string
dim myconnection as oledbconnection
dim mycommand as oledbcommand
myconnection = new oledbconnection(ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_csrdb"))
strsql ="SELECT tbl_case.Case_id, tbl_case.Title, tbl_case.Description, Tbl_Country.Country_Name, tbl_principle.Principle_Name," _
& "tbl_keyword.Keyword FROM tbl_keyword INNER JOIN ((tbl_principle INNER JOIN (Tbl_Country INNER JOIN tbl_case ON Tbl_Country.Country_Id
tbl_case.country) ON tbl_principle.Principle_ID = tbl_case.Principle) INNER JOIN tbl_Usedkeywords ON tbl_case.Case_id
= tbl_Usedkeywords.case) ON tbl_keyword.Keyword_id = tbl_Usedkeywords.keyword " _
& "WHERE "
if DLPrinciple.selectedindex=0 then
strsql = strsql & "((tbl_principle.Principle_Name) like '%')"
else
if DLCountry.Selectedindex=0 then
strsql = strsql & "((tbl_country.country_Name) like '%')"
else
if DLKeyword.selectedindex=0 then
strsql = strsql & "((tbl_keyword.Keyword) like '%')"
else
strsql = strsql & "((tbl_principle.principle_Name) = '" & session("infoprinciple") & "')" + "((tbl_country.country_Name) = '" & session("infoland") & "')" + "((tbl_keyword.keyword) = '" & session("infokeyword") & "')"
end if
end if
end if

This is working perfectly with only one dropdownlist but I can not figure out how to make it work with several.

View 14 Replies

DataSource Controls :: Simulating Many Users To Test Search Query?

Feb 28, 2010

I'm developing an ASP.NET application which has allows users to search for other users based on their name. This search is done using Linq to SQL. At the moment, I've only got 10 or so users in my database, so I can't really test the efficiency of my search query. I'm new to testing and such, but what is the best way to simulate 100/1000/10000 users on a query? Is there a tool (preferably free) that would allow me to perform tests to see how quickly the database can be searched if it had x number of users?

View 1 Replies

DataSource Controls :: Prevent Injection On Search Query From TextBox Control?

Jun 1, 2010

I've been reading up on SQL Injection and want to go back and implement some measures to prevent these kinds of potential attacks.For example, on our company intranet, we have an address book feature and a search function so the user is able to look a company or a person up from the database/The user will enter their query into a TextBox control and click the Submit button, calling the following function:addybookDS1.SelectCommand = "SELECT * FROM [addressbook] WHERE COMPANY LIKE '%" + search1 + "%' OR CONTACT LIKE '%" + search1 + "%' OR LASTNAME LIKE '%" + search1 + "%' OR EMAIL LIKE '%" + search1 + "%'"search1 is the TextBox controlI had previously implemented this measure:search1 = Replace(search1, "'", "''")But I want to know if there is more I can do here and how I can go about doing it.

View 16 Replies

DataSource Controls :: Query To Search "non - English Characters" With Column

Apr 29, 2010

I am using this code to find titles depending on user criteria:

[Code]....

The search is non-english charachters, and it has some problems. when you looks for "Marker" and in database you have this title: "Markers" it won't find it..... This search just not good enough and I am looking to replace it urgently....

View 6 Replies

DataSource Controls :: Word Search In Sql Server Without Full Text Search On Particular Column?

Jan 27, 2010

I want a word search i doing the search like this , but it is giving character wherever there is in the string,if i give two character like ok it is searching for a full string where ever Ok is there select * from table1 where textfield like '%word%' this query would match word but also wordabc how can i make it aware of delimitions

View 3 Replies

DataSource Controls :: Full Text Search -- How To Search Image

Mar 29, 2010

I am using SQL Server 2008 and Full Text search.

Its working fine for PDF / doc files but not working for .JPG files.

Basically i have some document scanned and stored it in varbinnary datatype in DB.

I am able to search for .doc /.xml /.pdf files .. but not able to search .jpg.

also i am not getting ".jgp" extension in result of following query

SELECT document_type, version, manufacturer
FROM sys.fulltext_document_types order by document_type

View 1 Replies

DataSource Controls :: How To Parse Normal Search Text To Sql Server Full Text Search String

Feb 13, 2010

How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.

View 1 Replies

DataSource Controls :: Search In A Database - Make A TEXTBOX And A Button "Search"?

Jan 18, 2010

now have tried to locate and find anything about how to make a

TEXTBOX and A Button "Search"

Problem is that I have made this "bellow" and when I then enter a "value" into texbox2 and hit enter on the button it wont show me the "emnenummer" that I have requested.

im not even sure this is the correct way to do a "search"

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><asp:Button ID="Button1"
runat="server" Text="Button" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"[code]....

View 3 Replies

DataSource Controls :: SqlDataSource And Parameters Query / Trying To Accomplish Is Building Dynamic Query

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

DataSource Controls :: Update Query Not Working When Using Query Builder To Configure Table Adapter

Jan 15, 2010

[code]...

This query works perfectly on the query analyser.

But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.

What could I be getting wrong in this case.

NB:Existing GalleryID has been supplied.

View 1 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

DataSource Controls :: How To Convert Sql Query Into Linq Query

Mar 10, 2010

select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid

View 5 Replies

DataSource Controls :: Accessing FK From A Query Via Entity Query

Jan 21, 2010

I've got a query such as

Dim MediaQuery =
From m
In dB.DOWNLOADS _Where m.ID = id _Select

which returns a record from the database. One of the fields in the record is a FK to another table. I need to read this value to be able to set a dropdown based on the ID but I can't work out how to access it. For a standard record I can just do the following txtTitle.Text = MediaQuery.FirstOrDefault().TITLE

However with the foreign key it doesn't work like that. I've tried drpGroup.SelectedIndex = MediaQuery.FirstOrDefault().DOWNLOAD_GROUPS.ID where DOWNLOAD_GROUPS is the FK field but it returns Object reference not set to an instance of an object. If you're simply wanting to read some values from a single db record in the entitiy framework and one is a foreign key how should I go about getting the value?

View 2 Replies

Data Controls :: Redirect To Another Page With Search TextBox Value In Query String

May 7, 2015

How Can Redirect Search TextBox  Value to default page On Search Button Click Asp.net..Here is my Code

div>
<asp:TextBox ID="TextBox1" runat="server" Height="37px" Width="526px" style="background-color: #CCFFFF"></asp:TextBox>
<asp:Button ID="btnsearch" runat="server" placeholder="Search By Brand Name" Text="Search" OnClick="btnsearch_Click" Style="font-weight: 700; color: #0000CC; background-color: #FF6600;" Height="39px" Width="108px" />
<asp:Label ID="Label4" runat="server" Text=""></asp:Label>
</div>
 
I Have A TextBox for Search Box And A button On My About Us Page ...i want to redirect The Search Box Value On default Page With Search Data from My Datalist That is belongs to Default Page.When I Click On Search Button The Value of Search Box Redirect To Default Page And Show value Data from Datalist 

View 1 Replies

How To Use PDF Generator And Chart Generator

Dec 21, 2010

know which is the best PDF generator I can use in ASP.NET.

I also need a library which allows me to draw charts.

I need this libraries to be free. tell me which ones do you use.

View 2 Replies

Forms Data Controls :: Displaying Search Results From A Query String Into A Listview?

Jan 21, 2010

I'm working on a job seeking website where the job seeker can search for a job , the search box is located in the master page, that's why i passed the keywords as a query string, and then the matching jobs will be displayed in a listview.

the keywords will be taken from two controls: a drop down list which the user can choose the location of the job, and a text box where he can type a keyword.

the select command of the sqlDataSource of the data list is as the following:

[code]....

View 4 Replies

Forms Data Controls :: Search - Create A Dynamic Query According To Selected Conditions

Jul 1, 2010

I want to create a search form for a table that has many columns. According to input criteria the query will have a where with conditions related to the columns selected or NONE. How can I create a dynamic query according to selected conditions ? is there an example on the net that I can use?

View 2 Replies

DataSource Controls :: Keyword Search In Sql?

Feb 9, 2010

In one of my column have a comma separated list of keywords.I have to build a query that will return the matching rows whenever user enters the keyword.for ex.if my keywords are java,.net,sql,php,ajax then on search of java OR java,sql OR php,java should return the above row.

View 5 Replies

DataSource Controls :: Search By DateTime In SQL?

Feb 12, 2010

I want to use a TextBox with the Ajax Toolkit Calender Extender as a control to return all activities on a particular date regardless of what time they are at into a GridView.I don't understand how to set up the SQL Statement to properly do this. If it helps here is my current SQL statement

[Code]....

View 2 Replies

DataSource Controls :: How To Search Through A Database Column C#

May 11, 2010

How to search through a Database column C# and display only what you want like a number 2 in a Gridview ..

View 12 Replies

DataSource Controls :: How To Program A Search Function

Jan 25, 2010

I'm on training in a company and i'm making a web application with an SQL server database..Now I created everything but i need to know how to program a search function..t's the point that when I search to a computer it'll put all the pc's with the matching word into the dropdownlist..Like when you search for "A" I get all the pc's wich has an 'A' in their name, I made everything, in the query builder I made a parameter with the textbox but i need not EXACT the value I typed but verything wich has it in it.

View 6 Replies

DataSource Controls :: How To Search For Any Input Word In Db

Jun 9, 2010

I need to have search form in my web app . I want visitor input text in textbox control and when he click on Search button it check DB table for his input text.

I dould like if user input "Windows 7" and I have the sentence in DB Records as "My be Some Windows Generation .." it list this record.

in other word I want to search for any word that users entered in DB.

Could any one tell me efficient way instead of split input text to words and then execute search query per word?

View 3 Replies

DataSource Controls :: Using LoginName As A Search Parameter?

Feb 23, 2010

Im working on my Dissertation and am seriously stuck. Im creating a blogging site with the ability to log in, this will also include the ability to search for projects etc. (created in Visual Studio in VB)

There are different roles: Student, admin, tutor. the table is made up of 2 tables aspnetdb.mdf and blogging.accdb; the first was created by visual studio and the later is mine that contains the projects, bloggs etc.

I want to use the asp:loginName in a search that is sourcing its data from the blogging database, Iv tried for days to do it myself, by trying to write an inner join manually, using its full name etc but keep coming up against a brick wall.

View 1 Replies

DataSource Controls :: Making A Search From Several Tables?

Mar 16, 2011

I have a searchbox where i ask for information to a table, but i want to rewrite the code so i can search from several tables.

Here is my temporary select command which works great when using only one table:

[Code]....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved