.net

Question

how to connect to db

Dipankar Biswas · Answer

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 Jc · Answer

hi kartheek, try this one. http://adidotnettotal.blogspot.in/2013/03/registration-form-in-aspnet-using.html

Vincent Maverick Durano · Answer

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 Rajput · Answer

http://www.c-sharpcorner.com/uploadfile/201fc1/introduction-to-sql/ http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Riddhi Valecha · Answer

The connection strings will be different... Refer - http://www.dofactory.com/reference/connection-strings Hope this helps !

Manoj Bhoir · Answer

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/

.net

Answers (6)