Is it possible to fill a data table from another data table by SQL QUERY in VB.net -


i have data table (dtexcelsource) filled ms_excel, using oledb. have second data table, structured (sqldbtype.structured).

my requirement is, fill second data table few values data table(dtexcelsource) using query or other method.

 myconnection = new oledb.oledbconnection("provider=microsoft.ace.oledb.12.0;data source=" & filepath & ";extended properties=""excel 12.0 xml;hdr=no"";")             myconnection.open()             dtexcelschema = myconnection.getoledbschematable(oledbschemaguid.tables, nothing)             dim sheetname string = dtexcelschema.rows(0)("table_name").tostring()             mycommand = new oledb.oledbdataadapter("select * [" & sheetname & "a5:f85]", myconnection)             ds = new system.data.dataset()             mycommand.fill(ds, "sourcetbl")             dtexcelsource = ds.tables("sourcetbl")             'dtexcelsource.columns(0).datatype = gettype(integer)             dtexcelsource.columns(0).columnname = "serial"             dtexcelsource.columns(1).columnname = "document a"             dtexcelsource.columns(2).columnname = "contract a"             dtexcelsource.columns(3).columnname = "subscriber a"             dtexcelsource.columns(4).columnname = "document b"        return dtexcelsource

my second data table having 15 columns, want insert each rows second data table.

does second table have same structure of first?
when said

my requirement is, fill second data table few values data table(dtexcelsource)

did mean wanted pull rows source table copy in second table or columns?

here @ may said post little confusing me.

   private sub fillseconddatatable()             dim dtexcelsource new datatable             dim dtsecondtable new datatable             ' put code populates dtexcelsource  in function returns datatable             dtexcelsource = somefunctioncalltoyourcode()             'if comes act on             if dtexcelsource isnot nothing andalso dtexcelsource.rows.count > 0                     'i'm cloning dtescelsource structure                     'new table because couldn't understand                      'post                     dtsecondtable = dtexcelsource.clone                     'the select procedure datatables returns                     'an array of datarows                      dim arreturnedrows() datarow = nothing                     'call select filter down rows want                     arreturnedrows = dtexcelsource.select("serial = someserialvalue")                     if arreturnedrows isnot nothing andalso arreturnedrows.count > 0                             'spin through returned rows ,                             'import row second table.                             '1 row cannot belong multiple tables                             'can't add second table while                             'it belongs first table                             each rw datarow in arreturnedrows                                     dtsecondtable.importrow(rw)                             next                     end if             end if     end sub

Comments

Post a Comment

Popular posts from this blog

javascript - jquery or ashx not working -

i using ajax file upload control. it creating html: <form action="/pages/handlers/asyncfileuploadhandler.ashx" method="post" enctype="multipart/form-data" target="ajaxuploader-iframe-1397144545"> <input type="hidden" name="type" value="mindvoice"> <input type="file" id="imagefile" style="display: block; width: 80%; margin-right: auto; margin-left: auto;"> </form> and target is: <iframe width="0" height="0" style="display:none;" name="ajaxuploader-iframe-1397144545" id="ajaxuploader-iframe-1397144545"></iframe> the form submitted using .submit() . my ashx handler: <%@ webhandler language="c#" class="asyncfileuploadhandler" %> using system; using system.web; using nettpals.core; public class asyncfileuploadhandler : ihttphandler { public void processre...
Read more

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

i wondering why line used in lucas kanade tracker in opencv: datatype<cv::detail::deriv_type>::depth can explain me? in opencv, depth of mat refers type of data contained in mat 's data buffer. represented integer values correspond given data type. these integers commonly abstracted appropriate macro definition (e.g. uchar data represented macro cv_8u ). cv::datatype type-traits class provides method obtain corresponding integer value without having memorize macro means data type. there few cases user code needs use datatype::depth . more common datatype::type . a simple example shows 1 possible use of datatype::depth : cv::mat uchar_data = cv::mat::ones(3, 3, cv_8uc1); cv::mat float_data; uchar_data.convertto(float_data, cv::datatype<float>::depth); // ^^ equivalently replaced // cv_32f macro float_data.at<float>(0,1) += 0.5f; std::cout << float_data << std::endl;...
Read more

python 3.x - Mapping specific letters onto a list of words -

can please suggest approach write piece of codes automatically maps letter in letter_str onto dic_key (a dict key string type contains dashes match length of words in word_lst)? so, mapping occurs if letter appears in every words in list @ same position no matter how many words in list. if no letter appears @ position words in word list new_dic_key '----'. please see examples below thanks word_lst = ['ague', 'bute', 'byre', 'came', 'case', 'doze'] dic_key = '----' letters_str ='abcdefghijklmnopqrstuvwxyz' new_dic_key = '---e' if word_list = ['bute', 'byre'] new_dic_key = 'b--e' or word_list = ['drek', 'drew', 'dyes'] new_dic_key = 'd-e-' if words in word_list of same length code give want: word_list = ['drek', 'drew', 'dyes'] cols = [] in range(len(word_list[0])): cols.append([]) word in ...
Read more