C#

SqlConnection sql_conn = new SqlConnection("connection_string");
SqlCommand sql_cmd = new SqlCommand();
sql_cmd.Connection = sql_conn;
sql_cmd.CommandText = "store_procedure";
sql_cmd.CommandType = CommandType.StoredProcedure;
// none or X parameters here
sql_cmd.Parameters.Add("@intvariable", SqlDbType.Int).Value = Convert.ToInt32(MyTextBox1.Text);
sql_cmd.Parameters.Add("@stringvariable", SqlDbType.Varchar).Value = MyTextBox2.Text;
sql_conn.Open();
SqlDataAdapter sql_da = new SqlDataAdapter();
sql_da.SelectCommand = sql_cmd;
DataTable dt = new DataTable();
sql_da.Fill(dt);
sql_conn.Close();
Mydatagridview.DataSource = dt;

List<int> Audios = new List<int>();
List<int> Videos = new List<int>();
List<int> Books = new List<int>();

List<int> All = new List<int>();

All.AddRange(Audios);
All.AddRange(Videos);
All.AddRange(Books);

papy-boom wrote:

the list ALL must contains the merge of the three list, the question is can we do with out using foreach statment for the thre list.

List<int> all = new List<int>(audios.Count + videos.Count + books.Count);
all.AddRange(audios);
all.AddRange(videos);
all.AddRange(books);

DateTime.Now

void FillRTB(string filepath){
   byte[] ByteRead = new byte[300];
   using (FileStream fs = new FileStream(filepath, FileMode.Open, FileAccess.ReadWrite))
    {
        fs.Read(ByteRead, 0, 300);
    }
    MemoryStream memStream = new MemoryStream(ByteRead);
    richTextBox1.LoadFile(memStream, RichTextBoxStreamType.PlainText);
}

void FillRTB(string filepath)
{
    byte[] ByteRead = new byte[300];
    FileStream fs = new FileStream(filepath, FileMode.Open, FileAccess.ReadWrite);

    fs.Read(ByteRead, 0, 300);

    MemoryStream memStream = new MemoryStream(ByteRead);
    rtbPage.LoadFile(fs, RichTextBoxStreamType.PlainText);
}

void FillRTB(string filepath, long Characters);

While (true) { Human.isLearnable = true; }

Pedram Behroozi wrote:

The name 'fs' does not exist in the current context

Pedram Behroozi wrote:

But what if I have a dynamic length? Ex:

void FillRTB(string filepath, long length); 

While (true) { Human.isLearnable = true; }

Pedram Behroozi wrote:

Can I dynamically get the length?

void FillRTB(string filepath, long length);

While (true) { Human.isLearnable = true; }