add data,delete data,modify data,save data from datagrid - C# Discussion Boards

Hi,
Thanks for the reply guys...
In regards to below:
"3.
First option is just find. we do not mention db filename, unless we attach it to project and is inside project."

Please elaborate. I remember seeing somewhere where in a project the name of the sql express was placed inside the connectionstring. Also I remember seeing that .mdf was being used within the application.

Since this is a small project with one user to begin with (Number of users may increase to say 5 maximum in the future), should I place the mdf inside the project?

Thanks

A typical connection string where the database is already attached to SQL Server 2008 Express.
"Data Source=POWERPC\\SQLEXPRESS2008;Initial Catalog=Northwind;Integrated Security=True"
and where it is not already attached
"Data Source=.\\SQLEXPRESS2008;AttachDbFilename=E:\\SQLExpress\\NorthWind\\NORTHWND.MDF;Integrated Security=True;User Instance=True"

Basically the Express versions of SQL Server are the same as the full version, same engine etc., it's just that some of the tools and functionality have been disabled.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!

Hi,
I am unable to connect to the sql2005express on my laptop
The error I get is:
login failed for user 'UserA'. the user is not associated with a trusted sql server connection

Note that sql server is set for both windows and sql authentication modes.
UserA is created in the login to have access to the database "DBName"

Data Source=.\SQLEXPRESS;Initial Catalog=DBname;User Id=UserA;Password=password

If I use the following connectionstring then it works fine

Data Source=LAPTOPName;Initial Catalog=DBname;IntegratedSecurity=True

Question:
How can I connect successfully to sqlExpress in my laptop please?

Thanks

At least you are able to connect using Windows Authentication. Smile | :)

The only time that I have seen the error message you are getting is when I have not had SQL Server Authentication turned on, even though I thought it was. So I can only suggest that you double check this, perhaps by following the steps in the post from yeukwong999 in this[^] thread on MSDN.

Once you are sure that it is turned on, if it still fails then I am stumped. In that case I suggest that you raise a new question, which will be seen by more people than will see this thread.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!

another thing to keep in mind is that Microsoft wants you to sign a distribution agreement with them if you are making a product that installs SQL Server Express. If this is something that the end user installs separately, then I think you would not have to have a signed agreement, but if you are building a system with it included, you should. We have signed it with MS for our application at work.

Steve Maier

Hi,

I want to restrict users that are logged on a computer from a guest account from running my .NET C# application. What is the recommended way to do this?

Best Regards
Olof

See caspol[^].

1st screen: Login form
initially, i.e for the 1st time it sud take username n password as admin admin n log in.

2nd screen: configuration.
here i have a data grid which will display all the values entered from form 3( add new user screen). i have 4 buttons in this screen. 1.add new user, 2.delete user,3.modify user,4.ok. Data grid will have 2 columns(user name, access level)

*new user button click- form 3(add new user screen ) ll be displayed. here there ll be three text boxes. one for user name, one for password, one for access level.. the user ll unser these details n press ok button in form3. on ok button click, only the user name n access level sub be displayed in the data grid.. but user name, access level n password sud be parallely saved in an array or arraylist.. here the no of users sud be restricted..

*for deleting the user, any row in the datagrid sud be selected n delete button ll be clicked. this deleting the user sud delete the data from the arraylist also.

*to modify the user details, first some row in datagrid sud be selected n on modify user button click, new form, form 4(i.e modify user form ll be displayed). here there will be 5 textboxes. old user name, new user name, old password, new password, confirm password. the old user name sud take the value from the grid when the form4 is displayed. on enetering the other details, the user name in the datagrid, will be modified n displayed with the new user name enetered by the user. along with this, the arraylist also sud be updated..

Note: each time the the user name is enetered from for3 n form4, first it sud be checked in the arraylist for the duplicate.. then the data that is displayed in the datagrid sud be retained..i.e when the application is restarted, the values previously entered sud be displayed in the arraylist.

*on ok button click in form2(configuration form), the array list sud be saved in am xml file.. for 2nd time login, the xml sud be checked for the existance of the user name. if the user name is present in the xml, then the user sud be allowed to log in..

database,datasource sud not be used. pls anyone help me to solve this prob

Please don't cross post you have already posted this question there[^].

Hi All,
I have requirement by which,:
when i press Ctrl+C on an outlook item, it gets copied to clipboard. I have to use this clipboard content and get MSG file(which is now text-data to clipboard), to C# outlook item and use it (say eg: save on some location as file).

if (Clipboard.ContainsText(System.Windows.Forms.TextDataFormat.Text))
            {
                IDataObject myData = Clipboard.GetDataObject();

                Outlook.MailItem olMsg = (Outlook.MailItem)myData.GetData(DataFormats.Text, true); //fails here
            }

Above code does not work because outlook is showing copied message as Text and not FileDropList!
Thus above code fails. What is other way to do so or modifications in same.
Your help highly appreciated.

I am currently working on a project, which will dynamically load in a C++ library and instantiate one of the contained classes through the use of a common interface.

However, one of the methods that I am trying to expose in the C++ library takes the following set of arguments...

C++Library.MethodName(String^ stringVariable, unsigned char sProblemVariable[])

This is where the problem arises.

Now I know the C# equivalent of the unsigned char [] argument is a byte, so I am attempting to use this method in the following manner.

byte[] byteArr = new byte[127];

unsafe
{
   fixed (byte *bytePointer = byteArr)
   {
      int returnValue = Interface.MethodName(aStringVariable, bytePointer);
   }
}

So I am attempting to expose the C++Library.MethodName through the Interface, using the following method signature...

unsafe int MethodName(string stringVariable, byte *problemVariable);

When compiling the C++ Library, implementing the interface, it builds successfully so I assume that the C++ method signature satisfies the C# interface signature.

However, when I attempt to load the C++ Library, I get a Reflection Exception telling me there is no implementation for the MethodName method, in the Library.

Any help would be greatly appreciated!!

Thanks..

A girl in Engineering AND IT?!...what is this nonsense?

Is there a reason you can't refactor the C++ code to .Net/C#?

What is the exact exception message?

Can you show us the interface you're creating (just the method prototypes will be sufficient).

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

I was trying to use PInvoke, as it provides another level of abstraction in a system that really doesn't need any more.

A generated C# code block dynamically loads the C++ dll through an interface loaded dynamically...and so on..

Anyway, I have resolved the issue by wrapping the C++ methods which take the unsigned char argument in methods which can be easily exposed through the interface.

Thanks for your input.

A girl in Engineering AND IT?!...what is this nonsense?

Did you consider wrapping the code in managed C++? I've done that occasionally in the past and had a lot of success with it.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Is there a reason you can't pinvoke this method? If you intend to write to the unsigned char [], you can pass a StringBuilder in to the method and use the output from that.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Message Removed

I don't think that was needed. Given her activity on the site to date, I was pretty confident that she wouldn't notice that, and now you've put a spotlight on it.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Maybe the spotlight should not have been put on her to begin with.

A little more class and little less lecherism, please.

cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

Hey, I agree.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

My original indent was to inform her.
If you have a look at timings, i informed her just after few posts and later non-sense chat started.
Had she seen my message here, when it was posted, non-sense would have been limited very much.

I had to delete message myself from being further down voted by people, who down vote a already down voted message without thinking about it.

I'd prefer to wrap it in another method that would then be exposed. That's how I do P/Invoke.

public byte[] Whatever ( ... )
{
    /* Maybe convert the parameters as necessary */

    return ( C++Library.MethodName ( ... ) ) ;
}

Errr, I think this is managed C++, isn't it? In this case you don't need pointers at all. Both libraries are running under the CLR, so you can pass the byte array. Have you considered AssemblyResolve[^] event?

Hi,

Any one guide me about the datagridview

Advance Thanks,
GJ.Balaji

See here[^].

You can search on the internet and you will find tons of more information.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Be warned, you should not edit data in a list control. Pop a dialog with the record information and edit it there, then reload the table/record in the grid after the user has completed editing.

Inline editing generates more problems that it solves.

Never underestimate the power of human stupidity
RAH