|
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
|
|
|
|
|
h
modified on Wednesday, April 27, 2011 3:39 PM
|
|
|
|
|
Are you absolutely, stonkingly, 100% sure you've picked the correct forum? Is there the teensiest, tiniest, minisculest chance that you might have picked the wrong one to ask this in?
|
|
|
|
|
I am 100% sure I was in the wrong crowds.
|
|
|
|
|
That's because all the cool kids hang out here. 
|
|
|
|
|
jashimu wrote: h
What in the world would this question suppose to mean?
Ignorance of the ability brings disability.
|
|
|
|
|
It was a question about validating input without the postback using JavaScript and it was pointed out that this wasn't the best place to ask this question. I'm not psychic; the OP removed the question, but couldn't delete it since there was a reply to it.
|
|
|
|
|
Hi All
Is it Possible to Call A Function Like This to add a link label to a particular form
public void AddLinklabel(string form,int top, int left, int width, int height,string Link)
{
LinkLabel linkLabel1 = new LinkLabel();
form.linkLabel1.Location = new System.Drawing.Point(top, left);
form.linkLabel1.Size = new System.Drawing.Size(width, height);
form.linkLabel1.AutoSize = true;
}
If Possible Please Show Me A Example Code
Please Help Me
Arunkumar.T
-------------------------
p4,3ghz,hdd-500gb,ram-4gb
|
|
|
|
|
Why not convert your method into a generic method? BTW, please enclose code samples in pre blocks like this:
public void AddLinkLabel<T>(T containingForm, int top, int left, int width, int height, string link) where T : Form
{
LinkLabel label = new LinkLabel();
label.Location = new System.Drawing.Point(top, left);
label.Size = new System.Drawing.Size(width, height);
containingForm.Controls.Add(label);
}Note that I've just typed this sample into this textbox, so there might be an error or two, you should be able to get the gist from this though.
|
|
|
|
|
I Called The Function Like This But There are lot of errors displaying
Error 1 The type 'string' must be convertible to 'System.Windows.Forms.Form' in order to use it as parameter 'T' in the generic type or method 'WindowsApplication1.Form1.AddLinkLabel<T>(T, int, int, int, int, string)' C:\Documents and Settings\Agni\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Form1.cs 21 13 WindowsApplication1
AddLinkLabel("Form1", 20, 20, 100, 30, "Click Here");
is there any other method to call this function?
|
|
|
|
|
Of course you've got errors, you've given it a string in place of the form instance. You'd need to give it like this:
AddLinkLabel(myFormInstance, 20, 20, 100, 30, "Click here"); BTW - why did you not encode your code in C#? I told you to do it before.
|
|
|
|
|
Thankyou This Time I Dont Get Any Errors The Program Executed Well But I Cant See The Label I Created
And Also How Can I fire Click Event? And Where Should I Add The Url?
This is My Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
Form1 frm1=new Form1();
AddLinkLabel(frm1, 20, 20, 100, 30, "Click Here");
}
public void AddLinkLabel<T>(T containingForm, int top, int left, int width, int height, string link) where T : Form
{
LinkLabel label = new LinkLabel();
label.Location = new System.Drawing.Point(top, left);
label.Size = new System.Drawing.Size(width, height);
containingForm.Controls.Add(label);
}
}
}
|
|
|
|
|
You don't need to create a new instance of Form1. In fact, as you have placed this method inside your Form class, you don't even need containingForm, but assuming you are going to move this method into a separate class, your call to AddLinkLabel would look like this:
AddLinkLabel(this, 20, 20, 100, 30, "Click Here"); You have now added the link label to the controls collection of the form that's displayed (and not the form you instantiated in Form1 frm = new Form1();.
|
|
|
|
|
Thankyou For That It Work on a form load event
I Writed The Same Code to A Class File To Create a library for link label but it faild there are so many errors displaying
this is my class library code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Net;
using System.Windows.Forms;
namespace linklabel
{
public class LinkLabel
{
public void AddLinkLabel<T>(T containingForm, int top, int left, int width, int height, string Text, string link) where T : Form
{
LinkLabel label = new LinkLabel();
label.Location = new System.Drawing.Point(top, left);
label.Size = new System.Drawing.Size(width, height);
label.Text = Text;
containingForm.Controls.Add(label);
}
}
}
is it possible to create a library for a control?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
