TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
yokzu
NA
306
0
Program works on Visual Studio but not work as ".exe"
Nov 10 2010 7:07 AM
Hello,
Im just working on a program that changes some row's values in an excel file. Program has just about 60 rows. When i debug my program at Visual Studio (pressing F5), its working properly and made some changes at excel file. Its ok. But when I only click my project's "excel.exe" file, it doesnt work properly. Its getting no error but it didnt any changes at this excel file. And i didnt move this "excel.exe" file to anywhere, i started it in projects folder.(/bin/debug)
Its really weird and i didnt know what is the problem?
My all codes below;
-------------------------
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 System.Data.OleDb;
namespace badi
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}I
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dosya.xlsx;Extended Properties=Excel 12.0 Xml;");
baglanti.Open();
string query = "SELECT [Ci Adi],[Baslangic Tarihi],[Bitis Tarihi],[Sira],[Kategori] FROM [Sheet6$A:L]";
OleDbDataReader rdr;
OleDbCommand komut = new OleDbCommand(query, baglanti);
rdr = komut.ExecuteReader();
while (rdr.Read())
{
DateTime tarih1_baslangic = DateTime.Parse(rdr["Baslangic Tarihi"].ToString());
DateTime tarih1_bitis = DateTime.Parse(rdr["Bitis Tarihi"].ToString());
string ci_adi = rdr["Ci Adi"].ToString();
string query_ci = "SELECT [Ci Adi],[Baslangic Tarihi],[Bitis Tarihi],[Sira],[Kategori] FROM[Sheet6$A:L] WHERE [Ci Adi]='" + ci_adi + "'";
OleDbDataReader rdr_ci;
OleDbCommand komut_ci = new OleDbCommand(query_ci, baglanti);
rdr_ci = komut_ci.ExecuteReader();
while (rdr_ci.Read())
{
string birincidongu = rdr_ci["Sira"].ToString();
string ikincidongu = rdr["Sira"].ToString();
DateTime tarih2_baslangic = DateTime.Parse(rdr_ci["Baslangic Tarihi"].ToString());
DateTime tarih2_bitis = DateTime.Parse(rdr_ci["Bitis Tarihi"].ToString());
if (int.Parse(rdr_ci["Sira"].ToString()) != int.Parse(rdr["Sira"].ToString()))
{
if (int.Parse(rdr_ci["Sira"].ToString()) > int.Parse(rdr["Sira"].ToString()))
{
if (tarih1_baslangic > tarih2_baslangic && tarih2_bitis > tarih1_baslangic)
{
OleDbCommand komut_ustune_yaz = new OleDbCommand("UPDATE [Sheet6$] SET [Kategori]='OK' WHERE [Sira]='" + rdr["Sira"] + "' ", baglanti);
komut_ustune_yaz.ExecuteNonQuery();
}
else if (tarih2_baslangic >= tarih1_baslangic && tarih2_baslangic <= tarih1_bitis)
{
if (rdr["Kategori"].ToString() == "OK")
{
}
else
{
OleDbCommand komut_ustune_yaz = new OleDbCommand("UPDATE [Sheet6$] SET [Kategori]='OK' WHERE [Sira]='" + rdr_ci["Sira"] + "' ", baglanti);
komut_ustune_yaz.ExecuteNonQuery();
}
}
}
}
}
rdr_ci.Close();
}
}
-----------
Reply
Answers (
2
)
Mathematicla library
How to share data with background worker c#