Thank U Mika, U made my job simpler , Though I was not searching for that, with ur previous sln I can proceed further. ------ Kiran

Sorry For not responding in time. I want to get a report of In the following way, If the user selects a "Bank" from dropdownlist, then he must get the list of all banks' amnts (may payable,receivable) towards that selected bank assume selected banks' Id is 1 (xyz bank) bankname Payable to(xyz) receivable from(xyz) aaa 1000 2000 bbb 2000 00.00 ccc 3000 4000 I have given the structure of my view. so how to generate this sort of report. what would be the query? I tried with this <pre>select T1.IssuedBank,T1.PaidBank,T1.Payable,T1.Receivable from Test_MergeView as T1 Left Join Test_MergeView as T2 ON T1.IssuedBank = T2.PaidBank and T1.PaidBank = T2.IssuedBank Where T1.PaidBank > T1.IssuedBank </pre> but if paidbankId is < issuedbankid that info is getting eliminated in display. to avoid rows 4,5 I used where clause. but other wanted info is also getting eliminated. ------ kiran

Thank U Mika, I want retain Rows(1,2). With ur query Rows (1,2,4,5) are getting eliminated. As rows 4,5 are having same data in other way I don't want to display it. If I show relation b/w Bank 'm' & 'n' I need not to Display the same relation b/w 'n' & 'm'. ------ Kiran

Thank U 'g', I am using sql server database. The data which I have given is from view not from table (sorry for mentioning it as table). What I exactly need is , I want to exclude redundant data while displaying, here when Bank '1' is payable "xxx" amnt to Bank '2', and receivable 'yyy' from bank '2', then bank '2' is receivable 'xxx' from bank '1', and payable 'yyy' to bank '1'. Hence my report should consists of either bank '1' info, or bank '2' info. In the same manner all banks info in one query.And field 'Row' is not a column. That I hav given for referance purpose. Kiran

I have a table with the following data Row | IssuedBankId | paidBankId | Payable | Receivable 1 | 1 | 2 | 1000 | 2000 _____________________________________________________________ 2 | 1 | 3 | 1100 | 3000 _____________________________________________________________ 3 | 1 | 4 | 4000 | 5000 _____________________________________________________________ 4 | 2 | 1 | 2000 | 1000 _____________________________________________________________ 5 | 3 | 1 | 3000 | 1100 _____________________________________________________________ 6 | 4 | 2 | 5000 | Null _____________________________________________________________ 7 | 5 | 4 | 1000 | Null I want to eliminate rows 4,5 bcoz we have the same info in row 1,2 respectively. Just payable, receivable amnts are interchanged. how can I get it. Please give me some Idea. Thaking You, Kiran.

hi all, I want to use Indian regionallanguages in my web site. In that I am using unicode Open Type font. But I don't know how to get the ".EOT" file of that font. Thank U all, Kiran

I am using AJAX Calendar Extendar Control in my application, But I don't want allow the user to select future dates. How do I do this without doing a postback? Thank U all, Kiran

Thank U Sherin, Can any one suggest a site for free down-load of "File down-load activex control" which meets my requirement.

Hi all, In my application I am using Response.TransmitFile to download a file on clients machine which, prompts the user where to save the file if the user clicks on save button. But I want to fix the location on clients system if he clicks on save button. Is it possible ? How do I meet this by any other means. Thank U all, Kiran

Hi all, I want to know how can I write data that has beeb read from sql server database to XML file. I doesn't have any Idea in working with XML. please suggest be how do I meet my requirement. Thank u all, kiran

Hi All, I want to copy a file from our remotely located web server to clients' machine when they are visiting a particular page on my web site. But how do I get their IP address if they are connected through proxy, Dial-up or any other sort of internet connection? I need your valueble suggestions. Thank U all, Kiran

Hi Jack, Thanks for ur response. But my actual requirement is as follows.., I uploaded an application to remotely located web server. Whoever the client calls that application it needs to send the content of its sqlserver database to clients' ms-access database. For this I need to establish a connection in that web-application to have access to clients' MS-Access data base. Irrespective of the connection i.e., whether it is from a proxy, Dial-Up, Broad band the data should flow exactly to the clients' system who is currently using that application. So, How do I know the exact systems' address to copy the database? Thank U all, Kiran.

Hi all, How do I connect to a MS-access data base which is present in localhost from an application runnig on web server. I want to send data from DB Server (sqlserver 2000) which is on remote machine to Ms-Access DB present in localhost. After googling I found the following Open connection to Access database located on a remote server:

"Provider=MS Remote; Remote Server=http://Your-Remote-Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb"

But, here my localhost IP varies depending on the client's system on which the web application is running. So, how do I set the clients' IP value or is there any other way to acheive this. Thank U all, Kiran

when I am trying to connect to remotely located sqlserver-2000 from asp.net (VS 2005) I am getting error msg "login failed to user XXXX". I am using the following connection string

   connectionString="Data Source=ip;Network Library=DBMSSOCN

;Initial Catalog=dbname;Persist Security Info=False;User ID=user;Password=Xyz"
providerName="System.Data.SqlClient">

Where am I going wrong ? our db server is located in 3rd party system. where we don't have any direct access to it to do any settings. what can I ask them to do? Thank U all, kiranmayi

Thank U Mr.JZ, I will try with this. with regards, kiran

Can I execute an exe in a windows application ? My exact requirement is, on the button click event I should run the exe in the same window where the button resides. Right now I am using process.start() to execute, but it is opening a new window. Thank U all, Kiran

yes, inside a browser I am calling it, it works on client side.

I am Thankfull for ur response. Here I am facing 2 Problems. 1. From my ASP.Net web application I am calling an exe using javascript. Here is my code.

var h;
h=new ActivexObject("wscript.shell");
h=run("c:\\sample.exe /v") ;
h=null;

So I am able to run it on client side. But as it is a third exe I am unable to set its location, size attributes. I pleed ur help in this regard. 2. In some other application I need to call a third party exe from my windows application. I am completely new to these C APIs and using dlls in applns, so suggest whate are the APIs to be used in what manner. Where from do I get this information. I feel sorry for confusing you, Thank U all, kiran

I am Thankfull for ur response. Here I am facing 2 Problems. 1. From my ASP.Net web application I am calling an exe using javascript. Here is my code.

var h;
h=new ActivexObject("wscript.shell");
h=run("c:\\sample.exe /v") ;
h=null;

So I am able to run it on client side. But as it is a third exe I am unable to set its location, size attributes. This was my question in ASP.Net message board. Here I pleed ur help. 2. In some other application I need to call a third party exe from my windows application. I am completely new to these C APIs, so suggest whate are the APIs to be used in what manner. Where from do I get this information. I feel sorry for confusing you, Thank U all, kiran

when I am calling a third party exe from a windows application how can I set its (GUI of that exe's) location (where it is to be opend) , size properties. or else can I run that exe in my application, without a new window is being opened. Thank U all, Kiran.