Diskuze: c# local messenger
Člen
Martin Svoboda:11.12.2015 12:27
nakoniec som začal písať od znova a došiel som tu
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace sql
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
using (MySqlConnection cnn = new MySqlConnection("Server=10.7.18.35;Database=OitDB;Uid=martin;Pwd=;"))
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT namepc FROM skupina where nazovskup= 'mojask' ", cnn);
DataSet ds = new DataSet();
da.Fill(ds, "skupina");
List<string> skName = new List<string>();
foreach (DataRow row in ds.Tables["skupina"].Rows)
{
skName.Add(row["namepc"].ToString());
string constring = "Server=10.7.18.35;Database=OitDB;Uid=martin;Pwd=;";
string Query = "INSERT INTO OitDB.skup(uzivatel)VALUES('" + skName + "');";
MySqlConnection conDatabase = new MySqlConnection(constring);
MySqlCommand cmdDatabase = new MySqlCommand(Query, conDatabase);
MySqlDataReader myReader;
try
{
conDatabase.Open();
myReader = cmdDatabase.ExecuteReader();
MessageBox.Show("Správa odoslaná!");
while (myReader.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
}pekne to zapisuje do sql 
len namiesto hodnoty (pc1,pc2,pc3,...) tam je
System.Collection.Generic.Lis
namepc už mám .ToString(); kde ešte môže byť zrada?
Martin Svoboda:12.12.2015 12:21
tak už to funguje
možno to niekomu pomôže
using (MySqlConnection cnn = new MySqlConnection("Server=;Database=OitDB;Uid=martin;Pwd=;"))
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT namepc FROM skupina where nazovskup= 'mojask' ", cnn);
DataSet ds = new DataSet();
da.Fill(ds, "skupina");
List<string> skName = new List<string>();
foreach (DataRow row in ds.Tables["skupina"].Rows)
{
skName.Add(row["namepc"].ToString());
string constring = "Server=;Database=OitDB;Uid=martin;Pwd=;";
var Query = "INSERT INTO OitDB.nrp(id,pc,ip,komu,datum,predmet,sprava,skupina)VALUES(@id,@pc,@ip,@komu,@cas,@predmet,@sprava,@name)";
MySqlConnection conDatabase = new MySqlConnection(constring);
MySqlCommand cmdDatabase = new MySqlCommand(Query, conDatabase);
cmdDatabase.Parameters.AddWithValue("@id", idtxt.Text);
cmdDatabase.Parameters.AddWithValue("@pc", pc);
cmdDatabase.Parameters.AddWithValue("@ip", label1.Text);
cmdDatabase.Parameters.AddWithValue("@komu", comboBox1.Text);
cmdDatabase.Parameters.AddWithValue("@cas", cas);
cmdDatabase.Parameters.AddWithValue("@predmet", textBox1.Text);
cmdDatabase.Parameters.AddWithValue("@sprava", pisat.Text);
cmdDatabase.Parameters.Add("@name", MySqlDbType.VarChar).Value = row["namepc"];
MySqlDataReader myReader;
try
{
conDatabase.Open();
myReader = cmdDatabase.ExecuteReader();
MessageBox.Show("Správa odoslaná!");
while (myReader.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Akceptované řešení
+5 Zkušeností
+5 Zkušeností
Zobrazeno 24 zpráv z 24.