| Is it possible to get the leftmost tab name of a Excel file? |
|
 |
Index ‹ DotNet ‹ ADO
|
- Previous
- 1
- Net Framework >> standard messaging in WinFormsHi,
I am a little confused about messaging system in .Net here is my question:
Each .Net windows form still contains a main loop that contains messages
sent to the window and it dispatches them, how can I send messages to this
loop?
I am looking for something like PostMesage(window.handle, message, lparam,
wparam) that used to work in win32.
Thank you
Vadim
- 2
- Visual C#.Net >> settings designer - can't find my typesI am setting up all my settings using the built-in settings stuff in Visual
Studio (though using my own provider to change the storage location/type for
the settings).
All goes well until i try to set the Type of one of my settings to something
that is in my current project. Types in the current project are not
displayed in the Select a Type dialog. All of the BCL types are displayed,
as well as types in some of my DLLs that i created and referenced in this
project. But not local types.
I tried just typing in the FQN of the type but it gave me an error message
that it is not a valid type.
Am i missing a setting somewhere? What would cause this? Or is this somehow
(<cringes>) by design?
Thanks in advance,
-Tim
- 3
- 4
- Dotnet >> Permission to Create a File in VB .NetWhen testing a VB .Net application on my system (with IIS installed) I get
an error message when using the fileopen function and the file does not
exist ... i.e. I want fileopen to create the file. The message I get is:
* * * * *
Access to the path "c:\inetpub\wwwroot\_private\(filename)" is denied.
The ASP.NET process is not authorized to access the requested resource. For
security reasons the default ASP.NET process identity is
'{machinename}\ASPNET', which has limited privileges. Consider granting
access rights to the resource to the ASP.NET process identity.
* * * * *
Now, HELP for the fileopen function says:
" When writing to files, an application may need to create a file if the
file to which it is trying to write does not exist. To do so, it needs
permission for the directory in which the file is to be created."
I do not understand how to give "permission for the directory" to an
application. If the file that fileopen addresses already exists everything
works OK.
Can someone help me understand how to give the appropriate permission such
that any user of the application will be able to create the file (if it
doesn't already exist)?
Thanks very much.
- 5
- Visual C#.Net >> Network programming bookCould someone please suggest me a good book to learn
network programming.
I have been programming in C#/VB.NET/VB 6.0 and have
also used a bit of C++ (not MFC/ATL/COM)
I am a total novice when it comes to networks and I don't
even know the basics.
I need a book which teaches me everything I need to get
started with programming in networks, I dont mind if the
book is not using C#/VB
thanks
- 6
- Visual C#.Net >> csharp version of cacls in VBScriptI am looking for the C# equivalent of invoking the CACLS command in
VBScript to set the permissions on a new user account HomeDirectory.
I think I'm close, but my permissions are listed under "Special
Permissions" in the folder's Security tab where the CACLS applied
permissions appeared in the main section of the Security tab.
Can anyone point me in the right direction to get the CACLS behavior in C#?
Using System.Security.AccessControl, I have gotten to this point where I
am making the call:
string strNtUser = String.Format(@"{0}\{1}",
strNtDomain, strUserName);
addACL(strHomeFolder, strNtUser,
FileSystemRights.FullControl, AccessControlType.Allow);
to the function:
private static void addACL(string path, string account,
FileSystemRights rights, AccessControlType type)
{
FileSecurity fs = File.GetAccessControl(path);
FileSystemAccessRule fsaRule =
new FileSystemAccessRule(account, rights, type);
fs.AddAccessRule(fsaRule);
File.SetAccessControl(path, fs);
}
Thanks.
JK
- 7
- 8
- ADO >> MI5 Persecution: Stand up for Free Speech 14/8/95 (2083)From: rji@cheetah.inmos.co.uk (Richard Ingram)
Newsgroups: uk.misc
Date: Mon Aug 14 10:08:32 1995
Some cencorship loving bore wrote :
> In article <GEVANS.95Aug14094119@mvagusta.uk.tele.nokia.fi> gevans@mvagusta.uk.tele.nokia.fi (Gareth Evans) writes:
>
> His sysadmin is also next to useless, and has not replied to my request or
> even acknowledged it. Maybe this person *is* a sysadmin?
>
> He's not. It seems the public access site he uses has got no proper
> management over its users. Here's a copy of a reply I got from a
> complaint I made. [After returning every one of Corley's postings to
[snip a large pile of winging complaining drivel]
Geez what a bunch of tossers you all are - you don't like someones postings so
you try and get him evicted from the net, why not just use a kill file - you
DONT have to read his posts/threads now do you ?
Why is it the net is getting populated by the biggest bunch of self absorbed
little Hitlers ? You don't like someones posts so you bloody complain or mail
bomb them - grow up you bunch of fucking sad gits !
Richard.
2083
- 9
- Microsoft Project >> Increasing the Number of Tiers in a GANNT ChartHi,
Is there a way to increase the number of tiers on the timeline in a
GANNT chart?
I wish to have a breakdown of years, quarters and weeks.
Cheers,
Rob.
--
robert32
------------------------------------------------------------------------
robert32's Profile: http://forums.techarena.in/member.php?userid=36536
View this thread: http://forums.techarena.in/showthread.php?t=864910
http://forums.techarena.in
- 10
- Visual C#.Net >> Whats LinkedListNode<>?When I create a LinkedList<> what is a LinkedListNode compared to a value?
AddFirst(54) for example, does it turn 54 into a node or what? I'm trying ot
find out what the LinkedListNode is specifically for? Basically just a
wrapper around the reference type?
- 11
- Visual C#.Net >> [Q] Interop: Pointer to structure in interface methodI have COM-object with Iface interface:
typedef struct
{
...
} TStruct;
[
object,
uuid(...)
pointer_default(unique),
local
]
interface Iface : IUnknown
{
TStruct* getDataPtr();
}
Question: how can i use this object in .Net?
For wrappers
[StructLayout(LayoutKind.Sequential)]
public struct TStruct
{
...
}
[Guid("..."), InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
public interface Iface
{
TStruct getDataPtr();
}
Tlbexp output is following:
[
odl,
uuid(...),
version(1.0),
oleautomation,
custom(..., ...)
]
interface Iface : IUnknown {
HRESULT _stdcall getDataPtr([out, retval] TStruct * pRetVal);
};
Many Thanks!
- 12
- Dotnet >> SocketHallo
Is there anybody able to tell me if and how to restore a lost socket
communication?
I try to explain.
Computer A and computer B are net connected and they estabilished a socket
connection. A (which acts as a server) is waiting for data from B and,
while waiting, it sends a "ping" character to B, in order to verify is the
connection is active.
Desconnecting the net cable, the "ping" character sending generates an
exception, as you can rightly presume that to connetion is no more active.
So far so good.
The problem is that re-connecting the net cable, the "ping" character
sending generates the same exception, just as if the lost communication
couldn't be recuperated unless you do a new call. Any idea or suggestion?
Thanks anyhow.
VV
- 13
- Visual C#.Net >> IE Intranet zone > Require server verification ... How to check programaticaly ?Hello,
I am dealing with security zones in Internet Explorer.
I know how to add websites programaticaly to the intranet zone (using
IInternetSecurityManager::SetZoneMapping).
But do anyone know how to check/uncheck programaticaly the "Require
server verification (https:) from all sites in this zone" ?
I looked all over MSDN, but do not find a function dealing with this
...
Thanks,
Guillaume BRAUX
- 14
- Dotnet >> UrlAllowList does not work when opening helpfile from .NET appBackground:
Since Microsoftâ??s security update 896358, security update 840315 or Windows
Server 2003 Service Pack 1, you can not longer open and see topic content in
help files on the network. This is true even for files in shared folders on
local intranet and even if the user has enough previliges to open the help
file it self. This is because help files indirectly could open active content
that is placed in some other unsecure location.
However, there is two known workarounds for this problem. One is to set the
MaxAllowedZone under the HTMLHelp\ItssRestrictions key in local registry.
Problem:
When launching a HTMLHelp file through .NET code and the Help.ShowHelp
method and setting the MaxAllowZone = 1, all works fine. But when using
UrlAllowList this does not work. But when opening helpfile directly from
Windows UrlAllowList all works fine.
Why doesn't UrlAllowList work from .NET app?
- 15
|
| Author |
Message |
Gabriella7772
|
ADO >> Is it possible to get the leftmost tab name of a Excel file?
Is it possible to get the leftmost tab name of a Excel file using ado.net?
Thanks,
DotNet77
|
| |
|
| |
 |
| |
|
Index ‹ DotNet ‹ ADO |
- Next
- 1
- Microsoft Project >> Update Task ProgressI am a beginner in using Microsoft project and project server (2007).
My questions are as below:
1. I did create 2 user in PWA(Project Manager(PM) and Team member (Mr. A)).
PM publish a project schedule to PWA which all tasks in the project asssigned
to Mr. A. How Mr. A check his task and update the % of work complete?
-I tried login as Mr. A and I only found those tasks can add into "My Time
Sheet" but not in "My Task". The button in "My Task" to import time sheet was
disabled.
2. How PM track the project status?
-I tried use local MS Project 2007 connect to server then goto Collaborate>
Request Progress Information but seem no different from the baseline plan
compare with the actual progress.
- 2
- Visual C#.Net >> how to do thatHi all...
I know this isn't the right place for that but i'm with this problem..
I work in a hospital and need to make a program that counts the amount
of people interned per day. I have in a mysql database the day that the
person interned and the day that it leaves.
tHow can I count that the person is interned in the middle days??? I
need to make a graph of that.
Some ideas???
*** Sent via Developersdex http://www.developersdex.com ***
- 3
- Net Framework >> CLR Shared Memory, C# DLL loadCLR Shared Memory, C# DLL load
How to share memory between CLR calls to the same C# dll? Is there some way
to know in the C# dll when the dll is loaded? Is the dll reloaded each tiem
a method is called from SQL Server or is the DLL loaded once when the C# dll
is added to sql server with CREATE ASSEMBLY?
I wold like to be able to share memory accross calls to methods on the same
C# dll is why. e.g. a Shared ArrayList or a shared Hashtable.
- 4
- ADO >> Connection StringsHi
Trying to sort out how to implement the use of connection strings with our new .Net Data Acces Layer(DAL).
2 solutions have been propoesed. Both suggest storing the connecion string in the machine.config file. The DAL uses SQLCleint namespace. At this stage there is only one SQL data store(with multiple data bases), but that might change in the future. Also, we are not using COM+ / Enterprise services, only manual transactions.
The 2 solutions differ, in that the first requires each part of the application to get the connection string, and pass it through every tier/layer (presentation, business, dalcs) to the DAL ...
The second solution makes it possible for the DAL to retrieve a named datasrouce from machine.config, and only DAL Components(DALCS which inherit the DAL) can specify a datasource.
If this makes any sense, can anyone suggest best of the two options, and why they think that? And if anyone has an even better solution to post that up would be great !
Cheers
Mike
---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
- 5
- ADO >> Bug with DataColumn.AutoIncrementSeedHi! I think I found a bug with DataColumn.AutoIncrementSeed. I tried to
communicate it via the Microsoft Feedback center, but after about half an
hour of trying to get through the feedback process without webforms breaking
down, I gave up.
The bug is: Under certain circumstances, the number to be automatically
incremented has a false value.
This is how to reproduce the bug (complete code below):
1) Call TestCode1(): an XML file TEST.xml is created in C:\
2) Call TestCode2() with a breakpoint in line
dr["Text"] = "Text2";
(= third to last line)
3) The new line created should have an ID of 1 (ID of existing line, which
is 0, plus 1); but it has an ID of 0.
With an AutoIncrementSeed of 1 (instead of 0), the problem disappears (the
two IDs are correctly numbered 1 and 2).
--Complete code:
private void TestCode1()
{
System.Data.DataSet ds = new DataSet("TestDS");
System.Data.DataTable dt = new DataTable("Test");
ds.Tables.Add(dt);
System.Data.DataColumn dc1 = new DataColumn("ID", typeof(int));
dt.Columns.Add(dc1);
dt.Columns[0].AutoIncrement = true;
dt.Columns[0].AutoIncrementSeed = 1;
dt.Columns[0].AutoIncrementStep = 1;
System.Data.DataColumn dc2 = new DataColumn("Text",
typeof(string));
dt.Columns.Add(dc2);
System.Xml.XmlDataDocument xmlTest = new XmlDataDocument(ds);
System.Data.DataRow dr = dt.NewRow();
dr["Text"] = "Text1";
dt.Rows.Add(dr);
dt.AcceptChanges();
xmlTest.Save("C:\Test.xml");
dr = dt.NewRow();
dr["Text"] = "Text2";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
private void TestCode2()
{
System.Data.DataSet ds = new DataSet("TestDS");
System.Data.DataTable dt = new DataTable("Test");
ds.Tables.Add(dt);
System.Data.DataColumn dc1 = new DataColumn("ID", typeof(int));
dt.Columns.Add(dc1);
dt.Columns[0].AutoIncrement = true;
dt.Columns[0].AutoIncrementSeed = 1;
dt.Columns[0].AutoIncrementStep = 1;
System.Data.DataColumn dc2 = new DataColumn("Text",
typeof(string));
dt.Columns.Add(dc2);
System.Xml.XmlDataDocument xmlTest = new XmlDataDocument(ds);
xmlTest.Load("C:\Test.xml");
ds.AcceptChanges();
System.Data.DataRow dr = dt.NewRow();
dr["Text"] = "Text2";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
Axel Hecker
- 6
- ADO >> Importing from a text file to a DatasetI have a large(1.25M), fixed field delimited, text file which I want to read into a DataSet. So, I opened a StreamReader, read a line, assigned the values to a new DataRow, and finally added the DataRow to a DataTable in the DataSet. Seemed to be a staight forward task but boy did it progress at a snail's pace!
So I tried to speed things up by first importing the data from the text file into SQL Server. To my amazement, the text import went like lightning! How can I get lightning fast text import?
Michael
- 7
- 8
- ADO >> Need suggestion: importing data into SQL ExpressI have an ASP.NET 2.0 website with a SQL Express database. I also have an
excel spreadsheet with alot of data on it. (If need be I can save it as a
CSV, XML, or whatever...)
I want the user to be able to import the data into an SQL Express database
(existing table) via a button on my ASPX page.
Do you recommend importing the data as XML into like a dataset, then
updating the SQL Express table with this dataset? If so, what's the easiest
way to update a table with an existing dataset? Additional
recommendations/suggestions appreciated...
Thanks!
- 9
- Microsoft Project >> HARD QUESTIONMy company and I wish to create an archive for storing all data from
previous projects. However, when I create a Consolidated Project it only
utilizes a shortcut to the projects. I'm wondering if there is any way to
load Project A into Project B such that Project A can then be deleted
(without deleting it from Project B). The way consolidating projects is set
up makes this impossible. If there is a way to load all information from
one project to another please let me know!! Even if it's long and
involved!! (I can make a macro) Thank you for your time and energy reading
this. please if you can help post a reply here or e-mail me at
Brian_Stebbins@yahoo.com
- 10
- Visual C#.Net >> Debugging assemblies: Forcing EXE to reload DLLWhen debugging an assembly, obviously a startup Exe file must be set.
I've run into a snag once in a while that appears to be caused by VS
referring to the Exe's *local* copy of the target DLL rather than the
one that has just been recompiled.
Is there an recommended method for ensuring that a newly compiled DLL
also gets copied over the DLL in the startup Exe's folder?
- 11
- 12
- Visual C#.Net >> Help with windows servicesI need direction on how to create a program that will start multiple windows
services. Each service will monitor a specific directory using
FileSystemWatcher. I have the file system watcher part working...but how
does one create multiple windows services??
Thanks
Jack David
- 13
- Winforms >> Getting Caret Position from another processDoes anyone know how I can get the caret position in terms of screen position
from the currently active window? By currently active window I don't mean
just mine, rather any window.
Basically the end result I want is to position a floating tooltip style
window next to wherever the user is typing (their caret) regardless of what
app they are using.
I've tried calling GetCaretPos, however this only seems to work when my app
currently has the focus. At all other times the POINT returned by
GetCaretPos is 0,0. I think this is due to other windows destroying their
Carets when they lose the focus.
Does any smart cookies out there have any ideas?
- 14
- Visual C#.Net >> Assign ado.net dataset to combobox?I have an app that I have been using this code to fill a datagrid:
DataSet ds = new DataSet("Recordset");
OleDbDataAdapter da = new OleDbDataAdapter();
// Call data adapter's Fill method to fill data from ADO
// Recordset to ADO.NET dataset
da.Fill(ds, rs, "tblTravelEventType");
// Assign data set to grid control
DropDownList1.DataSource = ds;
DropDownList1.DataMember = "tblTravelEventType";
But now I want to assign just one of the fields to the combobox1..
How can I do that? Can you give me an example?
Thanks,
Trint
- 15
- Winforms >> Save lines drawn in the picturebox as an lmageHave used DrawLine() method to draw some lines in the picturebox (sort
of a barcode) in the picturebox paint event.
This diagram has to be saved as an image in bmp or tiff format.
But the problem is that these lines are not recognized as the image o
the picturebox.
It shows picturebox.image = nothing.
How do we convert these lines drawn as the image of the picturebox so
that it can be saved.
Thanks for any help
--
Yas
-----------------------------------------------------------------------
Yash's Profile: http://www.highdots.com/forums/m177
View this thread: http://www.highdots.com/forums/t321621
|
|
|