public static DataSet getProjectNoteDetail(int projNote_Id) { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@projNote_Id", projNote_Id); //return SqlHelper.ExecuteDataset(strConn, CommandType.StoredProcedure, "getProjectNoteDetailById", param); return SqlHelper.ExecuteDataset(strConn, CommandType.Text, "select * from tbl_projnotes where projnote_Id = @projNote_Id", param); }
Aspx
<asp:Repeater ID="repProjects" runat="server" OnItemCommand="repProjects_ItemCommand"> <ItemTemplate> <tr id="<%#(Convert.ToInt32(((RepeaterItem)Container).ItemIndex+1)%2==0?"ContentMainRow":"ContentAlternateRow")%>"> <td> <%#(((RepeaterItem)Container).ItemIndex+1).ToString()%> </td> <td> <%#Eval("projNote_Title") %> </td> <td> <%#Eval("projNote_Note") %> </td> <td> <%#Eval("projNote_FileAttached") %> </td> <td> <asp:ImageButton ID="imgBtnEdit" CommandName="Edit" ToolTip="Edit a record." CommandArgument='<%#Eval("projNote_Id") %>' runat="server" ImageUrl="~/resources/Images/edit.png" /> <asp:ImageButton ToolTip="View Details." ID="imgBtnViewProjectDetails" CommandName="View" CommandArgument='<%#Eval("projNote_Id") %>' runat="server" ImageUrl="~/resources/Images/viewDetails_Icon.png" /> </td> </tr> </ItemTemplate> </asp:Repeater><asp:Repeater ID="repProjectDetails" runat="server"> <ItemTemplate> <table border="1" style="border: 1px solid #4a6491; border-collapse: collapse;" cellpadding="5px" cellspacing="0" width="100%"> <tr> <td style="width: 25%;"> <b>Project Title</b> </td> <td style="width: 75%;"> <%#Eval("projNote_title")%> </td> </tr> <tr> <td valign="top"> <b>Project Note</b> </td> <td> <%#Eval("projNote_Note")%> </td> </tr> </table> </ItemTemplate> </asp:Repeater>
aspx.csprotected void repProjects_ItemCommand(object source, RepeaterCommandEventArgs e) { lblInfoMessage.Text = string.Empty; divMessage.Style.Add("display", "none"); if (e.CommandName == "Edit") { hfCurrentTab.Value = (0).ToString();//======= To show the add tabcontainer on postback hfSelectedRecord.Value = e.CommandArgument.ToString();
bindProjectRecordsToEdit(Convert.ToInt32(e.CommandArgument)); tabContainerProjects.ActiveTabIndex = 0; btnSaveProject.Visible = false; btnUpdateProject.Visible = true; } else if (e.CommandName == "View")//====== To show the complete details of the project. { repProjectDetails.DataSource = clsManageNoteMethods.getProjectNoteDetail(Convert.ToInt32(e.CommandArgument)); repProjectDetails.DataBind(); mpeProjectDetails.Show(); } }
When i click on View it gives error -- Input string was not in a correct format.
Thanx