Re: c# - C# Discussion Boards

dcof3-Aug-12 10:23

3-Aug-12 10:23

In a linq to sql data context object that points to a sql server 2008 r2 database in a C# 2010 application, I want to change the size of a column from varchar(500) to varchar(900). To acoomplish this task, can you tell me what I need to do so the data context object picks up the expanded size?

Re: C# change linq to sql

Abhinav S3-Aug-12 18:02

Abhinav S

3-Aug-12 18:02

The datacontext schema is created when you drag and drop the database items from the explorer.
Since this is just a column size change, you can change this manually in the code generated.

The other option is to manually delete all the table mappings and then re-create them - this would be a slightly more cumbersome task.

A new Windows Phone App - Speed Dial

Re: C# change linq to sql

AnnieCalvert3-Aug-12 19:01

AnnieCalvert

3-Aug-12 19:01

Create another field with the HASH of that varchar(500), and put a UNIQUE CONSTRAINT on the hash field: HASH BYTES('md5', My Long VarcharField)
This will cause poor performance but if you have a varchar(500) where you need to enforce uniqueness I'm assuming performance isn't on the forefront of your considerations anyways.
http://www.dapfor.com/en/net-suite/net-grid/tutorial/data-binding

Re: C# change linq to sql

jschell4-Aug-12 7:02

jschell

4-Aug-12 7:02

AnnieCalvert wrote:
Create another field with the HASH...

What does that have to do with the question?

Re: C# change linq to sql

BobJanova5-Aug-12 23:45

BobJanova

5-Aug-12 23:45

Any varchar column is mapped to a string, isn't it? So you should just be able to change the schema and everything should still work fine.

Member 20501073-Aug-12 5:33

Member 2050107

3-Aug-12 5:33

window calculator in c#

Re: c#

fjdiewornncalwe3-Aug-12 5:42

fjdiewornncalwe

3-Aug-12 5:42

Yes, there is one.
Start Menu -> All Programs -> Accessories -> Calculator...

There are also 7.2 million results if you would have done a google[^] search.

I wasn't, now I am, then I won't be anymore.

Re: c#

Wes Aday3-Aug-12 6:06

Wes Aday

3-Aug-12 6:06

Random nonsensical sentence of the week?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: c#

Abhinav S3-Aug-12 18:03

Abhinav S

3-Aug-12 18:03

Try something and post your queries here - someone might be able to help you.

A new Windows Phone App - Speed Dial

Re: c#

Karthik Harve3-Aug-12 20:20

Karthik Harve

3-Aug-12 20:20

What have you tried so far?

Vande Matharam - Jai Hind

Re: c#

Christian Amado6-Aug-12 10:31

Christian Amado

6-Aug-12 10:31

You can try one of the following: Google Search[^]

Christian Amado
MCITP | MCTS | MOS | MTA
Olimpia ☆ ★★★

Please mark as answer, if it helps.

Creating a new value and data to am existing registry subkey

M.S.S.E3-Aug-12 4:25

M.S.S.E

3-Aug-12 4:25

Hi all,
actually what I need it's so simple (but not for beginner just like me) I read two articles about registry manipulating but I couldn't do what I need, it's to add these values and data using C#:

"Key"="000000000000"
"VID"="AAAADjUuMC4xMTMzNy4xOTY4"
to the existing key:

[HKEY_CURRENT_USER\Software\Google\Google Earth Plus]

could anyone help me please?.
Many thanks in advance.

modified 3-Aug-12 10:34am.

Re: Creating a new value and data to am existing registry subkey

Ed Hill _5_3-Aug-12 5:06

Ed Hill _5_

3-Aug-12 5:06

The following is untested code but should give you something to get started, add:

using Microsoft.Win32;

to your class, then where needed try the following code. I believe that CreateSubKey and SetValue will create the required Key/Value if they do not already exist, or update them if they do.

RegistryKey software = Registry.CurrentUser.CreateSubKey("Software");
RegistryKey google = software.CreateSubKey("Google");
RegistryKey googleEarth = google.CreateSubKey("Google Earth Plus");
googleEarth.SetValue("Key", "000000000000");
googleEarth.SetValue("VID", "AAAADjUuMC4xMTMzNy4xOTY4");

edit: correction of typeo in the word ~~goolge~~ google

modified 3-Aug-12 12:22pm.

Re: Creating a new value and data to am existing registry subkey

M.S.S.E3-Aug-12 6:02

M.S.S.E

3-Aug-12 6:02

Hi,
I tried this code but I got some errors like:
------------------
The name 'google' does not exist in the current context
The name 'goolgeEarth' does not exist in the current context
------------------

Anyway I also tried this code but nothing happened:

RegistryKey mykey = Registry.CurrentUser.CreateSubKey(@"Software\Google\Google Earth Plus");
mykey.SetValue("VID", "AAAADjUuMC4xMTMzNy4xOTY4");

Thank you.

Re: Creating a new value and data to am existing registry subkey

Ed Hill _5_3-Aug-12 6:21

Ed Hill _5_

3-Aug-12 6:21

looks like a little miss typing in the code sample i have now corrected it, the values are going into the registry fine for me here, remember if you are looking at regedit you will need to refresh the screen View > Refresh to see the new values.

using System;
using Microsoft.Win32;

namespace regWriter
{
    class Program
    {

        static void Main(string[] args)
        {
            RegistryKey software = Registry.CurrentUser.CreateSubKey("Software");
            RegistryKey google = software.CreateSubKey("Google");
            RegistryKey googleEarth = google.CreateSubKey("Google Earth Plus");
            googleEarth.SetValue("Key", "000000000000");
            googleEarth.SetValue("VID", "AAAADjUuMC4xMTMzNy4xOTY4");
            Console.ReadLine();
        }
    }
}

Re: Creating a new value and data to am existing registry subkey

M.S.S.E3-Aug-12 6:29

M.S.S.E

3-Aug-12 6:29

It worked, thank you very much.

C# using login form

sanjay savaliya3-Aug-12 3:38

sanjay savaliya

3-Aug-12 3:38

ogin form in user is three times password is incoreect in project is find out conformation code?

Re: C# using login form

BobJanova3-Aug-12 3:45

BobJanova

3-Aug-12 3:45

please rephrase in english tyia

Re: C# using login form

Christian Amado6-Aug-12 10:35

Christian Amado

6-Aug-12 10:35

You can change the record to 0 in IsLockedOut on your aspnet_membership table. If you're using ASP.NET Membership.

Regards

Christian Amado
MCITP | MCTS | MOS | MTA
Olimpia ☆ ★★★

Please mark as answer, if it helps.

Filter datagridview by a multiline texbox [moved]

Jaasiel3-Aug-12 1:14

Jaasiel

3-Aug-12 1:14

Hi, im a have a multiline texbox and a datagridview all c#. I want to filter the grid by the multiline textbox and need to use every single line to filter the grid. Please can somebody helm me with that??

Jaasiel

modified 3-Aug-12 7:26am.

Re: Filter datagridview by a multiline texbox

^1.21 Gigawatts3-Aug-12 1:20

^1.21 Gigawatts

3-Aug-12 1:20

Pssst....wrong forum!

Try the C# one Smile | :)

"Benjamin is nobody's friend. If Benjamin were an ice cream flavor, he'd be pralines and dick." ~ Garth Algar

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

Re: Filter datagridview by a multiline texbox

Hiren solanki3-Aug-12 1:21

Hiren solanki

3-Aug-12 1:21

Yes, I can helm this by suggesting you to put your question on THIS[^] forum.

People are so bad towards kind of question here. and will constantly remind you to look at the top of the page.

Regards,
Hiren.

Re: Filter datagridview by a multiline texbox

Nagy Vilmos3-Aug-12 1:22

Nagy Vilmos

3-Aug-12 1:22

--- DO NOT ASK PROGRAMMING QUESTIONS IN THE LOUNGE ---

I'd quickly apologise and move this to Q&A if I was you.

Panic, Chaos, Destruction. My work here is done.
Drink. Get drunk. Fall over - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer
Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

Re: Filter datagridview by a multiline texbox

Hiren solanki3-Aug-12 1:24

Hiren solanki

3-Aug-12 1:24

Nagy Vilmos wrote:
I'd quickly apologise and move this to Q&A if I was you.

As a newbie, It seems it will be too late till the time he realizes.

Regards,
Hiren.

Re: Filter datagridview by a multiline texbox

Andrei Straut3-Aug-12 1:26

Andrei Straut

3-Aug-12 1:26

Nagy Vilmos wrote:
I'd quickly apologise and move this to Q&A if I was you.

Can we start the Univote Frenzy now, pleeez pleeeeez pleeeeeeeez?

[Edit]:
Posted this before it was moved to C# forum
[/Edit]

Full-fledged Java/.NET lover, full-fledged PHP hater.
Full-fledged Google/Microsoft lover, full-fledged Apple hater.
Full-fledged Skype lover, full-fledged YM hater.

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 3:15

Refresh

ᐊ Prev 1...1931 1932 1933 193419351936 1937 1938 1939 1940 Next ᐅ

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