Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
A

antonio_dsanchez

@antonio_dsanchez
About
Posts
6
Topics
4
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • dynamic question in php and mysql
    A antonio_dsanchez

    Hello I'm doing a survey web where I keep my questions in a database and then I call them when the user selects which survey will answer and my questions are shown. This is my code where I show my questions and add raddiobuttons and textareas.

    and here I want to save the answers

    I ju

    SI

    NO

    Escribe aquí tus Hallazgos

    Escribe aquí tus Acciones Correctivas

    Linux, Apache, MySQL, PHP php database mysql question

  • clean form1 with button the other form2 calling a class
    A antonio_dsanchez

    in my form1 I have a texbox and I want to clean from my button clean in my form 2 whit my class clean I think is the is the second opcion

    C# csharp

  • clean form1 with button the other form2 calling a class
    A antonio_dsanchez

    hi all I developing a program in c#, I have two form. in the form1 I have a texbox, label and combobox, and in the second form I have a button the name cleaning and the class clean.I need is calling me class clean with me button clean and cleaning the form 1

    C# csharp

  • I have a search button and datagrid in c# and SQL
    A antonio_dsanchez

    the Question is, as can I load the data back my search datagrid

    C# database csharp security help

  • I have a search button and datagrid in c# and SQL
    A antonio_dsanchez

    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

    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)  
                {
    
    C# database csharp security help

  • not save my the data
    A antonio_dsanchez

    I'm working on dataGrid Save content based on SQL Server data, C # smart devices and I have all the code I do not make mistake but not save data

    /////////////////inicio guardar
    //cadena de conexion
    string partDir = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
    string partBD = System.IO.Path.Combine(partDir, "embarque.sdf");
    string connectionstring = string.Format(@"DataSource={0}; Password ='root'", partBD);

    try
    {
    using (SqlCeConnection con = new SqlCeConnection(connectionstring))
    {
    string ConsultaSQL = "INSERT INTO ENVIO VALUES(@RAID, @NPARTE, @CANTIDAD, @VENTANA, @LIDER, @FECHA)";

    	foreach (DataRow row in dt.Rows)
    	{
            SqlCeCommand cmd = new SqlCeCommand(ConsultaSQL, con);
    		
    		cmd.Parameters.Clear();
    
    		cmd.Parameters.AddWithValue("@RAID", Convert.ToString(row\["Raid"\].ToString()));
    		cmd.Parameters.AddWithValue("@NPARTE", Convert.ToString(row\["Nparte"\].ToString()));
    		cmd.Parameters.AddWithValue("@CANTIDAD", Convert.ToString(row\["Cantidad"\].ToString()));
    		cmd.Parameters.AddWithValue("@VENTANA", Convert.ToString(row\["Ventana"\].ToString()));
    		cmd.Parameters.AddWithValue("@LIDER", Convert.ToString(row\["Lider"\].ToString()));
    		cmd.Parameters.AddWithValue("@FECHA", Convert.ToString(row\["Fecha"\].ToString()));
    		
    		con.Open();
    
    		cmd.ExecuteNonQuery();
            
            con.Close();
       }
      
    }	
    
    MessageBox.Show("Datos Agregados");
    

    }
    catch (Exception ex)
    {
    MessageBox.Show(ex.Message);
    }
    ///////////////fin guardado

    C#
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups