|
HOw can do to insert a bulk data to Oracle database ( Store procedure ) using c#
Thanks
|
|
|
|
|
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.
|
|
|
|
|
|
Thanks for Reply...
Is it possible to achieve without using ODP.Net
Defaultly i not get the properity "ArrayBindCount" in OracleParameter.
Thanks
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
hi, i just want to query the monitor status,and the status is changed by system or programe.
|
|
|
|
|
How many times do we have to tell you there is no way to get the monitors status with any accuracy??
|
|
|
|
|
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[^]
|
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 .
|
|
|
|
|
|
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.”
|
|
|
|
|
Snap as in crackle and pop,
|
|
|
|
|
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.
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.”
|
|
|
|
|
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".
|
|
|
|
|
I am just looking for a simple answer to the question thats all
|
|
|
|
|
Please do NOT post the same question in more than one forum. Very rude.
Please delete this one.
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.”
|
|
|
|