Posts by srikkanthan

I have an issue like, I need to insert data from an XML file into MS Access table. I am able to do this with ADO as one by one row. But this terribly hits the performance when the number of rows to be inserted exceeds 1000. Kindly help with any idea.

(In SQL Server 2000, we have this OPENXML capabilities - Is there any 3rd party tool, library to do this in MS Access ?)

For the whizkids out there, CAPICOM library is available in the following URL:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=860EE43A-A843-462F-ABB5-FF88EA5896F6

This is an update for this thread. If we use digital certificates purchased from Certification Authorities like Verisign, a second dialog box with the Publisher name (with my company name as publisher) appears and asks the user do you trust this publisher. This is somewhat ok.

Adding to this, one more requirement added to this issue. I need to use this digital certificates "on the fly" at runtime. Meaning i need to sign files dynamically before they are about to be downloaded.

I found that Microsoft CAPICOM library will be useful for signing files dyanmically on the fly before downloads. But I am not able to use it properly - it is not as simple as you give the spc and pvk file - it signs the download file - not like that. Anybody used CAPICOM before?

There are lot more capabilities in VB.NET than in VB6 -

check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbCode/html/vbtskCodeExampleDrawingLineOnForm.asp

There are a couple of msm files (managed modules, remember?) for bundling crystal reports with applications. And there are a couple of licence issues too...

You might want to checkout
http://support.businessobjects.com/communityCS/TechnicalPapers/crxi_net_deployment.pdf.asp?ref=devzone_netzone_main

I hope you are using SQL Server. you can run a command for sp_tables right? - populate the resultset in the treeview.

From the code, what i understand is when u click the button, the random number is generated and that particular word is pulled out. If it is NOT used then you are taking that word. But what if it is used?? u want the user to click the button again to get "again" a random number? so if all the words are "used" - the user will be kept clicking the button forever wondering why no word is appearing right? I think u need to run a loop here to get the word that is not used along with a condition that "all words" are not yet used. Say if 100 words are there and if all of them are not used then only u should run this loop.

By the way, do remember to check your word file for duplicate words ;)))

Do you want to exclude just sundays? or you already have a list of public holidays? how are u defining a public holiday?

You are right. We again checked with Microsoft. They have confirmed this warning cannot be evaded even if we use digital certificates. No other way but to compromise with this.

I hear lot about this. Can anyone let me learn what is "Symmetric" and "Asymmetric" (or Public Key) encryption?

Any links also appreciated.

Hi
I have a web page - in that i give a link to exe file. When the user clicks on the link the exe is supposed to be downloaded and executed in the user's system. (I am not writing any malicious code or virus :rolleyes: )

However, when i try to download that executable a messagebox with prompts as follows:
==================================
Title: File Download - Security Warning
Name: Setup.exe
From: localhost

Buttons: [Run] [Save] [Cancel]

While files from internet can be useful, this file type can potentially harm your computer. If you do not trust the source, do not run or save this software. (link: ) What's the risk?
================================

I don't want to display this messagebox. I got the information like, I need to "Digitally sign" my executable - so that the user can trust the Digital Certificate and its publisher. I am ready to buy any digital certificate from any CA such as Verisign etc. Anyway, Before that to make sure, I tried with sample certificates generated using "makecert.exe" and "cert2spc.exe" and other tools. They have mentioned like these sample certificates work in intranet. However, still the warning pops up. I am not able to stop that. This happens only in the Windows XP - SP 2 systems.

Few other links i found to create sample digital certificates:

http://winfx.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_fxtools/html/b0343f8e-9c41-4852-a85c-f8a0c408cf0d.asp

http://winfx.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_fxtools/html/be434d7d-9c0d-46e7-8392-58a9b542d11d.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpgrfcertificatecreationtoolmakecertexe.asp

http://www.source-code.biz/snippets/vbasic/3.htm

You can use the ItemDatabound event in the datagrid for this. Add this ItemDataBound event of the datagrid and inside the event function - you could do something like in the following code:

If <<logic to find to span or not to span>> Then
e.Item.Cells(4).RowSpan = <<number of rows to be spanned>>
Else
e.Item.Cells(4).Visible = False
End If

Here the column number 4 in the grid is assumed as the checkbox column.

I see many of the sites like yahoo mail are using a technology "Web beacon". (You can see this in their privacy/private policy statements). I couldn't get much information about this. All i know is, these Web Beacons are tiny one pixel images used to track the user activity in a page such as how many time he accesses the page.

I would like to know where can i get more information on Web Beacons and can I use it in my programs too.

could you explain lil more? (if you wish, my mail id is srikkanthan@yahoo.co.in)

am i wrong or unclear about my issue...

Let me add one more, If you create a com+ component with ActivationOption.Server, you can't have methods that return objects (MarshalByRef)... I tried and got Remoting exceptions...

Only in ActivationOption.Library, I am able to return my custom objects... Even after implementing ISerializable or <Serializable> attribute it didn't worked for me (alas). Can anybody tried returning custom object as well as other .NET objects itself like ArrayList...

In webservices, it is understandable that the contract is text based but COM+ being binary contract, it should work isn't it....

I never get ok with the COM+ contexts... There are so many context types like client context, call context etc... Adding to this .NET provides few attributes such as MustRunInClientContext... I couldn't find any sample or links that explain this...

Let me elaborate more. As the definition goes by saying "context" is a conceptual grouping of objects within a transaction. However when u instantiate a COM+ component (TransactionOption.Supported) within another COM+ component (TransactionOption.RequiresNew), when i check the ContextUtil.ContextID, the two components are instantiated in different contexts... WHY?

Secondly, the definition says MustRunInClientContext runs the component in the client context but if try this with the above component (TransactionOption.Supported) it most always results in an exception... WHY?

Third and final, this is different from contexts but i just found this... Just create a COM+ component (Inherit ServicedComponent, Set transaction - every thing normal - you can do this simply by selecting Transaction Component template in VB.NET)... If you give description attribute to any of the methods, you will get method level rolebased security exception - if you remove the description attribute, you won't get this exception...

phew, COM+ seems to be a land of uncertainty....

why don't u try and a reference to System.Web assembly (Project->Add Reference)....

Very "professional"

You can also set the DropDownStyle property in the ComboBox to get an editable combo or dropdown list...

Compare the data where... if in the client side, while loading the page itself you need to put the initial value in some javascript variable or hidden control. If in the server side, you can actually put the data in a whole lot of places. ViewState, Session, Cache etc.. are some of the places (viewstate is better in that you can even put your dataset itself without costing the server memory)....

It strikes me that the application downloaded this way (href="<<url>>\xyz.exe") runs under partially trusted context. So as you have mentioned about WMI et all... i am not sure u can do that...

One more link on how to deploy applications with this method:
http://msdn.microsoft.com/msdnmag/issues/03/10/BasicInstincts/default.aspx

I am not sure what exactly you want to do... Obviously by looping through
mySet.Tables(0).Rows(i)("PERMISSION_BUTTON_ID") you can get all button ids... right?!

Simply you can put a href to that exe.

See these links:
http://msdn.microsoft.com/vbasic/letters/20030627/
http://www.sellsbrothers.com/wahoo/

Hi,
I have one ASP.NET page which allows users to upload their files which are stored in another system (file server) through simple network share. The code is as simple as
FileUpload.PostedFile.SaveAs(strPath)

Here this page gets "access denied" to save the file. I know the application is running under ASPNET local user account. So i even can't give privileges to save file for this local account in another target system.

I solved this problem by using impersonation tags as below in the web.config :

<identity impersonate="true" userid=xxx password=yyyy />

But i have to specify user id and password explicitly in plain text here....
Is there anyway i avoid specifying user id and password like this?

See, the information about C++/CLI 2005:

http://msdn.microsoft.com/visualc/default.aspx?pull=/msdnmag/issues/04/05/visualc2005/default.aspx

In ADO and VB6, you can just place some textboxes and ADO Data control and bind those textboxes to the data control and columns. Simple that you can navigate through records easily by just clicking arrow buttons.

Ever wondered how to do it with ADO.NET (and dataset)...

The following link provides a complete example with exhaustive definition...

http://support.microsoft.com/default.aspx?scid=kb;en-us;311543