ASP.NET Discussion Boards

Michael Bookatz23-Jun-08 6:14

23-Jun-08 6:14

Are you inserting into a database? If so you can check when inserting that you don't put in a duplicate record with in a time frame of 30 seconds.

Saving a form to database

ferronrsmith23-Jun-08 4:30

ferronrsmith

23-Jun-08 4:30

I created a form in asp.net, when users clicks submit (after validation), i want the form to be saved to database, any help???

Ferron

Re: Saving a form to database

www.Developerof.NET23-Jun-08 4:47

www.Developerof.NET

23-Jun-08 4:47

Ok u need help following will help you

.
.
.
.
Go and read a book, try it, and if u get any prob post it here

When you fail to plan, you are planning to fail.

Re: Saving a form to database

Christian Graus23-Jun-08 11:40

Christian Graus

23-Jun-08 11:40

What do you mean by saving a form to a database ? The data in the form ? It's overall state ? A form is an instance of a class, you can't save the whole form and restore it, not as such. You can write code to save whatever data you want from the form, and restore that from the DB.

Christian Graus

Please read this if you don't understand the answer I've given you

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

Accessing local device from a webpage

Michael Bookatz23-Jun-08 3:57

Michael Bookatz

23-Jun-08 3:57

Hi there,

I am currently looking to convert a winform app to asp.net and am having a problem.

The problem is that I have a device I need to read a setting from attached to the local machine and then passed back to the server.

I have a dll that is used to access the device which can be installed on the clients machine but am not sure how to access it from the page. the dll can be installed on the client machine

The code used in the winform app is

m_MHE = new MHE();
m_MHEOpenValue = m_MHE.Open();
m_Old = m_MHE.CurrentValue;
m_MHE.Enabled = true;

Thank you for any help

Michael

Re: Accessing local device from a webpage

N a v a n e e t h23-Jun-08 4:28

N a v a n e e t h

23-Jun-08 4:28

I don't think that ASP.NET can do this. Probably creating an Activex control may work, I am not sure though.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Accessing local device from a webpage

Michael Bookatz23-Jun-08 6:09

Michael Bookatz

23-Jun-08 6:09

Thanks for the answer - I felt this may be the answer. Is it the same for using the gdi printing to a printer.

Domain Alias

Member 367100623-Jun-08 3:44

Member 3671006

23-Jun-08 3:44

I have 5 different domain alias for my website; I want to know the alias in my asp.net code and want to display the page accordingly; say
For alias "http://aliasIndia" I want to open India.aspx
For alias "http://aliasCanada" I want to open Canada.aspx and so on.
My question is how do I know by which alias user came to my website so I can redirect to proper page; right now for each alias my default page is opening.

Re: Domain Alias

N a v a n e e t h23-Jun-08 4:29

N a v a n e e t h

23-Jun-08 4:29

Check the URL (Request.RawURL). Look for the text and redirect to proper page.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Domain Alias

Guffa23-Jun-08 4:48

Guffa

23-Jun-08 4:48

The Page.Url.Host property returns the domain name that was used to get to the site.

Despite everything, the person most likely to be fooling you next is yourself.

Listbox/DataValueField

Assaf8223-Jun-08 2:49

Assaf82

23-Jun-08 2:49

Hello
How i can retrieve from the combobox the DataValueField of a selectedItem

Please Help

And Thanks in Advance

Assaf

Re: Listbox/DataValueField

SathyaSiva23-Jun-08 3:08

SathyaSiva

23-Jun-08 3:08

Use like this
Combobox1.Selectedvalue

Sathya

Problems while placing the usercontrol

dayakar_dn23-Jun-08 2:23

dayakar_dn

23-Jun-08 2:23

Hi,

I created one user control. Now i am trying to placing that user control either in the master page or in the .aspx page that time i am getting an error in the design mode and the error is "an unhandled exception occurred request is not available in this context".

If any body knows the solution please let me know.

I registered that user control in the .aspx and master page, But still i am getting the above mentioned error.

Thanks and Regards
RakayaD

Re: Problems while placing the usercontrol

Christian Graus23-Jun-08 2:26

Christian Graus

23-Jun-08 2:26

Here[^].

Also check out the article I link to in my sig.

How to use LoginStaus Control in master page without ' Membership provider & Configure Security Using the Website Administration Tool '

K V Sekhar23-Jun-08 2:17

K V Sekhar

23-Jun-08 2:17

Hi ,

I want to use LoginStatus control in master page.

How do i use LoginStaus Control in master page without ' Membership provider' and with out 'Configure Security Using the Website Administration Tool '.

What are the changes to be done on web.config.

i have not used any Login Control for Login. I designed a separate page for Login. 'LoginPage.aspx'.

Thanks in advance.

Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

mcmilan23-Jun-08 1:47

mcmilan

23-Jun-08 1:47

Hi,
I am developing a web application in which the customer/user register(enter)with their complaints. When the End user enters all the required data and clicks the Register button automatically a unique number should be generated. For instance the number should be in the format like 23/Mar/2008/001 and for every new user the number should be incremented if according to the system date. If the system date changes then the number should be start again from current date/001........

Thank you
Dsr

Re: Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

Ashfield23-Jun-08 1:58

Ashfield

23-Jun-08 1:58

So what do you want to know? How to do it? Where, in a database or in the web app?

Please try to help yourself by being specific with what you want - nobody else knows what you are working on

Bob
Ashfield Consultants Ltd

Re: Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

mcmilan24-Jun-08 3:17

mcmilan

24-Jun-08 3:17

I want, how to do it? And in the database.

Re: Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

Arindam Tewary23-Jun-08 2:26

Arindam Tewary

23-Jun-08 2:26

Hi Mcmilan,

You can have a logic like this .. try it out .. could be helpful,

Before that following code part gives

--SQL SERVER 2005 code assuming that this ID will be generated at the time of insertion of values into DB

declare @currDate varchar(20),
        @NextID varchar(20)
select @currDate = replace(convert(varchar,getdate(),106),' ','/') 
print @currDate -- PRINTS 23/Jun/2008 FOR TODAY !!

Pseudocode ..........................................

set @CurrentDate = select replace(convert(varchar,getdate(),106),' ','/')
select @MaxuserID = Max(UserIDColumn) from UserTable -- Consideing your table name is "UserTable" and Column name is "UserIDColumn"
if(@CurrentDate is a SUBSTRING of @MaxuserID)
{
get @dateExcludedIndexPart from @MaxuserID -- here you should get 001 from "23/Mar/2008/001"
@dateExcludedIndexPart++
@NextID = @CurrentDate + @dateExcludedIndexPart
}
else
{
@NextID = @CurrentDate + '001' -- First ID value of the day ..
}

I know there could be more better algo for your requirement !!! But you can give a try ...

Thanks,
Arindam D Tewary

Re: Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

mcmilan25-Jun-08 0:53

mcmilan

25-Jun-08 0:53

Thank you Arindam D Tewary,
I have one more doubt ,...where should I write the code? In stored procedure or in aspx.cs page............

Please help me in this...

Thank you
Mcmilan

Re: Generating autonumber with date format like 23/Mar/2008/001 when the new record is inserted

Arindam Tewary25-Jun-08 3:39

Arindam Tewary

25-Jun-08 3:39

It should be in SQL server!! I have already mentioned that in reply ...

Thanks,
Arindam D Tewary

HTML to Excel from ASP.Net

Biju Sam23-Jun-08 0:48

Biju Sam

23-Jun-08 0:48

Hi I have a trange requirement which is as follows:
I have a HTML file with records which looks like a List View in ASP.NET. Please note that it is like a List view and not like a Datagrid.
But this is inside a single table.
I have to take this data and export it to excel in a DataGrid type of view.
One more problem i see in this HTML file is, say suppose there are 200 records which is displayed in that List view, if the first record has values, the second might have 12.
So the resulting excel sheet should have columns with maximum colums what the List view had.

HTML looks something this:

lt;table class='basic' width='100%' border='1' cellspacing='0'><tr class='header'><td valign='top' colspan=2 width='15%' class='sectionHeader'>Properties</td><tr><td valign='top' width='15%'>SI_ID</td><td valign='top'>15314</td></tr><tr><td valign='top' width='15%'>SI_NAME</td><td valign='top'>B&amp;C Share Top Dealers by Fund</td></tr><tr><td valign='top' width='15%'>SI_OWNER</td><td valign='top'>sweekev-a</td></tr><tr><td valign='top' width='15%'>SI_PARENT_FOLDER</td><td valign='top'>6294</td></tr><tr><td valign='top' width='15%'>SI_UPDATE_TS</td><td valign='top'>2/13/2008 4:59:01 PM</td></tr><tr><td valign='top' width='15%'>SI_CREATION_TIME</td><td valign='top'>2/13/2008 4:59:01 PM</td></tr><tr><td valign='top' width='15%'>SI_KIND</td><td valign='top'>Excel</td></tr><tr><td valign='top' width='15%'>SI_PROGID</td><td valign='top'>CrystalEnterprise.Excel</td></tr><tr><td valign='top' width='15%'>SI_FILES</td><td valign='top'><table class='basic' width='100%' border='1' cellspacing='0'><tr><td valign='top' width='15%'>SI_PATH</td><td

Re: HTML to Excel from ASP.Net

Christian Graus23-Jun-08 0:55

Christian Graus

23-Jun-08 0:55

Biju Sam wrote:
export it to excel in a DataGrid type of view.

So, you need to take your data source, use it to create an Excel file, then send it to the client.

Re: HTML to Excel from ASP.Net

Arindam Tewary23-Jun-08 0:59

Arindam Tewary

23-Jun-08 0:59

Hi,
Though I didnt get your problem very nicely .. But still I would try to help you out from what I understood ..

1.Use some Regular Expression to extract all data( I suppose in side each cell of your HTML table is your data right?), which you need to show in each cell of your excel.
2.using Extracted data create an XML.
3.Export the XML values to datagrid or Excel what ever you required.

Thanks,
Arindam D Tewary

window authentication

Pankaj Garg23-Jun-08 0:32

Pankaj Garg

23-Jun-08 0:32

do u have ay link to implement the window authentication(active directory)?

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.