Database Explorer Query - C# Discussion Boards

First Prev Next

Re: C Sharp Login with different user privilege

Xonel10-Apr-12 23:19

Xonel

10-Apr-12 23:19

I was thinking of it this way...

    private void Form1_Load(object sender, EventArgs e)

    {
    if ((Thread.CurrentPrincipal.IsInRole("admin"))) // admin in this case should be a domain name.
    {
    tabPage4.Hide();
    }
    else
    {
        MessageBox.Show("You must be a member of the Manager or Administrator's roles to view username and password information", "Insufficient Permissions",
            MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
    }
}

But now instead of

CurrentPrincipal.IsInRole

put something that will read the domain name. Something of that sort.
I'll appreciate any help
Thank you

Adding Reference to Dll (Class Library ) & Using statements

Smith#9-Apr-12 21:09

Smith#

9-Apr-12 21:09

Hi,
I would like to know:
1.what happens when you add a reference to a Class library in dotnet.

2.Is it something like a "implicit" linking in C++?

3.Can I make the library statically link to the exe?

4.And does the dll in dotnet internally have implementation for DLLAttach, Detach?

Re: Adding Reference to Dll (Class Library ) & Using statements

Richard Andrew x6410-Apr-12 8:38

Richard Andrew x64

10-Apr-12 8:38

1. It is similar to compile-time linking in C++ in that the CLR automatically loads the library

2. A little bit.

3. No. The CLR takes care of runtime loading and linking automagically. You are not allowed to have anything to do with it.

4. All necessary runtime loading and linking is taken care of by the CLR.

The difficult we do right away...
...the impossible takes slightly longer.

Re: Adding Reference to Dll (Class Library ) & Using statements

Smith#11-Apr-12 2:16

Smith#

11-Apr-12 2:16

Thanks for the reply mate.
I'm trying to look into the internals of managed world.

The document says "CLR is hosted"? Does that mean CLR is per process stuff? is it not system wide?

Re: Adding Reference to Dll (Class Library ) & Using statements

Richard Andrew x6411-Apr-12 5:12

Richard Andrew x64

11-Apr-12 5:12

The CLR is 100% a user mode component. No kernel mode stuff at all.

Technically, the CLR maintains a single process space, and all .NET "processes" are segregated within that one process space. These are called Application Domains. The fact that they are really within the same process makes inter-application communication much simpler and faster.

The difficult we do right away...
...the impossible takes slightly longer.

Re: Adding Reference to Dll (Class Library ) & Using statements

Smith#11-Apr-12 21:34

Smith#

11-Apr-12 21:34

Thanks for the reply Richard.

I'm trying to dig a little deep into it but most of the links show up a blunt high level Block diagrams , explaining the stacks in the framework.

I need to a pointer to understand low level details of how CLR is invoked to deal managed Applications.

Anywhere you can point me to?

I want to know: When I execute a managed App, how does the OS route the exe to the CLR?

Or CLR is mapped to every process? If CLR hosts all the managed Apps as domains? then how does it over ride 4GB limit per process in a 32bit system?

Re: Adding Reference to Dll (Class Library ) & Using statements

Richard Andrew x6412-Apr-12 5:13

Richard Andrew x64

12-Apr-12 5:13

Yes, those certainly are important questions.

I'm not sure where to find such detailed information. Perhaps the MSDN blogs?

Good luck.

The difficult we do right away...
...the impossible takes slightly longer.

Database Explorer Query

mauricemcse9-Apr-12 12:38

mauricemcse

9-Apr-12 12:38

Working with Visual Studio 2008. My tutorial indicates that when a SQL database is created the solutions explorer changes to the database explorer.

The view changed on the first attempt but has not been seen since. Looking for guidance for troubleshooting if necessary. Or... was the view only shown first creation. Guidance sought

Re: Database Explorer Query

PIEBALDconsult9-Apr-12 14:27

PIEBALDconsult

9-Apr-12 14:27

Sounds like a Visual Studio question, not a C# question.

Re: Database Explorer Query

mauricemcse9-Apr-12 16:25

mauricemcse

9-Apr-12 16:25

Much thanks for your reply. Please know that I checked the discussion list and did not see Visual Studio. Woudld be so appreciative for a link.

* Just saw Visual Studio in this forum for the first time. Much thanks

Cordially,
mauricemcse

Re: Database Explorer Query

Richard MacCutchan9-Apr-12 21:09

Richard MacCutchan

9-Apr-12 21:09

It's the one bottom left titled "Visual Studio".

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: Database Explorer Query

Dave Kreskowiak9-Apr-12 14:40

Dave Kreskowiak

9-Apr-12 14:40

View menu -> Server Explorer.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Getting Higlighted/Selected Text in C#

Alchemist28899-Apr-12 0:06

Alchemist2889

9-Apr-12 0:06

I want to get the selected/highlighted text from any application through c#. I know one way to get it is to copy it to the clipboard. But what I want my program to do is that when I display an Hotkey(will decide later) the highlighted text should be displayed on console/Messagebox. Just like we see in applications like Wordweb.

Re: Getting Higlighted/Selected Text in C#

Bernhard Hiller9-Apr-12 23:36

Bernhard Hiller

9-Apr-12 23:36

Register a global hotkey. In the key down/up event, get the window handle of the respective window and send a WM_GETSEL message to it. Note: this may fail with Java swing applications.

importing RowName and ColumnName from an excelfile to a datagridview ...

nassimnastaran8-Apr-12 8:39

nassimnastaran

8-Apr-12 8:39

Hi All !
I want to Import an Excel File to a DataGridView as FirstRow (Except A1 Cell that's null)will be Column HeaderCell in DataGridView and First Column in Excel file (Except Cell of A1=null) will be Row HeaderCell in DataGridView .Here is my code :

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=YES;IMEX=1;""", openFileDialog1.FileName);
string query = String.Format("select * from [{0}$]", SheetName);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);

DataSet ds = new DataSet();

dataAdapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

int row = ds.Tables[0].Rows.Count;
int col = ds.Tables[0].Columns.Count;

for (int i = 0; i < row - 1; i++)
{
  dataGridView1.Rows[i].HeaderCell.Value = ds.Tables[0].Rows[i].ToString(); ;
}

for (int j = 0; j < col - 1; j++)
{
  dataGridView1.Columns[j].HeaderCell.Value = ds.Tables[0].Columns[j].ToString();
}

But I have some Problem for Header Column And Header Row .
Thanks For Any Help .

Re: importing RowName and ColumnName from an excelfile to a datagridview ...

Mycroft Holmes8-Apr-12 20:54

Mycroft Holmes

8-Apr-12 20:54

Importing via an OLEDB connection only works on a well formed excel file/table. If you are having trouble then it is highly likely that the excel file is crap (as usual). Throw a break point after the fill and see if there is some data.

Never underestimate the power of human stupidity
RAH

Re: importing RowName and ColumnName from an excelfile to a datagridview ...

nassimnastaran9-Apr-12 4:18

nassimnastaran

9-Apr-12 4:18

Thanks for your reply ,
Here is my file , pl z check it .
or :
www.4shared.com/rar/6WxLLxtL/ReadFromExcelFile.html
I've prob yet !
thanks!

Database Programming in WPF

TAN TH7-Apr-12 23:10

TAN TH

7-Apr-12 23:10

I understand that the Database data can be easily displayed in a grid in WPF, by clicking a table in the Data Sources windows and dragging it onto the form.

we can then click a cell to change its value.

Say, if we have a field say Quotation_Date, and when we want to change/edit that field at a certain row, I would want a Calendar control with DatePicker to appear, such that user can change the date for the Quotation_Date at that row, from the Calendar control. Is that possible?

Similarly, say if we have a field say Weather, and when we want to change/edit that field at a certain row, I would want a ComboBox to appear, such that user can select from the ComboBox collections (Rainy, Sunny, Stormy), and update it. Is that possible?

Third question. With its DataGridView displaying all items from the database, I would want to have a button Add New Item, such that when user click on that button, a second WPF form (new and empty) appears such that all those fields [Items_ID, Quotation_Date, Weather] would appear, and when user adds new items from the second form, thoes Calendar control and ComboBox control would also appears on the second form. When user clicks a Save button, it would close the second form and update its new item to the first form. Is that possible?

thanks.

Re: Database Programming in WPF

Mycroft Holmes8-Apr-12 0:07

Mycroft Holmes

8-Apr-12 0:07

1. Yes
2. Yes
3. Yes

All these are possible but if you expect to be able to just drag and drop controls onto a window it will not work. Before attempting this I suggest you get a book, or at least some tutorials, and work through the examples.

Never underestimate the power of human stupidity
RAH

Re: Database Programming in WPF

TAN TH8-Apr-12 20:32

TAN TH

8-Apr-12 20:32

yes, I have worked with those examples already. it seem that for those things which I needed, it is not trivial, especially putting those Calendar controls inside the editable fields. Could you give me some hints?

also, to update the database with new records from another new form, I have problems too.

Re: Database Programming in WPF

Mycroft Holmes8-Apr-12 20:50

Mycroft Holmes

8-Apr-12 20:50

TAN THIAM HUAT wrote:
it is not trivia

You are right it is not trivial, and yet you are asking for help in the most trivial of manners, a support forum. You questions are so wide in scope they cannot possibly be answered in a forum post.

If you are still at the drag and drop stage then you need to do a whole lot more work to make these structures and controls work.

Never underestimate the power of human stupidity
RAH

Re: Database Programming in WPF

TAN TH9-Apr-12 13:56

TAN TH

9-Apr-12 13:56

can you then suggest which website is more suitable for me to post my non-trivial questions then?

accessing image by bit in c #

waqar rashid7-Apr-12 21:56

waqar rashid

7-Apr-12 21:56

plz help me some one. I am trying to read images and after some operation then save image(8bit image or Gray scale image).

Re: accessing image by bit in c #