Hi All,
I have a xml File named ITR_1.xml
<?xml version="1.0" encoding="UTF-8"?>
<ITR xmlns="http://incometaxindiaefiling.gov.in/main" xmlns:n1="http://incometaxindiaefiling.gov.in/" xmlns:ITR1FORM="http://incometaxindiaefiling.gov.in/ITR1" xmlns:ITR2FORM="http://incometaxindiaefiling.gov.in/ITR2" xmlns:ITR3FORM="http://incometaxindiaefiling.gov.in/ITR3" xmlns:ITR4FORM="http://incometaxindiaefiling.gov.in/ITR4" xmlns:ITRForm="http://incometaxindiaefiling.gov.in/master" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://incometaxindiaefiling.gov.in/main ITRMain09.xsd">
<ITR1FORM:ITR1>
<ITRForm:CreationInfo>
<ITRForm:SWVersionNo>4923</ITRForm:SWVersionNo>
<ITRForm:SWCreatedBy>KDK</ITRForm:SWCreatedBy>
<ITRForm:XMLCreatedBy>ZenIT</ITRForm:XMLCreatedBy>
<ITRForm:XMLCreationDate>2009-10-12</ITRForm:XMLCreationDate>
<ITRForm:IntermediaryCity>Jaipur</ITRForm:IntermediaryCity>
</ITRForm:CreationInfo>
<ITRForm:Form_ITR1>
<ITRForm:FormName>ITR-1</ITRForm:FormName>
<ITRForm:Description>For Indls having Income from Salary, Pension, family pension and Interest</ITRForm:Description>
<ITRForm:AssessmentYear>2009</ITRForm:AssessmentYear>
<ITRForm:SchemaVer>Ver1.0</ITRForm:SchemaVer>
<ITRForm:FormVer>Ver1.0</ITRForm:FormVer>
</ITRForm:Form_ITR1>
<ITRForm:PersonalInfo>
<ITRForm:AssesseeName>
<ITRForm:FirstName>PRAMOD</ITRForm:FirstName>
<ITRForm:MiddleName>PILLAY</ITRForm:MiddleName>
<ITRForm:SurNameOrOrgName>RAGHVAN</ITRForm:SurNameOrOrgName>
.
.
.
.
<ITRForm:Place>NAGPUR</ITRForm:Place>
<ITRForm:Date>2009-09-30</ITRForm:Date>
</ITRForm:Verification>
</ITR1FORM:ITR1>
</ITR>
then i have written this type of code to fill xml
Public Sub Fill_Section(ByVal clid As Integer, ByVal finyr As String)
Try
Class1.con.Close()
Class1.con.Open()
da = New SqlDataAdapter(" SELECT ClientMaster.ClientId, ClientMaster.FirstName, ClientMaster.MiddleName, ClientMaster.SurName, ClientMaster.PANNo, ClientMaster.ResiFlatNo, "
" ClientMaster.ResiBuildingName, CONVERT(char(20), ClientMaster.DOB, 103) AS DOB, ClientMaster.ResiStreet, ClientMaster.ResiArea, " & _
" FROM ClientMaster INNER JOIN IncomeTaxMaster ON ClientMaster.ClientId = IncomeTaxMaster.ClientId INNER JOIN " & _
" ClientITRMaster ON ClientMaster.ClientId = ClientITRMaster.ClientId INNER JOIN MasterResiStatus ON ClientMaster.ResiStatusId = MasterResiStatus.StatusId LEFT OUTER JOIN " & _
" MasterState ON ClientMaster.StateId = MasterState.StateId LEFT OUTER JOIN MasterWardCircle ON ClientMaster.WardCircleId = MasterWardCircle.WardCircleId " & _
" WHERE ClientMaster.ClientId=" & clid & " ", Class1.con)
da.Fill(ds1, "NAME")
ds.ReadXml(Request.PhysicalApplicationPath + "ITR_1.xml")
Dim row As DataRow = ds.Tables(0).NewRow
row("ITRForm:FirstName") = ds1.Tables(0).Rows(0).Item(1)
row("ITRForm:MiddleName") = ds1.Tables(0).Rows(0).Item(2)
Catch ex As Exception
Response.Write(ex.Message)
End Try
End Sub
while i m running this code the exeption occure that " Column 'ITRForm:FirstName' does not belong to table ITR1. "
also if i check ds it fill up with
ITR1_Id TaxExmpIntInc
0 0