C# Discussion Boards - CodeProject

Nishad8513-Sep-07 20:15

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........................

Re: Delete Data

\laddie13-Sep-07 20:26

\laddie

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");
}

Re: Delete Data

rohitsrivastava13-Sep-07 22:48

rohitsrivastava

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

Re: Delete Data

rohitsrivastava13-Sep-07 22:49

rohitsrivastava

13-Sep-07 22:49

yes

Re: Delete Data

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

Re: Delete Data

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

\laddie

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

rohitsrivastava

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

\laddie

13-Sep-07 19:39

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

Re: Regarding Telnet

\laddie13-Sep-07 19:40

\laddie

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() ;

Urgent button disabling problem

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

\laddie

13-Sep-07 19:38

What you exactly want button click will be fired after the text chenges to pass because you have enabled the button.

Re: Urgent button disabling problem

Sunshine Always13-Sep-07 20:11

Sunshine Always

13-Sep-07 20:11

i am clicking the button before the text changes to pass.

Re: Urgent button disabling problem

vikas maan13-Sep-07 20:58

vikas maan

13-Sep-07 20:58

Hi In a separate thread, check the messages in application queues parallely.
If any message of button click comes and you are doing "pass" processing work
delete that message from application quese. Size of application queue would be 8.

Smile | :)

not inheriting control from base class

falles0113-Sep-07 17:40

falles01

13-Sep-07 17:40

Can anyone tell me how I can have a control tht I don't want other classes to inherit?

I have a base class and the child class needs to inherit but I don't want it to inherit one of the comboboxes. I need to delete it.

I tried to go into the designer class and declare protected but it still inherits.

Thank you

Sianny aka Sharny

Re: not inheriting control from base class

vikas maan13-Sep-07 21:00

vikas maan

13-Sep-07 21:00

Hi,
Make it as a sealed class.
Smile | :)

Re: not inheriting control from base class

rohitsrivastava13-Sep-07 21:15

rohitsrivastava

13-Sep-07 21:15

i suppose use non abstract class but not sure

Re: not inheriting control from base class

Pete O'Hanlon13-Sep-07 22:16

Pete O'Hanlon

13-Sep-07 22:16

No. A non abstract class is just a class that can be instantiated. The answer to this is to make the class sealed so that it cannot be inherited from.

public sealed class CannotBeInherited
{
}

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

To copy a file

P_Elza13-Sep-07 17:10

P_Elza

13-Sep-07 17:10

How to copy a file to a different folder?

FileInfo[] fis = d.GetFiles();
  foreach (FileInfo fi in fis) 
  { 
     fi.CopyTo(Destino + "\\" + fi.Name);
  }

File.Copy(source,destination);

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 1:57

Refresh

ᐊ Prev 1...8538 8539 8540 854185428543 8544 8545 8546 8547 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.