C#

sajid.salim.khan wrote:

SqlCommand myCommand = new SqlCommand("INSERT INTO Designation (Designation) " + "Values ('string')", myConnection);


the problem is in this line how to insert a text box value in the values place

martin_hughes wrote:

Aha, says I, multiple threads can speed this up.

martin_hughes wrote:

could too many threads in this situation lead to much slower performance as they all vie for time?

Pete O`Hanlon wrote:

Notepad uses a fixed width font

private void PrintTextFileHandler(object sender, PrintPageEventArgs ppeArgs)<br />
        {<br />
            //Get the Graphics object<br />
            Graphics g = ppeArgs.Graphics;<br />
            float linesPerPage = 0;<br />
            float yPos = 0;<br />
            int count = 0;<br />
            //Read margins from PrintPageEventArgs<br />
            float leftMargin = ppeArgs.MarginBounds.Left;<br />
            float topMargin = ppeArgs.MarginBounds.Top;<br />
            string line = null;<br />
            //Calculate the lines per page on the basis of the height of the page and the height of the font<br />
            linesPerPage = ppeArgs.MarginBounds.Height / verdana10Font.GetHeight(g);<br />
            //Now read lines one by one, using StreamReader<br />
            while (count < linesPerPage &&<br />
            ((line = reader.ReadLine()) != null))<br />
            {<br />
                //Calculate the starting position<br />
                yPos = topMargin + (count *<br />
                verdana10Font.GetHeight(g));<br />
                //Draw text<br />
                g.DrawString(line, verdana10Font, Brushes.Black,<br />
                leftMargin, yPos, new StringFormat());<br />
                //Move to next line<br />
                count++;<br />
            }<br />
            //If PrintPageEventArgs has more pages to print<br />
            if (line != null)<br />
            {<br />
                ppeArgs.HasMorePages = true;<br />
            }<br />
            else<br />
            {<br />
                ppeArgs.HasMorePages = false;<br />
            }<br />
        }