am using sql 2005 as backend
Am trying to generate auto-incremental values that is preceded with letters from my C# codes, based on user text input into database. The user input could be MAN, LADY, UNCLE etc.
However, I intend to generate values into the database such as:
Why is it that people keep coming up with requests like this? As a key, this isn't exactly the most efficient.
Anyway, to do this, create yourself a sequence table. This table will consist of the two colums, one for the code and the other for the next sequence number. Then, when you need the value update this table and set the sequence value = sequence value + 1 (use an appropriate locking strategy and run this inside a transaction). Next, read the value back again and subtract 1 to get the sequence you need and commit the transaction. This logic works because the update locks the row for the user who is attempting to get the value. If somebody else attempts to update the row when you are inside the transaction, they won't be able to - they have to wait until you have commited or rolled the transaction back. Note - the order you do this in is hugely important; you must do the update before the select for this to work.
It's a hack, but it's the cleanest way to do it. I've heard of people attempting to do this type of thing using MAX queries and the like, but these are prone to error.
Deja View - the feeling that you've seen this post before.
To display report on Crystal Report I'm using, the following piece of code below.......but I'm not getting any idea of how to SELECT records between a date range ( in my database, the date field doesn't exist in date format, its splitted in multiple columns like MM, DD, YY, YY (i.e 4 columns altogether).
when I display it on Crystal Report, I can concatenate it using built-in Crystal report fucntion called CStr function.
If anyone has got any idea on how to proceed, pls help me.
private void Form2_Load(object sender, System.EventArgs e)
myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\sample_as400.mdb";
string sqlQuery = "Select * from table_as400";
myAdp = new OleDbDataAdapter(sqlQuery, myCon);
OleDbCommandBuilder myBldr = new OleDbCommandBuilder(myAdp);
catch (OleDbException exceptionObject)
private void btnReport_Click(object sender, System.EventArgs e)
// Create a CrystalReport1 object
CLIENT_REPORT myReport = new CLIENT_REPORT();
// Set the DataSource of the report
// Set the Report Source to ReportView
crystalReportViewer1.ReportSource = myReport;
One option would be to add a DateTime column to a dataset retrieved from your initial query of 'table_as400', loop through the dataset to edit/insert this DateTime column with the correct date according to the four various "date" related fields in each row of your table, and then pass that dataset object as your data source. You could then filter the date range according to the DateTime column you added. Of course, if your initial query is tens of thousands of records, this option is unlikely to be elegant.
Another option would be to concatenate the date fields in your initial query AS some new named field into a "yyyyMMdd" format and then filter against that new field.
They run in a standalone highly cut down web server called Cassini. It operates by listening to requests on a different port to the default port 80. When you start debugging your web application, it runs on the *new* port.
Deja View - the feeling that you've seen this post before.
I'm trying to Create a windows service in C#. Could some one assist me in creating a windows service that reads mail on a periodic basis from "MSoutlook inbox" of a given mail Id (say "email@example.com" with Host = "smtpx14.msoutlookonline.net" username = "uname" and password="pwd")?
I'm trying to Create a windows service in C#. Could you assist me in creating a windows service that reads mail and stores the message in to a database on a periodic basis from "MSoutlook inbox" of a given mail Id (say "firstname.lastname@example.org" with Host = "smtpx14.msoutlookonline.net" username = "uname" and password="pwd")?
I ve used one Custom Tab Control with some background image.
and ve one GroupBox in one of the Tab Page.
The backcolor of the GroupBox is Transparent.
It all works well with WindowsXP theme but when I change the Theme to
Windows Classic the Transparency of the GroupBox goes away and it is shown with System Control backcolor. But the Tab Page is having its background image.
One of the problems that developers face is the different visual styles that must be tested with an application. The best thing to do would be to detect when the theme changes and what theme it was changed too. When it happens you will have to alter the controls to better suit the visual style.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
You can't find out which one has changed by comparing the lists, as the lists only contains references to the objects. There is only one copy of each object, not one copy for each list. When you change the object, the change is visible from both lists, as they both reference the same object.
Despite everything, the person most likely to be fooling you next is yourself.
I have two issues, if u could help, would be a great assistance.
- line.unregister() using sipxtapidotnet api does not work although line.register works. why? is there any bug in sipxtapi or I am missing something?
- I want to register my line extensions to sip proxy server using sipXtapidotnet api, but how can i do that because there is only line.register() method which registers the line to the proxy server not the extentions.
thnx for the reply but why i asked here is due the fact that sipXtapidotnet is an open souce api and has no documentation or i might not be able to find. so there would be some one could help me out. could u as well.
Atif Ali Bhatti.
Last Visit: 24-Jan-20 13:01 Last Update: 24-Jan-20 13:01