|
My code is not working for dispaly records when i click buttonNext.Correct me.
Dim dr As DataRow
For i = 0 To ds.Tables("Offices").Rows.Count - 1
dr = ds.Tables("Offices").Rows(i)
If dr.Item("office_id") = TxtOff.Text Then
i = i + 1
TxtOff.Text = dr.Item("Office_id")
End If
Next
i tried but not working.
kissy
|
|
|
|
|
What are you trying to acheive. Please try and explain the whole scenario
Mubashir
|
|
|
|
|
I have to access records from database into the respected textboxes.
Whenever i click ButtonNext it should show the records,for that i have given code as above.but it is not working,it showing only first record,it is not moving to the next row in the database table.
kissy
|
|
|
|
|
Kissy16 wrote: My code is not working
What is the Error it gives? Mention that one.
Kissy16 wrote: TxtOff.Text = dr.Item("Office_id")
dr.Item("Office_id").ToString() ' Should be Converted to string.
Check also in 'if' statement above for the same.
More Efficiently try using, ForEach like..
Dim dr As DataRow
For Each dr in ds.Tables("Offices").Rows
put ur code here
Next
I am not remember the syntax using vb.net . But u may use like this.
Regards,
Jay
|
|
|
|
|
it is not moving to the next record,stay back in the first record itself,no error.
kissy
|
|
|
|
|
Kissy16 wrote: If dr.Item("office_id") = TxtOff.Text Then
i = i + 1
TxtOff.Text = dr.Item("Office_id")
End If
What this code does? Why u r increment 'i' value ?
Keep in mind, 'i' is the variable in the 'for' loop.
Regards,
Jay
|
|
|
|
|
why i am incrementing that value is,when the user is suppose in record1,if he wants to see record2,that is second row,here i is the row value.
i am incrementing row value to +1 to go to the next row.
Dim i As Integer = 0
Dim dr As DataRow
For Each dr In ds.Tables("Offices").Rows
dr = ds.Tables("Offices").Rows(i)
If TxtOff.Text = dr.Item("office_id").ToString() Then
i = i + 1
TxtOff.Text = dr.Item("Office_id").ToString()
end if
next
This is my code for the ButtonNext,if it is wrong what should i do.i am retriving dabase records into textboxes.
Give me an idea,for moving to the next row and display.
kissy
|
|
|
|
|
For that purpose u have to keep track of Current Record. ok. (ie)What is the Currrent Row Index, that should be kept in a variable.
I believe no need for looping through all the rows every time. Better to use, Select.. Case.
I think, u have used LinkButton Control to navigate Prev,Next record. Set the CommandArgument propery to some text, for example ,say 'prev' for navigating to previous record and 'next' for navigating to next record.
In the Click event of either link button, write a single event handler. In that use Select ...Case method, to find the particular 'CommandArgument' and Perform ur operation.
Thats all the idea. 
Regards,
Jay
|
|
|
|
|
Man the i variable is local and declared in the button event handler which is causing the problem,when ever u click the button i will alway be set to 0,this is the problem, it can work if u can make i static global variable, but it is better, if u save the value of i variable in View State for accessing the next record and check with the condition if the view state is empty then assign i with 0 , other wise assign the value of view state to i, hopefully this will solve ur problem.
|
|
|
|
|
Your for loop is not coded properly.
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hi kissy,
Try to refer the code which i sent you last week.
I hope it will help you to solve your problems.
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
I tried but it is not working.Thats y came again.I tried my best but where's the wrong step i dont know.
help me out.
kissy
|
|
|
|
|
Hi kissy,
You just send me that code.
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Dim ds As New DataSet
sedr = New SqlDataAdapter("Select * from Offices", dbconn)
sedr.Fill(ds, "Offices")
Dim dr As DataRow
For Each dr In ds.Tables("Offices").Rows
//For i = 0 To ds.Tables("Offices").Rows.Count - 1
dr = ds.Tables("Offices").Rows(i)
If TxtOff.Text = dr.Item("office_id").ToString() Then
i = i + 1
TxtOff.Text = dr.Item("Office_id").ToString()
End If
Next
just check it,how to maintain,viewstate??/
kissy
|
|
|
|
|
hi kissy,
if you declare a variable in asp.net,it will lose its value after postback.
for eg:
dim i as integer=1
and in the click event if you type
i=i+1 'then i(variable) will store now 2
and if you try to click the button it will always show you 2. Since it does not support viewstate. So i suggest you to store this value in one of your web control(i.e label) and hide this control if you dont want to show its value to end user.
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hai
I have given u a mail with my problem,otherwise read this.
urs answer is working for Button_next.
But the same code with some changes is not working for the Prev_button.Label value is working for the next record only,this is not global,and we are using in the event handler.so the same label should work for the button_Prev,bcz we need to navigate from the present record to prev or next.hope u might have got wat i am trying.
Give me an idea
thank you for ur patience.i am new to this asp.net
kissy
|
|
|
|
|
Hi kissy,
You have to use the same label for storing the value.If you click on the next button, its value(i.e your label value) should get incremented by 1 and if you click on the previous button, its value should get decremented by 1.
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Thank you so much,My problem solved,Thanks for ur help and respond me whenever i have a doubt
kissy
|
|
|
|
|
Always welcome.............
Thanks & regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Test......
Everything Is Possible!
|
|
|
|
|
I am working on an e-commerce site.Please tell me how to use SSL certificate for my site.I have the certificate but dont know how to use it in my application.(Its an ASP.NET (C#) web application)
Priyam Malhotra
|
|
|
|
|
I have a small application which has Textarea control,textbox control,and a button control.I have some text in the Textarea control.when i select some part of the text in the Textarea control and pressed a button,that selected text along with the starting index and ending index should be displayed in the textbox.i have achieved of capturing the selected text into the textbox but i couldn't able to trace starting and ending index of selected text.
can you plz help me out.....
Thanks
bye
kamalnath
|
|
|
|
|
I have a problem to post any file in XAML(WinFX).I have code to post file in asp.net 2.0.But I want to implement it also in WinFX.Any body know how to do that?
|
|
|
|
|
I want to make a control in WinFX that save any file to perticular location in local system.Can anyone help me?
|
|
|
|
|
Hi
I am developing an asp.net site with 5 layers as UI, DAO, DTO, Business and DAL. I am confused where should i do exception handling. Do i need to do it on each tier code or just i do it on UI layer.....Please suggest.
I am planning to use resource file and log4net. And for all layers except UI, i am planning to maintain trace on log file and on the other hand for UI i will display error on custom error.aspx page and as well as on log file.....
Am i correct, as i am doing n tier application first time. Is there any other simpler and full proof way......PLEASE SUGGEST...
Amit
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
