Getting an error "No value given for one or more required parameters." if any of the following queries are used. > SELECT C, D, F FROM SHEET1$ > SELECT COLUMN3, COLUMN4 FROM SHEET1$ And yes tried searching MSDN as well. The process is still on. Regards.

Dear All Normally the query used to read Excel file is "SELECT * FROM SHEET1$" Can anoyone help on how can we read specific columns using the query. For Eg. If we wan to read only columns C, D, and F then is there anything like "SELECT C, D, F FROM SHEET1$" Regards.

I'm trying to unregister a channel which was registered using a configuration file (using RemotingConfiguration.Configure). I can't use: ChannelServices.Unregister(mychannel) because I do not have a channel object because I did not register it manually. I could use: IChannel this_channel = ChannelServices.GetChannel(my_channel_name); ChannelServices.UnregisterChannel(this_channel); but as the channel name is specified in the configuration file, I don't want to hardcode in the code. I don't want to unregister all the channels, just the one I'm currently using. Is there any way to do this? Or am I better off just reading the xml config file for the channel settings and then setting up the channels programmatically? X|

Is there any way by which i can find out the name of the current running schedule task. [consider multiple schedule tasks running at a time.] For more info on scheduler task component please refer following links; http://www.codeproject.com/csharp/taskschedulerlibrary.asp http://www.codeproject.com/csharp/TSNewLib.asp

I am creating an new scheduled task using vb.net. I need to pass a parameter to it. Can it be done in name=value format. Also how can i read it in other vb.net program which is scheduled. For e.g., If I pass parameter as follows: t.Parameters = "name=" & name then how can i read this parameter from the scheduled program. For more info on scheduler task component please refer following links; http://www.codeproject.com/csharp/taskschedulerlibrary.asp http://www.codeproject.com/csharp/TSNewLib.asp Thanks for obliging.

Why is that without setting any filters the mails are sent to junk folder rather than inbox. This happens at hotmail, indiatimes, etc.. Kindly help and oblige. Thank you. Vipul Bhatt

well that's absolutely right. So is there anything that i can do to find the list of SQl servers in the network on these OSs. Thanks.

Thanks it works fine. what do i need to do to use netapi32.dll in win9x/NT. More help please. Thanks.

windows 9x/NT does not support netapi32.dll. can anyone let me know on how to use netserverenum on these OSs or should i use any other api. Kindly help. Thanks in advance. :zzz:

How do i declare & use "HttpSendRequest" in VB.NET Thanks in advance

Kindly check datatypes and data & also if the length of the data does not exceed the maximum length. VIPUL BHATT

I need to send XML data to a site and receive the processed info. Can any one suggest me how to go about it ? Thanks in advance. VIPUL BHATT

Try first coping this file elsewhere (thru' windows explorer) then delete it from your project and add it. Just give it a try.

Thanks Richard, only one change required: currentItem = DirectCast(Marshal.PtrToStructure(TempBufPtr, tS), tS) Just replace tS with Object as below currentItem = DirectCast(Marshal.PtrToStructure(TempBufPtr, tS), Object) A big thanks to you. :cool:

It worked A BIG THANKS RICHARDS. Great help. God bless you.

Thanks Richard. Great help. Can U pls. tell me how can i use the RtlMoveMemory in VB.NET and also do i need to convert pointer to string later. If yes please tell how do i do that. I tried using marshal.PtrToStringUni but in vain. hope i will get similar response as earlier. Thanks in advance. :cool:

I have declared 'NetServerEnum' function in module as follows; Public Declare Function NetServerEnum Lib "netapi32.dll" ( _ ByVal servername As String, _ ByVal level As Integer, _ ByRef buffer As Integer, _ ByRef prefmaxlen As Integer, _ ByVal entriesread As Integer, _ ByVal totalentries As Integer, _ ByVal servertype As Integer, _ ByVal domain As String, _ ByVal resumehandle As Integer) As Integer when i call it, i get an error saying "Object reference not set to an instance of an object." Can anyone help me out? Thanks in advance.