I have one query in my project (saved in folder SQLQueryes, Query.sql) and i need to execute it. Also, i have one parameter in script and i need to include him also. How?
View 8 Replies
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.
[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.
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 Repliesselect Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesI'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?
I have a parent repeater that lists the sections of the website. this repeater binds to display a table that contain another repeater of the website pages .. or may display a table that contains another two repeaters of the projects categories and sub-categories.Until now everything is going fine.
The problem comes when I try to include a query of the section ID to the link of the project categories (DataView of the projects repeaters does not contain SectionID)my question is : is there any way to call the SectionID of the first repeater in my projects categories and sub-categories repeaters?Here is my code:
[Code]....
the code behind is as follow:
[Code]....
I'm trying to use BLL and DAL in my asp.net web application in vs2008. But I have lots of problems doing it. My application cant find clasess from BLL, also when I changed build action of my classes into 'compile' my bll classes cant see Table Adapters from DAL. I dont know where is the problem. Does it mean I can use this solution just for web site projects?
View 2 RepliesI've created a Data Base project with some CLR functions and stored procedures.
I'd like to deploy the assembly under different schema then the default dbo.
Is it possible?
I'm trying to return the largest payment and that payments payment date and the project it was posted too, for each clientID. I can get the largest payment using the statement below, but I cannot get the payment date and project name. If the client made payment of the same amount to more than one project I get multiple client rows, but only want one row for each client.
[Code]...
Im trying to add a database to the project, and he following error appears. (Im using VB2008)
Local database file
A network-related or intance-specific error occured while establishing a connection to sql express.
The server was not found or was no accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections. (provider: Shared Memory Provider, error 40- Could not open a connection to SQL server.
I am using Querystring "ddl4" to pass on value of a drop down list to the next page where I am using that value in the WHERE clause of a SQL command. I also need to check whether ddl4 is blank or not which I do using If Else in SQL command. I am not able to run the query where the Querystring ddl4 IS NULL
This is the sample link with the Querystring ddl4 carrying a blank value:
[code]....
Ok, I have some experience, but I have always started with something and moved on from there.
I want to create a ASP.net Project in MSVC 2008 with the following...
- SQL 2005 database that I can use MSQL Server Management Studio with
- Forms authentication
- Authentication/roles etc is stored in the above database
So far every attempt has resulted in a database that when I attach with MSQL Management Studio I am logged in as guest, and thus can't do much.
SQL Query with IF and Select
View 2 Repliesif there is no relation bettwenn two tables why do i need union for example like below Please
can u inform me
SELECT categoryId
FROM categories
UNION
SELECT shipperId
FROM shippers
I´m using Linq to Sql in my asp.net application, but the problem is:I have a query like this:
[Code]....
My query is not returning anything, how do I do to get this?my problem is with this interval I need to have.
i want to know that should first name and last should be kept as sperate field or merged into single attribute. The Basic problem i am facing to keep first name and last name in seperate fields is that i cannot effectively use like query for searching a record by name
View 7 RepliesI have table in database with xml field and data like below
[Code]....
there are no records found
How do I use a Parentheses in an SQL query, example:
SET [myrow] = 'New Value' WHERE [myrow] = 'my (old) value'
I'm creating a web project in ASP.NET (C#) using Visual Studio 2010. I'm using the built-in login page. Here is what I'm trying to achieve.I want when a user logs in, the default.aspx page will display all his information including firstname, lastname, email address... I created a database table to store all users information (SQL). I want to use the "login name" as a parameter in "SELECT * FROM usertable WHERE username = loginname". From the code-behind (default.aspx.cs) I can pull the current loginname with "this.User.Identity.Name" but I can't pass this information to the query command in the default.aspx page.For example, when Jim logs in with his user name as "sirjim", I want to use"sirjim" in place of "loginname" in default.aspx page.Code in default.aspx page:
<asp:GridView
ID="GridView1"
runat="server"
[code]...
Hregarding to following query:
Use AdventureWorks
Go
ELECT p.ProductID,
piy.ProductID
What does mean ON 1 = 1 in this query??
I have 2 tables table1 and table2 as given below.
Table1 - user master table. table2 - transaction table. Now I want to write a single query which will give results like table 3. how to write single query.
TABLE 1
TABLE 2
TABLE 3
USER ID
[Code]....
I have several dropdowns in ASP.net, I want the contents in each dropdown depending on what is selected from the above dropdown and the datasource queries reflect this. I have the queries correct for the first two dropdowns, but I cannot get the third displaying data.
The first dropdown just contains all dept names
The second dropdown contains the manager names in that chosen dept above
The third is meant to contain the list employees relating to the chosen manager name above
<asp:Label ID="Label1" runat="server" Text="Cost Centre:" Font-Bold="True"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList_CostCentres" runat="server" Height="21px"[code]....
I am having some trouble querying a SQL Express DB from my ASP.NET 3.5 application. I am new to ASP.NET 3.5, only having used ASP in the past.In ASP, my code would be:
Dim db
Set db = Server.CreateObject("ADODB.connection")
'Opens the db connection string stored in another asp webform [code]....
This code creates the connection to the database, assigns the variable SQLi with the query, and assigns the execute command for that query to the variable RSi.
In ASP.NET, I have managed to get this far:
'The connection string is stored in web.config [code].....
I am unsure how to do the next part, when the individual id is assigned to the variable GEN1i (the syntax .fields does not appear to work for me).
Everytime I try to create a new sql 2005 server project I get this error. Then after I hit ok VS 2010 crashes.
Could not load file or assembly 'System.Data.SqlServerCe, Version 3.5.1.0, Culture=neutrail, PublicKeyToke=89845dcd908080cc91' or one of it dependencies. The system cannot find the file specified
