Comments by gunkrr (Top 24 by date)

thank you, i have done it :)

this code catch year as 20 not 11

where using function YEAR() ??

Argument data type int is invalid for argument 1 of substring function.

whats that??

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

how convert that??

yes thats autonumber, buti can handle that

this is my case

Insert into tb_generateid(id,firstname,lastname)
Values('L11'+CAST((@id+1) as varchar(10))+'IVO',@FirstName,@LastName)

i must input @id, but @id is 1 not 0000001
can i create it to be 0000001 ???

i know that
thx

ERRor in

Msg 156, Level 15, State 1, Procedure sp_generateid2, Line 18
Incorrect syntax near the keyword 'from'.
Msg 102, Level 15, State 1, Procedure sp_generateid2, Line 20
Incorrect syntax near ','.


why thats??

thx 4 ur attention

thank you

thx
but can you give me example in code??

can i use timer in timer
for example
private void timer1_Tick(object sender, EventArgs e)
{
timer2.start();
}

can i do that??

i have try this code

unsafe
{
byte* p = (byte*)(void*)Scan0;

int nOffset = stride - RImage.Width * 3;

for (int y = 0; y < RImage.Height; ++y)
{
for (int x = 0; x < RImage.Width; ++x)
{
int offset = y * RImage.Width * 3 + x * 3;
if (x == 0)
{
//get value of seed pixel if x==0
Color col = Color.FromArgb(p[offset], p[offset + 1], p[offset + 2]);
//col = bmData.GetPixel(x, y);
seedR = col.R;
seedG = col.G;
seedB = col.B;
}
//compare value seed pixel and pixel now
if ((seedR - p[0] >= tred) || (p[0] - seedR >= tred))
{
//change value pixel now
p[0] = p[1] = p[2] = 0;
//change value pixel for next 10 pixel
for (x = (x + 1); x <= 10; ++x)
{
p[0] = p[1] = p[2] = 0;
}
//get new value of new seed pixel
Color col = Color.FromArgb(p[offset], p[offset + 1], p[offset + 2]);
seedR = col.R;
seedG = col.G;
seedB = col.B;
}
}
p += nOffset;
}
}


but i cant see changes my image
whats problem?

i have correct my code and follow code above

private void button4_Click(object sender, EventArgs e)
{
// GDI+ still lies to us - the return format is BGR, NOT RGB.
BitmapData bmData = RImage.LockBits(new Rectangle(0, 0, RImage.Width, RImage.Height), ImageLockMode.ReadWrite, PixelFormat.Format24bppRgb);

int stride = bmData.Stride;
System.IntPtr Scan0 = bmData.Scan0;

unsafe
{
byte* p = (byte*)(void*)Scan0;

int nOffset = stride - RImage.Width * 3;

for (int y = 0; y < RImage.Height; ++y)
{
for (int x = 0; x < RImage.Width; ++x)
{
if (x == 0)
{
//RImage.GetPixel(x, y);
seedR = p[x];
seedG = p[x+1];
seedB = p[x+2];
}

if ((seedR - p[x] >= tred) || (p[x] - seedR >= tred))
{
//taruh value p dlu disini
for (int i=1; i <= 5; ++i)
{
p[x] = p[x + 1] = p[x + 2] = 0;
x++;
}

//RImage.GetPixel(x, y);
seedR = p[x];
seedG = p[x + 1];
seedB = p[x + 2];
}
p += 3;
}
p += nOffset;
}
}

RImage.UnlockBits(bmData);
}


but the result i have white area for 1/3 of my image
(i try change value tred but the result same)
whats wrong??
my goal is segmentation my image based or value every near pixel

vshost.exe has stopped working

in line
seedR = Convert.ToByte(col.R.ToString());
seedG = Convert.ToByte(col.G.ToString());
seedB = Convert.ToByte(col.B.ToString());

before it i use this code but also same error i get
seedR = col.R;
seedG = col.G;
seedB = col.B;

this code i mean for getting value of pixel

in the last block of code
we can see detect neighbor pixel
but i rather confused
is it from center area???
or scanline normal??

wanna become my mentor for doing this step by step??