Re: StreamReader - C# Discussion Boards

Re: .NET module. How to Add to Client?

8-Jul-05 16:23

in the "solution explorer" window, right click on the project node. Choose "Add". Choose "new Class". In the dialog. give the class the name you want... this will create a new class (and its .cs file) in the current project.
If you have an existing .cs file choose "add existing item" then browse to the file you want to add. The default "open" button will make a copy of that file in your current project directory (note that the button is really a drop-down combo under cover) if you drop down the "open" button, you can choos "link to project" instead. This will just add the file, in its current location, to the project as a linked itm. This is useful when you need to share common code between several projects.

Hopefully, I understood your question...

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

S. Senthil Kumar8-Jul-05 20:22

S. Senthil Kumar

8-Jul-05 20:22

By modules, if you meant classes, then ignore this post.

AFAIK, assemblies are the most basic units in .NET, you can't add references to individual modules within an assembly.

If you're talking about adding modules to your project's assembly (as opposed to adding references to them), then that's possible using the command line.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

StreamReader

Expert Coming8-Jul-05 15:22

Expert Coming

8-Jul-05 15:22

Help me out with this error please.

StreamReader input = new StreamReader("C:\Program Files\Prefs\num.txt");

Invaild escape sequence.

Problem, and answer please. Thanks for the help.

Guffa8-Jul-05 15:34

8-Jul-05 15:34

The \ character is escape character in C# strings. To put a \ character in a string you have to escape it, that is using \\.

Or you can put @ before the string, then it does not process escape sequences.

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

Expert Coming8-Jul-05 15:39

Expert Coming

8-Jul-05 15:39

Ok thanks that helps, but how do i make it look on the clients pc for the file?

Thanks again.

Guffa8-Jul-05 16:22

8-Jul-05 16:22

You don't.

Unless you run a component or applet in the browser, so that the user can accept it, there is no way you can get any information at all about the client's file system.

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

Rob Graham8-Jul-05 16:26

8-Jul-05 16:26

if you have sufficient rights to the clients pc, and the file is on a shared directory, you could use a UNC path: \\ComputerName\Sharename\....\filename.ext

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Javier Unamuno10-Jul-05 11:35

Javier Unamuno

10-Jul-05 11:35

You should do

StreamReader input = new StreamReader("C:\\Program Files\\Prefs\\num.txt");

or

StreamReader input = new StreamReader(@"C:\Program Files\Prefs\num.txt");

Error while insert DB

Ronen Kfir8-Jul-05 11:44

Ronen Kfir

8-Jul-05 11:44

I'm trying to open a user with insert SQL query to Access. This is the statements:

string sqlCreateNewUser = "INSERT INTO usersTbl ( UserName, Password) " +
"VALUES (" + username.UserName+ ", " + username.Password + ")";
Think the eror derived from the class I wrote to user. This is the class:

public class user
{
private string username;
private long password;

public user(string username, long password)
{
this.username = username;
this.password = password;
}

///

/// Gets, Sets username.
///

public string UserName
{
get
{
return this.username;
}
set
{

this.username = value;
}
}

///

/// Gets password.
///

public long Password
{
get
{
return this.password;
}
set
{

this.password = value;
}
}

}

Please help me find the false.

BTW: sorry I don’t use indentation. Just couldn’t understand the tags system here...
Where would I find some info on it?

TIA,

Ronen

Guffa8-Jul-05 13:15

8-Jul-05 13:15

Standard question #2:
What error message do you get?

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

Ronen Kfir8-Jul-05 20:28

Ronen Kfir

8-Jul-05 20:28

The Error I get is:
"Syntax error in INSERT INTO statement"
Tried it with the extra quotes, with no use.
I would rather do it this way at this stage. I think the syntax is OK (?)
What do you think of the user class I wrote?

Guffa9-Jul-05 7:04

9-Jul-05 7:04

Username or password might be reserved words, depending on what connection you use. Put brackets around them: [username], [password]

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

sea#9-Jul-05 10:29

sea#

9-Jul-05 10:29

The problem was with Password as a reserved word. once put it brackets around it- solved.

cheers!

Ronen

Rob Graham8-Jul-05 15:10

Edit controls properties in other thead

8-Jul-05 15:10

You need to enclose your values in single quotes:

... "VALUES ('" + username.UserName+ "','" + username.Password + "')";

note the extra single quotes I have added.

A better way to do this would be to use parameters and a stored procedure (querydef in access lingo), then you wouldn't have to worry with things like the single quotes (which will need to be doubled up if they are part of a name - O'Neill - becomes O''Neill - in order to work). If you use a strored procedure with parameters, you won't have to worry about escaping the embedded single quote.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

machocr8-Jul-05 10:30

machocr

8-Jul-05 10:30

Hi, how can I edit an windows control property with other threading tha the current works in the form?
I make a threat to do some tasks, and I want to show to the user the progress in a progress bar and subtask it is doing in label.
I try but throw me an exception because the threadin to edit controls property is other than the one is doing my custom tasks. Sigh | :sigh:

than you!

La realidad no es más que impulsos eléctricos del cerebro - Morpheus

Re: Edit controls properties in other thead

Rob Graham8-Jul-05 15:32

DataGrid---UpdateCommand... problem...

8-Jul-05 15:32

You can't access a control directly from a thread different than the one that created the control you need to use Invoke or BeginInvoke to do this. See this article[^] for more details.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

just4ulove78-Jul-05 10:15

just4ulove7

8-Jul-05 10:15

Hi..
I have a datagrid and an EditCommand

Now, when I click the UpdateCommand- link button...

private void dgProjects_ItemUpdate(object sender,DataGridCommandEventArgs e )
{
string ProjectId = e.Item.Cells[0].Text
....
}

It should return me the first column value in the clicked row???

But its not...

Is something wrong.. or some other way...???

Thanks

Re: DataGrid---UpdateCommand... problem...

Snowblind379-Jul-05 7:30

Snowblind37

9-Jul-05 7:30

The answer is a little more complicated than it should be....Or at least I thought it should be.

The following code is meant to take the value of the cell (that the user has selected and changed)and write this value into the database. It then refreshes the DataGrid to show the new value.

The hardest part to understand is that you have to create a DataGridTableStyle object to do this. The reason for creating this object is that the class provides the necessary methods and properties that you need to access.

<br />
private void updateButton_Click(object sender, System.EventArgs e)<br />
{<br />
//DataGridTableStyle provides the mechanisms<br />
DataGridTableStyle ts1 = new DataGridTableStyle();<br />
<br />
//DataGridCell allows you to hold the contents of the specified cell<br />
DataGridCell myCell;<br />
myCell = UserdataGrid.CurrentCell;<br />
<br />
// map the DataGridTableStyle object to the database source <br />
ts1.MappingName = "SessionTable";<br />
<br />
//Add the DataGridTableStyle object to the grid's TableStyles collection<br />
UserdataGrid.TableStyles.Add(ts1);<br />
<br />
string infoStr = null;<br />
int j = 0;<br />
<br />
//The two foreach statements is a loop within a loop<br />
//The outer loop deals with the row index<br />
//The inner loop returns the column number (j) if there is a match<br />
//and the infoStr(column to change)<br />
foreach(DataGridTableStyle gridStyle in UserdataGrid.TableStyles)<br />
{<br />
<br />
foreach(DataGridColumnStyle colStyle in gridStyle.GridColumnStyles)<br />
{<br />
if (j == myCell.ColumnNumber)<br />
{<br />
infoStr = colStyle.MappingName;<br />
}<br />
j++;<br />
}<br />
//end inner foreach<br />
}<br />
//end outer foreach<br />
<br />
//The element selection has been found <br />
//and the current row index is where it can be found	<br />
int i = UserdataGrid.CurrentRowIndex;<br />
<br />
//Get the unique id associated with this row<br />
//Note that I needed to make this GUID id part of <br />
//my DataTable so that when I update the sql table<br />
//I am updating only that particular record<br />
//and not other records that may have similiar entries<br />
String userId = UserdataGrid[i, 7].ToString();<br />
<br />
//The UpdateRecord method creates an SQL update statement<br />
//Parameters are:<br />
//Table to change<br />
//Column to change<br />
//Column to search for GUID id<br />
//match on GUID id will determine row index<br />
//Value to update<br />
sql.UpdateRecord("SessionTable", infoStr, "UserId", userId, UserdataGrid[myCell].ToString());<br />
<br />
//Now all we need to do is show the changes in the DataGrid<br />
FillData();<br />
UserdataGrid.SetDataBinding(dataSet, "SessionTable");<br />
UserdataGrid.Refresh();<br />
}<br />
<br />

Whoooo!!! It sure seems like alot of work just to get a value, change it and then display the changes. But there are some positive things to note:

1) This is the entire implementation(minus the sql statements for the database and the implementation of FillData())
2) I did not have to use EditCommand
3) Though not the most elegent solution, it works!

Well, I hope this helps. I know what it's like to wonder why something isn't working when it looks like it should. Sometimes we need to look outside of the "logical box" to make it work.............

Have a good one,

Snowblind37 aliasing as CodeBlind37 these days.

List definition in C#

zaboboa8-Jul-05 9:07

zaboboa

8-Jul-05 9:07

How come I cant define the List type using the statement:

List<int> intList = new List<int>();

it seems it does not recognize the List definition.

Thank you.

Stefan Troschuetz8-Jul-05 9:38

Stefan Troschuetz

8-Jul-05 9:38

Did you wrote a using directive for the correct namespace, so the use of types in that namespace is allowed without having to specify the namespace.?

www.troschuetz.de

zaboboa8-Jul-05 9:41

zaboboa

8-Jul-05 9:41

The only directive that I think I need is System.Collections;
And that is what I have.
Do I need some other directives to use List

Thank you

Stefan Troschuetz8-Jul-05 10:03

Stefan Troschuetz

8-Jul-05 10:03

The System.Collections namespace doesn't contain a List type. There are ArrayList or SortedList type and IList interface.

www.troschuetz.de