Comments by nyt1972 (Top 63 by date)

InsertBatch works fine but when I add the Enum field role then it gives the error.

I have table with following kind of values and I want to update Add, View or Delete with 1 or 0

ID Class Add View Update Delete
1 Class1  1
2 Class2       1
3 Class3             1
4 Class4

Thanks, my html is a page to grant permissions to classes, that is add/view/delete etc, so some classes may have add and some may have view and some have none, so I want to insert accordingly. Is it enough explanation?

I added this:

String fastFollowAssetPackPath = getAbsoluteAssetPath(assetPackName, "");

        if (fastFollowAssetPackPath == null) {
            assetPackManager.registerListener(assetPackStateUpdateListener);
            List<String> assetPackList = new ArrayList<>();
            assetPackList.add(assetPackName);
            assetPackManager.fetch(assetPackList);
        }

but it say
Attempt to invoke interface method 'com.google.android.play.core.assetpacks.AssetPackLocation com.google.android.play.core.assetpacks.AssetPackManager.getPackLocation(java.lang.String)' on a null object reference

Thanks dear the problem was in sql query, it was not duplicating in sql but in codeigniter I have to use distinct which resolved the problem.

Live Link of my project:

https://ansicollege.net/ci4/student

This is my classid change event, here the Ajax/getStudents method returning data and displaying correctly too. but when I try to do it with dataTables then it doesn't work

$("#classid").change(function(){
        var sessionid = $("#sessionid").val();
        var classid = $(this).val();
    $('#example').DataTable({
        ajax: {
            url: "<?php echo site_url('Ajax/getStudents'); ?>",
            type: "POST",
            data: function(d){
                d.sessionid = $("#sessionid").val();
                d.classid = $("#classid").val();
            }
        },
        dom: 'Bfrtip',
              iDisplayLength: 15,
              buttons: [
                  'copyHtml5',
                  'excelHtml5',
                  'csvHtml5',
                  'pdfHtml5',
                  'pageLength'
              ],
              search: true
         });  
        });

Response is this:

[{"studentname":"Ali","fathername":"Ajmal","rollno":"101","mobile1":"222111"},{"studentname":"jamal","fathername":"kamal","rollno":"102","mobile1":"545454"}]

Database has only one table tblstudent having some dummy data.

sorry typing mistake, dataTable getting no data, it say no data available.

do I need anything to change in html?

<table id="datatable-responsive" class="table table-sm table-striped table-bordered dt-responsive nowrap" cellspacing="0" width="100%">
                        <thead  
                        <tr><th colspan="5" class="text-danger">Student's Detail</tr>
                            <tr>
                                <th class="text-primary">Student Name</th>
                                <th class="text-primary">Father Name</th>
                                <th class="text-primary">Roll Number</th>
                                <th class="text-primary">Mobile</th>
                                <th></th>
                            </tr>
                        </thead>
                    </table>

I changed the code to below now its getting parameters correctly but dataTables getting no data

 $("#classid").change(function(){
    $("#datatable-responsive").dataTable({
        dom: 'Bfrtip',
            buttons: [
                'copy', 'csv', 'excel', 'pdf'
            ],
        ajax: {           
            url: "<?php echo site_url('Ajax/getStudents'); ?>",
            type: "POST",
            data: function(d){
                d.sessionid = $("#sessionid").val();
                d.classid = $("#classid").val();
            },
            columns: [
            { data: 'studentname' },
            { data: 'fathername' },
            { data: 'rollno' },
            { data: 'mobile1' }
        ]
        },
    });  
    $("#datatable-responsive").dataTable().api().draw(true);  
    });

I found the problem, the parameters sessionid, and classid are not getting values actually. these parameters are getting value Select Session and Select Class instead of values.

Thanks for your reply I tried this but no success

It say no data available.

if I click on bottom navigation Fragment show up, but if I click on a tab the Fragment is not showing up.

I resolved my problem by combining results array.

$results = array_merge($result1,$result2);

ok, I posted my solution.

After using if statement resolved the problem.

if you check the images, the problem is that I want the output like in the image number 2.

sorry I type %M instead of %m

It say Warning: #1411 Incorrect datetime value: '04-2020' for function str_to_date and return NULL value too.

My MySQL version shows:

mysql Ver 15.1 Distrib 10.4.14-MariaDB

Thanks for your replies, I tried the below and it worked:

SELECT id, avg_grade_point, FIND_IN_SET( avg_grade_point, 
                ( SELECT GROUP_CONCAT( DISTINCT avg_grade_point ORDER BY avg_grade_point DESC ) AS Rank
                FROM final_results WHERE academic_year_id = 6 AND class_id = 1 ) ) AS rank 
                FROM final_results 
                WHERE academic_year_id = 6 AND class_id = 1

sorry it was typing mistake. its academic_year_id and class_id and academic_year_id is 6 not 1

Thanks for the reply, if I change the code $('#grade_id_'+student_id).val(data);
to $('#grade_id_'+student_id).val("Test"); it works, which means that data is not getting the value.

Sorry I didn't understand your question but if($model->update($id,$data)){ returning successful message

thanks

tried that but still getting the error.

thanks for the reply but I think I am getting this error bcoz of wrong use of table rows and columns, but I dont have idea that how to fix.

Thanks a lot, just modified a bit
formatDate = function(d) {
var dd = new Date(d);
return dd.getFullYear()+"-"+monthNames[dd.getMonth()]
}

Thanks guys I have done, just need to add [] inputs names to make it arrays. e.g

yes in html they are all selected bcoz from JQuery it add selected to each option, and thats I want to ask that how can I add to the new option only.

In debug its executing the lines, but not alerting the message.

I tried this and its not executing even.

$lastInsertId = $conn->lastInsertId();
echo "". $lastInsertId ."";

Ok, thanks my mistake, I changed it to ready, but still not working

Thanks Sandeep but I wanted a fancy one, and without clicking a button, if I change this textbox value and if the condition is true.

Alret not working

Thanks Richard Deeming

Thanks for the reply,I created a ViewModel and changed my Controller's Methode to:

 public ActionResult GetClassFee(int? Classid)
        {
            ClassFeeVM CFee = new ClassFeeVM();
            if (Classid != null)
            {                
               List<ClassFee> classfees = db.ClassFees.Where(p => p.tblClass.ClassID == Classid).ToList();
                foreach (var item in classfees)
                {
                    CFee.ClassFee = item.ClassFee1;
                    CFee.ClassID = item.ClassID;
                    CFee.ClassName = item.tblClass.ClassName;
                    CFee.FeeType = item.tblFeeType.FeeType;
                }
               ViewBag.ClassFees = CFee;
            }
            return PartialView("_ClassFee");
        }

And partialView to:

@{ 
    var cfv = ViewBag.ClassFees;
}
@if (cfv != null)
{
    foreach (var item in cfv)
    {
        <p>item.ClassFee1</p>
        <p>item.FeeType</p>
        <p>item.ClassFee</p>
    }
}

But I get the error:

Cannot implicitly convert type 'SchoolMVC.Models.ViewModel.ClassFeeVM' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?)

Thanks a lot, it was logical error in JQuery script, I corrected and updated my Question too.

don't know how to debug JQuery code?

ok thanks

The browser allow bco when I paste link in browser it do work.

Passing Select List to Post create method resolved the issue

It should return a collection, and it does, but the error comes if I don't select any or if I leave any required field blank.

I expect the error message that InstitutionID not selected or something like this but it throws this IENUMERABLE error.

I got to know that the error message is from the login page, my login code is below

  Private Sub Login()
        Try
            sqL = "SELECT * FROM staff WHERE uname = '" & txtUsername.Text & "' AND upasswd = '" & txtPassword.Text & "'"
            ConnDB()
            cmd = New MySqlCommand(sqL, conn)
            drlogin = cmd.ExecuteReader()
            If drlogin.Read = True Then
                Me.PictureBox1.Image = My.Resources.lock_open_48

                If LCase(drlogin("role")) = "admin" Then
                    MsgBox("Welcome to Tsoft POS and Inventory System", MsgBoxStyle.Information, "Login")

                    frmMain.tsslUser.Text = UCase(txtUsername.Text)
                    frmMain.tsslUser.Tag = drlogin("ID")
                    isCashier = False
                    isAdmin = True
                    frmMain.Show()
                    Me.Hide()
                End If

                If LCase(drlogin("role")) = "user" Then
                    MsgBox("Welcome to Tsoft POS and Inventory System", MsgBoxStyle.Information, "Login")
                    strCashierID = drlogin("ID")
                    frmMain.Show()
                    isCashier = True
                    isAdmin = False
                    Me.Hide()
                End If





            Else
                Me.PictureBox1.Image = My.Resources.lock_48
                MsgBox("Incorrect username or password.", MsgBoxStyle.Critical, "Login")
                txtUsername.SelectAll()
                txtPassword.SelectAll()
            End If
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            cmd.Dispose()
            conn.Close()
        End Try
    End Sub

I debugged the code it shows error at end, when all records retrieved

I debugged the code it shows error at end, when all records retrieved

Ok thanks a lot

Thanks a lot for yours responses, finally I managed to correct the error finding in debug that the error is because of the last empty row in datagridview.

Product_id has a value, and in debug it show me the value in variable as well, but even then it gives me that error.

http://ansicollege.net/vbcode/error.png

This the error I get.

Following is the code line I get error in

dgvcc = DirectCast(DataGridView1.Rows(i).Cells(1), DataGridViewComboBoxCell)
.Parameters.AddWithValue("@product", dgvcc.Value)

I store values in combobox of Datagridview, product_id datatype in database is int

Thank you all for your replies and helping me, I tried my level best but facing new new errors so finally uploaded my project if anyone help me then.

Here is my project

With the changed code now its not showing any error but records are not stored in database

Changed code to below but now records are not stored in database

Try
            ConnDB()
            cmd = New MySqlCommand(sqL, conn)
            For i As Integer = 0 To Me.DataGridView1.Rows.Count - 1
                sqL = "INSERT INTO `dailysale`(`billno`,`customer_id`, `product_id`, `qty`, `price`, `total`, `description`) VALUES('@billno','@custid''@product', '@qty', '@price', '@total', '@desc')"
                'datatype integer
                With cmd
                    .Parameters.Clear()
                    .Parameters.AddWithValue("@billno", txtbillno.Text)
                    .Parameters.AddWithValue("@custid", txtCustomer.Tag)
                    .Parameters.AddWithValue("@product", Me.DataGridView1.Rows(i).Cells(1).Value)
                    .Parameters.AddWithValue("@qty", Me.DataGridView1.Rows(i).Cells(2).Value)
                    .Parameters.AddWithValue("@price", Me.DataGridView1.Rows(i).Cells(3).Value)
                    .Parameters.AddWithValue("@total", Me.DataGridView1.Rows(i).Cells(4).Value)
                    .Parameters.AddWithValue("@desc", Me.DataGridView1.Rows(i).Cells(5).Value)
                End With
            Next
            sqL &= "INSERT INTO `customer_payments`(`customer_id`, `billno`, `cdate`, `bill_amount`, `paid_amount`, `discount`, `ret_amount`, `balance`) VALUES ('" &
            txtCustomer.Tag & "','" & txtbillno.Text & "','" & DateTimePicker1.Value & "','" & txtbill_amount.Text & "','" & txtpaid_amount.Text & "','" & txtdiscount.Text & "','" & txtret_amount.Text & "','" & txttotalbalance.Text & "')"

            cmd.ExecuteNonQuery()

            MsgBox("New Bill successfully created.", MsgBoxStyle.Information, "Create Bill")
        Catch ex As Exception
            MsgBox(ex.ToString)
        Finally
            cmd.Dispose()
            conn.Close()
        End Try

Cells(1) containt value and Cells(5) too. but even then getting this error

'datatype integer
product = Convert.ToInt32(Me.DataGridView1.Rows(i).Cells(1).Value.ToString())
'datatype integer
desc = Me.DataGridView1.Rows(i).Cells(5).Value.ToString()

Show error in these two lines

I created setup on Windows 7 targeting x86 machine and when Install it on a windows XP machine then it gives the error.

and yes the Proper .net framework is installed.

Exception detail is below:

System.NullReferenceException was unhandled
HResult=-2147467261
Message=Object reference not set to an instance of an object.
Source=POS_test
StackTrace:
at POS_test.frmCustomer.addrec() in D:\Projects\vb.net\POS_test\POS_test\frmCustomer.vb:line 13
at POS_test.frmCustomer.btnAdd_Click(Object sender, EventArgs e) in D:\Projects\vb.net\POS_test\POS_test\frmCustomer.vb:line 5
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at POS_test.My.MyApplication.Main(String[] Args) in :line 81
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:

Dear thanks for the reply but I get the error in the line before the Identity line which is cmd.ExecuteNonQuery(), and even if I remove the code for the 2nd table I get error in the same line.