adding menus to minimized form - C# Discussion Boards

Re: How to bind a DataTable selected columns to a DataGridView in Windows Forms

31-Jan-09 3:05

You don't loop through the rows. Instead you define a datasource for the DataGridView, create a column in it and define the column from the datatable to show. For example something like this:

DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.DataPropertyName = "ColumnInDataTable";
column.HeaderText = "Header";
column.Name = "somename";
//
this.dataGridView1.Columns.Add(column);
this.dataGridView1.DataSource = dt1;

Of course you are aware that you can do this also in the designer.

The need to optimize rises from a bad design.My articles[^]

Najmal31-Jan-09 3:30

Najmal

31-Jan-09 3:30

Hi.......

U have lots of options to do this....
First One:

By Using BindingSource:::>> dataGridView1:>properties:>Choose Datasource:>{If u have already one then select it otherwise select Add Project Datasource}

If u cann't follow this Just message me!!!!!!

Second One:
fill dataset according to ur needs....

DataView dv = new DataView(dt.Tables["Specify table name here"]);
dataGridView1.DataSource = dv;
dataGridView1.Refresh();

{Remember Donn't Add Columns to DataGridView }

try this...... and reply me....

Web Service - calling a class method that uses datasets.

CrimeanTurtle200831-Jan-09 0:33

CrimeanTurtle2008

31-Jan-09 0:33

Hi Everyone,

I would just like to ask a question in relation to calling a web service.
I know how to call a web method when the return value is a string or an integer, however I am having difficulty in returning a dataset method that is in a class.
The following error gets returned

Error 1 Cannot implicitly convert type 'System.Data.DataSet' to 'ConnectToDB'

and i have tried several times to rectify this by changing the return value to string yet it relays a similar message to the above. . I guess my main query is , how do i create the web method so that it can return a dataset from the database?
Would someone be able to assist? Many Thanks. The code is below.

<br />
// connecttoDB.cs<br />
<br />
using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Linq;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.HtmlControls;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Xml.Linq;<br />
using System.Data.SqlClient;<br />
/// <summary><br />
/// Summary description for ConnectToDB<br />
/// </summary><br />
public class ConnectToDB<br />
{<br />
	public ConnectToDB()<br />
	{<br />
		//<br />
		// TODO: Add constructor logic here<br />
		//<br />
	}<br />
   <br />
    public static DataSet FilterCustomersByCountry(string country)<br />
    {<br />
<br />
        string query = "SELECT DISTINCT COUNTRY FROM CUSTOMERS WHERE COUNTRY LIKE"  + "'"+country+"'";<br />
        using (SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\MyCompany.MDF;Integrated Security=True;User Instance=True"))<br />
        {<br />
            DataSet ds = new DataSet();<br />
<br />
            SqlDataAdapter adapter = new SqlDataAdapter(query, conn);<br />
            adapter.Fill(ds, "Customers");<br />
<br />
            return ds;<br />
<br />
        }<br />
    }<br />
}<br />
<br />
// autocomplete.cs<br />
<br />
using System;<br />
using System.Collections;<br />
using System.Linq;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
using System.Xml.Linq;<br />
using System.Data.SqlClient;<br />
using System.Data.Sql;<br />
<br />
/// <summary><br />
/// Summary description for AutoComplete<br />
/// </summary><br />
[WebService(Namespace = "http://AJAXAutocomplete.org/",Name="AutocompleteVersion1")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. <br />
// [System.Web.Script.Services.ScriptService]<br />
public class AutoComplete : System.Web.Services.WebService {<br />
<br />
    public AutoComplete () {<br />
<br />
        //Uncomment the following line if using designed components <br />
        //InitializeComponent(); <br />
    }<br />
<br />
    [WebMethod] <br />
    public ConnectToDB SuggestionsFromDB(string country) <br />
    {<br />
        return ConnectToDB.FilterCustomersByCountry(country);<br />
    }<br />
    <br />
}<br />
<br />
<br />

Re: Web Service - calling a class method that uses datasets.

Wendelius31-Jan-09 1:48

Re: Web Service - calling a class method that uses datasets.

31-Jan-09 1:48

If you want to return a dataset from the web method, use something like:

[WebMethod] 
public System.Data.Dataset SuggestionsFromDB(string country) 
{
   return ConnectToDB.FilterCustomersByCountry(country);
}

The ConnectToDB is your class for getting the data.

Also note that never use concatenation in the sql statement in a situation like this. You're fully open to SQL injections. So your query should be:

string query = "SELECT DISTINCT COUNTRY FROM CUSTOMERS WHERE COUNTRY LIKE @Country";

and then you define a SqlParameter[^] to give the query a value.

The need to optimize rises from a bad design.My articles[^]

CrimeanTurtle200831-Jan-09 2:53

CrimeanTurtle2008

31-Jan-09 2:53

Awesome answer Mika, Thanks very much for your help and the heads up about the SQL injection.

Best Regards

Re: Web Service - calling a class method that uses datasets.

Wendelius31-Jan-09 2:56

How to manage a web-page from program/script?

31-Jan-09 2:56

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Exceter31-Jan-09 0:04

Exceter

31-Jan-09 0:04

Hi,
I have a situation like this:

I have a web-page where several "textboxes" and have an Excel file.
I have no direct access to web-page, that is, I can only open it in web-browser - https://
I need to copy data from Excell cell into textbox, and push an ENTER button. Of course, the web-page is open at the moment.

I know how to copy data from Excel into html, but have no experience how to copy into textbox in an open IE. and how to push link/button in IE.

could anybody help ???

Respectfully,
Exceter.

adding menus to minimized form

Mubeen.asim30-Jan-09 23:48

Re: adding menus to minimized form

30-Jan-09 23:48

the article "Minimize window to system tray By Elroy Dsilva" was great in minimizing an application but it missed how to add menus to the icon like restore exit.. and others... where should i have to write the menu codes for that..... thans...

Eddy Vluggen31-Jan-09 1:31

Eddy Vluggen

31-Jan-09 1:31

You'll need to add a contextMenu to the notifyIcon. Works the same as adding a mainmenu.

Good luck Smile | :)

I are troll Smile | :)

Re: adding menus to minimized form

Mubeen.asim31-Jan-09 2:00

can a windows service be used to display a message box..?

31-Jan-09 2:00

thank you vry much....

Mubeen.asim30-Jan-09 23:01

Re: can a windows service be used to display a message box..?

30-Jan-09 23:01

helu.. can a windows service be configured to display a windows control such as a message box or text box for the user... thans ...

Wendelius30-Jan-09 23:09

Re: can a windows service be used to display a message box..?

30-Jan-09 23:09

In short no. Service should never interact with desktop directly and depending on windows version it's impossible.

However, you can write a desktop application to communicate with the service and place that application for example in system tray. This application can then show a messagebox to the user based on the information received from the service.

The need to optimize rises from a bad design.My articles[^]

Mubeen.asim30-Jan-09 23:44

Re: can a windows service be used to display a message box..?

30-Jan-09 23:44

thns very much for the solution...

Wendelius31-Jan-09 0:09

Server side function from javascript.

31-Jan-09 0:09

You're welcome.

The need to optimize rises from a bad design.My articles[^]

Atul Shriram rane30-Jan-09 23:00

Atul Shriram rane

30-Jan-09 23:00

Hi,
I have a function (Server Side) which is used to fill the values in dropdownlist but I want to call the function from javascript.I am using c#.net.

Regards,
Atul Rane

Re: Server side function from javascript.

Christian Graus30-Jan-09 23:29

Christian Graus

30-Jan-09 23:29

I just checked, and you have posted in the ASP.NET forum before, so you must know it exists.

You're describing AJAX. AJAX is a way for a web page to call the code behind and retrieve data from it without refreshing the entire page.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Server side function from javascript.

Atul Shriram rane30-Jan-09 23:39

Atul Shriram rane

30-Jan-09 23:39

Thanks Christian for your reply,
Can you give me some web links where i can get more detail about this.

Regards,
Atul Rane

inherited form

pampam11030-Jan-09 21:59

pampam110

30-Jan-09 21:59

i am a begginer. so thanks if u answer my question in a simple way. i had a form and i wanna add an inherited form by write code. i dont know how?! and i dont know where the code should sit and placed! Thumbs Up | :thumbsup:

[]D @ []v[] []D @ []v[]

Wendelius30-Jan-09 22:26

30-Jan-09 22:26

If you want to inherit a form from another form you do something like this (creates a new MyForm class inherited from System.Windows.Forms.Form):

public class MyForm : System.Windows.Forms.Form {
   //Constructor, calls base constructor
   public MyForm() : base() { }
   
   ...
}

This seems like a good tutorial to start with: .NET Tutorial for Beginners[^]

The need to optimize rises from a bad design.My articles[^]

pampam11030-Jan-09 22:37

pampam110

30-Jan-09 22:37

thanks mika, but i like to deal with someone like u to learn it better, if it's no problem. Wink | ;)

[]D @ []v[] []D @ []v[]

Wendelius30-Jan-09 22:53

30-Jan-09 22:53

These forums are to help people who for example get stuck with a specific problem. All people expect that the person who asks a question has the basic knowledge about the environment he/she is working with. Many times people are given links to shortcuts or books that are very useful, but after that it's expected that the person reads the given information and tries to learn the environment (C# in this case).

So in short the purpose of these forums is not to educate people starting from beginning, but to help people with specific, clearly asked questions.

I'm sure that if you read the document I posted, you'll get a good start to C# inheritance along with other fields of programming in C#. Also you should consider buying a good book or two. Think of it like an investment to yourself.

The need to optimize rises from a bad design.My articles[^]