Comments by Member 10272175 (Top 20 by date)

sir please help me for my file

<avokasmartform>
<FormData>
<currentpage>1
<customerdetails>
<cidn>
<companydetails>
<abn>62091152573
<acn>091152573
<abnacn>
<companyname>RSJ TRADING PTY LTD T/AS BM GU
<businessname>RSJ TRADING PTY LTD T/AS BM GU

<usepreviousdata>
<address1>700 WATERDALE RD
<address2>
<suburb>BANDURA
<state>VIC
<Postcode>3083</Postcode>

<contactdetails>
<usepreviousdata>
<contactname>JACQUELINE MAO
<PhoneNumber>0394585893</PhoneNumber>
<mobilenumber>0418885185
<faxnumber>
<emailaddress>manager@bmguesthouse.com.au
<secondaryemailaddress>

<technicalcontact>
<usepreviousdata>Same as contact
<contactname>JACQUELINE MAO
<PhoneNumber>0394585893</PhoneNumber>
<mobilenumber>0418885185
<faxnumber>
<emailaddress>manager@bmguesthouse.com.au
<secondaryemailaddress>

<billingdetails>
<billingtype>Existing Account
<billingaddress>
<usepreviousdata>
<address1>
<address2>
<suburb>
<state>
<Postcode/>

<existingaccount>
<accountnumber>1441700600
<fullnationalnumber>
<accounttype>Account number


<ownershipcode>

<servicedetails>
<service>
<customerhascsv>Bigpond Broadband ADSL service,Business Broadband ADSL service,Business Broadband ADSL Standalone service,Business Broadband ADSL Bundled service,Business Broadband BDSL Metro service,Business Broadband BDSL Regional service,Business Broadband Ethernet Metro service,Business Broadband Ethernet Regional service,Business Broadband Access service,Business Broadband Starter service,Business Broadband Advantage ADSL service,Business Broadband Advantage BDSL Metro service,Business Broadband Advantage BDSL Regional service,Telstra Internet Direct service,Non-Telstra broadband service,Not applicable,BizEssentials service,Business Broadband FTTP Bundled,Business Broadband FTTP Standalone
<customerhas>Business Broadband ADSL Bundled service
<customerwantsjoincsv>Bigpond Broadband ADSL service:Migration of existing service to Business Broadband ADSL Standalone,Migration of existing service to Business Broadband ADSL Bundled,New Business Broadband ADSL Standalone service,New Business Broadband ADSL Bundled service,New Business Broadband Ethernet Metro service,New Business Broadband Ethernet Regional service,New BizEssentials,Migration of existing service to BizEssentials,New Business Broadband FTTP Standalone,New Business Broadband FTTP Bundled;Business Broadband ADSL service:Cancellation of existing service,Change existing service,Migration of existing service to Business Broadband ADSL Standalone,Migration of existing service to Business Broadband ADSL Bundled,New Business Broadband ADSL Standalone service,New Business Broadband A

Sir I have given query below

Sir This is my Listview Code and Table Creation Query

private void Submit_Click(object sender, EventArgs e)
{
SqlConnection objCon = new SqlConnection("Data Source=OM-PC;Initial Catalog=master;Integrated Security=True");
SqlDataAdapter objAdapt = new SqlDataAdapter("select * from Place Where NAME="+ textBox1.Text.ToString(), objCon);
DataTable objDT = new DataTable();
objAdapt.Fill(objDT);
//now initialize listview
// Set the view to show details.
listView1.View = View.Details;
// Allow the user to edit item text.
listView1.LabelEdit = true;
// Allow the user to rearrange columns.
listView1.AllowColumnReorder = true;
// Select the item and subitems when selection is made.
listView1.FullRowSelect = true;
// Display grid lines.
listView1.GridLines = true;
// Sort the items in the list in ascending order.
// listView1.Sorting = SortOrder.Ascending;
//finally fill listview
for (int i = 0; i < objDT.Rows.Count; i++)
{
DataRow objDR = objDT.Rows[i];
ListViewItem listitem = new ListViewItem(objDR["NAME"].ToString());
listitem.SubItems.Add(objDR["Education"].ToString());
listitem.SubItems.Add(objDR["Email"].ToString());
// listitem.SubItems.Add(objDR["Phone"].ToString());
listView1.Items.Add(listitem);
}
}


* CREATE TABLE PLACE(DNO INT NOT NULL , NAME VARCHAR(20), EDUCATION VARCHAR(10), EMAIL NVARCHAR(20), PHONE INT ))

Sir , I am implementing it in windows based C# code.

So Could you please help me for same ?

Hi Sir

I am building this in C# windows based app. I have two textboxes From Date and expire date please tell me ....I want that expire date will autopopulate by from date ...please tell me how to do this ....

Sir , This is my code to extract data from XML File on excel cells. however I am getting error that "User defined type not defined" please help me

Private Sub CommandButton1_Click()



Sheet1.Activate
Range("F9:F21").ClearContents
Range("C6:C6").ClearContents
Range("f6:f6").ClearContents
Dim xml_doc As New DOMDocument
Dim brtn As Boolean
Dim onode As IXMLDOMElement
Dim elst As IXMLDOMNodeList
Dim chnode As IXMLDOMElement
Dim chnode1 As IXMLDOMElement
brtn = xml_doc.Load("C:\My Documents\Form Data.xml")

intr = 2
If brtn Then

' Set onode = xml_doc.selectSingleNode("//FullNationalNumber")
' acc = Trim(onode.Text)
'
' If acc = "" Then
' Set onode = xml_doc.selectSingleNode("//ReferenceNumber")
' Sheet1.Cells(6, 3) = onode.Text
' End If

For Each onode In xml_doc.SelectNodes("//ExistingService")
If onode.HasChildNodes Then
For Each chnode In onode.ChildNodes
nm = chnode.nodeName
If nm = "FullNationalNumber" Then
Sheet1.Cells(6, 3) = chnode.Text

End If
Next
End If
Next


For Each onode In xml_doc.SelectNodes("//ExistingAccount")
If onode.HasChildNodes Then
For Each chnode In onode.ChildNodes
nm = chnode.nodeName
If nm = "AccountNumber" Then
acc = Trim(chnode.Text)
If acc <> "" Then
Sheet1.Cells(6, 6) = "'" & chnode.Text
End If

End If
If nm = "FullNationalNumber" Then
acc = Trim(chnode.Text)
If acc <> "" Then
Sheet1.Cells(6, 6) = "'" & chnode.Text
End If

End If

Next
End If
Next






Set onode = xml_doc.SelectSingleNode("//CIDN")
Sheet1.Cells(9, 3) = onode.Text

Set onode = xml_doc.SelectSingleNode("//ABN")
Sheet1.Cells(10, 3) = onode.Text
Set onode = xml_doc.SelectSingleNode("//ACN")
Sheet1.Cells(11, 3) = onode.Text
Set onode = xml_doc.SelectSingleNode("//BusinessName")
Sheet1.Cells(12, 3) = onode.Text

'// customer Contacht
For Each onode In xml_doc.SelectNodes("//ContactDetails")
If onode.HasChildNodes Then
For Each chnode In onode.ChildNodes
nm = chnode.nodeName
If nm = "ContactName" Then
Sheet1.Cells(14, 3) = chnode.Text
ElseIf nm = "PhoneNumber" Then
Sheet1.Cells(15, 3) = chnode.Text
ElseIf nm = "EmailAddress" Then
Sheet1.Cells(16, 3) = chnode.Text
End If
Next
End If
Next

Set onode = xml_doc.SelectSingleNode("//AccountNumber")
Sheet1.Cells(18, 3) = onode.Text

Set onode = xml_doc.SelectSingleNode("//CustomerWants")
Sheet1.Cells(22, 3) = onode.Text
Set onode = xml_doc.SelectSingleNode("//CustomerHas")
Sheet1.Cells(21, 3) = onode.Text
Set onode = xml_doc.SelectSingleNode("//OwnershipCode")
Sheet1.Cells(19, 3) = onode.Text

'// Site Address
For Each onode In xml_doc.SelectNodes("//SiteAddress")
If onode.HasChildNodes Then
For Each chnode In onode.ChildNodes
nm = chnode.nodeName
If nm = "Address1" Then
Sheet1.Cells(25, 3) = chnode.Text
ElseIf nm = "Address2 " Then
Sheet1.Cells(26, 3) = chnode.Text
ElseIf nm = "Suburb" Then
Sheet1.Cells(27, 3) = chnode.Text
ElseIf nm = "State" Then
Sheet1.Cells(28, 3) = chnode.Text
ElseIf nm = "Postcode" Then
Sheet1.Cells(29, 3) = chnode.Text
End If
Next
End If
Next
Set onode = xml_doc.SelectSingleNode("//SiteAd

Yes Now I have taken corect one as still shows error could not found
'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Form Data.xml'.

protected void Page_Load(object sender, EventArgs e)
{ server.MapPath("./Form Data.xml");
}
protected void Button1_Click(object sender, EventArgs e)
{
XmlReader xmlRdr = XmlReader.Create("./Form Data.xml");
while (xmlRdr.Read())
{ if (xmlRdr.Name == "CompanyName") { Label13.Text = (Label13.Text == string.Empty) ? xmlRdr.ReadString() : Label13.Text; }

could not found file path

In Above code, I took as you suggested as
protected void Page_Load(object sender, EventArgs e)
{
server.MapPath("Form Data.xml");
}

protected void Button1_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
Panel2.Visible = true;
Panel6.Visible = true;
Button1.Visible = false;

XmlReader xmlRdr = XmlReader.Create(".\Form Data.xml");
while (xmlRdr.Read())
{
if (xmlRdr.Name == "CompanyName") { Label13.Text = (Label13.Text == string.Empty) ? xmlRdr.ReadString() : Label13.Text;
}

Buut It shows error...Please help me to modify same

My code is like sir

protected void Page_Load(object sender, EventArgs e)
{
string pathToFiles = Server.MapPath(@"C:\Form Data.xml");

Panel1.Visible = false;
Panel2.Visible = false;

Panel6.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
Panel2.Visible = true;

Panel6.Visible = true;
Button1.Visible = false;

XmlReader xmlRdr = XmlReader.Create(@"C:\Form Data.xml");



while (xmlRdr.Read())
{
if (xmlRdr.Name == "CompanyName")
{
Label13.Text = (Label13.Text == string.Empty) ? xmlRdr.ReadString() : Label13.Text;
}

Sir my code for file path is
string pathToFiles = Server.MapPath(@"C:\Form Data.xml");

My project files saved in C drive
So How to give absolute path ? sir please help me

Yes Sir ...Script is ready ....I got code ..Now How to run that on remote server.. ?

Sir I am beginner ....Could you please tell me simple way .........I have IP address..

Sir please tell so How can I specify path ?