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
Similar Messages:
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
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
May 19, 2010
how can i set the parameter source of an SqlDataSource to a variable from visual studio?
View 2 Replies
Jul 23, 2012
I have an ASP.NET VB website in which I am using the Membership functionality to authenticate users. I am doing this through the Login control on the HTML page. I have working that it will authenticate the user and then opens a welcome screen in which I have a button they can push to open a Reports.aspx page. On that page I have a dropdown box that is being populated from a datasource connection query to my SQL Server database table. It is a hard coded query but want it to query the table off the username text value that the user provided on the login (i.e. select <something> from inventory where username = <username>). I have not behind code but only HTML at this point. Here it is ...
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Login.aspx.vb" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] .....
Here is the Reports form that has the dropdown on it:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Report.aspx.vb" Inherits="Report" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] .....
View 1 Replies
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
Jan 16, 2010
Which version of Visual Studio 2008 do you currently use with NHibernate? I would like to test out NHibernate at home, but I'm not sure if I want to shell out $500 plus for VS 2008 professional edition. Has anyone had any luck with NHibernate on VS 2008 standard or even one of the VS express editions?
View 4 Replies
Jan 28, 2010
i just cant install VWD2008.But heres the thing, i have had it installed before along side VWD2010 about a 5 weeks ago.After download everything is ticked and says ok, after i exit, it cant be found, its really starting to drive me nuts and take my life over
View 3 Replies
Apr 7, 2010
How do I specify a port number for a Data Connection in the Server Explorer of Visual Studio 2008. It would use 1433 as a default but the administrators changed it for security purposes.
View 2 Replies
Jul 11, 2010
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.
View 1 Replies
Apr 11, 2010
I created and populated a database inside Visual Studio 2008 instead of using Management Studio.I need to run the script to create the schema for users and roles.The database does not show up in ASP.NET SQL Server Setup Wizard or in Management StudioThe only databases that do show up are master, model, msdb, and tempdb
Is there anything I can do to fix this or would it be easier for me to just create a new database starting in Management Studio and then connect to it from within Visual Studio?
View 4 Replies
Feb 2, 2010
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
View 2 Replies
Jan 6, 2010
Is there any tool for Visual Studio 2008 which can reformat ASPX code to make it more presentable (eg insert line breaks, format the lines so they wrap when necessary, etc)?
View 5 Replies
Dec 11, 2010
I would like to create my reports by drawing out the data from the database.After creating my template (what would be in my report) and saving it as the .rdlc format, what should i do next do preview the actual data, or to present it in my asp.net pages.
I like the way how report builder works as it can export to pdf/excel, however its a standalone. Is there any way to make it similar in microsoft visual studio 2010 professional?
View 4 Replies
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
Aug 14, 2010
is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
View 2 Replies
May 21, 2010
Anyone know if I can maintain a VS 2008 (.net 3.5) project by using the VS 2010 IDE ?
View 1 Replies
Mar 25, 2010
Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?
I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.
View 11 Replies
Apr 22, 2010
I am getting return some data through stored procedure in a asp.net 3.5. Below is the method.
public DataSet GetDataSet(string strConnection,string strSPName, string param1)
{
DataSet ds = dataAccessLayer.getDataSet(strConnection, strSPName);
return ds;
}
In some cases, I have to pass 3-4 parameter. How can we do pass optional parameter here....
View 3 Replies
Sep 23, 2010
I'm trying to pass default value to a sql parameter which is
[Code]....
View 1 Replies
Sep 11, 2010
i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database
View 1 Replies
Feb 17, 2010
how can i pass a session variable in a C# web form to a stored procedure..?
View 1 Replies
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
Jan 20, 2010
can Visual Studio 2008 be All-In-One tool to integrate source code continuously from team members, build, unit test?
Having used Visual Studio Team Edition 2005, unit testing each method within VS itself. I strongly believe that it is feasible to add-on tools. Example ankhsvn tool to use SVN from Visual studio [URL]
In my investigating i have come across number of tools(shown below) to use with Visual Studio 2008 professional
Development tool:- Visual Studio 2008 professional using Subversion as source control tool. Continuous Integration:- Hudson or Cruise control Build tool:- NAnt Testing:- NUnit, Selinium As Visual Studio 2008 can be used for unit testing I think NUnit is out of consideration.
In the same way i would like to have any other tools/add-ons to Visual studio to implement continuous integration, building and unit testing. This process should be automated such a way source code between team members is continuously integrated, built and unit testing is done as configured.
Objective is to use few number of tools as add-on to Visual Studio or achieve most from Visual studio itself (example unit testing). Visual Studio should be all in one tool.
I am aware that Team Foundation Server best suits my requirement, but it is out of scope due to its cost.
View 3 Replies
Feb 14, 2011
I tried to develop a dynamic pivot query with following code to avoid hard coding. I can got the 'Q1, Q2, Q3, Q4' dynamically and assigned to @(@quarter. But it cannot be passed to the pivot query.
[Code]....
View 7 Replies
