|
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]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Erasers are for people who are willing to correct their mistakes.
|
|
|
|
|
Check this Link...
Export To Excel
Erasers are for people who are willing to correct their mistakes.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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)
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."
|
|
|
|
|
|
can you tell me what is the the error ?
please don't forget to vote on the post that helped you.
|
|
|
|
|
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..
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."
|
|
|
|
|
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
|
|
|
|
|
|
Hi
yes i tried with your 6 steps  still it is not running and not giving error also
is it not posible with ver 1.1
Than Q
Keerthi
|
|
|
|
|
iwant coding in ropdownlist as which to dsplay details of the selectd option in the dropdownlist in asp.net with vb
|
|
|
|
|
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."
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
I guess if you won't answer my questions, I can't really hope to answer yours.
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 )
|
|
|
|
|
srinivasbau wrote: want coding
srinivasbau wrote: i want in asp.net
I want, I want, I want... 
Why are you demanding code from people on this site without demonstrating a willingness to engage with the problem yourself? Frankly, it's rather tedious. Demonstrate that you have attempted to solve the problem and got stuck, and maybe help will be more forthcoming.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Why don't you answer the question that we asked you??
I have some examples for that..
You may read the following section from this article.
# Using ASP.NET Calendar Control in ASP.NET Project
# Showing ASP.NET Calendar Control in Popup Window
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."
|
|
|
|
|
Hey
I'm using the MySQL Membership and Role Provider from here and i'm having a few problems.
I've created all the tables in my database and added the part specified to my web config file and edited the connection string appropriately. The problem comes when I attempt to create user. It just says it fails. Even through web admin. Any ideas?
Thanks
-Bursh.
Don't you just hate coming up with something to put here?
|
|
|
|
|
You should address your question to the author of the article.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi there,
I have the situation as follows:
I have custom web part, which is provider and consumer at the same time. It implements IWebPartTable interface. When I work with my custom web part in "chain mode", which means web part p1 provides data for web part p2 and web part p2 provides data for web part p3 (p1->p2->p3) the data in all web parts are displayed properly. But, if I work with my web part in "parallel mode", which means web part p1 provides data for web parts p2 and p3 (p1->p2, p1->p3), the data only displayed in last web part p3. All connections are there!
The problem is that I must move using TableCallback object from GetTableData method on class level. Before moving it on class level, it looked as follows:
public void GetTableData(TableCallback callback)
{
callback(_table.Rows);
}
After moving it, it looks as follows:
public sealed class TableProviderWebPart : WebPart, IWebPartTableExtended
{
private TableCallback tableCallback;
...
public void GetTableData(TableCallback callback)
{
this.tableCallback = callback;
}
}
Do you have any suggestion how to make my web part work in "parallel mode" as well?
Thank you in advance.
Goran Tesic
|
|
|
|
|
hi
i write a program in ASP>NET with AJAX
when i send method to asmx whit xmlhttp if my browser be firefox it is rghith but IE has a problem some time my filds in the server side is null but when i test ajax url it is true
pls help me
mamad
|
|
|
|
|
Your question doesn't make sense. Please try and express yourself more clearly. Cutting down on the textspeak might help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
