Database

Re: How to iterate thru all the elements of Datagrid (windows forms)

6-Aug-06 9:38

Just one more question here, God I'm a real new commer here,

ah how do u empty a datagrid.
I want the datagrid showing an existing set of records to get empty when I click a button for adding a new record. Its actually a master detail form. The master table is linked with a set of textboxes and comboboxes and The details are in the datagrid. I hope the scenario is clear now and I repeat I'm using .net 1.1 and working in Windows Forms. So I need the info abt System.windows.Forms not the other one

thanks in advance...

Rocky

Izak -7-Aug-06 0:12

Izak -

7-Aug-06 0:12

clear the datascource

grdDetails.DataSource = Nothing

Re: How to iterate thru all the elements of Datagrid (windows forms)

Rocky#7-Aug-06 3:23

Re: How to iterate thru all the elements of Datagrid (windows forms)

7-Aug-06 3:23

Thanks I got this idea a little while b4 I read this but I really appreciate it.

Rocky#7-Aug-06 3:28

Re: How to iterate thru all the elements of Datagrid (windows forms)

7-Aug-06 3:28

Well right now I'm working on that same form to save the data. I've made the sqlDataadapters for the master and the detail tables which offcourse have the update,select insert, del commands.
But I'm a bit confused in whether if I should add() the new row of data in the master table b4 taking the input from the datagrid or not.

Can anyone plz give me a few guidlines or a tip or 2 abt this. I'm doin this for the first time actually. If u can give any useful Urls, that wuold be nice too.

thanks

Rocky#7-Aug-06 20:04

Re: How to iterate thru all the elements of Datagrid (windows forms)

7-Aug-06 20:04

Can anybuddy provide me some good helping material (reading, code etc) for making master detail forms (C# preferably)

_AK_7-Aug-06 20:12

_AK_

7-Aug-06 20:12

You can get so many examples on net for that if you will use google : Smile | :)

here is the one:
http://msdn2.microsoft.com/en-us/library/c12c1kx4.aspx

Best Regards,
Apurva Kaushal

Re: How to iterate thru all the elements of Datagrid (windows forms)

Rocky#8-Aug-06 20:45

Re: How to iterate thru all the elements of Datagrid (windows forms)

8-Aug-06 20:45

Thanks a lot, I appreciate it. yesterday I worked on the form and its del command is working allright now. I havent worked on updates as yet.

I'm having a little problem in inserting data in the detail table. Its shown in a datagrid and I dont know, the records get inserted automatically thru the grid. Its strange for me. How can we stop this behaviour ir use it more inteligently for our purpose?

Thanks a lot...

Rocky#8-Aug-06 21:18

Re: No service found for SQL

8-Aug-06 21:18

private void MakeReadOnly()
{
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.ReadOnly = true;
}

I think I got the clue here. is that it? Smile | :)

No service found for SQL

Skanless4-Aug-06 15:58

Skanless

4-Aug-06 15:58

I had a hard time installing MSDE 2000 onto my system but I eventually did. However, when I check my add remove programs all I see in there is Microsoft SQL CE 2.0 Server Tool but no SQL server. Futhermore everytime I re-start I get a message that states:"The system can not find the file specified". First I am not sure if MSDE was fully installed, since I was getting an error message before. Second: I am not sure how to assign service to application since its computer name appears in there but yet it can nto find service.

1. So my question is how do I assign service to SQL server?

2. How do I know that it is MSDE that is installed?

3. I am getting an error when attempting to start MSSQL Server AD Helper?

Thanks and any information which can help will be greatly appreciated.

Greg

Coding makes the world go round!!!

Rob Graham5-Aug-06 4:02

Rob Graham

5-Aug-06 4:02

1. You shouldn't have to do anything, install should take care of this.
2. from your description, it's not. You should be able to open the services admin tool , and see mssqlserver service. you should be able to start and stop it. There shouldbe a small "server" icon in the system tray (XP). A right click there should get "open Sql Server Manager" as a menu item. from the manager you should be able to start/stop the server, Sql Server agent and DTC.
3. if the server itself is not running, the AD helper can't start.

I would uninstall and try again (what problems did you have installing it - what OS are you installing to?)

Re: No service found for SQL

Skanless7-Aug-06 18:43

Skanless

7-Aug-06 18:43

I restarted and before I knew it was up and running fine with service and everything. Thanks

PS: I was using XP.

Greg

Coding makes the world go round!!!

Shifting over a string

Tom Wright4-Aug-06 8:50

4-Aug-06 8:50

select SUBSTRING(dmv2_data_text, 40, DATALENGTH(DMV2_DATA_TEXT))
from dmv2 WHERE DMV2_RCD_TYPE = 'R'

When I run this query sometimes there's a carriage return sometimes there isn't. Is there a way to inspect the first char and see if there is a CR and if so shift the whole string over one more space to remove it?

Thanks

Tom Wright
tawright915@gmail.com

Eric Dahlvang4-Aug-06 9:12

4-Aug-06 9:12

SELECT CASE WHEN SUBSTRING(dmv2_data_text, 40, 1) = CHAR(13)
THEN SUBSTRING(dmv2_data_text, 42, DATALENGTH(DMV2_DATA_TEXT)) 
ELSE SUBSTRING(dmv2_data_text, 40, DATALENGTH(DMV2_DATA_TEXT)) 
END
FROM dmv2 WHERE DMV2_RCD_TYPE = 'R'

If it is a carraige return, then add two (carriage return + line feed).

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Tom Wright7-Aug-06 4:26

7-Aug-06 4:26

nope still didn't do it. I may have to just live with is and remove it in my code instead of thru SQL.

Thanks

Tom Wright
tawright915@gmail.com

Eric Dahlvang7-Aug-06 5:05

7-Aug-06 5:05

TableName:MyTestTable
ColumnName:TestCol

Two Records:
1='

This<br />
is a test

'

2='

This is also<br />
a test

SELECT '--' + CASE WHEN SUBSTRING(TestCol, 5, 1) = CHAR(13)
THEN SUBSTRING(TestCol, 7, 256) 
ELSE SUBSTRING(TestCol, 5, 256) 
END
FROM MyTestTable

Result:

--is a test<br />
-- is also<br />
a test<br />

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Tom Wright7-Aug-06 5:15

7-Aug-06 5:15

Okay, I still could not get it to work. So I copied the data from Query Analyzer and pasted into a hex editor and saw that the char before my string is a hex 20...a space. So I tried the query you suggested only make the CHAR(13) to a CHAR(20) and CHAR(32)...still did not work.

Could there be something else there and the system sees and is not reading it right?

Thanks for the help

Tom Wright
tawright915@gmail.com

Eric Dahlvang7-Aug-06 5:24

7-Aug-06 5:24

I assume you've tried LTRIM()...

Tom Wright wrote:
Could there be something else there and the system sees and is not reading it right?

Try this to find out:

select ASCII(SUBSTRING(dmv2_data_text, 40, 1)) AS AsciiCode<br />
from dmv2 WHERE DMV2_RCD_TYPE = 'R'

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Tom Wright7-Aug-06 7:00

7-Aug-06 7:00

That did it. The correct code was a 10. Strange.

Thanks for the help

Tom Wright
tawright915@gmail.com

Eric Dahlvang7-Aug-06 7:20

7-Aug-06 7:20

Glad it worked.
FYI:

13 = carriage return<br />
10 = line feed

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Tom Wright7-Aug-06 7:21

7-Aug-06 7:21

Eric, mind if I ask you another question.

I'm calling a SP like this from my code:
myConnection.Open();
SqlCommand myCommand = new SqlCommand("EXEC LA_SP_NYSPINRESPONSE '"+ recType +"', 'P', '"+ Encoding.UTF8.GetString(ByteBuffer, 0, ByteBuffer.Length) +"', " + TrackNumber, myConnection);
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();

This works great however on one of repsonses that I'm writing out there is a single quote in the data, thus causing a problem when passing this data to my SP. It thinks it's end quote to a string. Would parameters be better, to pass data that way then to concante it like I'm doing?

Thanks

Tom Wright
tawright915@gmail.com

Eric Dahlvang7-Aug-06 8:04