1
Answer

reading two or more xml filesusing xml document

johnsanthosh_tr

johnsanthosh_tr

20y
1.9k
1
Hi I have done a program such that it reads a xml schema and gets data from a input xml file and loads into a particular column, the values (for the existence of same field) in a new xml file. other fields are loaded with values automatically. Now I have to read one more xml file(another input xml file along with the first one and load into anoyther column fo rthe existence of that field) I have done for reading one xml file. How to read two or more at the same time. Here is my that part of the coding. please help me to do this. In the coding I have marked **************** in the middle, that is the part wher I have to read the input xml . so I need to read two or more files there. What shall I do. please help me to do that private void button2_Click(object sender, System.EventArgs e) { ArrayList FiledNames = new ArrayList(); XmlDocument xdc = new XmlDocument(); //Read the file which contain the field names xdc.Load(@"C:\CDEV\testdatagenerator\Field Names.xml"); XmlNodeList nodFields = xdc.DocumentElement.SelectNodes("//item"); for(int i=0; i
Answers (1)
1
Ben Chris
35 5.5k 1.1m 8y
your issue here is that you are comparing dates valus exactly with the designated columns and I am assuming that your table date column is of datetime type. This means you need to discard time part from both your target column and your from and to dates i.e.
 
 
  1. select * from tablename where DATEADD(dd,0,DATEDIFF(dd,0,date )) between DATEADD(dd,0,DATEDIFF(dd,0,'01-12-2016')) AND DATEADD(dd,0,DATEDIFF(dd,0,'01-02-2017')) 
Accepted
1
Rajeev Punhani
NA 4.7k 402.7k 8y

Hi Vinay,

 Please find the below link.

https://www.codeproject.com/tips/355235/how-to-search-between-two-dates-and-get-all-record 
1
Amit Gupta
NA 16.5k 25.7k 8y
@Vinay
 
It has always been observed for many times that the problem is occuring with only the date formats
 
Always use the universal format 'yyyy-MM-dd' format instead using 'MM-dd-yyyy'. You can change its format whichever suits the clients.
 
try searching like this
 select * from tablename where date between '2016-12-01' and '2017-02-01'
 
1
Catcher Wong
NA 4.5k 188.6k 8y
Hi , 
 
I can not  understand you question clearly ! Do you mean that?
 
1
Ramesh Palanivel
NA 9.5k 138.6k 8y
HI Vinay,
 
Try your code first in your DB, if it is working fine , check whether the DB and system format both are same or not.
 
try this URL, It may help you
 
http://stackoverflow.com/questions/14353434/selecting-data-between-2-dates 
 
http://stackoverflow.com/questions/16447877/c-sharp-between-two-dates-search
 
http://stackoverflow.com/questions/35272405/how-to-search-between-two-dates-in-c-sharp-with-ms-access
 
http://www.c-sharpcorner.com/forums/search-between-two-dates