wht SPAM

[Message Deleted]

insert your code in update panel and add following code <asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="upPnl" DisplayAfter="50"> <ProgressTemplate> <img id="Img1" src="~/images/ajax.progress1.gif" runat="server" alt=""/> Please Wait... </ProgressTemplate> </asp:UpdateProgress>

got the solution...............:) SqlHelper.ExecuteNonQuery ( myConnectionString , "usp_InsertTrackingData" , iWeekNo , Convert.ToInt32(dtRow["InvCoID"]) , ((dtRow["LatestReportDateConsensus"] != DBNull.Value) ? dtRow["LatestReportDateConsensus"] : null) , ((dtRow["LatestReportDateVirtua"] != DBNull.Value) ? dtRow["LatestReportDateVirtua"] : null) ,dtFromDate ,dtToDate ,CreatedBy );

search lottttttt but no success.. :(

my code is in C#..:( :(

didnt get that IIF whts tht??

i have datatable in which 2 row,1st column value is null that column is datatype is DateTime. wwhen i tried to add data to database..its gives me error as Object cannot be cast from DBNull to other types. i have done following.. foreach (DataRow dtRow in dtTrackingData.Rows) { SqlHelper.ExecuteNonQuery ( myConnectionString , "SP_NAME" , iWeekNo , Convert.ToInt32(dtRow["InvCoID"]) , Convert.ToDateTime(dtRow["LatestReportDateConsensus"]) , Convert.ToDateTime(dtRow["LatestReportDateVirtua"]) ,dtFromDate ,dtToDate ,CreatedBy ); } i tried to add if (dtRow["LatestReportDateConsensus"] == System.DBNull.Value) dtRow["LatestReportDateConsensus"] =null; still its not work..:( how i will add value to datarow if its null

modified on Wednesday, June 3, 2009 1:22 AM

hello i have grid which is in div tag. (i want to set div with with javascript only) i want javascript function in which i want to set div width but after grid binding completion how can i call javascript fun after grid ginging complition

Take one image..on clcik of tht right following code its save gridview data as .xls not in zip file protected void imgBtnExport_Click(object sender, ImageClickEventArgs e) { System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite); try { DateTime dtFromDate, dtToDate; dtFromDate = Convert.ToDateTime(txtFromDate.Text); dtToDate = Convert.ToDateTime(txtToDate.Text); Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=ExcelName.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache); Response.ContentType = "application/vnd.xls"; this.EnableViewState = false; GridView grdExp = new GridView(); grdExp.AllowPaging = false; grdExp.AllowSorting = false; DataSet dsRawProd = objReportBL.GetRawProductivityData(dtFromDate.ToShortDateString(), dtToDate.ToShortDateString(), 0, 0); if (dsRawProd.Tables.Count > 0 && dsRawProd.Tables[0].Rows.Count > 0) { DataTable dtRowPrd = dsRawProd.Tables[0]; DataView dv = new DataView(dtRowPrd); grdExp.DataSource = dv; grdExp.DataBind(); //grdExp.Columns. grdExp.RenderControl(htmlWrite); } } catch (Exception) { } Response.Write(stringWrite.ToString()); Response.End(); }

Hey thnx a lot...its working fine..:)

string SmtpServerIP = "UR SMPTP IP"; if (SmtpServerIP != "") { SmtpClient smtpClient = new SmtpClient(SmtpServerIP); smtpClient.Send(Email); }

Hello guys, i have hyperlink in my page. i want to pass hyperlink id as parameter to that link...how to do that?? iahve done following,...but its not working..:( <asp:HyperLink ID="HyperLink6" runat="server" Text="File Status" CssClass="CSMenu" NavigateUrl='<%# "Default.aspx?HyperlinkID=" + HyperLink6 %>'

set Pagesize="10" and add below code in .aspx page <PagerSettings Mode="NumericFirstLast" NextPageText="" Position="TopAndBottom" PreviousPageText=""> </PagerSettings> may be it will work..:)

i have writ code in (!IsPostBack) still its not working..:(

There is dropdownlist on my page which showes country name. on click of country name popup will get display which showes companyname of selected country , and same dropdown will again get display. In Popup dropdownlist ,it will display selectedItem value (CountryName)as which we have selected from main page. for tht i have return code as follwes drdCountry.DataTextField = "CountryName"; drdCountry.DataValueField = "CompanyCount"; drdCountry.DataSource = dsCoverageList.Tables[0].DefaultView; drdCountry.DataBind(); drdCountry.SelectedItem.Text = Request.QueryString["CountryName"].ToString(); drdCountry.SelectedItem.Value = Request.QueryString["CompCount"].ToString(); but prob is on popup page in dropdownlist is showes duplicate value of selected item means suppose i have selected US (CountryName) from main drplist thn in popup page is showes US 2 times in DrpList. why is it so??.. :( please help me out..