[Solved] class that gets a value from database [closed]

by 


public static class myMethods
{
    public static string getName(){  
      string name = "";  
      ConnectionStringSettings myConnectionString = ConfigurationManager.ConnectionStrings["LibrarySystem.Properties.Settings.LibraryConnectionString"];
      using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
      {
        myDatabaseConnection.Open();
        using (SqlCommand mySqlCommand = new SqlCommand("select Top 1 * from Setting Order By SettingID Desc", myDatabaseConnection))
        using (SqlDataReader sqlreader = mySqlCommand.ExecuteReader())
        {
            if (sqlreader.Read())
            {
                name = sqlreader["Name"].ToString();
            }
        }
      }
      return name;
    }
}

Form:
private void Button1_Click(object sender, EventArgs e)
{     
    textBox1.Text = myMethods.getName();
}

Or this:

public static class myMethods
{
    public static void getName(out string name){  
      //.....
    }
}
private void Button1_Click(object sender, EventArgs e)
{
    string name;
    myMethods.getName(out name);
    textBox1.Text = name;
}

0

solved class that gets a value from database [closed]