Stored Procedure Calls Information to Visual Studio 2010 Windows Form

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Talisma_Lookup4

{

    public partial
class Form1 : Form

    {

        public Form1()

        {           
InitializeComponent();

       }

        private void
Form1_Load(object sender, EventArgs e)

        {          
this.BackColor = Color.DarkOrange;

        }

        private void
LoadData(Int32 Talisma_Search)

        {           
SqlConnection conn = new SqlConnection("Data
Source='talismadb';Initial Catalog=tlMain;Integrated Security=True");

            // change
this connection string according to you settings of sql server

            SqlCommand
cmd = new SqlCommand("dbo.Talisma_Search", conn);

           
cmd.CommandText = "Talisma_Search";

           
cmd.CommandType = CommandType.StoredProcedure;

           
cmd.Parameters.AddWithValue("@Talisma_Search ",
Talisma_Search);

           
SqlDataAdapter adapter = new SqlDataAdapter(cmd);

            DataSet
dataSet1 = new DataSet();

          
dataSet1.Tables.Clear();

          
adapter.Fill(dataSet1, "Table");

            //now you
can show this dataset table on window form how you want like i have shown to
Grid below           
//MyGrid.DataSource = dataSet1.Tables["Table"];

           
//bindingSource1 = new BindingSource(dataSet1, "Table");

           
//bindingNavigator1.BindingSource = bindingSource1;

            //MyGrid.DataSource
= bindingSource1;

           // Data is
accessible through the DataReader object here.

       }

   }

}

//cmd is your sqlcommand object

//TextBox1.Text=Convert.ToString(cmd.ExecuteScalar());

//Data Source=talismadb;Initial Catalog=tlMain;Integrated
Security=True);SqlCommand cmd = new SqlCommand(); 

Error      1              } expected          C:\Users\mbergeron\Documents\Visual Studio
2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs      76           14           Talisma_Lookup4

Error      2              Invalid token 'catch' in class,
struct, or interface member declaration                C:\Users\mbergeron\Documents\Visual
Studio 2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs     91                13           Talisma_Lookup4

Error      3              ; expected          C:\Users\mbergeron\Documents\Visual Studio
2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs      91           34           Talisma_Lookup4

Error      4              Invalid token '(' in class,
struct, or interface member declaration                C:\Users\mbergeron\Documents\Visual
Studio 2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs     93                32           Talisma_Lookup4

Error      5              Invalid token ')' in class,
struct, or interface member declaration                C:\Users\mbergeron\Documents\Visual
Studio 2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs     93                74           Talisma_Lookup4

Error      6              A namespace cannot directly
contain members such as fields or methods                C:\Users\mbergeron\Documents\Visual
Studio 2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs     96                4              Talisma_Lookup4

Error      7              Expected catch or finally               C:\Users\mbergeron\Documents\Visual
Studio 2010\Projects\Talisma_Lookup4\Talisma_Lookup4\Form1.cs      77           12           Talisma_Lookup4

SqlConnection conn = new SqlConnection("Data Source='talismadb';Initial Catalog=tlMain;Integrated Security=True");
            // change this connection string according to you settings of sql server
            SqlCommand cmd = new SqlCommand("dbo.Talisma_Search", conn);

            cmd.CommandText = "Talisma_Search";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Talisma_Search ", Talisma_Search);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);

            dataSet1.Tables.Clear();
            adapter.Fill(dataSet1, "Table");

            //now you can show this dataset table on window form how you want like i have shown to Grid below
            MyGrid.DataSource = dataSet1.Tables["Table"];
            bindingSource1 = new BindingSource(dataSet1, "Table");
            bindingNavigator1.BindingSource = bindingSource1;
            MyGrid.DataSource = bindingSource1;

Any help would be appreciated.

Thank you,

Mary