After editing a dataset my changes are not visible in the datagrid - C# Discussion Boards

sangramkp9-Jul-07 2:36

9-Jul-07 2:36

Actualli I want to store the listbox items into a database.
So I wanted to convert the items in the list box to arraylist.

But I don't know how to this.

C# Console program .Net Security

foxirl9-Jul-07 1:45

foxirl

9-Jul-07 1:45

Hi,

I have a small c# console program which is deployed on a network drive in over 100 sites. However when I update the code and redeploy the executable I have to manually phone each user and set the .net framework security on each machine. Is there an easy way around this. Can I write some code top handle this?

Thanks
John

Re: C# Console program .Net Security

Dave Sexton9-Jul-07 2:23

Dave Sexton

9-Jul-07 2:23

Have a look at ClickOnce Deployment[^].

I think I'm going to call my next project "Chuck Norris". It's a sure way to guarantee it's unbreakable.

• • •

But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson

how to read Mobile no digit by digit?

Nisar Inamdar9-Jul-07 1:38

Nisar Inamdar

9-Jul-07 1:38

Hello frnds,
i want to read the mobile no. entered in txtbox digit by digit....

Nisar Inamdar.

Re: how to read Mobile no digit by digit?

Bekjong9-Jul-07 1:52

Bekjong

9-Jul-07 1:52

Use the TextChanged event.

Standards are great! Everybody should have one!

Re: how to read Mobile no digit by digit?

Tamimi - Code9-Jul-07 1:56

Tamimi - Code

9-Jul-07 1:56

try this :
for(int i=0;i<textBox1.Text.Length-1; i++)
{
MessageBox.Show(textBox1.Text[i].ToString());
}

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: how to read Mobile no digit by digit?

valerian.precop9-Jul-07 2:31

valerian.precop

9-Jul-07 2:31

I think you could use the textBox1_KeyDown(object sender, KeyEventArgs e) event for your textbox...here you have e.KeyCode and other more properties that can help you very much.

Just call me Valy... Smile | :)

After editing a dataset my changes are not visible in the datagrid

kudorgyozo9-Jul-07 1:32

kudorgyozo

9-Jul-07 1:32

(This application is a Pocket PC application)

I have the following problem:
I create a dataset in code and add some rows to it. Then i show these rows using a datagrid.

<br />
<br />
            DataSet ds = new DataSet("dataset");<br />
            DataTable mytable = new DataTable("vizite");<br />
            DataRow dr1, dr2;<br />
<br />
            DataColumn dc = new DataColumn("bifat1");<br />
            dc.Caption = "bifat1";<br />
            dc.DataType = System.Type.GetType("System.Boolean");<br />
            <br />
            DataColumn dc2 = new DataColumn("bifat2");<br />
            dc.Caption = "bifat2";<br />
            dc.DataType = System.Type.GetType("System.Boolean");<br />
<br />
            mytable.Columns.Add(dc);<br />
            mytable.Columns.Add(dc2);<br />
<br />
<br />
            dr1 = mytable.NewRow();<br />
            dr1["bifat1"] = true;<br />
            dr1["bifat2"] = false;<br />
            mytable.Rows.Add(dr1);<br />
<br />
            dr2 = mytable.NewRow();<br />
            dr2["bifat1"] = true;<br />
            dr2["bifat2"] = false;<br />
            mytable.Rows.Add(dr2);<br />
<br />
            ds.Tables.Add(mytable);<br />
<br />
            dataGrid1.DataSource = ds.Tables["vizite"];<br />
<br />

<br />
<br />
            int i;<br />
            <br />
            for (i=0;i<ds.Tables["vizite"].Rows.Count;i++)<br />
            {<br />
                object cell = null;<br />
                string cellstr;<br />
<br />
                cell = ds.Tables["vizite"].Rows[i].ItemArray[0];<br />
                cellstr = System.Convert.ToString(cell);<br />
                if (cellstr == "True")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[0] = "yes";<br />
                }<br />
                if (cellstr == "False")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[0] = "no";<br />
                }<br />
<br />
                cell = ds.Tables["vizite"].Rows[i].ItemArray[1];<br />
                cellstr = System.Convert.ToString(cell);<br />
                if (cellstr == "True")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[1] = "yes";<br />
                }<br />
                if (cellstr == "False")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[1] = "no";<br />
                }<br />
<br />
            }<br />

The problem is this code is not doing anything...i cant see the changes. The table is still the same Cry | :((

Re: After editing a dataset my changes are not visible in the datagrid [modified]

Martin#9-Jul-07 1:43

Martin#

9-Jul-07 1:43

Hello,

What does the debugging tell you?
Is the code were you set a value to the Item excecuted?
If yes, maybe you only need a "Refresh()" or "Invalidate()" of the control.

Apart from that:
Use "else if".
string.Equals
Don't always access an Item over the whole Indexer structure (Row actRow)

All the best,

Martin

P.S.:
Just saw that it is your first post here on the forum.
Your question is detailed and has a good subject statement! (But you should use the "pre" Tag for code snippets)
Got my '5' to say: Wellcome!

Re: After editing a dataset my changes are not visible in the datagrid

kudorgyozo9-Jul-07 1:54

kudorgyozo

9-Jul-07 1:54

The code inside the if is executing i've checked when i debugged the program.
The instructions inside these 'if's are executing as they should

<br />
                if (cellstr == "True")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[0] = "yes";<br />
                }<br />
                if (cellstr == "False")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[0] = "no";<br />
                }<br />
<br />
                cell = ds.Tables["vizite"].Rows[i].ItemArray[1];<br />
                cellstr = System.Convert.ToString(cell);<br />
                if (cellstr == "True")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[1] = "yes";<br />
                }<br />
                if (cellstr == "False")<br />
                {<br />
                    ds.Tables["vizite"].Rows[i].ItemArray[1] = "no";<br />
                }<br />

I really don't know what the problem is! Dead | X|

I've tried with this.refresh and this.update too...well i'll try with invalidate too. though i have a feeling it wont work. Sigh | :sigh:

...
It doesn't. Sniff | :^)

Re: After editing a dataset my changes are not visible in the datagrid

sam#9-Jul-07 1:59

sam#

9-Jul-07 1:59

use dataGrid1.Refresh()

still not working...

kudorgyozo9-Jul-07 2:10

kudorgyozo

9-Jul-07 2:10

This doesn't work either. I don't think that i get no changes because i need to make refreshes.. but i don't know what else should i do or what am i doing wrong.

-- modified at 8:17 Monday 9th July, 2007

Re: After editing a dataset my changes are not visible in the datagrid

sam#9-Jul-07 2:21

sam#

9-Jul-07 2:21

sorry!! i didn't see your code.there are two mistakes.
1. Firstly when you added Column you specified their Type as Boolean and now u r changing the values.
2.when you assign the data source property with out making any table style structure it automatically generate table style for it.
put DataGrid1.TableStyles.Clear() before reassigning data source and then use refresh

Re: After editing a dataset my changes are not visible in the datagrid

kudorgyozo9-Jul-07 2:35

kudorgyozo

9-Jul-07 2:35

I forgot to mention that i tried with "System.String" too instead of "System.Boolean" but it didn't work either.(used both true as boolean and "true" as string) I'm sorry but i didn't quite understand where should i put that DataGrid1.TableStyles.Clear(). After i add the rows to the dataset and before the 'for' cicle. Confused | :confused:

Re: After editing a dataset my changes are not visible in the datagrid

sam#9-Jul-07 2:58

sam#

9-Jul-07 2:58

hmm.. i think some part is missing. check the following code .its working fine.in case any confusion please feel free for messaging me Smile | :)

DataSet ds = new DataSet("dataset");
System.Data.DataTable mytable = new System.Data.DataTable("vizite");

//fill data in grid
private void fillGrid()
{
DataRow dr1, dr2;

DataColumn dc = new DataColumn("bifat1");
dc.Caption = "bifat1";
//dc.DataType = System.Type.GetType("System.Boolean");

DataColumn dc2 = new DataColumn("bifat2");
dc.Caption = "bifat2";
//dc.DataType = System.Type.GetType("System.Boolean");

mytable.Columns.Add(dc);
mytable.Columns.Add(dc2);

dr1 = mytable.NewRow();
dr1["bifat1"] = "True";
dr1["bifat2"] = "False";
mytable.Rows.Add(dr1);

dr2 = mytable.NewRow();
dr2["bifat1"] = "True";
dr2["bifat2"] = "False";
mytable.Rows.Add(dr2);

ds.Tables.Add(mytable);

dataGrid1.DataSource = ds.Tables["vizite"];

}

///

/// changes values of grid
///

private void changeValues()
{
for (int i = 0; i < mytable.Rows.Count; i++)
{

if (mytable.Rows[i][0].ToString() == "True")
{
mytable.Rows[i][0] = "yes";
}

if (mytable.Rows[i][1].ToString() == "True")
{
mytable.Rows[i][1] = "yes";
}
}
dataGrid1.Refresh();
}

problem in running c# using sql server in other client

asdf17539-Jul-07 1:28

asdf1753

9-Jul-07 1:28

Hi I wrote an aplication using C# that works with Sql Server 2000 and it works right in my computer but when i wanna run it on other computer in my lan (that intalled .NET framework on it) there is an error in accessing to database and when i installed Visual Studio.NET2005 on this computer my application worked right!
So it apears that needs some library to run my application to access sql server.
(when i run my application until using database it works right and problem is in accessing to sql server)
the connection string is complete with user id and password and name of sql server.
please help me Confused | :confused:

Re: problem in running c# using sql server in other client

originSH9-Jul-07 1:33

originSH

9-Jul-07 1:33

Any client should be using atleast the latest MDAC[^] and ideally the latest Native Sql Client[^].

problem in running c# using sql server in other client

asdf17539-Jul-07 1:27

asdf1753

9-Jul-07 1:27

Hi I wrote an aplication using C3 that works with Sql Server 2000 and it works right in my computer but when i wanna run it on other computer in my lan (that intalled .NET framework on it) there is an error in accessing to database and when i installed Visual Studio.NET2005 on this computer my application worked right!
So it apears that needs some library to run my application to access sql server.
(when i run my application until using database it works right and problem is in accessing to sql server)
the connection string is complete with user id and password and name of sql server.
please help me Confused | :confused:

Re: problem in running c# using sql server in other client

Paul Conrad13-Jul-07 13:15

Paul Conrad

13-Jul-07 13:15

What is the error that occurs?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

XMLHTTP40Class Status 500 error.

ramdil9-Jul-07 1:17

ramdil

9-Jul-07 1:17

Hi All
i am accessing a webservice in my local machine through application which is of c# code and using XMLHTTP40 class
i have condition to check the status of the XMLHTTP40 .i created the object of it and was checking a condition like below

if (objXmlHTTP.status != 200)
{
}

i am getting status value as 500 .Why status is giving me 500 . i restarted my webservice and then restarted my machine but still status value is 500. can any one help me.

Advanced thanks

Regards
DilipRam

Re: XMLHTTP40Class Status 500 error.

Pete O'Hanlon9-Jul-07 1:37

Pete O'Hanlon

9-Jul-07 1:37

Have a look in your event logs and see if there are any IIS events written there. Status 500 is the catch all "something is wrong with the server" error, so without more information there is little we can help you with.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Re: XMLHTTP40Class Status 500 error.

ramdil9-Jul-07 2:40

ramdil

9-Jul-07 2:40

Hi Thanks for responding

when i checked the event log
i found entries like this
11:07:29 127.0.0.1 GET /_vti_bin/owssvr.dll 500
11:07:29 127.0.0.1 GET /MSOffice/cltreq.asp 404
11:07:29 127.0.0.1 POST /xmlsportsin/xmlsportsin.asmx 500
11:09:21 127.0.0.1 POST /xmlsportsin/xmlsportsin.asmx 500..
i looked the log file in the following path
C:\WINNT\system32\LogFiles\W3SVC1...in my local machine.

Any idea.

Regards
DilipRam

Re: XMLHTTP40Class Status 500 error.

Vasudevan Deepak Kumar9-Jul-07 2:04

Vasudevan Deepak Kumar

9-Jul-07 2:04