|
It is related to Datagrid in C# windows Applications:
1. When a row is deleted from a datagrid, it should be removed from the grid as well as from the database.It gets deleted from database but still visible on datagrid. I used datagrid.refresh but it did not work?
How to do it?
Basically how to refresh a datagrid after insertion/deletion/updation of records
2. When I try to navigate the records in datagrid after deletion/addition/updation of row, I get the following error message:
"An Unhandled exception has occured in your application..........
Cannot Create a child list for field Test"
|
|
|
|
|
1. How do I prevent the datagrid from displaying its append row (the row at the end with an asterisk)?
2. How can I convert a Datagrid into dataview?
|
|
|
|
|
You asked this three times, were you expecting three distinct and different answers ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
NO, Actually there were some screen errors, so I thought it has not been posted and I keep on posting the same question 2 times more.
|
|
|
|
|
private BindingManagerBase bindingManager;
What is BindingManagerBase and what's the use of it?
|
|
|
|
|
In C# Windows application,How can I tell if the current row in a datagrid has changed ?
|
|
|
|
|
By using the property that exists to tell you that.
Dude, did you consider reading the MSDN before posting all these questions ? Or google ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
In C# Windows application,How can I tell whether I am on the AddNew row or not in a datagrid?
|
|
|
|
|
In C# Windows Applications,
How do I determine whether a checkbox in my datagrid is checked or not?
|
|
|
|
|
The following link may help answer your questions:
http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp
Thank you,
Jason W.
|
|
|
|
|
Hi all~
E.g "Select * from table_A where firstName Like '%" + string + "%'";
How to change the ad-hoc sql to prepared statement using operator 'like' and '%'?
Thanks
|
|
|
|
|
Not sure what you mean, but have a look at the sp_executesql stored procedure. That may point you in the general direction
Gregg
|
|
|
|
|
If using prepared statement,
The sql will like this:
cmd.CommandText = "Select * from table_A where firstName Like ?"
cmd.Parameter.Add("FirstName", "John");
cmd.Prepared();
cmd.ExecuteNonQuery();
Then if I would like to get the records which the firstName contains string "John". Using ad-hoc statement, "%" operator can be used. If using prepared statement, but to put "%" operator or using other way to achieve the result.
|
|
|
|
|
I'm using the following select statement to identify records that contain a non alpha and non numeric character (ex &,/). I would like to modify this script to identify what these characters are and provide a count for each of them. How can this be done?
<br />
Select LastName, count(*) as 'Counts'<br />
From DataTable<br />
Where (LastName like ('%[^ a-z0-9]%'))<br />
Group by LastName<br />
Thank you,
|
|
|
|
|
Hi, how could i create a temp table without using create table #aux?
i need to have a dinamic name for each user who is working with my app, its that possible?
thankx
|
|
|
|
|
Why do you need dynamic names? You can create a #table in every (different) connection with the same name. The #temp tables are 'connection bound'.
Wout Louwers
|
|
|
|
|
Hello people,
I want to run a query for customers whose last order was placed before the beginning of this month. Since there is no LastOrder field, and I can only use OrderDate, how do you write a statement that would take only the latest OrderDate that is less than last month. I really only know the basic stuff, I'm guessing I might need to write an if statement or a loop.
Thanks in advance.
|
|
|
|
|
JON10884 wrote:
I'm guessing I might need to write an if statement or a loop.
Writing loops in SQL is very inefficient, you should only consider this as a last resort. Database systems are fine tuned to work on sets of data so by extracting the set into individual rows and operating on the individual rows is very inefficient.
It would be helpful if you could post the relevant tables and columns
Do you want to know more?
WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums
|
|
|
|
|
doesn't need a loop. You could use the horrible distinct clause
select * from
(
select distinct(customerid)
from orders
where orderdate < '2004-12-01 00:00'
) j
left join
(
select distinct(customerid)
from orders
where orderdate >= '2004-12-01 00:00'
) k
on k.customerid=j.customerid
where k.customerid is null
|
|
|
|
|
SELECT Customers.CustomerID
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
GROUP BY Customers.CustomerID
HAVING MAX(Orders.OrderDate) < '20041201' Assuming you keep your orders in an Orders table, and your customers in a Customers table, of course!
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
You guys are the best! thanks a lot!
But one more question, I'm using Mike's algorithm, how do you select more fields to display?
|
|
|
|
|
As long as you want to select more fields from the customers table, you should include the fields in both the select and group by clause. Like:
<br />
SELECT Customers.CustomerID, Customers.Name <br />
FROM Customers <br />
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID<br />
GROUP BY Customers.CustomerID, Customers.Name <br />
HAVING MAX(Orders.OrderDate) < '20041201'<br />
Wout Louwers
|
|
|
|
|
I did that but I want the date to display and if you group by date it shows the duplicates.
|
|
|
|
|
I 'me not sure if this will work, but you could try:
<br />
SELECT Customers.CustomerID, MAX(Orders.OrderDate)<br />
FROM Customers <br />
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID<br />
GROUP BY Customers.CustomerID<br />
HAVING MAX(Orders.OrderDate) < '20041201'<br />
Wout Louwers
|
|
|
|
|
You the man! Thanks a ton!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
