ASP.NET

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

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

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

HTML to Excel from ASP.Net

25-Jun-08 3:39

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

Thanks,
Arindam D Tewary

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

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!

Arindam Tewary23-Jun-08 0:36

23-Jun-08 0:36

[^]

Thanks,
Arindam D Tewary

vinay_K23-Jun-08 0:46

23-Jun-08 0:46

You mean to say, you want to authenticate with system login information. Like authenticating using Active directory server in your application..?

Pankaj Garg23-Jun-08 0:48

Pankaj Garg

23-Jun-08 0:48

yes

vinay_K23-Jun-08 1:18

23-Jun-08 1:18

Use LDAP provider to connect to ADS Server and Validate the username and password in the server, If it is correct it will return true/valid otherwise false....

ex:

DirectoryEntry("LDAP:/dc=name, dc= domain name, ou=....");

Hope it helps for you..

Pankaj Garg23-Jun-08 1:36

Pankaj Garg

23-Jun-08 1:36

Dim entry As New DirectoryEntry("LDAP://" + "192.168.1.16", "shadow-16", "pankaj")

the first parameter is ip address
second is full computer name , the system properties in my computer
third parameter is window password , my log in to the computer , window ask me the password.
Am i going correct ?

vinay_K23-Jun-08 3:53

23-Jun-08 3:53

dont give computer name, computer name is given in place of IP addrdss, u can connect through IP address/ Machine name..

use the folloeing code..

Dim entry As New DirectoryEntry("LDAP://" + "192.168.1.16", "User Windows Login Name", "User Password");

if this answer is usefull please mark this as Useful.

Hi..

vinay_K23-Jun-08 0:26