Monday, October 31, 2016

sql auto increment jump

You resolve your auto increment  jumping from this


you can also resolve the issue into another way if you are using EDMX.

Before inserting data into table get the max id value from your table.


 int maxAge = context.Persons.Max(p => p.Age);  

Now add your increment number maxAge+1  

Map the id value with your table.

NB: You table Identity specification : Is Identity Will be no.

Monday, October 24, 2016

C# read word document and get specific data from document




  // Reding all word document from a specific folder  
       foreach (string file in Directory.EnumerateFiles(@"D:\", "*.doc"))  
       {  
         //string contents = File.ReadAllText(file);  
         Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application();  
         object miss = System.Reflection.Missing.Value;  
         object path = file; // @"D:\35339.doc";  
         object readOnly = true;  
         Microsoft.Office.Interop.Word.Document docs = word.Documents.Open(ref path, ref miss, ref readOnly, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss);  
         string totaltext = "";  
         for (int i = 0; i < 2; i++) // i set value 2 you can change  
         {  
           totaltext += " \r\n " + docs.Paragraphs[i + 1].Range.Text.ToString();  
         }  
         // Getting data after specific data from the string  
         string _findName = "Name :";  
         string code = totaltext.Substring((totaltext.IndexOf(_findName) + _findName.Length), 20);  
         string _findMrno = "MR. No.      :";  
         string mrNo = totaltext.Substring((totaltext.IndexOf(_findMrno) + _findMrno.Length), 12);  
         string _findAge = "Age     :";  
         string age = totaltext.Substring((totaltext.IndexOf(_findAge) + _findAge.Length), 6);  
         string _findDate = " Date           :";  
         string date = totaltext.Substring((totaltext.IndexOf(_findDate) + _findDate.Length));  
         // You code for insert or other things to do  
         docs.Close();  
         word.Quit();  
       }  



SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...