[brandon277]

string strReturn = new string("");

Guys ... I dunno what I'm doing wrong, but I'm getting an error on this:
"The best overloaded method match for 'string.String(char[])' has some invalid arguments" ...
Not quite sure what's up, as I'm just starting to learn C# ...

[papuccino1]

I'm having this problem as well, but I think the line should read:

string strReturn = "";

At least I think it should be that way.

[Pretty_White_Vampire]

Good Day. I'm using the following codes to connect my project to SQL database.
What's the difference between the codes you were using because I'm having problems with remote connections.

using System;
using System.Collections.Generic;
using System.Windows.Forms;

namespace MySystem
{
	static class Program
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		public static string connection = "Server=Computer_Name\\SQLEXPRESS; Database= MySystemDatabase; integrated security=true";
		[STAThread]
		static void Main()
		{
			Application.EnableVisualStyles();
			Application.SetCompatibleTextRenderingDefault(false);
			Application.Run(new Form1());
		}
	}
}

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Text; 
using System.Windows.Forms; 
using System.Data.SqlClient;

  SqlConnection connect = new SqlConnection(Program.connection);

This post has been edited by Pretty_White_Vampire: 31 May 2009 - 09:07 PM

[MarmiteX1]

Hi,

Sorry to bother, but I was wondering if you could assist me please with this database issue i am having?

I would like to the values from the textboxes and update the values of a particular row that I have selected and save the permanantly but tat he moment it doesnt save it permanantly.

I have attempted to solve this but i am still having problems.

Here is the link for further details:

http://www.dreaminco...h...=150287&hl=

I would appreciate if you could look into this please?

Thanks

[royjm248]

Hi, the tutorial looked great, but all i get is "Error 1 The type or namespace name 'BindingSource' could not be found (are you missing a using directive or an assembly reference?)"

[PsychoCoder]

BindingSource is a member of the System.Windows.Forms Namespace

[chris71]

what is the difference between VB^ and C Sharp?

[milad.cia]

Quote

what is the difference between VB^ and C Sharp?

i think C# is more powerful.

i worked with VB and C# both
and i like C#. its easy and power full.

This post has been edited by milad.cia: 10 December 2010 - 06:03 AM

[gacanepa]

Hi guys, this may be an old thread but just came in handy for me, and I decided to join this forum because this tutorial and all the others are fantastic. Just a quick note: I was getting an error "ConfigurationManager does not exist in the current context" so this is what I found out: To use ConfigurationManager, It's not only necessary to use the namespace System.Configuration. You have also to add the reference to the assembly System.Configuration.dll , by right-click-ing on the References tab, choose add reference and then find System.Configuration.
Source: http://www.codeguru....p/t-409163.html

[gacanepa]

Quote

There's a problem in the "Try" "Catch" area, it gives an error "not all code paths return a value" From what I researched and found is that it is because, "nothing is returned if the try block throws an exception and it is caught by the catch block"

Has this issue been resolved?

[pietomb00]

I have a few errors when compiling that I'm just clueless about.

case ConnectionState.Open: //the connection is open
                    //close then re-open
                    oCn.Close();
                    oCn.Open();
                    break;
                case ConnectionState.Closed: //connection is open
                    //open the connection

The name "connectionState" does not exist in the current context.

and

  oBindingSource.DataSource = dtGet;

doesn't contain a definition for datasource, or extension method, (missing a using directive or an assembly reference?)

Thanks.

[Darkmatter5]

I'm getting an error in the GetBindingsource function.

It gets to the try/catch at da.Get(dtGet);

The error says, "Error in GetBindingSource" "Fill: SelectCommand.Connection property has not been initialized."

Here's my GetBindingSource code.

public static BindingSource GetBindingSource(SqlCommand cmdSql)
{
  BindingSource oBindingSource = new BindingSource();
  SqlDataAdapter daGet = new SqlDataAdapter(cmdSql);
  DataTable dtGet = new DataTable();
  cmdSql.CommandTimeout = 240;
  dtGet.Locale = System.Globalization.CultureInfo.InvariantCulture;
  try
  {
    daGet.Fill(dtGet);
  }
  catch (Exception ex)
  {
    MessageBox.Show(ex.Message, "Error in GetBindingSource");
    return null;
  }
  oBindingSource.DataSource = dtGet;
  return oBindingSource;
}

Any ideas?

[probuddha]

How to connect to an SQL-Server:
http://www.programme...-to-sql-server/