Thanks.. It won't do automatically only sync occasionally / manually. I am looking for whenver DML operation happens.

Thanks & Regards Rao

I have table(Tbl_A) in Server1 whenever DML(Insert/Update/Delete) operation happens in Tbl_A it has to be automatically insert/Update/Delete into Table B,C(Tbl_B,Tbl_C) in different sever2. 'Whenever Table B,C Update/Delete/Insert record automatically record in Table A(Tbl_A). I tried trigger but it does not help work for me. Please advice me how to deal this scenario. Thanks Rao

Thanks & Regards Rao

Dave, Here are the details.. It is online Test Management System which includes Oral proficiency,Writing and Listening Tests(Like Prove it /Brain bench)with multi-lingual Spanish,English,Chinese,Japaneses,Germany etc. The application interaction as follows. Candidate Tester Rater Proctor SalesRep Appointment Availability IVR System interaction I really appreciate if you could help me

Thanks & Regards Rao

Hi All, I am designing brand new application using the following technologies. C# ASP.Net AJAX SQL SERVER 2005 Visual Studio 2008. Approach's 3-Tier architecture UI+BL+DL classical way. UI+BL+DL with Application blocks. N-Tier architecture< UI+BL+Linq to SQL UI+BL+WCF+database Can you please help me which approach will give best performance.

Thanks & Regards Rao

Hi All, I am designing brand new application using the following technologies. C# ASP.Net AJAX SQL SERVER 2005 Visual Studio 2008. Approach's 3-Tier architecture UI+BL+DL classical way. UI+BL+DL with Application blocks. N-Tier architecture UI+BL+Linq to SQL UI+BL+WCF+database Can you please help me which approach will give best performance.

Thanks & Regards Rao

Hi All, Here are the code... // List< String >category=new List < String >(); category.Add("House"); category.Add("Car"); category.Add("Dog"); category.Add("Car"); I want to show report like this... Name Count ===== ===== Car 2 Dog 1 House 1 Please let me know how to do the above output.

Thanks & Regards Rao

[Message Deleted]

Thanks..

Thanks & Regards Rao

Thanks...

Thanks & Regards Rao

Hi All, I want to sort collections.. // Class public class Item { public String Name{get;set;} public int Cost{get;set;} public Item(string name,int cost) { Name=name; Cost=cost; } } // Collection of Data List items=new List(); items.Add(New Item("House",100)); items.Add(New Item("Car",80)); items.Add(New Item("Dog",10)); items.Add(New Item("Car",50)); items.Add(New Item("Cycle",25)); items.Add(New Item("Car",120)); Note: Provide code to sort a collection of Item. The code should sort the Item collection only one time, following this rule: The Items should be ordered by their names (following the standard C# API for string ordering), but if two Items have the same name, then those Items should be ordered by their cost, with the lower cost item to appear before the higher cost item. I appreciate somebody provide solution for the same.

Thanks & Regards Rao

Thank you so much...

Thanks & Regards Rao

Hi All, When user navigate pages if the session expires I want to show alert message and redirect login page. I written code for above reqruirement it is loging out but does not show message. My code as follows default.aspx.cs protected void Page_Load(object sender, EventArgs e) { Common comm = new Common(); if (Session[USER_CONTEXT] != null) { // do something... } else { // I want show javascript alert message to the user then click OK , redirect to logOutURL comm.LogoffTohome(); return; } } Common.cs public void LogoffTohome() { string Jscript = "javascript:alert('Your session is over')"; ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "SessionTimeout", Jscript, true); Session.Abandon(); HttpContext.Current.Response.Redirect(System.Configuration.ConfigurationManager.AppSettings["LogoutUrl"].ToString()); } I really appreciate if your help... Thanks Rao

Thanks & Regards Rao

Hi All, I have a muti-select listbox on my web form. When you scroll down to select items and SelectIndexChanged event fires, the postback brings the listbox back to the top of the screen. The item is still selected, but you have to scroll down to see it. How do I get the listbox to show one of the currently selected items. Below is the my code.. aspx page ]]> AutoPostBack="true" Width="150px" OnSelectedIndexChanged="cmdCustomList_SelectedInde xChanged"> client script fuction CustomSelect() { Var SMIndex = document.getElementById('ctl00_ContentPlaceHolder1 _cmdCustomList'); for(var index = 0; index < SMIndex.options.length; index++) { if (SMIndex.options[index].selected) { SMIndex.options[index].selected = true; } } } Code behind protected void cmdCustomList_SelectedIndexChanged(object sender, EventArgs e) int cntSelected = 0; string scriptBlock = "CustomSelect();"; try { if (cmdCustomList.SelectedIndex > -1) { for (int indx = 0; indx<cmdcustomlist.items.count;>{ if (cmdCustomList.Items[indx].Selected == true) { values = values + "," + cmdCustomList.Items[indx].Value; cntSelected++; } } Session["lstCompHosp"] = values; if (chkComparisonExcludeOnly.Checked == false) { if (cntSelected == cmdCustomList.Items.Count) scriptBlock = "cmdAllAvailHosp();" // Another Client side function } updpanelComparisonHospital.Update(); ScriptManager.RegisterStartupScript(this, typeof(DefaultView), "cmdCustom", scriptBlock, true); } } catch (Exception ex) { throw new Exception(ex.Message, ex); } } Would you please give some directions. Thanks Rao

Thanks & Regards Rao

Hi All, I have Gridview and inside checkbox/Dropdownlist controls.I want capture checked/selecteditem rows values. I am trying to get select checkbox rows values.but IsChecked variable not set True.Here is the example code. // Checkbox control... Dim i As Integer For i = 0 To gridview1.Rows.Count - 1 Dim gvr As GridViewRow = gridview1.Rows(i) Dim isChecked As Boolean isChecked = CType(gvr.FindControl("checkbox1"),CheckBox).Checked If isChecked Then textbox1.Text = gridview1.Rows(i).Cells(1).Text End If Next // DropdownList Dim gvr As GridViewRow Dim str As String For Each gvr In gridview1.Rows str = (CType(gvr.FindControl("ddlType"), DropDownList)).SelectedItem.Text textbox2.Text = str Next Please let me know why is not working the above code and how to do that.

Thanks & Regards Rao

Hi, I have to invoke the parameterized webservice. for example "http://dsrepct:8080/sanjose/services/Contract?method=getCustomerInfoList& in2=CHARLOTTE&in1=3&in0=5 how could i do that and i have to bound the values to dropdownlist which are custname as text and cust no as value. Please anybody let me know the process.

Thanks & Regards Rao

Hi All, Can anybody help me.How to call external application(FileMaker) using HTTPRequest in asp.net.Here is the example i have creatXMLpage.aspx it contains textbox and button controls.I will enter some value into the textbox and hit the button i want call external app(FileMaker) and expected the output is XML.How can i do this.Please let me know which concept i have to implement. Thanks & Regards Rao

Thank you ... Thanks & Regards Rao

Thank you ... But doesn't work... Thanks & Regards Rao

Hi All, I am unable to close Microsoft Excel object from Task Manager.what i am doing as follows ************ Sample Code********************* Excel._Application _excel = new Excel.ApplicationClass(); Excel.Workbook wsWorkbook = _excel.Workbooks.Open(@"C:\test.xls",0, false, 1, "", "", false, Excel.XlPlatform.xlWindows, "",true, false, 0, true, false, false); Excel._Worksheet sheet = (Excel._Worksheet)wsWorkbook.ActiveSheet; sheet.Activate(); ((Excel.Range)sheet.Cells [1,2]).EntireColumn.NumberFormat =0; ((Excel.Range)sheet.Cells [1,2]).EntireColumn.AutoFit(); ((Excel.Range)sheet.Cells [1,3]).EntireColumn.NumberFormat ="$#,##0.00"; ((Excel.Range)sheet.Cells [1,3]).EntireColumn.AutoFit(); wsWorkbook.Close(true,missing.Value,missing.Value ); // _excel.Visible = true; _excel.Quit(); MessageBox.Show("Done"); **************code end here*******************8 I am opening existing .xls file using C# and formatting some columns. It doesn't release object from Task manager memory. I used Excel.quit() and excel.close(); Please let me know why is object not realsed. Thanks & Regards Rao

Hi All, Can anybody help me how to convert Copybook data into Excel SpreadSheet using C# .I am new to Copy book.The copybook structure as follows. *****Copybook1***** 05 IC-Record-ID PIC X(02) value'IC' 05 IC-TPA-ID PIC x(06) 05 IC-Employer-ID PIC X(09) 05 IC-Plan-ID PIC x(09) 05 IC-Employee-ID PIC X(30) 05 IC-Account-Type-Code PIC X(04) 05 IC-Plan-Start-Date PIC x(08) 05 IC-Plan-End-Date PIC x(08) 05 IC-Account-Status PIC 9(01) 88 IC-Acct-New value 1. 88.IC-Acct-Active value 2. 88,IC-Acct-Temp-Inactive value 3. 88.IC-Acct-Perm-InActive value 4. 05 IC-Auto-Deposit-Last-Alloc-Dt Pic x(08) 05 IC-Flex-Account-Options Pic x(02) 88 IC-Recurr-Expense value '01' 88 IC-Copay-Rollover value '02' 05 IC-Request_Legnth Pic s9(04)COMP. 05 IC-Subscriber-Person-ID-R REDEFINES IC-Subscriber-Person-ID Pic x(15) 10 IC-Plan-ID pic x(10) 10 IC-Post-BenOPTS-Array OCCURS 20 Times. 15 IC-Post-BenOpt PIC x(05). 10 IC-Plan-Status Pic x(01) 88 IC-Plan-New value '1' 88 IC-Plan-Active value '2' *****Copybook2***** 05 RB-RB-Record-D PIC X(02) Value'RB'. 05 RB-Employer-ID PIC X(09) 05 RB-Employee-ID PIC X(30) 05 RB-Details-Response-Code PIC X(09). ****Copybook3***** Employee-Account-Record 05 RC-Employee-ID PIC X(02) value'RC' 05 RC-Employer-ID PIC X(09) 05 RC-Employee-ID PIC X(30) 05 RC-Account-Type-Code PIC X(04) 05 RC-Plan-Start-Date PIC X(08) 05 RC-Plan-End-Date PIC X(08) 05 RC-Detail-Response-Code PIC(06) Once defined above structure . I have to give input file as sequential data file and expected output as spreadsheet Thanks & Regards Rao