|
kjsl2k9 wrote: Is there any control or dll which can be used for showing map without using internet connection in .net
The problem you face is lack of Internet connectivty, the amounts of data in mappring are generally massive and costly to prepare by the provider. Google and Microsoft can do this for free due to economies of scale.
Yoiu will almost certainly not get anything for free, but there will be paid (and probably expensive) things you get for 3rd party suppliers.
Hopefully someone else will have a more positive response.
Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
|
I've got 2 connection strings:
1. "Data Source=.\SQLEXPRESS;
User Id=sa;Password=hello;
AttachDbFilename=C:\inetpub\wwwroot\MySite\dbs\MyDb.mdf;
Connect Timeout=30"
2. "Data Source=.\SQLEXPRESS;
AttachDbFilename=C:\inetpub\wwwroot\MySite\dbs\MyDb.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True"
2nd is working perfectly for db connection,
but using 1st returns that error:
System.Data.SqlClient.SqlException:
Unable to open the physical file "C:\inetpub\wwwroot\MySite\dbs\MyDb.mdf".
Operating system error 5: "5(Access Denied)".
An attempt to attach an auto-named database for file
C:\inetpub\wwwroot\MySite\dbs\MyDb.mdf failed.
A database with the same name exists,
or specified file cannot be opened,
or it is located on UNC share.
In SQL Server COnfiguration Manager I enabled all services
and protocols - SQL Server (SQLEXPRESS), SQL Server Browser,
Shared Memory, Named Pipes, TCP/IP, VIA.
In SQL Server Management Studio Express sa/hello user is present
and Server Properties->Security - SQL Server and Windows Authentication mode
If I put incorrect password in 1st connection string it reports password error.
Here is the code to connect to db and get some records just for a sake:
SqlConnection con = new SqlConnection(this.connection);
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
int nRows = da.Fill(ds, "Persons");
Чесноков
|
|
|
|
|
I am guessing that the Sql Server runs on a user which has no read/write access on the file specified by you in the connection string. When you use windows authentification and it works, probably you are logged on an administrator account or some other privilegiated user class.
I would start by checking the user that started the sql server (in task manager) an go check that file and all the intermmediate folders if that user has permissions.
I have no smart signature yet...
|
|
|
|
|
There is no sql server exe in task manager. It is running as a service.
I've got only 1 user with admin rights on PC and logged in as him while connecting with 1st and 2nd connection strings.
For that folder I set up RW access for all users. I also added that single user and set up RW access. But still the same error.
Чесноков
|
|
|
|
|
Probably in task manager you only see your user's processes (if so there's a button to show you all the processes).
The process name is sqlserv.exe an the service usualy start's or stops this process.
To test if what I said about the access rights is true, create on the root (c:\) a folder "test", and at security settings (of the "test" folder) grant full control to everyone (and by everyone I mean the special item in the search result named "everyone"). Copy you database file there (and grant full control to the file to everyone) and change you connection string to that folder. If you first connection string will work then my asumptions were correct, if not then you have another issue.
I have no smart signature yet...
|
|
|
|
|
It was NETWORK SERVICE and setting full access to it solved the problem.
Before I only enabled WRITE access, but only full access helped.
Чесноков
|
|
|
|
|
I am glad it worked
I have no smart signature yet...
|
|
|
|
|
Is it possible to show related rows(master/details) in one datagridview?
how?
|
|
|
|
|
|
Not with the OOB gridview. You would need a third party component such as Telerik or Infragistics that has the support built in, or derive your own
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
I've a datagridview with combobox and checkbox columns and would like to bind the datatable to the gridview. As per the data in datatable the items should get selected in the combobox. Please guide me. Thanks in advance.
|
|
|
|
|
Maybe this post here can help you.
|
|
|
|
|
Hi All,
I am working HTTPWebRequest to access the url and copy the data in other server database.
I am using the Threading concept here.
But the processing of threading is very slow.I am excepting the processing to 120/min but, it giving only 50/min processing.
Can you please help me in this case,how to increase the processing to 120/min.
Thanks in Advance.
JohnDas
|
|
|
|
|
Get a faster connection
Adding more threads does not guarantee increased performance, it can actually slow it do if not done properly.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
A colour palette column is required in datagridview. Where the user should have the privilege to select the his own color. Please let me know how to set that column. Thanks in advance
|
|
|
|
|
To create a control that you can host in a cell in editing mode, you can implement the IDataGridViewEditingControl interface in a class derived from Control.
you can find an example in msdn named:
Host Controls in Windows Forms DataGridView Cells
|
|
|
|
|
Hi all,
I have a button click event that is used to write a double used for offsetting another number in a form (ultimately to zero a display). Still struggling as a new user and having problem with an error:
'double WindowsApplication14.frmMain.btnZero_Click(object, System.EventArgs)' has the wrong return type
Here is the function:
private double btnZero_Click(object sender, EventArgs e)
{
dblOffset = dblReceive * -1;
return dblOffset;
}
Can anyone let me know what I'm doing wrong here?
Thanks.
|
|
|
|
|
you cant use return type for click event.
you should use void for click event.
the signature of method that you can use for click event is:
void methodname(object,EventArgs)
|
|
|
|
|
Do you have any suggestion for how I would get around this? Need to look at the current value of a double and then null it by clicking a button labeled "Zero". That is why dblOffset is equal to dblReceive * -1. I want to add dblOffset at that moment to dblReceive, which would then set dblReceive to zero.
Thanks.
|
|
|
|
|
I am having trouble figuring this out... even where to start. Basically I want to mimic the active directory browser. Listing all the OU's and their childs.
The hard part is I'm trying to do this backwards from what most people do I believe. What I have is a list of USERS and their DISTINGUISHEDNAME.
So:
I have a user:
CN=Jacob Dixon,OU=INFO TECH,OU=MAIN DIVISION,DC=company,DC=com
So what I did was:
string[] dn = usr.DistinguishedName.Split(',');
Array.Reverse(dn);
I then loop through each string ignoring EVERYTHING except for strings that start with "OU=". Anyone have an example on how to accomplish this?
I have tried something like this:
TreeNode root = new TreeNode();
TreeNode prev = new TreeNode();
foreach (string s in dn)
{
if (s.Contains("OU="))
{
string tmp = s.Replace("OU=", string.Empty);
if (string.IsNullOrEmpty(root.Text))
{
root.Text = tmp;
}
else
{
if (string.IsNullOrEmpty(prev.Text))
{
prev.Text = tmp;
root.Nodes.Add(prev);
}
else
{
TreeNode n = new TreeNode();
n.Text = tmp;
prev.Nodes.Add(n);
prev = n;
}
}
}
}
tvUsers.Nodes.Add(root);
It does the root and children but it also inserts duplicates.. (I know I'm not checking right now for duplicates). I'm just having a hard time figuring this out..
|
|
|
|
|
Hi,
In one of my tables I have a column with type char(1). When I used LINQ to SQL, this column was correctly mapped to "char" type but when using Entity Framework its being mapped to "String" type as opposed to "char".
Also there isn't seem to be an option in the Type drop down to select "char".
Can anyone shed some light on this matter?
|
|
|
|
|
I created a Windows Service that is installed on a server. Whenever any type of any error is thrown, the error is logged and the service stops.
Is there anyway to setup my try/catch to make sure the service continues to run after the error is logged?
static void Main(string[] args)
{
AppDomain currentDomain = AppDomain.CurrentDomain;
currentDomain.UnhandledException += new UnhandledExceptionEventHandler(currentDomain_UnhandledException);
#if !DEBUG
try
{
#endif
#if DEBUG
isDebugMode = true;
object debug = new object();
MessagingBroker(debug);
#else
ServiceBase.Run(new Program());
#endif
#if !DEBUG
}
catch (Exception e)
{
string msg = "Error: " + e.Source + "\r\n";
msg += "Message: " + e.Message + "\r\n";
msg += "Stack Trace: " + e.StackTrace;
sEvent = e.Source;
LogEvent(msg, EventLogEntryType.Error);
}
#endif
}
Thanks,
Joe Brislin
|
|
|
|
|
That doesn't look like a Windows Service to me.
|
|
|
|
|
It runs as a console application when in debug mode to help with programming and debugging but can also be installed as a Windows service.
|
|
|
|