Llenar TextBox de un Store Procedure (DataSet)

[Trulala de cordoba]

Mas o menos podrías hacer así:

Código:

SqlCommand myCommand = new SqlCommand("dbo.MyStoredProcedure");
myCommand.CommandType = CommandType.StoredProcedure;

// create SqlConnection
SqlConnection myConnection = new SqlConnection("your connection string
here");
myCommand.Connection = myConnection;
SqlDataAdapter da = new SqlDataAdapter(myCommand);

DataSet data = new DataSet();
da.Fill(data);


foreach(DataRow Row in Data.Tables[0].Rows)
{
txtNombre.Text = Row.cells["Nombre"].value.ToString();
}