How to bind a DataTable selected columns to a DataGridView in Windows Forms - C# Discussion Boards

Pete O'Hanlon31-Jan-09 10:29

Pete O'Hanlon

31-Jan-09 10:29

All right. If you're so bloody clever figure out the code for yourself. You've been told by several experts that the way to do this is to use policies to cope with it, and yet you persist in arguing. Fine - write the code, post it up and then see how long it is before somebody finds a way to work round it (btw - somebody could rename tastmanager.exe and launch that so any approach you had to block it by name would fail).

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

My blog | My articles | MoXAML PowerToys

Mubeen.asim31-Jan-09 10:31

31-Jan-09 10:31

hey man you are on fire... why dont you just help by telling how to call the policy manager from the code and disable the taskmanager.....

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Colin Angus Mackay31-Jan-09 17:00

Colin Angus Mackay

31-Jan-09 17:00

max.4u wrote:
why dont you just help by telling how to call the policy manager from the code and disable the taskmanager.....

I can see that you were told 11 minutes before you posted this message. See this post[^]

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Mubeen.asim31-Jan-09 10:49

31-Jan-09 10:49

hello.. am extreamly sorry for whats happening here... i was only making new ways of doing the thing.... sorry if i have hurted any one.... once more...

Najmal31-Jan-09 13:12

Najmal

31-Jan-09 13:12

you are right Max.....

Sometimes taskmanager must be disabled for security purpose...

Mubeen.asim31-Jan-09 18:19

31-Jan-09 18:19

thans...

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

Eddy Vluggen1-Feb-09 0:32

Eddy Vluggen

1-Feb-09 0:32

Imagine that one of the processes on the computer goes banana's. I know that it's unusual, since Windows is such a stable platform, but for arguments sake, let's imagine that there is a virus-checker on your system and that it's gone into an infinite loop, eating away 100% cpu time.

..and the virus-scanner starts when Windows start, rendering your machine useless.

That's why we have a task-manager Smile | :)

I are troll Smile | :)

pavanip31-Jan-09 1:40

pavanip

31-Jan-09 1:40

Hi,

I want to bind only one column, from the collection of columns of the DataTable table, to a DataGidView.I tried with this code

for (int c = 0; c <= i; c++)
{
dataGridView1.DataSource = dt1.Rows[i,1].ToString();
dataGridView1.Refresh();
}

but Nothing is displayed in dataGridView1. Please reply me if anyone know the solution.

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

Wendelius31-Jan-09 3:05

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