|
for (int m = 2; m < 8; m++) (There is only 01:00 and 02:00 hours, each of them consist 3 lessons)
{
for (int i = 3; i < 17; i++) (There is 17 students)
{
for(int j=2;j<8;j++){
switch (dataGridView1.Rows[2].Cells[m].Value.ToString())
{
case "Liquid Level":
for (int n = 2; n < 8; n++)
{
switch (dataGridView1.Rows[1].Cells[n].Value.ToString())
{
case "01:00":
formattedValue = dtPicker.Value.AddHours(3).ToString("yyyyMMdd HH:mm:ss");
date_stamp = formattedValue;
name = dataGridView1.Rows[i].Cells[0].Value.ToString();
surname = dataGridView1.Rows[i].Cells[1].Value.ToString();
lesson = "LL";
mark = dataGridView1.Rows[i].Cells[j].Value.ToString();
OracleCommand cmd = new OracleCommand("begin CPF_TANK_DATA_INSERT('" +
date_stamp + "','" + name + "','" +
surname + "','+lesson+','" +
mark + "'); END;", conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery()
case "02:00:
.....
....
}
}
}
}
But it gives an errors. Or puts more values. Where is mistakes?
|
|
|
|
|
sorry to say but that is very messy code, does your datagridview already contain the data exactly how you want it to be put in your database? you might want to look into using structs to store lesson info and student info too, that may help with things
If you have errors please post the error messages...
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
First of all, learn some things about variablenames.
I've been told that you could think for 10 minutes about a proper variable name, rather than 1 second for a bad one.
For instance:
for (int i = 3; i < 17; i++) (There is 17 students)
An iterator is fine and if you call it 'i' is sometimes fine to (it's intergrated in our system). But you say as a comment that there are 17 students.... why not call the variable students, or maybe better studentNumber or studentAmount?
Also about the commenting, maybe you allready do this, but you can better make a story in a comment above a function or some tough for loop in stead of writing some small parts behing some code. Do your outline first (in comments) and then start programming.
Don't use strange numbers.
Rather make this code:
int maxStudents = 17;
int minStudents = 3;
for(int studentNr = minStudents; studentNr < maxStudents; studentNr++);
than
for(int studentNr = 3; studentNr< 17; studentNr++);
But ontopic:
What kind of errors do you get?
I think you can't switch case with strings. It's only for numeric types like byte, int etc., at least I think so.
And you miss a lot of ';''s and break
|
|
|
|
|
Thanks for comments.
There is no error. Loops insert too many data,in to this procedure.
BR
|
|
|
|
|
I need to use one report with sub report i am using .Net Reporting.
The report is working without parameter from Master report to Sub Report
But when i pass the parameter to sub Report then it Give Error.
Is There Any Example or Tips Then Thanks
Best Regards,
Chetan Patel
|
|
|
|
|
Copy and paste your report to Bin/Debug Folder for the latest copy of the report because the application is running from that folder
Best Regards,
Chetan Patel
|
|
|
|
|
if you use crystalreport, you set the relation between mainreport and subreport, the crystalreport can work fine.
|
|
|
|
|
Hello,
i would get the name of file in directory, i use this :
<br />
files = Directory.GetFileSystemEntries(@"C:\Documents and Settings\Administrateur\Bureau\input");<br />
<br />
int filecount = files.GetUpperBound(0) + 1;<br />
for (int i = 0; i < filecount; i++)<br />
MessageBox.Show(files[i]);<br />
it show me the full name of my files like C:\Documents and Settings\Administrateur\Bureau\input\doc.txt, i would get doc.txt, thank you verry mutch.
|
|
|
|
|
You could use Path for that.
Like this:
Path.GetExtention(path);
Path.GetFileName(path);
|
|
|
|
|
i need to get all the names of files in a directory, thank you verry mutch.
|
|
|
|
|
then keep the for loop and use the path to get the name and put that name in a list or array
(sorry about the vb.net code but you can translate it)
files = Directory.GetFileSystemEntries(@"C:\Documents and Settings\Administrateur\Bureau\input")
Dim list as new list(of string)
For each s as string in files
list.add(io.path.getfilename(s))
messagebox.show(io.path.getfilename(s)
next
|
|
|
|
|
Off the top of my head I think you can do this:
string[] files = Directory.GetFiles( <path> )
...and I think files isn't fully qualified - ie. just the last bit you want. Not 100% without trying it though.
Regards,
Rob Philpott.
|
|
|
|
|
i try for this, but there are an exception :
string[] files = Directory.GetFiles(@"C:\Documents and Settings\Administrateur\Bureau\input");<br />
MessageBox.Show (files[0]);
Thank you verry mutch
|
|
|
|
|
You think the detail of that exception might be handy in solving your problem
|
|
|
|
|
try the following, using system.io;
DirectoryInfo di = new DirectoryInfo("FolderPath");
foreach(FileInfo file in di.GetFiles())
{
string name = file.Name;
string fullName = file.FullName;
}
//plus alot more useful properties
If only MySelf.Visible was more than just a getter...
A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting
|
|
|
|
|
hi,
i want to know how can i declare axhwinterface
assume
value= axhwinterfacei.input(888);
i wrote it in my code but the program make error on it
|
|
|
|
|
That's a 3rd parth component, which you obviously don't have. Where did you get the code?? Because, chances are, that'll also be the place to get the component you're missing (HWInterface).
|
|
|
|
|
i found it when i search in sites
the code contain two statement
val=axHwinterface1.InPort(888);
axHwinterface1.OutPort(888,(short)(val|2));
i searched more to find more information about it
but i didnot find any thing or how i can declared it for using
now i want to know how i can take information from
status register and make check on it(this check to tell me if parallel port free or not)
thanks
|
|
|
|
|
You need a third party library to do something like this. Google for "Logix4u" and you'll find one.
|
|
|
|
|
i downloaded hwinterface file system and i put it within project
but when i wrote this word in code made error (this name doesnot exist in the current text)i want to know if it want write something like(using system......)or not
|
|
|
|
|
If the .DLL you got is COM-based, then you can install it and add a reference to it.
If not, then you have to use PInvoke methods to get at the functions in the .DLL.
Just dropping the .DLL in your project folder does not make it magically work.
|
|
|
|
|
|
|
I think what you're asking is how to read a text file in C#? If so, add a textbox control to your form and a button, then double-click on that button and enter the following code:
StreamReader ReadFile = new StreamReader("C:\\MyTextFile.txt");
textBox1.Text = ReadFile.ReadToEnd();
ReadFile.Dispose();
Now that you've got the code to read from a text file, you need to add a using to the top of your document, add the following line to the top of the page:
using System.IO;
Hope this helps dude.
j.t.
j.t.
|
|
|
|
|
Hi,
I have to do a project on "Server Monitoring and Management using TCP and UDP"..Can you please send me any links or documents to give an idea about what does that actually mean and why is it necessary to do that....Please help me with this...thanks for any help in advance...
|
|
|
|