16,012,107 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by M.Ravibalaji (Top 11 by date)
M.Ravibalaji
28-Oct-14 5:01am
View
Problem here is Treeview dose not a SelectedItem property in xaml. SelectedItem is readonly in codebehind.
M.Ravibalaji
13-Jul-12 5:11am
View
try it in ie. then u can find this control compressing the other fields
M.Ravibalaji
13-Jul-12 2:37am
View
just leave about the max length. I will give u an ex say i have text "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" now this is continuous text because of this continuous text the control is getting expanded more over width is specified in % this is my exact problem
M.Ravibalaji
16-May-12 1:05am
View
i will make it clear an aspx page and an ascx page are there
i have done the design and coding in ascx page and registered it in aspx page
now when i click the botton the aspx page should close(so that registered ascx page will also be closed because it is put in an aspx page)
i think now u understand my problem clearly.....
the code u gave is not working i tried it...
help me with some other code...
M.Ravibalaji
31-Oct-11 3:26am
View
i want to do this in excel i want to do it using c#,asp.net
more than that i don't exactly know what kind of duplication
it will be dynamic
M.Ravibalaji
12-Sep-11 3:59am
View
ya now you understood the question now agra should be 1,2,3 and chennai should follow on with 4,5,6,7 this i how it should be . if another dealer's city is edited to Bihar then agra is 1,2,3 Bihar is 4 and chennai is 5,6,7,8
give me some idea or code help me only you understood my problem
M.Ravibalaji
12-Sep-11 3:40am
View
you have not understood the question correctly if a Dealer has moves from chennai to agra then we are changing that dealers city to agra in that case the serial number has to change because the city is changed from chennai to agra ... agra goes on top so the serial number has to change accordingly please check the structure i have given in the question and more than that i am using access database
M.Ravibalaji
12-Sep-11 3:37am
View
you have not understood the question correctly if a Dealer has moves from chennai to agra then we are changing that dealers city to agra in that case the serial number has to change because the city is changed from chennai to agra ... agra goes on top so the serial number has to change accordingly please check the structure i have given in the question
M.Ravibalaji
9-Sep-11 9:17am
View
string query_empty = String.Empty;
query_empty = "UPDATE customer SET category='" + NJS_Helper.FormatStringforDB(this.lblcategoryselected.Text) + "', code='" + NJS_Helper.FormatStringforDB(lblcategory_code.Text) + "', serial_no='" + String.Empty + "')";
OleDbCommand cmd_empty = new OleDbCommand(query_empty, this.gMain.openConn);
int i1 = cmd_empty.ExecuteNonQuery();
if (i1 > 0)
{
string query_sort = String.Empty;
query_sort = "SELECT * FROM customer WHERE (category='" + NJS_Helper.FormatStringforDB(this.lblcategoryselected.Text) + "') ORDER BY city,serial_no";
OleDbDataAdapter ad = new OleDbDataAdapter(query_sort, this.gMain.openConn);
DataSet ds = new DataSet();
ad.Fill(ds, "results");
foreach (DataRow row in ds.Tables["results"].Rows)
{
arr_serial.Add(row["serial_no"].ToString());
}
foreach (string currentitem in arr_serial)
{
if (currentitem.Equals(""))
{
current_index = arr_serial.IndexOf(currentitem);
}
}
int current_index_new = current_index + 1;
string query_update_new = String.Empty;
for (int i = arr_serial.Count - 1; i >= current_index_new; i--)
{
int serialno_new = i + 1;
int serialno_old = i;
query_update_new = "UPDATE customer SET serial_no='" + serialno_new + "' WHERE (category='" + this.lblcategoryselected.Text + "' AND serial_no='" + serialno_old + "')";
OleDbCommand cmd_update_new = new OleDbCommand(query_update_new, this.gMain.openConn);
cmd_update_new.ExecuteNonQuery();
}
//update empty string with new serial no
string query_update = String.Empty;
query_update = "UPDATE customer SET serial_no='" + current_index_new + "' WHERE (category='" + this.lblcategoryselected.Text + "' AND serial_no='" + String.Empty + "')";
OleDbCommand cmd_update = new OleDbCommand(query_update, this.gMain.openConn);
cmd_update.ExecuteNonQuery();
this how i am updating now .. First i update an empty string for the city changed and then finding that empty string and then incrementing the rest of the records and the updating the empty string
M.Ravibalaji
9-Sep-11 7:05am
View
this should be don without setting the primary key because your records will be changing based on the city and the serial number will also change accordingly
M.Ravibalaji
6-Sep-11 4:15am
View
i am using access database can you give the query for that
Show More