Click here to Skip to main content
15,904,503 members
Home / Discussions / C#
   

C#

 
AnswerRe: datagridview combobox Pin
Eddy Vluggen13-Feb-14 9:06
professionalEddy Vluggen13-Feb-14 9:06 
Question3D Model Pin
Kadam dIgambar12-Feb-14 18:07
Kadam dIgambar12-Feb-14 18:07 
SuggestionRe: 3D Model Pin
Richard MacCutchan12-Feb-14 21:39
mveRichard MacCutchan12-Feb-14 21:39 
GeneralRe: 3D Model Pin
JV999914-Feb-14 3:07
professionalJV999914-Feb-14 3:07 
QuestionConverting Back from Decimal to Byte Pin
computerpublic12-Feb-14 10:03
computerpublic12-Feb-14 10:03 
AnswerRe: Converting Back from Decimal to Byte Pin
Richard Deeming12-Feb-14 11:07
mveRichard Deeming12-Feb-14 11:07 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic12-Feb-14 11:29
computerpublic12-Feb-14 11:29 
GeneralRe: Converting Back from Decimal to Byte Pin
Richard Deeming13-Feb-14 0:37
mveRichard Deeming13-Feb-14 0:37 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic13-Feb-14 9:15
computerpublic13-Feb-14 9:15 
GeneralRe: Converting Back from Decimal to Byte Pin
Richard Deeming13-Feb-14 10:35
mveRichard Deeming13-Feb-14 10:35 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic13-Feb-14 10:48
computerpublic13-Feb-14 10:48 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic16-Feb-14 6:00
computerpublic16-Feb-14 6:00 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic16-Feb-14 6:03
computerpublic16-Feb-14 6:03 
GeneralRe: Converting Back from Decimal to Byte Pin
Richard Deeming17-Feb-14 1:46
mveRichard Deeming17-Feb-14 1:46 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic18-Feb-14 22:51
computerpublic18-Feb-14 22:51 
GeneralRe: Converting Back from Decimal to Byte Pin
computerpublic18-Feb-14 23:03
computerpublic18-Feb-14 23:03 
GeneralRe: Converting Back from Decimal to Byte Pin
Richard Deeming19-Feb-14 1:59
mveRichard Deeming19-Feb-14 1:59 
GeneralRe: Converting Back from Bit to Byte Pin
computerpublic13-Mar-14 8:16
computerpublic13-Mar-14 8:16 
AnswerRe: Converting Back from Decimal to Byte Pin
Eddy Vluggen12-Feb-14 11:21
professionalEddy Vluggen12-Feb-14 11:21 
QuestionRe: Converting Back from Decimal to Byte Pin
Richard MacCutchan12-Feb-14 21:38
mveRichard MacCutchan12-Feb-14 21:38 
Questiontreeview and database Pin
danmor49812-Feb-14 6:45
danmor49812-Feb-14 6:45 
QuestionRe: treeview and database Pin
Ravi Bhavnani12-Feb-14 7:28
professionalRavi Bhavnani12-Feb-14 7:28 
AnswerRe: treeview and database Pin
danmor49812-Feb-14 7:52
danmor49812-Feb-14 7:52 
in fact I am trying to build a snippet database for my personnel use
All the one I have seen where a bit complicated to work with
I want to create mine. It will more likely help to understand more the logic behind it
and for the other project that I have with treeview

I am Using SqlCe 3.5 and up.

For the database I have done it this way

C#
static public String Dpath = Application.StartupPath + "\\Data\\";
        static public String DB_NAME = Dpath + Application.ProductName + ".sdf";
        static public String DB_PWD = "";
        static public string sql;
        static private string _filename;
        static public string filename
        {
            get { return _filename; }
            set { _filename = value; }
        }
        static private string _filecontent;
        static public string filecontent
        {
            get { return _filecontent; }
            set { _filecontent = value; }
        } 
  static public string ConnectString()
		{
			string connectionString = string.Format("DataSource=\"{0}\"; Password=\"{1}\"", DB_NAME, DB_PWD);
			return connectionString;
		}

		static public void CreateDB()
		{
			SqlCeEngine en = new SqlCeEngine(ConnectString());
			en.CreateDatabase();
			en.Dispose();
			en = null;
		}

		static public void CreateTable(string TName)
		{
			SqlCeConnection cn = new SqlCeConnection(ConnectString());
			if (cn.State == ConnectionState.Closed)
			{
				cn.Open();
			}
			SqlCeCommand cmd;
			sql = "create table " + TName + "("
				+ "ID INT IDENTITY (1,1) PRIMARY KEY not null, "
				+ "FileName NVarChar(50), "
				+ "FileContent NTEXT)";
			cmd = new SqlCeCommand(sql, cn);
			cmd.ExecuteNonQuery();
			cn.Close();
		}


If there is a better way of doing it it will be appreciated

Thank'a Lot
Daniel

QuestionRe: treeview and database Pin
Richard MacCutchan12-Feb-14 21:27
mveRichard MacCutchan12-Feb-14 21:27 
AnswerRe: treeview and database Pin
danmor49813-Feb-14 8:58
danmor49813-Feb-14 8:58 

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

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