Hi.
I am getting data from accessdb with datareader. I want to all rows(datas) to send to client, but it doesnt work. All codes below. How can i do that?
--------------------------------------------------------------------
public void Form1_Load(object sender, EventArgs e)
{
CheckForIllegalCrossThreadCalls = false;
Thread thread_dinleyici = new Thread(new ThreadStart(dinle_gonder));
thread_dinleyici.Start();
sunucu_bag.Open();
}
public void dinle_gonder()
{
TcpListener dinleyici = new TcpListener(30000);
while (true)
{
dinleyici.Start();
Socket istemcisoketi = dinleyici.AcceptSocket();
karsi_ip = ((IPEndPoint)istemcisoketi.RemoteEndPoint).Address.ToString();
if (!istemcisoketi.Connected)
{
label2.Text = "Server is no connected";
}
else
{
NetworkStream ag_akimi = new NetworkStream(istemcisoketi);
StreamReader akim_okuyucu = new StreamReader(ag_akimi);
string gelen_veri = akim_okuyucu.ReadLine();
textBox1.Text = gelen_veri;
// istemciden gelen veriyi db'ye yazdiriyoruz.
OleDbCommand cmd_veriyi_yaz = new OleDbCommand("INSERT INTO notlar
(iletiler,tarih) VALUES ('"+gelen_veri+"' ,
'"+DateTime.Now+"')",sunucu_bag);
cmd_veriyi_yaz.ExecuteNonQuery();
// sending data to client
OleDbCommand cmd_veriyi_gonder = new OleDbCommand("SELECT iletiler,tarih FROM notlar", sunucu_bag);
OleDbDataReader rdr_gonderilecek;
rdr_gonderilecek = cmd_veriyi_gonder.ExecuteReader();
while (rdr_gonderilecek.Read())
{
Socket soket2 = dinleyici.AcceptSocket();
NetworkStream stream2 = new NetworkStream(soket2);
TcpClient istemci = new TcpClient(karsi_ip, 30001);
strieam2 = istemci.GetStream();
StreamWriter akim_yazici = new StreamWriter(stream2);
akim_yazici.WriteLine(rdr_gonderilecek["iletiler"].ToString(),rdr_gonderilecek["tarih"].ToString());
akim_yazici.Flush();
}
}
}
Loading
Sam HobbsPosted Dec 30, 2009, 12:10 AM
Sam HobbsPosted Dec 29, 2009, 11:47 PM
yokzuPosted Dec 29, 2009, 2:20 AM
Firstly thanks for your reply. Its not about crossthread, coz when I delete these label and textbox,I can not get any data too. Actually I can not send 2 or 3 rows? Is there any example that sending a dataset, 2,3 datarow or datareader's rows?
I just want to send a table to client?
Sam HobbsPosted Dec 28, 2009, 11:30 PM