I am using DB2 and C# to develop a web app.I got a problem in adding a new row.My table has Time field in DB2 which is in hh.mm.ss format.In Dot net the equivalent format is hh:mm:ss.My problem is how can I convert the hh:mm:ss(in .NET) to hh.mm.ss in DB2? I need urgent help kidus

hi How can I solve this problem in DB2.I am using C#. ERROR [22007] [IBM][DB2] SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007 Any help

hi I got a problem in inserting new rows to a datatable.How can I insert dates in a data table using DB2. Here is some code... DB2Connection conn = new DB2Connection(connectionString); DB2DataAdapter DataAd= new DB2DataAdapter(select, conn); DataSet ds=new DataSet(); DataAd.Fill(ds, "Table Name"); Datarow dr = ds.Tables["Table Name"].NewRow(); DB2Command aCommand = new DB2Command(select, conn); aCommand.CommandType = CommandType.Text; aCommand = new DB2Command("INSERT INTO CL.VSCHTM("ST_DTE")" "VALUES ("#" + dr["ST_DTE"]+"#",conn); DataAd.InsertCommand = aCommand; DataAd.Update(ds, "Table Name"); aCommand.Parameters.Add(new DB2Parameter("ST_DTE",DB2Type.Date, 0, "ST_DTE")); aCommand.UpdatedRowSource = UpdateRowSource.OutputParameters; It doesn't add new row ,any help?? kidus

hi Thank you for your fast response in the code String strScript = "window.opener.document.forms['aspnetForm']." + control.Value + ".value = '"; the form name 'aspnetForm'.There is only one form in the master page.No other forms in the other pages.My text box is in the other pages. Any help kidus</x-turndown>

And I put the controls inside the Asp:Content not Master page.

I add to the name of the controls $ but there is no difference.Make it clear pls help kidus

am using visual studio 2005 and I am trying to create a popup calender so when a user click on a image on the main form, a calender will then popup, the user will select a date and the date will then be passed back to the main form and populate a textbox. it works fine. but when i used master page for all my pages and i put the textbox inside the content , the calender pops up but when i select the date nothing happens .. the textbox was not populated with the selected date from the calender and the window was not closed. Here is my code Default Page/Parent Window/ function GetDate(CtrlName) { ChildWindow = window.open('Calendar.aspx?FormName=' + document.forms[0].name + '&CtrlName=' + CtrlName, "PopUpCalendar", "width=270,height=300,top=200,left=200,toolbars=no,scrollbars=no,status=no,resizable=no"); } [Start Date](javascript:GetDate('txtStartDate'))
Code for the Calendar Page/Child Page/ function ReturnDate() { window.opener.document.forms["<%= strFormName %>"].elements["<%=strCtrlName %>"].value = "<%= strSelectedDate %>"; window.close(); } function Close() { window.close(); } Public strFormName As String Public strCtrlName As String Public strSelectedDate As String Sub Page_Load(Sender As Object, E As EventArgs) If Not IsPostBack Then myCalendar.SelectedDate = System.DateTime.Now() End If strSelectedDate = myCalendar.SelectedDate.ToString("dd/MM/yyyy") strFormName = Request.QueryString("FormName") strCtrlName = Request.QueryString("CtrlName") End Sub Sub myCalendar_SelectionChanged(sender As Object, e As EventArgs) strSelectedDate = myCalendar.SelectedDate.ToString("dd/MM/yyyy") End Sub

I want it to be shown in the parent form as a child window.

Anyone who can help me in creating Pop up Calendar in ASP.NET 2.0? Thank you in advance kidus

hi pls ..... some small example thanks kidus

hi here is the code for creating the clickable Row using Javascript if (e.Row.DataItemIndex == -1) return; e.Row.Attributes.Add("onMouseOver", "this.style.cursor='hand';"); e.Row.Attributes["onmouseover"] = "javascript:setMouseOverColor(this);"; e.Row.Attributes["onmouseout"] = "javascript:setMouseOutColor(this);"; e.Row.Attributes.Add("onclick", this.GetPostBackClientEvent(GrdDynamic, "Select$" + e.Row.RowIndex.ToString())); and what I want to do is to hyperlink to other page when the row in the clickable gridview is clicked and passed the contents of the clicked row to the other page(using session). thanks kidus

hi I mean at ruutime and on the server side.I wrote using mouseover on the client side but it doesn't hyperlink? Can y show me on both?server side and client side scripting? thanks kidus

Hi How can I select and hyperlink the contents of a row in a gridview server control dynamically.I want the contents of the selected row to be transferred to the next page(using the hyerlink). ANy onwe who can help me? thanks kidus

hi szukuro Thank you for yr information but the problem is the RaisePostBackEvent() can't be fired? Any info? kidus

hi szukuro But I am using gridview server control and C#.Pls mak it clear thanks

Can any one help me in develing a row-clickable DataGrid control? thanks kidus