Thanks alot! I am new to MY SQL database and my problem is solved. Inderjeet Kaur Sr. Software Engg

Hi string conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; MySqlConnection con = new MySqlConnection(conn); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = "Insert_Image"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("?description", SqlDbType.VarChar).Value = txtdesc.Text; cmd.Parameters.AddWithValue("?fullstr", SqlDbType.VarChar).Value = path; con.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); Session.RemoveAll(); My code is giving error at executenonquery, "Input string not in correct format". The values in path and txt dec are correct. Can you please tell where i am wrong? Regards Inderjeet Kaur Inderjeet Kaur Sr. Software Engg

Hi I am making a website in ASP.NET on which i want to show food menu. It can be any no pages. I want to save it in database and show it on web page with page turn. What is the best way to do it. I know how to upload single file to database and show it on web page. Thanks in advance Inderjeet Kaur Inderjeet Kaur Sr. Software Engg

these plugins do not read files from folder....not dynamic.... Inderjeet Kaur Sr. Software Engg

Hi i want a photo gallery for ASP.net in which i could zoom the thumbnails with next and previous option.I used NotesforGallary, but after doing everything its just showing thumbnails not the slide show......If anybody could help....Thanks in Advance! Inderjeet Kaur Sr. Software Engg

You can schedule a job and can set the time

when to send an email.
Firstly, you need to configure your database for sending mails. Connect to your database---> Go to Management ----> Right Click database mail and configure database mail.

Inderjeet Kaur Sr. Software Engg

Hi I want to write a regular expression to validate my experience field. This field excepts numeric(year) value and decimal(month) value. For Ex: 4.3(4 yrs and 3 mnths) I want to validate my texbox value using regual expression so that year is not more than 12 and month is not more tha 11. I need help as early as possible. Thanks in advance Nikks

Inderjeet Kaur Sr. Software Engg

Hi I am using two HTML radio buttons <td align="left" style="height:40px;vertical-align:middle " > <input type="radio" id="rdoLeaveExcHoliday" value="1" name="rdoLeaveOption" onclick=" SelectLeaveType(this,'1');" />Leaves-excluding holidays and weekends <input type="radio" id="rdoLeaveIncHoliday" value="2" name="rdoLeaveOption" onclick=" SelectLeaveType(this,'2');" />Leaves-including holidays and weekends </td> I want to make second radio button invisible if my dataset in code behing returns zero. I canot make them runat="server" How to get it? Any help will be appreciated.. Thanks in advance

Inderjeet Kaur Sr. Software Engg

Hi I was trying to use Application_Start method of Global.asax file to catch Exceptions. Can we add Global.asax to Window application. I am not able to add it. Can anyone help me on this. Thanks & Regards Inderjeet Kaur

Inderjeet Kaur Sr. Software Engg

Hi You can use BatchUpdate for this try { Craete SQL COmmand Object cmd.CommandType = CommandType.StoredProcedure; cmd.UpdatedRowSource = UpdateRowSource.None; cmd.Parameters.Add("@Param1", SqlDbType.Int, 4, argDt.Columns[0].ColumnName); cmd.Parameters.Add("@Pram2", SqlDbType.Bit, 5, argDt.Columns[1].ColumnName); cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = cmd; da.UpdateBatchSize = 100; conn.Open(); int recordsInserted = da.Update(argDt); conn.Close(); }

Inderjeet Kaur Sr. Software Engg

Handle it in database. While retrieving value use ISNULL(CULUMNNAME, 0.00) AS NewColumn Or if you want to handle it at code behind use as told in above replies

Inderjeet Kaur Sr. Software Engg

You can use RowCommandEvent like this. e.Command name give thename of your button you gave in aspx. Now do whatever you want to do. You can also use RowdataBound event. protected void gvCardFeesRReport_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case "First": gvCardFeesRReport.PageIndex = 0; break; case "Prev": if (gvCardFeesRReport.PageIndex > 0) gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex - 1; break; case "Next": if (gvCardFeesRReport.PageIndex < gvCardFeesRReport.PageCount - 1) gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageIndex + 1; break; case "Last": gvCardFeesRReport.PageIndex = gvCardFeesRReport.PageCount - 1; break; } } catch (System.Threading.ThreadAbortException) { }

Inderjeet Kaur Sr. Software Engg

I have used something for GoogleChrome problem. Use can use something like this for IE prob if(Request.UserAgent.Contains("AppleWebKit")) Request.Browser.Adapters.Clear();

Inderjeet Kaur Sr. Software Engg

</asp:GridView> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="gvCardFeesRReport" /> </Triggers> </asp:UpdatePanel> Try using this code before closing the UpdatePanel. Change gridview ID in COntrolID to ur Gridview ID. Hope this helps you.

Inderjeet Kaur Sr. Software Engg

Hi I got teh solution for the problem. I am usin Update Panel which gives inconsistent behaviour while postback. SO before closing Update Panel for gridView we need to give this PostBack Trigger </asp:GridView> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID ="gvInstitutionReport" /> </Triggers> </asp:UpdatePanel>

Inderjeet Kaur Sr. Software Engg

Hi I am having a GridView paging done using Object data source. I want to calculate the sum of records of a column. First I need to find out values if ID = 1 sum all IDS with 1, if ID=2 sum all IDS with 2 and Display. I am able to do it but when i move to next page my label looses its value while rendering.

Inderjeet Kaur Sr. Software Engg

No it didn't work. i give u the code of my gridview also <asp:UpdatePanel ID="pnlBG" runat="server"> <ContentTemplate> <asp:ObjectDataSource ID="objCardFeesReport" runat="server" TypeName="BLL.ReportBLL" SortParameterName="sortExpression" EnablePaging="true" SelectCountMethod="GetReportsRecCount" SelectMethod="GetCardFeesReport" OnSelected="objCardFeesReport_Selected"> <SelectParameters> <asp:Parameter Name="sortExpression" Type="String" /> <asp:Parameter Name="filteredBy" Type="String" /> <asp:Parameter Name="startRowIndex" DefaultValue="0" Type="Int32" /> <asp:Parameter Name="maximumRows" Type="Int32" /> </SelectParameters> </asp:ObjectDataSource> <asp:GridView ID="gvCardFeesRReport" runat="server" PageSize="10" AllowSorting="true" AllowPaging="true" AutoGenerateColumns="false" CellPadding="5" CellSpacing="0" Width="100%" DataSourceID="objCardFeesReport" CssClass="GridMain" OnPageIndexChanging="gvCardFeesRReport_PageIndexChanging" OnSorting="gvCardFeesRReport_Sorting" OnRowCommand="gvCardFeesRReport_RowCommand" > <HeaderStyle CssClass="HeaderRow" /> <RowStyle CssClass="NormalRow" /> <AlternatingRowStyle CssClass="AlternateRow" /> <PagerStyle CssClass="PagingRow" HorizontalAlign="Right" Height="20px" /> <SelectedRowStyle CssClass="HighlightedRow" /> <EmptyDataRowStyle CssClass="NoRecords" /> <EmptyDataTemplate> <asp:Label ID="lblNoRecords" Text="Your search did not yield any result." runat="server"> </asp:Label> <p> Suggestions:</p> <li>Try different Filter.</li> <li>There may be no records in the system.</li> </EmptyDataTemplate> <Columns> <asp:BoundField HeaderStyle-CssClass="gridViewHeader" DataField="AccountNumber" SortExpressio

protected void objCardFeesReport_Selected(object sender, ObjectDataSourceStatusEventArgs e) { try { if (e.Exception != null) { e.ExceptionHandled = true; } Int32 totalSearchRows = 0; if (e.ReturnValue.GetType() == typeof(System.Int32)) totalSearchRows = (Int32)e.ReturnValue; lblSummary.Text = "Total Records Found :" + " " + Convert.ToString(totalSearchRows); if (e.ReturnValue.GetType() == typeof(System.Data.DataSet)) { DataSet ds = (DataSet)e.ReturnValue; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { String feeID = ds.Tables[0].Rows[i]["TRANTYPEID"].ToString(); Decimal feeAmount = Convert.ToDecimal(ds.Tables[0].Rows[i]["TRANSACTIONAMOUNT"]); if (feeID == "7") { totNewCardFee = totNewCardFee + feeAmount; } else if (feeID == "8") { totAdditionalFee = totAdditionalFee + feeAmount; } else if (feeID == "163") { totTxnFee = totTxnFee + feeAmount; } else if (feeID == "21") { totActFee = totActFee + feeAmount; } else if (feeID == "165") { totAnnualFee = totAnnualFee + feeAmount; } else if (feeID == "12") { totAuthFee = totAuthFee + feeAmount; } else if (feeID == "25") { totInactFee = totInactFee + feeAmount; } else if (feeID == "24") { totCardShipFee = totCardShipFee + feeAmoun

When i click on Next Page, GridView RowDataBound event and Databound event will be called up. Label is getting right value but when it displays, it displays the previous value. Dono know howz it happening.

Inderjeet Kaur Sr. Software Engg

I have a Grid view using ObjectDataSource. I add the values of a column and display it in a label in DataBound event. when i move to next page the value in label should change but its showing the values of first page only. Any help will be appreciated! Thanks in advance

Inderjeet Kaur Sr. Software Engg