datetime problem - Database Discussion Boards

Re: Paramaterized Queries vs. Stored Procedures

originSH29-Jun-07 0:11

originSH

29-Jun-07 0:11

This subject is hotly debated and is often the cause of religious wars! Well on the web anyway Wink | ;)

http://www.google.co.uk/search?hl=en&q=stored+procs+vs+dynamic+queries&meta=[^]

Personally I like Stored Procs, they appeal to my OO side with their encapsulation of data access sql code in the database. Another advantage is not having to update your application to change a query. But as others have said dynamic sql definatly has its place and shouldn't be completely dismissed.

Re: Paramaterized Queries vs. Stored Procedures

martin_hughes29-Jun-07 1:32

martin_hughes

29-Jun-07 1:32

originSH wrote:
This subject is hotly debated and is often the cause of religious wars! Well on the web anyway

That's why I thought I'd ask you guys - everytime I searched Google the whole debate turned into a semi-religious debacle!

View more than one page with CrystalReportViewer vb.net

kindman_nb28-Jun-07 5:09

kindman_nb

28-Jun-07 5:09

Hi ...
I use CrystalReport with vb.net 2005 ,
Can I view more than one page on CrystalreportViewer at the same time .. and also can I user Mouse scroll for navigatoin...
thanks Rose | [Rose]

jooooo

Alternative of CONVERT function in MS Access

FishiFishi28-Jun-07 3:12

FishiFishi

28-Jun-07 3:12

Hi All,
Any can help me out by telling what is the alternative of " Convert(Varchar(10), Date, 101) As MY_DATE " this in MS Access. this function is actually used in query to get short date. How can i get this type of short date in MS ACCESS

Re: Alternative of CONVERT function in MS Access

leckey28-Jun-07 4:20

leckey

28-Jun-07 4:20

If you open up a blank query and go to the functions under date/time there is a formatdatetime function. I believe 2 is the option for the short date.

______________________
stuff + cats = awesome

datetime code

niki_nilu28-Jun-07 1:56

niki_nilu

28-Jun-07 1:56

hello
In webform i have 4 date picker.
which are 1. Create date (that is todays date)
2. expirydate (i.e display automatically i write code todays date + 28 days)
3. warning date (i.e also automatically display. expiredate + 2 days)
4.updateDate(which we will select)
all code is correct
but when program run that time runtime error ocurrs.
i.e
The conversion of a char data type to a datetime data type resulted
in an out-of-range datetime value. The statement has been terminated.

In table i am taking datetime datatype.
pls give me a quick solution for this problem.

my code is ----
DateTime intWarningDate = DateTime.Now.Date.AddDays(28);
dtpWarningDate.SelectedDate = intWarningDate.Date;
DateTime intExpiryDate =dtpWarningDate.SelectedDate;
DateTime date1 = intExpiryDate.AddDays(2);
dtpExpireDate.SelectedDate = date1.Date;

Gayatri

Gayatri

Re: datetime code

Sathesh Sakthivel28-Jun-07 2:22

Sathesh Sakthivel

28-Jun-07 2:22

Don't CrossPost in Multiple Forums also.

Why are you Creating the New Thread for the Same Problem.

Please Continue in the Same thread Itself.

Regards,

Satips. Rose | [Rose]

datetime problem

niki_nilu28-Jun-07 0:54

niki_nilu

28-Jun-07 0:54

Re: datetime problem

Krish - KP28-Jun-07 1:30

Krish - KP

28-Jun-07 1:30

date format of date picket depends on regional settings of control panel.

use convert() function while inserting into table.

Regards
KP

Re: datetime problem

FishiFishi28-Jun-07 3:16

FishiFishi

28-Jun-07 3:16

convert cannot be used with MS Access.

Re: datetime problem

Pratik Vasant Shah28-Jun-07 20:19

Pratik Vasant Shah

28-Jun-07 20:19

Hi,

can u help me the datatypes of the dates in the table. Probably, I think the datatype is datetime (dd/mm/yyyy or so on) whereas the date value being passed could be either dd/mmm/yyyy or any character is included in that date

Thanking you in Advance

Kind Regards
Pratik Shah

how to pass null values to a query in the design time

pashitech28-Jun-07 0:12

pashitech

28-Jun-07 0:12

hi all,
i am retrieving values from 5 tables, for that i've written joins and tried to retrieve,
but here my problem is Even if one value is null the query is not working and returning 0 rows.
so i want to approch in such a way that if anywhere if any value is null, the query should return a null value
and ultimatly query should work with the fields that have values
Please help me
thnks in advance

Re: how to pass null values to a query in the design time

Xandip28-Jun-07 20:13

Xandip

28-Jun-07 20:13

Can u please show your query?

The name is Sandeep

Date Time String Transformation sample mssql

cutequencher27-Jun-07 23:18

cutequencher

27-Jun-07 23:18

here's my query

select t.date_value, start_time,end_time,upper(r.last_name)+', '+r.first_name teacher_name,
datediff(hh,t.start_time,t.end_time)*t.rate total_rate,t.remarks
FROM dbo.ttcpCustomizedSchedule t left outer join dbo.ResourcePersons r
on r.teacher_id=t.teacher_id where t.tload_id = 5724 order by date_value

i want to make the start_time and endtime using a string format of:
"hh:mm tt"

please help me...

i am using mssql server 2000

Re: Date Time String Transformation sample mssql

andyharman28-Jun-07 0:18

andyharman

28-Jun-07 0:18

Try: Substring(convert(varchar, StartTime, 100), 13, 8)

Re: Date Time String Transformation sample mssql

cutequencher28-Jun-07 0:39

cutequencher

28-Jun-07 0:39

thnx!

sql data adapter.update

Sebastian T Xavier27-Jun-07 22:42

Sebastian T Xavier

27-Jun-07 22:42

Hi,

I would like to know how i can perform update or delete by using Update method of sql data adapter. I have done the insert operation using update method. The code follows...

<br />
public Boolean SetStorageArea(int UID, DataTable dtStorageArea)<br />
        {<br />
            string strSql;<br />
            strSql = "SELECT [Active],[WarehouseID],[StorageAreaID],[StorageAreaShortName],[StorageAreaName], " +<br />
                     " [Alias],[Notes],[CreatedBy],[CreatedOn],[LastModifiedBy],[LastModifiedOn] FROM [StorageArea]";<br />
            try<br />
            {<br />
                DataSet dsStorageArea = new DataSet();<br />
                dsStorageArea.Tables.Add(dtStorageArea);<br />
                SqlDataAdapter sda = new SqlDataAdapter(strSql, sqlcon);<br />
                SqlCommandBuilder sqb = new SqlCommandBuilder(sda);<br />
                sda.Update(dsStorageArea, "StorageArea");<br />
                return true;<br />
<br />
            }<br />
            catch (Exception Ex)<br />
            {<br />
<br />
                throw new Exception("SetStorageArea: Could not get the records of all Storage Areas.\nOriginal message: " + Ex.Message);<br />
            }<br />
                    }<br />

.

awaiting for your valuable suggestions..

Thanks in advance

Sebastian

Re: sql data adapter.update

Vimalsoft(Pty) Ltd28-Jun-07 22:35

Vimalsoft(Pty) Ltd

28-Jun-07 22:35

See this , i did this in vb.net

'save the datasource Changes
If mblnIsDirty Then
If MessageBox.Show("Do you want to Save the Changes?", "Property", _
MessageBoxButtons.YesNo, MessageBoxIcon.Question) = DialogResult.Yes Then
' Checking for Error in the dataset
Try
SqlDataAdapter1.Update(DataSet11, "Property")
Catch
MessageBox.Show("Error saving Data in the DataBase", "Property")
checkerrors()
End Try
End If
End If

<br />
<br />
The Check Errors will tell you where did you go wrong<br />
here is code for checkErrors<br />
<code><br />
    Private Sub checkerrors()<br />
<br />
        Dim table As Data.DataTable<br />
        Dim row As Data.DataRow<br />
        SqlDataAdapter1.Update(DataSet11, "Property")<br />
        If DataSet11.HasErrors Then<br />
<br />
            For Each table In DataSet11.Tables<br />
                If table.HasErrors Then<br />
<br />
                    For Each row In table.Rows<br />
                        If row.HasErrors Then<br />
                            MessageBox.Show("Dataset has Errors")<br />
                            ' Process error here.<br />
<br />
                        End If<br />
                    Next<br />
                ElseIf table.HasErrors = False Then<br />
                    MessageBox.Show("Dataset has no Errors")<br />
                End If<br />
            Next<br />
        End If<br />
    End Sub<br />
<br />

And this is the insert

<br />
 'save the New Record for an Add or Edit<br />
        If mblnAdding Then<br />
            Try<br />
                Dim newRow As DataRow = DataSet11._PROPERTY.NewRow<br />
                newRow("Num_key") = CStr(txtnumkey.Text)<br />
                newRow("Extension") = CInt(txtextension.Text)<br />
                newRow("Cell_ID") = CInt(txtcellid.Text)<br />
                newRow("ACTUAL_EXTENT") = CInt(txtactualextent1.Text)<br />
                newRow("Lis_key") = CStr(txtliskey.Text)<br />
                newRow("Func_key") = CStr(txtfunckey.Text)<br />
                newRow("PROP_CATEGORY_ID") = CInt(Prop_Category_ID)<br />
                newRow("Geocode") = CStr(txtgeocode.Text)<br />
                newRow("Rateable") = Rateable<br />
                newRow("Non_Discreet_Valid") = Non_Discreet_Valid<br />
                DataSet11._PROPERTY.Rows.Add(newRow)<br />
                Catch exc As Exception<br />
                MessageBox.Show("Unable to add the Record." & _<br />
                ControlChars.NewLine & exc.Message, "Property")<br />
<br />
            End Try<br />
            mblnAdding = False<br />
            lblRecordNumber.Text = "Record Added at the end of the Table"<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

Hope this Helps

Vuyiswa

MySQL - C# - problem with charset encoding

yarns27-Jun-07 22:26

yarns

27-Jun-07 22:26

Hi,

have table configured like this:

CREATE TABLE `tblDane` (
`ID_DANE` bigint(20) NOT NULL,
`BAZA` varchar(50) default NULL,
`ID_ORG` varchar(50) default NULL,
`NAZWISKO` varchar(100) default NULL,
`TELEFON` varchar(50) default NULL
PRIMARY KEY (`ID_DANE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

my connections string looks like: "Server=192.168.1.18;Database=testtable;Uid=test;Pwd=test;charset=latin2;"

When retrive some data from table everything is ok - mean got polish chars like śćńł, but after update got only '??????' not a polish one

Any idea what can be wrong?

Greetings

Re: MySQL - C# - problem with charset encoding

Giorgi Dalakishvili27-Jun-07 22:45

Giorgi Dalakishvili

27-Jun-07 22:45

Try this:

"Server=192.168.1.18;Database=testtable;Uid=testwd=test;charset=utf8;"

and read this: http://dev.mysql.com/doc/refman/5.1/en/faqs-cjk.html[^]

#region signature
my articles
#endregion

Re: MySQL - C# - problem with charset encoding

yarns27-Jun-07 22:51

yarns

27-Jun-07 22:51

Wow,

thank you Smile | :)

its works... but ther is a little trick...I had to delete and create new table - when just changed encoding to old one its not work - any ide why?

Greetings

Re: MySQL - C# - problem with charset encoding

Giorgi Dalakishvili27-Jun-07 22:53

Giorgi Dalakishvili

27-Jun-07 22:53

Where did you change encoding to old one? In the mysql table or the connection string? In connection string it must be utf8 otherwise you will have ??? there

#region signature
my articles
#endregion

Re: MySQL - C# - problem with charset encoding

yarns27-Jun-07 23:19

yarns

27-Jun-07 23:19

Changed charset in connection string and in table and column options. Its funny cause until i do not drop table and create new one its not work Smile | :)

Re: MySQL - C# - problem with charset encoding

Giorgi Dalakishvili27-Jun-07 23:24

Giorgi Dalakishvili

27-Jun-07 23:24

In order to display unicode chars and manage them you need to have
1.a table in mysql database which can store unicode chars.
2.connection string which supports unicode so that you retrieve and/or insert unicode chars in the database

#region signature
my articles
#endregion

Saving Sybase Data to Excel

meeram39527-Jun-07 20:26

meeram395

27-Jun-07 20:26

Hi,

I have some bulk data on Sybase. Is there anyway that I can export the data to Excel? If anybody knows, please help me.

Thanks

Meeram395

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.