|
Hello again, according the lessons you gave me, I wrote a program that shows content of a table in a datagridview.
Now I want to sort the content of the table based a field(ASC or DEC) and show the result in that datagridview.
Database name= WirdDb, tablename= tbl2, fields: No, Code, Street, Alley, Status, Date and Time.
I want to sort the content of tbl2 according field "Street" ascendingly.
Would you please help me.
OleDbDataAdapter adapter2 = new OleDbDataAdapter();
OleDbCommand command2 = new OleDbCommand("SELECT * from tbl2"+tbl2.Street, conn);
adapter2.SelectCommand = command2;
OleDbCommandBuilder cb2 = new OleDbCommandBuilder(adapter2);
DataSet ds2 = new DataSet();
adapter2.Fill(ds2, "tbl2");
DataTable dt2 = ds2.Tables[0];
DataGridView dgv2 = new DataGridView();
dgv2.DataSource = dt2;
this.Controls.Add(dgv2);
Sourie
|
|
|
|
|
hi all,
I m a student, currently having problem on how i can start programming.
my project require the use of an measurement device and it measurement are taken from the usb port and save in notepad .txt format, i am suppose to come out with an real time graphical display of the measurement, but i have no idea how i could start on it as i am new in programming. any help or suggest would be greater appreciated. Thanks
|
|
|
|
|
You should have a library to communicate with your measurement instrument. Probably you can download it from the manufacturers web-site.
How to display the measurements on a graphical display? ZedGraph : http://www.codeproject.com/KB/graphics/zedgraph.aspx[^]
Don't bother with other plotting libraries, ZedGraph is the best.
Good luck
zafer
|
|
|
|
|
How can I set the tooltip location?
Right now I am setting a big enough tooltip size and then drawing it at desired location. Following is the code I have written.
private void Form1_Load(object sender, EventArgs e) {
ToolTip oTooltip = new ToolTip();
oTooltip.OwnerDraw = true;
oTooltip.Draw += new DrawToolTipEventHandler(oTooltip_Draw);
oTooltip.Popup += new PopupEventHandler(oTooltip_Popup);
oTooltip.SetToolTip(this.button1, "text");
}
void oTooltip_Popup(object sender, PopupEventArgs e) {
e.ToolTipSize = this.Size;
}
void oTooltip_Draw(object sender, DrawToolTipEventArgs e) {
Graphics oGx = e.Graphics;
oGx.Clear(this.BackColor);
oGx.DrawEllipse(Pens.Black, 20, 20, 20, 20);
oGx.DrawString("text",this.button1.Font,Brushes.Blue,20,20);
}
Somehow I am not too confident about this approach. Is there a better way to achieve this?
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
Use ToolTip and try these :
private void button_MouseLeave(object sender, EventArgs e)
{
toolTip1.Hide(this.button);
}
private void button_MouseMove(object sender, MouseEventArgs e)
{
toolTip1.Show("some text", this.button, e.X + 10, e.Y + 10);
}
|
|
|
|
|
Wasn't aware that .Show for a tooltip accepted a location. Thanks!
- Matthew (@CSharpByDesign)
|
|
|
|
|
Hello,
I've made a chat program, inspired by the WPF/WCF chat tutorial here.
The program is complete, and works well, but when I give it to other friends it doesn't work. I'm hoping that by explaining the simptoms someone could help me:
1) For 2 people, the program won't even load, it will show an error "0xc0000135". Maybe .Net framework 3.5 is not installed? Can I check that before loading?
2) For one guy, the program manages to catch the exception, saying "Object reference not set to an instance of an object", on the following lines of code:
TcpClient connection = new TcpClient();
ChatRoom chat = new ChatRoom(connection, boxName.Text);
chat.Show();
this.Close();
Meaning I didn't initialize "connection", but I just did!
3) For another guy, the program terminates also after these 3 lines, but without managing to catch the exception, saying the program had to close.
4) For someone else, the program first shows the ChatRoom window, and then shuts down. I've put everything I could in a try/catch block and it doesn't help.
What bothers me is that I get none of these problems.
Thanks!
|
|
|
|
|
either new TcpClient is failing or new ChatRoom(connection, boxName.Text) is failing
try this:
try
{
TcpClient connection = new TcpClient();
ChatRoom chat = new ChatRoom(connection,boxName.Text);
chat.Show();
this.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
and see what it says on your friends' machines
|
|
|
|
|
Thanks for the reply.
That's what I already did, and he's getting "Object reference not set to an instance of an object", I'm sure that it's failing right before the new Chatroom. I've also added try/catch blocks in the constructor, but it's not even getting there.
Why should it fail for all of my friends, but not for me or my laptop? It's not even connecting yet to the server, just initializing. I've made my friends install .Net framework 3.5 SP1 and it's no help.
It's really disappointing as I was hoping to continue learning WPF...
Thanks again 
|
|
|
|
|
Well I think the best way to diagnose the problem would be to take you and your code over to one of your freinds machines, put in a breakpoint at the start of these lines, and step through the code. You will then know exactly what crashes the program, and you can then inspect the object using the debugger.
Hopefully this would shed some more light on the problem, and then you could create a solution.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
Thanks for the reply.
As I was sure that it's the "new TCPClient" failing to initialize (though it wasn't kind enough to actually throw an exception), I changed TCPClient to Socket and configured it to work with TCP. Now it works for my friends.
But still I have one friend, who has .Net Framework 3.5, and when he tries to open my program, it crashes. No exception, no nothing. ("ChatClient.exe has stopped working").
This is frustrating, not only that with WPF I have to convince my friends to stop working on their PCs for 30 minutes so .Net framework would install, but my prefectly good program doesn't work on some PCs. So much for the .Net compability...
Thanks.
|
|
|
|
|
What is persistent object and transient object in OOP? Could you give an example in C#?
Best regards...
|
|
|
|
|
Persistent refers to an object's ability to transcend time or space. A persistent object stores/saves its state in a permanent storage system with out losing the information represented by the object.
A non-persistent object is said to be transient or ephemeral. By default objects are considered as non-persistent.
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Hi,
i am trying to read a word document which has images and tables with formats and trying to paste them in a string type control that supports tables/images/hyperlinks.
Can anyone help me with the sample code or any pointers to this is highly appreciated.
|
|
|
|
|
If that component doesn't support Word's format, your out of luck. You need a component that can interpret what Word puts on the clipboard.
|
|
|
|
|
|
Hi
i have this code to insert some values to database (via TableAdapter and storedProcedures) :
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
this.adapter.Insert(ref id, number, name);
but my program has crash and then dispay an error :
An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll
when i check my database, i see that my code insert about 7000 record in my table which all records is the same!
why is occred and how to solve it ?
thanks
|
|
|
|
|
Your code is somehow calling itself, or in other words, a method your calling is repeatedly calling itself. This is called recursion. The technique is useful in some situations, but you haven't provided any kind of "bailout" to tell the code to stop calling itself.
You haven't provided enough information or enough of a code snippet to be of much help in solving the problem.
|
|
|
|
|
Hi Dave
here is my full code :
DsMyDbTableAdapters.t1TableAdapter adapter = new DataAccessDesigner.DsMyDbTableAdapters.t1TableAdapter();
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
adapter.Insert(ref id, number, name);
The t1TableAdapter object has been generated with dataset designer (in viusal studio 2005).
Note : when i trace my code and execute each line via F11, it's works good and insert only 1 record.
modified on Saturday, September 13, 2008 12:27 PM
|
|
|
|
|
No, it's not. What method is this code in?? Because, like I said, this code is somehow calling itself, which makes the method that this code is in come into play.
|
|
|
|
|
no, it is just this :
private void button1_Click(object sender, EventArgs e)
{
DsMyDbTableAdapters.t1TableAdapter adapter = new DataAccessDesigner.DsMyDbTableAdapters.t1TableAdapter();
int? id = 0;
int? number = int.Parse(this.textBox2.Text);
string name = this.textBox3.Text;
adapter.Insert(ref id, number, name);
this.button1_Click(null, null);
}
my tabletable has been generated via dataSet designer.
i think problem is in Adapter.Insert() method, do you believe this ?
|
|
|
|
|
hdv212 wrote: this.button1_Click(null, null);
It's that line. You are recursively calling button1_Click, and you're not bailing out (returning).
|
|
|
|
|
Ohhh!
thanks S. Senthil Kumar.
yes. it's works.
many thanks again.
|
|
|
|
|
I have two questions.
I have a file, this file is created when I save data from my program.
How to make icon for file?
How run my program when I double click this file?
Help me please!
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
