i would like to query out the next record and previous record guid from the current record guid.But i don't want to use the ID + 1 or ID - 1 because the ID is not secure for query like this. I am using MS SQL.
May i know how can i write the sql query?
If I have records in a table in this order:
Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0
Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?
I am using paging to my gridview (pagesize=4) . now i am in (X) page and i want to get (X+1) page top record or (X-1)page bottom record , how i can get .
View 2 Repliesi want to select three records order by Date .This is my News table.
NewID NewTitle NewContent NewDate
1 Example ExampleContent 01.12.2010
2 Example2 ExampleContent2 02.12.2010
3 Example3 ExampleContent3 03.12.2010
4 Example4 ExampleContent4 04.12.2010
So,query selects example4,example3 and example2.
Im new to Crystal reports. I need to make a statement in which three columns are displayed.Debit, Credit and Balance.
something like:
Debit Credit Balance
3605241
51613 3656854
7599 3664453
3398 3661055
I just have top Balance amout in DB which is 3605241. now I have to display the updated balance After debit or credit. I want to get the Previous Balance amount for addition/subtraction.How can I do it using Formula field?
I have a Listview binded with a ObjectDataScource and a div to display a record's details on a page. Outside the Listview and div I have Previous/Next buttons on the same page. I want to click the button to display Previous/Next buttons in the Div. How can this be done? I use onItemcommand to trigge each record to be deplayed in Div.
View 2 RepliesI am using Jquery and Ajax to add new record into the database. After successfully insert the record, I want the listview I have to automatically append the previous added record.
The record can be added successfuly into the database and the only problem is I want them to be display in my listview after I click submit button. So is there any solution for this?
Below is my code:
[Code]....
[Code]....
[Code]....
[Code]....
I have a search page. If a user enter something into title textbox and search let say it display 15 records.
If click the title of each records, it goes to DetailsPage.aspx.
What I want here is: If user click the title details of a record and leave that search page, I want to put there(On Details.aspx) Previous/Next button arrow so that the user does not need to browse back and see the search results and go to next details.
Note: I am passing ID into querystring when go search page to details page.
How to keep remembering IDs on details page of searched records on search.aspx ?? Use session or something different ? How can I do this ?
I have FormviewPagerTemplate that is working fine but the problem is coming when I'm in the first or last record only.
if I'm in the first record and want to navigate to the second record I have to hit next linkbutton twice
if I'm in the Last record and want to navigate to the previios record I have to hit previuos linkbutton twice
See my code below:
[Code]....
I have the query to retrieve selected record in textbox. How to use this query to update record: I want when I enter sumit in textbox1 and click submit button then the record with ID 1 will be updated to name sumit
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT TOP 1 Name FROM Table1 Order by Id DESC", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
If dtrReader.HasRows Then
While dtrReader.Read()
TextBox1.Text = dtrReader("Name")
End While
Else
Response.Write("No customer found for the supplied ID.")
End If
dtrReader.Close()
SQLData.Close()
I'm trying to Exit the Page_Load event if the user did not come from a specific page. If it did I want it to populate the fields based on what i passed from the other page. Here's my code:
Protected Sub Page_Load(ByVal sender
As
Object,
ByVal e
As System.EventArgs)
Handles
Me.Load
If Request.QueryString
Is
Nothing
Then
Exit
Sub
ElseIf Page.IsPostBack
Then
NCMRNumber.SelectedValue = Request.QueryString("NCMRNumber")
NCMRLabel.Text = NCMRNumber.SelectedValue
Dim SQLDataview
As DataView =
DirectCast(SortInstructionsSQL.Select(DataSourceSelectArguments.Empty), DataView)
For
Each DataRow
As DataRowView
In SQLDataview
SupplierNameLabel.Text = DataRow("Supplier").ToString
SupplierContactLabel.Text = DataRow("SupplierContact").ToString
SupplierPhoneLabel.Text = DataRow("SupplierPhone").ToString
PartNumberLabel.Text = DataRow("PartNumber").ToString
DefectDescriptionLabel.Text = DataRow("DescriptionofDefect").ToString
Next
End
If
End
Sub
I have datagrid. i loading data to grid from user control like below
[code]....
when i click the button Show child item. all the child item are displaying except one. for first child item not displaying, but one of parent items is displaying inside child grid.
it seems like previous parents data is loading to one of child record. How can i prevent that?
I have table having data like:
ID Date Name
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
I need to get result something like...
1 1/1/2009 a
2 1/2/2009 b
3 1/3/2009 c
4 1/4/2009 Null
5 1/5/2009 Null
6 1/6/2009 Null
7 1/7/2009 Null
8 1/8/2009 Null
............................
............................
............................
30 1/30/2009 Null
31 1/31/2009 Null
I want query something like..
Select * from tbl **where month(Date)=1 AND year(Date)=2010**
Above is not completed query.
I need to get all the record of particular month, even if some date missing..
I guess there must be equi Join in the query, I am trying to build this query using Equi join
How can I build a query in a new page using the value from a prevous pages control's value. I can transfer the value to the new page, I just don't know how to use the passed value to build a query. I want to populate a data grid filtering with values obtained from the proveous page.
View 3 RepliesI have a LINQ query like this:
var query1 = from x in db.FaqCategories select new { x.CategoryId, x.Category };
What I would like to get is a query with an empty record
var empty = new {CategoryId="", Category=""};
on the very top of query1. I think this can be accomplished by using the union operator, just don't know how.
Here is my table and data of these tables
Table name: Code
CID Code
1 abc
2 def
3 xyz
Table Name : Details
ID Name CID
1 a 1
2 b 2
Resultant Table:
ID Code Name
1 abc a
2 abc Null
3 def b
4 def Null
5 xyz Null
6 xyz Null
I nned to get all record from the code table and against each code I have to get all the rows from the details table, if some code have value their need value and if not then Null
I am developing a web application in ASP.NET3.5 with C#. I also using Telerik RadAjax Control. When user click the menu then open the page with a new tab(Like web Browser).I want to create, when user back any previous tab(page) the will be show the previous data without loading 2nd time( like browser tab). Is it Possible ?
View 2 RepliesThis is the first time i am using ms access database for the c# asp.net .
I am getting the following error when i try to insert the record.
Operation must use an updateable query.
[code]....
i wants to display the related informations of each record of dataset. That mean, dataset having rows for A,B,C and etc..
Then i wants to display the information in same Gridview of each record(A,B,C). i wrote the below my coding, it dispaly info of the last row of dataset only. pls correct the coding.
[Code]....
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 Replies[Code].... Save previous row value to next row?
View 8 RepliesI am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
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
As I am learning asp.net . when i try to insert record into msaccess table why it says -
Syntax error (missing operator) in query expression 'user1','cx0437@gmail.com' ,'12312456')'.
As i found the same code at the following link [URL] ....
Code:
protected void Button1_Click(object sender, EventArgs e) {
OleDbConnection con;
try{
using (con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" + @"DATA SOURCE=C:Database iershop.mdb")) {
con.Open();
[Code] ....
I had a sql statement to prepare dataset for generate staff overtime work and time-off balance.
SELECT Table1.staff_key,Table1.from_date,Table1.to_date,Table1.total_min ...... FROM Table1
UNION ALL
SELECT Table2.staff_key,Table2.from_date,Table2.to_date,Table2.total_min ...... FROM Table2
the output of the sql statement should like this:
From To No. of hours
total_min Balance
01/01/2011 12:00 01/01/2011 17:00 7 hr 0 min 420
420
07/03/2011 12:00 09/03/2011 14:00 ( 2 hr 0 min ) -120
360
07/03/2011 19:00 09/03/2011 20:30 1 hr 30 min 90
450
10/03/2011 17:00 10/03/2011 17:30 ( 0 hr 30 min ) -30
420
But I have no idea how to calculate the Balance in the sql statement that it will sum up the total_min of previous rows + existing row.