Click here to Skip to main content
15,903,388 members
Home / Discussions / C#
   

C#

 
AnswerRe: C# Stopwatch - DateTime And Timer Tick - Is there a better way to run the Stopwatch Pin
OriginalGriff12-Oct-16 22:47
mveOriginalGriff12-Oct-16 22:47 
AnswerRe: C# Stopwatch - DateTime And Timer Tick - Is there a better way to run the Stopwatch Pin
Bernhard Hiller13-Oct-16 22:08
Bernhard Hiller13-Oct-16 22:08 
AnswerRe: C# Stopwatch - DateTime And Timer Tick - Is there a better way to run the Stopwatch Pin
omeecode15-Oct-16 8:56
omeecode15-Oct-16 8:56 
QuestionHTML.Kendo.ComboBox [Error: Object doesn't support property or method 'requestData'] Pin
Atul Shriram rane11-Oct-16 17:57
Atul Shriram rane11-Oct-16 17:57 
AnswerRe: HTML.Kendo.ComboBox [Error: Object doesn't support property or method 'requestData'] Pin
NotPolitcallyCorrect12-Oct-16 4:53
NotPolitcallyCorrect12-Oct-16 4:53 
GeneralRe: HTML.Kendo.ComboBox [Error: Object doesn't support property or method 'requestData'] Pin
Pete O'Hanlon12-Oct-16 4:59
mvePete O'Hanlon12-Oct-16 4:59 
GeneralRe: HTML.Kendo.ComboBox [Error: Object doesn't support property or method 'requestData'] Pin
NotPolitcallyCorrect12-Oct-16 5:47
NotPolitcallyCorrect12-Oct-16 5:47 
QuestionI have a search button and datagrid in c# and SQL Pin
antonio_dsanchez11-Oct-16 11:16
antonio_dsanchez11-Oct-16 11:16 
C#
hi all
 
I have a search button and datagrid in c#, I require perform a query in the database and load the data in me datagrid
 
it is my code


C#
conexion.ConnectionString = @"Data Source = SHINIL-PC040\SQLEXPRESS; Initial Catalog = produccion; Integrated Security = True";  
            if(TXTORDEN_PRODUCCION.Text == "" || TXTTURNO.Text == "" || TXTMAQUINAS.Text == "" || TXTHORAINICIO.Text == "" || TXTHORAFIN.Text == "")  
            {  
                MessageBox.Show("Te falta campo");  
            }  
            else  
            {  
                 
                if (checkBox1.Checked == true)  
                {  
                    try  
                    {  
  
                        comando.Connection = conexion;  
                        conexion.Open();  
                        string SqlAction = "select orden, turno, operador, horainicio, horafin, articulo, totalpiezasok, totalcajas, piezascondefecto, maquina from conteo2 where CONVERT(varchar(10), horafin, 108) >= @horainicio and CONVERT(varchar(10), horafin, 108)<= @horafin and orden = @orden  and turno = @turno and maquina = @maquina ";  
                        // "SELECT MOLDE, PROYECTO, ITEMPARTE, COLOR, SNP FROM PARTE WHERE ITEMPARTE = @ITEMPARTE";  
                        SqlCommand cmd = new SqlCommand(SqlAction, conexion);  
                        cmd.Parameters.AddWithValue("@orden", TXTORDEN_PRODUCCION.Text);  
                        cmd.Parameters.AddWithValue("@turno", TXTTURNO.Text);  
                        cmd.Parameters.AddWithValue("@maquina", TXTMAQUINAS.Text);  
                        cmd.Parameters.AddWithValue("@horainicio", TXTHORAINICIO.Text);  
                        cmd.Parameters.AddWithValue("@horafin", TXTHORAFIN.Text);  
  
                         
                        }  
  
                        conexion.Close();  
                    }  
                    
                    catch (Exception Ex)  
                    {  
                        MessageBox.Show(Ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);  
                    }  
                }  
                MessageBox.Show("selecciono ok produccion");  
                }  
                if (checkBox2.Checked == true)  
                {  
                    MessageBox.Show("selecciono paros");  
                }  
                if (checkBox1.Checked == false & checkBox2.Checked == false)  
                {  
                    MessageBox.Show("tiene que seleccionar un reporte");  
                }  
            }  

AnswerRe: I have a search button and datagrid in c# and SQL Pin
Dave Kreskowiak11-Oct-16 11:23
mveDave Kreskowiak11-Oct-16 11:23 
AnswerRe: I have a search button and datagrid in c# and SQL Pin
antonio_dsanchez11-Oct-16 11:31
antonio_dsanchez11-Oct-16 11:31 
GeneralRe: I have a search button and datagrid in c# and SQL Pin
Swinkaran11-Oct-16 16:00
professionalSwinkaran11-Oct-16 16:00 
GeneralRe: I have a search button and datagrid in c# and SQL Pin
Pete O'Hanlon11-Oct-16 20:35
mvePete O'Hanlon11-Oct-16 20:35 
QuestionClosest standard value Pin
Pavlex410-Oct-16 10:44
Pavlex410-Oct-16 10:44 
AnswerRe: Closest standard value Pin
Pete O'Hanlon10-Oct-16 19:31
mvePete O'Hanlon10-Oct-16 19:31 
GeneralRe: Closest standard value Pin
Pavlex410-Oct-16 23:38
Pavlex410-Oct-16 23:38 
Rant[REPOST] Closest standard value Pin
Richard Deeming11-Oct-16 2:14
mveRichard Deeming11-Oct-16 2:14 
AnswerRe: Closest standard value Pin
Ralf Meier11-Oct-16 21:02
mveRalf Meier11-Oct-16 21:02 
GeneralRe: Closest standard value Pin
Pavlex423-Oct-16 8:43
Pavlex423-Oct-16 8:43 
QuestionAndroid Studio: How can disable My applications in mobile when i run my application? Pin
Dr Kasa10-Oct-16 3:54
Dr Kasa10-Oct-16 3:54 
AnswerRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
Pete O'Hanlon10-Oct-16 4:11
mvePete O'Hanlon10-Oct-16 4:11 
AnswerRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
OriginalGriff10-Oct-16 4:11
mveOriginalGriff10-Oct-16 4:11 
GeneralRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
Eddy Vluggen10-Oct-16 4:38
professionalEddy Vluggen10-Oct-16 4:38 
GeneralRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
OriginalGriff10-Oct-16 4:42
mveOriginalGriff10-Oct-16 4:42 
GeneralRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
Eddy Vluggen10-Oct-16 5:02
professionalEddy Vluggen10-Oct-16 5:02 
GeneralRe: Android Studio: How can disable My applications in mobile when i run my application? Pin
OriginalGriff10-Oct-16 5:53
mveOriginalGriff10-Oct-16 5:53 

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.