I got the solution. If developer is using dynamic control,then they should use control's Prerender event in order to send object of these controls to javascript. Suppose ur activating Popup on click of Image img, then img_PreRender event should be used. Image img = new Image(); img.ClientId ="imgABC" img.ImageUrl="abc.jpg"; img.PreRender += new EventHandler(img_PreRender); void o_PreRender(object sender, EventArgs e) { string str = imgABC.ClientId; //here u can access any control ClinetId. } Regards Balasaheb

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

I'll try and get back to u. Before that, I want to explain another situation. The javascript function which is working perfectly for physical page (not dynamic) function callcal(obj,objTxt) { //alert(obj.id + " " + objTxt); var curleft = curtop = 0; if (obj.offsetParent) { curleft = obj.offsetLeft curtop = obj.offsetTop while (obj = obj.offsetParent) { curleft += obj.offsetLeft curtop += obj.offsetTop } } //var objtxtid = document.getElementById(objTxt); //alert(objTxt + " " + objtxtid ); var x= document.getElementById(objTxt).value ; var y= document.forms[0].name; window.open("DatePicker.aspx?Form="+ y + "&Field="+objTxt+"&Value=" + x + "&hField=<%=hfTargetResponsedate.ClientID %>","","top="+ curtop +", left= "+ curleft +" width=280, height=190, status=0"); return false; } Here u find objTxt & x. Forget about IF part inside function, just concentrate on 'x=' part. The x returns null on function call. Now how this function gets called? string strImage = ""; strImage = strImage + " "; HtmlAnchor objAnc = new HtmlAnchor(); objAnc.ID = "lnkDate" + strCtrlID; //objAnc.Name = strCtrlID; objAnc.InnerHtml = strImage; objAnc.Style.Add("text-decoration", "none"); //txtTargetResponseDate objAnc.Attributes.Add("onclick", "javascript:return callcal(this,'" + txtloc.ClientID + "')"); clChield2.Controls.Add(objAnc); Look for callcal function above for objAnc and I send clientID of textbox which is dynamically created. Please let me know about ur view/solution Regards Balasaheb:) By click on image, it should open popup with proper page size

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Thanks for ur reply you r right, & I do same think in my application for all pages on which server controls are placed directly rather than created dynamically. But for dynamically created ctrl (For now, I'll say only ctrl for dynamic server controls), javascript function which I called unable to find out ctrl name like ctl100_Main_textbox1 Textbox textbox1 = new TextBox1(); textbox1.Attributes.Add("OnMouseOver","FunTest("+ textbox1.ClientID + ")"); Function FunTest(obj) { var a = document.getElementById(obj); return a; } above javascript function return null even control is present on page. Can u help me in this regard Balasaheb

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Hello All, Can someone help me in finding Id of dynamically created webserver control like textbox, dropdownlist etc, when these server control placed in aspx page, but the aspx page is included in Master page. Suppose dynamically created textbox textbox1 id changes to clt100_Main_textbox1 How to find out this id or its value using javascript Please help in this regard. Solution will be appreciated. Regards Balasaheb:)

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Thanks for ur reply Finally conclusion is Dataview can not filter string starting with 00*7, we have to do some other solution, is it correct? otherwise I have to query to database for filter criteria of such requirement. What I was doing earlier Retreiving data from database and keep it in cache[20 mins] For every postback on same page, dataset is fill with this cache data. Then this ds is converted into dataview in order to filter the record. Postback happen when 1) on button click Filter, 2) ShowAll button Click 3) Paging 4) Sorting Regards

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Thanks for quick & useful reply I have tried ur code doesn't give expected answer. Explaination:- RowFilter = "Name Like 'Sar[*]avanan'" Suppose Name contains like "Sareeavan", the above doesn't return "Sareeavan" as result, but returns blank I have a column named "ref" which contains records like 0007k, 0017,0127, I like find out records such as starting with 0*7 search criteria (This should min return 0007k, but wont). As per logic 0*7 should return all above values as result. RowFilter doesn't work on such criteria, do u have any solution on such criteria? Regads,

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

ok then how to solve above problem using dataview because user can send string like te*xt, is there any way? Please suggest some way to solve such problem Regards,

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

ello Everybody, Can someone help in finding solution for dataview filter I know how to use dataview filter and I had been using dataview for my application for biding 5 gridview. Every gridview is binded by dataview. And when I'm using filter by sending filter criteria using textbox, it is possible to send any kind of string to filter the dataview. Now problem is when I send string like 1) *text, it works fine 2) text*, it works fine 3) te*xt, it fails why this is so? Can someone please help me in this regard :) Solution on this will be appreciated :rolleyes: Regards Balasaheb Kahat Software Developer Platform: Asp.net,vb.net,C# Database: SQL Server 2000

Hello Everybody, Can someone help in finding solution for dataview filter I know how to use dataview filter and I had been using dataview for my application for biding 5 gridview. Every gridview is binded by dataview. And when I'm using filter by sending filter criteria using textbox, it is possible to send any kind of string to filter the dataview. Now problem is when I send string like 1) *text, it works fine 2) text*, it works fine 3) te*xt, it fails why this is so? Can someone please help me in this regard :) Solution on this will be appreciated :rolleyes: Regards Balasaheb Kahat

Balasaheb Software Developer Platform: Asp.net,vb.net

Hello All, Pls help me in this regard. I need a code to display a gridview with header, subheader and again subheader. Example:- Example should be a gridview --------------------------------------------------------------------------------------------- First Header1 |First Header2 | First Header3 --------------------------------------------------------------------------------------------- Subheader1 | Subheader2 | Subheader3 --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- Second Header1 |Second Header2 |Second Header3 --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- data | data | data --------------------------------------------------------------------------------------------- If somebody has some idea about such kind of complex code, then please revert back to me. :((

Balasaheb Software Developer Platform: Asp.net,vb.net

now my prob. has been solved using output parameter too. it can be possible to retreive value after reder.nextresult. ok thanks for ur help have nice day bye now

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Hello Guffa, I'm not reading the value from output parameter, that is the problem because when I write code like string str = arParams[2].value.ToString(); it return null and fires exceprtion. I'm not able to understand what exactly happing behind the screen. ok thanks for ur help

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

yes, no need to use output parameter. if u know how to take value from output parameter then pls let me know. that solution will also helpful to me Thanks for ur help

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

ok problem has been solved using ExecuteReader. I'm using below code to read next Resultset. Reader = SqlHelper.ExecuteReader(pass parameters) if !(Reader == null) { while(Reader.Read()) { string str = Reader["param1"].ToString(); } Reader.NextResult While(Reader.read()) { string str1 = Reader["Param2"].ToString(); } } Many many thanks for ur help too. Thanks Keep in touch My email id:- kbalu_2001@rediffmail.com

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

ok I'm giving u actual stored procedure, earlier stored procedure was given only for reference The original stored procedure (working perfectly without error) is SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE GET_PROJECT_DETAILS_SP ( @prref varchar(20), @userid uniqueidentifier, @STATUS int output ) As begin declare @prjid int select @prjid = (select PRID from EET_PROJECTS where PRREF = @prref) IF ((SELECT PRISPATT FROM EET_PROJECTS WHERE PRID = @prjid) = 0) BEGIN Select P.PRID as PRID, P.PRREF as PRREF, --P.PRNAME as PRNAME, EUP.PROJECTNAME as PRNAME, PRACTIVE = case P.PRACTIVE when 1 then 1 else 0 end, P.PRDESC as PRDESC, EUP.PURCHASERNAME as PRPURCHASERNAME, EUP.ENDUSERNAME as PRENDUSERNAME, EUP.DESTINATION, P.PROWNER as PROWNER, P.PROWNLOC as PROWNLOC, P.PRMKTLOC as PRMKTLOC, '' as PRPATT, EUP.INDUSTRY as PRINDUSTRY, P.PRPROPOSAL as PRPROPOSAL, P.PRSALES as PRSALES, P.PRQUOTCURRENCY as PRQUOTCURRENCY, P.CREATED_DATE as PRDATE, CREATED_BY = (SELECT cast(FIRST_NAME + ' ' + LAST_NAME as varchar(161)) FROM EET_SEC_USERS WHERE USERID = P.CREATED_BY), P.LAST_UPDATED_DATE as PRUP, LAST_UPDATED_BY = (SELECT cast(FIRST_NAME + ' ' + LAST_NAME as varchar(161)) FROM EET_SEC_USERS WHERE USERID = P.LAST_UPDATED_BY), ((SELECT LOCCOUNTRY FROM EET_LOCATIONS WHERE LOCID = P.PRMKTLOC) + ' (' + P.PRMKTLOC + ')') as PRMKTLOCWITHCOUNTRY, EUP.GP3_FLAG, EUP.PROJECTORIGINATOR_NAME, EUP.PROJECTLEAD_NAME, EUP.SYS_FUNNEL_POSITION, EUP.SYS_KOB, EUP.SYS_PROBABILITY, EUP.SIS_CONTENT, EUP.SERV_FUNNEL_POSITION, EUP.SERV_KOB, EUP.SERV_PROBABILITY, P.PRISPATT, P.PRNOPATTREASON, NULL as PRPURCHASERID, case when P.PRUSECUSTPRICE = 1 then 'Yes' else 'No' end as USECUSTPRICE, P.PRCUSTPRICEID, (SELECT CUPRCUSTOMER FROM EET_CUSTOMER_PRICING WHERE CUPRID = P.PRCUSTPRICEID) as CUSTPRICENAME, dbo.FUNC_GET_LOCATION_LIST(P.PRCUSTPRICEID) as CUSTPRICELOCN, isnull(EUP.BOOK_DATE, getutcdate()) as PRBOOKDATE, EUP.transitional_order as PRTRANSPRJSTATUS from EET_PROJECTS P join EET_USER_PATT_DATA EUP on P.PRID = EUP.EUPDPROJECT where PRID = @prjid END if (exists(select opuserid, opprjid from EET_MY_PROJECTS_LISTS where opuserid = @userid and opprjid = @prjid)) begin SET @STATUS = 1 end else SET @STATUS = 0 select @STATUS as status end GO SET QUOTED_IDENTIFIER OFF GO SET A

Thanks for ur reply In case of ExecuteReader:- My stored procedure contains two result set The actual format of stored procedure is ***************************Stored Procedure start************************************* declare @colid1 int declare @col2 uniqueidentifire declare @Status out set @col1 = "001" set @col2 = "{123456789}" declare @id int select @id = (select id from tableid where colid = @colid1) Select col1,col2,col3,col4 from tabel where col1 = @colid1 and col2= @col2 if (exists(select col1,col2 from table2 where col1 = @col1 and col2 = @colid)) { @Status = 1 } else { @Status =0 } select @Status as status *****************************Stored Procedure End**************************************** The above stored procedure is given for reference. Now my problem is I'm able to retreive column values using ExecuteReader by passing stored procedure properly ReaderObj = SqlHelper.ExecuteReader(Pass parameters) ReaderObj retreives only table1 columns values.......now how to read @Status value(look at above stored procedure) ***************************************************** arParams[0] = new SqlParameter("@prref",SqlDbType.VarChar,20); arParams[0].Value = strPrjRef; arParams[1] = new SqlParameter("@userid",SqlDbType.UniqueIdentifier); arParams[1].Value = new Guid("{7126886d-2538-429c-ab3c-22b3341dcecf}"); arParams[2] = new SqlParameter("@STATUS", SqlDbType.Int); arParams[2].Direction = ParameterDirection.Output; RdPrjDetails = SqlHelper.ExecuteReaderconnstr,CommandType.StoredProcedure, "GET_PROJECT_DETAILS_SP", arParams); ******************************************************* Pls help me in this regard:((

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Thanks for ur reply In case of ExecuteReader:- My stored procedure contains two result set The actual format of stored procedure is ***************************Stored Procedure start************************************* declare @colid1 int declare @col2 uniqueidentifire declare @Status out set @col1 = "001" set @col2 = "{123456789}" declare @id int select @id = (select id from tableid where colid = @colid1) Select col1,col2,col3,col4 from tabel where col1 = @colid1 and col2= @col2 if (exists(select col1,col2 from table2 where col1 = @col1 and col2 = @colid)) { @Status = 1 } else { @Status =0 } select @Status as status *****************************Stored Procedure End**************************************** The above stored procedure is given for reference. Now my problem is I'm able to retreive column values using ExecuteReader by passing stored procedure properly ReaderObj = SqlHelper.ExecuteReader(Pass parameters) ReaderObj retreives only table1 columns values.......now how to read @Status value(look at above stored procedure):(( ***************************************************** arParams[0] = new SqlParameter("@prref",SqlDbType.VarChar,20); arParams[0].Value = strPrjRef; arParams[1] = new SqlParameter("@userid",SqlDbType.UniqueIdentifier); arParams[1].Value = new Guid("{7126886d-2538-429c-ab3c-22b3341dcecf}"); arParams[2] = new SqlParameter("@STATUS", SqlDbType.Int); arParams[2].Direction = ParameterDirection.Output; RdPrjDetails = SqlHelper.ExecuteReaderconnstr,CommandType.StoredProcedure, "GET_PROJECT_DETAILS_SP", arParams); ******************************************************* Pls help me in this regard

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Hello Friends Can someone help me. I know how to read value using SqlHelper.ExecuteReader using storedProcedure. But if stored Procedure has a output parameter, I'm not able to read output parameter value. How to read output parameter value. I could read output parameter value using SqlHelper.ExecuteNonQuery, but then I'm not able to read database query column values. how to read database query column values. pls help soon Regards Balasaheb :((

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Hello All, Help me for one code. I'm using web form pages in conjuction with master pages. I'm facing some problem. Let me know first, whenever I'm using webform & looks results in IE browser it shows form id as 'aspnetForm'. can I change it. Regards Balasaheb -- modified at 23:50 Wednesday 22nd November, 2006 -- modified at 23:51 Wednesday 22nd November, 2006

Balasaheb Software Developer Platform: Asp.net,vb.net Database: SQL Server 2000

Hello All Can u pls help regarding viewstate.......... I'm using user contol for some code. Also using viewstate on form1.aspx(e.g.). User control is placed on this form. I need to access form viewstate value on usercotrol. is it possible? is viewstate written on FORM available on User Control? :)Pls help me in this regard.

Balasaheb Software Developer