Developer Barn - .Net Development

Developer Barn - .Net Development http://www.developerbarn.com/ Learn about the Microsoft .Net framework and how to create powerful web-based (ASP.net) and client-based (Windows Forms) applications utilizing various languages such as C#, VB.Net, J# and others. Utilize tools such as Visual Studio to build your applications. en Mon, 06 Sep 2010 12:15:58 GMT vBulletin 60 http://www.developerbarn.com/images/misc/rss.png Developer Barn - .Net Development http://www.developerbarn.com/ Windows Forms - C# using c#.net forms to replace microsoft access forms http://www.developerbarn.com/net-development/2257-using-c-net-forms-replace-microsoft-access-forms.html Sun, 05 Sep 2010 12:53:29 GMT Hello, am looking for advice first - before I ask specific questions I have attached a simple example time worked database I have. What is mainly... Hello,
am looking for advice first - before I ask specific questions
I have attached a simple example time worked database I have.
What is mainly different than most time forms - is that I have two tables in microsoft access database. the form lets user enter data during the week and as long as user does not click submit button- the data is still there. the form is bound to table1.

But when user clicks submit button- all data is transferred to table2-( and data is then cleared out of table1).
my report for each user is based on their table2.
I am learning slowly C#.net. ( at work some computers not on network and only have .net 2.0 version)- i want to know if a C# form could replicate what the microsoft access form is doing here.
one reason am doing it- may be just a lesson for myself in C#- but I wonder first can C# form do it and In my actual database- I have a separate forms for each user- Can C# have multiple forms for a function like this.
thank you

Attached Files

exampleDatabase1.zip (24.8 KB)

]]> .Net Development arloguth http://www.developerbarn.com/net-development/2257-using-c-net-forms-replace-microsoft-access-forms.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 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 ASyncUpload control with URL rewrite http://www.developerbarn.com/net-development/2221-asyncupload-control-url-rewrite.html Fri, 20 Aug 2010 09:35:20 GMT I'm utilising the AsyncFileUpload control as part of the AJAX Control Toolkit but it always throws an error when I have a rewritten URL instead of the path to the actual file.

For example if I have www.domain.com/contact/upload it throws an error whereas if I have www.domain.com/contactupload.aspx it works fine.

The error is the file /contact/upload/contactupload.aspx does not exist. So obviously it's using the relative path from the url and appending the filename, rather than just using the url as it is.

Any ideas how to fix this? ]]> .Net Development richyrich http://www.developerbarn.com/net-development/2221-asyncupload-control-url-rewrite.html ASP.Net - C# Building Dynamic Conditional Statement http://www.developerbarn.com/net-development/2213-building-dynamic-conditional-statement.html Tue, 17 Aug 2010 12:08:46 GMT Anyone got an idea on how I could build a dynamic user-defined conditional statement? So, I want users to be able to select what properties to... Anyone got an idea on how I could build a dynamic user-defined conditional statement? So, I want users to be able to select what properties to include in a conditional.

I want users to be able to build there own conditionals so, ideally it would be something like:-

Code:

obj object = new obj();

object.id=1;

object.title="title";

object.firstname="firstname";

object.lastname="lastname";



if (object.(ddlFirstOption.SelectedValue)==txtFirstOptionToCheck.Text)

{

    //use object.(ddlFirstOption.SelectedValue)

}else if (object.(ddlSecondOption.SelectedValue)==txtSecondObjectToCheck.text)

{

   //use object.(ddlSecondOption.SelectedValue)

}

So a user could, for example, have a conditional where they selected title in the first option dropdown and enter "title" in the first option to check textbox.

So, I guess the question is, can you dynamically choose the property of an object or do you always have to "hard-code" them? ]]> .Net Development richyrich http://www.developerbarn.com/net-development/2213-building-dynamic-conditional-statement.html Windows Forms - C# C# form- access and crystal report http://www.developerbarn.com/net-development/2205-c-form-access-crystal-report.html Sat, 14 Aug 2010 12:05:06 GMT Hello, general question: i have never used crystal reports- I am trying to take microsoft access form and change to use C#.net ( .net 2.0 version)... Hello,
general question:
i have never used crystal reports- I am trying to take microsoft access form and change to use C#.net ( .net 2.0 version) form to do all same functions.
I was told Crystal reports are better to use than microsoft access reports.
Am still using access database.
If I create a c#.net form with crystal report- place it on a local network- do users need crystal report software on each of there pc's to view the crystal report?
I have Visual studio 2008 - is crystal reports bundled in this?
thank you ]]> .Net Development arloguth http://www.developerbarn.com/net-development/2205-c-form-access-crystal-report.html Image preview issue http://www.developerbarn.com/net-development/2202-image-preview-issue.html Fri, 13 Aug 2010 08:54:24 GMT Hi. I am displaying thumbnail images in grid as thumbnail.clciking on thumbnail user can view actual larger image in pop up window. Problem is after... Hi.
I am displaying thumbnail images in grid as thumbnail.clciking on thumbnail user can view actual larger image in pop up window. Problem is after showing 2 or 3 images it doesn't work. page can not be displayed error in pop up window. Already I have spent 4 hrs still no luck.

On item bound event onclick event is attached.

Code:

 protected void dgImages_ItemDataBound(object sender, GridItemEventArgs e)

    {

      try

      {

        if (e.Item is GridDataItem)

        {

          string documentID = DataBinder.Eval(e.Item.DataItem, WebConstants.COL_DOCUMENT_ID).ToString();

          string description = DataBinder.Eval(e.Item.DataItem, WebConstants.COL_DESCRIPTION).ToString();

          if (!string.IsNullOrEmpty(documentID))

          {

            ((Telerik.Web.UI.RadBinaryImage)(((GridDataItem)e.Item)[WebConstants.COL_THUMB_NAIL].Controls[0])).Attributes["onclick"] = String.Format(WebConstants.SHOW_MAIN_IMAGE, documentID, description);

          }

        }

      }

when user clicks thumbnail below javascript function gets called.

Code:

 function showMainImage(documentID,description) {           

        

            newwindow = window.open("FormViewPicturePreview.aspx?documentID=" + documentID + "&Description=" + description , 'name_' + documentID, 'height=400px,width=550px,left=100,top=100,right=100,resizable=no,scrollbars=no,toolbar=no,status=no');

        }

Formviewpicturepreview.aspx.cs
-------------------------------

Code:

protected void Page_Load(object sender, EventArgs e)

    {      

      if (!string.IsNullOrEmpty(Request.QueryString[WebConstants.COL_DOCUMENT_ID]))      

      {

        string documentID = Request.QueryString[WebConstants.COL_DOCUMENT_ID];

        string description = Request.QueryString[WebConstants.COL_DESCRIPTION];

        lblPictureNameValue.Text = description;

        imgPreview.ImageUrl = "DisplayImage.aspx?DocumentID=" + documentID;

        SessionHelper.ResetSessionValue(SessionConstants.IMAGE_MANAGE);

      }



    }

DisplayImage.aspx.cs .Here images are retrevied from database.
------------------------

Code:

protected void Page_Load(object sender, EventArgs e)

    {



      if (this.Page.Request.QueryString[WebConstants.COL_DOCUMENT_ID] != null)

      {

        int documentID = Convert.ToInt32(Request.QueryString[WebConstants.COL_DOCUMENT_ID]);

        //First Clear the session.

        SessionHelper.ResetSessionValue(SessionConstants.IMAGE_MANAGE);

        //MemoryStream stream = new MemoryStream();

        ImageManage imageManage = new ImageManage();   

        try

        {          

          //Get image detail

          imageManage = AssetManagerDelegate.GetImageDetail(DatabaseInstanceName, DatabaseName, documentID);

          if (imageManage.FileImage != null)

          {

            //Add to session for later use.

            SessionHelper.SetSessionValue(SessionConstants.IMAGE_MANAGE, imageManage);

            byte[] image = imageManage.FileImage;

            

            //stream.Write(image, 0, image.Length);

            //Bitmap bitmap = new Bitmap(stream);

            Response.ContentType = WebConstants.IMAGE_CONTENT_TYPE;

            Response.BinaryWrite(image);

            //bitmap.Save(Context.Response.OutputStream, ImageFormat.Jpeg);

            //bitmap.Dispose();



          }

]]> .Net Development guddu http://www.developerbarn.com/net-development/2202-image-preview-issue.html Display Events in Calendar http://www.developerbarn.com/net-development/2199-display-events-calendar.html Wed, 11 Aug 2010 13:38:41 GMT Hi I have a request from a client (on that crappy coded site I been talking about), he wants a calendar on the site, but this calendar must be... Hi

I have a request from a client (on that crappy coded site I been talking about), he wants a calendar on the site, but this calendar must be populated by the events that are on the site.

is there a control that can be used, so it looks like a normal calendar, but is populated from a table, not by the user?

Thanks for any help.
Shem ]]> .Net Development Shem http://www.developerbarn.com/net-development/2199-display-events-calendar.html