Developer Barn http://www.developerbarn.com/ Developer Barn is an ASP, ASP.NET, PHP, Javascript, SQL and MySQL and Programming Help Forum. Get ASP, ASP.NET, PHP and JavaScript help and sample code. en Fri, 03 Sep 2010 20:18:11 GMT vBulletin 60 http://www.developerbarn.com/images/misc/rss.png Developer Barn http://www.developerbarn.com/ <![CDATA[What's Wrong with ASP.NET Web Forms?]]> http://www.developerbarn.com/vbcms-comments/2255-whats-wrong-asp-net-web-forms.html Fri, 03 Sep 2010 13:49:01 GMT You can view the page at http://www.developerbarn.com/article/what-s-wrong-asp-net-web-forms-4/ You can view the page at http://www.developerbarn.com/content....NET-Web-Forms ]]> vBCms Comments jmurrayhead http://www.developerbarn.com/vbcms-comments/2255-whats-wrong-asp-net-web-forms.html Auto tab movement http://www.developerbarn.com/javascript-programming/2254-auto-tab-movement.html Fri, 03 Sep 2010 08:03:53 GMT Hey guys Sorry for the awkward title. I have a .aspx page on which i have 3 text boxes for phone number 1st and 2nd text boxes have length 3 and... Hey guys
Sorry for the awkward title.

I have a .aspx page on which i have 3 text boxes for phone number
1st and 2nd text boxes have length 3 and the third one has length 4.

Now my client wants that when he enters 3 numbers in 1st text box, he dont need to press "tab" and the cursor automatically goes to the 2nd text box and then to the 3rd textbox.

Is that possible?

Thanx ]]> JavaScript Programming micky http://www.developerbarn.com/javascript-programming/2254-auto-tab-movement.html Our New Site http://www.developerbarn.com/vbcms-comments/2253-our-new-site.html Fri, 03 Sep 2010 01:44:46 GMT You can view the page at http://www.developerbarn.com/article/our-new-site-2/ You can view the page at http://www.developerbarn.com/content...2-Our-New-Site ]]> vBCms Comments jmurrayhead http://www.developerbarn.com/vbcms-comments/2253-our-new-site.html Populate specific data field in a row in Access table based on Primary Key http://www.developerbarn.com/database-design-help/2252-populate-specific-data-field-row-access-table-based-primary-key.html Thu, 02 Sep 2010 21:59:51 GMT I have this Form Called "Invoices" that I will input a "InvoiceID" number from a drop down combo and enter. This will populate the form. I will then click a print button that will trigger this code. What it does is it will update the Duedate field in the Invoices table if the field is blank with (Current date + 30) before opening the "Invoices" report in printview to print that specific report. What Im having problem with is the code goes through the whole "Invoices" table and updates any DueDate field that is blank which it should not be doing. It should just update that specific row with that InvoiceID that you input in the beginning which is the primary key. The code I have now is this and everything works except it updates all Duedate fields that are blank.
Private Sub PrintInvoice_Click()
DoCmd.OpenQuery "SubtotalUpdate"
DoCmd.OpenQuery "InvoiceTotalAppend"
DoCmd.RunSQL "update Invoices set DueDate=date()+30 where duedate is null"
DoCmd.OpenReport "Invoices", acViewPreview, , "[Invoices.InvoiceID] = [Forms]![Invoices]![InvoiceID]", acWindowNormal
End Sub

Please help and thanks ]]> Database Design Help chrisjack001 http://www.developerbarn.com/database-design-help/2252-populate-specific-data-field-row-access-table-based-primary-key.html Populate Date field (CurrentDate + 30) in table if blank http://www.developerbarn.com/microsoft-access/2250-populate-date-field-currentdate-30-table-if-blank.html Thu, 02 Sep 2010 16:26:39 GMT I have a "Print" button on a Form called "Invoices" that that has embedded macros on the click event I want to replace with VB code due to the limitation in Macro. Currently this Macro does the following

1. Opens and runs a query called "SubtotalUpdate"
2. Opens and runs a query called "InvoiceTotalAppend"
3. Opens and populates a Report called "Invoices" with the DueDate from "Invoices" table before printing.
This is what I want to add to the existing macro all converted to VB code
4. If the DueDate field is blank in the "Invoices" table I want the date saved in that blank field in the table as (Current date + 30 days) before executing option 3. The format of the date should be mm/dd/yyyy. Can I replace this macro with a VB code. Can you please help with the code on Click event. Thanks ]]> Microsoft Access chrisjack001 http://www.developerbarn.com/microsoft-access/2250-populate-date-field-currentdate-30-table-if-blank.html Visual Studio 2010 http://www.developerbarn.com/net-development/2249-visual-studio-2010-a.html Thu, 02 Sep 2010 12:10:47 GMT So I got my hands on Visual Studio 2010 Premium...this is probably the most impressive version of Visual Studio I have seen. All sorts of features... So I got my hands on Visual Studio 2010 Premium...this is probably the most impressive version of Visual Studio I have seen. All sorts of features and the best part is...its speed. When I open it, it's instantaneous, unlike previous versions. When I click on a menu item, it opens right away. I'll post more about it when I actually get deeply into using it...but so far, I'm really loving it. :thumbs: ]]> .Net Development jmurrayhead http://www.developerbarn.com/net-development/2249-visual-studio-2010-a.html TCP/IP listener in ASP .NET http://www.developerbarn.com/net-development/2248-tcp-ip-listener-asp-net.html Thu, 02 Sep 2010 09:09:48 GMT I'm trying to develop a web application for a system consisting of several hardware devices, which will connect to a specific IP and port of a server to send some measuring data (plain text). This data will be stored in a SQL Server database in the server. Then, the users will connect to this server using a browser to view the stored data.

I will use ASP .NET (C#) for developing the web application for the users to access the stored data in the database (it's a standard web application with database access to retrieve and show information).

I don't know what is the best way to develop the application that will act as a TCP/IP listener to receive the hardware devices data, since it must run on the same server that stores the SQL Server database.

Could someone give me some advice or suggestion about how to develop the server listener application? I think a web service is not a good solution, because the client (hardware device) won't be able to use this technology (it will send a fixed data buffer after its connection request has been accepted).

Thanks in advance. ]]> .Net Development jcexited http://www.developerbarn.com/net-development/2248-tcp-ip-listener-asp-net.html Crystel reports to ssrs reports http://www.developerbarn.com/sql-server-reporting-services-help/2246-crystel-reports-ssrs-reports.html Wed, 01 Sep 2010 18:36:30 GMT Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to... Hi,

I need a documentation which helps me to convert crystel reports to ssrs.

if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project.
naveenjustlikethat@gmail.com ]]> SQL Server Reporting Services Help Naveenkumaryalavarthi http://www.developerbarn.com/sql-server-reporting-services-help/2246-crystel-reports-ssrs-reports.html Aggregates http://www.developerbarn.com/sql-development/2244-aggregates.html Tue, 31 Aug 2010 19:42:03 GMT Ok, I know I'm going to feel really silly when someone answers this because it should be very basic, but I'm at a loss at this point on how to select a record based on a min/max value. I realize I can use a Having clause, but it doesn't produce what I want.

Take the following data:

Create Table Customer (CustomerId int primary key, DateofBirth int);
Insert Into Customer (CustomerId, DateOfBirth)
Values (1, 19010801);
Insert Into Customer (CustomerId, DateOfBirth)
Values (2, 19100101);
Insert Into Customer (CustomerId, DateOfBirth)
Values (3, 19201201);

Select * from Customer

Results:
CustomerId DateOfBirth
1 19010801
2 19100101
3 19201201

Ok, so if I want to know the customerid of the person with the min or max date of birth, how would I go about it?

I can write:

Select customerid, Min(dateofbirth), Max(dateofbirth)
From Customer
Group by customerid


but it just yields all records grouped by customerid. What if I wanted to see just the customerid and the dateofbirth of the min or max?

Thanks! ]]> SQL Development Flam http://www.developerbarn.com/sql-development/2244-aggregates.html Where are the 2005 SSIS packages? http://www.developerbarn.com/microsoft-sql-server/2243-where-2005-ssis-packages.html Tue, 31 Aug 2010 16:31:37 GMT I have been told "Here is a 2005 database and SSIS package XYZ has two errors in it. Fix them." I can't find them. I've gone to the Integration Services Engine, but the folders there are all empty (except for other empty folders)

I also ran a search on XYZ.dtsx and found it (along with all the other .dtsx files) in someone's folder inside of a zipped folder. BMS can't brows beyond the zipped folder, so I coppied all the .dtsx files to my folder and then told BMS to open that file. It seems to have various errors, so I assume that I am not doing this correctly (I have no trouble creating my own packages). Also, since this is supposed to be a duplicate of a database with packages being run every night, it seems that there should be working SSIS packages SOMEWHERE. Where do these thing normally hide? (All of the tutorials I've gone through had me set up a special folder for packages I created) ]]> Microsoft SQL Server grnzbra http://www.developerbarn.com/microsoft-sql-server/2243-where-2005-ssis-packages.html <![CDATA[Report Design & Data]]> http://www.developerbarn.com/sql-server-reporting-services-help/2241-report-design-data.html Tue, 31 Aug 2010 10:26:33 GMT Hi all, I think it will be sound so dumb, but I don't have any idea what should I do to show some data from SSRS.

Well, let's say I wanted to build a report like this :

PAGE 1

Name : Dumbo
Address : Bali
NPWP Code : 123456


NO|ITEM|QTY
1__ABC__5
2__CDE__10

Total 15




PAGE 2

Name : Sillio
Address : Jakarta
NPWP Code : 654321


NO|ITEM|QTY
1__CCC__10
2__DDD__50

Total 60



PS :
I'm using 1 Store Procedure.
The parameter is using DocNoFrom Between DocNoTo (2param)

The problem is :
The report I already designed is using textbox to show each data. But everytime I want to show next record, they won't show up.
Then I re-build the report using table (only 1 table with 1 SP) but the result is still a mess.

So, any idea how to make this report nicely done?
Do I have to put that name into a header? coz everytime I put textbox into a header, the next record also not showing up.

Thank you in advance ]]> SQL Server Reporting Services Help PhloooooIsFlo http://www.developerbarn.com/sql-server-reporting-services-help/2241-report-design-data.html Username Question http://www.developerbarn.com/sql-development/2236-username-question.html Sun, 29 Aug 2010 21:25:30 GMT I've been slightly perplexed at the results of the following query depending on where I'm running it from:

SELECT spid, nt_username
FROM sys.sysprocesses
where spid=@@spid

(I realize I can run SUSER_Name() as well as a variety of other username functions, this is just an example)

Anyway, I have 2 different modules for an application. Both of them run on the same database, just out of different ports on the server. They run from SQL Server 2005. Both modules have their own built-in query executors (limited functionality; select statements only).

The thing that confuses me is that if I run the aforementioned query, one module always returns the nt_username value=the local machine username
while the other module returns tthe nt_username=the admin security group in SQL Server.

So for example, the results from module 1 of the above query might be:

SPID nt_username
55 FLAM

while the results of module 2 might be:

SPID nt_username
62 T_Admin

I'm not sure if this is something on the application or something I can change in SQL Server.

Anyone have any ideas?

Thanks much! ]]> SQL Development Flam http://www.developerbarn.com/sql-development/2236-username-question.html C# OleDbException: Unspecified error http://www.developerbarn.com/net-development/2235-c-oledbexception-unspecified-error.html Sun, 29 Aug 2010 15:31:12 GMT Hi, I'm trying to use a dropdownlist databound to an access data source (which has a parameter) and a gridview bound to another access data source (with a parameter).

There is a button that will send delete/insert/update command to the database based on the value of the dropdownlist.

Button code:
(I know I should use parameters)
Code:
if (cl.getInt("SELECT Count(player) FROM TownVotes WHERE (player = '" + Session["cname"].ToString() + "')") > 0)
            {
                cl.excQuery("DELETE FROM TownVotes WHERE (player = '" + Session["cname"].ToString() + "')");
                cl.excQuery("INSERT INTO TownVotes (Town, player, votedon) VALUES (" + Session["TownID"] + ",'" + Session["cname"].ToString() + "','" + playerlist.SelectedValue.ToString() + "')");
                bc.hokage(Convert.ToInt32(Session["TownID"].ToString()));
            }
            else
            {
                cl.excQuery("INSERT INTO TownVotes (Town, player, votedon) VALUES (" + Session["TownID"] + ",'" + Session["cname"].ToString() + "','" + playerlist.SelectedValue.ToString() + "')");
                bc.hokage(Convert.ToInt32(Session["TownID"].ToString()));
            }
bc.hokage:
Code:
public void hokage(int townid)
    {
        string hokage = cl.getString("SELECT votedon FROM TownVotes WHERE (Town = " + townid + ") GROUP BY votedon");
        cl.excQuery("UPDATE Towns SET (Hokage = '" + hokage + "') WHERE (Town = " + townid + ")");
    }

Here's the trace:
Code:
[OleDbException (0x80004005): Unspecified error]
  System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +975157
  System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
  System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
  System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4865788
  System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
  System.Data.OleDb.OleDbConnection.Open() +40
  AD.conn() in c:\7^4\App_Code\AD.cs:28
  AD.getString(String sqlstring) in c:\7^4\App_Code\AD.cs:70
  BC.hokage(Int32 townid) in c:\7^4\App_Code\BC.cs:162
  Default2.btnVote_Click(Object sender, EventArgs e) in c:\7^4\TownPolitics.aspx.cs:21
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
  System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
Thank you! :) ]]> .Net Development mksilva http://www.developerbarn.com/net-development/2235-c-oledbexception-unspecified-error.html Need Help with CAPTCHA on Form http://www.developerbarn.com/asp-development/2234-need-help-captcha-form.html Thu, 26 Aug 2010 12:12:07 GMT Hi there!

I'm kinda new here and well... I have a small problem. I just got reading ASP stuff since 2 days ago. I'm basically a PHP person. But since my company changed from a Linux Server to a Windows Server, I kinda have to basically redo everything in ASP.

So anyways, I just did my very very fast and very very messy Form Mail to get my stuff previously running instead of waiting for me to really learn ASP till I really know it to write it nicely.

Anyways, I now seem to be running into a small problem. I'm about 99.99% sure that if I left my FormMail just like it is right now, I'm sure spammers those bad ppl will come after my mail and exploit it.

Could someone be nice enough to help me put a CAPTCHA on my FormMail so that it would not be targeted by SPAMMERS and etc.

Would really appreciate it a lot.

Thanks in advance! ]]> ASP Development aodat2 http://www.developerbarn.com/asp-development/2234-need-help-captcha-form.html SUMMARY Formula for All Months in Access report Grouped by Month at the End of Report http://www.developerbarn.com/microsoft-access/2232-summary-formula-all-months-access-report-grouped-month-end-report.html Wed, 25 Aug 2010 17:33:45 GMT I need help with the formula or step in a report in Access to get Summary for All Months in the report Grouped by Month at the end of the report... I need help with the formula or step in a report in Access to get Summary for All Months in the report Grouped by Month at the end of the report before the Grand Total as seen below. Thanks for your help.

Example
Account 1 Jan 2009 $1500
Feb 2009 $800
Account 2 Jan 2010 $5000
Feb 2010 $200
SUMMARY OF JAN $6500
SUMMARY OF FEB $1000
GRAND TOTAL ]]> Microsoft Access chrisjack001 http://www.developerbarn.com/microsoft-access/2232-summary-formula-all-months-access-report-grouped-month-end-report.html