Re: pivot table control in c# - C# Discussion Boards

SHINOJK22-Jul-08 12:09

22-Jul-08 12:09

Hi,

I am using C# to insert a date value from the DatePicker into a DateTime

filed in mySQL database.. I am using the following syntax:

'" + datePicker.Value + "'
Plz Help.Thanks In Advance.

Re: data insert mysql+c#

Dirso22-Jul-08 12:30

Dirso

22-Jul-08 12:30

If you want the date part only, you should "'" + datePicker.Value.ToString("yyyy-MM-dd") + "'"
to include the time part too "'" + datePicker.Value.ToString("yyyy-MM-dd hh:mm:ss") + "'"

I hope it helps,
Dirso

Re: data insert mysql+c#

Mbah Dhaim22-Jul-08 23:37

Mbah Dhaim

22-Jul-08 23:37

use parameters for command, it will be more effective and secure from sql injection

dhaim
programming is a hobby that make some money as side effect Smile | :)

Yet another multi-threading question...

DavidBoyd22-Jul-08 11:58

DavidBoyd

22-Jul-08 11:58

Sorry guys i'm a bit of a newbie still... Frown | :(

But anyways here's my question.

I r multithreading! however it's not looking so good... I'm using a beginInvoke to fire off pings at other machines on my network I'm pulling the names from ldap sychronously. Anyways the question i had was "Are async delegates manged by the threadpool"... I thought i read somewhere that they were indeed managed via the threadpool... So next question is how come when i do something like this "ThreadPool.SetMaxThreads(10,10);" The app still fires off the max threads that the threadpool can manage? I.e. 20-25... Hope someone can shed some light on this.. Lemme know if you would like to see some code if that would help define my question/problem! Thanks in advance for any reply's even if it's stfu noobzor and go read a book! Smile | :)

I know the human being and fish can coexist peacefully. -George Dubya Bush

Don't believe me?
http://politicalhumor.about.com/library/blbushism-fish.htm

pivot table control in c#

Shuaib wasif khan22-Jul-08 11:46

Shuaib wasif khan

22-Jul-08 11:46

i am working on C# form and Have axPivotTable Control.

for Databinding i am Using This Code

SqlConnection cn=new SqlConnection("database=durdu;user id=sa;pwd=");
SqlDataAdapter cmd=new SqlDataAdapter ("select * from marksheet",cn);
DataTable dt=new DataTable();
cmd.Fill(dt);
axPivotTable1.DataSource=(msdatasrc.DataSource)(object)dt;

this throws an error -specified cast is not valid.

i have done lots of googling and does not found single satisfied answer

please tell me how to bind data to a pivot table

its very urgent .<b> Sleepy | :zzz:

Re: pivot table control in c#

Vimalsoft(Pty) Ltd22-Jul-08 12:03

Vimalsoft(Pty) Ltd

22-Jul-08 12:03

hi

Dont ever say Urgent again, we dont work for you.

Secondly mybe you can write your code like this

SqlConnection cn=new SqlConnection("database=durdu;user id=sa;pwd=");
SqlDataAdapter cmd=new SqlDataAdapter ("select * from marksheet",cn);
Dataset ds = new Dataset();
DataTable dt=new DataTable();
cmd.Fill(ds);
dt = ds("My_Table");
axPivotTable1.DataSource=(msdatasrc.DataSource)(object)dt;

Remember not to use the Word Urgent here

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: pivot table control in c#

PIEBALDconsult22-Jul-08 12:10

PIEBALDconsult

22-Jul-08 12:10

What benefit would a DataSet be?

Re: pivot table control in c#

Guffa22-Jul-08 12:22

Guffa

22-Jul-08 12:22

monu_khan wrote:
axPivotTable1.DataSource=(msdatasrc.DataSource)(object)dt;

You can't cast an object to something that it isn't. You can only cast an object to it's actual class, any of it's base classes, or any of the interfaces that it implements.

C# is type safe, so the object contains information about it's actual type. When you do a cast, you cast the reference, but the object still remains the same type. Therefore, when you cast the DataTable reference to object, you get an object reference pointing to a DataTable object. You can't then cast this to msdatasrc.DataSource, as the actual type of the object does not inherit that class.

If the control can't use a DataTable as data source, you have to copy the data from the DataTable into something that the control can use.

Despite everything, the person most likely to be fooling you next is yourself.

Create a file chooser.

AgroDuck22-Jul-08 11:32

AgroDuck

22-Jul-08 11:32

Good day,
Any help with writing the code to set up a browser that chooses a file that will later on be used to update a database.

Re: Create a file chooser.

Vimalsoft(Pty) Ltd22-Jul-08 11:56

Vimalsoft(Pty) Ltd

22-Jul-08 11:56

1: we dont Post like that on a Forum

2: i See its your First day, let me not be hard on you.

3:Did you make any research on google before you post?

4: Lets see what you have done soe far, We cannot do your Job for you.

Hope this help

Re: Create a file chooser.

PIEBALDconsult22-Jul-08 12:13

PIEBALDconsult

22-Jul-08 12:13

System.Windows.Forms.OpenFileDialog?

socket programming

AlexPizzano22-Jul-08 11:28

AlexPizzano

22-Jul-08 11:28

How to find out ip address of a listening port.

Re: socket programming

DavidBoyd22-Jul-08 11:47

DavidBoyd

22-Jul-08 11:47

lol what?

I know the human being and fish can coexist peacefully. -George Dubya Bush

Don't believe me?
http://politicalhumor.about.com/library/blbushism-fish.htm

Re: socket programming

AlexPizzano22-Jul-08 11:50

AlexPizzano

22-Jul-08 11:50

Re: socket programming

nelsonpaixao22-Jul-08 12:22

nelsonpaixao

22-Jul-08 12:22

I got this from a chat application here on codeproject, there are other ways. Try to download applications in the site.

String GetIP()
{
String strHostName = Dns.GetHostName();

// Find host by name
IPHostEntry iphostentry = Dns.GetHostByName(strHostName);

// Grab the first IP addresses
String IPStr = "";
foreach (IPAddress ipaddress in iphostentry.AddressList)
{
IPStr = ipaddress.ToString();
return IPStr;
}
return IPStr;
}

Good luck Big Grin | :-D

Blocking Input

Dirso22-Jul-08 11:15

Dirso

22-Jul-08 11:15

Hi,

I found this SO dependent solution. Is there a C# native solution to block all keyboard and mouse input?

[DllImport("User32.dll")]
public static extern bool BlockInput(bool enabled);

Thanks,
Dirso

Re: Blocking Input

Vimalsoft(Pty) Ltd22-Jul-08 11:53

Vimalsoft(Pty) Ltd

22-Jul-08 11:53

see this

http://www.msfn.org/board/lofiversion/index.php/t17955.html[^]

http://msdn.microsoft.com/en-us/library/ms646290.aspx[^]

http://msdn.microsoft.com/en-us/library/ms646290.aspx[^]

Re: Blocking Input

Dirso22-Jul-08 12:26

Dirso

22-Jul-08 12:26

Hi,

I think they all show exactly the same solution I have... did I miss anything? I'll use BlockInput, but I really would like to have a C# native solution instead (so I could also test it under Mono)

Thanks,
Dirso

data binding to combobox

bfis10813722-Jul-08 10:58

bfis108137

22-Jul-08 10:58

My goal is to have a combo box for genders. I need the combo box to display the selected gender. Currently I have a class that has one of it's properties as gender. 1 is supposed to be male and 2 is female. However I am willing to do it however is best. I would like to incorporate binding since that is how I am doing the rest of my app. i.e. text boxes and datepickers etc

Re: data binding to combobox

Vimalsoft(Pty) Ltd22-Jul-08 11:43

Vimalsoft(Pty) Ltd

22-Jul-08 11:43

So what is your problem?

Re: data binding to combobox

bfis10813723-Jul-08 3:08

bfis108137

23-Jul-08 3:08

My problem is that the only thing I really know how to do in data binding is to drag an item from the data sources menu to a text box or a date time picker. Here the most important thing is the selection be the selection that has been chosen in the object. Ideally I can just use objects but if I have to I can go with xml, but either way I really need some direction.

Re: data binding to combobox

Vimalsoft(Pty) Ltd23-Jul-08 5:45

Vimalsoft(Pty) Ltd

23-Jul-08 5:45

hi

You need to work a little bit on your English,Do it in XML then, but realy i did not understand what you wanted to do.

Re: data binding to combobox

bfis10813723-Jul-08 5:53

bfis108137

23-Jul-08 5:53

In the most simplest form, I want a combobox that will load on a form that will have have a item selected already. In other words lets say it's a male. So in my object it will have gender equal to 1. I want my form to know that when gender = 1, then it will automatically select male. I want to use data binding because thats how I have the rest o my project set up, and I feel that I will just be asking for trouble, if I use databinding for only half. I already know I can do it with if statements.

Ready screen for a simple game

Gareth H22-Jul-08 10:46

Gareth H

22-Jul-08 10:46

I am making a simple reaction game. When the player clicks "Start", i want to display a label that acts as a count down.

Eg:

label.Text = "Ready";<br />
Thread.Sleep(1000);<br />
label.Text = "Steady";<br />
Thread.Sleep(1000);<br />
label.Text = "GO!";

I could do it like the above but I'd rather not use Thread.Sleep.
Does anyone know how I'd go about this?

Regards,
Gareth.

(FKA gareth111)

Re: Ready screen for a simple game

DaveyM6922-Jul-08 10:56

DaveyM69

22-Jul-08 10:56

Use a timer with an interval of 1000 and increment a counter on each tick event, display the correct message depending on the counter value?

Dave

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