|
|
I would like a short example on how to populate a comboBox with the result of an SQLcommand.
Thanks!
|
|
|
|
|
it is vb.net example, but same do in C#
http://rustemsoft.com/vbbegin.htm#1
|
|
|
|
|
use:
private void Form2_Load(object sender, System.EventArgs e)<br />
{<br />
Authors authors = new Authors();<br />
DataTable Name;<br />
Name=authors.find_AuthorsName_all(connection.make());<br />
<br />
<br />
cmb_AuthorName.DataSource=Name;<br />
cmb_AuthorName.DisplayMember="name";<br />
cmb_AuthorName.ValueMember="id";<br />
}
Author class:
<br />
public class Authors<br />
{<br />
OleDbConnection con;<br />
OleDbCommand cmd;<br />
<br />
public DataTable find_AuthorsName_all(string cnstring)<br />
{<br />
con=new OleDbConnection(cnstring);<br />
<br />
<br />
try<br />
{<br />
<br />
con.Open();<br />
string cmdstr="select id,name from Authors ";<br />
cmd=new OleDbCommand(cmdstr,con);<br />
cmd.CommandType=CommandType.Text;<br />
OleDbDataAdapter adp=new OleDbDataAdapter(cmd);<br />
DataTable dt =new DataTable("Authors");<br />
adp.Fill(dt);<br />
con.Close();<br />
return dt;<br />
}<br />
catch(Exception ex)<br />
{<br />
MessageBox.Show(ex.Message);<br />
con.Close();<br />
return null;<br />
}<br />
<br />
<br />
}<br />
}<br />
|
|
|
|
|
Open/Save word documen in the server
i need to open the word document in the server and display it
to the user, and save changes if any to the server back
i am able to open and display it in explore (.doc file is in url)
but save back to server ?? so for this i need some control with in with
i can open and save ,
if any of u had gown through the same problem.
pls respond
Understanding comes from failures
SUCESSES comes form understanding failures
|
|
|
|
|
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!
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
