Hi All I want to know is there any extended procedure in sql to find out by which authentication mode sql server is connected.I want to use it in c# application . Thanks in advance

Regards DilipRam

You can directly check the path using if(System.IO.File.Exists(Path))

Regards DilipRam

Thanks for the information

Regards DilipRam

Hi create two ports which should be available in network one is for listening and one is for recieving that means listner port will be the receiver port in another side and vice versa then inside the listen method use the start method and send method inside the reciever method use the start method and recieve method of socket ..after that use stop method or close method in connectin close Hope u have got some fair idea from this.Lots of examples are their in code project...

Regards DilipRam

Hi All I am facing a strange issue and i am working on this issue for last one week,but i am not able to find it.I have a window service which reads the MSMQ .This windows service will do only this function.Now, when some thing is written to MSMQ, window service will read the msmq.Now there is nothing in queue ,then also it will loop and if some thing comes inside the msmq then again it will read ...this works fine if i am doing in regular intervals. Now if am not doing any operations for two or three hours ,then status of windows service will be started but it will not reading the msmq,and it is not throwing any error..also...this is the strange thing i am facing..why it is behaving like this.Can any one help me in this idea.I am pasting the start section of of mywindows service here .can any one tell me what is wrong in this code.Thanks in advance this code i am calling inside a thread.. try { MessageQueue mq = null; System.Messaging.Message msg = null; while(true) { //MessageQueue mq = null; //System.Messaging.Message msg = null; try { if(mq == null) { mq = new System.Messaging.MessageQueue (XMLReprocessMSMQPath); } RemoteLoggingManager.LogMessage(LoggingMessageTypes.Error, APPLICATIONNAME,"Read Queue", LoggingMessageTargets.Both); msg = mq.Receive(new TimeSpan(0,0,0,10,0)); RemoteLoggingManager.LogMessage(LoggingMessageTypes.Error, APPLICATIONNAME,"Data Rec", LoggingMessageTargets.Both); msg.Formatter = new ActiveXMessageFormatter(); XMLReprocessMSMQFileName=ReceiveMessage(msg.Body.ToString()); SendXMLToWebervice(XMLReprocessMSMQFileName); } catch (System.Messaging.MessageQueueException ex) { if(ex.ErrorCode != -2147467259) // Ignore timeout error { RemoteLoggingManager.LogMessage(LoggingMessageTypes.Error, APPLICATIONNAME,ex.ToString(), LoggingMessageTargets.Both); mq.Close(); mq.Dispose(); mq = null; MessageQueue.ClearConnectionCache(); Thread.Sleep(10000); } else { mq = null; } } catch (Exception ex) { RemoteLoggingManager.LogMessage(LoggingMessageTypes.Error, APPLICATIONNAME,ex.ToString(), LoggingMessageTargets.Both); mq.Close(); mq.Dispose(); mq = null; MessageQueue.ClearConnectionCache(); } } } catch(Exception ex) { RemoteLoggingManager.LogMessage(LoggingMessageTypes.Informatio

Thanks for the reply

Regards DilipRam

Hi all I have created a window service which just starts a thread on its start method.it was working fine.Now when i stopped the service and just restart the service without any changes i am getting an error "could not restart the service The service didnot respond to the start or control request in a timely fashion" Why is it so.Can any one pls help me Thanks in advance

Regards DilipRam

Hi Please give me an idea how to change the layout of an excel file through c# coding.If i am opening the printer dialogue box the then change the layout, the printing layout is working fine but it doesnt the layout of the excel Thanks in advance.

Regards DilipRam

Hi How can i check Day Light saving time in sql. I know there is a inbuilt function called ISDST in C# , but i want that check to be done in Sql procedure.Thanks in Advance

Regards DilipRam

Hi all I have a datagrid developed in 2005.I am populating datatable with recordset and assigning the datatable to the datasource of grid.The data contains one parent and its child..so when i click on parent automatically its child will also be selected.Now if sort the grid based on any columns my entire selection logic will fail that means datatable is not updated as i sort the datagrid and hence my logic fails.How can i over come it.When i was searching the net i found that use some default view of grid then go for it ,but i am not clear on it.Can any one help me on this

Regards DilipRam

Hi thanks for the reply I have set the property to false and havent set any thing in code but also when i am clicking on the col headers it is sorting...

Regards DilipRam

Hi I want to disable the sorting property of datagrid .I set the allowsorting property to false but still i am able to sort on clicking it How can i do it Thanks in advance

Regards DilipRam

Hi No its not any thing realted with spelling...

Regards DilipRam

Hi all. I have an application which reads a msmq path from the config file and passes to an storedprocedure.The entry in config file is as follows Now i am storing it a string variable called "XMLMSMQRecievePath" and passed to the storedprocedure name "UpdateAuditLogDetails" using folowing stmts daUpdateAuditLogDetails.SelectCommand.Parameters["@XMLMSMQRecievePath"].Value = XMLMSMQRecievePath; daUpdateAuditLogDetails.Fill(dsUpdateAuditLogDetails, "UpdateAuditLogDetails"); but i am getting the error as following Error, Number = 0x10001165, Source = \"MSMQQueueInfo\", Desc = \"The specified format name is invalid. \""} My storeed procedure accepts a varchar of size 2000 for it,Can any one help me on this

Regards DilipRam

Hi thanks for the reply Actually i have an application which will recieve messages from some other application.It can happen at any time.Now i have a recieve method for this purpose..but i dont want to do any operations as soon as i recieve any id but i want it to be used later .So inorder to not loose the incoming id, i decided to used string builder so that i can append one by one the id's which are coming..but now if i want to extract it or split it,,i dont have any split method in string builder ,its only in string ..so what do i need to do. Hope i am clear.

Regards DilipRam

Hi thanks for the reply But no idea on how to work with stacks and queues...

Regards DilipRam

Hi Thanks for the reply.The think here is that i will be having multiple strings coming from other application.It will be not single one or it can come any time and i need them for futher processing.So i am using string builder ,,but then how can i split these ids from the string builder.I hope i am clear abt my requirment

Regards DilipRam

Hi thanks for the reply,but the thing is that i will not be having single string value...there will be multiples values coming and i have to store it and so i how can use a string to store it.pls explain

Regards DilipRam

Hi all. I have an application which will recieve ids from some other application. Now i need to store the incoming ids to a string builder, so that i can use it for later use.For this i have created a string builder as follows stringbuilder strIncomingEventID=new stringBuilder() and inside the receiving method i used the below stmts strIncomingEventID.Append(incomingmessage + Convert.ToChar(FIELD_SEP) ) now i want to retrieve each ids from it..for my manipulation... i am not getting split properties or any thing which is useful..can any one help me in this .One more thing is that i am appending a constant FIELD_SEP to end of incoming message when i store , so that when i want to retrieve the ids ,it will be useful..is it right method.Please advise me how to get the value from the string builder Thanks in advance

Regards DilipRam

Hi thanks for the reply, but i am not getting dataGridAuthorised.Rows property Any idea

Regards DilipRam