C# Discussion Boards - CodeProject

Re: help with inport csv file to my C# program

_Erik_15-Dec-10 4:29

15-Dec-10 4:29

Could be a deja vu, but I think I have seen this question in random forums (or a very similar one) every two weeks in the last months. Please, write csv in the search text box at the top of this forum. Maybe you'll get what you need.

Message Removed

14-Dec-10 23:59

Pranay Rana

14-Dec-10 23:59

Message Removed

Re: Learn SQL to LINQ ( Visual Representation )

Hiren solanki15-Dec-10 0:03

Hiren solanki

15-Dec-10 0:03

This is not a right place to post your article Ad.

Regards,
Hiren.

My Recent Article: - Way to know which control have raised PostBack
My Recent Tip/Trick: - Remove HTML Tag, get plain Text

Re: Learn SQL to LINQ ( Visual Representation )

Pranay Rana15-Dec-10 0:42

Pranay Rana

15-Dec-10 0:42

sorry

message removed now

thanks for your replies

For any question : http://pranayamr.blogspot.com/

vote my article :

Learn SQL to LINQ ( Visual Representation )

Calling WCF Services using jQuery

Re: Learn SQL to LINQ ( Visual Representation )

thatraja15-Dec-10 0:29

thatraja

15-Dec-10 0:29

Oh man, It's a programming forum for Questions/Answers, better you can keep this in your CP signature. Cheers.

thatraja |Chennai|India|

Brainbench certifications
Univotes are like kid's kisses don't reject it Smile | :)

Do what you want quickly because the Doomsday on 2012 Smile | :)

My childhood story

Re: Learn SQL to LINQ ( Visual Representation )

Pranay Rana15-Dec-10 0:42

Pranay Rana

15-Dec-10 0:42

sorry guys

message removed now

thanks for your replies

For any question : http://pranayamr.blogspot.com/

vote my article :

Learn SQL to LINQ ( Visual Representation )

Calling WCF Services using jQuery

Re: Learn SQL to LINQ ( Visual Representation )

Pete O'Hanlon15-Dec-10 0:45

Pete O'Hanlon

15-Dec-10 0:45

Well done, but was the original post a link to your article? If so, then it isn't really an advert - it's a bit tacky pushing for votes, but it's not something we'd expect you to have to pay for.

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

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 .

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