Comments by shonezi (Top 150 by date)

griff I was stupid, your code works and it works great, here is what happened, i used in openfiledialog as you can see, a openFileDialog2.SafeFileName and with it I got just the name of the file while path was defined, but when changing location it doesnt work, I changed the openFileDialog2.SafeFileName to openFileDialog2.FileName; and now it works,

only thing is I need to save documentName just as documentName, I don't want all that path to be saved

but YOUR CODE WORKS< AND I AM SORRY FOR MY IGNORANCE

thank you griff (not the first time you helped me, probably not the last :)

sorry, i wasnt online, had to relax my mind :))) the problem is definitelly in line

if (!string.IsNullOrWhiteSpace(path) && File.Exists(path))

File.Exists(path) to be exact, in that the path gets lost of anything but the last item

but I am gonna run debugger now

but how to solve the problem griff

I placed a breakpoint on string path = item.Text; and the it showed only path of the last item in listview???? while on line
if (!string.IsNullOrWhiteSpace(path) && File.Exists(path))\
it showed the path to first item in listview????

aaaaaaaaaaaaaaaaaa

ok, here it is

foreach (ListViewItem item in listOfLoadedFiles.Items)
{
here it shows all items in listview, count is ok
}

but after this line

if (!string.IsNullOrWhiteSpace(path) && File.Exists(path))
{

HERE IT SHOWS ONLY LAST ITEM

byte[] data = File.ReadAllBytes(path);

long length = new FileInfo(path).Length;

string extension = Path.GetExtension(path);


}

I am definitelly doing something wrong, it counts alright, maybe it doesnt loops once, ah man I am frustrated

I placed path where you said already :) thank you , let me try this what you said about listview

it loops only once

when I save files from same folder it's ok,all saved, but when saving from different, only the last one in the list is saved

is this ok?

first did I implented the code corectly

if (listOfLoadedFiles.Items.Count != 0)
{


foreach (ListViewItem item in listOfLoadedFiles.Items)
{
string path = item.Text;
if (!string.IsNullOrWhiteSpace(path) && File.Exists(path))
{
byte[] data = File.ReadAllBytes(path);
long length = new FileInfo(path).Length;
string extension = Path.GetExtension(path);

daData2.InsertCommand = new SqlCommand("INSERT INTO Documents VALUES (@Documents, @patternID, @userID, @documentName, @extension)", cs);

daData2.InsertCommand.Parameters.Add("@Documents", SqlDbType.VarBinary).Value = data;
daData2.InsertCommand.Parameters.Add("@patternID", SqlDbType.NVarChar).Value = patternID.Text;
daData2.InsertCommand.Parameters.Add("@userID", SqlDbType.NVarChar).Value = ID.Text;
daData2.InsertCommand.Parameters.Add("@documentName", SqlDbType.NVarChar).Value = item.Text;
daData2.InsertCommand.Parameters.Add("@extension", SqlDbType.NVarChar).Value = extension;

cs.Open();
daData2.InsertCommand.ExecuteNonQuery();
cs.Close();
}
}

}
else
{

}

I did what you suggested but I get only last file in listview added to sql

openfiledialog instead of folderbrowser, sorry

that's all the code I have
Load files into listview, and save

public byte[] ReadDoc(string document)
{
byte[] DocData = null;
DirectoryInfo dirInfo = new DirectoryInfo(document);
foreach (FileInfo f in dirInfo.GetFiles())
{
long DocFileLength = f.Length;
FileStream fs1 = new FileStream(document, FileMode.Open, FileAccess.Read);
BinaryReader br1 = new BinaryReader(fs1);
DocData = br1.ReadBytes((int)DocFileLength);
}

return DocData;

}

private void btnSave_Click(object sender, EventArgs e)
{
if (listOfLoadedFiles.Items.Count != 0)
{
byte[] fileData = null;

foreach (ListViewItem item in listOfLoadedFiles.Items)
{

string extension = Path.GetExtension(item.Text);

fileData = ReadDoc(item.Text);

daData2.InsertCommand = new SqlCommand("INSERT INTO Documents VALUES (@Documents, @patternID, @userID, @documentName, @extension)", cs);

daData2.InsertCommand.Parameters.Add("@Documents", SqlDbType.VarBinary).Value = fileData;
daData2.InsertCommand.Parameters.Add("@patternID", SqlDbType.NVarChar).Value = patternID.Text;
daData2.InsertCommand.Parameters.Add("@userID", SqlDbType.NVarChar).Value = ID.Text;
daData2.InsertCommand.Parameters.Add("@documentName", SqlDbType.NVarChar).Value = item.Text;
daData2.InsertCommand.Parameters.Add("@extension", SqlDbType.NVarChar).Value = extension;

cs.Open();
daData2.InsertCommand.ExecuteNonQuery();
cs.Close();

}

}
else
{


}

you right, ok, this is what I am trying to do

I am saving files to sql server,

I have a form with btnSave, listview (listOfLoadedFiles), btnLoadFiles, folderbrowserdialog,

on btnLoadFiles click event I have this code, which works

openFileDialog2.InitialDirectory = System.Environment.GetFolderPath(Environment.SpecialFolder.Personal);
openFileDialog2.Title = "Insert document";
openFileDialog2.FileName = "";
openFileDialog2.Filter = "All Files|*.*";

IntPtr hImgSmall; //the handle to the system image list
//IntPtr hImgLarge; //the handle to the system image list
string fName; // 'the file name to get icon from
string fName1;
SHFILEINFO shinfo = new SHFILEINFO();

listOfLoadedFiles.SmallImageList = imageList1;
listOfLoadedFiles.LargeImageList = imageList1;

//openFileDialog1.ShowDialog();

if (openFileDialog2.ShowDialog() != DialogResult.Cancel)
{
listOfLoadedFiles.BringToFront();
listView1.SendToBack();


fName1 = openFileDialog2.SafeFileName;
//Use this to get the small Icon
hImgSmall = Win32.SHGetFileInfo(fName, 0, ref shinfo, (uint)Marshal.SizeOf(shinfo), Win32.SHGFI_ICON | Win32.SHGFI_SMALLICON);

//Use this to get the large Icon
//hImgLarge = SHGetFileInfo(fName, 0,
// ref shinfo, (uint)Marshal.SizeOf(shinfo),
// Win32.SHGFI_ICON | Win32.SHGFI_LARGEICON);

//The icon is returned in the hIcon member of the shinfo struct
System.Drawing.Icon myIcon = System.Drawing.Icon.FromHandle(shinfo.hIcon);

imageList1.Images.Add(myIcon);

//Add file name and icon to listview

listOfLoadedFiles.Items.Add(fName1, nIndex1++);


}
so here I have loaded files to listview and on btnSave need to save them into sql server, when I choose files from same folder everything works fine, because as you said, the path is the same for all files, and the problem you already know

thank you Griff, you are right with all your questions. how can I change my ReadDoc code (please help me, I am in dead end)

THANK YOU< THANK YOU, THANK YOU!!! it works!!!

friend recommended it to me, because on my main form I have bound that string Nesto with datatable (filled with data from sql server) but the data from Nesto has to be avaliable to every form I have, and now I have problem with actually calling the class with that filled data.

yes, yes, singleton design pattern, I forgot the name :) I want to use that string on each form which will be filled with data on main form, so with this design pattern I want to have that data on each form, but I dont know how to call it

since I am amateur, I will just say thank you both :) :) :) :)

:) guess I asked to much ::) :) :) thanks Griff

It says Rows don't hold definiton for action Any

THANK YOU GRIFF!!! just to ask, is there a possibility to place if question in get set property of the class that I have of the username, just wondering

thank you very much :)

well I don't know how to call this method on another form and I want to avoid writing entire code on each form. that's my problem actually :)

thank you

thank you, it was my mistake what I did, I was so totally lost I havent even noticed I was making new question instead should have continued on this one.

I am sorry, this is what I am trying to do, I have table variables in Sql Server, with columns Main, Data and DataDetails

I want to get values from those columns by specific ID in strings on my form. I dont want to bind textboxes to it but I want to in sort of speak bind them with strings, and I dont know what to do

obviously I am stupid. that's why I posted here my problem, I am trying to get @Main, @Data, and @DataDetails values to those strings up there

I tried this, but it's all empty

SqlCommand command = new SqlCommand("SELECT * from Variables WHERE ID = @ID", cs);
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters["@ID"].Value = Main.pattern3.Text;

cs.Open();
command.ExecuteNonQuery();

command.Parameters.AddWithValue("@Main", main);
command.Parameters.AddWithValue("@Data", amenu);
command.Parameters.AddWithValue("@DataDetails", amenu1);
command.Parameters.AddWithValue("@DataActivities", amenu2);
command.Parameters.AddWithValue("@DataHistory", amenu3);
command.Parameters.AddWithValue("@Storage", bmenu);
command.Parameters.AddWithValue("@StorageDetails", bmenu1);
command.Parameters.AddWithValue("@StorageActivities", bmenu2);
command.Parameters.AddWithValue("@StorageHistory", bmenu3);


cs.Close();

main, amenu, amenu1, amnenu2, and so own are strings, but I get all empty values

my bad, its working, i made a mistake on button click which triggers this code, sorry

now I get error on im = Bitmap.FromStream(ms) Cannot implicitly convert System.DrawingImage to User.Image

and on image1.Image = im I get cannot implicitly convert User.Image to System.drawing.Image :D :D :D

it doesnt work

thank you, sorry for stupid question, but my brain has left me this morning :P

thank you :)

THANK YOU!!!!!!!!!! I thought something like that might be the issue but NO CLUE HOW TO SOLVE IT.. THANK YOU!!!!

things is I dont get exception message, it just stands that, with nothing happening

I just added rct.Width = 240; sorry for the trouble and asking stupid questions

yes mate, sorry I didnt reply,thank you again

I found a problem, code works, its something I did that makes those columsn show up:))

50 percent :)))

I have modified my code to this and it works 500 percent because half of the columns that are hidden in dgv are hidden in exported xml, BUT I have a strange thing also shownand that is that I have 17 columns which are hidden but headertext also gets exported???????and I dont know what to do


DataTable dt = new DataTable();

dt.TableName = "MyTable";
foreach (DataGridViewColumn col in dg1.Columns)
{
dt.Columns.Add(col.HeaderText);
}
foreach (DataGridViewRow gridRow in dg1.Rows)
{
if (gridRow.IsNewRow)
continue;
DataRow dtRow = dt.NewRow();
for (int i = 0; i < dg1.Columns.Count; i++)
if (dg1.Columns[i].Visible)
dtRow[i] = (gridRow.Cells[i1].Value == null ? DBNull.Value : gridRow.Cells[i].Value);
dt.Rows.Add(dtRow);
}

DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml(saveFileDialog1.FileName);

I did mate and I cant get it running on this code :)))

I have this

for (int i = 0; i < dg1.Columns.Count; i++)
{
if (dg1.Columns[i].Visible)
{
//code
}
}
but its not working

how to do this???

I also added your addition to code after foreach (DataGridViewRow dr in dg1.Rows)
thank you a lot!!!!!!!!!!

thank you, works great

aaaa mousedown, and i was on mouseclick...thanks a lot mate, thank you 5+ :)))

I tried with flowlayoutpanel and it worked fine, maybe it's because of the richtextbox that it doesnt work

I tried this but nothing again

it says on ListItem that I am missing a directive or assembly reference????

I wonder if maybe the problem is that the mailFrom address that I use to send mail from is not used on this PC, or better said it is not created account in outlook on THIS PC that I am on

I found this code on net , somebody also had the same problem

string attachments = attachment.Text;

char[] separator = {';'};

string[] myattach;

myattach = attachments.Split(separator);

if (attachments != null)

if (attachments.Length != 0)
foreach (string str in myattach)
{
if (str.Trim() != "")
{
mail.Attachments.Add(new Attachment(Path.GetFullPath(str)));

}
}

and on THIS ONE I get failure in sending mail????

system.mail.attachment.attachment(string) has some invalid arguments

with additional one, it says on (new Attachment(attach)) part that there are some invalid arguments

sorry, I did something, i dont know what, but anyway when I made the change you suggested it still says the same error

I get failure in sending mail

I misstyped, and you are write, thank you

Thanks Santhos!!! I am such a begginer :)

THANK YOU VERY MUCH DYLAN, I have been going lef and right , up and down busting my head with this, thank you, thank you!!!!!

same error again, whats wrong Mohamed with this, it should work

nothing happens

good idea

thank you, and thank you TR and Wes Day :))

well, you are totally right so I did this, I placed all of the code with stopwatch to Shown event, to raise it just once on form load and its 0 miliseconds, works fast. maybe this is ok, is it?

I am a little lost on this one

how to do that??

yeah you are right, all of you, I am reformatting all the time, how to stop this and make it just once

I did what you suggested, I get around 300 miliseconds response at start, but when it finishes populating it shows 6. problem is also that when I scroll up and down the datagridview it is also slow

this is great, I am currently trying to learn WPF but really am just a begginer. thank you

Thank you both :)))

THank you very much, very helpfull, thank you again

I copied it but still the same, and I thank you a lot friend, Sourav Sarkar-SS managed to solve it, basically the same code as yours with modificationn but many thanks to you as well

same thing, empty spaces are still there

still the same

this works, just one thing, I have empty spaces between rows in listbox like this

empty
1
empty
2
empty

while it should be
1
2

this code is for passing listbox to textbox but I need textbox to listbox but the problem is I have in textbox this ,1,2, and I want in listbox to add 1 and under it in second row of listbox 2

I have no code

THANK YOU!!!!!!!

daPattern.SelectCommand = new SqlCommand("SELECT * from Pattern", cs);
dsPattern.Clear();
daPattern.Fill(dsPattern);

PatternBS.DataSource = dsPattern.Tables[0];


listpatternID.DataSource = PatternBS;
listpatternID.DisplayMember = "ID";

I did this but nothing, again the same

it says

object does not contain a definition for text and no extension method text accepting first argument of type object could be found (are you missing a using directive or assembly reference?)


I have these using directives

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using User.Properties;
using System.Data.SqlClient;

problem is I know nothing about wpf, I know I know, I am just another fool trying to get something without basic knowledge of about it and it's frustrating to deal with those like me. but this xaml is totaly unknown to me for now, I just need the code for binding textbox to sql server table column and that's it.

and this also worked, thank you all

I dont know what I did, but now it works :)

this su....cks.....again the same thing

ok, I am going from the beggining.....I am adding DataSet

well, thats the problem, I dont how, because I wrote it JUST THE SAME when it worked, so I am buffled

how to solve this now

doesnt exist??? but how

first time when I did this when it worked and I typed DataReport it was normally in black color of font and after dot Clear could be typed

DataReport is DataSet I created, its there in solution tree with extension xsd

that's the problem, it did work but then I made the exact same code, everything and now when I type DataReport it highlights and I have no extension Clear on it, I cant type it???

I have no idea what is that

it says an object reference is required for non-static field, method or property System.Data.DataSet.Clear();

it says I dont have object reference, but it worked before????

I restarted, same thing, I am puzzled, it worked now it doesnt, and I have done everything the same, maybe it is something in properties

I have a windows form application in C#, the code on form load is

daActivity.SelectCommand = new SqlCommand("SELECT * from DataActivity", cs);
dsActivity.Clear();
daActivity.Fill(dsActivity);

ActivityBS.DataSource = dsActivity.Tables[0];

dg.DataSource = ActivityBS;

this.dg.Sort(this.dg.Columns["DataInputID"], ListSortDirection.Descending);

where dg is datagridview that I have on my form, as you can see I fill dg from Sql Server, and it is sorted by first column in dg called DataInputID

this DataInputID is the same for multiple rows and I want to group them, being able to expand that group
I have looked on the google and found some solutions but was unable to implement them into my form, because most of those solutions are for asp.net

while I have simple basic windows form application that pulls data from Sql Server

unfortunately I am working in windows form application, not WPF

no, nothing, I do an export but those columns that I made invisible
are exported also

I tried but its not working

it's not working properly, it doesnt show contents of each cell that I hover over

I dont want to type in text of tooltip, I want that tooltip shows text which is in the cell

my bad , it works with loaded binding source, not the one I made myself. THANKS!!!!

I did put the brackets, I saw it but still the same message

it says it cant intepret token on position 14 and 26????

works!!!!!!!!!!! THANKS A LOT MATE!!!!!!!!!

ok, how do I do that, I mean the code?

this is ok but I always get zero at the end because newVal = 0, it doesnt change to to next number upon adding data

I did put it already mz username string inside it, I just refered to textbox as example also :)))

it doesnt work

it says I cant put argument as textbox1.Text in login code.

Hello, thanks for the answer, but I have a problem, login form runs on application run so only when I type in correct username and password does the start form opens up, and on this start form I have textbox where I want to see logged in user. I did what u told me but nothing happened, I still don't see the username in textbox????

I did this but it says that GlobalState doesnt exist in current context

sorry I havent explained better, I have login form with textbox username and I have main form with also textbox username, in this main form I want to see username that is logged in, I have done what you said and the code is ok, just I need how to see on main form in textbox the name of logged user
tthanks

I did what you said, but tell me this txtUserName.Text refers to login form or on another form where I have textbox in which I want to see who is logged on

I am new to visual studio, can you if you don't mind be little specific in code please

when logged in it opens another form, not showdialog but
form2 frm = new form2();
frm.Show();

that code

on wrong user,pass
opens window it says
ATMDataSet.users.KorisnikLozinkaString(Korisnik,Lozinka) could not be previewed.
Parameter ?_1 has no default value.

well it returns row with the proper user, I mean it works because if I type wronf entry it doesnt return anything

public virtual global::System.Nullable<int> KorisnikLozinkaString(string Korisnik, string Lozinka) {
global::System.Data.OleDb.OleDbCommand command = this.CommandCollection[1];
if ((Korisnik == null)) {
command.Parameters[0].Value = global::System.DBNull.Value;
}
else {
command.Parameters[0].Value = ((string)(Korisnik));
}
if ((Lozinka == null)) {
command.Parameters[1].Value = global::System.DBNull.Value;
}
else {
command.Parameters[1].Value = ((string)(Lozinka));
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
command.Connection.Open();
}
object returnValue;
try {
returnValue = command.ExecuteScalar();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
if (((returnValue == null)
|| (returnValue.GetType() == typeof(global::System.DBNull)))) {
return new global::System.Nullable<int>();
}
else {
return new global::System.Nullable<int>(((int)(returnValue)));

namespace ATM
{
partial class Login
{
///

/// Required designer variable.
///

private System.ComponentModel.IContainer components = null;

///

/// Clean up any resources being used.
///

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}

#region Windows Form Designer generated code

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.usersTableAdapter2 = new ATM.ATMDataSetTableAdapters.usersTableAdapter();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(182, 69);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(44, 13);
this.label1.TabIndex = 0;
this.label1.Text = "Korisnik";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(182, 96);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(44, 13);
this.label2.TabIndex = 1;
this.label2.Text = "Lozinka";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(244, 66);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 20);
this.textBox1.TabIndex = 2;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(244, 93);
this.textBox2.Name = "textBox2";
this.textBox2.PasswordChar = '*';
this.textBox2.Size = new System.Drawing.Size(100, 20);
this.textBox2.TabIndex = 3;
this.textBox2.UseSystemPasswordChar = true;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Arial", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.Location = new System.Drawing.Point(137, 275);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(276, 18);
this.label3.TabIndex = 41;
this.label3.Text = "SEKTOR ZA TELEKOMUNIKACIJE";
//
// button1
//
this.button1.Font = new System.Drawing.Font("Arial", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(185, 136);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(159, 32);
this.button1.TabIndex = 42;
this.button1.Text = "OTVORI";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//

this is form called Login with two textboxes and button, I have another form which I want to to open when typing in proper username and password click on button to open. I am new to C# and visual studio.

namespace ATM
{
public partial class Login : Form
{
public Login()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{

dynamic login = this.usersTableAdapter2.KorisnikLozinkaString(textBox1.Text, textBox2.Text);

{
if (login == null)
MessageBox.Show("Wrong entry");

}

}


}
}

SELECT COUNT(*) AS Result, Korisnik AS KorisnikInput, Lozinka AS LozinkaInput
FROM users
GROUP BY Korisnik, Lozinka
HAVING (COUNT(*) = 1) AND (Korisnik = ?) AND (Lozinka = ?)

Ok I have done this:

My datasource is accdb 2007 database, in it I have a table called users with simple 3 columns: ID, username, password

I open dataset which was created based on datasource
and I built query

SELECT COUNT(*) AS Result, username AS usernameInput, password AS passwordInput
FROM users
GROUP BY username, password
HAVING (COUNT(*) = 1) AND (username = ?) AND (password = ?)

and this works fine

then on login form in code of button which has to be clicked for logging in after correct input of username and password I have this:

private void button1_Click(object sender, EventArgs e)
{
dynamic login = this.usersTableAdapter2.usernamepasswordString(textBox1.Text, textBox2.Text);

usernamepasswordString is the name of the query I first mentioned nad textBox1 and textBox2 are two textboxes on login form, textBox1 is for input username and textBox2 is for input password

and here I am stuck because I want when clicked on this button to open another form or to start working on application better said but I am stuck with the code, any help

another froms name is ATM

I got it

SELECT RB, Bankomat, Datum_otvaranja, Vreme_prijave, ProView_vreme, Naziv_dogadjaja, Preduzeta_mera, Napomena FROM dnevni_izvestaj
WHERE Datum_otvaranja BETWEEN ? And ?

and I joined code on datetimepicker

DateTime Datum_otvaranja = dateTimePicker1.Value;
DateTime Datum_otvaranja1 = dateTimePicker2.Value;


because in SQL I have put question mark ? that made Datum_otvaranja and Datum_otvaranja1

anyway , it works, thanks a lot mate

OK I did this

SELECT RB, Bankomat, Datum_otvaranja, Vreme_prijave, ProView_vreme, Naziv_dogadjaja, Preduzeta_mera, Napomena FROM dnevni_izvestaj
WHERE Datum_otvaranja BETWEEN ? And ?

and I got what I wanted but I just need to put code on the button to generate report and I am in a jam

I am still in a jam, maybe I didn't explain it well, this is what I want: I have a table called dnevni_izvestaj, in that table I have a date column called Datum_otvaranja, this table is OLE DB from access 2007 as datasource. I have a form with reportviewer, two datetimepickers and a button, I have dataset with imported table dnevni_izvestaj on it. I choose dates from those datetimepickers and then clicking on button to open report based on chosen dates. sql is in dataset and I am stcuk, I am a newbie in visual studio, but I worked in access although no help with access sql in visual :)

I have trouble with this parameter queries cause code from above is in dataset from which report was made

I will look on it later, and let you know. thanks a lot

It's OleDb connection, so how does the code should look like?

last question and then I am gone :)) defining date parameters , I need help on code. so I have two dateTimePickers: dateTimePikcer1 and dateTimePicker2, how does this code looks like
dateTimePicker1.Value
dateTimePicker2.Value
????

ok, just one thing, those two date parameters are dateTimePikcers???

ah sorry, now I know what you meant, I do have designed RDL but I just want to display those data by dates when I choose which one, I mean between dates

I know I have put to much questions and perhaps you already are annoyed by me, but if I only have this what I have how can I make this work, what would you do, step by step if you don't mind.
one table, two datetimepickers, button.... choosing from date to date clivk on buton opens report, how would you do it easiest way

I can't see report Dtat pane in Visual studio 2010 on which I am working, and I work in C#

basically I have
table DailyReport with columns RB, Bankomat, DatInput
and I everyday write some data in and have dates
and I want report to open generated by dates, that's it

yes, I used dataset and assign them to report, and no I am not using SSRS report designer. and overiding button click on reportviewer I don't know what it means but I just have one button witht he code above in previous comment

ok1.I have table DailyReport
2.Dataset1 in which query is:


SELECT RB, Bankomat, DateInput, FROM DailyReport
WHERE DateInput BETWEEN @FromDate AND @ToDate

3. I use this Dataset1 for making Report1.rdlc which I use for reportviewer for generating report
4. above reportviewer is 2 dateTimePickers, one from and other to date, and the Button for generating report when I choose dates
5. in Button is code: private void button1_Click(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'DataSet1.DailyReport' table. You can move, or remove it, as needed.
this.DailyReportTableAdapter.Fill(this.DataSet1.DailyReport);

this.reportViewer1.RefreshReport();


I hope I have explained a little better how it looks like, I am quite new, but as I said , trying to learn :))

forgive me for asking but what does that mean to use query in SP or parameterized query???

I did this but when I click on finish I get error in WHERE clause near '@', so when I try preview data I get nothing, no parameters

I just can't get fill adapter to work for the table to generate report when I choose date in those two datetime controls because those datetime controls are not bound to the table. I am new to C# but eager to learn, I have a report, two datetime controls, one button, a table with primary column DateInput with dates, and I want when I choose dates and click on the button to generate report only for choose dates. I know I have to put some code in SQL for the report but I don't know how because those datetime controls are not part of the table