|
How to write data in multiple sheets in excel file using Asp.net.
modified on Friday, April 4, 2008 2:44 AM
|
|
|
|
|
Hi,
I have two dropdowns.
I want that the DDL2 gets populated based on the values in DDL1.
How can I achieve that.
This is the way I am populating DDL1
string cmd = "Select * from abc ";
SqlDataAdapter da = new SqlDataAdapter(cmd, connection);
DataSet ds = new DataSet();
da.Fill(ds);
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "Code";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "--Select--");
|
|
|
|
|
Hi,
On selectedIndexChanged even of DDL1 pass the value of selection and retrieve the result based on passed value to bind the DDL2.
Regards 
|
|
|
|
|
Hi,
I Created Link Button for Category Dynamically into the Datalist and Bind name to every Link Button. There are 7 Seven LinkButtons.
When I click First I want ID of that Click Link Button then From that ID I want to Fetch Records from the databse for Product and Display the Product.
Thanks
|
|
|
|
|
First bound data to your linkbutton in datalist .
then use this coding for ur click event for link button
if(e.commandName == "lnkbutton")
{
sqlconnection open();
string name = ((LinkButton)e.Item.Cells[0].Controls[0]).Text;
}
//pass name to query to fetch data
// mention your link button column no. in cells[] item.
Ashok
modified on Friday, April 4, 2008 8:06 AM
|
|
|
|
|
Hi all,
I have a calender shown below:
<asp:calendar id="Calendar1" runat="server">
ondayrender="Calendar1_DayRender" NextMonthText="" PrevMonthText="">
and code is shown below:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim dt As DateTime
dt = Now
Calendar1.VisibleDate = dt
Calendar1.SelectedDate = dt
End Sub
Public Shared Function Week(ByVal tdDate As System.DateTime) As Integer
Dim myCI As New Globalization.CultureInfo("en-US")
Dim myCal As Globalization.Calendar = myCI.Calendar
Dim myCWR As Globalization.CalendarWeekRule = myCI.DateTimeFormat.CalendarWeekRule
Dim myFirstDOW As DayOfWeek = myCI.DateTimeFormat.FirstDayOfWeek
Return myCal.GetWeekOfYear(tdDate, myCWR, myFirstDOW)
End Function
Protected Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DayRenderEventArgs) Handles Calendar1.DayRender
If Week(e.Day.Date) <> Week(Calendar1.SelectedDate) Then
e.Cell.Text = ""
End If
End Sub
when I run this, I am able get week in the calender and how can I make the calender to display weeks wise like months.
Please help me!
Thanks,
Mohd Farooq
|
|
|
|
|
I am using the following code
if (System.IO.Directory.Exists(Server .MapPath ("Albums/username" ))
{
System.IO.Directory.Delete(Server .MapPath ("Albums/username"),true);
}
to delete the folder named "username" and all of its subfolders. After this , if I take the folder Albums, I can see "username" folder. But when I double click on the folder, " Access is denied" message is coming. If I close visual Studio the folder itself is disappearing. In production server how will it work?
|
|
|
|
|
I got the answer. If anyone needs the answer here it is!!
My project is stored in a drive which uses NTFS File System and the folder to be deleted is inside my project folder. Since now I have opened this project in Visual Studio, that folder is also being used by Visual Studio.In NTFS, You may not be able to delete a file if the file is being used. You may be able to use the Delete command to delete a file, but the file is not actually deleted until the process that has the file open releases the file.
|
|
|
|
|
Hi!
Please consider the following scenario...
I have a number, say 10234 and I want to convert this number into words, i.e. Ten Thousand Two Hundred and Thirty Four.
Is it possible in VB.net and if so then please suggest a logic.
And in the worst case please suggest some keywords to search in google, the keywords I am using are not returning expected results.
Thanks,
Arun
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
LucknowRockers wrote: And in the worst case please suggest some keywords to search in google, the keywords I am using are not returning expected results
Did you try these words[^]?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul!
Thanx for your help. I found the logic with the help of the keywords suggested by you. 
You know sometimes the things are very obvious but you just don't get them working for you. 
Thanks again,
Bye
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
LucknowRockers wrote: You know sometimes the things are very obvious but you just don't get them working for you.
Too true. Happy to help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
LucknowRockers wrote: Is it possible in VB.net
Yes. This is a Web Site Project, that's why you are asking this in the ASP.NET forum?
LucknowRockers wrote: please suggest some keywords to search in google
try: VB sucks
or: software "spell numbers"
or: career change
led mike
|
|
|
|
|
hi Mike,
YOU ARE COMPLETELY WRONG.
The actual requirement was for a asp.net application I am developing for my company. It will automate many things and also the payroll. I wanted to print the salary in words along with numbers and that's why after wondering couple of hours I posted this question on this forum.
Now, I think the things are pretty clear to you and one more thing I want to suggest you that before making decision about anybody please try to find the actual cause.
Cheers  ,
Arun
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
led mike wrote: This is a Web Site Project, that's why you are asking this in the ASP.NET forum?
LucknowRockers wrote: YOU ARE COMPLETELY WRONG.
The actual requirement was for a asp.net application I am developing for my company.
Ah I see, I was COMPLETELY WRONG because I asked if it was a Web Site Project when in fact it is an ASP.NET application. 
led mike
|
|
|
|
|
led mike wrote: Ah I see, I was COMPLETELY WRONG because I asked if it was a Web Site Project when in fact it is an ASP.NET application
I thought you are giving the reference of some other web site project for which this type of query has already been asked, that's why I wrote those lines.
By the way, thanks for entertaining me with your funny replies and also for talking nothing about the problem I asked and distracting my mind for some time from the work load. It really helped alot. 
I have got the solution and going back to my work. So no further replies from my side.
Bye 
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
LucknowRockers wrote: and also for talking nothing about the problem I asked
led mike wrote: LucknowRockers wrote:
please suggest some keywords to search in google
try: ....
or: software "spell numbers"
Perhaps you should conserve your energy by cutting down on your replies to me. You will probably need all the energy you can get to complete your project.
Abandon hope all ye who answer here.
Pete O'Hanlon - the General Discussions forum
|
|
|
|
|
|
Id like to create a regex expression to add it to the createuserwizard
The problem is that im not very familiar with regex, ive been searching, but i cant find an example to do this
What id like is the user create a nick with the following restrictions:
Between 6 and 20 characters
Only letters and numbers and any of this signs (._-)
And only one space
Ive tried this regex:
^[\wÑñ._-]{6,20}$
How can i restrict the string to have no more than one space (No spaces would be ok)
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
This will do exactly what you want with no spaces ^\s{0}[\wÑñ._-]{6,20}$
A pessimist sees the difficulty in every opportunity; an optimist sees the opportunity in every difficulty I am a Optimist
|
|
|
|
|
Thanks for the reply
gspiteri wrote: ^\s{0}[\wÑñ._-]{6,20}$
This RegEx does exactly what the regex that already have does
Besides .-_ and letters and numbers, I need to allow only one space (Optional)
Alexei Rodriguez
|
|
|
|
|
gspiteri wrote: This will do exactly what you want with no spaces ^\s{0}[\wÑñ._-]{6,20}$
\s{0} is completely superfluous. White space is already disallowed because it hasn't been included in the list of character classes contained between the square brackets.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Oops sorry dude wasnt thinking
A pessimist sees the difficulty in every opportunity; an optimist sees the opportunity in every difficulty I am a Optimist
|
|
|
|
|
The only way I can think to do this is to use a CustomValidator[^] control.
In your custom validation function, first use a regular expression to check that the string is between 6 & 20 characters and contains only letters, numbers, spaces or the (._-) symbols (BTW, the literal '.' character needs to be escaped in a regular expression as \. because '.' is a reserved regular expression character). If your input passes this validation, write some code to count the number of spaces it contains.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thaks for the suggestion, someone at regexlib.com forums helped me with this
This does the job:
^(?!.* .* )[\w ñÑ.-]{6,20}$
Weird that . doesnt make the regex fail
But ill scape it on my page
Alexei Rodriguez
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
