C# Discussion Boards - CodeProject

Re: I should use what provider?

4-Jan-04 8:37

The Microsoft Jet provider is used to access .mdb files, which are commonly equated with Microsoft Access, though MS Access is not needed to create and use these .mdb files (it's just really handy, and I believe required for forms and reports manipulation).

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

Heath Stewart4-Jan-04 8:45

How to get list of Tables, Views and Procedure from Oracle database?

4-Jan-04 8:45

So what's the question? The Microsoft Jet provider for .mdb files doesn't support retrieving parameters from stored procedures, which really are only module functions.

If you need a real RDBMS, look into the Microsoft Data Engine (MSDE) at http://www.microsoft.com/sql/msde/default.asp[^]. This is Microsoft SQL Server with a few limitations, like the number of concurrent connections supported (10). Other than that, it supports true stored procedures, triggers, tables and views (of course), functions, and everything else that SQL Server supports. It is also freely redistributable so long as you have a valid license for a product that includes the MSDE, like Visual Studio .NET, Microsoft Access (I think), an MSDN Subscription, and several others things. It's also a free download.

You can install up to 16 instances of the MSDE and SQL Server (think of them as the same thing). Microsoft Access even supports direct access and designing with the MSDE if you still want to design your databases using MS Access.

Basically, though, you get a real RDBMS that is much faster and supports everything any other RDBMS like Oracle and DB2 does. It also supports output parameters in stored procedures and has better support in .NET using the System.Data.SqlClient namespace, which is written specifically for SQL Server and you don't have to guess at what is supported. System.Data.OleDb is based on OLE DB and uses abstract OLE DB providers that must provide some basic functionality, but don't have to provide any of the optional stuff.

For instance, in an article I wrote I use the Microsoft Indexing Service OLE DB provider. It only supports basic SELECT statements and views using an OleDbCommand. Period. No updates, no insertions, no transactions, no stored procedures. You're left to the will of the OLE DB provider.

god4k4-Jan-04 7:19

god4k

4-Jan-04 7:19

Hi, Guru
How to get list of Tables, Views and Procedure from Oracle database?

Thank You.

Re: How to get list of Tables, Views and Procedure from Oracle database?

Nick Parker4-Jan-04 7:52

Nick Parker

4-Jan-04 7:52

You can use the Oracle Data Provider for .NET[^]

- Nick Parker
My Blog

Re: How to get list of Tables, Views and Procedure from Oracle database?

Guillermo Rivero4-Jan-04 7:57

Guillermo Rivero

4-Jan-04 7:57

SELECT * FROM USER_TABLES
SELECT * FROM USER_VIEWS
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE'

Free your mind...

Feed CheckedListBox with data from XML

dophka4-Jan-04 6:37

4-Jan-04 6:37

I am writting a small application that works with remote server via http. My application sends a request and in return receives an xml file (i can access it via a string var.)

now I need to build a CheckedListBox with the data from this XML. Can someone suggest a simple way to arrange this and maybe give a sample?

my XML file looks like a lot of small containers that look like this (for each item):

<item>
<id>1</id>
<post_date>040104</post_date>
<subject>I posted a subject here!</subject>
<content>content is posted here</content>
</item>
<item>

I want to be able to build CheckedListBox with 4 rows: id, post_date, subject, content.

thanks a lot!

Alexander

Heath Stewart4-Jan-04 8:34

4-Jan-04 8:34

First of all, design your XML document to reflect alternatives which are more like siblings. Because you have a fragment like:

<items>
  <item>
    <id>1</id>
    <post_date>2004-01-03T00:00:00</post_date>
    <!-- and the rest -- >
  </item>
  <item>
    <id>2</id>
    <post_date>2004-01-03T01:00:00</post_date>
    <!-- and the rest -- >
  </item>
</items>

This implies that each item should be a separate row. This isn't absolute, but common. If you design your document like this, you could actually use DataSet.ReadXml and create a DataSet which is easily bindable to a CheckedListBox.

If you want to use your schema that you posted, you'll have to parse the XML document manually and create an IList or IListSource implementation. The easiest way would be to use an ArrayList, which implements IList. You can then use this object with the CheckedListBox.DataBindings property (if memory serves me correctly), or enumerate the list and add each item to the CheckedListBox.Items property. If you use the latter method, you can forego the ArrayList and just add the different XML elements to the CheckedListBox.Items property in the first place.

For information on multi-column CheckedListBoxes, see the CheckedListBox.MultiColumn property documentation, which inherits from the ListBox control class.

dophka4-Jan-04 8:46

4-Jan-04 8:46

well, my XML file looks like what you have shown above: all <item></item> are stored withing one <news></news> so it looks like:

<news>

<item>

</item>

<item>

</item>

</news>

I made a mistake, I want to show the data in a datagrid, not a checkedlistBox. The problem is that this XML is actually a string...

I created a new dataset. how can I make dataset.ReadXml() read from a string?

many-many thanks!

Alexander.

Heath Stewart4-Jan-04 8:52

4-Jan-04 8:52

dophka wrote:
I want to show the data in a datagrid, not a checkedlistBox.

Good, a DataGrid is easier to data-bind since you only have to use the DataSource property. You should also consider using the DataMember and TableStyles properties. See the SDK documentation for details or play around with the designer in VS.NET a little. It's not too difficult.

dophka wrote:
I created a new dataset. how can I make dataset.ReadXml() read from a string?

You'll need to read the fragment as a TextReader unfortunately. Let's say your XML fragment is in a string variable named xml:

StringReader reader = null;
DataSet ds = null;
try
{
  reader = new StringReader(xml);
  ds = new DataSet("news");
  ds.ReadXml(reader);
}
finally
{
  if (reader != null) reader.Close();
}

dophka4-Jan-04 9:07

4-Jan-04 9:07

thanks a lot for your explanations!

how I have done reading the xml thingy and I am sorry for asking, but then what? do I create another dataSet, add columns and then fill it with the data from the dataset that grabbed the xml content?

can you please please please walk me little further?

thanks!

Alexander

Heath Stewart4-Jan-04 9:11

4-Jan-04 9:11

I'm the kind of guy that would rather teach a man to fish than give him a fish. So, read the documentation for the DataGrid. You already have your DataSet, so you assign that to the DataGrid.DataSource property and set the DataGrid.DataMember property to the table name you want to bind to. Columns are automatically created for each column of that table, but you can control this with the DataGrid.TableStyles property.

Try doing all this in VS.NET using the designer. Create a new DataSet schema then use the Data toolbox to add a new DataSet object. Add a DataGrid to your form or control and play around with some of the properties. Reading the documentation will fill in the details, which are important to understand.

There are also many great articles on data-binding here on CodeProject. Just use the search box toward the top and use generic terms like "DataSet" or "DataGrid". I'm sure you'll find plenty.

Besides, going into any great deal really isn't meant for the forums. With all the possibilities, this is better discussed in an article. Always be sure to read the documentation, though. It should be your first stop for any questions.

dophka4-Jan-04 10:25

4-Jan-04 10:25

it seems to be helping a lot! Smile | :)

I finally made the grid how my data and feel very happy about that. I tho have a couple of last (you wish Smile | :)

) things to ask (something I didn't yet find in the properties):

when the grid comes out it has four columns as expected but how do I make them fill all the space horizontally? the actual grid sits in the left upper filling only about 50% of vertical space.

when the text in a column does not fit the grid window horizontally, is there a way to make it put it into a new line? like excel does it? o.w. avoid horizontal scroll bar?

and again - thanks a lot!

Alexander...

Heath Stewart5-Jan-04 6:05

help me in finding objective and multiple choice questions

5-Jan-04 6:05

dophka wrote:
(something I didn't yet find in the properties)

Don't be a drag-n-drop programmer - read the documentation for the DataGrid You'll find a lot more is possible than what the properties provide (some properties are browsable in the designer, and then there's all the methods that you won't see...)

dophka wrote:
when the grid comes out it has four columns as expected but how do I make them fill all the space horizontally?

This is perhaps the biggest problem with the DataGrid. There's really nothing you can do but resize the column programmatically. I'm sure I've seen a couple articles on this here on the CP site. Just try a search.

dophka wrote:
when the text in a column does not fit the grid window horizontally, is there a way to make it put it into a new line? like excel does it?

First of all, you must understand that Excel is a spreadsheet control - not a grid (just so you don't get any other crazy ieas in your head! Smile | :)

)

Second, you can create a custom DataGridColumnStyle class that allows you to edit text in multiple lines, but the display of the values is dependent on the DataGrid. To my knowledge, there is no way to get the text to display in multiple lines when not in edit mode.

imran_rafique4-Jan-04 4:29

imran_rafique

4-Jan-04 4:29

can any body tell me link where can i find objective question related to asp.net and csharp

r00d0034@yahoo.com

Re: help me in finding objective and multiple choice questions

Heath Stewart4-Jan-04 8:23

4-Jan-04 8:23

What do you mean? Are you asking where you can ask a question about an object for ASP.NET and C#? You can ask here or in the ASP.NET forum - see the links above.

The word "objective" means that a statement is not biased in any way. For a question, this really doesn't make any sense.

Sending mail using SMTP

gr8tushar4-Jan-04 1:47

gr8tushar

4-Jan-04 1:47

Hi All,
here is a code snippet from my mail program.

SmtpMail.SmtpServer = "localhost";
SmtpMail.Send (myemail);

myemail is an object of MailMessage.

If i run this program for the first time in Visual Studio there is an error saying CDO.Message is not accessible.

When it runs all the mail messages are stored in c:\inetpub\mailroot\queue
they do not reach there destinatin. They all are stored in my computer only.
Please someone tell me how to solve this.
WIll be eagrly waiting for the answer.

Mike Ellison4-Jan-04 3:11

Mike Ellison

4-Jan-04 3:11

Can you post the details of how you're setting up myemail? Make sure the From property is set. Also, use a try/catch block to capture the exception and look for InnerExceptions. An InnerException may give more details as to the nature of the problem.

gr8tushar4-Jan-04 3:43

gr8tushar

4-Jan-04 3:43

Thanx for replying!
i have used this code ..

private void button1_Click(object sender, System.EventArgs e) {

MailMessage myemail = new MailMessage();
myemail.From ="Tushar";
myemail.To ="a_tushar@hotmail.com";
myemail.Subject ="Test";
myemail.Body ="How are you ";

System.Web.Mail.SmtpMail.SmtpServer = "localhost";
System.Web.Mail.SmtpMail.Send (myemail);

}

using this all my mails are stored on my computer only they are not being delivered at a_tushar@hotmail.com

Broken God4-Jan-04 5:59

Broken God

4-Jan-04 5:59

Well, the from should be an e-mail address.

Heath Stewart4-Jan-04 8:18

4-Jan-04 8:18

This isn't his problem. As Mazdak said, we answer his question several days ago. His problem is that he hasn't configured the SMTP Virtual Server in the Internet Information Manager. I gave him pointers how to get started and told him to read the help, but he obviously hasn't.

Mazdak4-Jan-04 5:08

Mazdak

4-Jan-04 5:08

We answer you some days before. Look at those links and see how you should send email by C# and stop reposting the same question please.

Mazy

No sig. available now.

Heath Stewart4-Jan-04 8:21