ASP.NET

Issues with sorting a dynamically created Gridview

5-Jul-08 16:42

dream_liner_7e7 wrote:
i need to insert data through accessdatasource

It has a InsertCommand property. Write your query there.

dream_liner_7e7 wrote:
can i use parameterized queries to select or insert data

Yes. MSDN[^] has an example.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

AaronM_NZ5-Jul-08 16:07

AaronM_NZ

5-Jul-08 16:07

I am working on a project and I am a bit stumped with sorting of a Gridview. I am creating a DataTable, and one of the columns is populated with decimal numbers ranging from -100.00 to +100.00. I then DataBind the DataTable to the GridView, and then sort on the column. The problem is its sorting it as text, not as decimal numbers - so its sorted something like this: 9.33, -7.6, 3.3, 2.02, 14.6, -1.8, -1, 0.99, etc which isn't at all what I want! How can I make the GridView realise the data is decimal, not text, and sort correctly. I am almost at the point where I might just insert the numbers back into SQL as decimal, and then read it back in sorted!

Thanks

Re: Issues with sorting a dynamically created Gridview

N a v a n e e t h5-Jul-08 16:40

Re: Issues with sorting a dynamically created Gridview

5-Jul-08 16:40

Do you have all column type specified for your data table ? If yes, take a DataView from it and use sort functions on the DataView and bind DataView to the grid.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

AaronM_NZ5-Jul-08 17:24

AaronM_NZ

5-Jul-08 17:24

Thank you, that has worked! (dt.Columns.Add("SortColumn").DataType = System.Type.GetType("System.Decimal"))

Re: Issues with sorting a dynamically created Gridview

N a v a n e e t h5-Jul-08 18:07

RightToLeft Problem in Localization.

5-Jul-08 18:07

Glad to know it helped

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

hdv2125-Jul-08 10:08

hdv212

5-Jul-08 10:08

Hi i want to create maultiLanguage webSite, for this, each web page has two resource, en-US and ar, i want when user select en-US, RightToLeft set to No, and when user select ar(Arabic), RightToLeft set to Yes, but how to do this ?
thanks

sound recording

paresh_sarjani5-Jul-08 8:44

paresh_sarjani

5-Jul-08 8:44

i wanna add sound recorder in COM componentss of vs 2005

i tried to add [b]sndrec[/b] from System 32 bt giving error

m using visual studio 2005

help me plss

scrapp me if u knww

Re: sound recording

Christian Graus5-Jul-08 15:42

Christian Graus

5-Jul-08 15:42

Are you the same guy who has been spamming the whole site with this question ? If so, you have been answered.

Either way, you cannot record sound with ASP.NET

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Doubt about 'Session'

tina->newcoder5-Jul-08 7:13

5-Jul-08 7:13

When a client is connected with the server, a session is assigned with that client uniquely, now a sessionID is stored as cookie on the client's system.
Now, i m trying to check the value of this ID, as Session.SessionID
but, each time the page is re-loaded, the ID changes .... !
Why does the ID change ?
Is there anything wrong in my code, or the ID actually changes when the page is re-loaded ???

paresh_sarjani5-Jul-08 8:50

paresh_sarjani

5-Jul-08 8:50

i thinkkk sesssiion closes

after u reload and new session is created

check out ur code properly

tina->newcoder6-Jul-08 1:12

6-Jul-08 1:12

my code,

protected void Page_Load(object sender, EventArgs e)
{
        System.Windows.Forms.MessageBox.Show(Session.SessionID.ToString());
}

The above code shows a message box with the current Session ID.

Christian Graus5-Jul-08 15:43

Christian Graus

5-Jul-08 15:43

You're storing a cookie ? I don't believe the session does this by default. One good thing about the Session is that, unlike cookies, the user cannot turn it off.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

tina->newcoder6-Jul-08 1:13

6-Jul-08 1:13

na ...
i am not storing any cookie ...!

tina->newcoder6-Jul-08 1:15

6-Jul-08 1:15

I have tested that (posted) code for both IE 6.0 and Firefox 2.0
Both are showing similar behavior !!!!
Confused | :confused:

Steve Westbrook6-Jul-08 16:15

Steve Westbrook

6-Jul-08 16:15

Try to replicate this issue in an empty web app. If it occurs, then the problem is with your server's configuration (machine.config). If not, the problem is only application-level. My guess is that this is the case: see if you have a really low session Timeout set, or if you have a Session.Abandon() command somewhere in your program.

tina->newcoder6-Jul-08 23:14

In App_GlobalResources how can i add resources for menu

6-Jul-08 23:14

Steve Westbrook wrote:
Try to replicate this issue in an empty web app

the code i shwon is of an empty web-app.

Steve Westbrook wrote:
server's configuration (machine.config)

how to fix it ?

Steve Westbrook wrote:
low session Timeout set,

i m not changing, so the default 20min shall be there...

Steve Westbrook wrote:
Session.Abandon()

na .. it is not the case.

What is the result of 'that' code on your machine ?
Confused | :confused:

amistry_petlad5-Jul-08 4:53

amistry_petlad

5-Jul-08 4:53

Hi everybody how can i add menu for different languages in App_GlobalResources.
Anybody can have idea?
please help me out.
Thanks

How to validate user input with SQL database using asp.net C#?

katelva5-Jul-08 4:01

katelva

5-Jul-08 4:01

Hi,

I have created a login page using asp.net C#(not using login control).But I am wondering how to I validate the user input with SQL database? I have created a login.aspx with user input username and password, I put the code in login.aspx.cs,but I am not sure the syntax for asp.net in C#. So far, all the codes I search are for VB.net. I am not sure how do I validate user input with SQL database using asp.net in C#?

Do anyone have any recommended websites for this?

Thanks.

Regards,
Katelva

Re: How to validate user input with SQL database using asp.net C#?

Christian Graus5-Jul-08 4:03

Christian Graus

5-Jul-08 4:03

I think you're asking how to call a SQL database. You could only find VB examples ? They are easy to convert, and there's web sites that do it for free. Also, the code is the same if it's ASP.NEt or not, you just need to get some C# ADO.NET examples. Plenty on this site and elsewhere.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Re: How to validate user input with SQL database using asp.net C#?

katelva6-Jul-08 23:31

katelva

6-Jul-08 23:31

Hi Christian,

Can you give me the recommended website of learning asp.net using language C#, I am newbie to asp.net C#, so I am not sure how to read the data from SQL Express database and validate the user input from the database using asp.net C#. Mostly from book and internet are in VB language.

The bottom is my source code where I have tried to use SQLdataReader:

protected void btnSubmit_Click(object sender, EventArgs e)
{
string uname = txtUserName.Text;
string pwd = txtPassword.Text;

string connectionString = "Data Source= .\\SQLEXPRESS;"
+ "AttachDbFilename=\"C:\\Documents and Settings\\kathy\\My Documents\\Visual Studio 2008\\WebSites\\WebSite1\\App_Data\\salon.mdf\";"
+ "Integrated Security=True;"
+ "User Instance=True";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand cmd = myConnection.CreateCommand();

cmd.CommandText = "SELECT * FROM [Customer]";
myConnection.Open();

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
if (dr.GetOrdinal("UserName").ToString() == txtUserName.Text)
{
Response.Write("Heelo");
//dr.Close();
}
//dr.Close();
myConnection.Close();
}
}

Thanks.

Regards,
Katelva

Re: How to validate user input with SQL database using asp.net C#?

Herman<T>.Instance8-Jul-08 4:06

Herman<T>.Instance

8-Jul-08 4:06

you should do a Binary_checksum in your SQL:

Example of a Stored Procedure with Binary_Checksum:
CREATE procedure [dbo].[SE_SelSecUserCredentials]
@UserName NVARCHAR(45),
@PassWord NVARCHAR(45)
AS
begin
SELECT
......., ............., ........
FROM
UserTable
WHERE
active = 1
AND BINARY_CHECKSUM(loginName) = BINARY_CHECKSUM(@UserName)
AND BINARY_CHECKSUM(password) = BINARY_CHECKSUM(@PassWord)
end

RSS in ASP.NET

.NET- India 5-Jul-08 2:47

.NET- India

5-Jul-08 2:47

Hello,

I'm showing property news in my website throught RSS. And it's working fine in localhost but as i upload it over server then it's raising Runtime Error

my site url is:- http://www.investbackhome.com

and there is a link News it has further two sub-links like Property News-India and Property News- Overseas which are throwing the Runtime errors

Re: RSS in ASP.NET

N a v a n e e t h5-Jul-08 2:53

5-Jul-08 2:53

Turn custom errors off. You will get the error message then.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: RSS in ASP.NET

.NET- India 5-Jul-08 3:04

.NET- India

5-Jul-08 3:04

It's raising Security Exception error
as shown in below url
http://www.investbackhome.com/Property_India.aspx[^]

Re: RSS in ASP.NET

N a v a n e e t h5-Jul-08 3:13