Search:
Type: Posts; User: hlsc1983
Search:
Search took 0.07 seconds; generated 57 minute(s) ago.
-
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,...
-
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...
-
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:
-
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...
-
Have you ever needed to use rows that are deleted(with D values?) ?
-
Sorry for the delay. Can yoube more specific about letter status field? can you give an example?
-
so Delete statements will actually be replaced by Update statements? and the status field is a Boolean ? or foreign key to AddDrop table?
-
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?
-
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...
-
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.
-
I have the following tables:
Departments
Students
Subjects
Institutes
Departments_Subjects_junction(department_id,subject_id)
Institutes_Departments_junction(institute_id, department_id)
...
-
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...
-
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)
...
-
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...
-
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...
-
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 =...
-
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,.......
-
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...
-
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='" &...
-
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...
-
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...
-
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?
-
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("...
-
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...
-
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)
...
-
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...
-
That pivot query works like a charm... thanks
-
hi ..which are the items and their subitems that i am supposed to add to the listview??
-
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...
-
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...
-
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...
-
Sorry... yes I forgot to add " from Marks" .
And we have only only table here.
Are u talking about 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???
-
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...
-
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...
-
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 ...
-
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,...
-
Oh yes... it is set to dropdownlist
-
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...
-
i actually want the label to display the text when i click a command button like i said in the beginning
|
Click Here to Expand Forum to Full Width
|