Comments by dr.kitanjal (Top 17 by date)

Thanks Now I am getting this error

System.InvalidOperationException was unhandled
Message="There is an error in XML document (2, 2)."
Source="System.Xml"
StackTrace:
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(Stream stream)
at Test.Main(String[] args) in C:\Users\rahul.dhoble\AppData\Local\Temporary Projects\ConsoleApplication1\Program.cs:line 62
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: System.InvalidOperationException
Message="<datatable xmlns=""> was not expected."
Source="cfe6q0aa"
StackTrace:
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderDatatable.Read7_Datatable()
InnerException:


Code is as below :
using System;
using System.IO;
using System.Text;
using System.Xml;
using System.Xml.Serialization;

[XmlRoot("Datatable"), Serializable]
public class Datatable
{
[XmlElement("Employees")]
public Employees Employees { get; set; }
}

public class Employees
{
[XmlAttribute("Count")]
public int Count { get; set; }
[XmlElement("Employee")]
public Employee Employee { get; set; }
}

public class Employee
{
[XmlAttribute("Code")]
public string Code { get; set; }
[XmlAttribute("Name")]
public string Name { get; set; }
[XmlElement("Address")]
public Address Address { get; set; }
[XmlElement("Contact")]
public Contact Contact { get; set; }
}

public class Address
{
[XmlAttribute("City")]
public string City { get; set; }
[XmlAttribute("Pin")]
public string Pin { get; set; }
[XmlText]
public string AddressValue { get; set; }
}

public class Contact
{
[XmlAttribute("Mob")]
public string Mob { get; set; }
[XmlAttribute("Phone")]
public string Phone { get; set; }
[XmlAttribute("Email")]
public string Email { get; set; }
[XmlText]
public string ContactValue { get; set; }
}
public class Test
{
public static void Main(string[] args)
{
Console.Write("Hi");
XmlSerializer serializer = new XmlSerializer(typeof(Datatable));
FileStream loadStream = new FileStream("sample.xml", FileMode.Open, FileAccess.Read);
Datatable loadedObject = (Datatable)serializer.Deserialize(loadStream);
loadStream.Close();
Console.ReadKey();
}

}

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.Xml.Serialization;
namespace EMPPRO
{


public partial class Form1 : Form
{

public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
FileStream loadStream = new FileStream("ep.xml", FileMode.Open, FileAccess.Read);
Datatable loadedObject = (Datatable)serializer.Deserialize(loadStream);
loadStream.Close();

}
}
}

Here is my main class . I am getting below error . Please suggest

Error 2 The name 'serializer' does not exist in the current context

But still here I need to create class of known variable and array and that won't work if my XML node value and attribute changes
Please explain me with some code snippet.
Thanks in advance

What is this ?

But in this case my "EXEC dbname.dbo.spname parameter" is not fixed . It may be any valid SQL query or SP or SP with parameters

But how could I pass @Accountid ?

SELECT * INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=(local)\SQL2008;Trusted_Connection=yes;',
'EXEC getBusinessLineHistory' + @Accountid )

Result into error

Can you tell which column would specified to be invalid in error ?

Thanks for you help

Thanks . So overall we need to use the third party tool anyway because it couldn't attach files and thrown errors.That's why I need sideway.

Please learn about full text index and use them

Can you please let me know how to restore the data updated between 3 am to 3 40 am from .log file ? Thanks in advance

Thanks Amir , But as a DBA I can not loss 40 min of data . It is very huge database update. Can I recover it from log file (.ldf) file which are present in data folder along with .MDF file ?