C# Discussion Boards - CodeProject

First Prev Next

Re: Retrieve data from AR REmedy ODBC server

Praveen Raghuvanshi12-Oct-09 20:39

Praveen Raghuvanshi

12-Oct-09 20:39

Thanks, still I have some query.

I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).

- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?
- Is there a manual way to fetch data in C# rather than using the APS's?

Thanks,
Praveen

Praveen Raghuvanshi
Software Engineer,

India.

Re: Retrieve data from AR REmedy ODBC server

Dave Kreskowiak13-Oct-09 2:48

Dave Kreskowiak

13-Oct-09 2:48

Rags1512 wrote:
I tried to fetch data from the database using MS Excel and it worked fine. Also, tried with VB, the results are as expected. It fails/retrieves less no of records with the queries using OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0).

Like I already said, don't use ODBC.

Rags1512 wrote:
- How to set a timeout value for the query execution so that the application does not hang? i.e how to avoid execution of OdbcDataAdapter.Fill() and OdbcDataReader.GetString(0)?

I hate repeating myself.

Rags1512 wrote:
- Is there a manual way to fetch data in C# rather than using the APS's?

Whatever you mean by "APS", no.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

C# SharePoint Folder / Subfolder list collection

Wheels01212-Oct-09 4:08

Wheels012

12-Oct-09 4:08

Good morning.

I was wondering if there was an easy way to access the list of folders and subfolders from a SharePoint site.

I have the following so far:

namespace SharePoint_Tree
{
    public partial class _Default : System.Web.UI.Page
    {

        //public static void Main()
        //{
        //}

        protected void Page_Load(object sender, EventArgs e)
        {
            teamspace.Lists tsl = new teamspace.Lists();
            tsl.Credentials = CredentialCache.DefaultCredentials;
            XmlNode resp = tsl.GetList("Content and Structure Reports");
 
            this.Response.Write(resp.OuterXml);

        }
    }
}

Thank you, WHEELS

Re: C# SharePoint Folder / Subfolder list collection [modified]

Henry Minute12-Oct-09 4:40

Henry Minute

12-Oct-09 4:40

You might get more response if you post this in the SharePoint forum. here[^].

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

modified on Monday, October 12, 2009 10:46 AM

Re: C# SharePoint Folder / Subfolder list collection

Not Active12-Oct-09 4:49

Not Active

12-Oct-09 4:49

Wheels012 wrote:
an easy way to access the list of folders and subfolders from a SharePoint site.

Yes there is, ask in the correct forum and you might get an answer, or be told it's so simple it should take about 30 seconds to Google it.

only two letters away from being an asset

How to select map with opendialog

Aljaz11112-Oct-09 3:47

Aljaz111

12-Oct-09 3:47

Is there any option to select only path of map not files in it with open dialog?

Thanks,
Bye

Re: How to select map with opendialog

Luc Pattyn12-Oct-09 3:48

Luc Pattyn

12-Oct-09 3:48

No, however there is a FolderBrowserDialog Class

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: How to select map with opendialog

Aljaz11112-Oct-09 4:43

Aljaz111

12-Oct-09 4:43

Thanks a lot;)

SNMP

deviao12-Oct-09 3:11

deviao

12-Oct-09 3:11

Hi there,

I am looking to create an application that uses SNMP to map a basic network, however i have never used SNMP and am struggling to implement it - i am not quite sure where to start.

I have read numerous articles about SNMP on the web ranging from the basics to the defined RFC's as well as example code and i am still completely in the dark. I get the idea of how SNMP works using managers and clients, OIDs, Mibs etc but have no idea how to go about it with C# code.

Could someone please assist me!

Kind Regards,

Re: SNMP

harold aptroot12-Oct-09 3:31

harold aptroot

12-Oct-09 3:31

Well it "runs" over UDP right, so I guess you could just use an UDP socket?
I've never used SNMP though so maybe I'm completely missing the point..

Default file image

gwithey12-Oct-09 2:38

gwithey

12-Oct-09 2:38

Does anyone know if there is a way of getting the default image of a file to show in a file browser.

ie .txt image will be notepad etc.

Is there a way of finding this from "System.io.DirectoryInfo" or is there some other way i could retrieve this name.

I can then display the correct type of image for the file in my browser
)

UI.Entry(Image.FromFile("FolderFull_125x125.png"

Thanx George

Re: Default file image

Ian Shlasko12-Oct-09 2:50

Ian Shlasko

12-Oct-09 2:50

First google link: Get Registered File Types and Their Associated Icons in C#[^]

Proud to have finally moved to the A-Ark. Which one are you in?
Developer, Author (Guardians of Xen)

Re: Default file image

freakyit12-Oct-09 2:50

freakyit

12-Oct-09 2:50

hi,

try to extract the icon from the file with

System.Drawing.Icon.ExtractAssociatedIcon("log.txt").ToBitmap()

you can save the image to file with bitmap.Save("log.txt.png")..

hope i could help Smile | :)

Re: Default file image

Luc Pattyn12-Oct-09 2:56

Luc Pattyn

12-Oct-09 2:56

I don't think so, the OP wants the icon associated with a file, not an icon from within the file.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: Default file image

gwithey12-Oct-09 3:34

gwithey

12-Oct-09 3:34

bm = System.Drawing.Icon.ExtractAssociatedIcon("@C:\WINDOWS\system32\notepad.exe").ToBitmap();

This line does get the correct image thank you just dont know how to find all the others as the focused file is changed.

Re: Default file image

Henry Minute12-Oct-09 4:44

Henry Minute

12-Oct-09 4:44

http://www.codeproject.com/KB/cs/GetFileTypeAndIcon.aspx[^]

Connect to a remote MySql DB

SummerBulb12-Oct-09 2:28

SummerBulb

12-Oct-09 2:28

Hi,

i have a c# application that connects to a remote MySql database.
The application is meant for a windows 2003 server.
I have a refference to mySql.Data in my app.

What do i need in order to get the application to connect to the database?

Thanks!

Re: Connect to a remote MySql DB

stancrm12-Oct-09 2:31

stancrm

12-Oct-09 2:31

http://www.connectionstrings.com/mysql[^]

Re: Connect to a remote MySql DB

SummerBulb12-Oct-09 2:38

SummerBulb

12-Oct-09 2:38

I don't know why, but copying the dll (MySql.Data.dll) to the location of the application did the trick.

I'll apreciate an explaination...

Thanks again.

Re: Connect to a remote MySql DB

stancrm12-Oct-09 2:46

stancrm

12-Oct-09 2:46

If you just want to use MySql.Data.dll, you can set "CopyLocal = true" in reference property. Then the MySql.Data.dll will be copied automatically to Debug or Release directory. You can distribute it. To connect to remote DB, then what you need is connectionstrings.

thread problem

Member 59031012-Oct-09 2:06

Member 590310

12-Oct-09 2:06

hw can i suspend and resume thread.

Re: thread problem

stancrm12-Oct-09 2:14

stancrm

12-Oct-09 2:14

From MSDN : "Thread.Suspend has been deprecated. Please use other classes in System.Threading, such as Monitor, Mutex, Event, and Semaphore, to synchronize Threads or protect resources. http://go.microsoft.com/fwlink/?linkid=14202"

http://msdn.microsoft.com/en-us/library/ms173179.aspx[^]

paging in Sharepoint document library

Sudhir Mangla12-Oct-09 1:11

Sudhir Mangla

12-Oct-09 1:11

Hi

I have a client requirement that we need to implement paging in sharepoint document library.

For instance in some cases document library contain 100 or more files in such cases we need to implement paging.

Can any one suggest any solution that can be implemented easily using jquery or server side code.

Any help in this case will be appreciated.

Sudhir Mangla

http://tips.DevelopersVoice.com
(Technical Tips and Tricks)
http://Programmerworld.net
(Free books and source code)
http://Faq.Programmerworld.net
(FAQ and Tips for programmers)

http://health.Programmerworld.net
(Health tips)

Re: paging in Sharepoint document library

Not Active12-Oct-09 1:35

Not Active

12-Oct-09 1:35

Don't spam the forums looking for an answer. This is clearly a SharePoint related question that should not have been asked here. Mad | :mad:

only two letters away from being an asset

Connect to mapped network drive

musefan12-Oct-09 1:05

musefan

12-Oct-09 1:05

Hi All,

I have an application (Win Forms) that amongst other things downloads files from a server. This is done with the use of a mapped network drive.

The problem is sometimes the network drive will have a red cross (vista) to show it is not connected, it simply takes the user to double-click the desired path in order for it to connect. But if I try to access it through code while it is 'not connected' then it fails. All it takes is the user to double-click the drive and then the application will work again fine. But I don't want users to have to do this.

Basically, I want to know if there is a way I can check the connection status, and if need be, attempt to connect the drive before accessing the files. I don't want to un-map/re-map the drive each time either.

Thanks for any suggestions

Life goes very fast. Tomorrow, today is already yesterday.

Last Visit: 31-Dec-99 18:00 Last Update: 29-May-24 7:34

Refresh

ᐊ Prev 1...4222 4223 4224 422542264227 4228 4229 4230 4231 Next ᐅ

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