I have checked port 1433.It is available in Client Network Utility. Maybe some security policies cause the problem. I'm so confused ...

It seem to be a solution or an answer.

Hi everybody, I have a following problem. My computer uses SQL Server 2000. I write my project on my local machine. I use Dataset to retrieve data from QLNS database. When I set up my project to other machine in LAN. I encounter this error while running exe file. "An error has occured while establishing a connection to the server. When connecting to SQL Server 2000, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider: Name Pipes Provider, error: 40 - Could not open a connection to SQL Server". Please kindly teach me how to solve this. Thank you very much. Hope your help.

It seem to be a solution or an answer.

I have a table named STAFF contains fields like STAFFID, FULLNAME, BIRTHDAY, SEX, PHOTO. I use BindingSource to update database. Initially, when I have no PHOTO field, updating database is successful. After that, when I add PHOTO field into STAFF table, the failure of updating database is due to having a following error "The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time." I have searched all helps but no article mentions it. Please kindly help me solve this error. Thanks in advance.

It seem to be a solution or an answer.

You need to make a ID field in Employee table from 1 to 20 Then do this Select * from tblEmployee where ID in [10,15]

It seem to be a solution or an answer.

Hi! You can use CrystalReport1.DataDefinition.RecordSelection = "Order = ..." to pass parameters you want Hope my help!

It seem to be a solution or an answer.

Good afternoon, I have a question that need your help When I summarized the monthly purchase orders(PO), I got my result effectively. But, when I show the names of selected POs in Page header, first I use Crosstab, it works well. Then, I realize that the crosstab will be limited when I provide more than 20 POs. I image about a string instead of Crosstab My problem is that if I combine the names of POs into a string and assign the string to X2 field. How should I do ? EX: The list PO can be shown PO1,PO2,PO3,PO4,.. I use Crystal Report in VS C# 2005 Sorry about my English. I will appreciate your help ! If I misunderstand problem, please kindly explain me well.

It seem to be a solution or an answer.

Hello eveybody! I have a small question need your help. My datagridview is bound with a dataset contains tblProduct table. A combox allows users choose a Product(B3700, NAPPLE 3'1, NAPPLE 3'2,...) If I filter like this tblProductBingdingSource.Filter = "Product = 'B3700'" . It works well If I repeat tblProductBingdingSource.Filter = "Product = 'NAPPLE 3**'**2'" , it fails to work because of existence of the quote mark. If I replace string "Product = 'NAPPLE 3'2'" with string "Product like 'NAPPLE 3%'", my grid will have this list of unexpected products such as NAPPLE 3'1, NAPPEL 3'2, NAPPLE 3'3,so on. When the users choose a value from combobox such as NAPPLE 3'2, I only have an only product, NAPPLE 3'2. Please help me correct the filtering string. I know the filtering string "Product like 'NAPPLE 3%2'" but the string is not general for all. Thanks in advance Sorry about my English.

It seem to be a solution or an answer.

Hello everybody! I have a small question. I don't know how to insert a null DateTime value into database. In my form, I have a textbox-based field named OrderDate. If the user doesn't set value of this textbox, when inserting, I consider the value 1/1/1900 is added to database unexpectedly. I don't like this, I like empty. How should I do to get empty in Database. Thanks in advance !

It seem to be a solution or an answer.

Hello everybody ! My question is quite stupid in Crystal Report but I need your help Carton | Goods name | Cube of Carton T1 | A | 0.15 //not suppressed T1 | B | 0.15 //suppressed T1 | C | 0.15 //suppressed T1 | D | 0.15 //suppressed T2 | E | 0.74 //not suppressed T2 | F | 0.74 //suppressed T3 | G | 0.86 //not suppressed ---Total (???)1.75 //not suppress I need to make a total of Cube of Carton (???). I only calculate the unsuppressed to ???. ??? will be exactly 1.75. When I make Running Total Fields, the ??? is 2.94 instead of 1.75 I need. Help me the exact formula Thanks in advance !

It seem to be a solution or an answer.

You can use CrystalReport1.DataDefinition.RecordSelectionFormula = "ID = " + value; CrystalReport1.Refresh();

It seem to be a solution or an answer.

I don't know whether you see datetime. If you store hour and minutes, why don't you make two SmallInt fields to store each you want. I don't think storing full datetime is useless. You completely choose hour and minutes from datetime as needed. Hope the help.

It seem to be a solution or an answer.

I consider that we could use 2 character '*' and '%' based on what I need In SQL query, we use "Select * frm Assignee WHERE SN like 'Th%'" In Crystal Report, we use CrystalReport1.DataDefinition.RecordSelectionFomular = "{Assignee.SN} like 'Th*'";

It seem to be a solution or an answer.

You should use Parameter to make it easier instead of formatting datetime. string dateneeded = dateTimePicker6.Value.ToLongDateString(); String query = "INSERT INTO purchaserequest(dateneeded) VALUES (?)"; MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.Add(new MySqlParameter("pDate",dateneeded)); command.ExecuteNonQuery();

It seem to be a solution or an answer.

How to create a PivotTable in C#. Thanks in advance

It seem to be a solution or an answer.

This is a stupid question. But I wonder how I can use MS Office PivotTable in C#.

It seem to be a solution or an answer.

Christian Graus wrote:

It *seems* to ? What code have you written, that you're not sure if it does, or not ?

I only assign datasource to combobox column using dataset object,I don't write any code. Because list of items appears slow so I think everytime I select an item in new row, combo box also loads data.

Christian Graus wrote:

If you take the SQL that's being run, and run it in SQL Server, how fast is it ?

I am sure that if I run it in SQLServer, it makes me content with speed. If I use a favourite combox, loading of data is OK. But when using DatagridColumnComboBox, I confuse it...

It seem to be a solution or an answer.

I have a 100MB database of SQLServer. When I made a datagridview using DatagridViewColumnCombox in order that user can choose an item in combobox. When I choose an item, it seems to load data into combobox column. It cause my app running so slowly although this column contains a field about over 1000 records.... Somebody could help me explain why VS.NET uses cache but my app runs slowly I assume that if I made a combo box and then attached it into datagridview, it ưould seem slower. But, I don't know how to do it.... Sorry about my poor English Thanks in advance ...

It seem to be a solution or an answer.

Hi, I want to filter the productID that starts with "MDF", so I use bindingsource1.filter = "productID like 'NAPLE 5'-02'" (look like sql query), but it's not working. After that I corrected bindingsource1.filter = bindingsource1.filter ="productID like 'NAPLE 5%-02'", it's also not working and appear error "The expression contains an invalid string constant:'. " Somebody could correct the code will be appreciated. Thanks in advance.

It seem to be a solution or an answer.

It will be OK if I use sql query to filter the productID begins with MDF. But, what I need is bindingsource1.filter = "productID like 'MDF%'" is correct or not ? I mean that "productID like 'MDF%'" string is correct or not. If not, How must I make it correct ?

It seem to be a solution or an answer.

Hi, I want to filter the productID that starts with "MDF", so I use bindingsource1.filter = "productID like 'MDF%'" (look like sql query), but it's not working. Somebody could correct the code will be appreciated. Thanks in advance.

It seem to be a solution or an answer.