Search:

Type: Posts; User: hlsc1983

Page 1 of 5 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    0
    Views
    7,023

    Gridvalueat function in CR

    k i am trying to suppress a field using this line

    if GridValueAt(CurrentRowIndex, CurrentColumnIndex, 0) > 0 then true

    But i get the error like this: A number, currency amount, boolean, date,...
  2. get values from database based on the result of a query

    I have a query that gives me this result:


    select Students.student_rollno, Subjects.subject_name ,Gradetype.grade_id, TheoryPractical .ThPr_name, EndtermProgressive. ETPA_name, marks
    from...
  3. Replies
    0
    Views
    4,382

    marksheet using crysal reports

    Hi .Please help me solve this problem.
    I need to design a marksheet using crystal reports in this format:

    146169




    I have a table called Subjects that store details about each subject:
  4. Replies
    1
    Views
    513

    unable to generate crystal reprt

    I am trying to generate a crystal report using the following code.
    my dataset is named Dataset1 with a datatable containing two columns (marks, subject_id) .But my crystal report is blank. it does...
  5. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    Have you ever needed to use rows that are deleted(with D values?) ?
  6. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    Sorry for the delay. Can yoube more specific about letter status field? can you give an example?
  7. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    so Delete statements will actually be replaced by Update statements? and the status field is a Boolean ? or foreign key to AddDrop table?
  8. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    k wont it create too many unwanted columns in the table? i am thinking of given the permission to delete Institutes , Departments and Subjects only to the admin? what do you think?
  9. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    i think there is some difference between our education systems. Here a student can belong to only one department. so if i delete a department logically the students must also go since they would be...
  10. Replies
    17
    Views
    2,902

    Re: delete rows from multiple tables

    yes Cascading Deletes are i think one way of doing it. But i wanted some expert advice on this. Since i am not sure if Cascading Deletes have other ramifications. I will wait for some more input.
  11. Replies
    17
    Views
    2,902

    [RESOLVED] delete rows from multiple tables

    I have the following tables:

    Departments
    Students
    Subjects
    Institutes
    Departments_Subjects_junction(department_id,subject_id)
    Institutes_Departments_junction(institute_id, department_id)
    ...
  12. Re: how to get value member of item in checklistbox

    k this is working for me but i guess its not what you were talking about since you mentioned columns. Still i would like to know what you were talking about


    For i As Integer = 0 To...
  13. Re: how to get value member of item in checklistbox

    i know of another approach like this which works for checked items but it is not sufficient since i need to do something if items are not checked as well ( please refer my first post)



    ...
  14. Re: how to get value member of item in checklistbox

    How can i get the value member from the item. ? (the values are sourced from the table in sql server. by value member i am referring to the primary keys in the table)

    this is how i am populating...
  15. [RESOLVED] how to get value member of item in checklistbox

    This is my code. 'XXXXXXX' is supposed to be the value member of item in checklistbox, but i dont know how to get it. What am i supposed to write there?


    For i As Integer = 0 To...
  16. Re: how to enable or disable controls based on user account

    k then i should delete the coulm type and enter a new column , say IsAdmin of type Boolean?
    and i dont get these two lines( i will go for the former since it looks simpler)


    isAdmin =...
  17. how to enable or disable controls based on user account

    i have table called Users in sqlserver , with three columns: Username, Password and Type(integer).
    'Type' is identity column .
    The username 'admin' has Type value as 1 and other users have 2,3,.......
  18. Re: (update) versus (delete and insert)

    thank you all for assisting. i shall opt for 'update' option. Btw how does delete + insert cause fragmentation and how serious is it?
    (and yes my system will be used concurrently by at most ten...
  19. Re: (update) versus (delete and insert)

    k this is the code to insert the data in the first place.


    Private Sub addCheckedDepartments()
    Dim cmd As New SqlCommand("select subject_id from Subjects where subject_name='" &...
  20. Re: (update) versus (delete and insert)

    what i have shown above is the edit form. the user may decide to uncheck some departments for a subject and also add some new ones. therefore in the table above there may be new additions, and...
  21. Re: (update) versus (delete and insert)

    k i have a table DepartmentSubject with two columns department_id and subject_id(both are foreign keys).
    145119

    145121
    Now there is a form which will allow the user to edit the Departments for a...
  22. [RESOLVED] (update) versus (delete and insert)

    has anyone ever had to use delete and insert rows instead of updating them because I am facing it right now? Is it necessary sometimes or downright stupid to do so?
  23. Re: how to check items in check list box during run time based on values in database?

    thanks. this is working now.!!


    For i As Integer = 0 To ChkLstBoxDept.Items.Count - 1
    ChkLstBoxDept.SetItemChecked(i, False)
    Next


    Dim cmd As New SqlCommand("...
  24. Re: how to check items in check list box during run time based on values in database?

    thanks for structuring it better.
    let me try to make things clearer. I have entered the values from before using another form. what i am trying to do in this form is retrieve those values.
    your...
  25. Re: how to check items in check list box during run time based on values in database?

    i have tried this but its not working



    Dim cmd As New SqlCommand(" select department_id , subject_id from Departments_Subjects_junction where subject_id = @sid ", con)
    ...
  26. how to check items in check list box during run time based on values in database?

    there is a junction table called DepartmentSubject with only two keys- subject_id and dept_id. Both are foreign keys. In my form , i have a textbox that allows the user to type and enter the subject...
  27. Re: How to populate listview from multiple datatables?

    That pivot query works like a charm... thanks
  28. Re: How to populate listview from multiple datatables?

    hi ..which are the items and their subitems that i am supposed to add to the listview??
  29. Re: How to populate listview from multiple datatables?

    Thanks.. I will try it and get back to you later. Right now my p.c is not with me. Hearing about dictionary for the first time.
    I would also love to learn about the other methods also. Please tell...
  30. Re: How to populate listview from multiple datatables?

    There may be a maximum of four grade types... but the number of grade types differ from one subject to another. So the answer is no. That's the reason why I have a Gradetype table with gradeid as key...
  31. Re: How to populate listview from multiple datatables?

    Yes I have multiple tables but all the data I need in my list view is in this Marks table.
    I don't understand how other tables would be of any use here. For eg, Subjects table contain only two...
  32. Re: How to populate listview from multiple datatables?

    Sorry... yes I forgot to add " from Marks" .
    And we have only only table here.
    Are u talking about multiple datatables?
  33. Re: How to populate listview from multiple datatables?

    K I can get the rows using a query like this:


    Select subjectid, studentid, grade where studentid= studenttxt.text and subjectid= subjecttxt.text

    After that what???
  34. [RESOLVED] How to populate listview from multiple datatables?

    I have a table MARKS with these columns: it's used to store students grades/marks

    Studentid int as foreign key ,
    Subjectid int as foreign key,
    Grade int,
    Gradetype int as foreign key,
    Grade_pk...
  35. how to generate a report from a datatable?

    i have a datatable with the following columns:
    StudentId,
    StudentName,
    DateofBirth,
    Category.

    I wish to make a report using Crystal Vision Reports that will show the following: Number of...
  36. Replies
    1
    Views
    477

    whats the algorithm used here?

    my application uses this query to find duplicate entries in a table . I want to know what kind of algorithm is used here.


    SELECT * FROM Students s join (select student_fullname, student_dob ...
  37. [RESOLVED] reduce number of lines of code

    Please help me compress/ reduce the no of line of this code. This is the format i use to retrieve a single value from the table.



    Private Sub enterBtn_Click(ByVal sender As System.Object,...
  38. Re: how to get label to display selected item in combobox

    Oh yes... it is set to dropdownlist
  39. Re: how to get label to display selected item in combobox

    k got it. it was so simple. all this while i have been using this


    rcLbl.Text = rcCb.SelectedText

    now
    rcLbl.Text = rcCb.Text gives the desired result

    But i wonder why selectedtext is...
  40. Re: how to get label to display selected item in combobox

    i actually want the label to display the text when i click a command button like i said in the beginning
Results 1 to 40 of 198
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width