Comments by Member 9671810 (Top 127 by date)

yes, it does. i tried this one i cannot store the incremented value.

thanks sir, but i have referred this :) but it didn't helped me :/

i want that field to auto increment i tried various ways. eg select max(id) from table; or even tried putting null value. But it is not allowing me do so.

thanks. :) it worked friendname(\"" + friendname + "\") :)

sorry i was just checking that, there might be error while defining friendname i tried this friendnamebtn("+ friendname +") but it is not working.

getting error "Uncaught ReferenceError: daisy is not defined" when i debug.

@_Amy http://www.codeproject.com/Questions/1040301/link-two-contacts-make-friends-on-clicking-add-fri this is my new question's link.

and hey, if i want to pass argument as onclick=friendnamebtn(rs.getString(2)) so that i can get there id or name. then???

thanks :) it's working :) now can you please suggest me if i want to connect those two people,(i mean i need to write database connectivity code. so can i write in javascript or do i need to use some other logic :))

it's not working.. :/ why is this sender? and i have javascript code in separate file named index.js.

out.println(files)-- > gives output of various hyperlinks.
eg:- 1.mp3
2.mp3
3.mp3 etc.
now if I click 1.mp3 then that link value I want to store in a variable so that I can append at runtime.

I tried this one. but it ain't working. Still invalid source.

I have no idea of using jQuery. See upto what I have done is http://www.codeproject.com/Questions/1031104/How-to-get-link-values-store-in-a-variable-and-mak?arn=0

I have made hyperlinks of all the audio file that is stored on that folder. The only thing is I want that audio to played when the user clicks on that particular hyperlink.

But this is my college project, so you think to make a webserver and upload my files there? and access from there? is it feasible.?

I reinstalled MySQL sever, and now it works for me

there is problem with path only,if I just save in the project it works but if I try to fetch from other folders of drive it ain't working,

<pre lang="HTML">


</pre>

this ain't working.


this works if is just specify only song name and store it in a current working directory.

when I press play. then it shows -->Error: An unknown error occurred.

I made a hyperlink, using this code
out.println("");
out.println(files);
out.println("");

and audio player

out.println("<audio controls="">");


out.println("");
out.println("Your browser does not support the audio element.");
out.println("");


but audio is not getting played, cause invalid source. :/

i don't know how to do it :D. I mean how to store media file in filestream.

how can i get the admin previlage? OR how can i change use command prompt??
can u give me some detailed steps?

C:\Program Files\MySQL\MySQL Server 5.6>

after this what to do??

haha sir.. the problem was. i didn't use double quotes("").

but if i execute this query

update user_reg_ml SET uname=abcd where id='1'

then it gives me following error

Error code 1054, SQL state 42S22: Unknown column 'abcd' in 'field list'

see.. if i run this command it gets executed
select id,uname,pwd,country from user_reg_ml;

i tried updating either uname or country also.. :(

same as what i passed, id,pwd,uname,email and country

but do you think there is any syntax error?? infact i tried to update maually using uname=abc. then also there is an error saying unknown column in fieldlist.

i have error if i pass only uname also.

again i have the same error

javax.servlet.ServletException:
UPDATE user_reg_ml SET uname=abc ,email=abc@gmail.com ,country=India where id=1UPDATE user_reg_ml SET uname=abc, email='abc@gmail.com', country=India where id=1
: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com ,country=India where id=1UPDATE user_reg_ml SET uname=abc, email=' at line 1

thanks sir, that's what i wanted, "A direction".

I think sir, you were also unaware of all things things when you were beginner. I learned core java. I know very well to code using notepad and compile and run through command prompt. But now I want help for using IDE.

thanx a lot sir, i m beginner, so i don't had much idea about triggers. :)

see, i have choosen a project of online music player. But my faculty told me to compulsorily use trigger or cursors or both.. but i don't have any idea how and where to use. So please help me out.

Sir. still the same not showing any records.

i have mentioned look above. but 1 line is missing over here.
SqlCommand cmd = new SqlCommand("search_and_and", con);

sir. the query is not working.
i don't understand what is the problem.

yeah. i can insert 1 checked value.

i tried this sir. but the thing is windows forms does not have Listitem reference

okes.. well thanks.. a lot.... :)

yeah but it won't color red

tablelayoutpanel in windows form.. i don't have any code. i want code.

but can i add 2 tools at a time in tablelayoutpanel

oh yeah.. :) but tablelayout does not allow 2 tools ata time..:(

dis worked a bit. but the thing is i cannot pass the parameter when i m inserting the the whole form in database.

plz read read my code and problem posted above..

thanks a lot sir...i understand your code. but the thing is i want to insert when i click submit button..
here's my code..


private void button1_Click(object sender, EventArgs e)
{
try
{
string fname;
string mname;
string lname;
fname = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(txtfname.Text.ToLower());
mname = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(txtmname.Text.ToLower());
lname = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(txtlname.Text.ToLower());


// ( strdate , "d/MM/yyyy", CultureInfo.InvariantCulture).ToString()
SqlCommand cmd = new SqlCommand("insert_registration");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sname", cmbname.Text);
cmd.Parameters.AddWithValue("@fname", fname.ToString());
cmd.Parameters.AddWithValue("@mname", mname.ToString());
cmd.Parameters.AddWithValue("@lname", lname.ToString());
cmd.Parameters.AddWithValue("@address", rchtxtaddress.Text);
cmd.Parameters.AddWithValue("@state_id", cmbstate.SelectedValue);

if (cmbcity.SelectedValue == null)
{
cmbcity_SelectedIndexChanged(sender, e);
int id;
bool paresOK = Int32.TryParse(cmbstate.SelectedValue.ToString(), out id);
SqlDataAdapter cityda = new SqlDataAdapter("select city_name , city_id from city where state_id = '" + id + "' ", con);
DataTable citydt = new DataTable();
cityda.Fill(citydt);
cmbcity.DataSource = citydt;
cmbcity.DisplayMember = "city_name";
cmbcity.ValueMember = "city_id";
//int city = Int16.Parse(cmbcity.ValueMember);
cmd.Parameters.AddWithValue("@city_id", Int16.Parse("city_id++"));
//cmbcity.MaxDropDownItems + 1);
// cmbstate.DropDownStyle = ComboBoxStyle.DropDownList;
// SqlDataAdapter cityda1 = new SqlDataAdapter("select * from city where state_id = '" + +"'"
}
else
{
cmd.Parameters.AddWithValue("@city_id", cmbcity.SelectedValue);
}

cmd.Connection = con;
int check = 0;
con.Open();
check = cmd.ExecuteNonQuery();
con.Close();
}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

private void cmbmemstate1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataAdapter stateda = new SqlDataAdapter("select * from state", con);
DataTable statedt = new DataTable();
stateda.Fill(statedt);
cmbmemstate1.DataSource = statedt;
cmbmemstate1.DisplayMember = "state_name";
cmbmemstate1.ValueMember = "state_id";
cmbmemstate1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cmbmemstate1.AutoCompleteSource = AutoCompleteSource.ListItems;
}

but dis aint working..
i don't want another button to insert only city...
the thing is if the city is not in list so then the user can insert city... dat's all i want..

The problem is i cannot insert city at the same time i register my user

cmd.Parameters.AddWithValue("@bdate",string.IsNullOrEmpty(txtbdate.Text) ? DBNull.Value : (object)DateTime.ParseExact(txtbdate.Text,"dd/mm/yyyy",CultureInfo.InvariantCulture));

wrote above code to insert

and

string strdate = row.Cells["Bdate"].Value.ToString();
string date = DateTime.ParseExact( strdate , "d/MM/yyyy", CultureInfo.InvariantCulture).ToString();
txtmembdate.Text = date;

for gettind date to textbox from datagridview..
still getting error of string was not recognized as valid datetime

private void txtmembdate_Validating(object sender, CancelEventArgs e)
{
DateTime dob;
// DOB is required and must be a valid date
if (!DateTime.TryParse(txtmembdate.Text, out dob))
{
errorProviderbdate.SetError(txtmembdate, "Must be a date/time value");
e.Cancel = true;
return;
}
// Must be 18 or older
if (dob > DateTime.Now.AddYears(-18))
{
errorProviderbdate.SetError(txtmembdate, "Must be 18 or older");
e.Cancel = true;
return;
}
// DOB is valid
errorProviderbdate.SetError(txtmembdate, "");

}

dis is my code to validate.. i can only see date in datagridview but, while fetching... time.. also appears

thanks sir for your precious time.. :)

SELECT registration.user_id, registration.sname, registration.fname, registration.mname, registration.lname, registration.address, registration.bdate,
registration.age, registration.pincode, registration.occupation, registration.membership, registration.blood_id, city.city_name, state.state_name
FROM registration INNER JOIN
city ON registration.city_id = city.city_id INNER JOIN
state ON registration.state_id = state.state_id AND city.state_id = state.state_id


haha.. dis was the solution :P.. and i m stupidest among all.. :P

help me soon.. plz....

i did this.. but it does not show the selected value.

yup. i mean they are just read only in datagridview and i have made a table layout by its side and have made all the controls same as registration page

i m not much compatible with 3 tier but dis helped me a lot... i made simple application but not using 3 tier...
thanks a lot people i wonder and glad that i m a part of I.T. where every1 is so.. so.. so.. helpful... thanks a lot.. :)

oh.. thanx.. a lot... :)

i have tried yours but same error.
i have my connection string in web config.. and i used static just cauze i have declared it as global i mean in class.

<connectionstrings>
<add name="tours_travel" connectionstring="Data Source=EXPERT-17A055DD\\SQLEXPRESS;Initial Catalog=Tours_Travel_System;Integrated Security=True;Pooling=False"></add>
</connectionstrings>

i have binded ddlstate in page load..

if (!IsPostBack)
{
{
//state
ddlstate.Items.Insert(0, "select state");
SqlDataAdapter da = new SqlDataAdapter("select * from state", con);
DataTable dt = new DataTable();
da.Fill(dt);
ddlstate.DataSource = dt;
ddlstate.DataTextField = "state_name";
ddlstate.DataValueField = "state_id";
ddlstate.DataBind();
}

and ddlcity in ddlstate's selected index change..

and the i have chkboxes having autopost back on..

and do i have to bind ddlcity also in page load even.. or is it ok to bind in ddlstate's selected index chaged...?

how to do this sir..? i mean i am new, so i need more explanation..

oh.. thanx........
i solved.. :)

i the sense?

hey.. i got the problem.. the thing is that only that ids are displayed having state_id and city_id =1.. :P now plz help to solve it... :)

okes... but what should i do now?

nopes...

but my table does show... :(

how it is solved? my tables shows data.. but i don't know why, its not getting filled

yes it does..

i tried but when i give id 10 its working but not with other id..

how?
i mean i am beginner so i dint get you.. :P

nopes they are foreign keys(state_id and city_id)

nopes they are foregin key..(state_id and city_id)

state and city are the 2 tables having state_id and city_id as primary key,
and that key i used as foreign key in my table named registration
if i make them read only then what if the user want to edit..?

i have a table named registration. from which i fetch this columns.
and in that table i stored state_id and city_id but when we edit those columns i want state name and city name to be displayed.

i tried 1) and 2) step of yours but i dint get your 3) step.

<fields>
<asp:BoundField DataField="user_id" HeaderText="USER ID" ReadOnly="True" />
<asp:BoundField DataField="firstname" HeaderText="FIRST NAME" />
<asp:BoundField DataField="lastname" HeaderText="LAST NAME" />
<asp:BoundField DataField="username" HeaderText="USERNAME" />
<asp:BoundField DataField="state_id" HeaderText="STATE" />
<asp:BoundField DataField="city_id" HeaderText="CITY" />
<asp:BoundField DataField="pincode" HeaderText="PINCODE" />
<asp:BoundField DataField="mobile_no" HeaderText="MOBILE NO" />
<asp:BoundField DataField="phone_no" HeaderText="PHONE NO." />
<asp:BoundField DataField="e_mail" HeaderText="E-MAIL" />
<asp:BoundField DataField="address" HeaderText="ADDRESS" />
<asp:BoundField DataField="reg_date" HeaderText="REGISTRATION DATE" />
<asp:CommandField ShowEditButton="True" />

i have the following fields to be displayed in detailsview.
but here state_id and city_id is shown and they are foreign keys.
and i want to display name of their selected state_id and city_id

i have bind in dropdownlist in form which is going to be filled by the user.

u mean in form..? while registering then yes...
but how in details view..? :(

how?
note:" it is detailsview so here the user can update it"

yup... but the table contains State_id and city_id... as a foreign key

how can you show without saving it..
store using datetime datatype.
hope it works.. :P

yup..
but the thing was that i was not knowing how to start my loop as my ddl values stares from 2 or more..
i mean when i used dis loop to display panel it worked so hoped that this will also work..
and i have ddlvehicle1 upto ddlvehicle10.
but anyways i solved..

"Thanx for your co-operation"

can you tell what is the real matter?

yup..
and it worked for me.......
after writing both for loops

i have dropdownlist having values 1 to 10, and panel 1 to 10. after writing dis code when i select 5 in dropdownlist panel is visible upto 5, bt after that if i select 2 then 2 panel should be visible which is not working.. i mean i don't know dat logic.

i have dropdownlist having values 1 to 10, and panel 1 to 10. after writing dis code when i select 5 in dropdownlist panel is visible upto 5, bt after that if i select 2 then 2 panel should be visible which is not working.. i mean i don't know dat logic.

ya.. bt i have to do both register and book.. and when i do both.. this don't work.. if i do only booking then it is booked.. bt what should i write to register and book

is my insert query ok?

d thing is dat when i pass values and when user_id = 0 then there is confict in table.. of primary key and foregin key

first of all tell me is my insert query ok..?

so then how can i get the value from textbox..?

cmd.CommandText = "usp_booking_insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@user_id", ddluname.SelectedValue);
cmd.Parameters.AddWithValue("@journey_place", txtjplace.Text);
cmd.Parameters.AddWithValue("getdate()", txtpickup_calenderri.Text);
cmd.Parameters.AddWithValue("@pickup_address", txtpickup_address.Text);
cmd.Parameters.AddWithValue("getdate()", txtreturndate.Text);
cmd.Parameters.AddWithValue("@return_address", txtreturn_address.Text);
cmd.Parameters.AddWithValue("@service_id", ddlsname.SelectedValue);
cmd.Parameters.AddWithValue("@vehicle_id", ddlvehicles.SelectedValue);
cmd.Parameters.AddWithValue("@mode_of_payment", rdbtnpayment.SelectedValue);
cmd.Parameters.AddWithValue("@booking_date", System.DateTime.Now.ToString());

dis is my code.. now what should i do?

bt what should i pass in parameters...?

and i only want to use getdate()

thanx....

bt can you tell me how can i get date from the txtbox using getdate(),
as i have hot declared it..in store procedure.

cmd.Parameters.AddWithValue("@",);

what should i write over here..?

hey,
can you tell me how can i get date from the txtbox using getdate(),
as i have hot declared it..in store procedure.

cmd.Parameters.AddWithValue("@",);

what should i write over here..?

okes... thanx a lot... :) :D

as you solved my problem using foreach loop so how can i solve dis using for loop

bt how can i solve dis problem using for loop

hehe.. i forgot that i have to fill datatable...

thanx...a lot...... :P

no the data is not getting bind

DropDownList[] arr = {ddlvnameri1, ddlvnameri2 };

foreach (var d in arr)
{
DataTable dt = new DataTable();
d.DataSource = dt;
d.DataTextField = "vehicle_name";
d.DataValueField = "vehicle_id";
d.DataBind();
}

i wrote dis code for the code what i have asked.

not working .. :(

why to use combo box

<tr>
<td>
<asp:Label ID="lblvnameri1" runat="server" Text="VEHICLE NAME">
</td>
<td>
<asp:DropDownList ID="ddlvnameri1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlvnameri1_SelectedIndexChanged">

<asp:DropDownList ID="ddlvtype1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlvtype1_SelectedIndexChanged">
<asp:ListItem>AC
<asp:ListItem>Non-AC

</td>
<td>
<asp:DropDownList ID="ddlrate1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlrate1_SelectedIndexChanged">
<asp:ListItem>Rate/km
<asp:ListItem>Rate/day

</td>
<td>
<asp:TextBox ID="txtrate1" runat="server">
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblvnameri2" runat="server" Text="VEHICLE NAME">
</td>
<td>
<asp:DropDownList ID="ddlvnameri2" runat="server" AutoPostBack="True">

<asp:DropDownList ID="ddlvtype2" runat="server" AutoPostBack="True">
<asp:ListItem>AC
<asp:ListItem>Non-AC

</td>
<td>
<asp:DropDownList ID="ddlrate2" runat="server" AutoPostBack="True">
<asp:ListItem>Rate/km
<asp:ListItem>Rate/day

</td>
<td>
<asp:TextBox ID="txtrate2" runat="server">
</td>
</tr>


dis is my source code.. i have written <tr> block twice similarly i have to write 10 times and in each <tr> there are many dropdownlists.. and i have to write that code in each ddlselected index changed. which is not feasible.

i have to write dis code on ddlrate,ddlvtype,ddlvnameri selected index changed. and i have ddlrate1,ddlvtype1,dd1vname1....ddlrate10,ddlvtype10,dd1vname10.. so do i have to write dis code onevery ddlselected index changed..

i mean i have to write dis code on ddlrate,ddlvtype,ddlvnameri selected index changed.
and i have ddlrate1,ddlvtype1,dd1vname1....ddlrate10,ddlvtype10,dd1vname10.. so do i have to write dis code onevery ddlselected index changed..

and where should i write the above code..which you gave..

Incorrect syntax near '&'.

its done...
thanx a lot sir for spending ur precious time......

"CODE PROJECT ROCKS"

sure..

cmd.Parameters.AddWithValue("@ac_rate_km", String.IsNullOrEmpty(txtacrate_km.Text) ? DBNull.Value : decimal.Parse(txtrate_km.Text));

compilation error sir..

Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DBNull' and 'decimal'

hey der is red underline under....

DBNull.Value : decimal.Parse(txtrate_km.Text));

i didn't get you.

i am a stater so.... :P

i have not passed null i have checked allow null box in sql

if i do the above

cmd.Parameters.AddWithValue("@rate_km",Decimal.Parse(txtrate_km.Text));
cmd.Parameters.AddWithValue("@ac_rate_km", Decimal.Parse(txtacrate_km.Text));
cmd.Parameters.AddWithValue("@rate_day", Decimal.Parse(txtrate_day.Text));
cmd.Parameters.AddWithValue("@ac_rate_day", Decimal.Parse(txtacrate_day.Text));


i get error as

Input string was not in a correct format.

how and where to write query

how to know which suits me?

i downloaded dis but it wont work as i have framework 4.0. so do i have to install framework 3.5?

can you give some simple one. plz
i am a beginner so.....

it means i want to keep image in my webpage,( as in template we keep) and i want those images get displayed randomly or simultaneously after specific time.

sorry sir.. and thanx a lot.. :)