|
Hi,
On my local machine, I have developed a c# application which reads from a sql server express database.
Now I want to install these (The application and the sql server express) on the client machine.
On the client machine, with the login I have, I can only have access to the U drive.
Questions:
1- Can I install the appplication on the U drive or does it have to be the C drive?
2- I also have to install the sql server express on the client machine. Can It be installed in the U drive?
3- The application has a config file which is used to access the sql server i.e. ./sqlexpress, etc...
What should the config file path be if both the application and the sql server express are installed in the U drive?
Thank you
|
|
|
|
|
You can install the application where ever you would like, however, there may be components, especially with SQL Express that will require administrator rights.
The connection string for SQL Express would be .\SQLExpress, where the dot is shorthand for local.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Yes, the installation of sql server requires the admin rights but does it have to be installed locally into c drive or can I point it to u drive?
Thanks
|
|
|
|
|
Once again, you can install the application anywhere. That includes SQL Express, it will default to the c: but you can change that.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Once I install the sql server express on the U drive, then will I be able to access the management studio window from any machine which does not have sql server express installed in it's c drive?
Thanks
|
|
|
|
|
|
No.
Every PC that is going to manage that database with the management studio has to have the studio installed. You cannot just install the studio once and run it from anywhere. There are more than a few components that have to be registered on each PC that's going to run the management studio.
Once the studio is installed, you can manage the database on the U: drive.
|
|
|
|
|
If you have the administrator right you can instal at any drive.
|
|
|
|
|
|
how can i creat a report button for databse i have in c#
|
|
|
|
|
I think a little more information is needed. What do you mean by report button? a button that you click and see a ssrs report? or a report built from gridviews? or crystal?
Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.
|
|
|
|
|
Add a button to your form.
Caption it 'Report for Database'.
Add an event handler that creates a report.
(Seriously, you need to at least make the effort to determine what your problem is. No-one is going to write a reporting system for you.)
|
|
|
|
|
|
Hi,
I have field in database and it is defined as Varchar(max).
And in the front in ADO.NET I am trying with the options
AddParamToSQLCmd(sqlCmd, "@Comments", SqlDbType.VarChar, -1,
ParameterDirection.Input, pArg.Comments);
SqlDbType.NVarChar, -1
SqlDbType.VarChar, -1
SqlDbType.NText, -1
and nothing seemed working. I am trying to insert over some 48000
charecters but it is storing only 43500 some charecters. Not sure if I
am missing some thing. Am I doing it right or can some one please help
me how to get around this issue.
Thanks in advance
L
|
|
|
|
|
|
I tried with the Text but the same thing it can't store more than 43567 charecters. I also tried updating the Text database field that I just created for testing in the management studio but no luck. For some unknown reason it is storing only 43567 charecteros of text.
Any inputs towards fixing this issue is greatly appreciated.
Thanks,
L
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: Varchar max is 8000, Nvarchar is 4000. If you need more than that use text.
Both of those links specifically mention 'varchar(max)' which takes 2 gigs.
And the OP is already successfully storing more than 8000 as well.
|
|
|
|
|
Huh, never actually noticed. I could have sworn MAX was a synonym for 4000 and 8000 respectively. Learn something new everyday.
|
|
|
|
|
|
Don't change the type around.
Isn't there a way to set the parameter without specifying a size? (I can't find a reference to 'AddParamToSQLCmd')
> but it is storing only 43500 some charecters.
Specifically, and in detail, how did you determine that?
|
|
|
|
|
Hi
I am learning C# from the microsoft "Visual C# 2010 step by step". It seems good but I have got stuck on one example which I have attached to the bottom. The code works but I don't know how. It creates a class called point which holds an x and y o-ordinate. It then offers a method calle distanceTo whoch calculate the distance between the current objects x and y values and another objects x and y values. Dead easy but in the distance method there is a line which says
int xDiff = this.x - other.x;
Where other.x is the x value from the point object passed into the method and this.x is the x value of the current object . Since x is defined as private in the method how does the c compiler know about the data in the other.x field though ?
Any ideas ?
Cheers
Dave
Here is the code, the method first followed by the calling program ....
#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
#endregion
namespace Classes
{
class Point
{
private int x, y;
private static int objectCount = 0;
public Point()
{
this.x = -1;
this.y = -1;
objectCount++;
}
public Point(int x, int y)
{
this.x = x;
this.y = y;
objectCount++;
}
public double DistanceTo(Point other)
{
int xDiff = this.x - other.x;
int yDiff = this.y - other.y;
return Math.Sqrt((xDiff * xDiff) + (yDiff * yDiff));
}
public static int ObjectCount()
{
return objectCount;
}
}
}
-----------------------------------------------------------------------------
#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
#endregion
namespace Classes
{
class Program
{
static void DoWork()
{
Point origin = new Point();
Point bottomRight = new Point(1024, 1280);
Point one = new Point();
double distance = origin.DistanceTo(bottomRight);
Console.WriteLine("Distance is: {0}", distance);
distance = bottomRight.DistanceTo(origin);
Console.WriteLine("Distance is: {0}", distance);
Console.WriteLine("No of Point objects: {0}", Point.ObjectCount());
Console.ReadLine();
}
static void Main(string[] args)
{
try
{
DoWork();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
|
|
|
|
|
The 'other' Point is passed as a parameter to the DistanceTo Method
like this
public double DistanceTo(Point other)
{
int xDiff = this.x - other.x;
int yDiff = this.y - other.y;
return Math.Sqrt((xDiff * xDiff) + (yDiff * yDiff));
}
and it is called with an instance of the point class like this
double distance = origin.DistanceTo(bottomRight);
So the compiler will know the value of 'other' point's x and y co-ordinates.
...and I have extensive experience writing computer code, including OIC, BTW, BRB, IMHO, LMAO, ROFL, TTYL.....
|
|
|
|
|
Partially correct, but I think Dave has understood the part you have explained.
Richard's answer explains what is missing from your answer which is that the private members of a class are available because the passed in object is of the same type.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
First an instruction: please use <pre></pre> tags around your code to make it readable; use the "code block" button in the editor.
Second an answer: although the x fields are private they are accessible to any method of the class, and since other is an object of the same class then the DistanceTo() method can access it.
|
|
|
|
|
Because DistanceTo is a member of the Point class.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
