Windows Form Application example

[happyteddybearwithnobeard]

Hi guys,

 

Does any of you have an example of Windows Form Application with fillable form that works?

[AlTech]

1 minute ago, happyteddybearwithnobeard said:

Hi guys,

 

Does any of you have an example of Windows Form Application with fillable form that works?

What do you mean "fillable form"?

[happyteddybearwithnobeard]

2 minutes ago, AluminiumTech said:

What do you mean "fillable form"?

Something like that:

With textboxes values saving in database table.

[AlTech]

Just now, happyteddybearwithnobeard said:

snip

It wouldn't be hard to set up and create a Windows Forms. The part involving saving to a database might be difficult.

[happyteddybearwithnobeard]

1 minute ago, AluminiumTech said:

It wouldn't be hard to set up and create a Windows Forms. The part involving saving to a database might be difficult.

I am a newbie in programming world you know, I just need an example of it and then I can figure it out myself. I tried it, but I failed miserably.

[vorticalbox]

8 minutes ago, AluminiumTech said:

What do you mean "fillable form"?

You don't have to save anything to a database you could use json or XML to store your data. 

[happyteddybearwithnobeard]

1 minute ago, vorticalbox said:

You don't have to save anything to a database you could use json or XML to store your data. 

Yeah, I could, it's true. I just call it database, my bad. But I want it to be a Windows application, I tried to make it, but I failed and now I don't know how to get back on track.

[MrDrWho13]

Do you want it to be a form application? It would be much simpler to use google docs to create a form which automatically writes to a spreadsheet.

[happyteddybearwithnobeard]

1 minute ago, MrDrWho13 said:

Do you want it to be a form application? It would be much simpler to use google docs to create a form which automatically writes to a spreadsheet.

Yeah, I want it to be a form application, but executable as windows application. Could I maybe upload what I have now? You guys would laugh at what I made, but I tried ;/

[LUUD18]

Why don't you search on youtube? There is plenty of tutorial video's. Also use visual studio. It is just drag n drop.

[happyteddybearwithnobeard]

6 minutes ago, LUUD18 said:

Why don't you search on youtube? There is plenty of tutorial video's. Also use visual studio. It is just drag n drop.

That's what I am doing, I am using visual studio, but now the whole design of application form is gone.

[happyteddybearwithnobeard]

Here is what I have now. Would you kindly take a look and tell me what's wrong with that?

 

https://ufile.io/18980

[LUUD18]

Can you put it on pastebin or something? I am not gonna download some random rar file from a stranger.

[happyteddybearwithnobeard]

3 hours ago, LUUD18 said:

Can you put it on pastebin or something? I am not gonna download some random rar file from a stranger.

https://pastebin.com/RfJVzFYA

[madknight3]

On 3/28/2017 at 3:53 AM, happyteddybearwithnobeard said:

Here is what I have now. Would you kindly take a look and tell me what's wrong with that?

 

https://ufile.io/18980

First, in Form1 you're missing the constructor with the call to InitializeComponent(). That's why when you run your application nothing is being displayed on the forms.

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }
  
    // rest of code
}

Second, don't modify the designer file (Form1.Designer.cs) unless you need to. It's meant to hold the code that's generated from Visual Studio designer. Instead, you use the code behind file (Form1.cs - ie: the file where you put your SQL code).

 

I noticed that all your event methods were in the designer file instead of your code file. I don't know if it was something you did but I manually went through and moved the events to the code file.

 

Third, your call to Close() at the end of button4_click is closing your whole form. This may be what you want, but I just wanted to make sure.

protected void button4_Click(object sender, EventArgs e)
{
    // ...

        Close();  // This closes the windows form, not a connection or anything. In case that's what you intended.
    }
}

 

I think I've fixed up your project for you and added in some code for the sql method to hopefully get you on the right track. Here are the attached files.

VisualStudio2.zip

[happyteddybearwithnobeard]

8 hours ago, madknight3 said:

First, in Form1 you're missing the constructor with the call to InitializeComponent(). That's why when you run your application nothing is being displayed on the forms.

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }
  
    // rest of code
}

Second, don't modify the designer file (Form1.Designer.cs) unless you need to. It's meant to hold the code that's generated from Visual Studio designer. Instead, you use the code behind file (Form1.cs - ie: the file where you put your SQL code).

 

I noticed that all your event methods were in the designer file instead of your code file. I don't know if it was something you did but I manually went through and moved the events to the code file.

 

Third, your call to Close() at the end of button4_click is closing your whole form. This may be what you want, but I just wanted to make sure.

protected void button4_Click(object sender, EventArgs e)
{
    // ...

        Close();  // This closes the windows form, not a connection or anything. In case that's what you intended.
    }
}

 

I think I've fixed up your project for you and added in some code for the sql method to hopefully get you on the right track. Here are the attached files.

VisualStudio2.zip

Hello! Yes! Thanks for your help, before I saw your reply, I moved everything to visual studio 2010 and database to sql server 2008, used a YT tutorial and now everything works fine :))

[LUUD18]

Make yourself familiarized with MySQL.  Its the most used database.

[happyteddybearwithnobeard]

39 minutes ago, LUUD18 said:

Make yourself familiarized with MySQL.  Its the most used database.

Thanks for the advice and your help

[madknight3]

6 hours ago, LUUD18 said:

Make yourself familiarized with MySQL.  Its the most used database.

I wouldn't be surprised if Microsoft's Sql Server is more common when working within the .NET ecosystem though. It certainly doesn't hurt to learn to work with MySql, but I probably wouldn't use it over Sql Server in .NET unless I had a specific reason to do so.

 

Given @happyteddybearwithnobeard is already using Sql Server in their project, there's probably no need for them to switch. But it doesn't hurt to explore your options.

 

[happyteddybearwithnobeard]

On 30.03.2017 at 4:53 PM, madknight3 said:

I wouldn't be surprised if Microsoft's Sql Server is more common when working within the .NET ecosystem though. It certainly doesn't hurt to learn to work with MySql, but I probably wouldn't use it over Sql Server in .NET unless I had a specific reason to do so.

 

Given @happyteddybearwithnobeard is already using Sql Server in their project, there's probably no need for them to switch. But it doesn't hurt to explore your options.

 

Of course it doesn't hurt. Thank you for your response ???