WPF project connection to sqlserver

[anindya004]

Members I have a question how to connect to sql server tables of a database with this proect's data.
Can you suggest .

Members you can see that inside the bin\debug\Conta ctManager.state now in this ContactManager. state is the file where the data is getting stored when I am running the proj.

There is a _stateFile in the ContactReposito ry.cs where the values are getting stotred.This variable is later on used for all the operations.
My question is how to connect to sql server instead to this ContactManager. state file

now inside contactreposito ry.cs file

<code>

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Runtime.Serialization.Formatters.Binary;
 
namespace ContactManager.Model
{
    public class ContactRepository
    {
        private List<Contact> _contactStore;
        private readonly string _stateFile;
 
        public ContactRepository()
        {
            _stateFile = Path.Combine(
                AppDomain.CurrentDomain.BaseDirectory,
                "ContactManager.state"
                );
 
            Deserialize();
        }
 
        public void Save(Contact contact)
        {
            if (contact.Id == Guid.Empty)
                contact.Id = Guid.NewGuid();
 
            if (!_contactStore.Contains(contact))
                _contactStore.Add(contact);
 
            Serialize();
        }
 
        public void Delete(Contact contact)
        {
            _contactStore.Remove(contact);
            Serialize();
        }
 
        public List<Contact> FindByLookup(string lookupName)
        {
            IEnumerable<Contact> found =
                from c in _contactStore
                where c.LookupName.StartsWith(
                    lookupName,
                    StringComparison.OrdinalIgnoreCase
                    )
                select c;
 
            return found.ToList();
        }
 
        public List<Contact> FindAll()
        {
            return new List<Contact>(_contactStore);
        }
 
        private void Serialize()
        {
            using (FileStream stream =
                File.Open(_stateFile, FileMode.OpenOrCreate))
            {
                BinaryFormatter formatter = new BinaryFormatter();
                formatter.Serialize(stream, _contactStore);
            }
        }
 
        private void Deserialize()
        {
            if (File.Exists(_stateFile))
            {
                using (FileStream stream =
                    File.Open(_stateFile, FileMode.Open))
                {
                    BinaryFormatter formatter = new BinaryFormatter();
 
                    _contactStore =
                        (List<Contact>)formatter.Deserialize(stream);
                }
            }
            else _contactStore = new List<Contact>();
        }
    }
}

.
</code>

now in this file you can see that

_stateFile = Path.Combine(
                AppDomain.CurrentDomain.BaseDirectory,
                "ContactManager.state"
 

is there .
Now to connect it to the sqlserver what I have to do is instead of the binary file "ContactManager .state " ....I want a it to be connected to a *.mdf .

How to do this please suggest me .
This is an open source project.
for the detail explanation please see the two attached files with this question which have attached with this question.

The code can be downloaded from the website:
1. Go to www.informit.com/title/9780672329715.
2. Click Downloads.
3. Click one of links that appear, and the download should start automatically.

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

The tag is [code] not <code>

[tlhintoq]

My question is how to connect to sql server instead to this ContactManager. state file
now inside contactreposito ry.cs file

Until someone with more experience can offer more targeted advice I can point you toward these:

Database How-to parts 1 and 2
Database tutorial Part 1
Database tutorial Part 2

[anindya004]

I know the sql data connection to the windows forms.
Like the following
<code>
private void button1_Click(o bject sender, EventArgs e)
{
SqlConnection con = new SqlConnection(" Data Source=STUDENT-1D40FC5\\SQLEXP RESS; Initial Catalog=Library Mgnt;Integrated Security=SSPI") ;
string query = "insert into BookDetails(Tit le,Author,Publi sher,Subject,No _Of_Copies)valu es('" + title.Text + "','" + author.Text + "','" + textBox3.Text + "','" + subject.Text + "','" + no.Text + "')";
SqlCommand cmd = new SqlCommand(quer y, con);
con.Open();
SqlDataReader reader = cmd.ExecuteRead er();
MessageBox.Show ("The Book Details are saved.");
while (reader.Read())
{
}
reader.Close();

}
</code>

I want to know how to insert to the _stateFile in the code.
As if you see the full project and download it then you will see that it is using a binary file for the purpose of database connection and insert,update,d elete.

So in place
<code>
_stateFile = Path.Combine(
AppDomain.Curre ntDomain.BaseDi rectory,
"ContactManager .state"
</code>
how to connect to the sql database or .mdf file rather than a binary file.

[anindya004]

Experts I have a question---how to connect the following project to sql server and user insert/edit/update queries to the database-

1.Please open the page http://www.informit.com/store/produc...sbn=0672329859
2.click on Downloads
3.Please download the Contact Manager

4.Unzip ContactManager. zip
5.Please open ContactReposito ry.cs file
6.There you will find the following code

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Runtime.Serialization.Formatters.Binary;
 
namespace ContactManager.Model
{
    public class ContactRepository
    {
        private List<Contact> _contactStore;
        private readonly string _stateFile;
 
        public ContactRepository()
        {
            _stateFile = Path.Combine(
                AppDomain.CurrentDomain.BaseDirectory,
                "ContactManager.state"
                );
 
            Deserialize();
        }
 
        public void Save(Contact contact)
        {
            if (contact.Id == Guid.Empty)
                contact.Id = Guid.NewGuid();
 
            if (!_contactStore.Contains(contact))
                _contactStore.Add(contact);
 
            Serialize();
        }
 
        public void Delete(Contact contact)
        {
            _contactStore.Remove(contact);
            Serialize();
        }
 
        public List<Contact> FindByLookup(string lookupName)
        {
            IEnumerable<Contact> found =
                from c in _contactStore
                where c.LookupName.StartsWith(
                    lookupName,
                    StringComparison.OrdinalIgnoreCase
                    )
                select c;
 
            return found.ToList();
        }
 
        public List<Contact> FindAll()
        {
            return new List<Contact>(_contactStore);
        }
 
        private void Serialize()
        {
            using (FileStream stream =
                File.Open(_stateFile, FileMode.OpenOrCreate))
            {
                BinaryFormatter formatter = new BinaryFormatter();
                formatter.Serialize(stream, _contactStore);
            }
        }
 
        private void Deserialize()
        {
            if (File.Exists(_stateFile))
            {
                using (FileStream stream =
                    File.Open(_stateFile, FileMode.Open))
                {
                    BinaryFormatter formatter = new BinaryFormatter();
 
                    _contactStore =
                        (List<Contact>)formatter.Deserialize(stream);
                }
            }
            else _contactStore = new List<Contact>();
        }
    }
}
 
 

7.Now here you are seeing the following
<code>

_stateFile = Path.Combine(
                AppDomain.CurrentDomain.BaseDirectory,
                "ContactManager.state"

</code>

8.What this project is doing is it is storing the data in a binary data file ContactManager. state
9.Then passing those values to the variable _stateFile
10. Now my question is how to connect this project to the sql server and in place of the binary data file I want a table to be user in sqlserver .
11.How that is to be done I do not know.
12.I know the basic data connection to the winform application and insert/update/delete operation
as followes

<code>

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Data Source=STUDENT-1D40FC5\\SQLEXPRESS; Initial Catalog=LibraryMgnt;Integrated Security=SSPI");
            string query = "insert into BookDetails(Title,Author,Publisher,Subject,No_Of_Copies)values('" + title.Text + "','" + author.Text + "','" + textBox3.Text + "','" + subject.Text + "','" + no.Text + "')";
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            MessageBox.Show("The Book Details are saved.");
            while (reader.Read())
            {
            }
            reader.Close();
 
        }

</code>

13.But in this project how that connection is to be established I do not know and also how insert/update/delete queries are to be used .

14.Experts I thought that ContactReposito ry.cs file only is responsible for the data connection if I am wrong then please see the whole project where the required changes are to be made.That is the main reason I have send the url of the code project .

I am totally new to WPF please explain step by step

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

I know I have said this in a few of your posts now.
The tag for code is [code] not <code>
Stop making other people do this for you. It's lazy.

[tlhintoq]

I have to say, you are asking an aweful lot of people just to answer

How to connect the following project to sql server and user insert/edit/update queries to the database

There really isn't a need to download your entire project etc. to tell you how to connect to a database and use insert/edit/update queries.

Database How-to parts 1 and 2
Database tutorial Part 1
Database tutorial Part 2

[tlhintoq]

Please don't double-post your questions. It divides attempts to help you in an organized and cohesive manner. Your threads have been merged

[anindya004]

can you please suggest me how to replace the binary data file and what to do there as here binary data file is used

[tlhintoq]

What do you mean by "replace"?
Update the value in the database?
Or replace the use of a binary file with some other kind of data: Something different than binary file?

If you mean 'update the database'... That is very well covered in the tutorials. Did you *do* the tutorials?