Message not getting displayed.

Ramco Ramco

I have below code but it is not going in Load function

using Sap.Data.Hana;

namespace Atulaya
{
    public partial class Form1 : Form
    {
        HanaConnection conn;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            conn = new HanaConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Hana"].ConnectionString);
            conn.Open();
            Console.WriteLine("Connected");
        }

    }
}

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jayraj Chhaya1y ago
Hi Ramco,

The issue you're encountering may stem from the fact that the Form1_Load event is not properly wired up to the form's Load event. To resolve this, ensure that the Form1_Load method is correctly associated with the Load event of the form. You can do this in the designer or programmatically in the constructor
```
public Form1()
{
    InitializeComponent();
    this.Load += new EventHandler(Form1_Load);
}
```
Additionally, ensure that your connection string in the configuration file is correctly set up and that the Sap.Data.Hana library is properly referenced in your project. If the connection fails, the message "Connected" will not be displayed.

Lastly, consider using MessageBox.Show("Connected"); instead of Console.WriteLine to display the message in a Windows Forms application, as Console.WriteLine may not show output in the UI context.
```
private void Form1_Load(object sender, EventArgs e)
{
    conn = new HanaConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Hana"].ConnectionString);
    conn.Open();
    MessageBox.Show("Connected");
}
```
Amit Mohanty1y ago
Make sure that the Form1_Load event is assigned to the form's Load event. This can be either in the designer or manually in your code. Check that, in your designer file (Form1.Designer.cs), the Load event is hooked up like this:
```
this.Load += new System.EventHandler(this.Form1_Load);
```