Comments by Member 13153537 (Top 85 by date)

yes bro i want like that.please help me.thanks in advance.

i have that code in html file. i will share to you .if you dont mind can you give ur mailid please.

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

bro i posted my html code please check once.

ok i am posting the code.please check thanks in advance.

how to host files actually i am generating html script from mysql table using php is it possible host php files also there

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.

thanks bro for your help.

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.

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.

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();

?>

Thanks for your help and support.finally i got the solution.

can u please show me any example.i am fresher i dont know about json and all.please help me thanks in advance.

Finally i got a solution thanks for the help

Thanks for the help.

Ok Thank you.

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.

Anyway thanks for the help.But this doesn't solve my problem.

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'

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.

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)

you can check my above procedure i have created in mysql but it giving some syntax errors.

I already tried getting problem that why posted question.please help me if you know.
Thanks in Advance.

Thanks for your Advice.I will do.

How to do that please any help.Thanks in Advance.

Thanks for the help it is fixed now.

Thanks for your response.

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.

I want newly Added Slno show on the top of the datagridview.

Thanks for the help.Now i solved the problem.

how you can see my folder structure.Please tell me what can i do.

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.

I'm Fresher please guide me how to do this.I was stuck since morning Thanks for the response.

Thank you.

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.

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.

I did that.Please Check My code Once.Thanks in Advance.

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.

Once you done the preparing rectangle objects please share me.Thanks in Advance.

Thank you very much for your support.

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.

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.

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);
}

}
}

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.

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.

Thank you.

I know it is silly question.I'm fresher.Thanks for the help.

How to Handle that Exception in my case.Please give any reference.Thanks in advance.

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.

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);
}
}

Ok thanks for your response.If it works. I will accept the answer.

or Give me any reference.

How to do that please tell me.I'm fresher.Thanks In Advance.

ok Thanks.

In datagridview textbox has Textbox1_Valiadated event option not available.

Thanks you for your response.

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();
}

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.

It is not working for me as i expected.

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.

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();
}

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;

based on the bank_Id. we are passing bank_Name column.

ok thank you

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());

After Using the above query.i am getting empty dataset.

After Using the above query.i am getting empty dataset.

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.

bankname colum not there in chequedetails table.Only Bankid is there.could you guide me please how to do that.
Thanks in advance.

Thanks for your response.

I think winforms viewstate option is not available.

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.

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.

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.

Thanks for your response.

Did you understand my question

yes thank you

why are you added 1.
please explain me.