Inserting BLOB into MySQL using ODBC in C# - C# Discussion Boards

radio button in windows form..urgt plzz..

r_e_h_a_n9-Jun-06 20:09

9-Jun-06 20:09

i made a form of student registration. here i create two radio buttons against gender (Male,Female), and create database connectivity of these two buttons, now when i click on radio button for male or female it gives me error that "number of query values and destination fields are not the same". how the entries of radio button goes in databse plz tell me. i'm so worried following is my code which use for database connectivity of radio buttons.
------------------------------------------------------------------------
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\C#Projects\\practice1\\db1.mdb;Persist Security Info=False");//("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\C#Projects\\practice1\\SMSDB.mdb;Persist Security Info=False");
con.Open();
string idata = "insert into db1 values('"+txtID.Text+"','"+rbmale.Text+"','"+rbfemale.Text+"')";
OleDbTransaction tx = con.BeginTransaction();
tx.Commit();
OleDbCommand cmd = new OleDbCommand(idata,con);
cmd.ExecuteNonQuery();
con.Close();
-------------------------------------------------------------------------

m.reehanmunir

Re: radio button in windows form..urgt plzz..

Christian Graus9-Jun-06 20:36

Christian Graus

9-Jun-06 20:36

r_e_h_a_n wrote:
string idata = "insert into db1 values('"+txtID.Text+"','"+rbmale.Text+"','"+rbfemale.Text+"')";

Well, your approach to database development will never scale to real world apps, but I guess it's fine for now. You're passing the text of both radio buttons to the database. It does not surprise me that you don't have three fields to save against. You probably want something like this:

string idata = "insert into db1 values('"+txtID.Text+"','" + rbmale.Checked ? "M" " "F"+"')";

This stores M or F, depending on if rbMale is checked or not.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: radio button in windows form..urgt plzz..

malikjhangirahmed@hotmail.com10-Jun-06 8:53

malikjhangirahmed@hotmail.com

10-Jun-06 8:53

Dear Reehan Bhai,
Please change your Insert query as following:

String idata="Insert into db1 values("+txtID.Text+","+(rbmale.Checked ? rbmale.Text:tbfemale.Text+")";

I think above query must solve your problem.

Regards,
Wasif Ehsan

Small Question about Remoting

Alexandr Sergeevich Ilyin9-Jun-06 19:49

Alexandr Sergeevich Ilyin

9-Jun-06 19:49

I have 2 Applications : Client and Server.
Server application contains class DataForClient.
Client uses this class (in SingleTon mode) using .NET Remoting.

Problem is:
1) How Server application can control
DataForClient class initialization process ?

2) How to create DataForClient object on Server
manually then Client want to use it ?

Issue with ClickOnce and publishing to a http site

Raffi Basmajian9-Jun-06 19:18

Raffi Basmajian

9-Jun-06 19:18

I am using ClickOnce in Visual Studio 2005 Express. Everything is working fine. I am publishing my application to a web link:

http://andromeda/RuntimeConfig/RuntimeConfigTest.application

The issue I have is that when I try to create a desktop shortcut to the address, I get an error that states the shortcut is not valid. I guess it's expecting an absolute file path, or UNC path. It works with an IE favorite link, but when I click the link IE opens then closes immediately after my WinForm app displays. Is there any way to create a http:// shortcut link while preventing the browser from opening?

Thanks
Raffi

Re: Issue with ClickOnce and publishing to a http site

g00fyman10-Jun-06 15:19

g00fyman

10-Jun-06 15:19

Can't you just copy the shortcut from your start menu?

Although I have done what you are doing without any problems, perhaps you have a file association problem.

Don't forget to include all the params in the shortcut link as well.

HTH
g00fy

Re: Issue with ClickOnce and publishing to a http site

Raffi Basmajian10-Jun-06 16:31

Raffi Basmajian

10-Jun-06 16:31

If you are referring to the shortcut created by ClickOnce when the application is first installed on the client's machine, I can't seem to access to manipulate the shortcut Properties. I dumped the shortcut to a text editor and this is what's inside...

http://andromeda/RuntimeConfig/RuntimeConfigTest.application?#RuntimeConfigTest.application, Culture=neutral, PublicKeyToken=723942b244e09dfc, processorArchitecture=msil[^]

I tried adding a query parameter to the embedded link, but the shorcut doesn't work after I change it.

If the application is published using a UNC path, is it possible to pass name/value arguments to the app in the UNC path? I tried doing this as well with a standard shortcut but it didn't work; the shortcut refused to let me apply the changes to it. Here is what I tried to do:

\\andromeda\PUBLISH\RuntimeConfigTest.application environment=qa

and this didn't works
\\andromeda\PUBLISH\RuntimeConfigTest.application?environment=qa

thanks

Inserting BLOB into MySQL using ODBC in C#

nagramana9-Jun-06 19:15

nagramana

9-Jun-06 19:15

how to insert blob file into MYSQL using ODBC in C# language. If anybody have answer please reply with sample code.
Thanks

ramana

solution tree access + custom project [modified]

g00fyman9-Jun-06 17:03

g00fyman

9-Jun-06 17:03

hi all,

I would like to implement a framework that i have created as something similar to the way deklarit is integrated into .net. can anyone point me in the right direction to a starting point?

Basically i need to be able to dynaically generate a solution or project of my type and populate that project with custom nodes that perform specific tasks within that project.

Kind regards,
g00fy

Re: solution tree access + custom project

Ed.Poore10-Jun-06 3:32

Ed.Poore

10-Jun-06 3:32

SharpDevelop[^]

You know you're a Land Rover owner when the best route from point A to point B is through the mud.

Ed

Re: solution tree access + custom project

g00fyman10-Jun-06 15:17

g00fyman

10-Jun-06 15:17

Thanx Ed

I looked into MSDN examples of DTE and worked it out, just need to incorporate all the funcitonality I need now.

kind regards,
g00fy

Re: solution tree access + custom project

Ed.Poore10-Jun-06 20:59

Ed.Poore

10-Jun-06 20:59

Nice to be of service.

You know you're a Land Rover owner when the best route from point A to point B is through the mud.

Ed

Switch algorithm

S.M.9-Jun-06 14:15

S.M.

9-Jun-06 14:15

Hi all
I can't find an algorithm for store-and-forward technique used in network switches any where and i need ur help urgently by any means
Urgenly before the end of this week
PLZZZZZZZZZ
Thx alot

S.M.

Database without Server with C#

error14089-Jun-06 12:03

error1408

9-Jun-06 12:03

Hi all,
is there a way to create an application with an database WITHOUT the need of installing a server (e.g. MS-SQL Server or Oracle Server etc.)? The only solution i know is MS-ACCESS but i don't like this.
I hope you know what i mean.

Re: Database without Server with C#

Ravi Bhavnani9-Jun-06 12:12

Ravi Bhavnani

9-Jun-06 12:12

If the size of your data isn't too large and your data will be accessed by a single client (at a time), you could use XML files to store your data, doing away with the need for a database server.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Database without Server with C#

error14089-Jun-06 12:17

error1408

9-Jun-06 12:17

Yes i thought about that, but the data COULD be large Smile | :)

Any other suggestions?

Re: Database without Server with C#

Luis Alonso Ramos9-Jun-06 12:39

Luis Alonso Ramos

9-Jun-06 12:39

There are several embedded databases that could work. Search Google for VistaDB or Firebird.

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

Not much here: My CP Blog!

Re: Database without Server with C#

Joshua Quick9-Jun-06 12:43

Joshua Quick

9-Jun-06 12:43

You can use the Firebird database. There is an embedded version so that you don't have to install a server, just a DLL.
http://firebird.sourceforge.net/[^]

You can find the .NET data providers for it here.
http://firebird.sourceforge.net/index.php?op=files&id=netprovider[^]

I've never used it myself, but I've heard plenty of praise for this database. It might be worth a shot.

Re: Database without Server with C#

Jun Du9-Jun-06 16:22

Jun Du

9-Jun-06 16:22

You may want to give MySQL a check: http://www.mysql.com/oem/[^].

- It's easier to make than to correct a mistake.

Re: Database without Server with C#

error14089-Jun-06 18:37

error1408

9-Jun-06 18:37

Thank you, i'll have a look at both! Big Grin | :-D

tabpages

rcwoods9-Jun-06 11:23

rcwoods

9-Jun-06 11:23

Hi
Could someone plz help me.
I need to edit a particular tabpage's labels. my tabpages are sitting in an array called allTabs[].
When i click a certain button it should adjust a label on the currently selected tabpage. Im sure i could match the index in my allTabs[] with the index of selected tabPage. Only thing is, how do i get the index of selected tabPage?

Re: tabpages

Mairaaj Khan9-Jun-06 22:01

Mairaaj Khan

9-Jun-06 22:01

rcwoods wrote:
Only thing is, how do i get the index of selected tabPage?

I think you need this!

void tabControl1_Selected(object sender, TabControlEventArgs e)<br />
{<br />
  MessageBox(e.TabPageIndex.toString());<br />
  e.TabPage.Text = "current page"; // sets text of the currently select page.<br />
}

_____________________________
Success is not something to wait for, its something to work for.

Opening a file with VS2005(8.0)

Ista9-Jun-06 11:15

Ista

9-Jun-06 11:15

{ EnvDTE.DTE dteInst80 = (EnvDTE.DTE)Microsoft.VisualBasic.Interaction.CreateObject("VisualStudio.DTE.8.0", "");

//object dte = Microsoft.VisualBasic.Interaction.CreateObject("VisualStudio.DTE.8.0", "");
dteInst80.SuppressUI = false;

if (dteInst80 != null)
{
dteInst80.ItemOperations.OpenFile(txtPath.Text, EnvDTE.Constants.vsViewKindTextView );

I execute this and on the last line it errors with "Value does not fall within the expected range."

But, the documentation says that vsViewKindTextView is one of the arguments.

DOes anyone know what I am doing wrong?

1 line of code equals many bugs. So don't write any!!

DateTime.Now returning incorrect results (using Compact Framework)

BlackDice9-Jun-06 11:10

BlackDice

9-Jun-06 11:10

I have an app that is used on a lot of pocketpc devices. While the app is still in beta, I have written a Trace function to write to a file, and it uses DateTime.Now to log the time. On most of the devices it's on it works correctly. However, on a few of them, it wrote this out a few minutes ago:

4/12/2006 1:30:00 PM

when it should've been this:

6/9/2006 4:25:00 PM

We've checked and verified that the devices have the correct date and time set, and the file where it's logging this wasn't even created back in April (let alone the Trace function I wrote). Does anyone have any idea why it would be doing this?

My Music | My Pics | My Articles

BlackDice

sql statement in c#

ddpn429-Jun-06 10:51

ddpn42

9-Jun-06 10:51

i am working on a project where read a sql statement from a file and then modify it and pass it to sql server 2000 via a sqlconnection. one of the files has 2 functions and each function declares 2 of the same variables. in the sql file they use a / to break them into 2 seperate statements, but when i pass the / through my app i get an error. if i leave it off it gives me the error that the 2 varibles already exists. can someone tell me how to make this work?

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