|
After adding/deleting/updating records in dataset table, when I try to click next, previous(any navigation button), I get the message "Cannot Create child list for field student.".
Why there is such error?
|
|
|
|
|
It is related to datagrid in C# windows applications
I have the following requiremnts:
1. Navigation of records in grid
2. add/delete,update records in the grid.
|
|
|
|
|
In C# Windows applications:
1. How can we create checkbox for an existing datagrid column i.e. datagrid column should act like a checkbox? In the same way, how can we create new data column as checkbox in datagrid?
2. Same requirement for Combo box?
|
|
|
|
|
1. How can I embed a non database column in the form of combo box to datagrid
2. How can I changed the datgird textbox column to act like combobox
|
|
|
|
|
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?
|
|
|
|