Click here to Skip to main content
15,891,621 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
this error occurred when i change the database name in sql server
but the the method running and im sure i changed the database name also in the connectionString
how to solve this problem ... Plz

------------------------------------------------------
protected void BindEmployeeDetails2()
{
con.Open();
int userid = int.Parse(Request.QueryString["UserId"]);
SqlCommand cmd = new SqlCommand("Select * from SU_Seeker_Qualifications where UserId=" + userid , con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gvDetails2.DataSource = ds;
gvDetails2.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvDetails2.DataSource = ds;
gvDetails2.DataBind();
int columncount = gvDetails2.Rows[0].Cells.Count;
gvDetails2.Rows[0].Cells.Clear();
gvDetails2.Rows[0].Cells.Add(new TableCell());
gvDetails2.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails2.Rows[0].Cells[0].Text = "No Records Found";
}

-----------------------------------------

XML
<asp:GridView ID="gvDetails2" DataKeyNames="UserId,Id" runat="server"
        AutoGenerateColumns="False" CssClass="Gridview" HeaderStyle-BackColor="#0C8063"
ShowFooter="True" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"
        onrowcancelingedit="gvDetails2_RowCancelingEdit"
        onrowdeleting="gvDetails2_RowDeleting" onrowediting="gvDetails2_RowEditing"
        onrowupdating="gvDetails2_RowUpdating"
        onrowcommand="gvDetails2_RowCommand">

<Columns>
<asp:TemplateField>
<EditItemTemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.jpg" ToolTip="Update" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/Cancel.jpg" ToolTip="Cancel" Height="20px" Width="20px" />

</EditItemTemplate>
<ItemTemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.jpg" ToolTip="Edit" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/delete.jpg" ToolTip="Delete" Height="20px" Width="20px" />
</ItemTemplate>
<FooterTemplate>
<asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/AddNewitem.jpg" CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User" ValidationGroup="validaiton" />

</FooterTemplate>
 </asp:TemplateField>
<asp:TemplateField HeaderText=" النوع">
<EditItemTemplate>
    <asp:TextBox ID="txtType" runat="server" Text='<%#Eval("Type") %>'/>

</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblType" runat="server" Text='<%#Eval("Type") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtftrType" runat="server"/>
<asp:RequiredFieldValidator ID="rfvType" runat="server" ControlToValidate="txtftrType" Text="*" ValidationGroup="validaiton"/>
</FooterTemplate>
</asp:TemplateField>
 <asp:TemplateField HeaderText="تاريخ الالتحاق">
 <EditItemTemplate>
 <asp:TextBox ID="txtJoin_Date" runat="server" Text='<%#Eval("Join_Date") %>'/>
 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblJoin_Date" runat="server" Text='<%#Eval("Join_Date") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrJoin_Date" runat="server"/>
 <asp:RequiredFieldValidator ID="rfvJoin_Date" runat="server" ControlToValidate="txtftrJoin_Date" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
 </asp:TemplateField>
 <asp:TemplateField HeaderText="تاريخ التخرج">
 <EditItemTemplate>
 <asp:TextBox ID="txtGraduated_Date" runat="server" Text='<%#Eval("Graduated_Date") %>'/>

 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblGraduated_Date" runat="server" Text='<%#Eval("Graduated_Date") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrGraduated_Date" runat="server"/>
  <asp:RequiredFieldValidator ID="rfvGraduated_Date" runat="server" ControlToValidate="txtftrGraduated_Date" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
 </asp:TemplateField>
    <asp:TemplateField HeaderText="الجامعــه">
 <EditItemTemplate>
 <asp:TextBox ID="txtUniverisity" runat="server" Text='<%#Eval("Univerisity") %>'/>

 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblUniverisity" runat="server" Text='<%#Eval("Univerisity") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrUniverisity" runat="server"/>
  <asp:RequiredFieldValidator ID="rfvUniverisity" runat="server" ControlToValidate="txtftrUniverisity" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
 </asp:TemplateField>
    <asp:TemplateField HeaderText="الكليـــه">
        <EditItemTemplate>
 <asp:TextBox ID="txtFaculty" runat="server" Text='<%#Eval("Faculty") %>'/>

 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblFaculty" runat="server" Text='<%#Eval("Faculty") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrFaculty" runat="server"/>
  <asp:RequiredFieldValidator ID="rfvFaculty" runat="server" ControlToValidate="txtftrFaculty" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
    </asp:TemplateField>
     <asp:TemplateField HeaderText="التخصــص">
        <EditItemTemplate>
 <asp:TextBox ID="txtMajor" runat="server" Text='<%#Eval("Major") %>'/>
 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblMajor" runat="server" Text='<%#Eval("Major") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrMajor" runat="server"/>
  <asp:RequiredFieldValidator ID="rfvMajor" runat="server" ControlToValidate="txtftrMajor" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
    </asp:TemplateField>

     <asp:TemplateField HeaderText="المعدل التراكمى">
        <EditItemTemplate>
 <asp:TextBox ID="txtGrade" runat="server" Text='<%#Eval("Grade") %>'/>
 </EditItemTemplate>
 <ItemTemplate>
 <asp:Label ID="lblGrade" runat="server" Text='<%#Eval("Grade") %>'/>
 </ItemTemplate>
 <FooterTemplate>
 <asp:TextBox ID="txtftrGrade" runat="server"/>
  <asp:RequiredFieldValidator ID="rfvGrade" runat="server" ControlToValidate="txtftrGrade" Text="*" ValidationGroup="validaiton"/>
 </FooterTemplate>
    </asp:TemplateField>
 </Columns>

<HeaderStyle BackColor="#0C8063" Font-Bold="True" ForeColor="White"></HeaderStyle>
</asp:GridView>


Posted

1 solution

Please ensure the select "Select * from SU_Seeker_Qualificationsstate .... " contains the column name "Type"
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900