Click here to Skip to main content
15,887,355 members
Home / Discussions / C#
   

C#

 
AnswerRe: SQL statement problem? Pin
Christian Graus14-Mar-09 11:45
protectorChristian Graus14-Mar-09 11:45 
Question[Message Deleted] Pin
jetspike14-Mar-09 10:49
jetspike14-Mar-09 10:49 
GeneralRe: Accessing datatable.rows on Form1 from From2 Pin
Luc Pattyn14-Mar-09 11:19
sitebuilderLuc Pattyn14-Mar-09 11:19 
AnswerRe: Accessing datatable.rows on Form1 from From2 Pin
Christian Graus14-Mar-09 11:51
protectorChristian Graus14-Mar-09 11:51 
QuestionImage Problem Pin
reza assar14-Mar-09 9:20
reza assar14-Mar-09 9:20 
AnswerRe: Image Problem Pin
Christian Graus14-Mar-09 9:31
protectorChristian Graus14-Mar-09 9:31 
AnswerRe: Image Problem Pin
Mohammad Dayyan14-Mar-09 11:25
Mohammad Dayyan14-Mar-09 11:25 
Questiondisplay image from SQL Server into Picture control Pin
Jassim Rahma14-Mar-09 7:31
Jassim Rahma14-Mar-09 7:31 
I want to know how can save an image into SQL Server and retrive it again into Picture control using SqlDataReader? here is my code to read from the database and now I need to read the image in addition to the data I ma reading:


private void get_staff_info()

{

this.Cursor = Cursors.WaitCursor;

sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=ssis_database;integrated security=true;");

sql_connection.Open();

sql_command = new SqlCommand("sp_get_staff_info_by_id", sql_connection);

sql_command.CommandType = CommandType.StoredProcedure;

sql_command.Parameters.Add("@staff_id", SqlDbType.Int).Value = staff_id;

sql_reader = sql_command.ExecuteReader();

if (!sql_reader.HasRows)

{

MessageBox.Show("staff not found!!", "error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

else

{

if (sql_reader.Read())

{

lblCPR.Text = sql_reader["staff_cpr"].ToString();

lblFullName.Text = sql_reader["staff_name"].ToString();

lblBirthday.Text = Convert.ToDateTime(sql_reader["staff_birthday"]).ToString("dd-MMM-yyyy");

TimeSpan age = DateTime.Now - Convert.ToDateTime(sql_reader["staff_birthday"]);

int years = age.Days / 365;

int months = (age.Days - (years * 365)) / 30;

string strAge = String.Format("{0}y", years);

lblBirthday.Text += " [" + strAge + "]";

lblGender.Text = sql_reader["gender_name"].ToString();

lblNationality.Text = sql_reader["country_name"].ToString();

lblFlat.Text = sql_reader["staff_address_flat"].ToString();

lblBuilding.Text = sql_reader["staff_address_building"].ToString();

lblRoad.Text = sql_reader["staff_address_road"].ToString();

lblBlock.Text = sql_reader["staff_address_block"].ToString();

lblTelephoneHome.Text = sql_reader["staff_telephone_home"].ToString();

lblTelephoneMobile.Text = sql_reader["staff_telephone_mobile"].ToString();

lblTelephoneMobile2.Text = sql_reader["staff_telephone_mobile2"].ToString();

lblEmailAddress.Text = sql_reader["staff_email_address"].ToString();

lblGrade.Text = sql_reader["grade_name"].ToString();

lblStep.Text = sql_reader["step_name"].ToString();

lblSalary.Text = Convert.ToDecimal(sql_reader["staff_salary"]).ToString("BD #,###,##0.000");

lblBank.Text = sql_reader["bank_name"].ToString();

lblBankAccount.Text = sql_reader["staff_bank_account"].ToString();


sql_reader.Close();

}

}

this.Cursor = Cursors.Default;

}

AnswerRe: display image from SQL Server into Picture control Pin
Luc Pattyn14-Mar-09 7:39
sitebuilderLuc Pattyn14-Mar-09 7:39 
AnswerRe: display image from SQL Server into Picture control Pin
Giorgi Dalakishvili14-Mar-09 7:43
mentorGiorgi Dalakishvili14-Mar-09 7:43 
AnswerRe: display image from SQL Server into Picture control Pin
Xmen Real 14-Mar-09 8:10
professional Xmen Real 14-Mar-09 8:10 
GeneralRe: display image from SQL Server into Picture control Pin
Jassim Rahma15-Mar-09 8:43
Jassim Rahma15-Mar-09 8:43 
GeneralRe: display image from SQL Server into Picture control Pin
Xmen Real 15-Mar-09 15:36
professional Xmen Real 15-Mar-09 15:36 
QuestionDynamic buttons in flowlayout panel Pin
Jon Henry14-Mar-09 7:08
Jon Henry14-Mar-09 7:08 
AnswerRe: Dynamic buttons in flowlayout panel Pin
N a v a n e e t h14-Mar-09 7:42
N a v a n e e t h14-Mar-09 7:42 
GeneralRe: Dynamic buttons in flowlayout panel Pin
Jon Henry14-Mar-09 7:59
Jon Henry14-Mar-09 7:59 
QuestionMS remote for Media Player Pin
electriac14-Mar-09 6:29
electriac14-Mar-09 6:29 
QuestionFormat date to system timezone Pin
Tony Pottier14-Mar-09 6:24
Tony Pottier14-Mar-09 6:24 
AnswerRe: Format date to system timezone Pin
Christian Graus14-Mar-09 8:15
protectorChristian Graus14-Mar-09 8:15 
QuestionPInvoke void * parameter Pin
Jason McPeak14-Mar-09 5:32
Jason McPeak14-Mar-09 5:32 
AnswerRe: PInvoke void * parameter Pin
Luc Pattyn14-Mar-09 5:56
sitebuilderLuc Pattyn14-Mar-09 5:56 
GeneralRe: PInvoke void * parameter Pin
Jason McPeak14-Mar-09 7:02
Jason McPeak14-Mar-09 7:02 
GeneralRe: PInvoke void * parameter Pin
Luc Pattyn14-Mar-09 7:30
sitebuilderLuc Pattyn14-Mar-09 7:30 
GeneralRe: PInvoke void * parameter Pin
Jason McPeak14-Mar-09 8:16
Jason McPeak14-Mar-09 8:16 
GeneralRe: PInvoke void * parameter Pin
Luc Pattyn14-Mar-09 9:10
sitebuilderLuc Pattyn14-Mar-09 9:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.