C# Discussion Boards - CodeProject

musefan30-Jun-09 2:30

musefan

30-Jun-09 2:30

....hmmmm, that's an interesting thought...

Life goes very fast. Tomorrow, today is already yesterday.

K030630-Jun-09 2:06

K0306

30-Jun-09 2:06

I think you are asking about Joins in SQL, if this right,try the below links for Joins

SQL Join Link1[^]

SQl Joins Link2[^]

Dushan12330-Jun-09 2:31

Dushan123

30-Jun-09 2:31

I need to visualize the sql joins like sql query analyzer

Dushan Perera

musefan30-Jun-09 2:18

musefan

30-Jun-09 2:18

Dushan123 wrote:
I need to develope simple sql query designer

the word 'simple' strikes me as being one you clearly should not have included in a post asking for help.

I mean, if it's so simple then why do you need help with it

Life goes very fast. Tomorrow, today is already yesterday.

show custom control in aspx page

Pete O'Hanlon30-Jun-09 2:36

Pete O'Hanlon

30-Jun-09 2:36

OK - what have you got so far? How are you representing your tables? What diagramming methods are you using?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Pankaj Saha30-Jun-09 1:27

Pankaj Saha

30-Jun-09 1:27

Hi, I have a web application with a single page, where I put a textbox in that form. Then I build the project. Now I have another web application and want the previous web application page in this application. I mean I want to show the previous application's page into my current application's page as a user control. Confused | :confused:

Pankaj

Re: show custom control in aspx page

Vimalsoft(Pty) Ltd30-Jun-09 1:37

Re: show custom control in aspx page

30-Jun-09 1:37

Create a userControl and add what ever controls you want, and from your Solution Explorer Drag it and Drop it in your host page , it will be registered and you can use it. Smile | :)

Simple

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Pankaj Saha30-Jun-09 1:53

Pankaj Saha

30-Jun-09 1:53

Thanks for your replay. But this is not my problem. I have a web application not class library. And I have to show this web application form to my new web application as a control.

Pankaj

Connect C# win app and ASP.Net/C# website using HttpRequests?

Mtyb30-Jun-09 1:19

Re: Connect C# win app and ASP.Net/C# website using HttpRequests? [modified]

30-Jun-09 1:19

Hello,

Win App:
takes a value from a textbox1 and send it throw parameter to a method in the website called WebDisplay(textbox1.text)

Web App:
WebDisplay method recives the parameter.

so how can i do that..?

thanks!

Vimalsoft(Pty) Ltd30-Jun-09 2:15

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 2:15

Why Dont you Create a Web service that can be Consume by your Windows Application

modified on Tuesday, June 30, 2009 8:50 AM

Mtyb30-Jun-09 2:47

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 2:47

sry, can u explain more ?

Vimalsoft(Pty) Ltd30-Jun-09 2:52

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 2:52

Sorry i wrote a rotten English there Smile | :)

ok what you should do is to create a Web service on your Web Application and in your windows Application Add a WEb reference to that Web Service and in your C# code Consume the Web service.

Tell me if you need example code.

Hope this Helps

Mtyb30-Jun-09 2:59

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 2:59

Ok..
can u give me a simple project to do that.
thanks for help Smile | :)

Vimalsoft(Pty) Ltd30-Jun-09 3:12

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 3:12

Its Easy as you said you have a Web Application. in your Web Application Add a New project(Web Service).

You will find it has code like this

using System;
using System.Data;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.ComponentModel;

namespace WebService1
{
    /// <summary>
    /// Summary description for Service1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [ToolboxItem(false)]
    public class Service1 : System.Web.Services.WebService
    {

        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }
    }
}

as you can see there is example Function,

now change it to your needs , now this will be on your Web Application build it and make sure it has no Errors , in your Windows Application go to your References and right click and Add web Reference and Browse to your Web service, if you are doing this locally it will automatically show a list of web services that you created. choose one and in your Windows Appliction you will access the Web function as a Function that is created locally.

Hope this Helps

Mtyb30-Jun-09 3:32

Re: Connect C# win app and ASP.Net/C# website using HttpRequests?

30-Jun-09 3:32

if i connect two PCs throw cross cable ..
and i but the web app in one, and the win app in the 2nd one..
is it the same to add refrence from the web..??

Vimalsoft(Pty) Ltd30-Jun-09 3:35

How to Add file to the folder only if the file doesnt exist

30-Jun-09 3:35

Yes and Enter the Address of the Web Service. Remember After you created the Web service you must test it and you will see the URL that you can use consume it.

Krishna Aditya30-Jun-09 1:09

Krishna Aditya

30-Jun-09 1:09

Hi,

I have   a template file in a folder " c:\template_folder".

At runtime, I will create a new folder " c:\new_folder" and wish to copy the template file to the new_folder only if the file doesnt exist.

description:
for the first time, I will copy the template file to the new_folder and rename it with username... so that after first time the loop finishes,   i   will have 8 excel files with username as the name of the each file.

for the second loop, if I have to copy the template file to new_folder and rename it to the username, if the file with the user name already exists, then it shouldnt copy the file to the folder.

I am addin the snippet of the code for reference.

                                          foreach (FileInfo fi in templateFile)
                                          {
                                                string oldfilename = null;
                                                string newfilename = null;
                                                if (dir.Exists)
                                                {

                                                      fi.CopyTo(Path.Combine(dir.ToString(), fi.Name));
                                                      FileInfo fileName = new FileInfo(fi.Name);
                                                      oldfilename = Path.Combine(dir.ToString(), fileName.ToString());
                                                      newfilename = Path.Combine(dir.ToString(), tempUserName + " "   + "E" + tempUserID + " VIPv7.0.xls");

                                                      //if( !dir.ToString().Contains(newfilename))
                                                      foreach( FileInfo fileList in fileNames)
                                                      {
                                                            if (fileList.Exists == false)
                                                                  File.Move(oldfilename, newfilename);
                                                      }
                                                }
                                          }

please help me in working this.

thanks
ramm

Re: How to Add file to the folder only if the file doesnt exist

musefan30-Jun-09 2:23

musefan

30-Jun-09 2:23

Hmmm...

if(!File.Exists("filepath"))//if file does not exist
   //do copy

Life goes very fast. Tomorrow, today is already yesterday.

ADO.NET....

Isaac Gordon30-Jun-09 0:29

Isaac Gordon

30-Jun-09 0:29

Hi Experts
i Have Data of 2 millions of record i am using C#.NET and SQL Server 2005
then suggest me what i am using either sqldatareader or SQLdataadapter
which is faster.
Thank u
Dinesh

Pete O'Hanlon30-Jun-09 0:41

Pete O'Hanlon

30-Jun-09 0:41

Rather than us telling you, you should attempt to find this out for yourself. While I think that the DataReader will be faster, you don't know why this is my opinion. You don't know that it's because the DataReader is a firehose cursor, and you can't tell whether I'm right or absolutely full of it.

By attempting to solve this yourself, you will develop your critical thinking and analytical skills which will make you better able to evaluate whether or not you are being given valid advice. This, in turn, will help you grow as a developer. Alternatively, you could stay a cut and paste monkey for the rest of your life, and just get others to spoonfeed you information. The choice is yours.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Manas Bhardwaj30-Jun-09 0:44

Manas Bhardwaj

30-Jun-09 0:44

Before discussing the comparision, may I ask you something. What are you gonna do with 2 Million record at the application level?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Svetlin Panayotov30-Jun-09 0:50

Svetlin Panayotov

30-Jun-09 0:50

Manas Bhardwaj wrote:
Before discussing the comparision, may I ask you something. What are you gonna do with 2 Million record at the application level?

Second that. Anyway, you may have a good reason for this so...I assume that DataReader will be faster, but I don't really have DB with 2 Million records to verify that Smile | :)

Vimalsoft(Pty) Ltd30-Jun-09 1:41

30-Jun-09 1:41

Obviously the First thing you should remember

1) retrieve the Fields that your Application will need

2) Retrieve the number of records by using where Clause

3) Use Dataset or Datatable if you are going to Update the Data else Datareader.

but please Be specific, what are you going to do with the Data? You cant Display 1000 000 in gridiew that will be a bad idead and Design.

Hope it Helps

dan!sh 30-Jun-09 1:51

dan!sh

30-Jun-09 1:51

1. Pulling out 2 million records at once means your application needs redesign.
2. If there is an unavoidable reason to do this, then choose depending on what you will do with those records.

For instance, if you are going to write them to some other place, use datareader.

Your post reminded me of an aticle I had read some time back. Here[^] it is, if it helps.