i have a table "Activity" contains two column "personid1" "personid2". i have to select those two column with the personname from person table. how should i write the query?

I am Entry level person

i have a database table to store all the article content which has a field is memo data type to store all the article content(generally contains richtext). how to use asp.net to read from a word document then store the content into this field?

I am Entry level person

drop table [dbo].[TableName]

I am Entry level person

i did a function to replace invalid characters. i used replace(@description, chr(180), N'') but it is replacing number 3 with empty string as well. why it does this? is there a setting for text comparison in SQL related to this problem?

I am Entry level person

both way is good, but just FTP is file transfer so u may have problem with add new line into the existing file. i used webservice with is really handy

I am Entry level person

CSV file is just normal textfile with coma. u can use streamreader to get all the lines in the file!

I am Entry level person

i used mydataAdapter.selectcommand.cancel to cancel that operation. it returns a error which is cancelbyuser sqlexeption I am Entry level person

When i use Dataadapter to fill datatable, if the data amount is huge, the user has to wait for a long time, so maybe they want to cancel that operation, how to do that ? SqldataAdapter.fill(mydataset.mydatatable) how to stop this operation I am Entry level person

i want to implement an ASP.net web apllication, when i change the dropdown list i want to textbox text change by itsself i have a event on the dropdown box which is selectedindexchanged code is Select Case Me.DropDownList1.SelectedItem.Text.ToUpper Case "TODAY" Me.TextBox1.Text = Now.Date & " 06:00:00 AM" Me.TextBox2.Text = Now.Date.AddDays(1) & " 05:59:59 AM" Case "YESTERDAY" Me.TextBox1.Text = Now.Date.AddDays(2) & " 05:59:59 AM" Me.TextBox2.Text = Now.Date & " 06:00:00 AM" End Select but it is not working even this event is not fired I am Entry level person

i want a function in the web service to return a xml file which contains multiple value i need, how to write this function ? using Array ??? I am Entry level person

i want a function in the web service to return a xml file which contains multiple value i need, how to write this function ? using Array ??? I am Entry level person

i am working on an application which is a door terminal application, now i want to implement a function which is when there is no one touch the application there is a screensaver application(which i also did it ) come up. how to implement this, especially how to detect no one touched the application within certain time! I am Entry level person

i have a webservice under C:\Inetpub\wwwroot\RetrieveData\ now i want this web service create a txt file under this folder i have changed the permission of this folder to write as well, but still when i run this webservice i get a exception which is C:\Inetpub\wwwroot\RetrieveData\ the path is denied! how to solve this problem ? pls help me! thank you very much! I am Entry level person

i have a webservice under C:\Inetpub\wwwroot\RetrieveData\ now i want this web service create a txt file under this folder i have changed the permission of this folder to write as well, but still when i run this webservice i get a exception which is C:\Inetpub\wwwroot\RetrieveData\ the path is denied! how to solve this problem ? pls help me! thank you very much! I am Entry level person

i have a webservice under C:\Inetpub\wwwroot\RetrieveData\ now i want this web service create a txt file under this folder i have changed the permission of this folder to write as well, but still when i run this webservice i get a exception which is C:\Inetpub\wwwroot\RetrieveData\ the path is denied! how to solve this problem ? pls help me! thank you very much! I am Entry level person

i have a webservice under C:\Inetpub\wwwroot\RetrieveData\ now i want this web service create a txt file under this folder i have changed the permission of this folder to write as well, but still when i run this webservice i get a exception which is C:\Inetpub\wwwroot\RetrieveData\ the path is denied! how to solve this problem ? pls help me! thank you very much! I am Entry level person

There is a Windows application sitting on Client A can make a request to the server which has a web service on it, then the server can create a Text file send to B and C, there is another windows application sitting on B and C which can read the text file then deal with the data included in the Txt file, and talk to database. i think for me the second solution is better. but how it works ? Can you give me some specific thing such as functions and reading material i can have a look and read?1 I am Entry level person

i have a windows application can make a request to the webservice, then the webservice deals with these request data and be able to create a Txt file with these data then send to another machine. if you have Email, i can pass some graph to you as well! I am Entry level person

if i want to send this file to another machine which is not the request machine is that possible ? I am Entry level person

i want to implement a webservice with windows application, and the webservice can create a txt file, but i just can not create this file on the server using streamwriter it says the path is denied, how can i solve this problem I am Entry level person