Re: Delete Data - C# Discussion Boards

Joe13-Sep-07 22:13

Joe

13-Sep-07 22:13

P_Elza wrote:
not at all serching

Hope you are checking if the directory is existing using
Directory.Exists ?

P_Elza wrote:
search the particular element from an xml file

Are the innertext's value assigned to the intended variables?

Probably debugging the app will help you understand where it fails.

P_Elza13-Sep-07 22:28

P_Elza

13-Sep-07 22:28

Tis is working if the file is in my hard disk itself.
but not when it comes to server. If i map the server i can search.like
y:\\my folder\\myfolder
am tring to make an exe. different people will map to different drive.
so i cant give like that.should give like \\server\\serverfolde\\folder\\

Pete O'Hanlon14-Sep-07 0:21

Pete O'Hanlon

14-Sep-07 0:21

Well, that will never work because a server must start with a double slash, so in your syntax this would be \\\\server\\serverfolde\\folder\\. You can, of course, prefix this with the @ sign so this becomes @"\\server\serverfolde\folder\".

Now, your application will need to have permissions to work with these folders - make sure that it has the permissions to do this.

Deja View - the feeling that you've seen this post before.

rohitsrivastava13-Sep-07 23:01

13-Sep-07 23:01

hi
you can take the toolbox from openfiledialogbox1

P_Elza13-Sep-07 23:04

P_Elza

13-Sep-07 23:04

I am tring to make an exe.

Delete Data

Nishad8513-Sep-07 20:15

Nishad85

13-Sep-07 20:15

Hi,
I want to delete data from datbase by entering a year in text box. If the there no data then i want to show "the selected date does not exist". How can i do this? pls help me?
Please write code here........................

\laddie13-Sep-07 20:26

13-Sep-07 20:26

It should look something like this.

SqlConnection con = new SqlConnection(connecitonstring);
SqlCommand cmd = new SqlCommand("delete from table where year = @year",con);

cmd.Parameters.Add("@year",SqlDbType.Int).Value = int.Parse(TextBox1.Text);

if(cmd.ExecuteNonQuery() > 0)
{
Console.WriteLine("Record deleted successfully");
}
else
{
Console.WriteLine("No data found");
}

rohitsrivastava13-Sep-07 22:48

13-Sep-07 22:48

in select statement
strdelete="delete from tablename where datefield='date'
objsqlconn=new sqlconnection("user id=sa;password=;data source=servername")
objsqlconn.open
try
Dim vbmsg As String
vbmsg = MessageBox.Show("Are u sure to delete this record", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Information)

If vbmsg = vbYes Then
strdelete = "delete from tablename where datefield='date'"

objsqlcmd = New sqlcommand(strdelete, objsqlconn)
objsqlcmd.executenonquery()
Else
MessageBox.Show("There is no field exits")

End If

catch (ex as exception)
exception(ex.message)
end try

rohitsrivastava13-Sep-07 22:49

13-Sep-07 22:49

yes

Colin Angus Mackay13-Sep-07 23:24

Colin Angus Mackay

13-Sep-07 23:24

rohitsrivastava wrote:
yes

Upcoming FREE developer events:
* Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

Dave Kreskowiak14-Sep-07 6:20

Dave Kreskowiak

14-Sep-07 6:20

Why do I get the feeling the OP is going to copy'n'paste the code thrown at him and wonder why it doesn't work?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Combo Box

sajid.salim.khan13-Sep-07 20:15

sajid.salim.khan

13-Sep-07 20:15

How to Fill Combo Box From SQL2000 Tables

Rose | [Rose]

SAS

Re: Combo Box

\laddie13-Sep-07 20:47

13-Sep-07 20:47

SqlCommand cmd = new SqlCommand("SELECT [field] FROM table",connection);
SqlDataReader dataReader = cmd.ExecuteDataReader();

while(dataReader.Read())
{
comboBox1.Items.Add(new llistItem(dataRead[0],dataRead[0]);
}

dataRead.Close();

Hope this helps

Re: Combo Box

rohitsrivastava13-Sep-07 22:08

13-Sep-07 22:08

hi this is the coding to fill the combo
strselect="select fieldname from tablename "
objsqlconn=new sqlconnection("userid=sa;password=;data source=servername")
objsqlconn.open()
objdataset=new dataset
objsqlcmd=new sqlcommand(strselect,objsqlconn)
objsqldataadapter=new sqldataadapter(objsqlcmd)
objsqldataadapter.fill(objdataset,"Tablename")
cmbname.datasourc=objdataset.table("Tablename")
cmbname.displaymember="Fieldname"
cmbname.displayvalue="fieldname"

this is how to fill the combo
have a nice day

Iterarting menu item

Amar Chaudhary13-Sep-07 19:54

Amar Chaudhary

13-Sep-07 19:54

when I iterate through form controls and their child controls
it works fine for every thing else expect when it comes to menu items it only returns only

the top item and not the child ones

the code I am using is

void ModifyControls(Control.ControlCollection ControlCollection)
      {
          //iterator
          for (int i = 0; i < ControlCollection.Count; i++)
          {
              if (ControlCollection[i].GetType() != typeof(Menu))
              {
                  // add control
                  Array.Resize(ref Controls, Controls.Length + 1);
                  Controls[Controls.Length - 1] = new MyControls(ControlCollection[i]);

                  // save control specific formating and apply it
                  Controls[Controls.Length - 1].SaveFormating();
                  //itrate through child controls
                  ModifyControls(ControlCollection[i].Controls);
              }
          }
      }

Thanks and Regards
Amar Chaudhary

It is Good to be Important but!
it is more Important to be Good

Re: Iterarting menu item

ElSpinos13-Sep-07 22:42

ElSpinos

13-Sep-07 22:42

Greetings Amar,

If you look at how the MenuStrip control works you will notice that it houses a different type of collection, the ToolStripItemCollection in its MenuStrip.Items property. You need to iterate each ToolStripMenuItem in that collection to get its children.

After that, the ToolStripMenuItem has another ToolStripItemCollection in it's DropDownItems property, you now need to iterate through this collection to get it's children and so forth... consider the following example:

<br />
void ListControls(Control parentControl)<br />
{<br />
	foreach (Control control in parentControl.Controls)<br />
	{<br />
		MessageBox.Show("Control Type   : " + control.GetType().ToString() + "\n" +<br />
		                "Has Children   : " + (control.Controls.Count > 0 ? "Yes" : "No") + "\n");<br />
		<br />
		// Perform the child-find functionality on the ControlCollection here.<br />
		if (control.Controls.Count > 0)<br />
		{<br />
		// Call ourselves to discover additional children...<br />
		 this.ListControls(control);<br />
		}<br />
		<br />
		// Get the sub menus of a MenuStrip.<br />
		// * Test for the type of control, we're looking for the MenuStrip here...<br />
		// TODO: Add this to a different function to nest-find child tool strips.<br />
		if (control.GetType() == typeof(MenuStrip))<br />
		{<br />
		 // As you can see, the menu houses a collection of items not controls, notice this is now a ToolStripItemcollection not ControlCollection.<br />
		 foreach (ToolStripMenuItem toolStripMenuItem in ((MenuStrip)control).Items)<br />
		 {<br />
		  MessageBox.Show("---> Menu Strip '" + ((MenuStrip)control).Text + "' has '" + toolStripMenuItem.Text + "' as a child item.");<br />
		  // Test if tool strip has child items, notice this is a ToolStripItemcollection too.<br />
		  if (toolStripMenuItem.DropDownItems.Count > 0)<br />
		  {<br />
		   // Call your nested-find function...<br />
		  }<br />
		 }<br />
		}<br />
	}<br />
}<br />

Basically, the MenuStrip needs to be treated like a TreeView as it can contain a complex hierarchy. I hope this helps... Have a great weekend!

Fernando Mendes
Senior .NET Developer, Architect

Re: Iterarting menu item

Amar Chaudhary14-Sep-07 3:12

Amar Chaudhary

14-Sep-07 3:12

thanks for the help
Amar Chaudhary

It is Good to be Important but!
it is more Important to be Good

Regarding Telnet

pashitech13-Sep-07 19:31

pashitech

13-Sep-07 19:31

In my application I need to use telnet to execute some commands so please help me to this.

How to connect to telnet and how to execute the commands in c#.net

Please help me on this
Thanks in advance

prashanth,
s/w Engineer,
Syfnosys.

Re: Regarding Telnet

\laddie13-Sep-07 19:39

13-Sep-07 19:39

Check this. http://www.activexperts.com/activsocket/howto/telnet/aspnetc/

Re: Regarding Telnet

\laddie13-Sep-07 19:40

Urgent button disabling problem

13-Sep-07 19:40

Hope you google before you post question next time Smile | :)

Re: Regarding Telnet

PIEBALDconsult14-Sep-07 4:44

PIEBALDconsult

14-Sep-07 4:44

I use System.Net.Sockets.TcpClient and System.Net.Sockets.NetworkStream.

System.Net.Sockets.TcpClient socket = new System.Net.Sockets.TcpClient ( Host , Port ) ;
socket.NoDelay = true ;
System.Net.Sockets.NetworkStream stream = socket.GetStream() ;

Sunshine Always13-Sep-07 19:29

Sunshine Always

13-Sep-07 19:29

hi in my code, i am saying

button.enabled = false;
...
...
...
...
progressbar.performstep();
label.text = "Pass";
button.enabled = true;

the button is grayed out during this, but if i have clicked during this, it takes the click event after "Pass" is displayed.
how do i prevent this? i need an urgent solution. please see if anyone can help me with some suggestion.

thanks.

Re: Urgent button disabling problem

\laddie13-Sep-07 19:38