Comments by Member 8584763 (Top 146 by date)

There're copule of errors:

Error 2 'Microsoft.Reporting.WinForms.ReportViewer' does not contain a definition for 'DataBind' and no extension method 'DataBind' accepting a first argument of type 'Microsoft.Reporting.WinForms.ReportViewer' could be found (are you missing a using directive or an assembly reference?)

Error 1 The name 'Server' does not exist in the current context

Yes, I've but they're not talking about the problem that I face.

All I get so far is this.

string sql = "SELECT * FROM product where dat>='" + yy + "' and dat<'" + xx + "'and product_sold>0 and total >0";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, con);
DataSet5 ds = new DataSet5();
dscmd.Fill(ds, "product");
int l = 0;
string ll = Convert.ToString(l);
if (ds.Tables["product"].Rows.Count.ToString() == ll.ToString())
{
MessageBox.Show("لا يوجد تقارير ");
}
else

MessageBox.Show(ds.Tables["product"].Rows.Count.ToString());
Now, I want to pass to report viewer

All I get so far is this.

string sql = "SELECT * FROM product where dat>='" + yy + "' and dat<'" + xx + "'and product_sold>0 and total >0";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, con);
DataSet5 ds = new DataSet5();
dscmd.Fill(ds, "product");
int l = 0;
string ll = Convert.ToString(l);
if (ds.Tables["product"].Rows.Count.ToString() == ll.ToString())
{
MessageBox.Show("لا يوجد تقارير ");
}
else

MessageBox.Show(ds.Tables["product"].Rows.Count.ToString());
Now, I want to pass to report viewer

Yes, I know it's the same, but what am I trying to ask is how to pass query to report viewer?

I used to work CR, but now I can't the result on the report?

Yes it is code with install crystal report

Ye I have
What about your email can I send my project to you

The assembly are added automatic.

Can you send me your email to check it?

I'm confused, I thought x86 for Windows 32 cpu and x64 for Windows 64 cpu

Who can I distinguish between those assembly?

Well, I don't think all the assembly are x86 some of them are x64.

Because this problem don't occur when I deploy it for x64?
How can specify the assembly?

x86

I didn't understand your question?

There're as followings:

stdole.dll
log4net.dll
Microsoft.VisualC.STLCR.dll
CrystalDecisions.Data.AdoDontNetInterop.dll
CrystalDecision.Shared.dll
CrystalDecision.ReportSource.dll
CrystalDecision.ReportAppServer.Prompting.dll CrystalDecision.Enterprise.Viewing.ReportScource.dll

I tried to put "Any CPU" and for the deployment I put x64 it works, but when I put x86, it didn't work?

Do you think the problem is CR?

I used in my project x86 and for deployment I used the same x86.

when I used x64 and for deployment I used the same x64. It didn't give me any error, but I need it to work on x86?

That's when I get the error.

What's best for security? Professional?

For example I have table called product: productid, productname
My question is . Is it better to create class that has two sets and gets for the id and name then save it in the database? Or creat query for insert the id and name?

How to check it?

Yes

I changed it ANYCPU ,but still I'm getting the same message "This product is designed for x64 platform".

OK, but how to deploy it?

So, it'll be like sql server than but much smaller in size?

SqlCE, does it have a graphic interface?

What do you recommend. Because I need to access them. to backup the database or restore it ? Which one better?

If I use SQLCE. Will it give you the same funtion as sql server management?

Actually, it's a single user database, and I was planning to install sql server and sql server management on the client PC. After that, I'll install my app, but the problem what if the sql server didn't run. what other database I should use? I heard of Sqlserver compact?

The app can't run without it. How come it's their choice?

Ok, suppose that I did the setup to my app, then on client PC ,I should install sql server, if it's not exist? and do I need to install sql server management?

Nothing changes after commenting it?

Where to get the messing files

Crystal_Database_Access2003.msm
Crystal_Database_Access2003_enu.msm
Crystal_regwiz2003.msm
Microsoft_VC80_ATL_x86.msm
policy_8_0_Microsoft_VC80_ATL_x86.msm

Even I double click on it .It doesn't show anything?

what's the relevant code file? where to find it

there are the warnings:
Warning 1 Value does not fall within the expected range.
Warning 4 ResX file Value does not fall within the expected range. Line 128, position 5. cannot be parsed. 128 0
Warning 5 Could not determine the dependencies of the COM reference "CRQUERYENGINE". Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) pharmcy

No,the code works fine ,but when I open the design it gives this message
value doesn't fall within the expected range

the warning is value doesn't fall within the expected range line 0?

Still the same problem? What do you think?

<pre lang="c#">
namespace pharmcy
{
public partial class MDIParent3 : Form
{
// private int childFormNumber = 0;
SqlConnection con=new SqlConnection ();
SqlCommand cmd=new SqlCommand ();
int i=1;

string a = "l.bak";
string x = @"c:\SQLBackup\";

public MDIParent3()
{
InitializeComponent();
}

private void ShowNewForm(object sender, EventArgs e)
{
Sale s = new Sale();
s.MdiParent = this;
s.Show();
}

private void OpenFile(object sender, EventArgs e)
{
deleteproduct s = new deleteproduct();
s.MdiParent = this;
s.Show();
}

private void SaveAsToolStripMenuItem_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
saveFileDialog.Filter = "Text Files (*.bak)|*.bak|All Files (*.*)|*.*";
if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
{
string FileName = saveFileDialog.FileName;
}
}

private void ExitToolsStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}

private void CutToolStripMenuItem_Click(object sender, EventArgs e)
{
}

private void CopyToolStripMenuItem_Click(object sender, EventArgs e)
{
}

private void PasteToolStripMenuItem_Click(object sender, EventArgs e)
{

}

private void CascadeToolStripMenuItem_Click(object sender, EventArgs e)
{
LayoutMdi(MdiLayout.Cascade);
}

private void TileVerticalToolStripMenuItem_Click(object sender, EventArgs e)
{
LayoutMdi(MdiLayout.TileVertical);
}

private void TileHorizontalToolStripMenuItem_Click(object sender, EventArgs e)
{
LayoutMdi(MdiLayout.TileHorizontal);
}

private void ArrangeIconsToolStripMenuItem_Click(object sender, EventArgs e)
{
LayoutMdi(MdiLayout.ArrangeIcons);
}

private void CloseAllToolStripMenuItem_Click(object sender, EventArgs e)
{
foreach (Form childForm in MdiChildren)
{
childForm.Close();
}
}

private void backupToolStripMenuItem_Click(object sender, EventArgs e)
{
backup b = new backup();
b.ShowDialog();
}


public void backup()
{
string iii=".bak";
string xxx = dateTimePicker4.Text;
string y = Convert.ToString(i);
string format = ("yyyy-MM-dd");
DateTime f = Convert.ToDateTime(xxx);
string yy = f.ToString(format);
bool ii = true;
int number = 1;
x += yy;
x += iii;
bool bBackUpStatus = true;
Cursor.Current = Cursors.WaitCursor;
try
{
con.Open();
if (Directory.Exists(@"c:\SQLBackup"))
{
while (ii)
{
if (!File.Exists(x))
{
ii = false;
bBackUpStatus = true;
break;
}
else
{
y = (number + 1).ToString();
x += y;
bBackUpStatus = false;
}
}
/*if (File.Exists(@"c:\SQLBackup\wcBackUp1.bak"))
{
if (MessageBox.Show(@"Do you want to replace it?", "Back

Do you have a link or something .Because I searched and didn't find a thing?

I installed the runtime crystal report? will it be OK?

I just installed on the client pc, crystal report will work?

I tried this one

[STAThread]

static void Main()

{

//AddGlobalHandlers();

Application.EnableVisualStyles();

Application.SetCompatibleTextRenderingDefault(false);

//Application.Run(new MainForm());

Application.ThreadException += new ThreadExceptionEventHandler(Application_ThreadException);

AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);

Application.Run(new MainForm());

}

static void CurrentDomain_UnhandledException(object sender, UnhandledExceptionEventArgs e)

{

MessageBox.Show("CurrentDomain_UnhandledException: " + e.ExceptionObject.ToString());

}

static void Application_ThreadException(object sender, ThreadExceptionEventArgs e)

{

MessageBox.Show("Application_ThreadException: " + e.Exception.Message);

}

and it works

Thanks .

I tried to put try and catch ,but nothing happends
try
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new MDIParent3());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

There's no option about prerequisite in publish tab

When I installed the font on my PC. I tried using in notepad and it works, but when visual studio I tried to change the font propriety for a textbox ,it gave this message
only true type fonts are supported . what do you think the problem?

I installed it in window/font. Then in visual studio I chose the the font that I added and it gave me this message.
only true type fonts are supported

I did and it gave this message
only true type fonts are supported

how can I you add it to your project?

I read online if you have a barcode font you can apply it to the text the you have. But I've never used barcode font?
My question is how to use it?

how to can I use it?

I've barcode font how can I apply it to textbox?

I developing point of sale app and I need to print invoice and the invoice must has barcode which is invoice Id?

How can I convert invoice Id to barcode Image?

are you still there?

I already updated could you look at it?

still in this line
adp.Fill(tab);
it gives me
Conversion failed when converting date and/or time from character string.

Ok ,but now do you understand the question ?

I made i solution to explain

if it's possible it'll make you code easier.

if it's possible it'll make you code easier.

Well, it goes fine till this line
SqlDataAdapter ad1 = new SqlDataAdapter(cmd);
ad1.Fill(dy, "product");
it said Conversion failed when converting date and/or time from character string. and their data type in the database datetime?

copy error

cmd=new SqlCommand ( "SELECT dat , product_id FROM market where dat >= '" + fro + "' and dat<='"+to+"' ",con);
How to send from sqldatareader to dataset?

it's giving me the same results
in sql server
Product_id dat
101 2012-11-1
102 2012-11-1
in c#
product_id dat
100 2012-10-10
101 2012-11-1
102 2012-11-1

still the same problem it gives me all dates?

It gave me error in
ad1.Fill(ds1);
Conversion failed when converting date and/or time from character string.

in sql server
Product_id dat
101 2012-11-1
102 2012-11-1
in c#
product_id dat
100 2012-10-10
101 2012-11-1
102 2012-11-1

the date result it doesn't match up?

NO, it's the same format like in the database

where I took the code it was used like this
string from_date = Request.QueryString["fromdate"];
string to_date = Request.QueryString["todate"];

is there another way beside using this
string from_date = Request.QueryString["fromdate"];
string to_date = Request.QueryString["todate"];

I tried both of the methods, but it didn't work?

the website talks about datetime my data type is date?

how?

Well, I think the problem in the strings it doesn't recognize them. Because dat type is date.

Also, I found this code and did some changes on it ,but the problem is it gives me all the date?
private void button1_Click(object sender, EventArgs e)
{
string from_date = textBox1.Text ;
string to_date = textBox2.Text;
SqlConnection con=new SqlConnection (@"Data Source=.\Ahmed;Initial Catalog=Market;Integrated Security=True");
String data = "SELECT * from Product where dat>='"+from_date+"' and dat<='"+to_date+"'";
con.Open();
SqlDataAdapter ad1 = new SqlDataAdapter(data, con);
DataSet ds1 = new DataSet();
ad1.Fill(ds1);
ReportDocument cr = new ReportDocument();
cr.Load(@"C:\Users\Ahmed\Documents\Visual Studio 2010\Projects\WindowsFormsApplication9\WindowsFormsApplication9\CrystalReport4.rpt");

cr.SetDataSource(ds1.Tables["product"]);
crystalReportViewer1.ReportSource = cr;

}

I don't actually ,but if there using c# mainly?

is there another way?

using c# app

OK, thank you

what about sending to crystal report?

what about sending to crystal report?

It seems it like this ,but can I send this dataset to crystal report.
DataGridView1.DataSource = ds; // dataset
DataGridView1.DataMember = "TableName";

The solution post solved my problem, but when I tried MDI parent, the second form run in the empty space
But when I tried to another tool strip the second form runs behind the strip?

I tried MDI parent, the second form run in the empty space
But when I tried to another tool strip the second form runs behind the strip?

Thanks ,it worked. Is it possible the second form to be displayed in the first form like mdiparent?

Still the second one runs before the first one.

I think , the problem in the first step, when I did . I didn't do completely .Because there's no document to explain this step cause I'm using sql server 2012 the step is:
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

I tried login from client sql server to server sql server. using IP address of the server, I create user name and password for sql authentication, but still getting error code 184556. what do you think..

I changed server-pc, still getting the same error 18456

I did it all ,but it's the same message. what do you think is the problem..

I still get the same message .I'll try to change client PC to check...

I changed server name insted of ip address I put it the server name ,it give error 26

I changed the connection string to:
data source=192.168.1.100;initial catalog=supermarket;integrated security=true;uid=;pwd;timeout.
it said can't connect to the ipaddress. Error number 18456

it said can't connect to the ipaddress. Error number 18456

it said login failed ,the login from untrusted domain. I have , but the last part is not clear.

it said time out??

My connection string is a class which has my string connection:
internal static string x = @"Data Source=.\sqlser;Initial Catalog=SuperMarket;Integrated Security=True";

I trying to connect from c# to sql server.

yes, I can ping them both using fix IP address

I did exactly like you said, when I run the app it said there's not like userId

the first step is done , the second I download it ,but when I run it .It despair all the time.
My connection string is a class which has my string connection:
internal static string x = @"Data Source=.\sqlser;Initial Catalog=SuperMarket;Integrated Security=True";

finally , I manged to ping them , but still when I try connect my c# app to sql database server. it gives me the same message, what do you think is the problem?

I manged to make the client ping the server ,but the server doesn't ping the client , do you think it's because of the firewall?

Well, I put fix IP address for the server and fix IP address for the client , and I tried to ping the server from the client ,but it said request time out. they both have the netmask. and ip address just like you put them.
So , what do you think is the problem ?

I checked ,but it still the same , do you think I should put the server IP address in the client internet protocol?

OK, I should change the Ip address in client and put like the server IP, right?

I ping the server Ip from the client .It said time out

still the same

I did the three steps , still got the same problem

then I should use switch in that case

I used cat-6 in that case it won't work ,right?

just this is there a different If I connect them directly through cable or switch?

what do you mean exeption tab SQL-Browser and SQL-server exes is added.

it's said time out, could it be that I connect them directly.

yes

last step isn't clear
it will be easy to test
and also make sure that Firewall settings are configured properly (you have added exes in Exception-tab) and sql-agent service is running on server-pc

I tried a switch and connect them directly .
How to ping the server

I did almost exactly like it said in step one except

In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll. One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer. Right-click each address, and then click Properties to identify the IP address that you want to configure.

This time I connect them directly , I still get the same message

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

System.Exception {System.Data.SqlClient.SqlException}

the connection string is correct
-TCP/IP is enabled.
-firewall ,I did open a port for remote access.
-if I tried connect them directly will it make a different

what do you suggest?

This is my connection string:
internal static string x = @"Data Source=.\Ahmed;Initial Catalog=SuperMarket;Integrated Security=True";

in your function I'm using connection string not configuration manager

my app is desktop , will it be different

is it like remote access?

it's sql server.

i've c# app want to update and insert on database on different computer which has the database, and I connect to it though switch

Yes, I meant multi-users,

I've the basic ,but I'm confused whether to user client server database, or there
is another way? cause I'm not good client server and multithreading

any idea,come on

any idea,come on

even if I used a switch , the other computers and to access the central database.
Do I need server client app?

even if I used a switch , the other computers and to access the central database.
Do I need server client app?

I'm sorry for taking too long with you, but stock_code isn't null I checked.

I tried the debug mode, it gets caught in catch.

I think object sender.

If I put the hole code would it help?

system.nullreferenceexpception:object reference not set to an instance of an object
it's say in these line: in the call and in the condition of the function
exist = checking(stock_code);
if (dataGridView1.Rows[j].Cells[0].Value.ToString () == x.ToString ())

that's right, the call is inside try and catch. it's given me error like this
Object reference not set to an instance of an object. in catch

this function always gives me false, even if the value in the data grid view

not all code paths return a value

The problem that I want to call amount() when the event in the text box finshed. So the total will be right ,but now, it's giving me big numbers and the formal in amount() I think it's correct. So when I should call it?