I have been looking for code to show a dropdownlist date for a person to select there date of birth without calendar.
I have the below code but if there is some code in Ajax Javascript I will use it.
I feel like I am inventing the wheel.
I have to make sure that all these are c# and return the appropriate value.
I appreciate any help.
[CODE=c#]public string Populate_MonthL ist()
{
...
macupryk
Last Activity: Aug 27 '08, 01:59 PM
Joined: Sep 27 '06
Location:
-
Dropdownlist date selector(no calendar) in AJAX C#.
-
Need to modify stored proc for crystal report. Important.
Need to modify the stored proc where we can add the REP_NAME. to an existing crystal report.
I will also need to order by REP_NAME and group by REP_NAME.
Many customer id's can belong to one Sales REP. I need help first on modify the stored proc below.
I must modify the procedure below and the two tables attached as code snippet can help get the
REP_NAME.
=============== =============== =============== =============== =============== ====... -
macupryk started a topic soapclient. need to extract information in php from a webservice that was built in C#in PHPsoapclient. need to extract information in php from a webservice that was built in C#
soapclient. need to extract information in php from a webservice that was built in C# asp.net 2.0
I am new to php. Can someone help me with the code below.
I would like to learn how to manipulate the information so if the user would like to display
the contents of start_date on his/her web page. How would I go parsing this.
[code=xml]
<?xml version="1.0" encoding="utf-8" ?> ... -
Modify a ultradatagrid on click
I press modify button and there is an arror beside the row.
Then I call a dialog with a ScaleName, ScaleDescriptio n to modify.
private void ultraButtonModi fyScale_Click(o bject sender, EventArgs e)
{
ReportModifySca le _reportModifySc ale = new ReportModifySca le();
_reportModifySc ale. = e.Row.Cells["ScaleName"].Value.ToString ();
_reportModifySc ale.... -
Stored procedure not returning anything
Returns nothing?
private DataSet DoQuery()
{
DataSet ds = null;
SqlConnectionSt ringRG_Study = ConfigService.I nstance.GetStri ng("RG10_Study" );
try
{
VxDbClient _dbClient = new VxDbClient();
VxDbConnection _connection = new VxDbConnection( VxDbType.Sql, SqlConnectionSt ringRG_Study);... -
Creating a UltraGrid and data binding
I have the following table
USE [RG10_Study]
GO
/****** Object: Table [dbo].[Report] Script Date: 10/16/2006 07:45:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
CREATE TABLE [dbo].[Report](
[ReportId] [int] IDENTITY(1,1) NOT NULL,
[ReportName] [nvarchar](255) COLLATE Latin1_General_ CI_AS NOT NULL,
[ReportDefinitio n] [nvarchar](4000)... -
Need a book for reporting services
http://www.amazon.ca/s/ref=nb_ss_gw/701-8175374-6201155?url=sea rch-alias%3Daps&fie ld-keywords=report ing+services
I need a book to do the following:
Create a format of a report.
Define parameters of a format of a report, name, description.
Choose options of period of report
Modify the format of a report.
Create a chart by name, description, grouping by.... -
Value zero is being returned.
DECLARE @SQL6 NVARCHAR(4000)
SET @SQL6 = N'EXECUTE ' + @nvcDatabaseNam e + N'.dbo.sp_execu tesql N''
CREATE PROCEDURE [dbo].[Rg_sp_GetProjec tQuestionID]
@ProjectQuestio nId int output,
@ProjectQuestio nName nvarchar(255)
AS
SET NOCOUNT ON
SELECT distinct ProjectQuestion Id from
ProjectQuestion where @ProjectQuestio nName=ProjectQu estionName'''
EXECUTE (@SQL6)
public void... -
Getting a column from from a datatable
I am not sure how to get a column from a datatable, I cannot use foreach.
DataColumn dataColumn = DataColumn TEXTDT.Columns[2+columns].ColumnName.Tri m();
if (rows < TEXTDT.Rows.Cou nt) // this will prevent rows to exceed number of rows in TEXTDT
{
// Insert each answer
DataColumn dataColumn = DataColumn TEXTDT.Columns[2+columns].ColumnName.Tri m();... -
Insert statement conflicted with foreight key contrait.
{System.Data.Sq lClient.SqlExce ption: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProjectResp onse__ProjectQu estionId". The conflict occurred in database "RG_ProjectData ", table "dbo.ProjectQue stion", column 'ProjectQuestio nId'.
The statement has been terminated.
public void ProjectResponse andRespondentTo DB(DataRow dr, string contents, int iProjectQuestio nID, int... -
Connection string problem.
+ ex {"The name \"CHARACTER\ " is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted."} System.Exceptio n {System.Data.Sq lClient.SqlExce ption}
+ dr {System.Data.Da taRow} System.Data.Dat aRow
dr[1] "CHARACTER" object {string}
dr[2] "NAME" object {string}
dr[3] "14/09/2006... -
Problem with stored proc.
{System.Data.Sq lClient.SqlExce ption: Incorrect syntax near 't'.
Must declare the scalar variable "@ProjectQuesti onId".
Unclosed quotation mark after the character string ''.
Must declare the scalar variable "@ProjectCodeId ".
Incorrect syntax near 't'.
Must declare the scalar variable "@ProjectQuesti onNo".
USE [RG10_Study]
GO
/****** Object:... -
Need to utilize exec('use '+@nvcDatabaseName+';
exec('use '+@nvcDatabaseN ame+';
How can I use this with a stored proc.
ALTER procedure [dbo].[Rg_sp_CreatePro jectProcedures] @nvcDatabaseNam e nvarchar(255)
--with execute as 'dbo'
as
exec('CREATE PROCEDURE [dbo].[AddProjectQuest ionContentFrequ ency]
AS
=============== =============== =============== =============== =======
I can do it with tables.
ALTER procedure... -
Stored proc not working.
I have this stored proc
USE [RG_ProjectData]
GO
/****** Object: StoredProcedure [dbo].[AddProjectQuest ionIdFrequency] Script Date: 09/28/2006 11:22:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[AddProjectQuest ionIdFrequency]
AS
DECLARE
@ProjectQuestio nId... -
Building the ado.net
How do I build the ado.net for this.
There are no inputs?
USE [RG_ProjectData]
GO
CREATE PROCEDURE AddProjectQuest ionContentFrequ ency
@ProjectQuestio nId int,
@ProjectQuestio nContent nvarchar(255),
@ProjectQuestio nContentFrequen cy int,
@ProjectQuestio nContentDateTim e datetime
AS
SET NOCOUNT ON
SET @ProjectQuestio nContentDateTim e... -
Invalid column name 'ProjectQuestionContentDateTime'
I build the following:
USE [RG_ProjectData]
GO
CREATE PROCEDURE AddProjectQuest ionContentFrequ ency
@ProjectQuestio nId int,
@ProjectQuestio nContent nvarchar(255),
@ProjectQuestio nContentFrequen cy int,
@ProjectQuestio nContentDateTim e datetime
AS
SET NOCOUNT ON
select ProjectQuestion Id, ProjectResponse Content, count (*) ProjectQuestion ContentFrequenc y... -
if (TEXTDT.Rows[rows][dataColumn.ColumnName] != DBNull.Value) fails.
if (TEXTDT.Rows[rows][dataColumn.Colu mnName] != DBNull.Value)
{System.IndexOu tOfRangeExcepti on: There is no row at position 10.
at System.Data.RBT ree`1.GetNodeBy Index(Int32 userIndex)
at System.Data.Dat aRowCollection. get_Item(Int32 index)
I have to fix this somehow so it does not bomb on this. -
There is no row at position 10.
How do I validate before going in the function.
string value = TEXTDT.Rows[0][cell.ToString()].ToString();
ProjectQuestion ToDatabase.Proj ectResponseandR espondentToDB(T EXTDT.Rows[Convert.ToInt32 (var.no)-1], value, intId, Convert.ToInt32 (var.no)); -
Removing blank spaces or add
-- _list Count = 13 System.Collecti ons.ArrayList
+ [0] {QUEST} object {System.Data.Da taColumn}
+ [1] {S_DAT} object {System.Data.Da taColumn}
+ [2] {NAME } object {System.Data.Da taColumn}
+ [3] {INTRO} object {System.Data.Da taColumn}
+ [4] {PART } object {System.Data.Da taColumn}
+ [5] {INT00}... -
Column 'NAME' does not belong to table targetTable
I don't understand why this does not work.
object cell = _dtProjectQuest ion.Rows[0]["ProjectQuestio nName"];
object value = TEXTDT.Rows[0][cell.ToString()];
In the TEXTDT there is a column table "NAME"
cell = "NAME"
I don't understand
No activity results to display