ASP.NET

Re: What is better server.Transfer() or Response.redirect()

24-Nov-07 5:19

Yeah. You can use the Session object.

koolprasad2003 wrote:
can it use my server memory

All variables use the memory. For example: int i = 0; If you declare the variable called i, it will take some amount (maybe. very little) of memory... Nothing on computer works without memory. Smile | :)

koolprasad2003 wrote:
what abt Viewstate?

The ViewState is not for that purpose. Don't confuse.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

John-ph23-Nov-07 21:15

John-ph

23-Nov-07 21:15

koolprasad2003 wrote:
if i use queeryString with Responce.Redirect() then the variable that are transfered are render in browser's address bar.

You can Tamper[^] the Query String values and Pass to another page, use Response.Redirect()

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Query

Sunil Wise23-Nov-07 19:45

Sunil Wise

23-Nov-07 19:45

i have posted a query yesterday plz look at it someone and help me

http://www.codeproject.com/script/comments/forums.asp?msg=2332286&forumid=12076#xx2332286xx[^]
regards
sunilwise

Is it possible to add mySql queries in aspx page

Deepthy.P.M23-Nov-07 19:33

Deepthy.P.M

23-Nov-07 19:33

I want to display datas in a table in two columns.How is it possible using Mysql queries

Re: Is it possible to add mySql queries in aspx page

Michael Sync23-Nov-07 19:53

How to show data in EXCEL Sheet?

23-Nov-07 19:53

Yeah. You can use mysql in ASP.NET..

http://www.google.com/search?q=asp.net+mysql&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Kasi Viswanathan23-Nov-07 19:11

Kasi Viswanathan

23-Nov-07 19:11

I have data in a grid view...My problem is how to show my data in EXCEL sheet using Asp.Net2.0....Any reference will be more helpful...

Thanks in Advance... Rose | [Rose]

Erasers are for people who are willing to correct their mistakes.

Found Reference...

Kasi Viswanathan25-Nov-07 22:55

Kasi Viswanathan

25-Nov-07 22:55

Check this Link...

Export To Excel

Erasers are for people who are willing to correct their mistakes.

Crystal Report Problem

Suryanairg23-Nov-07 17:49

Suryanairg

23-Nov-07 17:49

Hai,
I have a Crystal Report. I have to change background color of a Textobject dynamically.
What can I do?? Please help me....
Thanks in advance

Surya Nair

Sunil Nair

AutoComplete

kirthikirthi23-Nov-07 17:38

23-Nov-07 17:38

Hi all

Iam working on autocomplete textbox.

in my code only 1 tetbox is working fine. but i want use 2 textbox as autocomplete (from DB)

when i write code for 2 textboxs only 1 textbox is working other is not displaying the data values

can any 1 tell me what is error on my code

iam using 1.1 ver.

MYCODE

--------------------

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

Autocomplete1.PageType = Me.[GetType]().BaseType
Autocomplete1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData1)

End Sub

- AjaxPro.AjaxMethod() _
Public Function GetSearchData(ByVal s As String) As DataTable
Dim conn As New SqlConnection("server=;uid=;pwd=;database=")
Dim cmd As New SqlCommand("SELECT Name FROM IDs WHERE Name LIKE @Name + '%'", conn)
cmd.Parameters.Add("@Name", s)
Dim da As New SqlDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "IDs")
Return ds.Tables("IDs")
End Function

- AjaxPro.AjaxMethod() _
Public Function GetSearchData1(ByVal s As String) As DataTable
Dim conn1 As New SqlConnection("server=;uid=;pwd=;database=")
Dim cmd1 As New SqlCommand("SELECT NameID FROM IDs WHERE NameID LIKE @NameID + '%'", conn1)
cmd1.Parameters.Add("@NameID", s)
Dim da1 As New SqlDataAdapter
Dim ds1 As New DataSet
da1.SelectCommand = cmd1
da1.Fill(ds1, "IDs")
Return ds1.Tables("IDs")
End Function
---------------------

THX

Keerthi

Michael Sync23-Nov-07 17:51

23-Nov-07 17:51

I think I've seen this thread earlier.

Are you sure the function works fine?? Because i think that the SQL statement looks strange to me..

kirthikirthi wrote:
Dim cmd As New SqlCommand("SELECT Name FROM IDs WHERE Name LIKE @Name + '%'", conn)

Dim cmd As New SqlCommand("SELECT Name FROM IDs WHERE Name LIKE '@Name%'", conn)

kirthikirthi wrote:
Dim cmd1 As New SqlCommand("SELECT NameID FROM IDs WHERE NameID LIKE @NameID + '%'", conn1)

Dim cmd1 As New SqlCommand("SELECT NameID FROM IDs WHERE NameID LIKE '@NameID%'", conn1)

kirthikirthi23-Nov-07 18:43

23-Nov-07 18:43

THX for reply

Yes (which i paste)it is working fine but only for 1 Textbox

I want it for 2 textboxes.

i used this code from

http://mind.com.my/forums/thread/970.aspx[^]

THX

Keerthi

Imran Khan Pathan23-Nov-07 18:54

Imran Khan Pathan

23-Nov-07 18:54

can you tell me what is the the error ?

please don't forget to vote on the post that helped you.

Michael Sync23-Nov-07 19:51

23-Nov-07 19:51

kirthikirthi wrote:

acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

This code is working fine??

I don't have VS 2003 in front of me.. I will tell you some possibilities..

Try with only one textbox

1. You said that the textbox "acSearch" and "GetSearchData" work fine. Why don't you try with "acSearch" and "GetSearchData1"

<br />
acSearch.PageType = Me.[GetType]().BaseType<br />
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData1)

Is it working?

2. What about "Autocomplete1" and "GetSearchData"?

<br />
Autocomplete1.PageType = Me.[GetType]().BaseType<br />
Autocomplete1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

Is it working?

3. What about "Autocomplete1" and "GetSearchData1"?

<br />
Autocomplete1.PageType = Me.[GetType]().BaseType<br />
Autocomplete1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData1)

Is it also working??

If those three possibilities are working fine then try with two textboxes..

1.
acSearch + GetSearchData
Autocomplete1 + GetSearchData

2.
acSearch + GetSearchData1
Autocomplete1 + GetSearchData1

3. (finally)

acSearch + GetSearchData
Autocomplete1 + GetSearchData1

And let us know the steps the code is not working.

One more suggestion. If you are testing those steps, I suggest you to use Firefox with Firebug. And check whether you got any error in Firebug console or not..

kirthikirthi30-Nov-07 20:28

30-Nov-07 20:28

Hi
I tried your code

The code working only for 1 textbox

I mean On Page Load

2 Textboxs calling not woring only 1 textbox calling is working

can u plz tell me a solution for my error

Or

Can u plz tell me is there any other way to do this in (2 or more DB autocomplete textboxes) 1.1 ver or VS 2005 ver

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
AUTOCOMPLETE1.PageType = Me.[GetType]().BaseType
AUTOCOMPLETE1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf GetSearchData00)
'Ca()

End Sub
<ajaxpro.ajaxmethod()> _
Function GetSearchData(ByVal s As String) As DataTable

Try
Dim conn As New SqlConnection(Global.constrSQ)
Dim cmd As New SqlCommand("SELECT MusicDirector FROM MusicDirector WHERE MusicDirector LIKE @MusicDirector + '%' ", conn)
cmd.Parameters.Add("@MusicDirector", s)
Dim da As New SqlDataAdapter
Dim ds As New DataSet

da.SelectCommand = cmd
da.Fill(ds, "MusicDirector")
Return ds.Tables("MusicDirector")
Catch ex As Exception

End Try

End Function
<ajaxpro.ajaxmethod()> _
Function GetSearchData00(ByVal s0 As String) As DataTable
Dim conn As New SqlConnection(Global.constrSQ)
Dim cmd As New SqlCommand("SELECT SingerName FROM Singer WHERE SingerName LIKE @SingerName + '%'", conn)
cmd.Parameters.Add("@SingerName", s0)
Dim da As New SqlDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd '============ erragaddalopala
da.Fill(ds, "Singer")
Return ds.Tables("Singer")
End Function

Keethi

Michael Sync30-Nov-07 21:42

30-Nov-07 21:42

Have you tried my 6 steps that I mentioned in previous post? Which steps do you get the error??

If you are using VS2005, you can check this sample "ASP.NET Ajax Toolkit - Autocomplete" http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

kirthikirthi30-Nov-07 23:09

about dropdownlist control in asp.net

30-Nov-07 23:09

Hi
yes i tried with your 6 steps Frown | :(

still it is not running and not giving error also

is it not posible with ver 1.1

Than Q

Keerthi

srinivasbau23-Nov-07 10:01

srinivasbau

23-Nov-07 10:01

iwant coding in ropdownlist as which to dsplay details of the selectd option in the dropdownlist in asp.net with vb

Re: about dropdownlist control in asp.net

Malcolm Smart23-Nov-07 10:52

Malcolm Smart

23-Nov-07 10:52

other things you might want...

manners?
a dictionary to look up words like drop downlist, display, selected
a web browser which automatically opens up with google

you might also want to try and do this yourself and then post questions when you get stuck.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."

Re: about dropdownlist control in asp.net

koolprasad200323-Nov-07 19:16

koolprasad2003

23-Nov-07 19:16

hi,
just go through following links

www.codersource.net/asp_net_dropdownlist.html

www.w3schools.com/aspnet/control_dropdownlist.asp

regards,
koolprasad2003

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

about calander controlin asp.net

srinivasbau23-Nov-07 9:58

srinivasbau

23-Nov-07 9:58

i want coding on how to get the calander date into a textbox when i selected a date in the calander?i want in asp.net

Christian Graus23-Nov-07 10:52

Christian Graus

23-Nov-07 10:52

What have you tried ? What calendar control are you using ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

srinivasbau23-Nov-07 11:10

srinivasbau

23-Nov-07 11:10

actaualy my problem is set a claender control and a textbox in a form , whenever i select a date in the calander i want that selected option into the textbox

Christian Graus23-Nov-07 12:47

Christian Graus

23-Nov-07 12:47

I guess if you won't answer my questions, I can't really hope to answer yours.