connect to database From WinAPP asp.ent

Question

0.00/5 (No votes)

See more:

please, any one tell me best way simply to connect between 1 table in database and display it simply on windows form application through grid view :( SQL DATABASE

Posted 16-May-12 4:26am

Haitham tarek

Updated 16-May-12 4:33am

v2

Add a Solution

Comments

Killzone DeathMan 16-May-12 10:31am

your database is 'sql server' or 'oracle' or 'MySQL' or what?

Haitham tarek 16-May-12 10:33am

sql :) sorry

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Killzone DeathMan · Accepted Answer · 2012-05-16T04:37:00

Solution 1

This is what you want: www.macoratti.net/08/11/c_sql_m1.htm[^]
Go down of the web site, there are images that help you...
Tell me if I helped you or not...

First add the libraries:

C#

using System.Data;
using System.Data.SqlClient;

Then:

<pre lang="c#">
namespace teste
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            string connection = "Your Conection String";
            SqlConnection conn = new SqlConnection();
            SqlDataAdapter adapt = new SqlDataAdapter("Query SQL", conn);
            DataSet ds = new System.Data.DataSet();
            adapt.Fill(ds);
            dataGridView1.DataSource = ds;
        }
    }
}

Here you get more: http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm[^]

Posted 16-May-12 4:37am

Killzone DeathMan

Updated 16-May-12 7:06am

v6

Comments

Haitham tarek 16-May-12 10:39am

this is not english :(
also i dont know how to get the connecttion string because i added the database inside
the asp.net and my app dont hv web config file :(

Killzone DeathMan 16-May-12 10:47am

Look my solution, I update it... Better now?

Haitham tarek 16-May-12 11:01am

yes thanks alot but please how i can get the connection string i added database INSIDE add items in aps.net and then i cant find the web .config how i can do instead ed

Killzone DeathMan 16-May-12 11:07am

In Microsoft Visual Studio 2010 there is on top a button 'Data' -> 'Add New Data Source' -> 'Database' -> 'DataSet' -> 'New Connection' -> Choose 'Microsoft SQL Server' and click 'Continue'...
Then add you sql server and click 'Test Connection'...
I have no SQL server installed to test here...but is this what you want?

Haitham tarek 17-May-12 4:01am

<pre lang="c#">
namespace teste
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// from where i can get that connection string? in that case i added new item
//from the solution and then chooses database and created like that.

string connection = "Your Conection String";
SqlConnection conn = new SqlConnection();
SqlDataAdapter adapt = new SqlDataAdapter("Query SQL", conn);
DataSet ds = new System.Data.DataSet();
adapt.Fill(ds);
dataGridView1.DataSource = ds;
}
}
}

Haitham tarek 17-May-12 4:02am

thanks for ur effort i am mainly web apps i don do much win apps
sorry maybe my questions are stupid but i really don't know it thanks a lot