Thanks for the help. Project works fine. Please see link below which serves as my guidance. http://www.devarticles.com/c/a/C-Sharp/Socket-Programming-in-C-sharp-Part-II/1/[^]

Dabsukol

It is a window service. It will run in the background and pull data from the server then save to the databse. My Client program will read the updated value from DB

Dabsukol

Hi, Really need help and guidance. I need to pull data from server if there is available data, it shouldn't interrupt users action while data is being pulled. Scenario: Login to connect Pull data if available once complete, process wait for the next data.. I tried different approach but failed. New to asynchronous 1. The link below is working but failed and timeout expired in the middle. https://msdn.microsoft.com/en-us/library/bew39x2a(v=vs.110).aspx[^] It's eating all my time. :confused: Really Appreciate

Dabsukol

Hi, I have a SP that calculates data based on criteria, the result were % and duration. It takes 8-10 seconds before it displays the result. The problem is when more users are trying to generate the report, it seems that it takes more time. My problem was when I tried to update a simple statement such as below, it resulted to a "time out expired" and it affects the entire process of the application becuase users cannot perform their task.

update table
set status = 1
where keyId = 6

I don't have any locking on my select nor update. What is the best practice to resolve it? I have 100 users nationwide aside from report users, please need help. Thanks in advance Dabuskol

Dabsukol

excel files are saved in a database for every record created. What I need is to read this files of every record let say 10 records per run then automatically read the content of each file to a grid for display purposes. In the end all the contect of 10 excel files is displayed in the grid for viewing. no human intervention, automatic with a single button. Regards

Dabsukol

I need to create a routine that reads all the excel files saved from sql DB. If I have 40 excel files in my DB. I need to extract all one at a time then read the content of the excel file, save it to a grid for reporting. Excel is in standard template with only 4 columns. Hope you could enlighten this. Regards Dabuskol

Dabsukol

How to read a users/group in my local machine at the same time can update and delete users. I am currently doing it manually and it takes a lot of time doing that. I am developing it in c#. Local machine not windows directory using network domain. Thanks even link on how to that will do

Dabsukol

Thanks it works in .NET

Dabsukol

Hi, I have a lot of URLS / web programs. I need to create a default page which consist of two columns. Left column which has link button will call the url and display the existing url to the right column of my default page. It can be done using html. Is there a way to do it in .NET version? using web. Thanks

Dabsukol

Most of the time there are two/three record in the table. How can you do it in SQL IF Status = 1 or status = 0 THEN Desc = "In Progress" TabID Status T1 1 T1 0 If Status = 1 or status = 1 THEN Desc = "Ok" TabID Status T1 1 T1 1 If status = 0 or status = 0 THEN Desc = "failed" TabID Status T1 0 T1 0 Select should give me 1 row only My example is not correct, kindly enhance.

select tabid, GroupDesc = case when groupstatus = '1' or groupstatus = '0' then 'In Progress'
else 'Ok' end
from tab1
where tabid = T1

Dabsukol

Thanks for the information. I will check with our server log the real problem and at the same time try to see for other solutions. I will keep you posted.

Dabsukol

Hi, I have a webservice that send bulk SMS and it works for English language. The problem is when users send SMS using ARABIC text no SMS is receieved. Please help me to improve or change my code so it will work for arabic characters. I think the problem is when converting the string to UTF-8 code. MY Webservice:

http://10.45.98.198:8080/Script/SMSArabicEnglish.jws?wsdl

MY C# Code that send the message to my webservice. string sMessage = وقت البلاغ:" ; byte[] utfCodes = System.Text.Encoding.UTF8.GetBytes(sMessage); //second solution

SendGSM.send_sms(utfCodes);

Dabsukol

I have a list like excel format in the list, Org Code Title Function 62,171,616 BAT To develop as per users request 62,171,616 BAT To Maintain existing systems under NO/NI I want to read the Org Code and display the function on every page of the site depending on the title that I will pass as parameter. FROM THIS SITE

http://po.abv.com.sa/Lists/NO%20Organizational%20Functions/AllItems.aspx[^]

TO THE FRONT PAGE OF THIS SITE

http://po.abv.com.sa/PS/BAT/default.aspx[^]

Regards

Dabsukol

Hi, I need to go to All Site Content -> LIST -> PersoanlGroup --> Pesonal group have record in excel format and I need to read it and display it another site. please help since I am confuse ehre to start. Regrds

Dabsukol

Hi, I have 10 different sites in my sharepoint application and I need to limit the Disk or size per site.for Each Site 5GB only, Is there a way to set the size quota using the Sharepoint Admin? I tried to adjust the size quota but it affected the entire web application not the specific site. Best Regards Dabuskol

Dabsukol

Hi, I have a table with 2,000,000 records and there is no way for me to filter it by range. I was able to get the first 1,000,000, my problem is to get the next 1,000,000 without any duplicates from the first 1M records. Any Idea. SELECT TOP 1000000 * from Table1 how about the next 1M?? Pls..

Dabsukol

You are correct... Thanks for the immediate reply you save me on my last minute. Thanks...

Dabsukol

Help!!! How can I find specific value from a field in a select list where the specific value varies in position. ex; Record1 A-'Telec:144' Record1 B-'Telecom:145' How to find the ":" using the SQL so I can get the 2 value in one field.. pls.. Dabuskol

Dabsukol

Hi, Do you have any idea on how to attache image/docs/pdf saved from SQL DB then send it to email? All the attachements of diff. docs are all saved in our SQL DB, they want me to send the attched files as per record at attachment to email. PLSzzz.

Dabsukol

Hi, I have a system web page (c#) that is running within the company there is one process in the system that needs approval from vendor/supplier within the company (separate office). The request is that thay just want to receive email notification for approval using MS outlook and then there are 2 buttons (approved/reject) either of the two should execute the SQL statement that will update the flag of the record table. Any suggestions on how to do it? My solution: I created a web page where all the updates for approve/reject was there. I can send outlook message to the users with 2 buttons. Once he click either of the two it will run the web page and should execute the SQL statement. Unfortunately, nothing happen. At the same time the web page should close automatically. Regards

Dabsukol