|
if your connection string is like this
add name="conn1" connectionString="string1"
ur access will be like this.
string conn = ConfigurationManager.ConnectionStrings[conn1].ConnectionString;
|
|
|
|
|
thanks !
but it gives an error "ConfigurationManager" does not exist into current context
|
|
|
|
|
add a reference in ur class file.
using System.Configuration;
|
|
|
|
|
It's said that "Don't have par(my table)" and alway have error with sql_cmd.ExecuteNonQuery(); coz my file have # it can't read #
<pre>
private SQLiteConnection sql_con;
private SQLiteCommand sql_cmd;
private SQLiteDataAdapter DB;
private DataSet DS = new DataSet();
private DataTable DT = new DataTable();
private void SetConnection()
{
sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=False;Compress=True;");
// sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=True;Compress=True;"); if I want to create new database
}
private void ExecuteQuery(string txtQuery)
{
<big> sql_con.Open();</big>
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
<big> sql_cmd.ExecuteNonQuery(); </big>
sql_con.Close();
}
</pre>
<pre>
private void LoadData()
{
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select * from par";
DB = new SQLiteDataAdapter(CommandText, sql_con);//นำข้อมูลออกมา
DS.Reset();
DB.Fill(DS);//นาม ข้อมูลปายส่ายนาย ดาต้าเซด
DT = DS.Tables[0];
dataGridView1.DataSource = DT;
sql_con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
SetConnection();
LoadData();
}
</pre>
It has error on the BIG 
NO MORE TEAR
|
|
|
|
|
indicates you have a problem with your connection string. Probably an invalid path for pare.db Try putting in the fully qualified path as this will be looking in the folder where the exe is created (debug).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I've already tried
It's still "no such table: par"
And what the problem with the # in sql_cmd.ExecuteNonQuery();
|
|
|
|
|
Hi
I have visual studio 2005 installed in my system and Windows Vista home OS. It is working fine but i cannot debug in the IDE though i gave the breakpoint and run the program in start debugging mode.
Your suggestions are highly valuable.
Thanks
Mahe
|
|
|
|
|
delete the *.pdb file in your debug folder,try again.
|
|
|
|
|
sorry i forgot to post, It is a web application..
|
|
|
|
|
Are you running the project in debug mode or release mode??
"Legacy code" often differs from its suggested alternative by actually working and scaling.
—Bjarne Stroustrup
|
|
|
|
|
And you expect a reply to this question 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
sorry i forgot to post, It is a web application.
|
|
|
|
|
Hi friends,
I went through google and MSDN in search for code samples that can be used to change the icon of an .exe file. But, I found softwares rather codes that claim to change the icon of .exe files! However, they are sharewares and can only display the desired icon on machine's where the software in particular is installed!
I went through the properties and all the tutorials on C# but did not find the a way to change the icon of an .exe programatically! Please help me out.
Hope to hear from you guys soon,
Rajdeep.NET
|
|
|
|
|
Is this your exe or someone elses exe?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Ok so have you set the icon in the projects Properties > Application > Default Icon
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how can i change icon of .exe file ?
.exe file isnt my project.
can i swap icon of an .exe file with another .exe ??
thanks
|
|
|
|
|
BILLY_Mgs wrote: .exe file isnt my project.
What gives you the right to change someone elses application. I write software, I help people learn to develop applications, I do not help people bugger up someone elses application.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
 Mycroft Holmes  I know you cant do this , plz do not spam ok ?
Guys there isnt any helpful code to extract icon from .exe file and change icon of .exe file with this icon?
Thanks
|
|
|
|
|
Hi,
I am using a Syncfusion virtual grid in my project
this grid has 3 columns.. I wanted to increase there size by dragging it's corner through mouse pointer .. How can i do that .. since i have seen this can be done only on those grids on which moving the mouse it will display that resize pointer
|
|
|
|
|
It will be better to try the support/forum of Syncfusion virtual grid.
जय हिंद
|
|
|
|
|
I already did.. but did any body know that how can i do this .. even on general grid what is the property to enable this?
|
|
|
|
|
Hello All,
Will you please tell me how can i import Excal file into Mysql usnig .NET2005. i dont know about it. so if you have any example of it then please tell me its urgent.
thanks in advance
Naim Khan
|
|
|
|
|
You should open and read Excel File then Insert it's value in Mysql database.
Add refrences Microsoft.office.Introp.excel to read excel file.and Use SQL Connection and Query to save it on Mysql.
If you can think then I Can.
|
|
|
|
|
ok sir . i think that would be good option please do this. and how me demo how can i implemet in my project.
thanks in advance
naim khan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
