|
Dave Kreskowiak wrote: He didn't say anything about using an Access database. He said "...to be able to access a database on my server."
Thank you for pointing that out
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
You didn't really specify what database engine you are using, and that impacts the answer. If it's Microsoft Access, you would need to place it on a shared drive on the server and use a UNC string for the database path (\\Servername\Sharename\path) part of the connection string (the user would also need read and write access to the share). For SQL server and other server base databases, you just need to specify the correct server in the connection string, and insure that the correct network client drivers were present on the client.
If you used ADO or ADO.Net and SQL server, you they will likely already be present. The connecting user will need to be a user known to the server if using windows authentication (either a domain member, or if a work group, have an account on the server with exactly the same username and password).
|
|
|
|
|
Sorry, responded to the wrong post - see my reply to Guffa below. He is incorrect, you can use Access on a server, with some reservations.
|
|
|
|
|
Rob Graham wrote: He is incorrect, you can use Access on a server, with some reservations.
Where am I incorrect? I explained how you could access the database file through the file system.
---
b { font-weight: normal; }
|
|
|
|
|
Use a UNC file path for DBQ/Data Source. As long as the user has read/write access to the server share, this works fine. (must also be either a domain user - so can authenticate - or have an account with excacty the same username and password on the workgroup server). I have used this sevreal times, and it works in ADO.NET or ADO.
|
|
|
|
|
Either you are replying to the wrong post again, or you didn't read my post before replying?
---
b { font-weight: normal; }
|
|
|
|
|
hey guys, How can i do compression in .net? I have i files i would to compress. I came acorss this project called SharpZip in C#. Its got a lot of functionality but its too complicated. Anything simpler. I just have a bunch of filenames in a string array that i would like to add into a single ZIP file.
|
|
|
|
|
I dont know exactly but, the way that I can say you, try to use windows api.
|
|
|
|
|
hey, thanks a lot. i ahve been googling like crazy for the past hour and i have come to realize that SharZIp is the best. It's tried and tested - no major bugs and it gives a lots of functionality.
|
|
|
|
|
If you are using 2.0 you could try the System.IO.Compression namespace
only two letters away from being an asset
|
|
|
|
|
Use the J# library
http://www.codeproject.com/csharp/vmeasyzipunzip.asp?df=100&forumid=39636&exp=0&select=1438491
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Use the Compression of .net2 or go use the sharplibzip of sharpdevelop
SharpZipLibLINK
Don't you also love the code?
|
|
|
|
|
Hi guys!
This is my method signature:public static string Translate(string translationCode, string culture, Dictionary<string, Dictionary<string, string>> input)
i would like to know how to access the value of the 'input' dictionary within the method?
e.g. if(input.ContainsKey(culture))
{
if(how do I check they 'key' of the inner dictionary?)
{
//use the value of the inner dictionary
then how would i access the value of the inner dictionary
}
}
I hope this makes sense. Thanks
|
|
|
|
|
I think this should work:
if (input.ContainsKey (culture)) {
Dictionary d = input [culture];
if (d.Contains (translationCode))
return d [translationCode];
return String.Empty;
} /ravi
|
|
|
|
|
Just apply every operation to the inner dictionary to input[culture] :
if(input.ContainsKey(culture))
{
if(input[culture].ContainsKey(innerDictionaryKey))
{
string theValueYouWant = input[culture][innerDictionaryKey];
}
}
|
|
|
|
|
Hi, this is a repost from earlier.
Using WinForms in VS2003 and a DataGrid, how do I control the *color* for individual columns / rows / cells. I don't see any properties in DataGrid, DataTable, DataView, or DataGridTableStyle.
Thanks.
|
|
|
|
|
Is this what you're looking for?
DataGrid grid = new DataGrid();
//First Row BackColor
grid.Items[0].BackColor = Color.Red;
//First Row First Cell
grid.Items[0].Cells[0].BackColor = Color.Green;
As for changing the column's color I think you need to loop though each row for a particular cell and change the color that way... I'm not really sure if there is a better way to do it.
e.g.
//Change Column color for first cell
foreach(DataRow row in grid.Rows)
{
row.Cells[0].BackColor = Color.Blue;
}
Cheers
Disgyza
Programmer Analyst
|
|
|
|
|
Hello Friends;
I use c# in .NET and use firebird embedded for database.I develop a program, but program doesnot run in any other computer, it gives this error :
http://erayince.com/error.jpg
Please Help!
Thanks
Best regards
|
|
|
|
|
Hi again;
If there anyone have such a problem;
solution is dont use stringbuilder. I use string builder instead of connectionstring
I solve it is as
string connectionString = "ServerType=1;User=SYSDBA;Password=masterkey;Dialect=3;Database=TAXI_TAKIP.FDB ";
c.ConnectionString = connectionString;
|
|
|
|
|
You could still use stingbuilder to build up the string:
c.conectionString = mystringBuilder.ToString();
|
|
|
|
|
Yes I used but when i used stringbuilder this application cannot connect to DB!
Do you think that what will be the problem
|
|
|
|
|
Perhaps if you posted the StringBuilder version of your code I could spot the problem...
|
|
|
|
|
Hi All,
I am a new programmer in .net and need some help from you..
I m using .net framework 1.1 and it has capability of sending only unauthenticated emails by using SmtpMail class..
The server on which my site is running uses authenticated email and I am unable to send email throgh C# script, because I can't enter username and password of the sender email...
So, is there any option to call a php file lying on any other server, to which we pass some variables and it will send the email...
or
Do you have any other ideas..
I hope you people certainly help me to find out the solution..
Thanks in advance.
Suman Singh
|
|
|
|
|
You could do a web request call to your PHP page. SMTP Authentication in .net 1.1 is non existent, however .net 2.0 is much improved.
have you considered creating your own SMTP client connecting to PORT 25
|
|
|
|
|
Hi!
I didn't test it, but according to this site you should be able to authenticate to a SMTP server in .NET 1.1.
Hope this helps.
|
|
|
|