|
Hi Guyz
I have the following Database Tables
tbStaff
StaffID, Name, etc, etc, etc
1, Bob, ..., ..., ...,
2, Bill, ..., ..., ...,
3, John, ..., ..., ...,
4, Marry, ..., ..., ...,
tbStaffFigures
StaffID, Date, Value,
1, 01-01-08, 200,
2, 02-01-08, 100,
I want to dynamically create a GridView that looks like the following:
Date, Bob, Bill, John, Marry
01-01-08, 200, 100, Value, Value,
02-01-08, Value, Value, Value, Value,
etc, etc, etc, etc, etc,
|
|
|
|
|
I think I've seen this assignment before
Make a google search on "pivot OR crosstab sql" and the name of your database
|
|
|
|
|
HI ALL,
i'd calculator project in that i'm getting small error after getting the result (2+3=5)
the result value 5 is not deleting in text box, again it adding to new value given by user
can u help me
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Collections;
namespace cal_sample
{
public partial class Form1 : Form
{
int r;
ArrayList a = new ArrayList();
public Form1()
{
InitializeComponent();
}
private void button_one_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text+button_one.Text;
}
private void button_two_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_two.Text;
}
private void button_three_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_three.Text;
}
private void button_four_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_four.Text;
}
private void button_five_Click(object sender, EventArgs e)
{
// textBox1.Text = "";
textBox1.Text = textBox1.Text + button_five.Text;
}
private void button_six_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_six.Text;
}
private void button_seven_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_seven.Text;
}
private void button_eight_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_eight.Text;
}
private void button_nine_Click(object sender, EventArgs e)
{
//textBox1.Text = "";
textBox1.Text = textBox1.Text + button_nine.Text;
}
private void plus_Click(object sender, EventArgs e)
{
if(textBox1.Text !="")
{
a.Add(Convert.ToSingle(textBox1.Text));
textBox1.Text = "";
}
else
textBox1.Text = Convert.ToString(0 + r);
}
private void equl_Click(object sender, EventArgs e)
{
r = 0;
for (int i = 0; i < a.Count; i++)
r = r + Convert.ToInt32(a[i]);
if (textBox1.Text != "")
{
textBox1.Text = Convert.ToString(r + Convert.ToInt32(textBox1.Text));
a.Clear();
}
else
textBox1.Text = Convert.ToString(r + 0);
}
private void button_clear_Click(object sender, EventArgs e)
{
textBox1.Clear();
}
private void button_zero_Click_1(object sender, EventArgs e)
{
textBox1.Text = textBox1.Text + button_zero.Text;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button_period_Click(object sender, EventArgs e)
{
textBox1.Text = textBox1.Text + button_period.Text;
}
}
}
[code][/code]
madhu
|
|
|
|
|
madhu Rao wrote: textBox1.Text = Convert.ToString(r + Convert.ToInt32(textBox1.Text));
is the problem i believe, also you allow them to use decimals but convert everything to INT, which i fairly certain wont work, unless integer means something else in your computer. also every button click runs a += line, so unless the answer to the previous problem is cleared, it will always use that answer ..as the first number in the next set. so if you do 2 + 3 = and get 5 then try to do 4 + 3 you end up with 54 + 3. unless i misread something.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
This is not the Right forum for your Question !!! Post it to C# Forum 
|
|
|
|
|
i am working webparts ..Its working successfully but cannot published...
the following error will be displayed
Error 1 The process cannot access the file 'C:\Documents and Settings\Afxisi\Desktop\webparts\UserControlEditorPartEx\App_Data\ASPNETDB.MDF' because it is being used by another process. /
|
|
|
|
|
Are you getting the error while publishing the website from Visual Studio ?
|
|
|
|
|
Try,
at the time of publishing,the application should not in running state
Cheers!!
Brij
|
|
|
|
|
You can't Publish your web application if its on running mode. you have to stop debugging !!!!  
|
|
|
|
|
Hi to all,
I am new to ASP.net and i want to execute some code after textbox's lostfocus event in ASP.Net. I tried by using its TextChanged event but it takes more time to execute it because it executes on server, i want to execute this code on client machine only. how can i do this?
Help me.
Thanks.
Pravin
|
|
|
|
|
pavya_Cool wrote: i want to execute this code on client machine only. how can i do this?
You could use a client side script such as Javascript with the onChange() event handler - it depends what code you want to run though.
Regards,
--Perspx
"The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia
Introduction to Object-Oriented JavaScript
|
|
|
|
|
Hi,
Thanks for reply. I tried this by using the following function.
txtusername.Attributes.Add("onchange", "txtusername_TextChanged()")
but i am not getting success. Also i am not able to trace it.
Pravin
|
|
|
|
|
pavya_Cool wrote: txtusername.Attributes.Add("onchange", "txtusername_TextChanged()")
your trying to run a Server side function, you cant do it using this way.
just use ther javascript function
txtusername.Attributes.Add("onchange", "javaScriptFunction()")
|
|
|
|
|
use onblur Property for Lostfoucs on Client Side
<asp:textbox id="yourtext" runat="server" onblur="YourJScriptMethods();" xmlns:asp="#unknown" />
|
|
|
|
|
thanks,
actually iam new to javascript... i have to check this first...
Pravin
|
|
|
|
|
sure , just check it and let me know .
|
|
|
|
|
Hi,
I have an website which has few pages accessing data in an old method(The ADODB method) and few pages using the ODBC method. All the pages works fine in an 32 bit XP machine. We have a server with 64 bit, when i deployed this website in that server, i got the following error,
Class not registered
Exception Details: System.Runtime.InteropServices.COMException: Class not registered
Stack Trace:
[COMException (0x80040154): Class not registered]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0
When it tries to opdn the ADODB connection, it fails. I have installed MDAC 2.8 in that server.
Do i have to do anything more to get it work. Any suggestions would be of great use.
N.Surendra Prasad
|
|
|
|
|
did you install 64bit .NET Framework on that system !!!
|
|
|
|
|
Yes, 64 bit .net framework is installed in that machine.
N.Surendra Prasad
|
|
|
|
|
How did you deployed the sites on IIS ? did you published the Sites from visual Studio?
|
|
|
|
|
Yes, i published it through Visual Studio.
N.Surendra Prasad
|
|
|
|
|
Did you Embed you DAta access code into your page or you have a DLL for that ? if so did you deploy it with your Application ?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
The Data Access code is embedeed in my page. I donot have a separate DLL for that.
N.Surendra Prasad
|
|
|
|
|
hi
I deploy my application like this. I after i Build the Project,i use the Copy Website feuture of VS to the Production Folder that i have Created, and that will be all i dont use Publish feuture, i think thats where you got a Problem. i know what the Publish do , but in that case i dont rely on VS to do it for me. try not to use Publish, i have a 64 machine and i dont have problems.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi I have developed an asp.net webpage which contains one textbox.I want when the user presses M key inside the textbox,a serverside event(aspButton1.Click) to be fired.We tried with _doPostBack.But failed.
ARINDAM
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
