c# - System.ArgumentException: The table type parameter must have a valid type name -

-

i trying pass in user defined table type query in c#.

the type defined 2 columns (org , sub org)

this code looks like:

dataset ds = new dataset(); try {      datatable filteredorgsuborg = new datatable("orgsuborgvaluetype");     filteredorgsuborg.columns.add("org", typeof(string));     filteredorgsuborg.columns.add("suborg", typeof(string));     filteredorgsuborg.rows.add(org, orgsub);     using (sqlconnection conn = new sqlconnection(ccon.getconn()))     {         using (sqlcommand cmd = conn.createcommand())         {             cmd.commandtext =                  "select * mytable ex year = @year' , qtr = @qtr" +                 " , exists(select 1 @orgsuborg tt  ex.org tt.org" +                 " , ex.orgsub = tt.suborg  )"+                 " order ex.org,year, qtr desc";             // 2. set command object knows             // execute stored procedure              // 3. add parameter command,             // passed stored procedure             cmd.parameters.add(new sqlparameter("@orgsuborg", filteredorgsuborg));             cmd.parameters.add(new sqlparameter("@year", year));             cmd.parameters.add(new sqlparameter("@qtr", qtr));               conn.open();             sqldataadapter sqlda = new sqldataadapter();              sqlda.selectcommand = cmd;             sqlda.fill(ds);          }     }

am passing parameters in incorrectly?

when in sql server so:

declare @orgsuborg orgsuborgvaluetype insert @orgsuborg  values ('05%','00000000') insert @orgsuborg values ('03%','00000000')   ------------ complete ----------------------------------- select * mytable ex  year = '2013' , qtr = '1'  , exists(                select 1                 @orgsuborg tt                               ex.org tt.org                  , ex.orgsub = tt.suborg  ) order ex.org,year, qtr desc  works should.

i tried passing in so:

  sqlparameter p = cmd.parameters.add(new sqlparameter("@orgsuborg", sqldbtype.structured));                      p.value = filteredorgsuborg;

but getting same error

the table type parameter '@orgsuborg' must have valid type name.

could can't pass sql command, have similar code in place, works great stored procedure...?

set mapping type in sqlserver using typename property that: gets or sets type name table-valued parameter, has fix .

p.typename = "dbo.mytype";

check table-valued parameters post


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

html - Accumulated Depreciation of Assets on php -

-
i have problem table print out asset accumulated depreciation on php, stright line method. $query = mysqli_query($connect, "select current_value, salvage_value, useful_life, placed_service assets"); if(!$query){ echo 'could not run query b: ' . mysqli_error($connect); exit; } while($asset = mysqli_fetch_row($query)){ echo "assets :"; print_r($asset); $month = 12; $year = date('y',strtotime($asset[3])); $first_year = $month - ((int)date('m',strtotime($asset[3]))-1); $last_year = $month - $first_year; $first = round((($asset[0] - $asset[1])/$asset[2])*(($first_year)/12),0); $last = round((($asset[0] - $asset[1])/$asset[2])*(($last_year)/12),0); $others = ($asset[0] - $asset[1])/$asset[2]; echo "<table border=1>"; echo "<tr><th>year</th><th>book value year start</th><th>depreciation expense</th><th...
Read more

Update QSQLTableModel in QT C++ -

-
i created 1 dialog used bindvalues in sql database, , can save every new record sucessfully. problem i've got dialog qsqltablemodel shows information database. every time make new record must close program , run again see changes in showinformationdialog() . know way such don't need close program update information in showinformationdialog() ? you can use select() method of qsqltablemodel class repopulate model data database. bound views updated automatically. suggest connecting signal wherever update data in database (i.e. dialog updating sql database) custom slot in showinformationdialog() calls select() of qsqltablemodel object. assume have qmainwindow object parent of both dialogues best place establish connection. also since showinformationdialog() 's model used viewing data consider using qsqlquerymodel . if used setquery() method should used instead of select() otherwise (the connection of signal showinformationdialog() 's slot) same. ...
Read more