.net

kartheek nekkanti

11y1.1kLearn iOS Programming

how to connect to db

6 Replies

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

Dipankar Biswas11y ago
hi..

Oledb...

Imports System.Windows.Forms
Imports System.Data.OleDb

connectin:

Public ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Arise english exam\Demo\Arise english exam\arise_english_exam.accdb;Persist Security Info=False"
Public conn As New OleDbConnection

Private Sub new_user()
Try

'Dim sqlquery As New OleDb.OleDbCommand
conn.ConnectionString = ConnString
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
Dim sqlquery As String = "insert into new_user_table (user_name,user_password,user_email) " &
" values(@username,@userpass,@usermail) "

Dim sqlcommand As New OleDbCommand
With sqlcommand
.CommandText = sqlquery
.Connection = conn
.Parameters.AddWithValue("@username", txt_new_uname.Text)
.Parameters.AddWithValue("@userpass", txt_new_upass.Text)
.Parameters.AddWithValue("@usermail", txt_new_umail.Text)

.ExecuteNonQuery()
End With

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
conn.Close()
End Sub

SqlClient

Dim conn As New SqlClient.SqlConnection

conn = New SqlClient.SqlConnection
conn.ConnectionString = "Data Source=Localhost; Initial catalog=win_exam_system; Integrated security=true"

Private Sub RefreshData()
If Not conn.State = ConnectionState.Open Then
conn.Open()

End If
'ds.Tables.Add(dt)

Dim da As New SqlDataAdapter("select Date_Time,Subject_1,Subject_2,Subject_3,Subject_4,Subject_5 from Qus_upload_tbl ", conn)
Dim dt As New DataTable

da.Fill(dt)
Me.DataGridView1.DataSource = dt

conn.Close()
End Sub
Adinarayana Reddy Jc11y ago
hi kartheek,

try this one.

http://adidotnettotal.blogspot.in/2013/03/registration-form-in-aspnet-using.html
Vincent Maverick Durano11y ago
how to connect to db

This is a very generic question and can easily be found at google by doing a simple search. Also what database do you want to connect with? Which development platform? windows? web? What data access do you want to use for connecting to your database?
Khargesh Rajput11y ago
http://www.c-sharpcorner.com/uploadfile/201fc1/introduction-to-sql/

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm
Riddhi Valecha11y ago
The connection strings will be different...

Refer -

http://www.dofactory.com/reference/connection-strings

Hope this helps !
Manoj Bhoir11y ago
Hi,

You will get so many example on Internet to connect your applicaion with database.

Sample Code :

using System;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string connetionString = null;
            SqlConnection cnn ;
            connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
            cnn = new SqlConnection(connetionString);
            try
            {
                cnn.Open();
                MessageBox.Show ("Connection Open ! ");
                cnn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can not open connection ! ");
            }
        }
    }
}

Please check these link :

How to connect SQL Database to your C# program, beginner's tutorial
http://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program

C# SQL Server Connection
http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

For more info about Conections strings for different types of Database
http://www.connectionstrings.com/