16,011,868 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 Member 13153537 (Top 85 by date)
Member 13153537
27-Nov-17 4:51am
View
bro i have posted a question.you have time can you please check once.
Member 13153537
17-Nov-17 0:56am
View
ok thanks.
i have created page using header ,menu,footer and content.
menu is loading from the database.what i want is if click on the menu link
the new form should display between the header and footer without reloading the menu and page how to that please help me thanks in advance.
Member 13153537
16-Nov-17 23:18pm
View
ok thanks for your help and support
Member 13153537
16-Nov-17 5:51am
View
thank you bro it is working fine.
Member 13153537
16-Nov-17 4:45am
View
yes bro i want like that only.please help me.thanks in advance
Member 13153537
16-Nov-17 4:40am
View
yes bro i want like that.please help me.thanks in advance.
Member 13153537
16-Nov-17 4:29am
View
i have that code in html file. i will share to you .if you dont mind can you give ur mailid please.
Member 13153537
16-Nov-17 4:26am
View
when document loads it is working fine but when you open all the child elements of A and go to B and then come back it will show all the previously opened child elements also
check it once.please
Member 13153537
16-Nov-17 3:54am
View
bro i posted my html code please check once.
Member 13153537
16-Nov-17 2:45am
View
ok i am posting the code.please check thanks in advance.
Member 13153537
16-Nov-17 2:26am
View
how to host files actually i am generating html script from mysql table using php is it possible host php files also there
Member 13153537
15-Nov-17 23:56pm
View
instead of using hover i want to implement using click using jquery or javascript how
to do that give me any example.thanks in advance.
Member 13153537
15-Nov-17 23:37pm
View
thanks bro for your help.
Member 13153537
15-Nov-17 0:05am
View
yes by using css if i open the page first time it will show only parent elements like
A
B
C
then i click on A it should show child elements of A not grand child elements
again if i click A child elements like A1 it should show A1 child elements how to do that.please give me any example.I am sorry i am asking every small doubt also because i am fresher.thanks in advance.
Member 13153537
14-Nov-17 0:56am
View
thanks for your help and support.but i want to add class names for each parent element
and child element and each grand child elements using that function .how to do that please help me thanks in advance.
Member 13153537
14-Nov-17 0:46am
View
Deleted
thanks for your help and support.
in my case what i want is create class for main li element for limain class and child elements for lichild and if there grand child element for each children create like that .
i have tried something but it is taking child elements inside child elements also same
child elements name how to prevent that.please help.
Member 13153537
9-Nov-17 4:22am
View
yes it is getting record.
i tried different code somehow it is working fine.i want only child elements clickable remaning should show only text i would i do that .please help me.i am new to php.i am posting my code.thanks in advance.
<?php
mysql_connect('localhost','root','');
mysql_select_db("test");
function submenu($parentid=0){
$sql=mysql_query("SELECT * FROM test WHERE refid=".$parentid);
{
echo '';
while($row=mysql_fetch_array($sql))
{
if(mysql_num_rows($sql)>0)
{
$sql1=mysql_query("SELECT * FROM test where refid=".$row['id']);
if(mysql_num_rows($sql1)>0){
echo ''.$row['name'];
submenu($row['id']);
echo '';}
else{
echo '
'.$row['name'].'
';
submenu($row['id']);
echo '';
}
}
echo '';
}
}
}
submenu();
?>
Member 13153537
6-Nov-17 3:52am
View
Thanks for your help and support.finally i got the solution.
Member 13153537
28-Oct-17 2:40am
View
can u please show me any example.i am fresher i dont know about json and all.please help me thanks in advance.
Member 13153537
24-Oct-17 7:19am
View
Finally i got a solution thanks for the help
Member 13153537
27-Sep-17 3:08am
View
Thanks for the help.
Member 13153537
28-Aug-17 7:10am
View
Ok Thank you.
Member 13153537
28-Aug-17 6:25am
View
this is my table and below is the stored procedure.
create table customer(firstname varchar(100) unique,lastname varchar(10) unique)
DELIMITER $$
CREATE PROCEDURE insertcustomer(IN firstname varchar(100), IN lastname varchar(100))
BEGIN
declare exit handler for sqlexception
select 'sql exception invoked';
DECLARE EXIT HANDLER FOR 1062
SELECT 'MySQL error code 1062 invoked';
-- insert a new record into article_tags
INSERT INTO customer(firstname,lastname)
VALUES(firstname,lastname);
-- return tag count for the article
END
and below is the php code
#conatiner{
text-align:center;
padding-top:18%;
}
<title>Add
<?php include("connection2.php");?>
<?php
if(isset($_POST['submit'])) {
$link = mysqli_connect("localhost", "root", "Admin@123", "Test");
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$res=mysqli_query($link, "CALL insertcustomer('$firstname', '$lastname')");
if($res===false){
echo mysql_errno."".mysql_errno;
}
}
?>
First Name:
Last Name:
What i want is in my table i created two columns as unique.if i pass the same data second i want show the inside stored procedure handler message.
How to do this please help me on this.Thanks in advance.
Member 13153537
28-Aug-17 5:55am
View
Anyway thanks for the help.But this doesn't solve my problem.
Member 13153537
28-Aug-17 5:28am
View
workbench throwing error when i passing these values like this call insert_article_tags_2(4300290271,4300290271) Error Code: 1264. Out of range value for column 'article_id' at row 1
i want show this error instead of mysql showing error.I am handling this error using this
DECLARE EXIT HANDLER FOR 1264
SELECT 'Out of range exception'
Member 13153537
28-Aug-17 5:05am
View
thanks for the reply.i am calling mysql workbench itself.what i want is if i pass those values(155555555555555,1877777755555555555) i want the out of range error.What have i created above using handler 1264.
Member 13153537
28-Aug-17 1:09am
View
I have created a stored procedure in mysql in that i created handler.one is 1064 handler another one is 1264. 1064 is working fine but 1264 is not working.Do you have knowledge on mysql please help me thanks in advance.
DELIMITER $$
CREATE PROCEDURE insert_article_tags_2(IN article_id INT, IN tag_id INT)
BEGIN
declare exit handler for sqlexception
select 'sql exception invoked';
DECLARE EXIT HANDLER FOR 1062
SELECT 'MySQL error code 1062 invoked';
DECLARE EXIT HANDLER FOR 1264
SELECT 'Out of range exception';
-- insert a new record into article_tags
INSERT INTO article_tags(article_id,tag_id)
VALUES(article_id,tag_id);
END
--showing 1062 error correct
call insert_article_tags_2(1,1)
--it is not showing out of range errror
call insert_article_tags_2(155555555555555,1877777755555555555)
Member 13153537
24-Aug-17 1:53am
View
Deleted
What is wrong with this query plaese help me.In Mysql
if Insupdt='0' then
SET @NxtSlno =(select ifnull(max(bgrp_Id),9) from HemoTrace.bldgrps);
Member 13153537
23-Aug-17 9:29am
View
you can check my above procedure i have created in mysql but it giving some syntax errors.
Member 13153537
23-Aug-17 9:17am
View
I already tried getting problem that why posted question.please help me if you know.
Thanks in Advance.
Member 13153537
30-Jun-17 0:38am
View
Thanks for your Advice.I will do.
Member 13153537
29-Jun-17 13:33pm
View
How to do that please any help.Thanks in Advance.
Member 13153537
17-Jun-17 1:49am
View
Thanks for the help it is fixed now.
Member 13153537
16-Jun-17 7:12am
View
Thanks for your response.
Member 13153537
16-Jun-17 6:50am
View
What i want is in my datagridview i had 1 row already .If i add new row will be added at top of the datagridview with slno 2.
Member 13153537
16-Jun-17 6:31am
View
I want newly Added Slno show on the top of the datagridview.
Member 13153537
14-Jun-17 23:52pm
View
Thanks for the help.Now i solved the problem.
Member 13153537
14-Jun-17 8:59am
View
how you can see my folder structure.Please tell me what can i do.
Member 13153537
14-Jun-17 8:41am
View
Yes same name space only
but if call the namespace. it is directly showing the file.If i call namespace.foldername.classname not showing why.Please help me.
Member 13153537
14-Jun-17 8:36am
View
I'm Fresher please guide me how to do this.I was stuck since morning Thanks for the response.
Member 13153537
6-Jun-17 8:47am
View
Thank you.
Member 13153537
6-Jun-17 5:39am
View
Hi Please help me how to use the same code in class file and call it in front-end in different different.Thanks in advance.
Member 13153537
6-Jun-17 0:17am
View
My Problem is in my bankdetails table example bank is sbi i insert record like like chequestartno,noofleaves,chequeendno and status.
I used cheques like startno to endno showing in the chequeno and chequebook no is 1 for the after completed the totalcheques.If i used total cheques and update the status and insert another record in table i want to show the chequebook no 2.How to do that.please help me.Thanks in Advance.
Member 13153537
5-Jun-17 8:07am
View
I did that.Please Check My code Once.Thanks in Advance.
Member 13153537
2-Jun-17 3:50am
View
Every BankCheque sholud Have the same measures.I put the Bank cheque on the printer and click print.I will try my self.Thank you.
Member 13153537
2-Jun-17 3:26am
View
Once you done the preparing rectangle objects please share me.Thanks in Advance.
Member 13153537
2-Jun-17 2:54am
View
Thank you very much for your support.
Member 13153537
2-Jun-17 2:01am
View
My question is i put the bankcheque on printer and create somestrings for the date and payname and amount and rupessinwords text.If i click the print the button that strings will be place on the bank cheque date field opposite date and amount opposite amount like that.how to get the dimensions of the that places how to do that please help me i tried above code.
Member 13153537
29-May-17 2:43am
View
What link did you shared to me in that path is there.How to we set the file in that location.Please guide me how to do this.
Member 13153537
25-May-17 6:28am
View
this is the code what i have tried.
private void btnprint_Click(object sender, EventArgs e)
{
CaptureScreen();
printDocument1.Print();
printPreviewDialog1.ShowDialog();
ClearControls(this);
}
Bitmap memoryImage;
private void CaptureScreen()
{
Graphics myGraphics = this.CreateGraphics();
Size s = this.Size;
memoryImage = new Bitmap(s.Width, s.Height, myGraphics);
Graphics memoryGraphics = Graphics.FromImage(memoryImage);
memoryGraphics.CopyFromScreen(this.Location.X, this.Location.Y, 1060,360, s);
}
private void printDocument1_PrintPage_1(object sender, PrintPageEventArgs e)
{
e.Graphics.DrawImage(memoryImage, 1060, 360);
}
}
}
Member 13153537
25-May-17 6:08am
View
Now i tried something but i'm getting documents doesnot contain any pages.how to solve that.Please have look at my question once.Thanks.
Member 13153537
25-May-17 1:08am
View
My Requirement is after filling the form and then click save button data save into the database and then print button enable .After i click the print button it will go to print.I was stuck since yesterday.Please help me how to start.I'm fresher.Thanks in Advance.
Member 13153537
19-May-17 9:07am
View
Thank you.
Member 13153537
19-May-17 8:42am
View
I know it is silly question.I'm fresher.Thanks for the help.
Member 13153537
19-May-17 8:30am
View
How to Handle that Exception in my case.Please give any reference.Thanks in advance.
Member 13153537
19-May-17 8:27am
View
If I select first column value and click column header it is working fine.If i directly click the column header i am getting argument out of range exception.Any way Thanks for the Help.
Member 13153537
19-May-17 8:20am
View
This is the code for the loading data to datagridview
private void LoadDataGridView()
{
string connection = @"Data Source=CISBLR-01\SQL2008; Initial Catalog=ChequeManager;Integrated Security=True;";
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand("SELECT bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Name],[bank_Accountno],[bank_Accountype],[bank_Chequetype] FROM [dbo].[bankdetails] order by SlNo", con);
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dgvwDtls.DataSource = dt;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Member 13153537
18-May-17 7:29am
View
Ok thanks for your response.If it works. I will accept the answer.
Member 13153537
18-May-17 7:15am
View
or Give me any reference.
Member 13153537
18-May-17 7:14am
View
How to do that please tell me.I'm fresher.Thanks In Advance.
Member 13153537
15-May-17 10:46am
View
ok Thanks.
Member 13153537
15-May-17 10:08am
View
In datagridview textbox has Textbox1_Valiadated event option not available.
Member 13153537
15-May-17 2:35am
View
Thanks you for your response.
Member 13153537
13-May-17 1:38am
View
Finaly I got the answer.I clear the datatable when the selected value changed to select text in the banknamecombobox i have got answer.
else if (cmbbankname.SelectedIndex == 0)
{
txtAcntno.Text = "";
cmbAcntype.SelectedIndex = 0;
dts.Clear();
}
Member 13153537
13-May-17 1:15am
View
It is not working for me.Because when i clear the datagridview it isclearing complete datagridview along with datagridview column definitons.But secondtime it is showing different columnnames from the database table.Please help me anybody.how to do.Thanks in advance.
Member 13153537
12-May-17 23:22pm
View
It is not working for me as i expected.
Member 13153537
12-May-17 8:23am
View
I have tried that too.But firsttime it working fine.But secondtime bank_chequeendno cannot found.and showing bankid column in the datagridview.Actually i have set bankid column visible false.I have posted loaddatagridview() please once have look at it.Thanks.
Member 13153537
11-May-17 23:36pm
View
For filling the combobox i am used below code.
private void FillBankName()
{
//DataRow dr;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("select bank_Id,bank_Name from bankdetails", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
Dictionary<string, string> test = new Dictionary<string, string>();
test.Add("select", "select");
for (int i = 0; i < dt.Rows.Count; i++)
{
test.Add(dt.Rows[i]["bank_Name"].ToString(), dt.Rows[i]["bank_Id"].ToString());
}
comboBox1.DataSource = new BindingSource(test, null);
comboBox1.ValueMember = "Value";
comboBox1.DisplayMember = "Key";
comboBox1.DataBindings.ToString();
con.Close();
}
Member 13153537
11-May-17 13:57pm
View
It is the place where am i the getting the null reference exception. First time it is working fine.But second time when i select different value from the combobox.I am getting that error.How to fix that.
DataGridViewComboBoxColumn cmb = dgvwChqs.Columns["noofcheques"] as DataGridViewComboBoxColumn;
cmb.DataSource = dt;
cmb.DisplayMember = "bank_Chqlvscount";
cmb.ValueMember = "bank_Id";
cmb.HeaderText = "No. of Cheques";
dgvwChqs.DataSource = dt;
Member 13153537
11-May-17 9:03am
View
based on the bank_Id. we are passing bank_Name column.
Member 13153537
11-May-17 8:57am
View
ok thank you
Member 13153537
11-May-17 8:54am
View
When i used this code atleast firsttime i am getting correct and then got an error."Object reference not set to instance of an object".
SqlCommand cmd = new SqlCommand(" SELECT bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Chqstartno],[bank_Chqendno],case bank_Chqlvscount when 100 then 2 when 50 then 1 when 10 then 0 end as noofcheques ,bank_Chqlvscount,bank_Stat FROM [dbo].bankcheques where bank_Id=@bank_Id order by SlNo desc ", con);
cmd.Parameters.AddWithValue("@bank_Id",
comboBox1.SelectedValue.ToString());
Member 13153537
11-May-17 8:47am
View
After Using the above query.i am getting empty dataset.
Member 13153537
11-May-17 8:46am
View
After Using the above query.i am getting empty dataset.
Member 13153537
11-May-17 8:25am
View
Thank you very much.It is working fine for me first time. when i change combobox value second time i am getting "Object reference not set to instance of an object " error.
Member 13153537
11-May-17 8:12am
View
bankname colum not there in chequedetails table.Only Bankid is there.could you guide me please how to do that.
Thanks in advance.
Member 13153537
11-May-17 5:34am
View
Thanks for your response.
Member 13153537
11-May-17 1:18am
View
I think winforms viewstate option is not available.
Member 13153537
9-May-17 3:25am
View
It is working fine for me firsttime.After loading form firsttime select is showing bankname. accountno and accounttype both are empty.when i select bankname both are filling fine.but after i select 'select' text again prevoiusly data showing in accountno and accounttype.In my table bankname,acountno and accounttype coming from single table only.
Thank very much for your effort.
Member 13153537
8-May-17 23:43pm
View
I did the same thing.what happening is when form load firsttime it is taking bankname and fill the account number and accounttype.I want after loading the form bankname place i need to show select text.after i can select my required bankname.How to do it.Please helpme.
Member 13153537
8-May-17 12:23pm
View
Yes it is helpful for me.But when i run the program it is by default taking first bank name.Now i need to select after loading the form.How to do it any idea.
Member 13153537
8-May-17 6:26am
View
Thanks for your response.
Member 13153537
8-May-17 6:01am
View
Did you understand my question
Member 13153537
27-Apr-17 3:26am
View
yes thank you
Member 13153537
27-Apr-17 1:58am
View
why are you added 1.
please explain me.
Show More