I retrieve a null value from a nullable sql datacolumn but when I pull it into a property it automatically gets the current datetime.
How will I go about making sure that this value returns a null and not the currentdatetime.
I have a DateTime field on a database it looks like this :
2014-10-21 14:34:37.697
I want to use it, as is, in an UPDATE statement something like:
UPDATE PayrollRuns SET IsProcessed = 'True' WHERE Date_Time_Triggered = '2014-10-21 14:34:37.697'
I must have the exact date & time as that uniquely identifies the record.
The problem I'm having is getting it off the database and into an C# variable without it being changed.
I can get it into a string but it changes it becomes:
21/10/2014 14:34:37
I've got it in an object. I've tried:
string date_Time_Triggered = databasesRow["Date_Time_Triggered"].ToString();
//
//and
//
var date_Time_Triggered = databasesRow["Date_Time_Triggered"];
[Code] ....
I am getting this error whenever I leave my drop down lists blank: "String was not recognized as a valid DateTime". My code is below:
aspx:
asp:DropDownList ID="cboDay" runat="server" Width="55px" Height="32px" AppendDataBoundItems="true">
<asp:ListItem></asp:ListItem></asp:DropDownList >
<asp:DropDownList ID="cboMonth" runat="server" Width="80px" Height="30px" AppendDataBoundItems="true">
[Code]....
I have an application in C sharp that searches for a record in a sql database using a datetimepicker,the output is displayed in a datagridview.When I execute it I got a blank datagridview with empty columns.I can not view the content and I don't get any error message.
Here is my code:
DataTable dt=new dataTable();
SqlDataAdapter sda=new sqldataadapter("select * from Delivery where convert
(char(20),Delivery_Date,112)='"+ dateTimePicker1.value.Date,con);
//con is sqlconnection
Sda.Fill(dt);
Datagridview1.DataSource=dt;
How do I convert date in integer format to DateTime without using DateTime?
I have tried:
Regex regex = new Regex(@"^(0[1-9]|1[012])(0[0-9]|1[0-9]|2[0-9]|3[01])(1[789]|[2-9][0-9])dd+$");
if (regex.IsMatch(txt_fromdate.Text) == true)
{
DateTime dt = DateTime.ParseExact(txt_fromdate.Text, "MMddyyyy", null);
}
When I am filling a Application form and save this Application form Entries in database it saved successfully but below Application form in DataGridView How to show only current Entry row; There is not show a previous Entries in DataGridView?
View 1 Replies View Relatederror is giving.
int ages = 0;
ages = int.Parse(textBox2.Text);
if(textBox2.Text == "")
{
MessageBox.Show("Age Blank ......");
}
else if (ages >= 5 || ages <= 9)
{
MessageBox.Show("age must be 5 to 9 only");
}
I would like to fill a combobox with particular field for example if i have atable with fields such as CustID, CustName, CustAge.
I would like to only fill the combobox with the Name filed such that only the CustNames will be field in the combobox and am able to write an event handler for the selected index.
I have a variable named Authors. Sometimes I will insert one author into the database, sometimes more than one author will be inserted into the database.
The page that performs the update is a .cs page. Here is the layout:
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
[Code]....
This definitely works for updating one author's name:
if (old.Author != Author) RequestItem.UpdateField(LibraryDocID, Editor, "Author", Author);
I just can not nail down how to insert a string of author's names.
I have tried to use File.Copy and File.Move but non of them would work as I expected .....
View 1 Replies View RelatedSo I have this class
class DataBase
{
// Change the connection path here to your own version of the database
public SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)v11.0;AttachDbFilename=|DataDirectory|UberDatabase.mdf;Integrated Security=True;");
public DataBase()
{
}
}
And in the same namespace as this class I have a form that calls it like so:
DataBase dBase = new DataBase();
SqlCommand trythis = new SqlCommand("Register", dBase.con);
However, I'm getting the field initializer error on dBase.con. I'm not sure why, but when I call the database from another file (program.cs) it works fine this way.
I'd like to get a a field name "eventDateTime" from a DB table and its storage is datetime year to fraction (3) . I have created a function return results like this but i put its type as a int:
int Status::GetEventFromSQL(){
int j = 0;
int eventTime = 0;
MYSQL_ROW myROW;
MYSQL_RES *myRES = NULL;
[code]....
"eventTime " is also declared in another sheet .h as an int. In execution i have a big and negative number ; I know that's because of the int type but i'm bigenner in C++...
i have saved my data in sql and i can retrieve them except datetime i can't retrieve ,, this is my code
SqlCommand cmd1 = new SqlCommand("select ID,name,carplatnumber,cartype,expiredate,badgtype from [ID-personal] where id like('" + textBox1.Text + "%')", cn);
SqlDataReader dr1;
[Code].....
I currently have a DatePicker in my xaml forum. In my constructor and class I have my dates as a DateTime object. I am currently trying to get my datepicker date to be passed into my constructor or maybe I have to convert the datepicker to a datetime object?
private void btnSave_Click(object sender, RoutedEventArgs e)
{
DateTime xxx = new DateTime();
xxx = Convert.ToDateTime(dateCurrent.SelectedDate);
//validate registration form
lifter = new User(txtFirstName.Text, txtLastName.Text, txtStartWeight.Text, genderStatus, xxx);
I am trying to insert values from a form into my SQL database. Two of the fields in the SQL database are of type DateTime.
When trying to insert I am receiving the error "Conversion failed when converting date and/or time from character string."
The relevant code is as follows:
DateTime saveNow = DateTime.Now;
string sqlFormattedDate = saveNow.ToString("yyyy-MM-dd HH:mm:ss");
conn.Open();
[Code] ....
The table layout:
I am converting unix timestamp to datetime format like this:
static readonly DateTime UnixEpoch = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
static readonly double MaxUnixSeconds = (DateTime.MaxValue - UnixEpoch).TotalSeconds;
public static DateTime UnixTimeStampToDateTime(double unixTimeStamp) {
return unixTimeStamp > MaxUnixSeconds
? UnixEpoch.AddMilliseconds(unixTimeStamp)
: UnixEpoch.AddSeconds(unixTimeStamp);
}
use it:
Console.WriteLine("From UNIX do datetime 1300123800440 : " + UnixTimeStampToDateTime(1300123800440));
output: 14.03.2011 5:30 PM
Now i would like to have function which convert it back to unix timestamp but unfortuently my new function is cutting down last 3 digits for instance:
public static long UnixTimestampFromDateTime(DateTime date) {
long unixTimestamp = date.Ticks - new DateTime(1970, 1, 1).Ticks;
unixTimestamp /= TimeSpan.TicksPerSecond;
return unixTimestamp;
}
after use of it i am retrieving:
Console.WriteLine(UnixTimestampFromDateTime(Convert.ToDateTime("14.03.2011 5:30 PM")));
result:
1300123800
i have a form in which i have a field date of birth , and a textbox to fill date of birth , when a person fills his date of birth like 01/01/1990 , then it will be saved into database , and when i retrieve this date form database then this comes 01/01/1990 12:00 AM , i want only date part from it.
This is my form to fillup date of birth
form.aspx
<tr>
<td width="30%">
Date of Birth
<br />
</td> <td style="width: 1px">
:<asp:TextBox ID="txtDateofBirth" runat="server" placeholder="dd/mm/yyyy"></asp:TextBox>
</td> <td class="td2">
</td>
</tr>
this is code for form.aspx.cs
SqlCommand cmd = new SqlCommand("insert into ApplicantForm(NameofApplicant, dateofbirth)" +
"values( @NameofApplicant, convert(Datetime, @dateofBirth, 103)", con);
cmd.Parameters.AddWithValue("@dateofBirth",txtDateofBirth.Text);
this is code for print of this date of birth
print.aspx
<asp:Label ID="txtDOB" runat="server" ></asp:Label>
this is code print.aspx.cs
SqlCommand cmd = new SqlCommand("Select * from ApplicantForm Where ApplicantId=" + ((Request.QueryString["ApplicantId"])) + "", con);
dr = cmd.ExecuteReader();
txtDOB.Text = dr["dob"].ToString();
I'm new in C and I want to know how to get the current weekday where sunday=0, monday=1,...,.(using time.h if possible)/I want to do something like
Code:
#include<stdio.h>
#include<time.h>
int main(void)
{
[Code]....
I have a file which has records with 2 fields--one int and one float..what is the best way to sort it?
The sorting has to be based on the int field(the first field) (each time the program runs the file might end up with some hundreds of records).
I'm trying to write a simple program that extract the FAT information from a FAT32 virtual Hard Disk.I have the following structures regarding the FAT format:
Code:
//BOOT RECORD
typedef struct NF_BOOT_RECORD
{
unsigned char BS_jumpBoot[3]; //EB 58 90 = JUMP 58 NOP (Jumps to boot code). Also E9 is acceptable.
unsigned char BS_OEMName[8]; //Either MSWIN4.1 or mkdosfs
unsigned short BS_BytesPerSec; //Little endian. The size of a sector. 128,256,512,1024...
unsigned char BS_SecPerClus; //The number of sectors per cluster (1 CLUSTER = BPS*SPC BYTES)
unsigned short BS_RsvdSecCnt; //The boot sectors (this) are included. That makes at least 1.
}
[code]...
Everything seems to work fine. Mostly. The only problem, is that the program gives me the following output:BS_NumFATs shouldn't be 0. In fact, I've checked inside the structure memory, and the information seems correct. BS_NumFATs is 0x02, not 0x00 (It's the byte at offset 0x10, starting at 0x00).
I've checked the order of the structure fields, and their types, comparing them to the FAT specification given by Microsoft (File fatgen103.pdf), and it seems fine, unless I'm missing something. So I don't know why it gives 0 instead of 2, if I'm missing something.It's a Win32 program compiled with GCC version 4.4.0
I wrote a script that generates n random pixel positions and draws them to the screen. Works well. Now i tried to rotate them. Rotating does work too. But it does not work as i planned it.
paramters 'angle' and 'timestep' work somehow, but not as they should do. the function 'move' is supposed to rotate the pixelfield 'angle' degrees in a given direction, addicted to the 'timestep' parameter. 'timestep' is needed time for drawing in one single game loop.
angle_step = timestep * angle
// x
ppdPoint[i]->x =
pRotationPoint->x + cos(angel_step) * (ppdPoint[i]->x - pRotationPoint->x) - sin(angel_step) * (ppdPoint[i]->y - pRotationPoint->y);
// y
ppdPoint[i]->y =
pRotationPoint->y + sin(angel_step) * (ppdPoint[i]->x - pRotationPoint->x) + cos(angel_step) * (ppdPoint[i]->y - pRotationPoint->y);
rotation point is the middle of the screen. when i set angle to 10 it should rotate 10 degrees / second. Instead it's rotating very very fast and all stars are moving nearer to the center of the screen, so after x rounds there is just 1 pixel left in the middle of the screen. there is a kind of gravition.I'm working with SDL2. What I did find out:
FPS is <= 60, 'cause of the 'SDL_RENDERER_PRESENTVSYNC' flag. When i skip that flag, for any reason the 'gravition' would take more time. FPS is <= 1400 then, 'though i got a natural game loop (i hope):
while(pBuild->getExecuteFlag())
{
pBuild->draw();
pBuild->update(time_dif, pTimeWindow->TimeStampB);
time_dif = (pTimeWindow->TimeStampB - pTimeWindow->TimeStampA);
time_dif *= 0.001;
pTimeWindow->TimeStampA = pTimeWindow->TimeStampB;
pTimeWindow->TimeStampB = SDL_GetTicks();
pBuild->count_fps(pTimeWindow->TimeStampB);
}
So maybe (timestep * angle) isn't the right way?
I need writing a program in c++ that will get the input of 50 different users for the following the fields (surname, other names, sex, status, date of birth) and after entering the data for these 50 users, it will then output only the list of all FEMALE users who were registered...
#include <iostream>
#include <string>
using namespace std;
int main () {
string surname, other_names1, other_names2, status, sex, dob;
[Code] ....
I don't really know what to do next - all my attempts have not really given me the result I want.
class myCls{
int x;
};
and then I create:
myCls c1;
and now:
is there way that I go like: cout << c1;
not overloading << operator;
and it shows me a value of c1.x?
just wanna replace c1 with that value;
I need sth similar to indexer from c#.
I need exchange strings in field, but how to do that. For example:
{"Hi", "Hello", "Goodbye", "Morning"};
to
{"Hello", "Hi", "Goodbye", "Morning"};
I tried this, but it isn't working:
Code:
for(unsigned int k=0; k<slova[i].size();k++){
t = slova[i][k];
slova[i][k] = slova[i+1][k];
slova[i+1][k] = t;
}
I am new to GUI programming, I am using mono winforms
using System.Windows.Forms;
using System.Drawing;
using System.IO;
[Code]...
I tried sw.WriteLine(this.to.Text); but that did not work
I have a dynamic storage class based on a vector. The elements of this class shall be addressable via a string.
I have something like the following:
StorageClass* test = new StorageClass();
while(notEnd) {
test->setValue("name3", 3);
test->setValue("name2", 4);
[Code] ....
The Storage class is implement with a vector having to attributes per entry, the first one is name the second one is value. If the setValue function is called, Igo through the whole vector to find the correct item via the name and than i set the new value.
At the end of the loop i want to write out the data into a comma separated value file (*.csv). This shall be done generic by the writeLineToFile() function of the StorageClass.
As a want the columns in csv file to be sorted in a specific way a thought about a preInitalisation routine at the beginning of the program which builds a the vector with all possible entries as something like this in order to define a specific output order.
test->assign("name1");
test->assign("name2");
test->assign("name3");
So my outputfile should look like this:
name1;name2;name3;
5;4;3;
I now have 2 places in the code where i write down the "fieldnames".
I was wondering if there is a possibility to check if the fields called by the setValue function were first aranged in the vector by the assigned() function before or bettwer while compiling the programm.
I thought about MAKROS with #define XYZ and #ifndef XYZ #error to do though, but currently i reached a dead end and find no solution for my problem.