C# Discussion Boards - CodeProject

Nader Elshehabi10-Jan-07 22:04

10-Jan-07 22:04

RichardContact-1 wrote:
s there a way of forcing the form to display correctly and run while the SP is called in the background.
Did you try to call the SP using another thread?

Regards

Re: Progress Form

Guffa10-Jan-07 22:09

Guffa

10-Jan-07 22:09

If you are calling the stored procedure from the main thread, it will be busy until the stored procedure completes. As all updates are handled in the main thread, your form will not be updated while the stored procedure is running.

Start a new thread that runs the stored procedure, that way the main thread can update the form while the stored procedure runs.

---
Year happy = new Year(2007);

problem about HttpWebRequest and NetworkCredential

TuanNH8510-Jan-07 21:36

TuanNH85

10-Jan-07 21:36

Enter the site www.ou.edu.vn/diemthi. There r 2 textbox. Once i add 10360127 for both of username & password and click submit, the score page will occur.
I used the HttpWebRequest and NetworkCredential to send username & password with the request. But all i can recieve is the blank page with the banner only instead of the full score page Confused | :confused:

.

Can u tell me the problem? I used the following URI in HttpWebRequest Create() method: "http://www.ou.edu.vn/EduNet/modules.php?name=diemthi&act=xl_xemdiemthi" Is it correct? If not, what URI should i use Confused | :confused:

Free HTML Editor for ASP.net

adnanrafiq10-Jan-07 21:23

adnanrafiq

10-Jan-07 21:23

Hi all,

Is there any free html editor available that can be used in ASP.Net, i tried on google,yahoo, i found FCK editor but its not working good.

Many Thanks adnan

Re: Free HTML Editor for ASP.net

Guffa10-Jan-07 21:43

Guffa

10-Jan-07 21:43

Visual Web Developer 2005 Express Edition[^]

---
Year happy = new Year(2007);

Re: Free HTML Editor for ASP.net

adnanrafiq11-Jan-07 1:31

adnanrafiq

11-Jan-07 1:31

Hi,
Thanks for repely.

I dont meant that, i want to get HTML Editor to use ASP.Net web forms.
Many Thanks,
adnan

Re: Free HTML Editor for ASP.net

ed^nrgc11-Jan-07 2:25

ed^nrgc

11-Jan-07 2:25

FCK works fine. What problems are you having?

Re: Free HTML Editor for ASP.net

adnanrafiq11-Jan-07 8:50

adnanrafiq

11-Jan-07 8:50

Thanks, when i get value of the fckgrid, it return me html, but when i am trying to store it in database (MS Access 203), it only stores first html tag, like

page name

, the rest one disapperar some where, i also did debuging the function which is inserting html gets full html, but i dont know y its not inserting .
And one more thing plz, how to deply it on server.
Many Thanks,
adnan

Re: Free HTML Editor for ASP.net

ed^nrgc11-Jan-07 9:01

ed^nrgc

11-Jan-07 9:01

So, it works fine, and there's a problem in your code.

Process' handles

Seishin#10-Jan-07 21:22

Seishin#

10-Jan-07 21:22

there's the Process class and it has this HandleCount property.
is there way to get these handles?
I'm trying to write app like Process Explorer but with logging capabilities.

life is study!!!

Re: Process' handles

Nader Elshehabi10-Jan-07 22:01

Nader Elshehabi

10-Jan-07 22:01

Quoted from MSDN:
Handles provide a way for a process to refer to objects. A process can obtain handles to files, resources, message queues, and many other operating system objects. The operating system reclaims the memory associated with the process only when the handle count is zero.

These handles -as you can see-, are to resources, while the process itself has only one handle. You can get that single handle using the Process.Handle property. Other handles used by the resources are quite difficult to obtain.

Regards

Re: Process' handles

Seishin#10-Jan-07 22:12

Seishin#

10-Jan-07 22:12

"Other handles used by the resources are quite difficult to obtain"

well I found it quite difficult and thats why I'm writing here Big Grin | :-D

life is study!!!

Re: Process' handles

Seishin#11-Jan-07 0:58

Seishin#

11-Jan-07 0:58

k. let's say I got these handles..
how to get registry keys and ports from them??

life is study!!!

Edit numeric value in DataGridView column

Salogus10-Jan-07 21:12

Salogus

10-Jan-07 21:12

How to make DataGridView column to input only numeric data, with filtering literals?

Re: Edit numeric value in DataGridView column

Nader Elshehabi10-Jan-07 21:58

Nader Elshehabi

10-Jan-07 21:58

You can handle the KeyDown event and check if the character was a numeric or not. If not you should set e.SuppressKeyPress to true.

Regards

free graph/chart libraries

blackjack215010-Jan-07 19:32

blackjack2150

10-Jan-07 19:32

Hi.

Can someone tell me where/if I can find freeware graph/chart controls/libraries for .NET? I'm not interested in trial or evaluation versions of comercial libraries, but something basic and free. All I need is draw a simple, 2D bar chart on my C# Windows App.

Thanks.

Re: free graph/chart libraries

stancrm10-Jan-07 20:06

stancrm

10-Jan-07 20:06

There are lots of chart control in codeproject. Try to search it.

Re: free graph/chart libraries

Tamimi - Code10-Jan-07 20:07

Tamimi - Code

10-Jan-07 20:07

try this:
http://www.carlosag.net/Tools/WebChart/[^]

samples:
http://www.carlosag.net/Tools/WebChart/samples.aspx[^]

When you get mad...THINK twice that the only advice
Tamimi - Code

How do I assign a handler to a command button?

JoeRip10-Jan-07 19:15

JoeRip

10-Jan-07 19:15

Let's say I have a cmdButton sitting on my form. It's a generic "Cancel" button, and I want it to perform different operations depending on which of my methods showed it.

Given that, how do I assign a handler to the Click event for the button?

I'm sure this is much more simple than I'm making it, but I've tried eleventy-seven different syntaxes, and I'm not getting it.

Thanks!

Re: How do I assign a handler to a command button?

JoeRip10-Jan-07 19:20

JoeRip

10-Jan-07 19:20

Well, Joe, this is how it appears in the Designer.cs code, if you allow VS to do it:

this.tsCmdBtn.Click += new System.EventHandler(this.tsCmdBtn_Click);

Does this help?

Re: How do I assign a handler to a command button?

JoeRip10-Jan-07 19:20

JoeRip

10-Jan-07 19:20

It sure does. Thanks, Batman!

Re: How do I assign a handler to a command button?

CPallini10-Jan-07 21:22

CPallini

10-Jan-07 21:22

Hey Joe, what about Psychoanalysis?

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Insert a Record

mwith10-Jan-07 18:54

mwith

10-Jan-07 18:54

Hi all,

I am a beginner for C# and trying to study about ADO.NET. I wrote a simple application with a datagridview and three text boxes. I can populate data from table. Now I am trying to insert a record to a table. When I execute the following code, it is updating that table only a blank line. please can you help me to solve this problem? Or any other ways to update a record better than this?

using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.SqlClient;<br />
<br />
<br />
namespace FundOrg<br />
{<br />
    public partial class frmBankDetails : Form<br />
    {<br />
<br />
        private DataSet dsBank;<br />
        private SqlDataAdapter da = new SqlDataAdapter();<br />
        SqlConnection myConnection = new SqlConnection();<br />
<br />
<br />
        private static frmBankDetails frmB = null;<br />
        public static frmBankDetails Instance()<br />
        {<br />
            if (frmB == null)<br />
            {<br />
                frmB = new frmBankDetails();<br />
            }<br />
            return frmB;<br />
<br />
        }<br />
<br />
        public frmBankDetails()<br />
        {<br />
            InitializeComponent();<br />
<br />
<br />
            <br />
<br />
            myConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["dbcon"];<br />
<br />
            try<br />
            {<br />
                myConnection.Open();<br />
            }<br />
            catch (SqlException E)<br />
            {<br />
                MessageBox.Show("Connection Erro : " + E.Message);<br />
            }<br />
<br />
            <br />
            SqlCommand cmd = new SqlCommand("SELECT * FROM Bank_Details", myConnection);<br />
           // BindingSource bsBank = new BindingSource();<br />
<br />
<br />
            da.SelectCommand = cmd;<br />
            dsBank=new DataSet();<br />
            da.Fill(dsBank,"Bank_Details");<br />
<br />
            <br />
            dgBankCode.DataSource = dsBank;<br />
            dgBankCode.DataMember = "Bank_Details";<br />
<br />
<br />
            dgBankCode.RowHeadersVisible = false;<br />
<br />
            dgBankCode.Columns[0].HeaderText = "Bank Code";<br />
            dgBankCode.Columns[1].Visible = false;<br />
            dgBankCode.Columns[2].Visible = false;<br />
<br />
            txtBankCode.DataBindings.Add("Text", dsBank, "Bank_Details.Bank_Code");<br />
            txtBankName.DataBindings.Add("Text", dsBank, "Bank_Details.Bank_Name");<br />
            txtAccNo.DataBindings.Add("Text", dsBank, "Bank_Details.Acc_No");<br />
            dgBankCode.ReadOnly = true;<br />
        }<br />
<br />
<br />
        public void SaveEntry()<br />
        {<br />
<br />
            <br />
            SqlCommand cmdUpdate = new SqlCommand();<br />
            cmdUpdate.CommandType = CommandType.Text;<br />
            cmdUpdate.CommandText = "INSERT INTO Bank_Details(Bank_Code,Bank_Name,Acc_No) VALUES('"+ txtBankCode.Text +"','"+ txtBankName.Text +"','"+ txtAccNo.Text +"')";<br />
            cmdUpdate.Connection = myConnection;<br />
            <br />
            cmdUpdate.ExecuteNonQuery();<br />
<br />
<br />
<br />
        }<br />
        <br />
       <br />
        <br />
<br />
      <br />
<br />
<br />
    }<br />
}<br />

And can anybody explain me, what are the good/bad coding practices with this?

Thanking you

Re: Insert a Record [modified]

~~_{lost in transition}~~ 11-Jan-07 5:54

~~_{lost in transition}~~

11-Jan-07 5:54

MySQLString = "INSERT INTO Bank_Details(Bank_Code,Bank_Name,Acc_No)" +
              "VALUES('"+ txtBankCode.Text +"','"+ txtBankName.Text +"','"+ txtAccNo.Text +"')";

SqlConnection MySqlConn = new SqlConnection(MyConnectionString);
SqlCommand    MySqlComm = new SqlCommand(MySQLString, MySqlConn);
// MySqlConn and MySqlComm refer to variable and not the DBMS
MySqlComm.Connection.Open();
MySqlComm.ExecuteNonQuery();
MySqlComm.Connection.Close();

mwith wrote:
And can anybody explain me, what are the good/bad coding practices with this?

When working with DB try your best to keep it simple.

Also, check the SQL statement if Bank_Code and Acc_No are 'int' data types then you need to convert the textboxes from string to int. i.e. Convert.ToInt32(txtBankCode.Text)
Good Luck,
Jason

-- modified at 12:01 Thursday 11th January, 2007

Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software.
[^]

serialize treeview [modified]

Maddie from Dartford10-Jan-07 18:23

Maddie from Dartford

10-Jan-07 18:23

Hello,

I am using the TreeView control in form application of C#.

I am having my own classes which are derived from TreeNode and i am adding the object of these classes to treeview as a node.

I want to serialize and deserialize the TreeView and i am doing it with BinaryFormatter object.

It get serialized properly but when i am loading it back it flashes an error "The constructor to deserialize an object of type 'MyTreeNode' was not found".

What else i need to add to get this done.

Thanks in advance

Gajesh
Pune(India)

-- modified at 2:17 Thursday 11th January, 2007

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.