|
This query does work when run as a sql command against a 2005 express
database, changing to nvarchar has removed the error due to the type
incompatability, thanks.
However when I ran the command from the app it had legal syntax but no affect ?
So i pasted it into the sql pane and intllisense altered the statement to this
INSERT INTO Table_C<br />
(Name)<br />
SELECT DISTINCT Name<br />
FROM Table_A<br />
WHERE (Name NOT IN<br />
(SELECT DISTINCT Name<br />
FROM Table_B AS Table_B_1))
This SQL command now works, i will have to do some homework on why that change is required for SQL CE 3.5
and not in SQL 2005 express 
|
|
|
|
|
Hi all,
I am having one c++ dll and when i am try to add as a reference in c# application it is giving and error.
How can i use it in my c# application ?
Can you suggest me any method instead of using "dllimport and external" methods.
Thanks in advance.
|
|
|
|
|
sarang_k wrote: Can you suggest me any method instead of using "dllimport and external"
methods.
Unless you want to write a C++/CLI implementation of your C++ function, or provide a C++/CLI version to act as a bridge, there is no other mechanism you can use (discounting you providing COM interfaces in your C++ code for your C# to hook into).
The PE header for .NET assemblies is different to the PE header for other libraries, which means that you can't add a none .NET assembly in as a reference.
|
|
|
|
|
Hi guys,
How can I rename my file defined by my string Path?
I want to pass from :
TXTFile_rfcyxt55efrem1fj4sycjv5527-04-2011_17h-4641_0.txt
to
Entite1.txt
ty for u help
modified on Thursday, April 28, 2011 4:47 AM
|
|
|
|
|
|
Hi,
File.Move is good solution also File.CopyTo(olderpath, NewPath) is also well working)
Ty
|
|
|
|
|
file raname using Regex
like this
newfilename = Regex.Replace(fDialog.FileName, "F.NCF", "H.NCF");
|
|
|
|
|
That just changes strings. It doesn't touch the file at all.
|
|
|
|
|
Hi,
RDLC print icon not displayed in Mozilla Firefox, its working fine in IE. what is the issue
Thankyou,
ypki
|
|
|
|
|
I'm sorry, but you've picked the wrong forum for your question. Would you like to move it to a more appropriate forum please?
|
|
|
|
|
which is the forum where i can ask about the RDLC?
|
|
|
|
|
|
I found this thread[^] having same discussion with solutions.
|
|
|
|
|
Hi,
I am filling a combobox with the code below:
private void frmCrearCooperativa_Load(object sender, EventArgs e)
{
string nacionalidad = "select * from cs_nacionalidad";
try
{
//open connection
bdConex.OpenConnection();
//create command and assign the query and connection from the constructor
MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
//create dataset
DataSet ds = new DataSet();
// filling dataset
da.Fill(ds, "cs_nacionalidad");
//dataset values
cboNacionalidad.DataSource = ds.Tables["cs_nacionalidad"];
cboNacionalidad.DisplayMember = "nm_nacionalidad";
cboNacionalidad.ValueMember = "cd_nacionalidad";
//close connection
bdConex.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
how do I can do a class that fills the combobox with this code?
because I have to write it down in all forms.
thanks.
|
|
|
|
|
I dont have your answer but, If you would like the guys who know more than me to answer you might want to edit your post and put the code in a code block
code here by using pre tags to make it easier to read.
Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.
|
|
|
|
|
you only need to pass dataset object
EASY COME EASY GO
|
|
|
|
|
You can just create a method that accepts a combobox as parameter. and then inside your method, just do the usual setting of the datasource to your combobox, just like what you are doing in your code. Im not sure though if your data source for your combo boxes will be the same. If it isn't, you might want to add parameters for your datasource, displaymember, and valuemember to your method.
Ignorance of the ability brings disability.
|
|
|
|
|
You can create a class, that derives from ComboBox, and there you do
protected override void OnLoad(EventArgs e)
{
string nacionalidad = "select * from cs_nacionalidad";
try
{
bdConex.OpenConnection();
MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
DataSet ds = new DataSet();
da.Fill(ds, "cs_nacionalidad");
cboNacionalidad.DataSource = ds.Tables["cs_nacionalidad"];
cboNacionalidad.DisplayMember = "nm_nacionalidad";
cboNacionalidad.ValueMember = "cd_nacionalidad";
bdConex.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
And then use this class, where you want ComboBox to contain this data.
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
how do I call the class with the combobox as a parameter?
Thanks
|
|
|
|
|
You don't. You create class:
public class NationSelector : ComboBox
{
protected override void OnLoad(EventArgs e)
{
string nacionalidad = "select * from cs_nacionalidad";
try
{
bdConex.OpenConnection();
MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
DataSet ds = new DataSet();
da.Fill(ds, "cs_nacionalidad");
cboNacionalidad.DataSource = ds.Tables["cs_nacionalidad"];
cboNacionalidad.DisplayMember = "nm_nacionalidad";
cboNacionalidad.ValueMember = "cd_nacionalidad";
bdConex.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
And then, when you edit your aspx (or ascx), in the toolbox you should see "NationSelector". And you just drag this control on the designer.
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
Hi,
I did it as you told me:
protected override void OnLoad(object sender, EventArgs e)
{
BDconexion bdConex = new BDconexion();
string nacionalidad = "select * from cs_nacionalidad";
try
{
//open connection
bdConex.OpenConnection();
//create command and assign the query and connection from the constructor
MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
//create dataset
DataSet ds = new DataSet();
// filling dataset
da.Fill(ds, "cs_nacionalidad");
//dataset values
NationSelector1.DataSource = ds.Tables["cs_nacionalidad"];
NationSelector1.DisplayMember = "nm_nacionalidad";
NationSelector1.ValueMember = "cd_nacionalidad";
//close connection
bdConex.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
But I am having problem with these lines:
NationSelector1.DataSource = ds.Tables["cs_nacionalidad"];
NationSelector1.DisplayMember = "nm_nacionalidad";
NationSelector1.ValueMember = "cd_nacionalidad";
what is the name that I should write instead of NationSelector1?
thanks.
|
|
|
|
|
You should use this. And additionally you should notice, that OnLoad method should have only one argument: EventArgs e
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
I did it and there is not error messages, but what I need to do to see the NationSelector combobox in the toolbox? because I compile the code and It does not appear.
Thanks.
|
|
|
|
|
I think that the answer that you are looking for is that you must
add anther class to your project, create a method within that class
using your curent code. You then re use this wherever you like by adding a reference to the new class
at the top of each form. have a look at what refactoring does.
Instances of the class can then be created and its methods etc can be used.
Make sense ?
|
|
|
|
|
Hi,
is there any way how to prevent child process, created in C# code using Process class, to inharit parent process inharitable handles?
Some equivalent to API CreateProcess parameter bInheritHandles
Thank you
viliam
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
