i have the following select staement which deosnt work, can anyone advise me whats wrong with it:
string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;
i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?
SqlConnection
Conne=new
SqlConnection(); [code]....
Dim queryString As String = "SELECT Presenter_Assignment_.username, Presenter_Assignment_.FirstName, Presenter_Assignment_.LastName, Presenter_Assignment_.SchoolName, Presenter_Assignment_.SchoolTalk, Presenter_Assignment_.Dates, Presenter_Assignment_.Time
FROM Presenter_Assignment_ INNER JOIN UserInformation ON Presenter_Assignment_.username = UserInformation.username WHERE ('@username' = username)
When I run a page with this statement, it pops up an error saying 'Ambiguous Column Name 'username'. Why is this so? ._.
I have two drop down lists and a upload control. One dropdown allows my user to select a valid contract number, and the second dropdown is populated from a table that has 5 contract document types and id's.
after i use the dropdowns to select the information i want and select the file i want to upload based on that information, I press my upload button and get " Invalid column name 'ContractDocumentType'."
It is very possible that I have extra code in here that is not necessary as I have fixed several issues before this one, such as a convert varchar to int error.
What Contract Number Are These Documents Related To?
<asp:DropDownList ID="lstContractNumber" runat="server"
DataSourceID="dsdContractNumbers" DataTextField="ContractNumber"
DataValueField="ContractNumber">
</asp:DropDownList>
<asp:SqlDataSource ID="dsdContractNumbers" runat="server"
</table>
</asp:Content>
My code-behind (I edited out some stuff that is probably not needed here):
[Code]....
[Code]....
[Code]....
I want to select all the customers from "customers" table from a specific country. I write the following query but it is not working. why?
select *
From customers
where country = @country;[code]....
I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?
Where (p.Link_ID Like GridView5.?
[code]....
For example:
[Code]....
When I run this the error is 'Invalid column name 'assigned'.'Yet if I load up Microsoft sql server management studio and run the query against the same db:
[Code]....
I get the data I was expecting and the column does exist?
[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.
protected void Button19_Click(object sender, EventArgs e)
{
SqlDataSource conn = new SqlDataSource();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["Database2ConnectionString1"].ToString();
conn.SelectCommandType = SqlDataSourceCommandType.Text;
conn.SelectCommand = "SELECT FROM table1 (a, b)VALUES(@a,@b)";
conn.SelectParameters.Add("a",TextBox1.Text);
conn.SelectParameters.Add("b", TextBox2.Text);
int rowsAffected = 0;
try
{
rowsAffected = conn.Selectt();
}
catch (Exception)
{
Label1.Text = "Error";
}
finally {
conn = null;
}
if (rowsAffected != 0)
{
Label1.Text = "Data saved";
}
}
well it returns error no overloading method for select (P.S. same code work fine for insert)
I will declarate a attribute, but it gives me an error
This query works fine and returns 1 record from type int:
SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
And when I will declarate a attribute/parameter it gives me an error:
DECLARE @dataObjectVersionId INT
SET @dataObjectVersionId = SELECT TOP 1 DataObjectVersionID
FROM tblDataObjectVersionPropertyValueText
WHERE PropValue like CAST('00010281' AS ntext)
ORDER BY DataObjectVersionID DESC
Error message:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SELECT'.
SQL Query with IF and Select
View 2 Repliesin DataBase Attendancedate is save in this format 4/5/2010 4:16:28 PM ..i want to query like this select * from EmployeeAttendance where Attendancedate='4/5/2010' but this giv error
View 5 RepliesI need to write a select query where it will be doing "like" on one column with multiple strings.
Eg : Select * from tblCity where city like '%ABC%' and city like '%XYZ%'
I have set of strings.
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 RepliesI have an application that I am developing using ASP.Net with visual basic code. I have a table called "Customers" that contains 3 fields. The name of each field is "Name", "LocationA", and "LocationB". I want to code a select query that list two columns. The first column should contain the field "Name". I want the second column to contain the value in the field "LocationB" if "LocationB" is not null, else I want the second column to contain the value in the field "LocationA".
View 4 RepliesI have several methods where I return a SqlDataReader to populate Gridviews, Listview, etc. I get random "Timeout expired" errors regarding connection pooling, so I decided to add using{} to my methods. The lack of using is a carry over from my more beginner days.Below I included the before and after code. The after code always gives me the "Invalid attempt to call FieldCount when reader is closed" error. I have tried various combination of using{}, but ALL result in the same error.What am I doing wrong? Also, from the code below what is the best way to structure this code to ensure no connection leakage?Before:
[Code]....
After:
[Code]....
when i am executing xmlreader in enterprise library 4.1, iam getting an error like below
error: Invalid command sent to ExecuteXmlReader. The command must return an Xml result.
my code:
SqlDatabase
db = (
cmd = db.GetSqlStringCommand(
xmlReader = db.ExecuteXmlReader(cmd);
db = null;DbCommand cmd =
null;XmlReader xmlReader =
null;SqlDatabase)DatabaseFactory.CreateDatabase();"select
* from emp");DataSet ds = db.ExecuteDataSet(cmd);
I am looking to display the value of a column and divite it by 1.175and display only the result do you know how to adjust the value of a column through a select statement in SQL?
View 7 RepliesI have following tables.
Items
ItemId
ItemName
GroupId
CatId
1
Apple
5
6
2
Banana
5
6
3
Blackberry
5
6
4
Grapes
5
6
5
Guavas
5
6
6
Beans fresh
5
7
7
Bitter Gourd
5
7
8................
i have used one query like this
Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0%'
it is working fine. But while giving
Select skillReq from tblPostJobs where SkillReq like '%Silverlight 2.0,C#%'
It is not filtering data from database. It is only checking starting and ending Character.In my database some keyskill are like that
Asp.net 3.5,4.0,C#,Sql server 2008,Silverlight 2.0,3.0.
My requirement is to check each word in "SkillReq" text.
I have dropdownlist of dates and depending on the date that the user selects from list, I would like to filter records that fall between the startyear and finishyear columns in the datasource. (My the problem is that I do not know how to declare the Startyear and Endyear from the query in the code as they appear underlined - probably the BETWEEN syntax is wrong too).
yYear = DropDownList1.Text
Using connection As New SqlConnection("Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=TorGHL;Integrated Security=True")
Dim cmd As String
cmd = "SELECT BarDetails.*, MenuHeadingId AS Expr1 FROM BarDetails WHERE (MenuHeadingId = 2)" & "WHERE " & yYear & " BETWEEN " & "(" &
StartYear & ")" & " AND " & "(" & EndYear & ")"
connection.Open()
Dim dapubcb As New SqlDataAdapterDim sqlcomm
As
New SqlCommand(cmd, connection)
dapubcb.SelectCommand = sqlcomm
Dim dspubcb As New DataSet("BarDetails")
dapubcb.Fill(dspubcb, "BarDetails")
I want to create an application where I need to enter date to the ms access database.
I am a bit confused regarding how to make the user to enter date. The options avaliable are:
a. Shall I use a textBox?
b. Shall I go for 3 drop down lists?
or something else.
Some more questions:
1. what date format shall i use? (dd-mm-yyyy, dd-mmm-yyyy, etc, etc or anything else)
2. What datatype shall i use to store the date in the database?
3. What SQL query shall i use to retrieve the data between 2 dates?
let me know if there are multiple options available regarding this application.
I want to make this application as easy as possible for the user.
How to write select query to get counts in row values
View 6 RepliesI have a stored procedure where i am creating a run time query.
Stored procdure compiled successfully. But when parameter is passed its have an error.
[code]....
Its have a Error like this.
Invalid format specification: '% (RTRIM(LTRIM(baln))) % '.'.
when i am trying to execute it with bold parameter.
exec USP_GetRedemptionBYPlayer 'baln',null,null,null
Mmy data table has four columns. How can I get only selected columns name?
View 5 Replies