Comments by snake1 (Top 51 by date)

are there any solutions ?

i think this issue is not because of using webclient,threads it's happening even if i use ftpwebrequest and also it happens while using download tools

the file is not corrupted but i don't know if the server disconnects due to delay , the first 2 files are 2MB and the third is 13MB it's not that big

thanks for your reply , i switched to ftpwebrequest and it also works fine on the first 2 files but on the third file it caught an exception "The underlying connection was closed: An unexpected error occurred on a receive." i tried to download this file with download tools again it cannot be downloaded without resuming the download it disconnects on 96% - 99% i dunno why

hello Bala Selvanayagam , Thanks for your reply, it seems in your code that you are creating a new instance of a datatable how could i do that for the table which i have created into dataset ? ,because i have databinding to the members of this table

Insert Step
//---------------
MemoryStream ms = new MemoryStream();
PBoxGuestImage.Image.Save(ms, ImageFormat.Jpeg);
Byte[] PicArray = new Byte[ms.Length];
ms.Position = 0;
ms.Read(PicArray, 0, PicArray.Length);

CMD.CommandText = "Insert Into TestTable(TestImage) Values (@ParTestImage)"
CMD.Parameters.AddWithValue("@ParTestImage", PicArray);
//---------------
this works great

Retrieve Step

Image NewImage;
byte[] content = (byte[])TestReader["TestImage"];
TestPictureBox.Image = null;
using (MemoryStream stream = new MemoryStream(content, 0, content.Length))
{
stream.Write(content, 0, content.Length);
NewImage = Image.FromStream(stream, true); //at this line i get the exception
}
TestPictureBox.Image = NewImage;

can u make your own insert and retrieve code and if it works for u ,help me with it

so what should i do in this case is it impossible to do that ?!,some people says it's very easy i knew it's very easy ,but why am i stuck here ?,please help me to solve this issue

yes i have tried it and it worked on a file , so is there something wrong at the insert step ?

so what should i do ?, do you have any sample of code which worked for u at this case?

i have already done this but there's an exception "The Parameter Is Not Valid" maybe i'm doing something wrong can you explain with some code please ?

is there another way to select image from database and store it into picturebox ?

i have tried this line and i get the same exception

pictureBox1.Image = System.Drawing.Image.FromStream(ms);

omg, i didn't sleep well since 3-4 days , ur right it was a wrong picturebox, Thanks very much for your help

it's the same thing with camera, what should i do ?

what if i set the specified image at the designer,why is the picturebox.image in this case is null too?

i have scanned the image and i get this error
the picturebox image is null while setting breakpoint
btw i'm using sqldatabase

myPictureBox.Image.Save(ms,ImageFormat.Jpeg)

i get an exception here object reference not set

i think i have searched before posting this

it's useful and it's so amazing but the right to left is so annoying
i just want to change the direction of the columns to be right to left without any troubles , when i try to do that with your sample it's the same thing the columns invisible and visible again and some annoying things happens to me
anyway to solve this problem?

Thanks.

is there any way to install database server?

where can i get MDIVWCTL.DLL?

i dun think that's gonna work , i'm doing an operation every 1 minute,i want the program to execute the method 1 time every minute but the timer execute it 2 times every 1 minute

thanks very much for your answer it works now but after changing little thing

InsertCMD.CommandText = "insert into Test(TestDateTime) values ( CONVERT([datetime], '@GDDate', 121) )";

'@GDDate' should be @GDDate

yeah, it's the same error

thanks for your answer , but it doesn't work for me

oh, sorry for that

i have already created a windows service and it works good for me but i can't use timer in this case ,i want to execute a method every 1 minute but,the program execute it one time i have set the start type to Automatic so the windows service should start on windows startup but it just execute the method one time , the only way to execute the method again is to restart the service

i have already posted a new question but i didn't think that i found the solution , can u help me there?

i'm doing a closing day method that's why i want to do this

hello Henry Minute , was just wondering how to do a method in a specific time and that time is stored in a variable , and the variable gets the specific time from database so the user can write the specific time in database if it's compare to the windows time the program automatically should do the method

and is it possible to make this method while the program is not running i mean something like in process service or windows service

i tried to use sqldatareader is it possible to use foreach statement ?

foreach(datarow row in this.dataset.tables[TableName].rows)
{
//----------------
}
is there anyway to retrieve the table without dataset? i mean can i directly retrieve the table from sql database? , because the dataset is too slowly

hello henry, thanks very much for the help

i have RoomType this table got 2 columns called [RoomTyCode - RoomTyName]
the primary is RoomTyCode table and i have a foreign key in Room table called ROMRoomType
how to retrieve the RoomTyName Value as ROMRoomType
if the ROMRoomType = 1 so it's gonna retrieve the 1st RoomTyName Value and its Name Villa

uhmm it's ok now i have tried to use fn as string and it works now

int fn = C3["FloorNumber"];
this line is has an error "Cannot Implicitly Convert Type Object To Int" and i tried to convert it that way
int fn = (int)C3["FloorNumber"];
so i get an exception , so the buttons won't appear

All of the buttons use the same event handler for their Click event

let's say i have 6 buttons retrieved by
foreach(DataRow C3 in this.dB1_PureEyezDataSet.Tables["Floor"].Rows)
{
Button B1 = new Button
//--------------
}
all of those buttons is gonna be using the same event handler
so how could i control all of them at the same event handler not to make the same thing
and how to make the button automatically gets its value

string filterExp = "Floor = 1";

i want the filterExp to automatically get the value when there's a new floor is added

let's say the user added a new floor so it's gonna appear as a button, this button is gonna do the same thing as the others
i want the filterExp to get the value automatically
is it possible or should i create a button by button ?

When the user creates a new floor, add a button
i didn't mean that he's gonna create a floor from the homescreen let's say he has created a row in database which indicates to the new floor
the floor is gonna appear as a button by the old method which i have started with look up at the question
the problem is when the button is added to the form how can i use the button click eventhandler and make it indicates to the new floor
i mean how to display the rooms which belongs to the new floor
let's say i have added 30 floor in the database
all of those rows is gonna appear as buttons in the homescreen the question is how to make those buttons works together at runtime if i select the floor number 27 is gonna get the rooms which belongs to this floor at runtime and if i select 26 the program gonna get the rooms which belongs to that floor ,etc i want the user to be able to add floors and filter the rooms at runtime not adding a code to a button by button

can u help me here or should i start a new question?

hello Henry

u already solved my problem but i'm sorry there's one thing more , please

now i have added the filterexp value i can't make it auto increment with the floors numbers because it's string

i mean i have to add filterexp value foreach button by myself and i want the user to be able to add floors and can filter them so what should i do
i'm srry but please i need your help here

snake

hello Henry Minute

thanks very much for helping

hello Henry Minute
Thanks very much for the help
but there's a little question here i have retrieve the rooms which belongs to the floor 1 but i can't make the status of them like i did before
explaining more:-i have just retrieved the new rooms as labels which belongs to floor number 1 but i still can't make the status if it's 1 it's gonna be limegreen if it's 2 it's gonna be Red , etc like what u have explained to me before
Hotel System Main Page[^]

i can't use foreach statement in this case
sorry for this little question
but, how could i solve this?

Code:-
try
{
string filterExp = "FLOID = 1";
string sortExp = "";
DataRow[] drarray;
drarray = dB1_PureEyezDataSet.Room.Select(filterExp, sortExp, DataViewRowState.CurrentRows);
FLP1.Controls.Clear();
for (int i = 0; i < drarray.Length; i++)
{
Label B3 = new Label();
B3.Width = 104;
B3.Height = 80;
B3.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
B3.Dock = DockStyle.Fill;
B3.Anchor = AnchorStyles.None;
B3.TextAlign = System.Drawing.ContentAlignment.TopRight;
FLP1.Controls.Add(B3);
B3.BorderStyle = BorderStyle.FixedSingle;
}
}
catch { }

hello

i think u didn't get it i want the user to be able to add floors to the hotel also if the floor is added ,it will appear as button shape if he clicked on that button the rooms which belongs to this floor is gonna be appear on the main screen as labels

oh i'm sorry i added the comment as a solution sorry for that

firstly thanks for ur attention

here's my new code after editing some errors

Collapse

private void FE_Method1()
{
foreach (DataRow C2 in dB1_PureEyezDataSet.Room.Rows)
{
try
{
Label B1 = new Label();
B1.BackColor = Color.LimeGreen;
B1.Width = 104;
B1.Height = 100;
B1.Dock = DockStyle.Fill;
B1.Anchor = AnchorStyles.None;
B1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
TLP1.Controls.Add(B1);
B1.BorderStyle = BorderStyle.FixedSingle;
B1.Text = "Test";
foreach (DataGridViewRow row in dataGridView1.Rows)
{
switch (row.Cells[9].Value.ToString())
{
case "1":
B1.BackColor = Color.LimeGreen;
break;
case "2":
B1.BackColor = Color.Red;
break;
case "3":
B1.BackColor = Color.Blue;
break;
}
}
}
catch (Exception)
{
}
}
}

TLP1 is a tablelayoutpanel

the problem is that i'm using B1 it's an object from Label class so when i try to change that object backcolor it changes all the labels

is there anyway to solve this problem ?