|
Hi,
When i try to upload an excel file that has a date column, there is a issue in the system language. That is, when i tried my application in my system which has regional settings (System Language:English-US;Programs that run non-unicode format: English-US)and it was working perfectly. The datas got uploaded.
But when i tried in another machine that has the system settings (System Language:English-UK;Programs that run non-unicode format: English-UK), this threw me an error "Invalid date format in excel".
Help me out.
Thanks in advance.
|
|
|
|
|
|
You mean reusing the DataGridView?
If so yes you can, just call the Clear method before assigning the datasource second time
OR set the datasoruce to null.
Be careful, there is no Undo Button(Ctrl+Z) in life.
|
|
|
|
|
thanx but my question is :
1. i have 2 dropdown list ctrls on my page showing the ID's of two different tables.
And only one dropdown list can b used at a time.
2. i wud like to know whether i cud use the datagridview to c the results according to the dropdown list selected(which shows the data of the table connectd to )
|
|
|
|
|
Please don't use txtspeak, it makes you look like a moron.
But, given how trivial your question is, and how easy it would be to test if this will work ( or just to put two styled grids on a form and only show the selected one ), perhaps first impressions are correct.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Why would you want to ? Why would you ask this and not just try it ?
Yes, if they have the same columns or if you have the columns auto generated, then of course you can.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
ASALAMOALEKUM,
I am working with ASP.NET and c#
i have a chatting website.
i have two pages:
page1: names of all the chat rooms available
page2: a chatroom (for chatting)
i have use database to store chat and then by using ajax timer i have updated the displaying textbox with chat from database... for each chat room, it stores chat in the database w.r.t to its roomid.
i have made a class "chat" which contains static member ROOM_ID.
when user click on any room_name (from page1), the respective roomid is stored in the static member ROOM_ID and direct to page2 where all the working is done on the basis of the ROOM_ID.
as per scenerio i needed to open more than one chat room at a time so i have used OnClientClick event to target to new browser window when clicks on the room name from page1.
now i am facing two probelms...
1st:
i have run my application on browser say "A", for the first time when i click on any roomname, it opens the application in new browser say "B" but not with the page2(chat area for that room) but a LOGIN page of my website and when i log on to it it directs to the HOME page instead of directing to the page2.. and then when i again click on the roomname of page1 on "A" or "B" now it opens the new browser window say "C" with requested page2. (but for this i have to login to that page which was for the first time opened in new browser window "B" otherwise browser "C" also initiate with LOGIN page)..
how to avoid this LOGIN page ??
2nd:
Its a major problem, i dont know whether to have some different settings while working with different browsers incase of handling database too.
well...issue is :
i have opened a chatroom1 in browser"A" .. when i am working with only one chatroom its fine
now when i open a chatroom2 in new browser "B",, with the loading of this chatroom2 the chatroom at browser "A" tends to adopt the values of chatroom2.. that is both the browsers show the chat msgs of chatroom2...
how to handle thisss... ??
i know there must be any soln to thisss.. else having individual form for each chatroom is totally wastage and not a good practice because rooms are created and deleted by the user !
please reply!
thanks,
Regards.
$@N@
|
|
|
|
|
Sounds like your design is broken. For a start, a static variable is obviously going to be the same for all your pages, and in fact, I'd have expected it to be the same for all users, have you tested with two lots of users running at once in different rooms ? It sounds to me like your code has a lot of issues stemming from poor design.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
okay... so can i solve my probelm by passing roomid from page1 to page2 using session/querystring/cookies ?
$@N@
|
|
|
|
|
Thanksalot!
i have solved my problem by passing roomid btw pages through response.redirect().
Allah bless u all!
tc
regards,
Sana
$@N@
|
|
|
|
|
Hi ,
I have drag the Menu control from the navigation tool and change its color to my css match.Now the Main menu tabs changes its color and font But sub menu dosen't support evenafter used <levelsubmenustyles>
Thanks all,Your Help will be appreciated
|
|
|
|
|
Hi.
I've to develope a web messageBox. It should be server side with 2 states:
- OK button
- Yes/No button
If an instance of this class creates and the Show() method be called, I should show a message box and wait for user action and I get back the button that clicked to the callers method.
Could you please give me some guides how can I develope this class and how would you have started this?
Best wishes
|
|
|
|
|
http://www.getafreelancer.com/[^]
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
mehrdadc48 wrote: t should be server side with 2 states:
'it should be server side' ? What does that mean, and how is it possible for a piece of client UI to be 'server side' ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi All,
I have one input box in my html form, i want to put condition on it so that it will take only numerical values and whenever user enters a numerical value in it, it should format it in currency format automatically.
Please help me by advicing any CSS class or any XSL property.
Any help will be very much thankfull.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
|
indian143 wrote: want to put condition on it so that it will take only numerical values
Call a javascript function on the onblur event of the input box which will validate the input string. You can check if the entered string is a number or not like this[^]
Next step would be to convert it into the currency format. As I remeber from your last post, this currency thing was culture specific, rite?
Here, what you can do is that pass a regular expression based on culture and convert the string on its mask base.![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
<convert the string on its mask base>
Can u please provide me any help for this any small code nippet or any links.
And the above problem is solved. I am concerntrating on this problem only.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
Hi all,
iam using Memberhip API and login controls for user login and authentication.
by default asp.net 2.0 uses sql server Provider am i right?
now how i change this for MS Access data Provider ?
or how i configure this by defalult server for security
any article to point this issue
Best Regards
|
|
|
|
|
I would recommand this[^] article to read. 
Be careful, there is no Undo Button(Ctrl+Z) in life.
|
|
|
|
|
How about not using access and converting your DB to SQL Express then your troubles dissapear
|
|
|
|
|
Thanks for the reply ,
actually i read that Membership API by default uses the Access DB and it creates automatically inside App_Data Folder .
but some articles defined that the by default is using sql server DB .
kindly clear me in these ideas .
I also Downloaded the video from asp.net site and it is also defining the Access Database by default.
Best regards
|
|
|
|
|
Hi there,
I am trying to insert some data into a database table and am getting an error which says
"String or binary data would be truncated. The statement has been terminated. "
What is the problem here pls help.
The error is at the ExecuteNonQuery Line 2nd last line.
Dim insertCommand As SqlCommand<br />
Dim strConnection As String = "Data Source=cccc;Initial Catalog=Bccc;Integrated Security=True"<br />
Dim objConnection As New SqlConnection(strConnection)<br />
Dim strRate As String = "INSERT INTO tblTable(FkPId,RateType) VALUES (@PId,@Rate)"<br />
insertCommand = New SqlCommand(strRate, objConnection) <br />
objConnection.Open()<br />
<br />
insertCommand.Parameters.AddWithValue("@PId", ddlRooms.SelectedValue)<br />
insertCommand.Parameters.AddWithValue("@Rate", ddlRate.SelectedValue)<br />
<br />
insertCommand.ExecuteNonQuery()<br />
objConnection.Close()<br />
allphpro
|
|
|
|
|
the error means the size of rate (probably a text field) is to big. Like putting a 10 char string in a 5 char field. Could you be trying to put a rate into ratetype by mistake.
For what it is worth, I would use a stored proc.
I didn't get any requirements for the signature
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
