Newly added rows from Datagrid - C# Discussion Boards

Re: Connecting database from different domain

Dave Kreskowiak24-Oct-11 4:06

24-Oct-11 4:06

If these is no trust setup between Domain Z and Domain X, you're limited to using SQL Server accounts and SQL Authentication. The problem with this is maintaining the accounts on the SQL Server, seperate from everyones AD account.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

crystal report

Aisha sharma24-Oct-11 0:50

Aisha sharma

24-Oct-11 0:50

Crystal report not open other system in 32bit window 7 AMD processor
and report related files............

thanks in advance.

Re: crystal report

Richard MacCutchan24-Oct-11 1:17

Richard MacCutchan

24-Oct-11 1:17

Please clarify your question, and also explain why this is a C# issue.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Creating CAPTCHA using SQL Database in ASP.NET

M Gxabana23-Oct-11 8:36

M Gxabana

23-Oct-11 8:36

Hi Guys,

I am having a problem here, please help.

I wanted to create an CAPTCHA image using text from SQL Database but now I don't know how to actually fit the get and fit the text in the image. I have already created the image but with automatically generated text using C# code.

I tested my program before, I got the image with the automatically generated text but now I dont get the other components like the textbox and botton for entering the text and validating it.

Please help!!! Thanks in advance!!!

Re: Creating CAPTCHA using SQL Database in ASP.NET

OriginalGriff23-Oct-11 21:57

OriginalGriff

23-Oct-11 21:57

Why? What you create will almost certainly not be as good or robust as those that are already available.

Have a look at ReCaptcha[^] - it's free, it's easy to use, and it helps digitise books that have failed OCR treatment.

[edit]Damn that link truncation bug! Fixed - OriginalGriff[/edit]

Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

modified 24-Oct-11 4:32am.

Re: Creating CAPTCHA using SQL Database in ASP.NET

Mycroft Holmes23-Oct-11 22:16

Mycroft Holmes

23-Oct-11 22:16

Crappy link I do believe.

Never underestimate the power of human stupidity
RAH

Re: Creating CAPTCHA using SQL Database in ASP.NET

OriginalGriff23-Oct-11 22:35

OriginalGriff

23-Oct-11 22:35

Fixed - it's the damn link truncation bug again. If you highlight text and then paste a link for some reason the url gets truncated in proportion to the original text length. But only sometimes, and most links get straight through. I reported it a month or so ago...

Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

Newly added rows from Datagrid

SFORavi22-Oct-11 13:05

SFORavi

22-Oct-11 13:05

Hi
For my assignment, I need to find out all rows that were newly added into the datagrid and add it to the database.

I have pasted my code below, getting error in setting dRow where it says index is out of range.. I thought the newly added row can be accessed thru the index. Please let me know how to access the cells in newly added row.

public partial class AllCustomer : Form
    {
        private int ii;
        public AllCustomer()
        {
            InitializeComponent();

            string strConnection = "Data Source=.;Initial Catalog=Company;Integrated Security=True";

            SqlConnection sqlconn = new SqlConnection(strConnection);
            DataSet ds = new DataSet();
            string sqls = "select * from CustomerMaster";

            SqlDataAdapter da = new SqlDataAdapter(sqls, sqlconn);

            sqlconn.Open();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            ii = dataGridView1.RowCount;
            sqlconn.Close();

        }

       private void btn_Add_Click(object sender, EventArgs e)
        {
            string strConnection = "Data Source=.;Initial Catalog=Company;Integrated Security=True";

            SqlConnection sqlconn = new SqlConnection(strConnection);
            DataSet ds = new DataSet();
            string sqls = "select * from CustomerMaster";

            SqlDataAdapter da = new SqlDataAdapter(sqls, sqlconn);
            SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);

            sqlconn.Open();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];

            for (int j = ii; j >= dataGridView1.RowCount; j++)
            {


                DataRow dRow = ds.Tables[0].NewRow();
                
                dRow["cust_name"] = dataGridView1.Rows[j].Cells["cust_name"].Value.ToString();
                dRow["cust_st_addr"] = dataGridView1.Rows[j].Cells["cust_st_addr"].Value.ToString(); 
                dRow["cust_city_state_zip"] = dataGridView1.Rows[j].Cells["cust_city_state_zip"].Value.ToString(); 
                dRow["cust_phone"] = dataGridView1.Rows[j].Cells["cust_phone"].Value.ToString(); 
                dRow["cust_stat_cd"] = dataGridView1.Rows[j].Cells["cust_stat_cd"].Value.ToString(); 

                //datetime hard coded for test only...
                dRow["cust_add_dt"] = "2011-10-14";
                dRow["cust_updt_dt"] = "2011-10-15";



                ds.Tables[0].Rows.Add(dRow);
            }
            da.Update(ds.Tables[0]);
        }

        

        
    }

Re: Newly added rows from Datagrid

Dan Mos23-Oct-11 3:02

Dan Mos

23-Oct-11 3:02

this is wrong.

1) In the button add click event you load the data form the DB again. Without first adding stuff
2) ii has the value of Count. Lets say 5. That means dROW[4] maximum and you start with 5.

The list could go on.
Smile | :)

All the best,

Dan

8086 assembler

gif202022-Oct-11 11:09

gif2020

22-Oct-11 11:09

I've visual c# 2008 ,I wanna make an assembly program of 8086 microprocessor on it,, is it available ????
could u show me the steps ,,plz??? Wink | ;)

thanks

Re: 8086 assembler

Dave Kreskowiak22-Oct-11 11:36

Dave Kreskowiak

22-Oct-11 11:36

Uhhh.. you're either asking how to write an 8086 emulator or your looking to write an app in Intel Assembly Language. I really can't tell which.

In either case, the required discussion would fill entire books. WAY too much information for a couple of forum posts.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: 8086 assembler

Luc Pattyn22-Oct-11 13:22

Luc Pattyn

22-Oct-11 13:22

Here[^] is an article that seems to explain things rather well, I didn't test it however I do expect it to work properly, even with Visual Studio C++ Express. What it doesn't say is you will be getting some build errors, unless you move some switches away from their default values. Trial and error will be involved.

[ADDED]
ML.exe may already be present in C:\Program Files\Microsoft Visual Studio 9.0\VC\bin

Now how is this a C# question?
[/ADDED]

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

modified 22-Oct-11 19:41pm.

Re: 8086 assembler

Paul Conrad23-Oct-11 9:16

Paul Conrad

23-Oct-11 9:16

Luc Pattyn wrote:
Now how is this a C# question?

From what it sounds like, and I'm still wondering about it, he might be wanting to have some 8086 (why an old 8086, maybe meant 80x86) Assembly code get called from C#. Like Dave's post, who knows for sure.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Re: 8086 assembler

Luc Pattyn23-Oct-11 9:42

Luc Pattyn

23-Oct-11 9:42

Nah. Calling an assembly function is too easy: just call it like you would call a regular C/C++ function, i.e. using P/Invoke, and make sure to have the calling conventions declared correctly.

We'll know what he really wants tomorrow. Or later. Or not at all. Who knows?

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: 8086 assembler

Paul Conrad23-Oct-11 9:55

Paul Conrad

23-Oct-11 9:55

Luc Pattyn wrote:
just call it like you would call a regular C/C++ function, i.e. using P/Invoke, and make sure to have the calling conventions declared correctly

It's pretty easy, too. But again, who knows what his real requirements are.

convert unicode to iransystem

mersad0022-Oct-11 6:33

mersad00

22-Oct-11 6:33

Hi there, i'm really in need of a convertor to convert unicode character map to iran system charachter map
Please Help!

Re: convert unicode to iransystem

BobJanova23-Oct-11 22:29

BobJanova

23-Oct-11 22:29

I don't know what the Iranian character set is but assuming it is a 256 character set a bit like the western one you can have a static map which specifies what Unicode code point each Iranian byte index represents. Then you can look up Unicode code points in that map, converting anything that isn't found to a ?.

Re: convert unicode to iransystem

Pascal Ganaye23-Oct-11 23:05

Pascal Ganaye

23-Oct-11 23:05

I just had a look and this is a really interesting question.
There are a few encoding in .NET that might be derived from the 'Iran System encoding standard'
But they don't appear to be as described in the Wikipedia page[^].

708: Arabic (ASMO 708) - different
720: Arabic (DOS) - different
864: Arabic (864) - different
1256: Arabic (Windows) - different 
10004: Arabic (Mac) - not found
20420: IBM EBCDIC (Arabic) - not found
28596: Arabic (ISO) - different

I thought it would be fun to try to write it then:

class IranianSystemEncoding
{
    static char[] ByteToChar;
    static Byte[][] CharToByte;

    static IranianSystemEncoding()
    {
        InitializeData();
    }

    static void InitializeData()
    {
        var iranSystem = new int[] { 0x06F0, 0x06F1, 0x06F2, 0x06F3, 0x06F4, 0x06F5, 0x06F6, 0x06F7, 0x06F8, 0x06F9, 0x060C, 0x0640, 0x061F, 0xFE81, 0xFE8B, 0x0621, 0xFE8D, 0xFE8E, 0xFE8F, 0xFE91, 0xFB56, 0xFB58, 0xFE95, 0xFE97, 0xFE99, 0xFE9B, 0xFE9D, 0xFE9F, 0xFB7C, 0xFB7C, 0xFEA1, 0xFEA3, 0xFEA5, 0xFEA7, 0x062F, 0x0630, 0x0631, 0x0632, 0x0698, 0xFEB1, 0xFEB3, 0xFEB5, 0xFEB7, 0xFEB9, 0xFEBB, 0xFEBD, 0xFEBF, 0x0637, 0x2591, 0x2592, 0x2593, 0x2502, 0x2524, 0x2561, 0x2562, 0x2556, 0x2555, 0x2563, 0x2551, 0x2557, 0x255D, 0x255C, 0x255B, 0x2510, 0x2514, 0x2534, 0x252C, 0x251C, 0x2500, 0x253C, 0x255E, 0x255F, 0x255A, 0x2554, 0x2569, 0x2566, 0x2560, 0x2550, 0x256C, 0x2567, 0x2568, 0x2564, 0x2565, 0x2559, 0x2558, 0x2552, 0x2553, 0x256B, 0x256A, 0x2518, 0x250C, 0x2588, 0x2584, 0x258C, 0x2590, 0x2580, 0x0638, 0xFEC9, 0xFECA, 0xFECC, 0xFECB, 0xFECD, 0xFECE, 0xFED0, 0xFECF, 0xFED1, 0xFED3, 0xFED5, 0xFED7, 0xFB8E, 0xFB90, 0xFB92, 0xFB94, 0xFEDD, 0xFEFB, 0xFEDF, 0xFEE1, 0xFEE3, 0xFEE5, 0xFEE7, 0x0648, 0xFEE9, 0xFEEC, 0xFEEB, 0xFBFD, 0xFBFC, 0xFBFE, 0x00A0 };
        ByteToChar = new char[256];
        // ascii first
        for (int i = 0; i < 128; i++) ByteToChar[i] = (char)i;
        // non-ascii
        for (int i = 128; i < 256; i++) ByteToChar[i] = (char)iranSystem[i - 128];

        // ok now reverse
        CharToByte = new Byte[256][];
        for (int i = 0; i < 256; i++)
        {
            char ch = (char)ByteToChar[i];
            var low = ch & 0xff;
            var high = ch >> 8 & 0xff;

            var lowCharToByte = CharToByte[high];
            if (lowCharToByte == null)
            {
                lowCharToByte = new Byte[256];
                CharToByte[high] = lowCharToByte;
            }
            lowCharToByte[low] = (byte)(i);
        }

    }

    public static String GetString(byte[] bytes)
    {
        var sb = new System.Text.StringBuilder();
        foreach (var b in bytes)
        {
            sb.Append(ByteToChar[b]);
        }
        return sb.ToString();
    }

    public static Byte[] GetBytes(string str)
    {
        var mem = new System.IO.MemoryStream();
        foreach (var ch in str)
        {
            var high = ch >> 8 & 0xff;
            var lowCharToByte = CharToByte[high];
            Byte res = 0;
            if (lowCharToByte != null)
            {
                var low = ch & 0xff;
                res = lowCharToByte[low];
            }
            if (res == 0) res = 0xff;
            mem.WriteByte(res);
        }
        return mem.ToArray();
    }
}

I have not clue if it works or not. My visual studio get confused with left and right when I try to put some of those characters in the source.
This was good fun though.
I posted this into [Tips] for reference.

Re: convert unicode to iransystem

Keith Barrow24-Oct-11 1:53

Keith Barrow

24-Oct-11 1:53

I don't think there is a direct way to do this, from the brief research I did it looks like the Iran System is obsolete, though that doesn't help your problem.

My advices is to create a Map which maps the numeric value of the Iranian System to the numeric equivalent in Unicode and vice versa. This isn't a huge problem but:

There isn't a map type in .net, which is a pity. You can fudge it a few ways, I've done it via dictionary (it is close with key/value instead of "key"/"key"), there is a discussion here[^]
Entering the numberic values by hand in code or config or somesuchis error prone.
This[^] should help as there is a [almost] copy and paste value mapping

Internationized text is a real pain (as I'm learning to my cost), it is even worse for right-to-left languages such as Farsi.

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Animation format

Aleonis22-Oct-11 5:59

Aleonis

22-Oct-11 5:59

Hello everyone!

What i want to do is to make an animation of a female character that appears on SCREEN and does everything it was supposed to do during animation.
The MAIN problem that i have no idea how to do this on the screen, without any borders of audio/video player. Closest EXAMPLE is VHGD aka VirtuaGirl player - girls walk on your screen without any border of the player (my version is NOT porn, it is rather gift).
Animation will be done by myself, all i ask is how to make it look like a VHGD.

How can i perform this using C# or any 3rd party libraries/ect?

modified 23-Oct-11 3:51am.

Does anyone know how to unbox or convert a "1" as a nullable long?

Alaric_22-Oct-11 5:37

Alaric_

22-Oct-11 5:37

...That pretty much says it all:

private void SetValue(object instance, PropertyInfo property, object data)
{
   //some preliminary checks
     if(property.PropertyType.IsAssignableFrom(data.GetType()))
        property.SetValue(instance, data, null);
     else
     {
         if(data is int)
         {
             int? unboxed = (int?)data;
             property.SetValue(instance, unboxed, null);
         }
         else
             property.SetValue(instance, Convert.ChangeType(data.ToString(), property.PropertyType), null);
}

I have an object that has a property of type long? and the value "1" cannot be pushed into it.

The failure is inside the "if(data is int)" branch.
"Object of type 'System.Int32' cannot be converted to type 'System.Nullable '1[System.Int64]'

How do I go about getting a System.Int32 into a System.Nullable [System.Int64] ??

"I need build Skynet. Plz send code"

Re: Does anyone know how to unbox or convert a "1" as a nullable long?

Alaric_22-Oct-11 6:03

Alaric_

22-Oct-11 6:03

omg...the int? is still boxed, isn't it

"I need build Skynet. Plz send code"

Re: Does anyone know how to unbox or convert a "1" as a nullable long?

Alaric_22-Oct-11 6:04

Alaric_

22-Oct-11 6:04

if((property.PropertyType ==(typeof(long))) || ((property.PropertyType == (typeof(long?)))))
{
    long converted;
    if(Int64.TryParse(data.ToString(), out converted))
       property.SetValue(instance, converted, null);
}

Money

"I need build Skynet. Plz send code"

Scope issue declaring a delegate within a static class

dotman121-Oct-11 23:15

dotman1

21-Oct-11 23:15

I have a static class that requires a delegate. A delegate should not be static and cant be fine. However a static class requires the variable and methods be static; There for how do I declare a delegate within the class?

e.g.
public delegate void currentBalance(int value);

public static DoSomething()
{
do something...
balance = 10;
currentBalance(balance);
}

Any Help more than welcome.
Thanks

dotman1

Re: Scope issue declaring a delegate within a static class

dotman121-Oct-11 23:33

dotman1

21-Oct-11 23:33

ok worked it out Smile | :)

forgot to pass the delegate to the method.

dotman1

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