Re: SQL Data Reader - ASP.NET Discussion Boards

First Prev Next

Re: SQL Data Reader

Sathesh Sakthivel7-Jul-07 4:29

Sathesh Sakthivel

7-Jul-07 4:29

Amit Kumar G wrote:
My query only returns -1 which means no record affected

True.

Amit Kumar G wrote:
I checked the database table and data is there, connection is fine

Ok.

Then what problem?

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Re: SQL Data Reader

Not Active7-Jul-07 12:30

Not Active

7-Jul-07 12:30

Satips wrote:
Ok.

Then what problem?

I believe that is what his original question was WTF | :WTF:

Thanks for your valuable contribution in asking him the same question he has asked you. Roll eyes | :rolleyes:

only two letters away from being an asset

Re: SQL Data Reader

Guffa7-Jul-07 6:19

Guffa

7-Jul-07 6:19

Amit Kumar G wrote:
My dtrCat (data reader) is getting -1 record affected

Yes, of course. A select query does not change any data.

From MSDN library:

"SqlDataReader.RecordsAffected Property
Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement."

---
single minded; short sighted; long gone;

Re: SQL Data Reader

eggsovereasy7-Jul-07 19:04

eggsovereasy

7-Jul-07 19:04

I always thought it should return 0 rather than -1.

Re: SQL Data Reader

Guffa8-Jul-07 1:06

Guffa

8-Jul-07 1:06

It's all in the documentation, plain to read: Smile | :)

"Property Value
The number of rows changed, inserted, or deleted; 0 if no rows were affected or the statement failed; and -1 for SELECT statements."

---
single minded; short sighted; long gone;

Re: SQL Data Reader

eggsovereasy8-Jul-07 7:14

eggsovereasy

8-Jul-07 7:14

Well I know that is what it does, but logically it seems 0 would be more appropriate. I'm questioning someones design decision not you answer Smile | :)

Re: SQL Data Reader

Guffa8-Jul-07 8:51

Guffa

8-Jul-07 8:51

Well, a zero would mean that there were zero records uppdated. As there shouldn't be any updated records, there shouldn't be any count of them either, so I can see how a value representing a non-count would be more appropriate than a count of zero.

---
single minded; short sighted; long gone;

Re: SQL Data Reader

eggsovereasy8-Jul-07 9:50

eggsovereasy

8-Jul-07 9:50

That makes sense I suppose.

Repeater Control

Amit Kumar G7-Jul-07 2:41

Amit Kumar G

7-Jul-07 2:41

What is wrong in this ....In IE i can not see repeater control...

<%@ Page Language="C#" MasterPageFile="~/WebForms/MasterPage.master" AutoEventWireup="true" CodeFile="Query.aspx.cs" Inherits="WebForms_Login_Query" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="server">
<asp:Repeater ID="catlist" runat="server">
<HeaderTemplate>
<tr>
<td>
Amit Header
</td>
</tr>
</HeaderTemplate>

<ItemTemplate>
<tr>
<td>
Amit Item
</td>
</tr>
</ItemTemplate>

<FooterTemplate>
<tr>
<td>
Amit Footer

</td>
</tr>
</FooterTemplate>
</asp:Repeater>
</asp:Content>

Amit

Re: Repeater Control

Not Active7-Jul-07 2:46

Not Active

7-Jul-07 2:46

Are you actually binding data to it?

only two letters away from being an asset

Re: Repeater Control

Amit Kumar G7-Jul-07 2:46

Amit Kumar G

7-Jul-07 2:46

No Not require...

Re: Repeater Control

Not Active7-Jul-07 5:54

Not Active

7-Jul-07 5:54

If you are not binding anything to it then what's the point in using it?? WTF | :WTF:

Just create a HTML table. Roll eyes | :rolleyes:

only two letters away from being an asset

I have make code for file upload on webserver with resume upload, working on local server correctly but not on webserver

shailendra_ec20037-Jul-07 2:34

shailendra_ec2003

7-Jul-07 2:34

I have make code for file upload on webserver with resume upload, working on local server correctly but not on webserver

try to use codes like this , use 2 text boxes and one button, in first text box write c:\1.dat , in other textbox 2.dat, i.e file from your local harddisk c named 1.dat will copy on the servers folder uploads with name 2.dat, it works well on local server but error occurs on web server

the error is
"Could not find file 'c:\1.dat'. "

you can check this error by using different extension and size files.

By this code, file will not use web servers memory, file will transfers in chunks ( parts ) and append on the server, this is a very usefull thing if somebody want to upload large files in GB.

Please note before answering the problem that lots of FTP softwares available in the market that supports resume upload but on FTP server, not on normal http server as a normal user.

My code are working just like yahoo mail attachment with additional advantage of resume support.

codes are

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
int bufferSize = 100;
int bytesRead = 0;
string ImagesFolder = "uploads";
string savePath;
string saveFile;
long sentBytes = 0;

protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
FileStream fs = new FileStream(TextBox1.Text, FileMode.Open, FileAccess.Read);
savePath = Path.Combine(Request.PhysicalApplicationPath, ImagesFolder);
saveFile = Path.Combine(savePath, TextBox2.Text);

fs.Seek(this.sentBytes, 0);
byte[] buffer = new byte[bufferSize];

bytesRead = fs.Read(buffer, 0, bufferSize);
while (bytesRead > 0)
{
AppendChunk(buffer, sentBytes, bytesRead);
this.sentBytes += bytesRead;
bytesRead = fs.Read(buffer, 0, bufferSize);
}
fs.Close();
}

public void AppendChunk(byte[] buffer, long offset, int bufferSize)
{
FileStream FSs = new FileStream(saveFile, FileMode.Append);
FSs.Write(buffer, 0, bufferSize);
FSs.Close();
}
}

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
But the codes are not working on real web server.

Thanks
Shailendra

How to show words in Hindi at browser

Kurian_Kurian7-Jul-07 2:22

Kurian_Kurian

7-Jul-07 2:22

Hi.How to show the Text in Hindi at browser without installing the hindi font at the client machine.

Re: How to show words in Hindi at browser

RaviJJain7-Jul-07 2:41

RaviJJain

7-Jul-07 2:41

http://quillpad.in/new/quill.html

Type words in English and they will be produced in hind then copy and paste them on the browser
u dont have to download the fonts

Sorting

musnet20076-Jul-07 23:59

musnet2007

6-Jul-07 23:59

i am using the below sample code for sort in repeater, it is sorting only in asc order, now i want to sort both direction, i am using defaultview.sort, using the same function

can anyone help me

Thankz

connection open()

strSql = "select fiel1,fie2 from tablename order by columname or (Request.QueryString("val"))"
Dim da As New OleDbDataAdapter(strSql, connection)
Dim ds As New DataSet
da.Fill(ds)

If Request.QueryString("val") = "" Then
repeater.DataSource = ds.Tables(0)

Else
ds.Tables(0).DefaultView.Sort = Request.QueryString("val")
repeater.DataSource = ds.Tables(0).DefaultView
repeater.DataBind()
End If

connectionclose()

Re: Sorting

Ajai Chaudhary7-Jul-07 0:29

Ajai Chaudhary

7-Jul-07 0:29

Use your sql query in the followign manner it will sort the records in desecding order.

order by columname desc

The desc keyword followed by the column will arange the data into desecding order

with regards

Yogesh Agarwal

Re: Sorting

eggsovereasy7-Jul-07 19:08

eggsovereasy

7-Jul-07 19:08

<br />
ds.Tables[0].DefaultView.Sort = Request.QueryString("val") + "desc";<br />

But you will probably want to add someway to toggle between asc and desc.

convert into mp3 file formt

kuwl_mark6-Jul-07 23:25

kuwl_mark

6-Jul-07 23:25

hi friend i want to convert any music file to.mp3 format .
how to do it. can i use window's service for .
If yest how do i do this. ( I am new to windows service pls tell me how will i set time to execute window's service )

thanks in advance.

Re: convert into mp3 file formt

Tarik Guney6-Jul-07 23:59

Tarik Guney

6-Jul-07 23:59

i guess you gotta have encoders for converting music format one to another.

Re: convert into mp3 file formt

Christian Graus7-Jul-07 1:30

Christian Graus

7-Jul-07 1:30

Dunno about 'any' file format, but I think that the WMP control can be used to convert to WMA, and mp3 if a codec is installed.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Tab Event???

Nada Adel6-Jul-07 23:00

Nada Adel

6-Jul-07 23:00

Hi,
I have a textbox with autopostback property set to true and an event: OnTextChanged , now when the user hits the tab key, I want some information to be displayed in another textbox in my web form...I succeeded in doing that using the enter key only...but the tab key never postbacks to the server...how can I do that using the tab key??

Re: Tab Event???

Vipin.d6-Jul-07 23:27

Vipin.d

6-Jul-07 23:27

using a javascript function u can convert the tab key preess to enter key press event...

in the form tag add
onkeydown="TabToenter()"

The Javscript function is
function TabToenter()
{

var intkey=window.event.keyCode;
if(intkey==9)
{

window.event.keyCode = 13;

}
}

i hope this will work....

All I ever wanted is what others have....
CrazySanker

Re: Tab Event???

Nada Adel7-Jul-07 7:15

Nada Adel

7-Jul-07 7:15

thnx a lot, it worked Smile | :)