I have written this query for retrieving data from mysql as below
select FeedbackCode,EMailID,FeedbackDetail,
Date_Format(FeedbackDate,'%m,%d') as 'Feedback_Date'
from FeedbackDetail
where EMailID not like '' and InstanceCode =5
and I'm binding this data with GridView in asp.net but at the column of Feedback_Date,
instead of Date I receive System.Byte[].
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
I am trying to upload a picture into database using FormView insertItemTemplate. FormView is bounded by objectdatasource.To upload, I placed FileUpload control inside insertItemTemplate.In table the dataType is image.Error:Object of type 'System.Boolean' cannot be converted to type 'System.Byte[]'.
View 3 RepliesUnable to cast object of type 'System.String' to type 'System.Byte[]'....
on line #2
private void download(DataTable dt) { Byte[] bytes = (Byte[])dt.Rows[0]["FileData"];
Response.Buffer = true; Response.Charset = "";
I am trying to pull string values from LDAP. They are all text attributes in LDAP. I'm able to pull all values successfully from LDAP except one attribute below. following line of code displays System.Byte[] instead of actual string value. Why is it showing System.Byte[] and how can I fix it?
txtAccount.Text = loResultPropertyCollection[
"Account"][0].ToString().ToLower();
[Code]....
[Code]....
I am trying to get the following code behind to store a file in a datbase using Linq (with *dbml). I am getting an intellisense error in my "For each" loop the says the following":Value of 'Byte' cannot be converted to 'System.Data.Linq.Binary'I have been searching for awhile, but I can't seem to find a solution that has worked for me yet.
[Code]....
I am develping an application that integrates with an RFID kit. The problem is, the kit comes with an .cs class that accepts data stored in a byte array however, each information stored in the array respresents an int. I wanted to store String information in each array but, my research suggest that a String itself can be converted to a byte array and not a byte....here the code from the .cs class:
byte BlockNo = 0;
byte[] BlockData = new byte[16];
byte ReturnCode = 0;
[code]....
Each t_b*.text respresents an int. Is there a way I can stored a String in a single byte block?
I am using ASP.NET C# with mySql database. What is the best way for implementation of login system like Membership and Role. Membership and Role dont work with mySql database.
View 1 RepliesI am trying to use the MySQL replace function in C# but the resulting data ignores the columns inside the REPLACE function - i guess its because C# has its own Replace function
get the required column either through Mysql escape sequence or in the C# syntax
MySqlConnection mySqlConnection1 = new MySqlConnection("server=localhost; database=faohr; pooling=false; allow zero datetime=yes;");
ArrayList lstEndPoints
0 element "0x01"
1 element "0x82"
byte b = (byte)(lstEndPoints[0]); //Error cannot convert
I got a variable of type System.Drawing.Image and need to convert it to a variable of type byte so I can store the image in the database. Can someone show me how to do that in VB.NET code.
View 2 RepliesI am getting the "Unable to convert MySQL date/time value to System.DateTime" error because from what I can tell I have a record with 0000-00-00 00:00:00. Now while the data should never be that (it should be null) there are cases when this might happen and I don't want my entire application to crash because of it. I am using NHibernate and I tried adding change my connection string to allow zero datetime so the connection string configuration looks like:
<property name="connection.connection_string">
Server=localhost;Database=user_system;User ID=root;Password=root;
Allow Zero Datetime=true;
</property>
However I still receive that error. How can I allow NHibernate to allow zero values for timestamp/datetime/data/time?
Not sure if this is the correct section to ask this but this is regarding storing datatype problem.im trying to convert an image file retrieve from a folder and convert it to Byte so that i can save into database
In below function i retrieve and convert the image from a folder to byte
[Code]....
Then i set ImageUrl in PageLoad
[Code]....
My image datatype in database is image
using ASP .NET and I'm retrieving data from a MySQL S2005.
I'm using several Jquery Datepickers and I set the dateformat to: "yy/mm/dd".
However, when the datepicker's input field is filled with a date stored in the DB, it
uses different formats, depending on the language of the system.How can I specify a default format? Should I specify this on the DB or directly on the app?
i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 RepliesI have a range validator to validate a textbox for birthday. i must ensure that a student must be above 21 to register with us. i set "31/12/1993" format (dd/mm/yy).
but it cannot run the website as in my database is set to this (mm/dd/yy) format. how can i solve this without changing my database format? so that it can function for everyone.
like to get DateFormat "28/07/09 10:29" - "dd/mm/yy hh:mm". My query is below
[Code]....
Which style is fixed this format? Here, time will be shown in 24 hours format.
we recently upgraded an application (.NET 2.0) that we maintain to use Oracle 11g. The application uses MS Enterprise Library 2.0. We've found that when the database.ExecuteNonQuery(Oracle.DataAccess.Client.OracleCommand) method is called, it bombs when the stored procedure expects a parameter as a number, but receives a string. This didn't happen prior to upgrading. If I cast the parameter to an Int, I don't recieve the error. Was something possible missed during the upgrade? The issue occurs regardless if we are hitting an 11g database, or a 10g database.
EDIT: I neglected to mention that this same issue does not occur when ExecuteDataReader is called (handles implicit conversion of the datatype).
How do I set my insert identity return value parameter in codebehind? I have working code now but i have all of my parameters set in codebehindexcept the following:
[Code]....
how to format this label.text date as dd/MM/yyyy
Label1.Text = "" + drReaderi["date"].ToString() + "";
I have been struggling with this for a long time. I have a form in which there is a textbox using an ajax calender extender. Now, the problem is that, I want to take the Date value which is string format and format it to a specific date format before inserting it into the database. The following is the core problem:Dim MDate as string=txtMeetingDate.Textdim d as new Datetime ' I want to convert the d to a datetime using the Mdate/// The problem is that I don't know what's the date format in the TextBox because users can use any time format they want, it is based on their windows settings!!!
So, I am struggling to change my String (MDate) into a DateTime in the same format the user have and then convert it into my format:"dd/MM/yyyy" and after I have the date in the correct format, I want to change it back to string and save it in the database.I am doing this so that I have the same dateformat saved in my database.
1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3 varchar(40);
2)if record in data database such that
hobby1 hobby2 hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2 hobby3
1 cricket null null
2 null hockey null
3 null null tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
I want to use the System.DateTime.Now() function (to get system time) rather than the Date() function (for user's time) in a Javascript routine of an ASP.net web page, however this does not seem to be supported in Javascript (as it is in VB.net).
View 11 RepliesI trying to display image in picture box. The application have two part.First part is windows application, and second part is web service (asmx).This is the code for windows application:
Public Sub PrikazSlike()
Dim p As localhost.Service1 = New localhost.Service1()
PictureBox1.Image = Image.FromStream(p.PictureShow()) [code]....
The problem is that function in web service does not return System.IO.MemoryStream data type so I getting error message can not convert:
Error 1 Value of type 'WindowsApplication1.localhost.MemoryStream' cannot be converted to 'System.IO.Stream'.