thanks for you reply actually i fixed it, I just create a command statement with my query and i map my fields with the old ones and its working now, i guess the fact that i was working with two...

The fields are DefectType, RootType in the Page Header C section and also the details section complete thanks

11524

Hello all, I created a crystal report which works perfect local but in production work partial, it means that there are 3 specific values that the report does no retrieve, is there any particular...

Ok cool.

in your select statement are you retrieving that value? if yes verify you have autogeneratecolumns to false you have to create a bound column manually for the primary field and also you can set the...

You can use a datatable instead

DataSet dsResult = new DataSet();
DataRow drRev;
DataTable dtRev = new DataTable();
dtRev.Columns.Add("Name");
dtRev.Columns.Add("Number");
For(int i =0; i <...

you need this

if(ContractID_Reader2.HasRows)
{
while(ContractID_Reader2.Read())
{
//Your code here
}
}

into the try clause

connection.Open();
cmd.ExecuteNonQuery();
connection.Close();

regards

why dont you pass the login parameters in the select statement and if datareader has any rows it means that user exist.

Something like this.

OleDbDataReader dr;
OleDbCommand cmd = New OleDbCommand("select * from login where id= '"+txtUser.Text+"' and pass='"+txtPwd.Text+"'", conn);
dr =...

Check this thread http://www.daniweb.com/forums/thread190964.html and let me know.

regards.

Yes the above select statement is correct, but remember you will need a dataset or datareader to fetch more than one column as follow.

SqlCommand sqlcmd = new SqlCommand("Select Password,firstname...

First you do not need to retrieve the username because is given as parameter. base on what you said.
Under the button search click event you will have a code like this.

SqlConnection con = new...

In my opinion, regardless the operation in issue (Insert a new record or displaying data from db) you need to fill the dropdown with all values from genre table.

Now if you want to display a...

Ok, first i imagine you have a dropdownlist to display all genres in the new movie entry form. is that is the case you will have a select statment like.

select GenreID, GenreName from Genre
then...

make sure you have permissions to access and write into the database, also double check the path of the connection string, maybe you should test the connection first without trying the insert to see...

after you open the connection you should say this
objCmd.ExecuteNonQuery();

regards.

Hi friends, I fixed the problem PreBina Variable was holding a hide delimiter character at the end of the string and that was stopping the correct function or result that i wanted. anyway I just did...

Hi, everyone this is my issue I have to read a binary record from the database and concatenate another string to it, the thing is that is just working one way, I ll put some code to explain better.
...

I tried the first two suggestions but got the same error, the third one adatapost resolved my issue thanks all.

Ok I have seen to many post about this and nothing work for me, I just do not get it. I have a simple datagrid which i want to add rows, NOTE: this datagrid have no relation with database so...

Ok, thanks for your help.

Well what I mean is that I do not have like a specific string to search all the documents has data at least the header, now what i know is that column 1 = Drawing Revision for example in the table...

Yes, I understand your point, but the problem is that I do not have any specific parameter to search into the document, the data could be any, like a I said before the only thing I know is that the...

Thanks Serkan.
Base on your link, I came out with this code, which can read the table as I want, thanks again.

Microsoft.Office.Interop.Word.Application app = new...

Hi, Guys.

I have a issue reading a word document, well i can actually read the document but i need some how split some data into array, now the data that i want to split is into a table in word,...

jeje got it, thanks ddanbe. I forgot about the consistency of Microsoft Products.

Uhmm, Are we talking about the same control?
I think I misunderstood the question, you guys are talking about CheckedListBox and I am talking about CheckBoxList jeje, well anyway if there are...

First step is to split the string into an array.

string MyString = "Games,Tvs,Shows";
string[] MyArray = new string[3];
MyArray = MyString.Split(',');
CheckBoxList1.DataSource = MyArray;...

you are doing good, after that save the content of the word document into a string variable in then read word by word the content.
String ContentWord = "";
ContentWord =...

i do this to get the current computer maybe look for something like this.

Dim IPAddress as String = Request.ServerVariables.Get("REMOTE_ADDR")

that is vb, c# is almost the same.