|
hi
i need it to work when running it in c# e.g.
string test0002 = "Select room_code from room_types where room_code like '_'";
but this doesnt work it seems to only look for a field called _ not containing this character??
any suggestions?
cheers
|
|
|
|
|
Did you read the documentation under the section I mentioned?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
I want to create a Reminder application (windows application using C#.net)which need to be started as soon as system gets boot up. To acheive this task I need to use windows service application but I think windows service application doesn't support GUI application So can any one plz help me out to find the solution.
My main requirement is:-
1. Application needs to be started as soon as computer started.
2. It should have a GUI.
If you know the solution then plz let me know ASAP.
Best Regards,
Chandan Kumar Gupta
|
|
|
|
|
Chandan_Kr wrote: I think windows service application doesn't support GUI application
It can. It's not good practice, but it can.
You could always put something in the startup folder to autostart.
|
|
|
|
|
I agree, you can get the path using this:
Environment.GetFolderPath(Environment.SpecialFolder.Startup); The first time you start the program (manually) you could make a shortcut to the application in this folder.
Matthew Butler
|
|
|
|
|
I have a string as
loadplaylist "playlistname=xyz";instancename=abc"
I have written regex as
[^\p{Cc}\\r\\n\\a\\e\\b\\t][\S]*[a-zA-Z0-9\p{Po}\s\p{Sm}]*[^\p{Cc}\\r\\n\\a\\e\\b\\t]
which will remove tabs, backspaces.......and many more from the leading and trailing sides of string.
But, how I can remove the tab and backspace if it is in middle of string as
loadplaylist "playlistname=\txyz";instancename\b=abc" -----\t and \b are included which is to be removed.
Please do help........
Thanks & Regards
Kapil
|
|
|
|
|
I've never used Regex before...
However why not use:
string s = " some thing ";
s = s.Replace(" ", "");
s = s.Replace("\t", "");
Is there any reason why you are using Regex?
Matthew Butler
|
|
|
|
|
First of all, why are you matching the above characters instead of just using the \w (word characters) and \s (whitespace characters) character classes? It appears you are trying to do something like the following (with slightly more control)
myString = myString.Trim(); Second, if you really want to remove things in the middle, instead of a regex do the following:
myString = myString.Replace("\t", string.Empty);
myString = myString.Replace("\b", string.Empty);
-Jeff
|
|
|
|
|
I have a method which uses regex.... shown below
<b>string pattern = "(?<before>.*)(?<junk><table class="MyTable" cellspacing="2" cellpadding="1" width="144" border="0">.*</table><!--MyTable- -->)(?<after>.*)";
string matchEvaluator = "${before} ${after}";
try
{
local_string = Regex.Replace(local_source, pattern, matchEvaluator);
}
catch (Exception er)
{
string g = er.Message;
}
string wr = HTMLWriter.htmlWriter.WriteHTMLFile(@"C:\trimExtras.html",
local_string);</after></junk></before></b>
I want to remove certain part of html page with this regex
the problem is it does not work... it takes a long time i.e hangs the app and when i write it to html file its still the same i.e does not replace any thing
<div class="ForumMod">modified on Friday, December 07, 2007 7:52:14 AM</div>
|
|
|
|
|
Question: A curiosity, doubt, or statement inquiring about something.
Did you forget something?
|
|
|
|
|
string test0002 = "Select room_code from room_types where room_code = '" + room_code + "'";
int max2;
SqlCommand cmd17 = new SqlCommand();
cmd17.Connection = con2;
cmd17.CommandText = test0002;
max2 = (int)cmd17.ExecuteNonQuery();
lbtest1.Text = max2.ToString();
hey is there a problem with the code above as its not displaying the data it is meant to, is there another way t display data from a query quickly/
cheers
|
|
|
|
|
did u get any error while running this code?
|
|
|
|
|
The return value from ExecuteNonQuery is the number of rows affected. In the case of a Select statement this will usually be zero.
You shold use ExecuteScalar to get a single return value from your select statement, or ExecuteReader to get more than one return value.
|
|
|
|
|
Please consider renaming your command to something more meaningful than cmd17, and don't use inline SQL like this - it's wide open to SQL Injection attacks. This[^] article should help.
|
|
|
|
|
-------------------Program.cs--------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
namespace WindowsApplication1
{
static class Program
{
[STAThread]
static void Main(string[] args)
{
Application.SetCompatibleTextRenderingDefault(false);
Form1 obj = new Form1();
TimerCallback tcallback = new TimerCallback(obj.Child);
ThreadPool.QueueUserWorkItem(new WaitCallback(tcallback));
long dTime = 1000 ;
long pTime = 10000 ;
System.Threading.Timer atimer = new System.Threading.Timer(tcallback, null, dTime, pTime) ;
Application.EnableVisualStyles();
Application.Run(new Form1());
}
}
}
-------------------------------------------------------------------------
----------------------------------------Form1.cs-------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public void Child(object state)
{
//textBox1.Text is the problem. This value is not shown on form.
textBox1.Text = "Some Text";
MessageBox.Show(textBox1.Text);
}
}
}
-------------------------------------------------
|
|
|
|
|
Hi..
Nice Subject
you can not change the text of a control from another thread.
try the following:
public void Child(object state)
{
if (textBox1.InvokeRequired)
{
Invoke(new TimerCallback(Child),new object[]{state});
}
else
{
textBox1.Text = "Some Text";
MessageBox.Show(textBox1.Text);
}
}
alternatively you could also use System.Windows.Forms.Timer instead of the one in the Threading - Namespace. then you wouldn't have to use Invoke.
hope this helps
m@u
|
|
|
|
|
Hi
I ahve the following problem
I ahve a field in a database with field format jh00~pr11_ 01
howecer when a person adds a new row i need the last number to autoincrment so the next one would be: jh00~pr11_ 01
however the problem is i cant do this in the database end i need to do it in c#
any starters or suggestions?
cheers
|
|
|
|
|
Jamie1985 wrote: I ahve a field in a database with field format jh00~pr11_ 01
howecer when a person adds a new row i need the last number to autoincrment so the next one would be: jh00~pr11_ 01
Boot the string looking same !!!
I belive it will be incremented in jh00~pr11_02,jh00~pr11_03 this way ???
if this !! use Substring() and indexof() for that !!!
you can find position of _ using indexof
hope this will help !!!
|
|
|
|
|
Yeah, you could probably use .Split on the underscore:
string db = "jh00~pr11_01";
string[] split = db.Split('_');
string s_number = split[1];
int i_number = Int32.Parse(s_number);
i_number++;
s_number = i_number.ToSrting();
db = split[0] + "_" + s_number;
There's probably stuff wrong with that code, but you get the idea.
Separate the number from the rest of the string, increment it, and add it back on.
My current favourite word is: Bauble!
-SK Genius
|
|
|
|
|
thats great thanks
how would i make it 02 on the end instead of just 2 as its doing at the mo?
cheers!!
|
|
|
|
|
of course, use .PadLeft(2, '0'); which will add 0's to the start until the length of the string is 2
My current favourite word is: Bauble!
-SK Genius
|
|
|
|
|
On invoking the form that contains the Datagrid view the DataGridView Default Error Dialog appears...
I am unable to handle this event. Can anyone tell how to prevent this dialog from appearing.
|
|
|
|
|
I am pretty sure there has to be a method after that.
but i dont no if that is write.
ollie
|
|
|
|
|
Thank you ollie for your reply...
I have resolved the problem...
Using the DataGridView.DataError event and catching the exact error worked out...
modified on Friday, December 07, 2007 7:46:56 AM
|
|
|
|
|