Re: how to capture the event when the monitor close - C# Discussion Boards

Bulk insert data

anishkannan14-Dec-10 18:31

anishkannan

14-Dec-10 18:31

HOw can do to insert a bulk data to Oracle database ( Store procedure ) using c#

Thanks

Re: Bulk insert data

Abhinav S14-Dec-10 18:39

Abhinav S

14-Dec-10 18:39

This[^] article may help.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Visit the Hindi forum here.

Re: Bulk insert data

RaviRanjanKr14-Dec-10 18:51

RaviRanjanKr

14-Dec-10 18:51

Navigate the Given link
Bulk Operations Using Oracle Data Provider for .NET[^]

Hope it will works for you.
Smile | :)

Re: Bulk insert data

anishkannan14-Dec-10 19:18

anishkannan

14-Dec-10 19:18

Thanks for Reply...

Is it possible to achieve without using ODP.Net

Defaultly i not get the properity "ArrayBindCount" in OracleParameter.

Thanks

how to capture the event when the monitor close [modified]

scoket14-Dec-10 15:49

scoket

14-Dec-10 15:49

Hello:
Development (VS2005(C#)\WinXP).i want to get the datetime when the local monitor close.
also want to get the datetime when the monitor wakeup.so i can calculate the time of the monitor's sleep.I think "SystemEvents" can not solve this problme.should i use Win32API?
can someone lend me a hand?
thanks in advance

modified on Tuesday, December 14, 2010 10:36 PM

Re: how to capture the event when the monitor close

Hiren solanki14-Dec-10 19:35

Hiren solanki

14-Dec-10 19:35

As you have asked question regarding monitor ON|OFF Status HERE[^], If you've got success with that then you can measure System local time when it goes OFF and further note it when it goes ON.

Regards,
Hiren.
Microsoft Dynamics CRM

My Recent Article: - Way to know which control have raised PostBack[^]

Re: how to capture the event when the monitor close

scoket14-Dec-10 20:35

scoket

14-Dec-10 20:35

thank you for your link.
i just want to get the monitor ON|OFF Status.
but the link is not solve it.so i ask this problem.

Re: how to capture the event when the monitor close

Dave Kreskowiak15-Dec-10 2:09

Dave Kreskowiak

15-Dec-10 2:09

There is no reliable way ot get the monitor power state.

If you're trying to measure power usage, you'll have to use some kind of meter attached to the power cable instead.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: how to capture the event when the monitor close

scoket15-Dec-10 15:00

scoket

15-Dec-10 15:00

hi, i just want to query the monitor status,and the status is changed by system or programe.

Re: how to capture the event when the monitor close

Dave Kreskowiak15-Dec-10 16:18

Dave Kreskowiak

15-Dec-10 16:18

How many times do we have to tell you there is no way to get the monitors status with any accuracy??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: how to capture the event when the monitor close

Pete O'Hanlon15-Dec-10 2:54

Pete O'Hanlon

15-Dec-10 2:54

If the monitor is manually switched off, you can't reliably detect it. The monitor power supply may be independent from the base unit so you can't watch power consumption. One thing that may work is the interface IMSVidDevice which is implemented by the video devices. More details here[^]

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

array [modified]

jim haras14-Dec-10 15:33

jim haras

14-Dec-10 15:33

hi there. i am creating a bookstore web service for my course project. the part i find difficult, is to implement the search-for-books part of the web service into the web site i am building. with a little help a created the web method for that. it returns an array which includes the information of the book using the book id as input. i want to display the info in my website either with a gridview or a data list or even with textboxes. this is the method. any help would be greatly appreciated Big Grin | :-D

[WebMethod]
public BooksClass.Books GetBookInfo(string Book_ID)
{
BooksClass.Books books = new BooksClass.Books();
SqlConnection SQLConn = new SqlConnection();
string strSQL = "SELECT * FROM Books WHERE Book_ID = '" + Book_ID + "' ";
SqlDataReader Reader = null;
try
{
SQLConn.ConnectionString = @"Data Source = .\SQLEXPRESS; AttachDbFilename = C:\Users\jimis\Desktop\BookstoreBrokerWebService\BookstoreBrokerWebService\App_Data\BookstoreBrokerDatabase.mdf;
Integrated Security = True; User Instance = True;";

SQLConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = SQLConn;
cmd.CommandText = strSQL;

Reader = cmd.ExecuteReader();

while (Reader.Read())
{
books.book_ID = Reader[0].ToString();
books.title = Reader[1].ToString();
books.author = Reader[2].ToString();
books.publisher = Reader[3].ToString();
books.category = Reader[4].ToString();
books.year = Reader[5].ToString();
books.edition = Reader[6].ToString();
books.isbn = Reader[7].ToString();
books.price = Reader[8].ToString();
books.number_of_Copies = Reader[9].ToString();

}

}
finally
{
if (Reader != null)
{
Reader.Close();
}
if (SQLConn != null)
{
SQLConn.Close();
}

}

return books;

}

modified on Wednesday, December 15, 2010 11:40 AM

Re: array

PIEBALDconsult14-Dec-10 18:09

PIEBALDconsult

14-Dec-10 18:09

0) Do you have a question?
1) You should format your code snippet properly.
2) WHERE Book_ID = '" + Book_ID + "' " is very very bad; use a parameter.
3) Reader[0].ToString(); is also bad, use the column name, and if the column is a string already, just cast it.

Re: array

Abhinav S14-Dec-10 18:47

Abhinav S

14-Dec-10 18:47

If you want to search within the array, try using LINQ.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Visit the Hindi forum here.

Re: array

Hiren solanki14-Dec-10 19:42

Hiren solanki

14-Dec-10 19:42

I didn't find any mistake in your code, But the way you're using development approach is very BAD.

Just to make a note.

jim haras wrote:
while (Reader.Read())
{
books.book_ID = Reader[0].ToString();
books.title = Reader[1].ToString();
books.author = Reader[2].ToString();
books.publisher = Reader[3].ToString();
books.category = Reader[4].ToString();
books.year = Reader[5].ToString();
books.edition = Reader[6].ToString();
books.isbn = Reader[7].ToString();
books.price = Reader[8].ToString();
books.number_of_Copies = Reader[9].ToString();

}

If you want to get all things returned from a query then use SqlDataAdapter will be having less code lines. Fill the results in a DataTable.

As of you're passing BookID then I don't think there's chance of fetching multiple rows from DB, If you've kept BookID Unique or PrimaryKey.

Most of the things were already suggested by PIEBALDconsult, Add mine this to it. Smile | :)

Regards,
Hiren.
Microsoft Dynamics CRM

My Recent Article: - Way to know which control have raised PostBack[^]

Re: array

jim haras15-Dec-10 5:47

jim haras

15-Dec-10 5:47

thanks for the replies guys! maybe i didn't explain it properly. the problem is not in the code that i posted. despite its structure, it works fine. the problem i am facing is in the web page. i put a textbox that will be filled with the book id ( or the title or the author it doesn't matter) and a grid view ( or a bunch of text boxes each assigned to show a different collumn of the books database) that will display the search results from the database using the web method in the web service ( the one i posted earlier). i can not make it display the results

Re: array

jim haras16-Dec-10 16:05

jim haras

16-Dec-10 16:05

Let me make it easier for you to understand what i want to do. in my web page i use a dropdown list which contains the customer id column of the customer data table as input and i try to call the web service that i posted above. i want the array that the web service returns to be displayed in a grid view( or any other way for that matter but i prefer the grid view ). this is what i wrote:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{

Array getinfo = new Array[6];

try
{

localhost.WebService1 myserv1 = new localhost.WebService1();
getinfo = myserv1.GetCustomer(DropDownList1.Text);

GridView1.DataSource = getinfo;
GridView1.DataBind();
}
catch (Exception ex)
{

Label8.Text = ("Unable to find user because" + ex.Message);
}

}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
}

and it returns nothing.Thanks in advance

Action keyword question

SciGama14-Dec-10 11:24

SciGama

14-Dec-10 11:24

Can anyone explain this line in plain english (I am learning).

var userCallback = e.UserState as Action<bool>

I understand how to call a typical invoke method on an action but how is e.UserState convertable to an Action<bool>? From what i have seen in object browser e.UserState is just calling a property.

When i right click on the property and select get definition this is the property it is referring to.

In this case UserState is from
System.ComponentModel.AsyncCompletedEventArgs

public object UserState
{
get;
}

Thanks for your time .

Re: Action keyword question

Manfred Rudolf Bihy14-Dec-10 12:35

Manfred Rudolf Bihy

14-Dec-10 12:35

Please don't cross post.
You have already asked that question here: http://www.codeproject.com/Questions/136500/Action-keyword-question.aspx.

Re: Action keyword question

Henry Minute14-Dec-10 12:36

Henry Minute

14-Dec-10 12:36

Snap!

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.”

Re: Action keyword question

Manfred Rudolf Bihy14-Dec-10 12:48

Manfred Rudolf Bihy

14-Dec-10 12:48

Snap as in crackle and pop, Confused | :confused:

Re: Action keyword question

Henry Minute14-Dec-10 12:52

Henry Minute

14-Dec-10 12:52

Children's playing card game[^], used for teaching number recognition etc.. Both turn a card over at the same time and if both are the same e.g. a 9 then the first to call out 'Snap' wins all cards laid down so far. Winner is one who gets all cards or most in a given time.

So 'Snap' is used when two people do the same thing at the same time.

Re: Action keyword question

Manfred Rudolf Bihy14-Dec-10 13:11

Manfred Rudolf Bihy

14-Dec-10 13:11

Thanks for clearing that up for me.
For me the association was more like when some fragile part in ones mind breaks and you "snap". Smile | :)

Re: Action keyword question

SciGama14-Dec-10 13:01

SciGama

14-Dec-10 13:01

I am just looking for a simple answer to the question Smile | :)

thats all

Re: Action keyword question