I have the following code which writes to a Gridview:
[Code]....
Using the same methods of connecting to the database, how can I amend this code to write the result of a second query (which only returns a number) to a label?
I want to populate a label with the employees name when they enter a badge number in the source page but im new to programming and don't know how to tackle this. The database connection has been established and it is successful. just an fyi this is for a time sheet application.
string Badge = "100000" + Request.Form["xBadgeTextBox"];
string Date = Request.Form["xWeekDropDownBox"];
string Hours = Request.Form["xWlengthDropDownBox"];
if (Badge != null)
{
string cmdquery = "SELECT EMPLOYEE_NAME FROM Employees WHERE Badge ='" + Badge + "'";
OracleCommand cmd = new OracleCommand(cmdquery);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
}
sql_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 = ?
i have a form that my i use to look up whether or not there is an email address in the database. i wrote a query with this basic structure:
select *
from table A, table B
where table A.email = "email" or table b = "email"
i though that would return all instances that the email occurred in either table. what i am getting back is a bunch of null or other unrelated records from table A with a matching email in table B. the thing is, these two tables primary key to join them. i thought i wouldnt need to do that though in this case.
here is the actually query i am using if it makes things more clear:
select lm.cemailaddr, lm.b1emailadd, b.emailaddr
When I run select *from sysfiles it gives below result.
fileid groupid size maxsize growth status perf
------ ------- ----------- ----------- ----------- ----------- -----------
1 1 1463328 -1 128 2 0
2 0 270120 -1 10 1048642 0
i need record with id 1 and 3 only how do i get in sql server 2005.(means distinct empcod onl.
View 3 RepliesI have a table with columns A and B, values as follows..
A B
-- --
1 11
1 12
1 13
2 21
2 22
2 23
How do i generate another computed column that will contail the result of GrandTotal/Total,
where GrandTotal is another value comes from computed column and the Total would be the sum of the Total within SchedularID.
And thats what i have done so far: [Code]....
Need to figure out the correct way to do a simple SUM function in Linq, but also manipulate one of the feilds coming back by doing a Substring on it, here is the original SQL query:
[Code]....
i have a table for customer forecast with following fields.. customer, year, week, quantity. now i need to write the SP to retrive the records based on the from week,year and to week,year... like this... from 45th week of 2009 to 25th week of 2010. how can write the query...
View 4 Replieshow do i write my alter schema query in Asp.net
using the sqlclient object..
I have couple of DDL's which let user choose couple of different values from it. Once the user has made his selection he clicks on the "Submit" buttion which redirects the user to the other page, which then displays table from backend SQL DB. The pages are named Page1.aspx and Page2.aspx resp. I am using Querystring to carry forward the values of the DDL's to Page2.aspx.
How can i modify the query in such a way that even if one of the DDL's is left blank the Query would ignore that and shall produce the table considering value of DDL2 in the where clause. In case both the DDL's are empty then the query will not have a where clause and shall showcase the complete table as such. I've written a query for this but it's not working the way it shoul.Here is my code for the SQLDataSource: [Code]....
How to write select query to get counts in row values
View 6 RepliesI 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 have a table for customer forecast which contains customer, week number and quantit as columns. now i need to write query and list the week as column for each customer and each cell should have a quantity. how to write query for this using pivot logic. i dont want to use cursor.
View 3 RepliesI want to write the query for finding second highest salary in my employee table how to find it??
View 3 RepliesI have a Dynamic Data Website that I created after watching the video tutorials on this website (I'm new to programming, but not computers).I have a SQL Table named 'Adult' that has a 'DOB' column. I would like to add an asp:label to the Default.aspx that does a LINQ to SQL query to determine if it's someones birthday today and if so display their name and age.
View 5 RepliesFor context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
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 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
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
I have a label inside a formview that is not bound to anything.
Lets say I have a table of customers (with a key field called CustomerID), and then another table that has all their orders (with amount spent per order (OrderID) - based on CustomerID)
On the FormView there is a key field (CustomerID) (this is to be used as an INPUT parameter to a SP - which is to return the SUM of all the customers (Order_Totals). I could nest a view within a view I suppose to get this result, however, I just want a label to simply show this ScalarValue.
Basically, I want the label to show the aggregate (SUM) total amount each customer has spent on all orders. I have a SP called SumCost with two Fields (one a grouped by field CustomerID and the other a Summed Total of each customer's orders SumCost)
SELECT [SumCost] FROM [SumCost] WHERE ([CustomerID] = @CustomerID)
I test my SP and it works great, returning the value based on CustomerID - no problem.
My problem is getting the CustomerID passed into the SP on runtime (do I put it in FormView2_Databound) and putting the value into the label (CustTotalLbl) which is inside this form.
i have asp page. i did the connection with connection string. the query is to search name, id and phone numbers. i wand to display these data in 3 textboxs. how can i display these results in textbox.
this is the connection code.
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
con.ConnectionString = "server=localhost;uid=sa;pwd=sa;database=mydatabase";
cmd.CommandText = "select ename, id phone from emp";
now i want to display these data in 3 textboxs. how can i do it.
In my asp.net gridview i want to count how much peoples are qualified in MCA Â and display the value in a lbel in same page. The qualifications are in COURSE field in my table anme persadata
table name is PERSDATA
PNO Â Â NAME Â Â Â Â Â Â COURSE Â COMPANY
121 Â Â Â RAJU Â Â Â Â Â Â BCA Â Â Â Â Â TCS
234 Â Â Â RK SINGH Â Â MCA Â Â Â Â Â Â TECHNO
525 Â Â Â P RAJ Â Â Â Â Â Â MCA Â Â Â Â Â Â KELTRON
325 Â Â Â ANIL Â Â Â Â Â Â BBA Â Â Â Â Â Â BPL
235 Â Â Â KUMAR Â Â Â Â Â MCA Â Â Â Â Â Â TATA
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]....