|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
how to insert blob file into MYSQL using ODBC in C# language. If anybody have answer please reply with sample code.
Thanks
ramana
|
|
|
|
|
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
|
|
|
|
|
SharpDevelop[^]
You know you're a Land Rover owner when the best route from point A to point B is through the mud.
Ed
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Yes i thought about that, but the data COULD be large  Any other suggestions?
|
|
|
|
|
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!
|
|
|
|
|
|
|
Thank you, i'll have a look at both!
|
|
|
|
|
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?
|
|
|
|
|
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";
}
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
{
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!!
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
