referenced https://www.codeproject.com/Articles/331986/Table-Row-Drag-and-Drop-in-ASP-NET-MVC-jQuery-Data?msg=5450831#xx5450831xx but getting error
Uncaught TypeError: $(...).dataTable(...).rowReordering is not a function in row reordering
referenced https://www.codeproject.com/Articles/331986/Table-Row-Drag-and-Drop-in-ASP-NET-MVC-jQuery-Data?msg=5450831#xx5450831xx but getting error
Uncaught TypeError: $(...).dataTable(...).rowReordering is not a function in row reordering
i have a listing page liststd view which displays all standards when i click on any standard it redirects to section view in section view i have a @url.Action to add new Section. A new gets opened but i need standard when the section view get opened so that when saving i can save both standard and section
i read the thread for using getsockno culd u ket me knw how t o get the port no i ma using c#
sqlstr = "select country , city FROM tbl_data WHERE RID in( " & ID & ") " dr = ''''''''''''''''''''exexuting the reader Ifdr.HasRows Then Whiledr.Read Dim datacountry =dr("country").ToString.Trim Dim datacity =dr("city").ToString.Trim MsgBox(datacountry & "===" & datacity) sqlstr = "SELECT user FROM tbl_info " _ & " WHERE country='" & drpcountry.SelectedItem.Text & "' AND city='" & drp city.SelectedItem.Text & "'" dr = ''''''''''''''''''''exexuting the reader Ifdr.HasRows Then Whiledr.Read sqlstr = "IF EXISTS (SELECT user, country, city FROM tbl_info " _ & " WHERE user='" &dr("user").ToString.Trim & "'" _ & " AND country='" & datacountry & "' AND city='" & datacity & "')" _ & " UPDATE tbl_info set user='" &dr("user").ToString.Trim & "' " _ & " WHERE user='" &dr("user").ToString.Trim & "' AND country='" & datacountry & "' AND city='" & datacity & "' " _ & " Else " _ & " INSERT INTO tbl_info(user,country, city) " _ & " VALUES ('" &dr("user").ToString.Trim & "','" & datacountry & "','" & datacity & "')" ''''''''''exexuting the query........ End While End If End While End If but in this only the first record from the country and city gets affected. all the records obtained in the reader shld get affected how do i rectify it
this code works fine for the first record in the loop it gives the error from second record if i execute the query after NEXT statement i dont get any error but only the last record frm the loop gets affected/executed not the earlier ones any solution /alteration in the code i have also used if DS.tables.count>o then before the IF DS.tables(0).rows.count>0
the problem ur r facing is either due to incorrect referencing of the application in IIS or due to firewall
reference your application folder in IIS nad use the virtual directory in the url
i have 2 tables from where the data is taken table 1 and table 2 table1 has user, country, city table2 has country,city wht i need is 1) selecting user with condition of country and city dropdownlists = the output can be multiple & after exceution of he query need to get the users 2) selecting fields from table2 from the grid depending on the id( i am getting the selected multiple id from the grid.== uid) then inserting the user , country , city in table1 with country, city selected fom table 2 if table1 has the combination of user , country , city then update else insert i have written the code but not getting the desired output if i use in the below way ie line1 & line2 then i get no error but only the last record in for loop gets affected and if i use line2 and then line1 i get sqlstr= "SELECT user FROM table1 " _ & " WHERE country='" & drpcountry.SelectedItem.Text & "' AND city='" & drpcity.SelectedItem.Text & "'" USERREADER = cmdMain.ExecuteReader() If USERREADER.HasRows Then While USERREADER.Read dim uname= USERREADER("user").ToString.Trim msgbox(uname) sqlstr= "select [country],[city] FROM table2 WHERE ID in( " & UID & ") order by country" '''''''''''''''''''' executing the query using If ds.Tables(0).Rows.Count > 0 Then Dim count = ds.Tables(0).Rows.Count For i = 0 To count - 1 Dim datacountry = ds.Tables(0).Rows(i).Item("country").ToString() Dim datacity = ds.Tables(0).Rows(i).Item("city").ToString() sqlstr= "IF EXISTS (SELECT user, country,city FROM table1 " _ & " WHERE user='" & uname & "'" _ & " AND country='" & datacountry & "' AND city='" & datacity & "')" _ & " UPDATE table1 set user='" & uname & "' " _ & " WHERE country='" & datacountry & "' AND city='" & datacity & "' " _ & " Else " _ & " INSERT INTO table1(user,country,city) " _ & " VALUES ('" & uname & "','" & datacountry & "','" & datacity & "')" Next ''''''' line1 '''''''''''''''''''' executing the query using dataset ''''''''line2 End If End While End If End If getting error cannnot find table(0)
i have a table with fiELds pARTICULARS , MA, ME, MD, MV, MF, MP (CHAR 1) electronics a e v plastics e d rubber a e d v f p this table is displayed in a grid i need to disable that cell of the grid which is blank at present i have i execute the query with a datareader For I = 0 To grid1.Rows.Count - 1 qry="select particulars from table" if datareader("ma")="" then disable the cell end if if datareader("me")="" then disable the cell end if if datareader("md")="" then disable the cell end if next i am not getting the desired thing . how do i exceute it
i have an aspx page with few control i wants its clientid in an external javascript file how do i get it i am using vb.net as the code behind at present in my external js file i have var tid = document.getElementById("shapedrpdw"); can anybody help