i m using gridview to add New records into the database using the following code . Its not taking the values in footer row
Protected Sub AddNewRecord(ByVal sender As Object, ByVal e As EventArgs)
Dim Employ_Id As String = DirectCast(Empdata.FooterRow _
.FindControl("txtEmpID1"), TextBox).Text
Dim Fullname As String = DirectCast(Empdata.FooterRow _
.FindControl("txtEmpName1"), TextBox).Text
Dim Designation1 As String = DirectCast(Empdata.FooterRow _
.FindControl("txtDesignation1"), TextBox).Text
Dim DateofJoin As String = DirectCast(Empdata.FooterRow _
.FindControl("txtDateOfJoining1"), TextBox).Text
Dim income As Integer = DirectCast(Empdata.FooterRow _
.FindControl("txtSalary1"), TextBox).Text
Dim Dept As String = DirectCast(Empdata.FooterRow _
.FindControl("txtDepartment1"), TextBox).Text
Dim con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.Text
cmd.CommandText = "insert into EmployRecord(EmpID, EmpName,Designation,DateOfJoining,Salary,Department,Address,Contact,Email,Sex" & _
") values(@Employ_Id, @Fullname, @Designation1,@DateofJoin,@income,@Dept,NULL,NULL,NULL,NULL);" & _
"select * from EmployRecord"
cmd.Parameters.Add("@Employ_Id", SqlDbType.VarChar).Value = Employ_Id
cmd.Parameters.Add("@Fullname", SqlDbType.VarChar).Value = Fullname
cmd.Parameters.Add("@Designation1", SqlDbType.Int).Value = Designation1
cmd.Parameters.Add("@DateofJoin", SqlDbType.NVarChar).Value = DateofJoin
cmd.Parameters.Add("@income", SqlDbType.Int).Value = income
cmd.Parameters.Add("@Dept", SqlDbType.VarChar).Value = Dept
con.Open()
cmd.Connection = con
cmd.ExecuteNonQuery()
BindData()
End Sub
