|
why is my query wrong at FROM ?
i want to connect two tables so i can get some specific data but c# appear error.
try
{
//Set the command string
string Cmd = "SELECT * FROM Robberies_Table JOIN Branches_Table ON Robberies_Table.BranchCode =Branches_Table.BranchCode ;";
//create new new connection to the database
OleDbConnection conn = new OleDbConnection(ConnectionString);
//create new data adapter
OleDbDataAdapter Adapter = new OleDbDataAdapter(Cmd, conn);
//create new command builder
OleDbCommandBuilder CmdBuilder = new OleDbCommandBuilder(Adapter);
dTable = new DataTable();
Adapter.Fill(dTable);
conn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
//return the search results on a datatable
return dTable;
}
|
|
|
|
|
Your SQL query has a semi-colon in there. Remove it.
|
|
|
|
|
i remove inner semi-colon but the query has error again at from field .
string Cmd = "SELECT * FROM Robberies_Table JOIN Branches_Table ON Robberies_Table.BranchCode =Branches_Table.BranchCode ";
|
|
|
|
|
A couple of things:
- What error does it come up with? Give us a fighting chance here.
- What happens if you run this query directly against your database?
|
|
|
|
|
THE QUERY RUN SUCCESSFULLY AND IS IN THIS FORMAT:
SELECT Robberies_Table.BankName, Robberies_Table.Region, Robberies_Table.BranchCode, Robberies_Table.[Date], Robberies_Table.Ammount,
Robberies_Table.Description, Robberies_Table.Robbery_ID, Robberies_Table.[Year], Branches_Table.BranchName
FROM (Robberies_Table INNER JOIN
Branches_Table ON Robberies_Table.BranchCode = Branches_Table.BranchCode)
IN C# THE QUERY I WRITE IS LIKE THIS :
string Cmd = "SELECT * FROM (Robberies_Table INNER JOIN Branches_Table ON Robberies_Table.BranchCode = Branches_Table.BranchCode);";
AND WHEN I RUN THE PROGRAM NOW ONLY THE RECORD IS UNDER THE BRANCHNAME IT APPEAR IN SCREEN THE DATA OF ROBBERIES TABLE DON'T SHOW ME
modified 2-Apr-13 17:44pm.
|
|
|
|
|
So use that query in your code.
|
|
|
|
|
IN C# THE QUERY I WRITE IS LIKE THIS :
string Cmd = "SELECT * FROM (Robberies_Table INNER JOIN Branches_Table ON Robberies_Table.BranchCode = Branches_Table.BranchCode);";
AND WHEN I RUN THE PROGRAM NOW ONLY THE RECORD IS UNDER THE BRANCHNAME IT APPEAR IN SCREEN THE DATA OF ROBBERIES TABLE DON'T SHOW ME
IF I WRITE THE SAME THAT IS IN MY DATABASE QUERY C# SHOW ME MY CRYSTAL REPORT EMPTY SO I WRITE AS ABOVE AND HAS THE ABOVE ERROR
DIDN'T SHOW ANYTHING:
------------------------
string Cmd = "SELECT Robberies_Table.BankName, Robberies_Table.Region, Robberies_Table.BranchCode, Robberies_Table.[Date], Robberies_Table.Ammount,Robberies_Table.Description, Robberies_Table.Robbery_ID, Robberies_Table.[Year], Branches_Table.BranchName FROM (Robberies_Table INNER JOIN Branches_Table ON Robberies_Table.BranchCode = Branches_Table.BranchCode);";
|
|
|
|
|
I don't know how many different ways I can put this, but try running the same query that you issue in your C# code in the SQL table. You can't run different queries and then expect them to be the same.
|
|
|
|
|
MY DATABASE IS ACCESS NOT SQL AND I OBSERVE THAT HAS MANY DIFFERENCES IN THE WAY YOU WRITE THE QUERY.
BUT ITS OK I WILL TRY MORE AND I WILL FIND THE SOLUTION ANYWAY...
THANK YOU 
|
|
|
|
|
Please don't SHOUT. It's not polite.
/ravi
|
|
|
|
|
|
No worries!
/ravi
|
|
|
|
|
Would you plaese remove the * and write the columns that you want to access after joining both the table
like--
select column1,column2 from (table1 JOIN table2 where.....)
|
|
|
|
|
Hello,
i'm moving my actual winform based application to WPF.
My application acquire 1500x1500 8bit depth images at 30 frame per second.
In winform i was used to BitBlt my images to a panel handle and that work fine.
In wpf i tried two ways:
int stride = img_w * ((PixelFormats.Gray8.BitsPerPixel + 7) / 8);
bmpSource = BitmapSource.Create(img_w, img_h, 96, 96, PixelFormats.Gray8, null, my_arrb_8bit, stride);
this.Image1.Source = bmpSource;
but this is too slow...then i try
int max = PixelFormats.Rgb24.BitsPerPixel;
uint count = (uint)(img_w * img_h * PixelFormats.Rgb24.BitsPerPixel / 8);
IntPtr section = CreateFileMapping(new IntPtr(-1), IntPtr.Zero, FileMapProtection.PageReadWrite, 0, count, null);
IntPtr map = MapViewOfFile(section, FileMapAccess.FileMapAllAccess, 0, 0, (UIntPtr)count);
System.Runtime.InteropServices.Marshal.Copy(my_arrb_24bit, 0, map, (int)count);
my_ibs = System.Windows.Interop.Imaging.CreateBitmapSourceFromMemorySection(
section,
(int)img_w,
(int)img_h,
PixelFormats.Rgb24,
(int)(img_w * PixelFormats.Rgb24.BitsPerPixel / 8), 0) as System.Windows.Interop.InteropBitmap;
this.Image1.Source = my_ibs;
this is faster than the first solution, but still i can't manage to reach 30fps....am i doing something wrong? any suggestion?
|
|
|
|
|
Off the top of my head, I'd suspect that the issue that you are hitting is because you are creating new BitmapSource elements each time. Basically, a WPF Bitmap is an immutable object - normally this is a good thing - but in the case where you want to keep changing a source, I'd suggest that you should look at a WriteableBitmap instead. This will give you some ability to mimic the BitBlt functionality.
|
|
|
|
|
On a first try using
writeableBitmap.Lock();
unsafe {
Marshal.Copy(my_arrb_8bit
, 0
, writeableBitmap.BackBuffer
, img_w * img_h);
}
writeableBitmap.AddDirtyRect(new Int32Rect(0, 0, img_w, img_h));
writeableBitmap.Unlock();
seems to start working not yet at 30fps but almost there...thank you very much
|
|
|
|
|
|
I am trying to install an application using c# console application. I have installed it using Process.Start(exepath,"/q").. It was installed successfully. in the same console application, I am trying to search for an update for the same application and trying to install using Process.Start(updatePatchexepath,"/q"). But it is giving some error like "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2734." Can any one help me resolve this.
Thanks in Advance.
|
|
|
|
|
What happens if you try to run this command outside your C# code? You've posted this in the C# forum, but it's not really a C# problem - it's a problem with your installer file. If you looked this error up, you'd see the message was "Invalid reinstall mode character."
|
|
|
|
|
It is not throwing any error message when running it manually. It is launching the update wizard. But when I pass some argument like "/q" to process.start() for this update exe, this error is shown. I want even this update to get installed without displaying the UI. It is a .EXE file and not an msi installer file. However it works for the installation of the application and not for updating the application.
|
|
|
|
|
If you try running this upgrade exactly like this from the command line (i.e., passing in the /q flag), what happens? In general, when you are wrapping something with Process.Start, it's a great idea to see what happens from the command line first.
|
|
|
|
|
It is giving the same installer error "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2734" when i run it from cmd (i.e., using "updateexename.exe /q").
|
|
|
|
|
That's what I was trying to get to above. It looks like /q isn't a supported switch for an upgrade, although I can't say for certain whether or not this is the case. Without knowing any more about how you created this update exe, I can't give any more help.
|
|
|
|
|
Ok thanks for this information
|
|
|
|
|
I run the below query in SQL server through C#.
SELECT ScheduleTime FROM test
I'm using SqlDataAdapter to fill the results in datatable. I'm getting "ScheduleTime" values from test table ("ScheduleTime" is datetime type). But the results are in system date time format.
For example, if my system Time format is "tt hh:mm:ss" in Long Time, the results are in the below format.
27-03-2013 PM 03:51:01
if my system Time format is "HH:mm:ss" in Long Time, the results are in the below format.
27-03-2013 15:51:01
I need to get the results in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format.
Please guide me to this. Thanks in advance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
