C# Discussion Boards - CodeProject

Re: Moving a file over a network.

Dylan van Heerden14-Oct-04 2:51

Dylan van Heerden

14-Oct-04 2:51

Thx

My brain is 2 small for all the knowledge that I need.

Re: Moving a file over a network.

Heath Stewart14-Oct-04 6:43

Heath Stewart

14-Oct-04 6:43

By default ASP.NET runs under the ASPNET account, a local machine account. This can cause a problem, especially since the password is, by default, randomly generated when the AppDomain is recycled.

If you're on a domain (and presumably you are), I (and most other developers familiar with this problem) recommend changing your machine.config file to use a domain account (like MYDOMAIN\ASPNET) and the password assigned to that user. This file is protected under strict ACLs so you shouldn't worry too much.

That'll make it easier for the web service running under ASP.NET to copy files, since you're now using a domain account instead of a local account (which you might not even be able to reference depending on your network topology). See the <httpRuntime> element documentation in the .NET Framework SDK for more information.

Alternatively, you could enable impersonation. That's a little more drawn-out, so I would refer you to the .NET Framework SDK and MSDN[^] articles about how to do that, or ask in the ASP.NET forum here.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Re: Moving a file over a network.

Heath Stewart14-Oct-04 6:38

Heath Stewart

14-Oct-04 6:38

I need a second "drive" then - or just a damn good defragmenter. Retaining most of what I read, see, and hear (which can suck) I'm starting to get way too much thrashing. My driver might be a little bad, too, since the heavy fragmentation is leading to data corruption (mixing of fragments into incomprehensible rubbish). Smile | :)

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Strong name to Interop assembly

hatim_ali13-Oct-04 23:44

hatim_ali

13-Oct-04 23:44

Hello,

I have a class library project which has a class supporting COM+ transactions. This class library project refers a COM interop assembly. Now i need to register the assembly after compiling this class library projects into GAC. Registrering it into GAC requires tthat the assembly should have a strong name. Now when i use [assembly: assemblykeyfile("file.snk")] attribute and compile the class library project it prompts me that the interop assembly should have a strong name too..

Now how to assign that interop assembly a strong name whehn its source is not accessible to me ?? OR how compile successfully this class library without assigning strong name to interop assembly.

Any other workarounds ??

Thanks,
Hatim Ali.

Re: Strong name to Interop assembly

Alex Korchemniy14-Oct-04 9:18

Alex Korchemniy

14-Oct-04 9:18

al.exe

also c: http://www.thecodeproject.com/vb/net/serviced_components.asp

Re: Strong name to Interop assembly

hatim_ali14-Oct-04 19:19

hatim_ali

14-Oct-04 19:19

I had read about al.exe but it requires .netmodule file which obviously i don't have because the source assembly is an interop assembly.

Any other workaround ??

Thanks...

Insert RTF files in Access DB

Zamolxes13-Oct-04 23:35

Zamolxes

13-Oct-04 23:35

I want to insert a RTF file to an Access DB and i tried to insert only the RTF source to a MEMO field and when the command is executed i recive an error "SQL SYNTAX something" if anyone can help me with code please do...

Re: Insert RTF files in Access DB

Judah Gabriel Himango14-Oct-04 5:45

Judah Gabriel Himango

14-Oct-04 5:45

Most likely the RTF has a single quote in it, which corrupts the SQL syntax. Try creating and calling a stored procedure instead of concatenating together a string containing the SQL INSERT statement, this will allow you to pass single quote characters without messing up the SQL syntax.

Judah Himango

Re: Insert RTF files in Access DB

Heath Stewart14-Oct-04 6:35

Heath Stewart

14-Oct-04 6:35

Access doesn't support stored procs. Besides, the correct resolution here is to use parameterized queries - even with stored procs. Not using parameterized queries and instead relying on string concatenation to build SQL expressions opens you up for SQL injection attacks.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

Re: Insert RTF files in Access DB

Heath Stewart14-Oct-04 6:34

Heath Stewart

14-Oct-04 6:34

This is most likely because your SQL expression contains a quote (as Judah said) but instead of just resorting to stored procedures (especially since Access doesn't support them), use parameterized queries.

When you use string concatenation to build SQL expressions, you not only run into problems like this but face SQL inject attacks, which are extremely easy to exploit and can be the most devastating (yeah, DDoS'ing a site sucks, but stealing credit card numbers or something else of value without the site knowing is far, far worse). If you're interested, search prior discussions on this board (heck, just go back to yesterday where I had to explain this 4 times to different people).

Something like the following would solve the problem of both escaping quotes and keeping your database secure:

using (OleDbConnection conn = new OleDbConnection(connectionString))
{
  OleDbCommand cmd = conn.CreateCommand();
  cmd.CommandText = "insert into Whatever (RTF) values (?)";
  cmd.Parameters.Add("@RTF", OleDbType.LongVarWChar).Value = richTextBox1.Rtf;
  cmd.ExecuteNonQuery();
}

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles] [My Blog]

TextBox - What else?

pat27088113-Oct-04 22:43

pat270881

13-Oct-04 22:43

Apparent it is not possible to change the height of a TextBox. But I want to display two or three lines of text. Which control can I use and/or should I use?

Regards

patrick

Re: TextBox - What else?

Jay Shankar13-Oct-04 22:56

Jay Shankar

13-Oct-04 22:56

Set Multiline property to True, You can enter more than one line as well as change the height.

Dictionary on cd

hazzem elrefai13-Oct-04 22:38

hazzem elrefai

13-Oct-04 22:38

Iam going to develop something like dictionary but it will be distrebuted on cd, and it will have about 100,000 record (the record about 5 fields some fileds will be 800 character)

i do not know what is the database to use with this application?
sure it will not be sql server coz of cost resons
and i think that access will be weak to this

thnx in advance

Re: Dictionary on cd

Colin Angus Mackay13-Oct-04 22:48

Colin Angus Mackay

13-Oct-04 22:48

How about MSDE? It is basically a SQL Server Engine, but limited to about 5 or 10 concurrent connections, and you can redistribute your application with the MSDE engine at no extra cost.

Also, if you are going to create a database application you might want to consider improving your spelling ability. The following words are all misspelled: distrebuted fileds coz resons thnx

Do you want to know more?

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Re: Dictionary on cd

Anonymous14-Oct-04 1:50

Anonymous

14-Oct-04 1:50

thnx

Tab Control

mathon13-Oct-04 21:59

mathon

13-Oct-04 21:59

Hello,

Unfortunately, in the ".NET Compact Framework Programming with C#" is the TabControl not explained so I have five questions referring to the TabControl on Smart Device Application:

1) How can I when I go from another Form1. to the Form with the TabControl to select an initial TabPage?

2) When I want to create a special control for a TabPage which I cannot design with the VS.NET Designer in the corresponding tabPage, what do I have to quote that the Control is on the certain tab page?

3) When I click from one tabPage (JobDetails) to another tabPage (ClientDetails) the SelectedIndexChanged Event is occured. But how can I indicate in this event that I want for example to the ClientDetails tab Page?

4) How can I take over a parameter from one tabPage to another tabPage?

5) Is it difficult to give a certain tab page a background colour?

Hopefully anybody find time for these questions..:-/

Best Regards

mat

Re: Tab Control

Alex Korchemniy14-Oct-04 9:50

Alex Korchemniy

14-Oct-04 9:50

1) Just show the right form. Set the SelectedIndex to the tab you want.

2) Confusing question but i'll try. If you want to know what tabpage a control is on go control.Parent. If you are trying to add designer support search google.

3) After the event occurs you can check the selectedtab or selectedindex. The eventargs don't have any additional info.

4) ???

5) No. Just get the TabPage you want and change the Background like you do on everything else.

adding combo box and data picker in DataGrid

shambho13-Oct-04 21:24

shambho

13-Oct-04 21:24

hi guys,

I am building a employee data base management system with lot of datagrid. Its basically a windows app. I am building the whole application in 3 tier architecture. I want to add a combo box to the datagrid. i got some sample from net. They are saying abt adding datagridTextcolumn in datagrid table styles. I tried adding that. No errors but not results i cannot see the combo box. how can i exactly put the combo box in the right cell. How can i map them i tried mapping properties but it does not work and will not work as i am filling dataset using a function in the wrapper class to get a dataset and setting this as the datasource to the grid. so how can i do that any ideas. is my question a bit confusing or vague. sorry for that. how can i do that plz tell me a neat way of doing that.

thanks in advance

anand

anand

Altering the word wrap in a multiline text box / rich text box

Jay Shankar13-Oct-04 20:50

Jay Shankar

13-Oct-04 20:50

I want to fix the line of 50 bytes (Or 50 characters) each in the text box.

I searched the info using Google. Unfortunately, I could not get any C# examples for achieving so.

Where as I could find some similar examples in VB, which are as below:

http://www.developerfusion.com/show/1052/

http://www.developerfusion.com/show/1052/

http://www.vbcity.com/forums/topic.asp?tid=79766

http://vbvbvb.com/jp/gtips/0701/gSendMessageEmSetwordbreakprocRepression.html

I need help in converting the code in C# or.
similar examples in C#.

Regards,

Jay

Desktop context menu?

ting66813-Oct-04 20:48

ting668

13-Oct-04 20:48

Hi~

Can I add item to "new" of the desktop context menu?

Thanks

rearange combobox

rolandf6913-Oct-04 20:19

rolandf69

13-Oct-04 20:19

Hi,

I can't figure out how the textbox 'knows' where to draw. Can I get a handle to that rectangle and 'move' it over?

thanks,
Roland

File Copy to network share

tmonte13-Oct-04 17:44

tmonte

13-Oct-04 17:44

Is there any way I can login to a remote machine from code to allow for a file copy?

If the folder is mapped and connected (entering username/password) it works fine copying to "\\server\share\filename" But if not, I get access denied exception.

Uniqueidentifier

pat27088113-Oct-04 12:19

pat270881

13-Oct-04 12:19

Hello,

I want to save the name of the company in the textBox2. The problem which occur is with the JobId. I will get the JobId number from a previous page as a string. Here I have quoted an example JobId. (the JobIds are saved in the database as uniqueidentifier). The Problem occurs in the ExecuteReader. I think it concerns that the parameter @JobId is of type uniqueidentifier and the the quoted jobId here is from type string. So it occurs a Data conversion failed. error.

jobId = "D4DF269F-F9FB-4C88-A005-11C98B38818A";

this.dataSource = "\\Program Files\\MobileHelpDesk.sdf";
this.strConn = "Data Source = " + dataSource;
this.connection = new SqlCeConnection("Data Source = " + dataSource);

SqlCeCommand command = new SqlCeCommand();
command.Connection = connection;

command = connection.CreateCommand();

command.CommandText = "SELECT c.CompanyName, c.ContactLName FROM Client c INNER JOIN JobDescription p ON p.EmailClient = c.Email WHERE p.JobId = ?";
command.Parameters.Add( "@JobId", jobId);

connection.Open();
drdrDB = command.ExecuteReader();

while (drdrDB.Read())
{
textBox2.Text = drdrDB["JobId"].ToString();
}
drdrDB.Close();
connection.Close();

Does anybody know how can I solve this problem or parse the jobId string in the corresponding type?? or is there another error? But the Select String is correct, I tried it in VS.NET.

thx

patrick

Re: Uniqueidentifier

Colin Angus Mackay13-Oct-04 13:42

Colin Angus Mackay

13-Oct-04 13:42

The parameter value needs to be a System.Guid[^] if the SQL Server type is a uniqueidentifier.

For example:

Guid jobGuid = new Guid(jobId);
command.Parameters.Add("@JobId", jobGuid);

Do you want to know more?

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Re: Uniqueidentifier

pat27088113-Oct-04 21:57

pat270881

13-Oct-04 21:57

Thank you very much, now it works!

patrick

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