DataSource Controls :: Failed To Create Custom Statement In Query Builder?

Mar 2, 2011

i faced a problem during i want to create inner join in query builder.

Here is my statement

[Code]....

If i select 2 tables, i can get the result. But when i insert 1 more table, i failed to get my result.

View 4 Replies


Similar Messages:

DataSource Controls :: How To Create An Insert Statement For Two Tables In One Query

Apr 1, 2010

i have a form view that takes fields from two tables 'Contract' and 'volunteers', however because i used a query builder,i have to input an insert statement. How do i create an insert statement for two tables in one query?

View 4 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 :: Using Visual Studio 2008 Query Builder And Am Trying To Pass A Value To A Parameter That Uses The IN OPERATOR?

Jun 3, 2010

I'm using Visual Studio 2008 Query Builder and am trying to pass a value to a parameter that uses the IN OPERATOR.Here is my sql from qb:

SELECT COURSE_TITLE, INSTR_NAME, ADMIN_UNIT
FROM vwHRIC_EC_ContractSummary
WHERE (ADMIN_UNIT IN (@ADMIN_UNIT))

The trouble I am having is that if the parameter @ADMIN_UNIT contains more than one value such as (8X, CV) that the query doesn't return any data. If I run the same query with only one value such as (8X) it works fine.I have tried different formats like (8X, CV), ('8X', 'CV'), (8X; CV) but none have worked.I ran this same query in SQL Server Management Studio and and it returns data no problem but can't get it to work in Query Builder for my aspx application.Does anyone have any experience with this problem and how did you correct it?

View 3 Replies

Forms Data Controls :: Query Working In Query Builder But Not In Webpage?

Jul 13, 2010

I'm encountering a strange problem. Here is the scenario. I have built a query that accepts a parameter (WHERE LIKE clause).

I've tested this within the query builder and it returns exactly the number I would expect.

I then go back to my webpage and add the following controls:

Dropdown

Gridview

the user to make a selection from the dropdown. Postback on the dropdown is enabled so the page reloads and the Gridview displays the filtered results (via an objectdatasource). I've set the parameter to the dropdown control.

The trouble is when I run the page I make the selection in the dropdown no results are displayed. Even though the text displayed in the dropdown control is exactly the same as I inputted into the query builder when testing it.

View 3 Replies

DataSource Controls :: Insert Query Statement?

Aug 16, 2010

I have SQL Details View insert statement, I need to have a Condition checked for the Insert Query. The condition is, I do have a table by name table1 with the No of Questions (for Eg: 10). The insert statement shud insert data to the table2 (Another table) only if the no of rows is less than or equal to 10 else it shud give me a message (It has exceeded the no of questions).

View 3 Replies

DataSource Controls :: SQL Select Statement - Values To Appear In Same Query

Feb 15, 2010

I am having difficulty selecting data from 2 tables that do no share a primary key value. For instance, I have an actual table, a forecast table, and a GLText table. I may have an actual value but not a forecast value but I need them to appear in the same Query (like the query results shown below). I can get all values to appear in each table but have been unsuccessful in getting all values from both tables.

View 5 Replies

Forms Data Controls :: How To Display Records After Going Through The Query Builder And Select "Test Query"

Nov 5, 2010

I have a SQL Data Source that displays records after going through the Query Builder and select "Test Query" yet when I save it, go back to the design mode and select View in Browser I get nothing but a blank screen.

View 3 Replies

DataSource Controls :: Use SQL GROUP BY Statement To Create Menu?

Jan 27, 2010

I'm trying to create a menu structure, subpages within pages, for use with my cms. I have 3 tables in sql server, I would like to query all three tables and list those pages with a certain siteid, and subpages where the subid is the pageid. how to use the GROUP BY Statement to create the menu below? Or could I use vb.net to display it for me? Something like this:

sitename
page
page
page
page
subpage
subpage
subpage
page
page

Here is my query so far:

SELECT * FROM sites
LEFT JOIN pages ON sites.siteid=pages.siteid
LEFT JOIN subpages ON pages.pageid=subpages.pageid
WHERE sites.siteID = 1ORDER BY sites.siteid, pages.pagesub ASC

These are my tables:

sites
siteID int Unchecked PK
siteName nvarchar(MAX) Checked
siteAdmin nvarchar(MAX) Checked
siteLive bit Checked
Pages

pageID int Unchecked PK
siteID int Checked FK linked to siteid in sites table
pageLink nvarchar(MAX) Checked
pageBody ntext Checked
pageSummary ntext Checked
pageTitle ntext Checked
pageOrder int Checked
pageHome bit Checked

subpages

subID int Unchecked PK
PageID int Checked FK linked to pageid in pages table
subBody ntext Checked
subSummary ntext Checked
subTitle nvarchar(MAX) Checked
subOrder nvarchar(MAX) Checked

View 2 Replies

Custom Server Controls :: How To Create Custom Property (DataSource) In Custom Controls

May 15, 2010

I know that how to create custom control and add custom property.

I want to create property like DataSource to my custom control.

View 1 Replies

DataSource Controls :: Create A Multi Column Listbox By Combining Fields In Linq Select Statement

Jan 11, 2010

I am trying to create a multi column listbox by combining fields in Linq select statement, as Let Name = Last + First. The problem is how to pad the Last column with spaces as you would in SQL using REPLICATE so when I bind the listbox to the data, it looks like two columns.

View 5 Replies

DataSource Controls :: How To Create A Query With Values From Calendar Control

Jan 18, 2010

What I want to do is create a parameterized query in the code behind with the parameters being values from the calendar control

I'm trying to modify the select command already declared in the sqldatasource so I think it should be something like

SqlDataSource2.SelectCommand = "SELECT * FROM Activities WHERE StartDate>@StartDate AND StartDate<@StartDate2"

but the main problem I am having is how to declare the value of @StartDate, I thought it would be simply calendarID.selecteddate but this doesn't seem to be right, I've tried different variations I've found in similar threads but can't get it right

I'm not sure if grouping my results is complicating matters but when I hard code dates in it works Ok so I don't think so

the code I was trying to get working is

Dim theFilter as String = "WHERE StartDate>@StartDate and StartDate<@StartDate2"
SqlDataSource2.SelectCommand= "SELECT DATENAME(month, StartDate) AS Expr1, YEAR(StartDate) AS Expr2, SUM(CGUPreSchool) AS Expr3, SUM(CGUPrimary) AS Expr4, SUM(CGUSecondary) AS Expr5, SUM(CGUYouth) AS Expr6, SUM(CGUAdult) AS Expr7 FROM Activities WHERE " & theFilter &
" GROUP BY YEAR(StartDate), DATENAME(month, StartDate)"

I am trying to build the filter part dynamically you see but can't get this right

View 3 Replies

DataSource Controls :: How To Create A Query In Gridview Selectcommand Without The Code Behind

Dec 1, 2010

how to query the system date in selectcommand in gridview without using the codebehind. using c# .net

my code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT * FROM tablename where date_today = <SYSTEMDATE>" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName
%>"

View 1 Replies

Visual Studio :: Maximize Query Builder - Window Is To Small ?

Jun 23, 2010

When i create a sql script in the Query Builder (going through the wizard in a DataSet) the Query Builder window is to small for me. Is there a way to maximize this window by default?PS, I have previously posted this in the forum "Visual Studio 2008.

View 2 Replies

ADO.NET :: Query Builder - Show Values Where Date Is Greater Than DateTime Now?

Oct 27, 2010

Visual Web Developer 2010 Express

ASP.Net and C#

My issue is that I am pulled three tables together using the Query Builder and I only want to show data where a specific date is greater than todays date. Here is what i have so far:

[Code]....

Where it says '2010-09-01 00:00:00' I want that to be the todays date.

Is this possible?

View 2 Replies

Building A Custom Form Builder Module For Customers?

Jul 20, 2010

I am working on building a custom form builder module for our customers ... and wondering if you know any good .NET code base references for this module.

Requirements:

Customer should be able to add a form field(radio button, text box, dropdown menu) and customize the values real time.

View 1 Replies

C# - Create XML String Instead Of Using Builder?

Mar 29, 2011

I am using the code below (simplified for this example) to post data to a SharePoint list

StringBuilder customerDoc = new StringBuilder();
customerDoc.Append("<Method ID='1' Cmd='New'>");
customerDoc.Append("<Field Name='Name'>" + Name + "</Field>");
customerDoc.Append("<Field Name='Age'>" + age + "</Field>");
customerDoc.Append("<Field Name='City'>" + city + "</Field>");
customerDoc.Append("<Field Name='Country'>" + country + "</Field>");
customerDoc.Append("</Method>");
XmlDocument xDoc = new XmlDocument();
XmlElement xBatch = xDoc.CreateElement("Batch");
xBatch.SetAttribute("OnError", "Continue");
xBatch.InnerXml = sb_method.ToString();
XmlNode xn_return = sharePoint.listsObj.UpdateListItems(ConfigurationManager.AppSettings["SaveCustomer"].ToString(), xBatch);

As you can see I am using a stringbuilder which isn't ideal so I wonder what I should use instead to create an XML string?

View 7 Replies

Create A Form Builder Without Using Any Of The Third Party Tools?

May 10, 2010

I need to create a form builder without using any of the third party tools. i.e a user shold be able to pick his choice of textbox, dropdown ..etc and create a form.

View 1 Replies

DataSource Controls :: Ckeck Sql Query Perform With Load By Using Tools For Create Load?

Feb 16, 2010

how to check performance of sql server query with load ,also wants to create load by any tolls like load runner,if any url for download load runner or any other tolls by which we can create load please give me some idea related to it.

View 1 Replies

DataSource Controls :: Getting Error : The Login Failed. Login Failed For User 'IIS APPPOOL V4.0'?

May 16, 2010

I am using SQLEXPRESS 2008 R2 and developing ASP.net 4 application. I am getting this error:

Cannot open database "mydbfile" requested by the login. The login failed.

Login failed for user 'IIS APPPOOLASP.NET v4.0'.

View 6 Replies

SQL Reporting :: Create A Multiple Optional Parameter In Report Builder?

Feb 24, 2011

I'm creating a reports with the following filter criteria:

ID - textbox Created Date - range between start and end date Syste Name - dropdown Users may filter the report based on the ID or System Name or all the criteria mentioned.

The search Field for ID, by default has a Null checkbox beside on it while other filter doesn't. how can I enable the checkbox for the other filters?

So I came across this article which should my issue. Apparently, I'm receiving a formula error "The arguments to the following functions are not valid:FIND" with this formula OR(FIND(Creation Date, Parameter: Creation Date)<>0, Parameter : Creation Date = Empty). see this link for the screenshot. I don't know what I'm missing. I'm using Reporting Services 2005

View 2 Replies

Custom Server Controls :: Case Statement Is Never Executing?

Aug 25, 2010

why the case statement is never running

[Code]....

[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 :: 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







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