C# .NET - want to develop window based application

i want to develop small window based application for asset management.

but i don't want to use sql server because installation need sql server file which i don't want because in user computer its not necessary installed sql server on their machine.

i want to use database which does not require installation in client machine also can run on .net environment ( is it possible in sql server 2005).

so what should i do to overcome this problem.

give me solution as soon as possible. thanks you.

regards,
Pinakin Patel
me.pinakin@gmail.com
+91 99744000333

You can use Ms Access as a databse, the key advantages that Microsoft Access has is the ability to build a software system to manage a range of services very quickly, but it also have my drawback like security, meant to have multiple users at any given time,  but for desktop application Ms Access is the best database, you can add database while creareing setup package, so no need to install it saparetely

Hi Pinakin

user Sqlite its superb light weight and easily understandble,i used it in one of my project
there is also access is there but i would suggest you to go with sqlite

thxs

You Can Use OLEDB(Ms Access) As Your Database For That Follow This :

Imports System.Data.oledb    //Import This "oledb" Class


Dim conn As New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = /DATABASE.MDB") //For Create Connection With MS Access File, Here "DATABASE.MDB" Is MS Access File.


//Below Code Is For Retrieve Data From Database Into The Textbox.

Try
            Dim cmd As New OleDbCommand
            Dim dr As OleDbDataReader
            conn.Open()
            cmd.Connection = conn
            cmd.CommandText = "Select UserName From User_Detail Where UserID like '" + txtUser.Text + "'"   //Write Query For Get The Username From The database. Here "txtUser" Is TextBox Which Store The "UserId".
            dr = cmd.ExecuteReader()
            While dr.Read()
                txtUserName.Text = dr.GetValue(0).ToString  //Store Data Into "txtUserName" Textbox.
            End While
            dr.Close()
            conn.Close()
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try
        conn.Close()

//Using This You Can Connect Your Database With The The Controls.//

//I Hope This Will Very Helpful To You & It's Work 100%...

hello pinakin, if there is small application and if only a some transaction ,

then you can use file in your application.

just do necessary operation.

and if you want flexible operation, than the file, then you can use ms-access

hi anand

Dear Pinakin,

Why Don't You Understand?

If there will be not ms office in client machine, still you can access your data from the file.
For Accessing data From The File you don't need to ms office.


//i hope now you clear & Using Access You Don't Need To Install Another Application Like SQL Server or Etc..

Hi Pinakin

you have to download lightweight free sqlite from following url

http://www.sqlite.org/download.html

and than you can use it has any other database,i am providing you some links where you can find some sample to start with

http://www.codeproject.com/KB/cs/SQLiteCSharp.aspx
http://jclement.ca/devel/dotnet/sqlite.html

Feel free to ask anything

thxs

Well, choosing about database is purely depend up on your size of the application and architecture of the application. 

I  would personally suggest to go for SQL Express. Because your application might end up being multi user. One of the biggest drawback of SQLite is, it was designed for Single User. Also there are other implementation limitations details are listed about SQLite: http://www.sqlite.org/limits.html.