Hi
I have changed the line no 25 as
cmdItem.Paramet ers.Add(paramco mm)
But still I got the error as
Error converting data type numeric to decimal.
sweatha
Last Activity: Jul 15 '09, 07:42 AM
Joined: Mar 10 '08
Location:
-
Hi
Then I replaced the lines
Dim commision As String = txtCommission.T ext
Dim EffectiveDate As String = txtDate.Text
as
Dim commision As Decimal = txtCommission.T ext
Dim EffectiveDate As Date = txtDate.Text
but while running the error is
The SqlParameterCol lection only accepts non-null SqlParameter type objects, not Decimal object...Leave a comment:
-
problem with data type
Hi
I have to insert the commision value and date into the database. For that I have given the coding as
...Code:Imports System.Data Imports System.Configuration Imports System.Data.SqlClient Partial Class commision1 Inherits System.Web.UI.Page Public strConnection As String Public Conn As SqlConnection Public Sql As String Public AdditionalSQL As String Protected
Last edited by DrBunchman; Jul 30 '08, 12:21 PM. Reason: Added [Code] Tags - Please use the '#' button -
using calendar extendar
Hi
I have used a calendar extendar in my form. For that I have added a script manager. but if I add that I am having a error in designing in scriptmanager itself.
My coding is
...Code:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="commision.aspx.vb" Inherits="commision" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit"
Last edited by DrBunchman; Jul 30 '08, 12:47 PM. Reason: Added [Code] Tags - Please use the '#' button -
automatic id generation
Hi
I have the table named commission with 3 fields as id int, commission decimal(2,2), effectivedate smalldatetime. . I have to generate the id field automatically. To generate id feild automatically as 1,2,3,...., what code should I give in .net or wheather I should set any properties in sql server 2005 -
Hi
I tried that but it is still showing error:
Input string was not in a correct format....Leave a comment:
-
Failed to convert parameter value from a String to a Decimal
Hi
In sql server 2005 I have a column as
GraduationYear Decimal(4,0). In asp.net I used the coding for that as
SqlParameter GraduationYear = new SqlParameter("@ GraduationYear" , SqlDbType.Decim al);
GraduationYear. Value = GYTextBox.Text;
but while running I got error as
Failed to convert parameter value from a String to a Decimal. -
Stored Procedure
Hi
I have to convert the following query into stored procedure
"select DoctorMaster.Fi rstName+''+Doct orMaster.Middle Name+''+DoctorM aster.LastName as DoctorsName,Doc torMaster.DRID, DoctorMaster.Ge nder,DrClinicDe tails.Address,D octorMaster.Tel ephone+','+Doct orMaster.Mobile as Phone,PrimaryTi tle.PrimaryTitl e from DoctorMaster,Dr ClinicDetails,P rimaryTitle,Spe cialty where DoctorMaster.Fi rstName like '" + obj.ToString()... -
Converting Object to Short
Hi
I have to select count(Date) from Appointment table having count<5. If count(Date)<5 then I should insert the data from my page. For that I have given the coding as
[code=c#]
protected void Button3_Click(o bject sender, EventArgs e)
{
SqlConnection con = new SqlConnection(" user id=sa;password= cast;database=H ello_Dr;server= AURORA-SERVER;");
con.Open();
SqlDataReader...Last edited by Frinavale; Feb 23 '09, 05:12 PM. Reason: Moved to ASP.NET Answers from .NET (Plater added [code] tags) -
Using SQLDataSource in GridView
Hi
I connected SQLDataSource in GridView by using coding
...Code:<asp:GridView ID="Search_GridView" runat="server" Style="z-index: 100; left: 2px; position: absolute; top: 270px" AutoGenerateColumns="False" OnSelectedIndexChanged="Search_GridView_SelectedIndexChanged" CellPadding="20" Width="720px" AllowPaging="True" OnPageIndexChanging="Search_GridView_PageIndexChanging" -
Hi
In my DB, I have the Appointment Table with the following columns
APID nvarchar(12)
USID nvarchar(12)
DRID nvarchar(12)
Date datetime
Brief Desc nvarchar(50)
Other Desc nvarchar(500)
Add by char(2)
Status char(1)
My requirement is the patients can fix an appointment to the doctors. If already appoints are fixed by an patients for...Leave a comment:
-
Hi
sorry for delay.
In ASP .Net calendar control, I have to block all dates which has count >=5 in DB during the page load...Leave a comment:
-
.net stored procedure
Hi
I am quite new in writing stored procedure. I have created a stored procedure for binding the data from DB. I have to bind data from Specialty table with 2 feilds. For that my stored procedure coding is
set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
go
-- =============== =============== ===============
-- Author: <Author,,Name >
-- Create date: <Create... -
Calendar date blocking
Hi Experts
I have selected date from DB by using query
"Select Date from Appointment where Count(date)>=5"
I have to block all dates that I retrieved from DB in Calendar control. If I have to block a single date (eg: 28-6-2008), I can block that date by using the coding
if (e.Day.Date =='28-6-2008')
{
e.Day.IsSelecta ble...Leave a comment:
-
Calendar date blocking
Hi
Can anybody help me how to block all dates in calendar control till the current date. -
Controlling Page Load
Hi
My issue is If I click the link button in my page, then Table1 should get visible & by default the Table1 should not be visible. For that, I have set the visible property of the Table1 as False by default & under link button click event I have set it as True. But the problem is the page is loading every time. Can anybody reply me how to control the page load. -
PageRequestManagerParserErrorException
Hi
I have created the login form with the following coding
Protected Sub imgLogin_Click( ByVal sender As Object, ByVal e As System.Web.UI.I mageClickEventA rgs) Handles imgLogin.Click
Dim con As SqlConnection
Dim cmd As New SqlCommand
Dim str As String
Dim rd As SqlDataReader
str = "user id=sa;password= cast;database=j sc;server=AUROR A-SERVER"... -
Hi
I got the sol for above issue. The thing is I have changed the table name again in the above stored procedure and I have n't executed it. Thats why.
Now for Login form I created the stored procedure as
set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
go
ALTER PROCEDURE [dbo].[Pro_Login1]
@loginid varchar(50),
@password...Leave a comment:
-
Using Stored Procedure
Hi
I have created a stored procedure for registration form as
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
-- =============== =============== ===============
-- Author: <Author,,Name >
-- Create date: <Create Date,,>
-- Description: <Description, ,>
-- =============== =============== ===============
CREATE PROCEDURE dbo.Pro_Login
... -
problem with smtp mail sending
Hi
Through smtp I have to send email by getting the "To"-Email Id from textbox named txtTo. For that I have given the coding as
...Code:Imports System Imports System.Net Imports System.Web.Mail Imports System.Net.Mail Partial Class Default3 Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object,Leave a comment:
No activity results to display
Leave a comment: