SQL DSN Losing Default DB Setting?

Mar 19, 2004

This isn't really DB related, except for the connection, but I was wondering if any of you guys had run into this before.

I have a ODBC System DSN Setup for a connection to my MSSQL2K Server. My users will occasionally lose the Default Database setting (Drop-down during DSN Setup), forcing me to go in and reset it. It's getting to be a pain in the ass and I was wonder if any of you guys had run into this before.

Thanks!
Ed

View 1 Replies


ADVERTISEMENT

T-SQL Setting Default Value

Feb 2, 2006

I have the following to create a new table....
CREATE TABLE dbo.test (Id varchar(20) NOT NULL PRIMARY KEY,    Name varchar(256) NOT NULL,    visible bit NOT NULL                                          )
 
I need to set the default value of the bit visible to 1.
How can this be done using a T-SQL statement?
Thanks,
Zath

View 1 Replies View Related

Setting Default

Jul 15, 2002

Hi all:

How can I change the Default value of a column in a table using sql?
for instance I have a table called Phone and I have a field called AreaCode and the default now is '123' . I would like to change it to '456'.

Thanks,
Nisha

View 1 Replies View Related

Setting Default Value

Jan 8, 2007

hi

i have to add a column of date datatype and i want to set the default value to getdate(). how to do this using sql script.

thanks

suji

View 1 Replies View Related

Default Database Setting

Mar 18, 2015

Is there any practical downside to setting ANSI_NULLS and QUOTED_IDENTIFIER to ON at the database level? Almost all devs will simply leave these default settings at the top of a stored proc script anyway.

View 2 Replies View Related

Setting Default Values

Jun 6, 2006

Pardon the newbie question...but I'm trying to load a dimension table in a small data mart that has columns in it that are unique to the dimension and not sourced from any source table. Two of those columns are date columns that I want to default to the system date and the other column I want to load with a default value. I can't figure out how to do this within a data flow task. The source columns flow from the input db source into a scd transform but I can't seem to edit the columns in the target table table if they don't actually come from a data source. There doesn't seem to be a data transform object to handle this.

Thanks.

View 5 Replies View Related

How To Modify Default Setting?

May 16, 2008

Hi,

I have few question:

1)Is it any methot to modify lock_timeout default value? (Default value is -1, if i want to modify default value for example 1, i try [SET lock_timeout 1;] but it only work during that session / connection)

2)Is it any method to modifyTransaction Isolation Level default value? (Default value is READ COMMITTED, if i want to modify default value for example READ UNCOMMITTED, I try [SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;], but it only work during that session / connection)

Thank you!~

View 2 Replies View Related

Setting A Default Image

May 22, 2007

I have created an employee directory that displays a picture from a folder based on a consistent naming scheme. I need to set a default value for the picture for when a photo by that name does not exist in the folder. I've tried using both the ISNULL and ISNOTHING commands. Does anyone know how to do this?

View 1 Replies View Related

Restore Default Setting For MSDE

Nov 4, 2005

How can I restore the default setting for MSDE to have only Windows
Autentication and not mixed mode? And to have my sa account without
password? Please help me! Thanks, Nibbles

View 1 Replies View Related

Setting Default Transaction Level

Apr 23, 2006

is there any way I can setup the default transactional level at the Database level instead.

Such as I don't want to write the transaction isolation level at every SQL statement.

View 2 Replies View Related

Problem In Setting Default Value While Creating

Mar 14, 2008

Hi All.,

here i try to set default value 0 while creating table., But in my code its not working.,any one please help me to know how to set a default value while creating table.,

here is the sample code.,


CREATE TABLE MODULE_ROLE
(
MODULE_ROLE_IDINT IDENTITY(1,1) NOT NULL,
ADD_FLAGBIT default 0,
UPDATE_FLAGBIT default 0,
BIT default 0,
VIEW_FLAGBIT default 0,
INPUT_USERINT
)
insert into MODULE_ROLE values (null,null,1,null,1)

select * from module_role

----------------------------------------------------------------------
MODULE_ROLE_ID ADD_FLAG UPDATE_FLAG DELETE_FLAG VIEW_FLAG INPUT_USER
-------------- -------- ----------- ----------- --------- -----------
1 NULL NULL 1 NULL 1

BUT I NEED 0 FOR NULL VALUES..,

View 1 Replies View Related

Setting Default While Creating Table

Aug 31, 2007

Hi,

I am having 2 tables Groups and GroupMembers table . the following are the structures for the above two tables

Group
---------

GroupID
GroupName
CashassignmentType


Groupmembers
----------------------

MemberID
memberName
GroupID
Payment


Group table is referenced by groupmembers table through Group ID Column
Here while i am inserting a row (member) into a Groupmembers tables i want to crosscheck with CashAssinmenttype column of Group table. if cashassignment type i want to set the payment with 0 other wise the payment specified should be inserted

Groupmembers.Payment <---> If Group.CashassignmentType=0






Then 0
Else Payment




I want to set this Condition while creating tables itself

Please let me know what could be the best option to proceed here

Thank you

View 1 Replies View Related

Setting Default Code Page

Nov 28, 2007

I've been reading some forums and I'm not able to get this to work. Basically I'm using an Oracle DB source and trying to import data into SQL server 2005. I guess the best connections to use are OLE DB.

Here are my current connections:
Source: Native OLE DBOracle Provide for OLE DB
Destination: Native OLE DBSQL Native Client

I'm running SP2 of SQL 2005.

Now, the issue is I'm not getting the code page stuff correct. In the data flow I'm just doing a OLE DB Source to SQl Server Destination. I'm not doing any transformations (I'm hoping to avoid doing that).

I'm getting an error:


[OLE DB Source [1]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.


I'm looking at how to set the DefaultCodePage property in various forums, but nowhere does it say exactly how to do this. I've tried changing the "Extended Properties" and added AlwaysUseDefaultCodePage=TRUE in there, but that doesn't work. I've tried changing the Locale Identifier to 1252 that doesn't work. I've tried a combination of the two, doesn't work. Can somebody tell me two things:

1. what's the best/fastest/industry used method to get data from Oracle into SQL server via SSIS (please include the type of connections).
2. How the hell do you set the DefaultCodePage property. I would love a screenshot on this one as well.


Thanks,
Phil

View 3 Replies View Related

Setting Paper Size To Be Default A4

May 30, 2006

Hi,

I have been trying to configure the Paper Size to be default "A4" instead of "Letter".
My Report is configured to 21cm x 29,7cm and margins 1,5cm.
The Body is configured to 18cm x 26,7cm.

Everything looks fine in the Preview but the Size is always "Letter". The printers are all configured for A4 printing.

Is there a way to set these default values in the Page Setup Toolbar or is it supposed to figure it out?

Thanks,
steinar

View 4 Replies View Related

Setting To Show Default Data Row

Feb 5, 2007

Hi

I have a database details veiw on my vb 2005 express form.

When I run my program , all the data in row 1 automatically shows up, as the default.

How can I set the default to show the data from row 2 when I start up my program?

Thanks

Rob

View 2 Replies View Related

Analysis :: SSAS Default Value Setting

Oct 29, 2015

how to achieve the below mentioned in SSAS: P

1 - Set Default values 20 and 80
2 -Set Default value <> 90 or except 90.

View 2 Replies View Related

Need Help Setting Default DateTime On SqlDataSource Control

Jan 21, 2007

I thought this would be easy.  I have a repeater control and a sqldatasource control.  I am trying to filter the select statement using DateTime.Now.ToString() and keep getting an invalid date string format.  The control is on a content page in my asp.net site.  On the master page this <%= DateTime.Now.ToLongDateString() %>  works to display the current date.  If I try and put <%= DateTime.Now.ToString() %> in the Default value of the SelectParameter it does not work.  No intellisense either so I am assuming I am missing something.  Here is the code... pretty basic really.
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="sqlDSnews">
<ItemTemplate>
<h3><%# Eval("newTitle")%></h3>
</ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource
ID="sqlDSnews"
runat="server"
ConnectionString="<%$ ConnectionStrings:XXXX%>"
SelectCommand="SELECT [newTitle], [newsDetails], [dateExpires], [newsImage], [dateCreated] FROM [News] WHERE (([GroupID] = @GroupID) AND ([dateExpires] >= @dateExpires))">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="0" Name="GroupID" QueryStringField="Gid" Type="Int32" />
<asp:Parameter Name="dateExpires" DefaultValue='<%= DateTime.Now.ToString() %> 'Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
** NOTE the DateTime does not show up in blue - if that helps with a solution **

View 5 Replies View Related

Setting Default Value Or Binding To Today In SQL Server

Apr 10, 2006

Hi,I have a column (type: datetime) in which I want to load the current date and time.What should I fill in in the default value or binding so that SQL server automatically fills this column?Thanks!

View 2 Replies View Related

Setting Default Value (concatenated String) Of Column Using UDF

Oct 23, 2005

Hello,

I'm trying to set the default value of a column (SysInvNum) in a table (caseform) of mine by concatenating 3 other fields in the same table. These other fields are all Integer datatypes. they are "CaseYear" e.g. (2005), "InvNum" e.g. (0001) and "PostId" e.g. (5).

So basically the SysInvNum column for this row should read '200500015'

When I run a basic query using the CAST or CONVERT functions like this:

SELECT convert (varchar,caseyear) + convert(varchar,InvNum) + convert(varchar,postid) from caseform

OR

SELECT cast(caseyear as varchar(4)) + cast(InvNum as varchar(4)) + cast(postid as varchar(1)) from caseform

I get the results I want. But since I want this value to be the default value of the column, I tried inserting this: convert (varchar,caseyear) + convert(varchar,InvNum) + convert(varchar,postid) into the default value parameter of the column in the caseform table. The result is a string that is the query itself.

I then tried creating a UDF called getsysinvnum() where I declare and set 2 variables whilst returning one of the variables as a varchar. An example of what it looks like is this:


CREATE FUNCTION GetSysInvNum()
RETURNS varchar
AS
BEGIN
DECLARE @maxcaseid Int
DECLARE @sysinvnum varchar

SELECT @maxcaseid = max (caseid) from caseform
SELECT @sysinvnum = cast(caseyear as varchar(4)) + cast(invnum as varchar(4)) + cast(postid as varchar(1)) from caseform where caseid = @maxcaseid
RETURN @sysinvnum
END


The result I get when I plug this into the default value of the column as : ([dbo].[getsysinvnum]()) is "2".

Yes it returns the number "2" could someone please tell me what I am doing wrong, or suggest a better way for me to do this?

Thanks in advance

'Wale

View 10 Replies View Related

Setting Default Dates In Reporting Services

Mar 26, 2008

Thought I'd help some folks with rs and dates..

here is some scalar valued functions:



CREATE FUNCTION [dbo].[get_date_only] (@date datetime)
RETURNS datetime AS
BEGIN
RETURN dateadd(day, DateDiff(day, 0, GetDate()), 0)
END

CREATE FUNCTION [dbo].[get_month_end] (@date datetime)
RETURNS datetime AS
BEGIN
RETURN dateadd(ms, -3, dateadd (m,datediff(m,0,
dateadd(m,1,@date)),0))
END

CREATE FUNCTION [dbo].[get_month_start] (@date datetime)
RETURNS datetime AS
BEGIN
RETURN dateadd(m,datediff(m,0, @date),0)
END

CREATE FUNCTION [dbo].[get_today_end] (@today datetime)
RETURNS datetime AS
BEGIN
return dateadd(ms, -3, datediff(d,0,dateadd(d,1,@today)))
END

CREATE FUNCTION [dbo].[get_today_noon](@date datetime)
RETURNS datetime
BEGIN
RETURN DATEADD(hh, 12, DATEADD(d,DATEDIFF(d,0, @date),0))
END

CREATE FUNCTION [dbo].[get_today_start] (@today datetime)
RETURNS datetime AS
BEGIN
return dateadd(day, 0, datediff(d,0,@today))
END

CREATE FUNCTION [dbo].[get_tomorrow_noon](@date datetime)
RETURNS datetime
BEGIN
RETURN DATEADD(hh, 12, DATEADD(d,DATEDIFF(d,-1, @date),0))
END

CREATE FUNCTION [dbo].[get_week_end] (@date datetime)
RETURNS datetime AS
BEGIN
return dateadd(yyyy, datepart(yyyy,
dateadd(weekday,7-datepart(weekday, @date),@date))-1900, 0)
+ dateadd(ms, -3,
dateadd(dy, datepart(dy,
dateadd(weekday,7-datepart(weekday, @date),@date)),0) )
END

CREATE FUNCTION [dbo].[get_week_start] (@date datetime)
RETURNS datetime AS
BEGIN
return dateadd(yyyy, datepart(yyyy,
dateadd(weekday,1-datepart(weekday, @date),@date))-1900, 0)
+ dateadd(dy, datepart(dy,
dateadd(weekday,1-datepart(weekday, @date),@date))-1,0)
END

CREATE FUNCTION [dbo].[get_weekday_end] (@weekday tinyint,
@date datetime)
RETURNS datetime AS
BEGIN
return dateadd(yyyy, datepart(yyyy,
dateadd(weekday,@weekday-
datepart(weekday, @date),@date))-1900, 0)
+ dateadd(ms, -3,
dateadd(dy, datepart(dy,
dateadd(weekday,@weekday-datepart(weekday, @date),
@date)),0) )
END

CREATE FUNCTION [dbo].[get_weekday_start] (@weekday tinyint,
@date datetime)
RETURNS datetime AS
BEGIN
return dateadd(yyyy, datepart(yyyy,
dateadd(weekday,@weekday-
datepart(weekday, @date),@date))-1900, 0)
+ dateadd(dy, datepart(dy,
dateadd(weekday,@weekday-datepart(weekday, @date),
@date))-1,0)
END

CREATE FUNCTION [dbo].[get_year_start] (@date datetime)
RETURNS datetime AS
BEGIN
RETURN DATEADD(year,DATEDIFF(year,0, @date),0)
END

CREATE FUNCTION [dbo].[get_yesterday_end] (@today datetime)
RETURNS datetime AS
BEGIN
return dateadd(ms, -3, datediff(d,0,@today))
END

CREATE FUNCTION [dbo].[get_yesterday_start] (@today datetime)
RETURNS datetime AS
BEGIN
RETURN dateadd(day, -1, datediff(d,0,@today))
END


Then create a Table-Valued Function like so:


CREATE FUNCTION [dbo].[udfCommonDates] (@date datetime)
RETURNS @t table (week_start datetime,
week_end datetime,
lastweek_start datetime,
lastweek_end datetime,
month_start datetime,
month_end datetime,
lastmonth_start datetime,
lastmonth_end datetime,
yesterday_start datetime,
yesterday_end datetime,
today_start datetime,
today_end datetime,
thisweek_monday_start datetime,
thisweek_monday_end datetime,
year_start datetime,
year_end datetime,
tomorrow_noon datetime,
today_noon datetime,
date_only datetime)
BEGIN
INSERT @t
SELECT
dbo.get_week_start ( @date ) AS week_start,
dbo.get_week_end ( @date ) AS week_end,
dbo.get_week_start ( DATEADD(d, -7, @date ) ) AS lastweek_start,
dbo.get_week_end ( DATEADD(d, -7, @date ) ) AS lastweek_end,
dbo.get_month_start( @date ) AS month_start,
dbo.get_month_end ( @date ) AS month_end,
dbo.get_month_start ( DATEADD(m,-1, @date) ) AS lastmonth_start,
dbo.get_month_end ( DATEADD(m,-1,@date) ) AS lastmonth_end,
dbo.get_yesterday_start ( @date ) AS yesterday_start,
dbo.get_yesterday_end ( @date ) AS yesterday_end,
dbo.get_today_start (@date) AS today_start,
dbo.get_today_end ( @date ) AS today_end,
dbo.get_weekday_start(1,@date) AS thisweek_monday_start,
dbo.get_weekday_end(1,@date) AS thisweek_monday_end,
dbo.get_year_start(@date) AS year_start,
dbo.get_year_end(@date) AS year_end,
dbo.get_tomorrow_noon(@date) AS TomorrowNoon,
dbo.get_today_noon(@date) AS TodayNoon,
dbo.get_date_only(@date) AS DateOnly
RETURN
END


Now the RS folks might be thinking but how does this help me as I need a dataset and a dataset can only be based on a Stored Procedure or a direct table. No problem create the following stored procedure:


CREATE PROCEDURE [dbo].[uspCommonDates] AS
begin
set datefirst 1
declare @date datetime
set @date = getdate()
select * from dbo.udfCommonDates(@date)
end


Now you've got a stored procedure to use as a dataset...Now in reporting services add a new dataset:



Now go to the report parameters section of the report:



Now pick that dataset dsFunctions (or whatever you called it) and then pick any of the value fields from the scalar functions such as:



Now when you run the report it uses the scalars:



If you have questions feel free to ask :).

Hope this helps someone

View 2 Replies View Related

Setting Up Default Report Startup Properties

Apr 13, 2007

Hello,

Is it possible to establish a set of default report and report body properties, perhaps in an ini file of some sort so that upon creating a new project and adding a new report item the developer does not have to go through the process of setting up all the interactive sizes, margins, paper sizes, etc each and every time? We have an established header that we incorporate on all reports and while in transition to the new Reporting Services it was my hope of finding something will create the first set of default conditions to help us automate the process just a bit.



Thank you.

View 2 Replies View Related

Setting Default Value Of A Report Parameter Dynamically

Jan 26, 2007

Hi all,

Does sombody have experience on dynamically set or change the default value of a report parameter?

Assuming: report parameters p1, p2, p3, p4 have been set up(and have their default value 'all') with the creation of the report1; report browseing is through reportviewer that embedded in the web application; datasource is datacube

What I want to do: based on the login user of the my web application, set default value of p1 as the user's username.

What I did is:

Microsoft.Reporting.WebForms.ReportParameter reportParam = new Microsoft.Reporting.WebForms.ReportParameter("P1","Mary");

ReportViewer1.ServerReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter []{ reportParam });

what I got when reveiw the report:

P1 has no default value, and p2, p3, p4 greyed and could not choose value from them.

Any idea and suggestion will be pre-appreciated!

Jone

View 1 Replies View Related

Simple ALTER Command Setting DEFAULT Help

Apr 21, 2008

Hi all, I am trying to do a very basic ALTER Command and am trying to change its DEFAULT value. Code below is what I currently have:





Code Snippet

ALTER TABLE Table_1

ALTER COLUMN TEST VARCHAR(1000) NULL DEFAULT 2

Thanks, Onam.

*UPDATE* I found this code but are there alternative methods? Additionally, if I was to update its DEFAULT value again how would I go about doing that? Do I first have to remove the CONSTRAINT and then run the command?





Code Snippet

ALTER TABLE Table_1 ADD CONSTRAINT DF_Albumns_Comment DEFAULT 2 FOR TEST

View 8 Replies View Related

How Do I Change The Default Setting From Connecting To SQL Server 2005?

May 2, 2006

Hi there!
My provider does not yet support SQL Server 2005, they are still on SQL Server 2000. I put together a very basic login page, but it is crashing everytime I access it because of this problem, and sadly I am not advanced enough as yet to know how to remedy it! Can you help?
Here is the error page, some of it; - Any ideas gratefully received!
Russ.

Server Error in '/' Application.


An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

View 1 Replies View Related

Setting The Default To &&<Select All&&> In Multivalue Parameter List

Aug 21, 2007

How can I set the multivalue parameter list's default option to <Select All> ?

View 2 Replies View Related

Setting Default Parameters Via The Reporting Services Viewer

Oct 23, 2007

HI,
I am trying to set the following default parameter : datepart("m",now()). The parameter is an integer

If I do this through visual studio 2005 it works just fine.
However I need to change this for a linked report and when I do the same thing in the viewer (using the "Overide Default" key) I get the following error
"The parameter Month contains a value that is not valid. This parameter takes an integer as a value"
Can anyone suggest a way to get arround this ?

View 2 Replies View Related

SQL Server Admin 2014 :: Setting Up AG On Default And Named Instance

Aug 26, 2014

Plan to setup AG on in both default and named instance of two nodes. Can we do it ?

View 9 Replies View Related

URGENT: Windows X64, SQL 2005, ODBC - Setting Default Provider For A System DSN

Jan 6, 2006

In Windows Server 2003 SP1 (x86) with Sql Server 2000 I could use the following connectionstring no problem
DSN=Hello;

Now I am using Windows Server 2003 x64 and SQL 2005 and I get this error:
Provider is not specified and there is no designated default provider.

If i try Provider=MSDASQL;DSN=Hello; i get
Provider cannot be found. It may not be properly installed.

for DSNless this works fine:
Provider=sqloledb;driver={sql server};server=(local);database=Hello;uid=sa;pwd=p wd;

but i am forced to use DSN as it is in a closed source application which uses set DSNs (the idea there being that you can change the connections how you like in ODBC)

This means that i need the ODBC provider name that will work in here: Provider=...;DSN=Hello;

and then to use whatever works in there as the "default provider" but i cannot find any information anywhere on how to do this!

please reply ASAP!

View 7 Replies View Related

Change Default Zoom Setting For Reports Viewed On Report Manager Web Site

Sep 14, 2007

I've tried changing the default zoom setting by editing the RSReportServer.config file to include

<Configuration>

<DeviceInfo>

<Zoom>Page Width</Zoom>
</DeviceInfo>
</Configuration>
under the

<Render>

<Extension Name = "HTML4.0" etc.
However, all reports still show up with the zoom setting at 100% on the toolbar.
I stop and restart the Report Server Service and it comes up OK so I know my XML syntax is cool. What am I doing wrong?

This is on a 2005 Report Server. Reports are built in VS2005 Report Designer and deployed to the Report Server directly. Reports are accessed via IE7 browser.

View 2 Replies View Related

Reporting Services :: SSRS 2012 - MultiValue Parameter Throws Error On Setting Up Default Value

Aug 3, 2015

I have a multi value  parameter called "Location" and this depends on another multi valued  parameter value. The default value for the parameter "Location" comes from the another another multi valued  parameter. Now say when the default value is set for the parameter Location like the below:

The Location parameter data set has values from the Query and default values has been set as shown below:

=Iif(array.IndexOf(Parameters!Program.Value,"A")>-1,nothing,"N/A")

I get an error on preview saying that . The Default Expression for the report parameter "Location" contains error:

Unable to cast object of type 'System.String' to type 'System.Array'.

View 2 Replies View Related

Losing It Again - How To Pass Value To Sp?

Mar 15, 2007

I cannot remember how to pass a value to a stored procedure.  I would work this through but I am really running out of time, any help greatly appreciated.  This is my stored procedure and I need to pass CompanyID from the code behind page in for the stored procedure @C_ID value.
PROCEDURE dbo.EditCompanyInfo  @C_ID int, @CS_CompanyName nchar(100), @CS_City nchar(50) AS UPDATE tblCompanyInfo_Submit SET CS_CompanyName = @CS_CompanyName, CS_City = @CS_City  WHERE C_ID = @C_ID RETURN
This is my aspx. page:
 <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server" >    <asp:TextBox ID="TextBox1" runat="server"> </asp:TextBox>    <br />    <asp:TextBox ID="TextBox2" runat="server"> </asp:TextBox>&nbsp;<br />    <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br />    <asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="SqlDataSource2" Height="50px"        Width="125px">        <Fields>            <asp:CommandField ShowEditButton="True" ShowInsertButton="True" />        </Fields>    </asp:DetailsView>    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"        InsertCommand="CompanyInfoSubmit" InsertCommandType="StoredProcedure"  OnInserted="SqlDataSource2_Inserted"        SelectCommand="SELECT CS_CompanyName, CS_City FROM tblCompanyInfo_Submit WHERE C_ID = @CompanyID "        UpdateCommand="EditCompanyInfo" UpdateCommandType="StoredProcedure">        <UpdateParameters>            <asp:Parameter Name="CS_CompanyName" Type="String" />            <asp:Parameter Name="CS_City" Type="String" />        </UpdateParameters>        <InsertParameters>            <asp:Parameter Direction="ReturnValue" Name="ReturnValue" Type="Int32" />            <asp:Parameter Name="CS_CompanyName" Type="String" />            <asp:Parameter Name="CS_City" Type="String" />        </InsertParameters>    </asp:SqlDataSource>    <br /></asp:Content>
CODE BEHIND:
public partial class aaatest : System.Web.UI.Page{    int CompanyID;     protected void Page_Load(object sender, EventArgs e)    {        if (!Page.IsPostBack)        {            DetailsView1.ChangeMode(DetailsViewMode.Insert);            TextBox1.Text = "insert";            TextBox3.Text = Convert.ToString(CompanyID);        }    }    protected void SqlDataSource2_Inserted(object sender, SqlDataSourceStatusEventArgs e)    {        {            foreach (System.Data.SqlClient.SqlParameter param in e.Command.Parameters)            {                string RValue = Server.HtmlEncode(param.Direction.ToString());                if ( RValue == "ReturnValue" && Page.IsPostBack)                {                    TextBox1.Text = Server.HtmlEncode(param.Value.ToString());                    TextBox2.Text = "Return";                    CompanyID = Convert.ToInt16(TextBox1.Text);                    TextBox3.Text = Convert.ToString(CompanyID);                }            }        }    }}
 
 
 

View 1 Replies View Related

Losing AM/PM From Query

Apr 1, 2008

I have a stored procedure and one of the fields in the SELECT is a datetime type. On SELECT I am getting the date and the time but no AM/PM returned. The datetime in the query is returned in this format:
2008-03-21 08:37:20.000
 Any help is appreciated.

View 3 Replies View Related

SQL Losing Data

Jul 23, 2005

We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBClinked tables. I recently created a new set of tables for the app, and usersare complaining that unsaved data is being lost when they move to a newrecord. This seems to be the case when there are multiple users. When thereis a single user using it, we don't seem to have that problem.It seems that we had this problem when we first converted from an MDB backend to a SQL 7 back end, years ago, but we haven't had this problem in awhile. These are the first "entirely new" tables created in several years,and we seem to be having that problem again.Is this something with SQL 7 when it's dealing with new tables? Any ideas onwhat to do?Thanks!Neil

View 32 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved