ASP.NET

Re: Import data from Xml to sql in vs2003

6-Dec-09 2:22

Loop through the records and insert one by one to database.

Best wishes,
Navaneeth

<<Tash18>>6-Dec-09 2:32

<<Tash18>>

6-Dec-09 2:32

Im a fresher actually.. i do accept ur idea.. hav u got any tutorials or samples... i googled alot dint get the apt one...
I tried using Sqlbulkcopy but that doesnt work with vs2003... and also there are duplicate rows in my xml files...
thanx in advance...

Re: Import data from Xml to sql in vs2003

N a v a n e e t h6-Dec-09 2:45

Identifying system process.

6-Dec-09 2:45

Ok. To read records from XML, use the classes provided in System.Xml name space. Work with XmlDocument[^] and load the XML to it. XmlDocument class provides methods to get collection of nodes. Start a loop that iterates over the collection.

To insert data into SQL database, you need to prepare insert SQL statement with necessary parameters. Then work with SqlConnection, SqlCommand classes. Execute the DB statement in each iteration of the loop. If you want to avoid duplicate records, create a primary key on the database table and when you try to insert duplicate records, SQL server will throw exception. Handle this and proceed to next row.

All the classes which I explained has got very neat documentation and you should be able to start easily.

<<thashif>> wrote:
Im a fresher actually

<<thashif>> wrote:
i googled alot dint get the apt one..

While searching on the Internet is good, as a fresher you should be learning stuff initially from a book. Not all the stuff in Internet are correct and reading from a book makes real difference. So I suggest you to get a good book on the subject and start working with the examples rather than wasting time on online forums or doing search.

Smile | :)

Best wishes,
Navaneeth

srikantha_nagaraj5-Dec-09 18:51

srikantha_nagaraj

5-Dec-09 18:51

When internet explorer opens my dotnet code should identify that. How can we do that? Please help me with this.

N a v a n e e t h5-Dec-09 19:02

5-Dec-09 19:02

srikantha_nagaraj wrote:
When internet explorer opens my dotnet code should identify that.

When you post questions you should identify correct forum.

srikantha_nagaraj wrote:
Please help me with this.

Your question is terribly unclear and off topic to this forum. If your question has anything to do with ASP.NET, explain it clearly. If not, move to correct forum.

Best wishes,
Navaneeth

Re: Identifying system process. [modified]

Abhishek Sur5-Dec-09 22:19

Abhishek Sur

5-Dec-09 22:19

No way... If you are talking about process in the client side, it cant detect it from the browser.. As browser only deals with htmls(Request / Response). It dont have access to anything, but just to display some Data and Ui elements.

If you are looking for server side processes, it is very easier to deal with this. Just use
System.Diagnostics.Process[] processlist = System.Diagnostics.Process.GetProcesses()

But I dont think your motive is fulfilled using this as no one opens internet explorer to work with their own site in the server.

Anyway.. Be specific on what you require always. And post in right section.

Cheers.
Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

N a v a n e e t h6-Dec-09 2:00

6-Dec-09 2:00

Abhishek Sur wrote:
If you are looking for server side processes, it is very easier to deal with this. Just use
System.Diagnostics.Process[] processlist = System.Diagnostics.Process.GetProcesses()

I doubt this. ASP.NET process runs on a restricted account and will not have full trust. GetProcesses() method is likely to fail if invoked from ASP.NET application.

Best wishes,
Navaneeth

modified on Sunday, December 6, 2009 8:21 AM

Abhishek Sur6-Dec-09 7:31

Abhishek Sur

6-Dec-09 7:31

Yes.. But I guess giving proper rights to the user (or impersonating) to run the aspnet worker process as an administrator will surely solves the issue ..

But seriously... this is not generally what we do often... but it is possible I guess.

Cheers..
Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Abhijit Jana6-Dec-09 0:36

Abhijit Jana

6-Dec-09 0:36

srikantha_nagaraj wrote:
When internet explorer opens my dotnet code should identify that.

Why do you need that ? Do you need it for an ASP.NET Application or any win Application ?

srikantha_nagaraj wrote:
Please help me with this.

Please be specific while asking any question so that we can help you at best !!

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Querystring issue

bhavnvyas4-Dec-09 23:47

bhavnvyas

4-Dec-09 23:47

hi all,

i know this is not a windows app forum but i want to pass querystring from my web page and fetch it into my windows application.
I am using some 3rd party tool web GUI for my windows app to run it as web application.

Plz help..... Confused | :confused:

sashidhar4-Dec-09 23:55

sashidhar

4-Dec-09 23:55

bhavnvyas wrote:
I am using some 3rd party tool web GUI for my windows app to run it as web application.

Then You better ask third pary tool developing team..!

As you are using the 3rd party tool first check tht it is supported for such type..!

BTW You didnt mention the 3 rd party vendor name so tht if any one uses the 3rd party tool before they can help You..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

bhavnvyas4-Dec-09 23:59

bhavnvyas

4-Dec-09 23:59

thnx for reply

but WebGUI itself is a my tool.
leave it neways but wat if i am developing somt web gui application in windows app thn how to fetch querystring data...plz help....

sashidhar5-Dec-09 0:04

sashidhar

5-Dec-09 0:04

bhavnvyas wrote:
web gui application in windows app

What do you mean by tht..!

Can You Explain it More briefly..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

bhavnvyas5-Dec-09 0:11

bhavnvyas

5-Dec-09 0:11

thnx again

in my web site i want to use some windows form features so for tht i am inclunding one page which is basically windows form for tht i am using webgui visual studio express which run my application in web.

so i want to pass querystring from my web application page to this windows app page which is basically .wgx page

Abhishek Sur5-Dec-09 9:43

Abhishek Sur

5-Dec-09 9:43

What is the problem.... load the page using Webbrowser control of your windows application and invoke the items which you need to get the querystring...

For example :

Say I add a Webbrowser control on my form,

now during form load I pass
wbrowser.Navigate(new Uri("http://codeproject.com"));

Next I navigate to an article. You might invoke browser buttons to navigate. Finally to get the querystring you use :
wbrowser.Url.Query

I hope this is what you needed. Rose | [Rose]

Next time post in right section.

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Image resize in asp.net

Any_India4-Dec-09 22:34

Any_India

4-Dec-09 22:34

Is there any simple code to resize the image in image upload and at the time of showing the image in asp.net.

plz urgent
thanks

keyur satyadev4-Dec-09 22:50

keyur satyadev

4-Dec-09 22:50

public static string Resize(string InputFilePath, string Name, int TargetWidth, int TargetHeight, string Extension, string TargetFolder)
            {
                  string thumbnailFilePath = string.Empty;
                  string FileName = string.Empty;
                  Size newSize;
                  try
                  {
                        using (Bitmap bmp = new Bitmap(InputFilePath))
                        {
                              newSize = GetRelativeImageSize(bmp.Width, bmp.Height, TargetWidth, TargetHeight);
                              FileName = Name + Extension;
                              thumbnailFilePath = TargetFolder + FileName;
                              using (Bitmap thumb = new Bitmap((System.Drawing.Image)bmp, newSize))
                              {
                                    using (Graphics g = Graphics.FromImage(thumb)) // Create Graphics object from original Image
                                    {
                                          g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
                                          g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBilinear;
                                          g.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
                                          //Set Image codec of JPEG type, the index of JPEG codec is "1"
                                          System.Drawing.Imaging.ImageCodecInfo codec = GetImageCodec(Extension);
                                          //Set the parameters for defining the quality of the thumbnail... here it is set to 100%
                                          System.Drawing.Imaging.EncoderParameters eParams = new System.Drawing.Imaging.EncoderParameters(1);
                                          eParams.Param[0] = new System.Drawing.Imaging.EncoderParameter(System.Drawing.Imaging.Encoder.Quality, 100L);
                                          //Now draw the image on the instance of thumbnail Bitmap object
                                          g.DrawImage(bmp, new Rectangle(0, 0, thumb.Width, thumb.Height));
                                          thumb.Save(thumbnailFilePath, codec, eParams);
                                    }
                              }
                        }
                  }
                  catch (Exception ex)
                  {
                        throw ex;
                  }
                  return FileName;
            }

//it will return the file name with resize.
private static Size GetRelativeImageSize(int SourceWidth, int SourceHeight, int TargetWidth, int TargetHeight)
{
float nPercent = 0;
float nPercentW = 0;
float nPercentH = 0;
if (SourceWidth <= TargetWidth && SourceHeight <= TargetHeight)
{
return new Size(SourceWidth, SourceHeight);
}
else if (TargetWidth == 0)
{
if (SourceHeight > TargetHeight)
{
nPercentH = ((float)TargetHeight / (float)SourceHeight);
nPercent = nPercentH;
}
else
return new Size(SourceWidth, SourceHeight);

}
else if (TargetHeight == 0)
{
if (SourceWidth > TargetWidth)
{
nPercentW = ((float)TargetWidth / (float)SourceWidth);
nPercent = nPercentW;
}
else
return new Size(SourceWidth, SourceHeight);

}
else
{
nPercentW = ((float)TargetWidth / (float)SourceWidth);
nPercentH = ((float)TargetHeight / (float)SourceHeight);
if (nPercentH < nPercentW)
{
nPercent = nPercentH;
}
else
{
nPercent = nPercentW;
}
}
return new Size(Convert.ToInt32(SourceWidth * nPercent), Convert.ToInt32(SourceHeight * nPercent));
}

Regards
Keyur Satyadev

Any_India4-Dec-09 23:40

Any_India

4-Dec-09 23:40

thanks for the code

what about the functon of
GetImageCodec(Extension)

you dont declare this function.

keyur satyadev4-Dec-09 23:56

keyur satyadev

4-Dec-09 23:56

private static ImageCodecInfo GetImageCodec(string Ext)
            {
                  switch (Ext)
                  {
                        case ".jpg":
                              return ImageCodecInfo.GetImageEncoders()[1];
                        case ".gif":
                              return ImageCodecInfo.GetImageEncoders()[2];
                        case ".bmp":
                              return ImageCodecInfo.GetImageEncoders()[0];
                        case ".png":
                              return ImageCodecInfo.GetImageEncoders()[4];
                        case ".jpeg":
                              return ImageCodecInfo.GetImageEncoders()[1];
                        case ".tif":
                              return ImageCodecInfo.GetImageEncoders()[3];
                        case ".jpe":
                              return ImageCodecInfo.GetImageEncoders()[1];
                        case ".jfif":
                              return ImageCodecInfo.GetImageEncoders()[1];
                        case ".tiff":
                              return ImageCodecInfo.GetImageEncoders()[3];
                        default:
                              return ImageCodecInfo.GetImageEncoders()[1];
                  }
            }

Regards
Keyur Satyadev

macielaf14-Aug-13 9:56

macielaf

14-Aug-13 9:56

Hi!!

I'm trying use this code but does not working.
Please help me.

Simply does not work, not of error but also does not work.

public void carregarImagem()
{
string path = "~/imagens/" + FileUpload1.FileName;
string folder = "~/imagens/";
string nome = FileUpload1.FileName;
int largura = Convert.ToInt32(w.Text);
int altura = Convert.ToInt32(h.Text);
string ext = System.IO.Path.GetExtension(FileUpload1.FileName);

string name = "~/imagens/" + FileUpload1.FileName;

Resize(picImage.ImageUrl, nome, largura, altura, ext, folder);

//used to show image
picImage.ImageUrl = name;
}

sashidhar4-Dec-09 23:50

sashidhar

4-Dec-09 23:50

Try this ..!

google hits[^]
Google Hits..![^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.