|
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
|
|
|
|
|
Amit Kumar G wrote: Is there any other simpler and full proof way
Yeah, don't run the app, that way you will never get any exceptions 
You should handle the exception in the code where it happens. If it is something that can be corrected, then do so, otherwise rethrow it up the call stack. I'm curious as to why you think you need so many layers?
I would suggest using the Enterprise Library Exception Handling Block. It is easy to configure and setup multiple policies for different exceptions and situations.
only two letters away from being an asset
|
|
|
|
|
I agree with you, but to buy bread i have to run the application )
Jokes apart.
I appreciate your reply. Can you help me to understand how i can use enterprise library. I have zero idea for this.
Cheers
Amit
|
|
|
|
|
|
Hi,
you can use microsoft enterprise library for exception handling and database operations. That will log the exception on the event viewer.
Catch the exceptions in all layers, but log the exception only from the UI layer. Throw exceptions from other layers to the UI layer.
Istead of using enterprise library, you can log your events and exceptions with datatime on a text file in a specific directory. Those files can be used to keep track of the execution.
Ram
|
|
|
|
|
I am still having trouble with Form Authentication. Looks like my vb code doens't like the FormsAuthentication.RedirectfromLoginpage. I think its a variable that is not declared.
Here is my web.config
<configuration>
<system.web>
<compilation defaultlanguage="vb" debug="true">
<customerrors mode="RemoteOnly">
<authentication mode="Forms">
<forms name="AuthCookie" loginurl="Login.aspx" defaulturl="Default.aspx"
="" timeout="60" protection="All" cookieless="AutoDetect">
<authorization>
<deny users="?">
<trace enabled="false" requestlimit="10" pageoutput="false" tracemode="SortByTime" localonly="true">
<sessionstate
="" mode="InProc" stateconnectionstring="tcpip=127.0.0.1:42424" sqlconnectionstring="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20">
<globalization requestencoding="utf-8" responseencoding="utf-8">
This is what my login button looks like:
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim objSqlDataset As New DataSet
Dim isfound As Boolean = False
Dim objSqlDataAdapter As New SqlDataAdapter
Dim i As Integer = 0
Dim SelectMembers = New SqlCommand("select * from Members", objSqlConnection)
objSqlDataAdapter.SelectCommand = SelectMembers
objSqlDataAdapter.Fill(objSqlDataSet, "Members")
pstrUserId = Me.txtUserId.Text.Trim
PstrPassword = Me.txtPassword.Text.Trim
With objSqlDataSet.Tables("Members").TableName
Do Until (i >= objSqlDataSet.Tables("Members").Rows.Count Or isfound)
If objSqlDataSet.Tables("Members").Rows(i).Item("UserId").TOUPPER = pstrUserId.ToUpper Then
'Update the Flag
isfound = True
Else
'increment the counter
i = i + 1
End If
Loop
If isfound Then
If objSqlDataSet.Tables("Members").Rows(i).Item("Password").TOUPPER = PstrPassword.ToUpper Then
If Me.chkPassword.Checked = True Then
Response.Cookies("FremontPokerLeague")("FirstName") = objSqlDataset.Tables("Members").Rows(i).Item("FirstName").trim
Response.Cookies("FremontPokerLeague")("userId") = Me.txtUserId.Text.Trim
Response.Cookies("FremontPokerLeague")("Password") = Me.txtPassword.Text.Trim
Response.Cookies("FremontPokerLeague").Expires = DateTime.Now.AddMonths(1)
 formsauthentication.redirectfromloginpage(pstrUserId, False)
End If
objSqlDataset.Dispose()
objSqlDataset = Nothing
objSqlDataAdapter.Dispose()
objSqlDataAdapter = Nothing
insertLogin()
Else
Lblstatus.Text = "Invalid Password!"
End If
Else
Lblstatus.Text = "Invalid User Id!"
End If
End With
End Sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
