And I realise that a user/member can have mutlple roles.HOW Can I do a select SQL query that returns the result set like this (SQL 2005)
SELECT Roles FROM <tbl>
WHERE UserID = <GUID>
AND Roles IN ('AA','CC')
I'm using a very simple Ldap query in my asp.net mvc 2.0 site:
String ldapPath = ConfigReader.LdapPath;
String emailAddress = null;
try
{
[code]....
I'm running it under the default app pool.
How can I SELECT second if first SELECT returns nothing?
View 8 RepliesI've created a script that adds user data to a database, however, I'd like to check the email entered is unique within the database.
I've already started the query at comm2 but not sure how to progress the script so it tells the user if the email address is already taken.
[code]....
i need record with id 1 and 3 only how do i get in sql server 2005.(means distinct empcod onl.
View 3 Repliessql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IarUN & "'"
'Step Three is Creating Connection Object and opening the database
'Add Error Trapping Later
con = Server.CreateObject("ADODB.Connection")
con.Open(data_source)
'Step 4 is to Execute the SQL Command
con.Execute(sql_select)
'Step 5 Done. Close the connection
con.Close()
con = Nothing
This works fine, but I want the returned id (which I will right code to make sure it is not null and that it is only one returned) to show up as a label (or the text of a label)
lblShowNEWUserauID.Text = ?
In my data table i have a Date Column with of type DateTime.
In my sql select query, I want to return all records where the date is today.
This query does not return any record
[code]....
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
I have the aspnet membership on my own sql database, I am trying to add the user's first and last name into my sql select query. How can I do it?
View 3 Repliesprotected 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 am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
i have tow query in one stored procedure
first query and the second one every of them return only value
i want to copy the result of tow values in a new row in new table
as i want to check on this tow values in ado.net
i want to get only this tow values as a row not first and secon query
only a row has result of first and second query results
[Code]....
I have an ASP.NET multiline textbox. I can hit return to create carriage returns on the screen but the text property of the textbox is ignoring the carriage returns and simply concatenating the lines without even a space in between. I am writing this text property to a database and I want to be able to retrieve the text exactly as it was typed with carriage returns included.
View 2 RepliesI'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
View 4 RepliesI am using this code to get th ProcessID of newly Created Excel.
Code:
Imports Microsoft.VisualBasic
Imports Microsoft.Office.Interop
Public Class Class1
[code]....
This code returns the Process ID Correctly with Virtual Server. Now I deployed it using a Website, and the ProcessID is 0
I use the follwoing code to get a value from the SQL query. But now i would like to use some sql function like Sum() count() ... and i would like to get the result of that.
vb Code:
Dim constg As New SqlConnection
constg.ConnectionString = "Data Source=m......."
constg.Open()
Dim payrollquery As String '= ("SELECT * FROM xxxxx.nnnnn WHERE ID IN(" & ID & " ) AND sent = 'U' ")
Dim cmd3 As New SqlCommand(sqlstr, constg)
Dim reader As SqlDataReader = cmd3.ExecuteReader
have gridview in my asp.net webform, and if i select rowafter the database is refreshed i see the ID correct.but when i run any query on the data and i see for example 4 rowsand i select one row i see wrong IDi use this for select row: ID = GridView1.SelectedRow.Cells[1].Text;
View 1 RepliesWhen stepping through my LINQ query it returns dataq,but when I try to return it as Json Result,I get the error 'The query results cannot be enumerated more than once'.
Here is my LINQ and stored proc,
[Code]...
i need to make 2 funtions on an ASP.NET c# page working with an SQL server (using Visual Web Developer 2010 Express) the 1st one is a simple serach and i've done the 2nd thing is an update , the sp is like:(it works in SQL)
UPDATE [lens] SET [qty] = @b+@c WHERE [id] = @a
@a is the id which user input in the textbox1
@b is an number user input in the textbox2
now @c should be the result of an query "select [qty] from [lens] where [id] = @a"
so ,the new value of [qty] will be the "old valus"+"valus in textbox2"
I'm trying to use SemWeb library to make my SPARQL queries on an remote SPARQL endpoint.
this is what i'm using fort testing, since this is an example that came with Semweb
SparqlHttpSource source = new SparqlHttpSource("my_endpoint");
source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", new SparqlXmlQuerySink(Console.Out));
Now, what happens is that my query isn't returning xml, but javascript, how do i know that?
using this simpler example:
SparqlHttpSource source = new SparqlHttpSource("my_endpoint");
source.RunSparqlQuery("SELECT * WHERE {?entity dcterms:title 'someentity' }", Console.Out);
So my question is, how do i tell semweb to get my results in xml format?
How come my query returns 0 records?
SELECT WebSiteID, BanDate
FROM tblWebSite
WHERE (BanDate <> NULL)
The BanDate is a date column. There are date times through the table in this column. I just want the ones with a date and ignore the rest.
I am trying to figure out why this service does not return any data. The service does not error out is just doesn't return any data. When I take the Linq into LinqPad the query returns exactly as I expect. So I am wondering if the problem is getting my return data into a List<string>??
[Code]....
I don't know what else to say to help. When I set a break point on the "return LoanStats" line a quick watch shows an empty results view.
I want to export the sql query result to excel workbook. Diffrent query results in diffrent work sheets but in a same excel sheet.
View 3 Replies