|
Hai Friends,
I have one problem withe Excel Sheet, Actually Iam uploading excel sheet , and I am storing the contents of Excel sheet in DATASET and i am reading the data from DATASET
While Reading Data from DATASET,Iam unable to read the INTEGER data Even i am reading the data of Text,
getting problems with INTEGER data and it is giving error is INVALID CAST ERROR and it is showing the valuse DBNull
i have tried to solve it by changing the properties of Excel Sheet CEll,but could not Succeed
Iam giving Code what i wrote in aspx.vb
Dim TNo As String
Dim ASFD As integer
For i = 4 To DS.Tables(0).Columns.Count - 1
TNo = Trim(DS.Tables(0).Rows(0).Item(i))
ASFD = DS.Tables(0).Rows(6).Item(i)
when i am reading the ASFD,iam getting the INVALID CAST Error
|
|
|
|
|
Don't spam the boards repeating the same thing over and over again. Posting your question once is sufficient for people to see it.
|
|
|
|
|
Hi
How can I make a auto generated column read-only. Means when I click the edit button some column data should appear as it is. It should not change to edit mode. As we are making a column read-only in window app. Is it possible in web app?
Thanks & Regards
Smruti
Smruti
|
|
|
|
|
Hi all
I got the answer. By setting the DataKeyNames we can make a auto genereted column read only.
|
|
|
|
|
Hi all,
How can I create a short cut key any button in .net. Suppose I have a button named btClick and button text as "Click". In this I want to keep "C" as short cut key for this button click event. Can I do it in Windows and Web applications too?. If so please tell me how in both type of applications?. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
I don't think you can in web apps. In windows apps, you can certainly catch a keyboard event and call the button click if it's a 'c'. I am not sure if it's possible otherwise. In a menu, if you type &, as in &Click, that gives you a shortcut.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
if you want to do it in web application,you must have a focus on something(e.g textbox) and then catch the keyboard code to press
|
|
|
|
|
Yeah, ok. Even then too, how. Please give me the details if possible please. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
This means, you can handle a key press in javascript, so long as you require the user to have focus on a specific control. Or, you can hook the code up for all controls, I guess.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
use "access key" property of a text box, or button... in web application this will solve ur problem....
|
|
|
|
|
i wanna test a windows application i have it is suppose to send string to a website and accept response string it doesn't matter wat the response is even if it is a boolean value.
can anyone tell me of any website they know that allows you to test this or how i can create a simple one that jus accepts and send reply on my iis
or even a sample that i can download and install i jus wanna test my windows app
|
|
|
|
|
create a web service, then register it with IIS, call it from ur windows application for first time,,
then stop ur IIS then again run ur app. u will find error...
regarding WEB Servcices check out web resources...
|
|
|
|
|
i am not getting security tab , when i click properties of web.config file,
i want to giv permissions to fullcontrol( i want to put tick mark).
thanks
aslam
|
|
|
|
|
Where are you clicking ? If you don't see a security tab in Explorer, chances are you have basic security turned on.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
i wrote code in web form , when i run it says error like
error couldnot find the file"c:\inetpub\wwwroot\Web.config"
my code is :
try
{
DataSet ds=new DataSet ();
ds.ReadXml(Server .MapPath ("./../Web.config"));
DataRow row;
row=ds.Tables [6].NewRow ();
ds.Tables [6].Constraints .Add ("usr_pk",ds.Tables [6].Columns [0],true);
row[0]=TextBox1 .Text ;
row[1]=FormsAuthentication .HashPasswordForStoringInConfigFile (TextBox1 .Text ,"md5");
row[2]=0;
ds.Tables [6].Rows .Add (row);
DataRow row1;
row1=ds.Tables [8].Rows [0];
row1.BeginEdit ();
row1[0]+=","+TextBox1 .Text ;
row1.EndEdit ();
ds.WriteXml (Server .MapPath ("./../Web.config"));
lblmsg.Text ="user registeed";
}
catch(Exception ex)
{
lblmsg.Text ="error"+ex.Message ;
}
aslam
|
|
|
|
|
Well, do you have a web.config file there, or not ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
im using vb. To summarize, i have a textbox where user input quantity and a gridview to display the price. i also have a submit button to calculate the totalprice where totalprice = quantity * price.
meanwhile im using a label to store the value price.
<br />
Dim tmp As Double = e.Row.Cells(3).Text.Trim<br />
Label1.Text = "$" + (tmp).ToString("0.00")<br />
this is the submit coding
<br />
myCommand.CommandText = "INSERT INTO [Order] ([Quantity], [TotalPrice]) VALUES ('" & CStr(Me.txtQty.Text) & "',__________)"<br />
<br />
is ________ me.txtQty * Label.Text ?? i need to know what should be the correct way.<br />
<br />
<br />
<br />
thanks in advance. Much appreciated.
|
|
|
|
|
Plz try this
cdbl(me.txtQty.text) * cdbl(Label.Text )
or
cint(me.txtqty.text) * cint(Lable.Text)
Your access database column type should be integer, Float or Double....
Quantity,TotalPrice.
Better way.........
dim Total as integer = cint(me.txtqty.text) * cint(Lable.Text)
"Insert Into order (quantity,TotalPrice) Values (" & me.txtQty.Text & "," & cstr(Total) & ")"
Parwej Back...............DON of Developer.......
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
thanks but there was an error
No value given for one or more required parameters.
Dim Total As Integer = CInt(Me.txtQty.Text) * CInt(Label1.Text)<br />
myCommand.CommandText = "INSERT INTO [Ord] ([Quantity], [TotalPrice]) VALUES ('" & CStr(0) & "','" & CStr(Total) & "')"
i change my databse for TotalPrice to number instead of currency.
thanks in advance. Much appreciated.
|
|
|
|
|
The error message means that you have one or more names in the query that doesn't match the database. Check the name of the table and the names of the fields.
If the fields are numeric, you should not use apostrophes around the values, as that makes them string values.
Why are you storing the total price in the database anyway? If you display the data later, don't you want to display both the price and the total price? You can always calculate the total price if you store the price and the quantity, but if you store the total price and quantity you have to re-create the price, which is a bit backwards.
---
Year happy = new Year(2007);
|
|
|
|
|
in detail, i have two tables, 1 is products details and the other is order details.
so the totalprice n quantity are meant for the order details table.
so how should i solve the problem? both the field names are spelled correctly.
thanks in advance. Much appreciated.
|
|
|
|
|
blurMember wrote: in detail, i have two tables, 1 is products details and the other is order details.
so the totalprice n quantity are meant for the order details table.
I see. You might consider copying the price from the products table to the order table at the time of the order, so that the orders doesn't change if the product changes.
blurMember wrote: both the field names are spelled correctly.
The database begs to differ...
Debug the application and look at the query that you created, so that you see if it ended up the way that you expect.
---
Year happy = new Year(2007);
|
|
|
|
|
hi every one,
i am trying to get code for this project, i hav to submit in the college,
is there any one can help me to find this or give me the link or if any one can
able write, please write it for me.
thanks very much
this is abstract:
Project Title : TRADING PARTENERS COLLABORATION
ABSTRACT
The Trading Partners Collaboration application is a web-based application for primarily providing Services to Companies who hire Consultants from vendors/suppliers. The main aim of this application is to Reduce Administrative costs by automating the workflow (via Web) taking place between the people on the Company-side and the people on the vendor-side and the hired Consultants.
This Application is useful for preparing the timesheets, which are entered by the consultants. Time sheet consists of company and project details and for each task like coding, design, testing, and documentation etc, the number of hours they worked throughout the week.Consultant having the permission to enter the time sheet. Also can check different types of reports based on project or client wise. These entered Time sheets can be approved or rejected by the manager (approver).this approving the time sheets is done by manager at the end of week by selecting option called week ending dates. At the manager’s login there are reports based on different search criteria. To maintain the details of users, projects, consultants, permission to login users and define the new roles can be done at administrative tasks. This application is maintaining three types of logins consultant, manager and administrator. Consultant can act as timesheet entry or expense sheet entry. Manager role is to approve the time sheet or expense sheet. And admin maintain all the details of consultants, managers, projects and roles. This reduces administrative costs for the company side.
aslam
|
|
|
|
|
aslamshaik2510978 wrote: i am trying to get code for this project, i hav to submit in the college,
is there any one can help me to find this or give me the link or if any one can
able write, please write it for me.
I think the idea is that you write it.
|
|
|
|
|
aslamshaik2510978 wrote: please write it for me.
I suggest you either change your attitude, or drop out of your course now.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|