Click here to Skip to main content
       

C#

 
GeneralRe: C# error message SystemCertificates\Disallowed Pinmemberclassy_dog12-Feb-13 17:18 
QuestionHow to sent/receive sms in C# application? PinmemberAnand Gunasekaran11-Feb-13 4:43 
AnswerRe: How to sent/receive sms in C# application? PinmemberJosé Amílcar Ferreira Casimiro11-Feb-13 5:28 
AnswerRe: How to sent/receive sms in C# application? PinmvpAbhinav S11-Feb-13 6:21 
AnswerRe: How to sent/receive sms in C# application? Pinmemberjschell11-Feb-13 9:15 
GeneralRe: How to sent/receive sms in C# application? PinmemberAnand Gunasekaran12-Feb-13 0:21 
AnswerRe: How to sent/receive sms in C# application? PinprofessionalAmir Mohammad Nasrollahi29-Jul-13 23:23 
QuestionConstructor issue Pinmemberantrock10111-Feb-13 3:41 
Hello,
 
I'm having a few issues with my code, i'm following this tutorial http://www.homeandlearn.co.uk/csharp/csharp_s12p6.html Can anyone point me in the right direction. I've included my code below.
 
The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapter(string, System.Data.SqlClient.SqlConnection)
 
<pre lang="c#">Argument 2: cannot convert from 'System.Data.SqlServerCe.SqlCeConnection' to 'System.Data.SqlClient.SqlConnection'
 

 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 
namespace Game
{
    public partial class Form1 : Form
    {
        public OpenFileDialog dialog = new OpenFileDialog();
        System.Data.SqlServerCe.SqlCeConnection con;
        System.Data.SqlServerCe.SqlCeDataAdapter da1;
        DataSet ds1;
 

 
        public Form1()
        {
            InitializeComponent();
        }
 
        private void btn_sel_Click(object sender, EventArgs e)
        {
            
            //dialog.Filter = "*.sdf";
            dialog.ShowDialog();
            MessageBox.Show(dialog.FileName);
            loadconnection();
 
        }
 
        private void btn_close_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
 
        public void loadconnection()
        {
            con = new System.Data.SqlServerCe.SqlCeConnection();
            con.ConnectionString = "Data Source=" + dialog.FileName + ""; //opening dialog (selected file)

            con.Open();
 

            ds1 = new DataSet();
            string sql = "SELECT * From tbl_games";
            da1 = new System.Data.SqlClient.SqlDataAdapter(sql, con);
            da1.Fill(ds1, "Name");
 
            con.Close();
        }
 
    }
}

AnswerRe: Constructor issue PinmvpAbhinav S11-Feb-13 3:51 
GeneralRe: Constructor issue Pinmemberantrock10111-Feb-13 4:43 
GeneralRe: Constructor issue PinmvpRichard MacCutchan11-Feb-13 5:45 
GeneralRe: Constructor issue Pinmemberantrock10111-Feb-13 5:55 
GeneralRe: Constructor issue PinmvpRichard MacCutchan11-Feb-13 6:10 
GeneralRe: Constructor issue Pinmemberjibesh11-Feb-13 7:38 
AnswerRe: Constructor issue PinmemberShameel11-Feb-13 6:02 
Questionif loop cant excuted properly Pinmemberabhishek80800011-Feb-13 1:36 
AnswerRe: if loop cant excuted properly PinprotectorPete O'Hanlon11-Feb-13 1:45 
AnswerRe: if loop cant excuted properly PinmvpDave Kreskowiak11-Feb-13 3:09 
AnswerRe: if loop cant excuted properly PinmemberBernhard Hiller11-Feb-13 3:27 
GeneralRe: if loop cant excuted properly PinmemberSimon_Whale11-Feb-13 4:58 
AnswerRe: if loop cant excuted properly PinmemberJegan Thiyagesan11-Feb-13 7:27 
GeneralRe: if loop cant excuted properly Pinmemberabhishek80800011-Feb-13 9:06 
GeneralRe: if loop cant excuted properly PinmemberDanielSheets19-Feb-13 8:59 
QuestionInvoke schedule task using .NET program Pinmembersiddisagar11-Feb-13 1:30 
AnswerRe: Invoke schedule task using .NET program PinmvpDave Kreskowiak11-Feb-13 3:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.1411019.1 | Last Updated 21 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid