UPLOADING AND DOWNLOADING THE PDF FILES FROM THE DATABASE

CREATE TABLE [dbo].[books]
(
[ID] [int] IDENTITY(1,1) NOT NULL,
[Pdlfiles] [varbinary](max) NULL,
[File name] [varchar](max) NULL
)

CREATE A PAGE FOR UPLOADING PDF AS addpdf.aspx AND ADD THE FOLLOWING

         <label>PDF FILE</label>
         <asp:TextBox ID="txtauthor" runat="server"></asp:TextBox>
         <br />
         <label>FILE NAME</label>
         <asp:FileUpload ID="fileupldsample" runat="server" />
         <br />
         <asp:Button ID="btnupload" runat="server" Text="Upload" onclick="btnupload_Click" />

   

IN THE  addpdf.aspx.cs PAGE  ADD THE FOLLOWING

// This namespace should be there
using System.IO;
 protected void btnupload_Click(object sender, EventArgs e)
 {
if(fileupldsample.HasFile)
{
Stream fs = default(Stream);
fs = fileupldsample.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
byte[] pdfbytes = br.ReadBytes(fileupldsample.PostedFile.ContentLength);
SqlCommand cmd = new SqlCommand("insert into tablename",);
}
 }

PASSING VALUE FROM ONE FORM TO ANOTHER USING C#

This an example of transferring a value from Form1 to Form2..

IN THE FORM1 TYPE THE FOLLOWING CODE

   public partial class Form1 : Form
    {
        public Form1()
        {

            InitializeComponent();
         }

        public static string Sno;  //Declaring a Global variable ID

    private void button1_Click(object sender, EventArgs e)
        {

         Sno = textBox1.Text;    //Type any value in the textbox and click the button
         Form2 f2 = new Form2();
         f2.Show();
        }
      }

IN THE FORM2 TYPE THE FOLLOWING CODE

  public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
         }

  private void Form2_Load(object sender, EventArgs e)
        {

          int v1 =  int.Parse(Form1.Sno);  //Getting the Sno value from Form1
          Label1.Text  = Sno.ToString();  //Displaing the Sno value got from Form1
        }
     }

HOW TO CALCULATE COLUMN TOTAL IN DATAGRIDVIEW USING C#

// POPULATE THE DATAGRIDVIEW AND THEN INCLUDE THE FOLLOWING CODE IN ANY EVENT.HERE I AM USING IT IN A BUTTON CLICK EVENT.

private void button1_Click(object sender, EventArgs e)
{

int Total = 0;

for (int i = 0; i < dataGridView1.Rows.Count; i++)

{

Total += Convert.ToInt32(dataGridView1.Rows[i].Cells["Columnname"].Value);

}

textBox1.Text = Total.ToString();
}