Yes there is no CONCAT fucntion in Sql Server .it's in ORACLE For Sql Server you can do the same thing with + sign e.g Select First_Col + Second_col from table

trish http://AllJobSearch.blogspot.com

Hay Apurva I have just modified my signature but not repost the same answer. And I'm not able to see duplicate answer here!!

trish http://AllJobSearch.blogspot.com

try to use Page.SmartNavigation = true; in page load event. and then use textbox1.setfocus(); in your function.

trish http://AllJobSearch.blogspot.com

try to use following lie of code in page load- Page.SmartNavigation = true;

trish http://AllJobSearch.blogspot.com

Have you called this function/event from anywhere else?which may trigger at the same time when combo SelectedIndexChanged event fired.

trish http://AllJobSearch.blogspot.com

Here some fields have same values like First,front & rear have value 1. Hence if you select any text which has same value it points to first text which has value 1. solution : if possible change you sql quesry as select TEXT,concat(VALUE,TEXT)as VALUE from tbl_test where criteria=hello" now you will get the required text selected. If you need a value of selected,you need to pick only VALUE part from (VALUE,TEXT) combination

trish http://AllJobSearch.blogspot.com

modified on Monday, April 28, 2008 7:13 AM

you can search for HttpModules

trish

Hi Hari, Try to delete that file in "Finally" block of Try-Catch. Trish

Hi, I have two console applications..I want to send values from one apps to another and vise versa...also want that if one apps sends the value to another apps then it will trigger some event to know that value has arrived.. trish

Hi, I think you are using Crystal report for generating report.. Unfortunately I don't have crystal report installed on my PC.. But I search similar problem for you on net..try this link you may got the solution http://forums.asp.net/thread/1003903.aspx Trish

Hi It will definately return Client's IP address.. But maybe it will return wrong IP where this site will hosted.. Just try access to access your page from some others browser..it will return correct static IP address of the machine!!! try this ,if still confused then let me know.. trish

Hi try this

Hi, try this Response.Write(Request.UserHostAddress()) but this will applicable for clients browsers...you may get IP on your machine as 127.0.0.1 which is default IP in IIS.. trish

Hi, Try this, Call procedure CheckBoxListValues() on CheckBoxList's OnDataBinding event to show check/uncheck checkbox Your aspx code.... :-D Add Modify Delete View Print /aspatagrid> and code behind code is .... Public Sub CheckBoxListValues(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Checkboxlist2.DataBinding Dim i As Integer Dim str As String = "AXXVP" 'Pass value from Database For i = 0 To Checkboxlist2.Items.Count - 1 Select Case i Case 0 ' Add If str.Substring(i, 1) = "A" Then Checkboxlist2.Items(i).Selected = True Else Checkboxlist2.Items(i).Selected = False End If Case 1 'Modify If str.Substring(i, 1) = "M" Then Checkboxlist2.Items(i).Selected = True Else Checkboxlist2.Items(i).Selected = False End If Case 2 ' Delete If str.Substring(i, 1) = "D" Then Checkboxlist2.Items(i).Selected = True Else Checkboxlist2.Items(i).Selected = False End If Case 3 'View If str.Substring(i, 1) = "V" Then Checkboxlist2.Items(i).Selected = True Else Checkboxlist2.Items(i).Selected = False End If Case 4 ' Print If str.Substring(i, 1) = "P" Then Checkboxlist2.Items(i).Selected = True Else Checkboxlist2.Items(i).Selected = False End If End Select