ASP.NET

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

23-Nov-07 20:36

You can use the Session object or Cache object to store those values....

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."

koolprasad200323-Nov-07 20:50

koolprasad2003

23-Nov-07 20:50

thankx for your advice..

if i use session object then can it use my server memory ??? what abt Viewstate?

regards,
koolprasad2003 Smile | :)

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

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

Michael Sync24-Nov-07 5:19

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.

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