visual studio 2010 - Change the default behaviour of NullValue in a DataSet -

-

i have used .net mysql connector import dataset of mysql schema visual studio.

visual studio has generated *.xsd file me visual representation of tables, , fields within tables in schema.

i running queries against these tables using linq.

by default, nullvalue property of every field in every table set (throw exception). means in practice if apply criteria column contains null values in query, exception thrown when try enumerate through results shown below:

exception

the easy way fix change nullvalue property of particular column either (null) or (empty), have lot of columns in lot of tables , changing of these 1 @ time pain. can't use shift key select columns either, (null) , (empty) values apply reference types , nullable value types, if, example, selection contains single integer, none of properties updated.

is there option in visual studio change default behaviour of nullvalue property on column in datatable across board?

thanks

  1. in solution explorer, right-click on .xsd file
  2. select "open with..."
  3. choose "xml (text) editor"
  4. find field you've set "(empty)" or whatever want "default" value , review of syntax of msprop:nullvalue such msprop:nullvalue="_empty"
  5. use text search-and-replace (ctrl+h default) modify rest of nullable field xml tags in file. 1 way find standard column tag , add it. example, find msprop:generator_columnpropnameintable , replace msprop:nullvalue="_empty" msprop:generator_columnpropnameintable
  6. after done making replacements, ensure sure have 1 instance of msprop:nullvalue attribute per column or you'll have dataset syntax error
  7. save file , close it
  8. double click on .xsd opens in xsd designer , save ensure have no syntax errors , designer.cs files updated.

Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more