Re: retrieving a sql results with a specific Id using Rank and Partition - ASP.NET Discussion Boards

Re: problem with browser

N a v a n e e t h25-Feb-09 1:49

N a v a n e e t h

25-Feb-09 1:49

Use the W3C[^] standards while designing.

Navaneeth

How to use google | Ask smart questions

How to Browse Folder

trushitshah25-Feb-09 0:46

trushitshah

25-Feb-09 0:46

How to browse folder not file using vb.net?

Re: How to Browse Folder

N a v a n e e t h25-Feb-09 1:55

N a v a n e e t h

25-Feb-09 1:55

You can't browse folder using ASP.NET.

Navaneeth

How to use google | Ask smart questions

Re: How to Browse Folder

Xmen Real 25-Feb-09 4:53

Xmen Real

25-Feb-09 4:53

JavaScript will help you if you gonna browse folder at client side

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Problem With Datatable

ais0725-Feb-09 0:46

ais07

25-Feb-09 0:46

Hi There,
Is it possible to write a query on Datatable ?

Re: Problem With Datatable

N a v a n e e t h25-Feb-09 1:56

N a v a n e e t h

25-Feb-09 1:56

Not SQL, but you can use DataTable.Select[^] method with a filter criteria.

Smile | :)

Navaneeth

How to use google | Ask smart questions

retrieving a sql results with a specific Id using Rank and Partition

gottimukkala25-Feb-09 0:46

gottimukkala

25-Feb-09 0:46

Hi

I have a stored procedure that returns all the docs uploaded ordered by creation date. Now i want to change it like show a document with the id "1234" as always on top and the remaining results as today after to that document.

Does anyone have any one idea.

Any Help please......!

thanks#

Re: retrieving a sql results with a specific Id using Rank and Partition

Mark Graham25-Feb-09 1:22

Mark Graham

25-Feb-09 1:22

What springs to mind....

The first thing I would look at is returning two result sets (presumably your first would have one row in it and your second would have many, excluding the unique row you've already selected, ordered by create date) from your store proc. Then using a ADO.Net DataReader I would merge the two result sets in code.

Here's some pseudo with some c#

    // create return object (a list) here

    using ( SqlDataReader reader = command.ExecuteReader( ) )
    {
        // read first doc

        if ( reader.Read( ) )
        {
            // add data to a DTO, or business object then add to results list
        }

        // move to next result set and read the other docs

        reader.NextResult();

        while ( reader.Read( ) )
        {
            // add data to a DTO, or business object then add to results list
        }
    }
    // return list - the merged results

This is still only one stored proc call; one trip across the wire (not that two trips in this case would make the slightest bit of difference).

Has this helped?

Mark Graham (MCP) // The Doodler
blogging about C#, Asp.Net, and Design Patterns at: csCoffee [^]
and contributing at dotNet Notepad [^]

update/delete/edit in gridview-asp.net(2.0)

muana_gunner25-Feb-09 0:36

muana_gunner

25-Feb-09 0:36

How to handle gridview delete/update and edit events in asp.net 2.0 with c# coding using SQL database.(let's say I'm using 'DD' database with 'CC' Table that I want to handle with 'xx' and 'zz' columns).

Security

ellllllllie24-Feb-09 23:37

ellllllllie

24-Feb-09 23:37

hello,
How can i assign a permission for a folder in order to prevent access to him from the address bar or by clicking on it or using the run command.
only this folder should be used by the aspnet client account.
best regards

dghdfghdfghdfghdgh

Events in a UserControl

Vimalsoft(Pty) Ltd24-Feb-09 23:06

Vimalsoft(Pty) Ltd

24-Feb-09 23:06

Good Day All

Am using a Infragistic Ultragrid Control and in the Control there is no event RowDataBound, So i decided to add it. I right Clicked on the Control and went to Properties and clicked at the lightning sign for events and double clicked "DataBound" event and next to it i started coding my event like this

protected void ultraGridCycles_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        //We're only interested in rows that contain data

        //Get a reference to the data used  to databound the row
        DataRowView drv = (DataRowView)e.Row.DataItem;
        if (Convert.ToString(drv["1"]) == "1")
        {
            e.Row.Font.Bold = true;
            e.Row.ForeColor = System.Drawing.Color.Gold;
        }
    }

}

The Compiler did not complain. Now i want to use this event in the like in MS Gridview. How do i get that event to be Fired ?

Thank you

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.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Re: Events in a UserControl

N a v a n e e t h25-Feb-09 3:01

N a v a n e e t h

25-Feb-09 3:01

Vuyiswa Maseko wrote:
Now i want to use this event in the like in MS Gridview

Not sure I got you. Can you explain in detail?

Navaneeth

How to use google | Ask smart questions

Re: Events in a UserControl

Vimalsoft(Pty) Ltd25-Feb-09 3:07

Vimalsoft(Pty) Ltd

25-Feb-09 3:07

Am using a third party Grid Control by "Infragistics". So i want to use the event like i use the Microsoft's Gridview that we normally use in VS.

about asp dot net?

che_kar24-Feb-09 23:04

che_kar

24-Feb-09 23:04

What are the needed languages should known to become good with the Asp Dot net?
Give me the neccessary ideas about it.please....

with regards

yr cheguevara

Re: about asp dot net?

kumareshTMC24-Feb-09 23:26

kumareshTMC

24-Feb-09 23:26

Hi yr cheguevara..

To have the ideas of to become good sound in asp.net to know the following languages

HTML

Javascript

SQLserver For database connection

ASP

Re: about asp dot net?

Ravindra Bisen25-Feb-09 1:00

Ravindra Bisen

25-Feb-09 1:00

Hi,
you have to good command on c# or Vb.net

how to open the download page in another window

lakshmichawala24-Feb-09 22:42

lakshmichawala

24-Feb-09 22:42

Response.Clear()
Response.AddHeader("Content-Disposition", "attachment; filename=" xmlfile)
Response.AddHeader("Content-Length", file.Length.ToString()) Response.ContentType = "xml" ' "application/octet-stream"
Response.WriteFile(file.FullName)
Response.End()

using this code iam download an xml file then iam getting open save and cancel window when iam click on open then the download file is opening in the same page which makes my application is not visible. how to make download file to be open in the another window

Re: how to open the download page in another window

Calin Tatar25-Feb-09 0:37

Calin Tatar

25-Feb-09 0:37

Try to create a new page and add that code.
Redirect to that page, from a link that contains TARGET="_blank", or use javascript, window.open()to show that page.

Calin

How to redirec From Https to Http page in same application

jainmravi24-Feb-09 22:36

jainmravi

24-Feb-09 22:36

Hello,

How to redirec From Https to Http page in same Web Application

In Asp.net 2.0

Ravindra Jain

error in reading file

meghamaharshi24-Feb-09 22:12

meghamaharshi

24-Feb-09 22:12

Hello Everybody
in my page i need to read file (.doc,.txt,.rtf) and find out mobile numbers to which i am to send sms
its working fine on localhost but onupload on ftp its giving following error..

Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Thanks

Re: error in reading file

N a v a n e e t h24-Feb-09 22:17

N a v a n e e t h

24-Feb-09 22:17

You haven't provided enough details to answer this question. Please explain clearly what you are trying to do.

Navaneeth

How to use google | Ask smart questions

Re: error in reading file

meghamaharshi24-Feb-09 22:29

meghamaharshi

24-Feb-09 22:29

thanks for reply..
there is an excel file (can be .txt,.rtf,.doc) containing mobile number with some text
now the problem is that i successfully retrieve the numbers while running project on localhost but
when i upload the compiled code on ftp then on reading that file its giving the following error.

Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Re: error in reading file

Expert Coming24-Feb-09 22:33

Expert Coming

24-Feb-09 22:33

You have to either have Excel installed on the server, or a free package Microsoft has that let's a server access the DLLs required. Can't remember what it's called, but it should give ya some Google key words.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: error in reading file

meghamaharshi24-Feb-09 22:38

meghamaharshi

24-Feb-09 22:38

if it is so then why its giving same error with .txt file?

Image Saving into SQL Database

Robymon24-Feb-09 21:23

Robymon

24-Feb-09 21:23

am resizing the uploaded image and also adding the watermark, that code as follows, but now am saving the image into local path, i want to save this image into sql server database. how can i do that. can i get some source code for that.

int thumbWidth = 0;
System.Drawing.Image image = System.Drawing.Image.FromFile(cmdBrowse.PostedFile.FileName);
if (image.Width > 500)
{
thumbWidth = 500;
}
else
{
thumbWidth = image.Width;
}
int srcWidth = image.Width;
int srcHeight = image.Height;
Decimal sizeRatio = ((Decimal)srcHeight / srcWidth);
int thumbHeight = Decimal.ToInt32(sizeRatio * thumbWidth);
Bitmap bmp = new Bitmap(thumbWidth, thumbHeight);
System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(bmp);
gr.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
gr.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
gr.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;
System.Drawing.Rectangle rectDestination = new System.Drawing.Rectangle(0, 0, thumbWidth, thumbHeight);
gr.DrawImage(image, rectDestination, 0, 0, srcWidth, srcHeight, GraphicsUnit.Pixel);
Font font = new Font("Verdana", 14, FontStyle.Bold, GraphicsUnit.Pixel);
Color color = Color.FromArgb(100, 0, 0, 0);
Point pt = new Point(2, 3);
SolidBrush sbrush = new SolidBrush(color);
gr.DrawString("www.Test.com", font, sbrush, pt);
bmp.Save("E:/Images/Test.bmp");
bmp.Dispose();
image.Dispose();

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.