C# Discussion Boards - CodeProject

Re: create a runtime table in Ms Access database

~~_{lost in transition}~~ 11-Dec-06 4:28

11-Dec-06 4:28

Here are two SQL statements that will create table1 and then create table2 with PK, FK and inforced integrity.
string _StrSQL;
string tblName = "table1";
string tblName2 = "table2";

_StrSQL = @"CREATE TABLE " + tblName +
@" (RecID AUTOINCREMENT " +
@" CONSTRAINT PK_" + tblName + " PRIMARY KEY, " +
@" RecorderID VARCHAR WITH COMPRESSION, " +
@" GroupID VARCHAR WITH COMPRESSION, " +
@" Name VARCHAR WITH COMPRESSION, " +
@" Address VARCHAR WITH COMPRESSION)";

_StrSQL = @"CREATE TABLE " + tblName +
@"(HourID AUTOINCREMENT" +
@" CONSTRAINT PK_" + tblName + " PRIMARY KEY," +
@" RecID INTEGER NOT NULL " +
@" CONSTRAINT FK_" + tblName2 + "_" + tblName +
@" REFERENCES " + tblName2 + " (RecID) " +
@" ON UPDATE CASCADE " +
@" ON DELETE CASCADE," +
@" DSID INTEGER NOT NULL," +
@" [Month] INTEGER," +
@" [Day] INTEGER," +
@" [Year] INTEGER," +
@" [Hour] INTEGER)";

You do not have to use the '@' symboly. I use it because it make the statement easier on my eyes.

Then drop the _StrSQL in a OleDbCommand:
object _obj = null;
OleDbConnection OleConn = new OleDbConnection(_ConnString);
OleDbCommand OleComm = new OleDbCommand(_SQLString, OleConn);
OleComm.Connection.Open();
_obj = OleComm.ExecuteScalar();
OleComm.Connection.Close();

Good Luck,
Jason

Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software.
[^]

File Upload in Windows Application ?

Kamal.Afridi11-Dec-06 3:30

Kamal.Afridi

11-Dec-06 3:30

Hi how can i upload a file from desktop application to a web directory.

I am using following code.

string fileName = @"E:\queries.txt";<br />
System.Net.WebClient client = new WebClient();<br />
client.UploadFile("http://ef-kam/Compaq/working/" + fileName, "PUT", fileName);

But i am getting following exception.
"The remote server returned an error: (501) Not Implemented."

Know Yourself Then Grow Yourself.

Re: File Upload in Windows Application ?

Guffa11-Dec-06 3:36

Guffa

11-Dec-06 3:36

The PUT method is disabled by default in the web server. You have to enable it for the server to accept it.

---
b { font-weight: normal; }

Re: File Upload in Windows Application ?

Kamal.Afridi11-Dec-06 3:37

Kamal.Afridi

11-Dec-06 3:37

thanks can u please tell me how i can enable it.

Know Yourself Then Grow Yourself.

Re: File Upload in Windows Application ?

Vasudevan Deepak Kumar11-Dec-06 4:17

Vasudevan Deepak Kumar

11-Dec-06 4:17

Check out this article http://www.codeproject.com/cs/webservices/DimeBufferedUpload.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Return Type

Saialsh11-Dec-06 3:10

Saialsh

11-Dec-06 3:10

Hi,
I need to pass values dynamically for a return type of a particular property.How could i do this.

Actually what happend is:I need to display time according to the user selected format.For that I have taken a proprty and that has constants.So for that i cant send values.I need to send the values only for the retun type.How could i do this.

Re: Return Type

Guffa11-Dec-06 3:29

Guffa

11-Dec-06 3:29

I have no idea what you are talking about. Perhaps if you illustrated it with an example of what you are doing and what you want the result to be.

---
b { font-weight: normal; }

Re: Return Type

jchigg200011-Dec-06 6:15

jchigg2000

11-Dec-06 6:15

If i understand you correctly you need to return date in the format specified by the user. Does the user input the format (e.g. MM/DD/YY)? You could return as String and cast to the proper format.

Re: Return Type

eggsovereasy11-Dec-06 9:01

eggsovereasy

11-Dec-06 9:01

You can override ToString and use it or you can just do like: yourTimeHoldingClassInstance.Time.ToString(userSuppliedFormatString);

public class YourTimeHoldingClass
{
  public DateTime Time
  {
    get { return this.time; }
    set { this.time = value; }
  }
  private DateTime time;

  public override string ToString(string format)
  {
    return time.ToString(format);
  }
}

Newbie: NullReferenceException

praths_c11-Dec-06 3:06

praths_c

11-Dec-06 3:06

Hi,

I am new to .NET, someone plz help me with the simple code below.

public partial class FontSelection : Form
{
public FontSelection()
{
FontFamily [] ff = FontFamily.Families;
for (int i = 0; i < ff.Length; i++)
{
try{ lbFonts.Items.Add(ff[i].Name);}
catch(Exception e )
{ MessageBox.Show(e + " null exception") ; }
}
}
}

I am getting NullReferenceException when I run it. I understood from reading some message boards that NullRefereceException is occurring here coz i havent instantiated the fontFamily. How do i do that?

I saw on help the overload list of FontFamily class and used FontFamily (String)

I tried ff[i] = new FontFamily ("Font") but complier doesnt like it. Im not sure what else to do, so plz help me

Praths

Re: Newbie: NullReferenceException

Luc Pattyn11-Dec-06 3:32

Luc Pattyn

11-Dec-06 3:32

Hi,

May I suggest you:
- use a debugger to single-step your code.
- or you insert Console.WriteLine statements to see progress and intermediate results
(such as ff.Length)
- make sure lbFonts is not null.

Smile | :)

Luc Pattyn

Re: Newbie: NullReferenceException

Stefan Troschuetz11-Dec-06 3:43

Stefan Troschuetz

11-Dec-06 3:43

I doubt that the FontFamily array is the problem as you get it from the static Families property and I doubt that the elements of this array aren't initialized. Otherwise you would have found a bug in .NET Framework and should report it. But I think it is more likely you forgot to initialize lbFonts which then causes the exception.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: Newbie: NullReferenceException

praths_c11-Dec-06 4:20

praths_c

11-Dec-06 4:20

Ok, but lbFonts is a listbox which i dragged and dropped on the form in visual studio. Do i need to initialize it? I assumed it is done automatically when u drag and drop the component on the form.

Re: Newbie: NullReferenceException

Stefan Troschuetz11-Dec-06 4:28

Stefan Troschuetz

11-Dec-06 4:28

It should be done automatically, but maybe something gone wrong or you're calling the method at some moment of the form's lifetime were it's already uninitialized. As the other poster said use the debugger to find the cause of your exception.

Re: Newbie: NullReferenceException

gnadeem11-Dec-06 10:46

gnadeem

11-Dec-06 10:46

hi.
on my system this code runs fine. both as a class and as a method. however i didn't extend class from Form, rather just created a form and added a control. check your initialization code for FontSelection class (in addition to the base class Form).

regards.

Running an application by the start up of the windows

hadad11-Dec-06 2:34

hadad

11-Dec-06 2:34

How can I run my desktop application automaticly by the start up of the windows

Dad

Re: Running an application by the start up of the windows

Stefan Troschuetz11-Dec-06 2:38

Stefan Troschuetz

11-Dec-06 2:38

Create a shortcut to the exe inside the "Startmenu"-"Programs"-"Autostart" folder.

Re: Running an application by the start up of the windows

Eric Dahlvang11-Dec-06 2:50

Eric Dahlvang

11-Dec-06 2:50

Add a new string value to the registry key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run that points to your app.

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Re: Running an application by the start up of the windows

Pete O'Hanlon11-Dec-06 4:50

Pete O'Hanlon

11-Dec-06 4:50

Or, more properly, create it as a Windows Service so that the end user can control the start up mode for the application, e.g. does it start up as Automatically or Manually.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

How to access data from a control on one from from another form? [modified]

Saira Tanwir11-Dec-06 1:45

Saira Tanwir

11-Dec-06 1:45

hello
i'm trying to use the values i get from this code

for(int i=0;i<count;i++)<br />
	{<br />
	indice[i] = TableListBox.CheckedIndices[i];<br />
	MessageBox.Show(indice[i].ToString());<br />
	}

where TableListBox is actually a CheckedListBox and its checked indices are being stored in another array.
Now the problem is that when i run this code from its respective form it works fine, but as soon as i close the form and try to access this chunk of code from another form, it gives me the Index out of bound exception for CheckedIndices. i expect this is due to the reason that as soon as i close the form with the CheckedListBox, all its values are discarded.

i've tried solving this problem by storing the CheckedIndices into a static array, but it still is giving me the same exception.

So plz can anyone guide me about this problem of mine and tell me how to retain the checked indices after the form has been closed.

Thanks and awaiting ur reply
Saira

-- modified at 8:34 Monday 11th December, 2006

Re: How to access data from a control on one from from another form?(URGENT)

Not Active11-Dec-06 2:17

Not Active

11-Dec-06 2:17

Posts marked URGENT will usually get ignored

only two letters away from being an asset

Re: How to access data from a control on one from from another form?(URGENT)

Saira Tanwir11-Dec-06 2:30

Saira Tanwir

11-Dec-06 2:30

well mark
very kind of u to tell me that ,i'll be more careful in future.;P
so can u help me?????

Re: How to access data from a control on one from from another form?(URGENT)

quiteSmart11-Dec-06 2:34

quiteSmart

11-Dec-06 2:34

you don't need to close it just hide it

Re: How to access data from a control on one from from another form?(URGENT)

Saira Tanwir11-Dec-06 2:49

Saira Tanwir

11-Dec-06 2:49

it still gives the same exception

any other suggestins???

Re: How to access data from a control on one from from another form?

Nader Elshehabi11-Dec-06 3:25

Nader Elshehabi

11-Dec-06 3:25

First the info you've provided isn't suffecient to judge the problem, but I'll take few guesses here.
1- The way you use to copy the array -ignoring the MessageBox of course- is quite wrong. You should use Array.Copy() or Array.CopyTo() static methods instead.
2- Failure of the static array ecludes that discarding the values of the CheckedIndices when closing the form is the problem.
3- Make a breakpoint and see the values of:
a. count
b. CheckedIndices.Count
c. indice.Count

Waiting for your reply.

Regards

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