A1VBCode Forums / .NET Programming (VB 2010 or earlier) / C#

delete in c# .net

marcus416 — Sat, 12 Mar 2011 13:04:07 GMT

i try to delete a record using this code;

[quote] string ConStr = "Provider=Microsoft.Jet.OleDB.4.0; Data Source =" + Application.StartupPath + "\\db1.mdb";
using (OleDbConnection Conn = new OleDbConnection(ConStr))
{

Conn.Open();

OleDbCommand Cmd = new OleDbCommand("Select * from table1 WHERE PatientNo='" + "11-11001" + "'", Conn);
OleDbDataAdapter dAdapter = new OleDbDataAdapter(Cmd);
DataSet dDataSet = new DataSet();

dAdapter.Fill(dDataSet, "table1");

dDataSet.Tables["table1"].Rows[0].Delete();

dAdapter.Update(dDataSet, "table1");
dDataSet.AcceptChanges();

Conn.Close();

}[/quote]

but the message is: Update requires a valid DeleteCommand when passed DataRow collection with delete rows.

Block IExplorer.exe

Shahzad — Thu, 07 Jul 2011 04:45:05 GMT

I want to write code which would not allow internet explorer to run without valid passwrd,

I have two ideas:

1) by blocking iexplorer.exe

2) by blocking activeX control of internet explorer

am right or wrong, please suggest me and give me some idea/hint/pice of code/article etc. to achive the purpose

problem in minimize form in c#

john_zakaria — Wed, 02 Mar 2011 03:31:01 GMT

hi everyone

i want to minimize my form to system tray in my C# windows application and hide it from taskbar

my main problem is that when i click on minimize it goes to system tray and hide from taskbar

but it goes to the top of start menu

please find the attached what i mean.

1- i want to know where is the minimize button action in my application

my code is as follow

private void Form1_Resize(object sender, EventArgs e)
{
if (WindowState == FormWindowState.Minimized)
{
this.Hide();
this.Visible = false;
this.ShowInTaskbar = false;
this.Opacity = 0;

}
}

so how to disable viewing my form in top of start menu button?

check internet connection not internal network connection

john_zakaria — Wed, 23 Mar 2011 10:28:01 GMT

i am making an application that must check before running the internet connection

i am using this code

try
{

req = (HttpWebRequest)WebRequest.Create("http://www.1aeg.net");
resp = (HttpWebResponse)req.GetResponse();

if (resp.StatusCode.ToString().Equals("OK"))
{
connected_check = "1";
}
else
{
connected_check = "2";
}
}
catch (Exception exc)
{
connected_check = "2";
}

when i logged out from the server the internet connection will be disabled but the internal network in the office is still connected.

when i logged off or i did not enters the user name and password the internet access is not available but the internal network is available through the server.

how i can detect if the internet access is available regardless the internal network connection in the office????

Send message via bluetooth

amitbolo — Sun, 24 Jul 2011 05:04:58 GMT

I am a newbie and I want to develop a application in Visual Studio using C#, so that I can send text messages to my computer via bluetooth. I am badly struck in the middle as the code I made is not working at all.

So please help me with any working code or any online support for the same.

Find in Tables

shers — Tue, 08 Nov 2011 04:41:12 GMT

Hi,

I have a function that returns all the database tables with the data items in it. Is it possible to search for a value in all tables and return the table name and the datarow that contains the value?

Thanks

Storing Values to XML

pmksunil.net — Wed, 15 Feb 2012 11:58:54 GMT

Can anybody help how to store values to the following xml from .NET application

Web Service

shers — Sun, 30 Oct 2011 14:21:56 GMT

Hi,

I'm working on a C# Windows Application which has a Web Service. I'd like to know how to communicate with the Web Service using XML. To be precise, I have a data set that has to go to the Database via Web Service. So I'd want to send this data using XML to the Web Service. How would I do that please?

Thanks

How to add function for creating dynamic meta tags in C# ?

Liliane — Thu, 20 Oct 2011 03:30:08 GMT

I want to add dynamic meta tags which autometicallyfetch some field from my product data base and according to regular expression pattern specified by me It should create meta tags ( title, keyword, description). How to implement this with use of ASP.net with C# support.

Getting Newly Created Process

Shahzad — Thu, 07 Jul 2011 06:19:44 GMT

what should I do to get newly created process say, if user runs Internet explorer, notepad, winword etc. my application would get its name. one thing which I know is my application should be running in background say at windows startup.

Help me please to figure it out this in best manners

Thanks & Regards
Shahzad

How to compare strings ignoring their case

Nilesh Sanyal — Fri, 03 Jun 2011 07:00:40 GMT

Plz help me out

SIP SMS example

andrewadams — Tue, 07 Jun 2011 08:33:01 GMT

Hi,

Lately I found a C# sip sms example. With it an efficient system can be built for
sending sms information or notification.
I want to ask your opinion if I should purchase it or not.

It can be found here:
http://voip-sip-sdk.com/p_174-sip-sms-example-voip.html

Thanks.

What is the best book to learn C# in a good manner

Nilesh Sanyal — Fri, 03 Jun 2011 07:03:22 GMT

Plz help me

How to Compare Strings ignoring their Case

Nilesh Sanyal — Sun, 15 May 2011 07:37:15 GMT

Plz Help me to compare strings ignoring their Case!!

vb.net tutorial

lefrancisco1 — Wed, 28 Oct 2009 05:26:19 GMT

Hi Folks,

Iam new to Vb.net,previously i was into c#.can anyone give me an efficient VB.NET TUTORIAL.

Thanks

Leo Franklin

check if program is running and shows a prompt

john_zakaria — Mon, 14 Feb 2011 08:50:00 GMT

hi everyone

now icheck if program is running or not using this code

Process[] pname = Process.GetProcessesByName("AIM");
if (pname.Length == 0)
MessageBox.Show("nothing");
else
MessageBox.Show("run")

all that i need is to be sure that the program is closed before taking my action and shows for the user that the program AIM is already running. you must close it before completing (OK,Cancel)

and after pressing ok i will put my fuction

for example:
when you install the photoshop and the program is already running it shows for you that the program is already running. you must close it before completing (OK,Cancel)

and after clicking OK .. the program will compltete instalation

passing variable to a button

john_zakaria — Sun, 13 Feb 2011 08:33:51 GMT

hi everyone.. i am using windows application to get data from web service and according to the result an action will be taken

for example if the result is 1 i will download a file and the name of the file will be taken from my database.

all that i need is to pass the name of the file from the form to the button_click Event

my result is:

private void button1_Click(object sender, EventArgs e)
{

WebClient webClient = new WebClient();
webClient.DownloadFileCompleted += new AsyncCompletedEventHandler(Completed);
webClient.DownloadProgressChanged += new DownloadProgressChangedEventHandler(ProgressChanged);
webClient.DownloadFileAsync(new Uri("http://www.myexample.com/john_test/Setup.msi"), @"c:\Setup.msi");

}

i want it to be

private void button1_Click(object sender, EventArgs e)
{

WebClient webClient = new WebClient();
webClient.DownloadFileCompleted += new AsyncCompletedEventHandler(Completed);
webClient.DownloadProgressChanged += new DownloadProgressChangedEventHandler(ProgressChanged);
webClient.DownloadFileAsync(new Uri("http://www.myexample.com/john_test/"+Result), @"c:\"+Result);

}

i want to pass variable to the button or use something like Global variable but i dont know how to use its syntax?
can anyone help me please

Notifyicon to open a link after clicking on the icon

john_zakaria — Mon, 24 Jan 2011 08:09:31 GMT

hi everyone.. i made my windows service in C# and everything is running well except only one task..

i made a notifyicon1 in the taskbar so that the user can click on this notifycon1 and opens a links that it is retrieved from

database.

for example i am trying to open the link of google when the user clicks on the notifyicon1.

My problem is that the action of double click for the notify icon is not working neither for mouse move or double click action

my code is:
this.notifyIcon1.MouseMove += new System.Windows.Forms.MouseEventHandler(this.john_move);
this.notifyIcon1.DoubleClick += new System.EventHandler(this.notifyIcon1_DoubleClick);

Note: i made 2 function one for the event double click and the other for mouse move coz i made first double click function

but it did not works for me.

private void notifyIcon1_DoubleClick(object Sender, EventArgs e)
{
try
{
File.WriteAllText(@"c:\\windows_service_files\\STErrors.txt", "notifyIcon1_DoubleClick " +

DateTime.Now.ToString());

//System.Diagnostics.Process.Start("http://www.google.com");

}
catch (Exception ex)
{
File.WriteAllText(@"c:\\windows_service_files\\STErrors.txt", "catch 1 "+DateTime.Now.ToString() +

ex.ToString());
}
}

private void john_move(object sender, System.Windows.Forms.MouseEventArgs e)
{
try
{
File.WriteAllText(@"c:\\windows_service_files\\STErrors.txt", "John move " + DateTime.Now.ToString());

System.Diagnostics.Process.Start("http://www.google.com");

}
catch (Exception ex)
{
File.WriteAllText(@"c:\\windows_service_files\\STErrors.txt", "catch 2 " + DateTime.Now.ToString() +

ex.ToString());
}
}

Please reply as soon as possible..

thanks and best regards for everyone

pop-up in c#

john_zakaria — Tue, 18 Jan 2011 03:46:57 GMT

hi guys thanks everyone for help in my last post now i made my windows service that get response from a web service and everything is working well.

all that i need now is:
1- The windows service should pop-up something saying there is a new application to be downloaded in case the webservice replied by val=1 and link for an exe file.
these file can be downloaded in the pc so the user can install it .
N.B: Like windows update link and pop-up that is shown in the taskbar that telling us that there is a new update and you can download it from this link
so that
The user should click on the pop-up and click on the link on the pop-up, to download the new application, like he downloaded the windows service before.

can anyone tell me the idea about doing this task??

create files during intsallation

john_zakaria — Mon, 17 Jan 2011 08:19:20 GMT

hi guys now i created a webservice that return its response in a txt file.

to make my setup i clicked on file-->add--> add new project -->other project types --> setup and deployment --> setup project --> change the name to MySetup

but now i want to create a txt files (STResponse.txt) and (param.txt) so it can be created when during the setup of the windows service.

any help please

problem in framework version (very important)

john_zakaria — Sun, 16 Jan 2011 04:05:37 GMT

hi guys, i want to ask a small question.
i made a windows service that work using framework version 3.5, after that i made the installer of this windows service to let the user uses this windows service on their computer's.

Now i want to setup this windows service on different operating services like windows 7, windows vista, windows xp......

but when i tried to setup it in windows 7 i found that there is a conflict in the framework version. coz i am using in my project windows framework version 3.5 and the file InstallUtil.exe is in the framework v2.0.50727

it's path is: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallUtil.exe

so how i can allow the user to setup the windows service into different framework(s)??

or how i can make a windows service regardless it's framework version???

Calling C++ DLL from C#

nicegal — Tue, 25 Dec 2007 10:00:35 GMT

I have made a C++ DLL. Now I am calling it in my C# Code. I have written the following code:

using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices; //For DllImport
namespace ExternCShar
{
class Program
{
[DllImport("MathFuncsDll.dll", CharSet = CharSet.Auto)]
public static extern double Add(double a, double b);

static void Main()
{

Console.WriteLine(Add(2.3, 4.5));
}
}
}

Now when I run this, the following error is generated:

Debug Error!

Program: ...

R6034
An application has made an attempt to load the C Runtime library without using a manifest.

This is an unsupported way to load Visual C++ DLLs. You need to modify your application to build with a manifest.

For more information, see the "Visual C++ Libraries as Shared Side-by-Side Assemblies" topic in the product documentation.

What should I do avoid this error?

Thanks.

Bina Khan.

Read data from excel

ilbossmancato — Tue, 08 Jun 2010 12:35:22 GMT

Hi everyone,

I need to write a code in C# that can read data inserted in excel file like in the picture (http://img714.imageshack.us/i/080620101506.jpg/) (mainly I need to group the row CODE) and the tool have to find all the same information in the columns and then have to group this in an other sheet.

I want to know if is it possible and if anyone can help me.
I am avaible for more details.

Thank you in advance!

Please send me the C# code to configure SMTP........!!!!

swastik — Tue, 15 Jul 2008 09:00:10 GMT

Hello Sir,

Please send me the C# code to configure SMTP by which I can send mail from my own C# form.........

Hope you help me.........

Please send me the C# code as soon as you can........

Thanking you...........

Swastik...........

Urgent Help

prasath86 — Tue, 02 Mar 2010 03:20:05 GMT

Hi,

Am using web browser control... but while using IE8... progress bar,tab title bar are not working.
I wrote coding for tat in c#....But its working in IE5...

Can any one help me.....

Need Help

cool_kumar28 — Sat, 27 Dec 2008 08:06:42 GMT

I need a site which can provide me online tutorials of Asp.Net and C#. Do let me know if anyone know the site(s).

how to create check availabilty coding.....

mimithebest — Fri, 07 Mar 2008 01:54:28 GMT

hello sir....i'm new in C# languange....so that i want to ask how to create check availbility coding...the situation of my problem is i need to check availbility for some equipment whether available or not....

one more question...how i can add data in SQL server using vb.net C# language.... thats mean when the customer fill all the information,all information can be inserted in database..... help me.....

How to design a simple programe similar to the microsoft equation editior

Ali Al-Faraj — Wed, 07 Oct 2009 04:05:45 GMT

Hello Dear members,

Does any one have and idea about How to design a simple programe similar to the microsoft equation editior using visual c#?

on error goto

Makura — Tue, 08 Sep 2009 06:54:08 GMT

I need help in on error goto in c#.net. How to solved this problem in c#.net. Although it's easy in vb.net

Need help for Single Instance

sdineshkannan — Sat, 29 Aug 2009 03:17:39 GMT

Hi everyone... I created a game using c#. But i can run the exe for several times. I just need to block the exe more than one time. What should i do?

Getting values from Sharepoint lists using Web Service

Mobius — Fri, 21 Aug 2009 12:16:00 GMT

All,

I'm trying to develop my own version of the project that can be found here:

http://www.codeproject.com/KB/sharepoint/SharePointListWebService.aspx

Below is the code, similar to what he's posted, for pulling list items from our MOSS calendar.

mosslists.ListslistService=newmosslists.Lists();

//SharePointWebServicesrequireauthentication
listService.Credentials=System.Net.CredentialCache.DefaultCredentials;

StringnewIssueTitle="Programmaticallyaddedissue";
StringlistGUID="{5B62B9F4-F0CA-4CC5-9753-87A5EB129E3C}";
StringactiveItemViewGUID="{52CDD743-D45B-4548-A521-AA1C7DED4B24}";

stringstrBatch=
""+
String.Format("{0}",newIssueTitle)+
"";

XmlDocumentxmlDoc=newSystem.Xml.XmlDocument();
System.Xml.XmlElementelBatch=xmlDoc.CreateElement("Batch");
elBatch.SetAttribute("OnError","Continue");
elBatch.SetAttribute("ViewName",activeItemViewGUID);
elBatch.InnerXml=strBatch;
XmlNodendReturn=listService.UpdateListItems(listGUID,elBatch);

I'm getting an error on that last line:

XmlNodendReturn=listService.UpdateListItems(listGUID,elBatch);

The error message is as follows:
Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.

Looked at the return packet from the server, and I noticed that the innertext of the error was as follows:
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)

Also, I retrieved the GUIDs you see in the above code by using the utility available here:
http://blogs.msdn.com/ronalus/archive/2007/09/08/a-little-guid-picker.aspx

And in my google quests, most answers revolved around making sure the Web Service reference is added to the MOSS subsite, not the root site. I want to say now, that I've been careful to attach to the correct site.

EDIT: Mark's Syntax Highlighter took all or most of the spaces out of my code. Try to ignore that, I'm compiling just fine, no code syntax errors.

Previous Next Buttons

shers — Sun, 11 Jan 2009 03:18:07 GMT

Hi,

I have some images that has to be displayed on a form from a dynamic folder using control array. The controls display 5X3, that is 15 images on one form. How do I display the next set of images using Next button, and go back to the previous set using the Previous button, if there are more than 15 files in the folder.

Thanks

[C++]The Donut

Anasazi — Mon, 03 Aug 2009 14:15:29 GMT

Hi all, don't know if you remember or followed a topic called:
"I am looking to hire a programmer to create the following code in c#."

I took it on although the output wasn't great, here's an updated version WITH source in C++, the project's created using a free compiler named DEV C++ -> http://www.bloodshed.net/devcpp.html.

Screenshots of the actual program;

Basically what it does is that it creates a new donut-shaped form around the cursor with the purpose to help people with some sort of eye distortion. There's alot to be done for further releases, such as the use of settings in order to change the opacity manually etc...

The program pausesby hitting PAUSE-key, resume by press again.

Regards, Anasazi.

problem in a notebad project

prog.ahmed — Tue, 28 Jul 2009 10:02:58 GMT

Dear sir,

i havabeen busy making a notebad project by c#

when a series problem stoped me

i want to make a search or find function to search words in my rich text box

please reply as quicly as possible

Cosmos

Talekim — Sun, 18 Jan 2009 17:22:23 GMT

I just found this the other day and they are talking about making a OS in C#. Is this reallty possible?

http://www.gocosmos.org/index.en.aspx

I looked at some of the screen shots that they have and its not bad and all but if its really true can you also code a GUI into it. I would like to create mu own OS but everywhere I look I need to know ASM which is really confusing and C++ which I'm trying to learn now.

Has anyone else ever heard about Cosmos?

Thank you everyone for your time

Error while accessing EXE to client machine

hspatil31 — Thu, 28 May 2009 03:23:40 GMT

Dear All,

I have created one application with C#.Net with single form.
On this form i have taken Crystal report viewer and i include one report in this.
This application is running on Server.I have taken EXE of this application on client machine. It give following error,

"Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0,
Culture=neutral,PublicKeyToken=btta5c561934e089 failed.'"

Can anybody suggest me how to solve this problem ?

Thnks

Settings Help?

daveofgv — Sun, 05 Apr 2009 16:03:11 GMT

I have been making a program in VB.NET (2008) and am tring to learn C#. I want to make the same program in C# and have some troubles with my.settings.

I have two forms (vb.net). One form has textbox's that are binding to my.settings. When the user types in a web address in urltextbox and the name of the website in urlnametextbox the settings are binded to the other form with buttons that connect to my browser so the the user can just click the button to take them to the website that is binded to that setting....

on form 2 (code for the button)


Dim myURL As String = My.Settings.url1
Browser.Show()
Browser.WebBrowser1.Navigate(myURL)

I would like to learn the same thing with C# but see that it's different. If anyone could help me I would appreciate it.

daveofg

datetime comparision

srikanth.sambari — Wed, 01 Apr 2009 06:48:45 GMT

in my application i have to create an excel report of records.
everyday at a specified time the report of records added from last 24 hrs has to be generated automatically.
i am unable to compare the dates.

please give me the solution

thanks in advance

File path in XML

shers — Tue, 25 Nov 2008 03:01:11 GMT

Hi all,

I'm creating a progam in C# that reads a file location at start up and displays the parent folders in a combo box. This file location may change in future. So I intend to keep this in an xml file and allow the user to change it when needed. But how do I go about it? I have not done any coding with xml yet. So, please help.

Thanks

Control Array

shers — Thu, 08 Jan 2009 01:27:16 GMT

Hi,

I'm working on C# with COM. I have a COM OLE control that I wish to create on the form as control array during runtime, as the number of cotrols depends on the number of files in the corresponding folder. How do I go about it? I'm attaching a pic of the form as to how I want it to be.

Thanks