Comments by graciax8 (Top 67 by date)

if our solutions helped kindly marked it as answered so others will konw. thanks! :)

have you solved it?

what? im sorry i didn't get what you said.

---ahh. now i get it. that's fine sir. It's no big deal. :-)

oops my mistake. i just hope this is what he is looking for. lol.


for (int i = 0; i <= Gridview.Rows.Count - 1; i++) {
GridViewRow row = Gridview.Rows(i);

//For Each checked row In Gridview
bool isChecked = ((CheckBox)row.FindControl("CheckBox1")).Checked;
if (isChecked) {
InsertRow();
//code to insert row

}
}

declare a new connectionstring for your second query.
SqlConnection conn2 = new SqlConnection();

SqlCommand comm2 = new SqlCommand("SELECT TC, Name, Surname, BirthDate, Phone from Pers_Info WHERE TC='"+TCNumber+"'");
comm2.Connection = conn2;

your code is kinda messy i suggest you clean it. hope this finally solves your problem. Goodluck!

read this
http://www.vbforums.com/showthread.php?552425-2008-MDI-form-gradient

post codes you have now.

are you sure your query string is getting a value. can you check the output of Request.QueryString["TC"].ToString(); first? thanks.

xD no prob just me ratings. :) click the stars next to my questions. give the rating dude. lol. thanks!

it is right.

i saw our other question, 'll answer it there.
if my answer helped you. please mark it so we will help you next time. :)

what have you got so far?
post your codes.

mark as answer if it helped you. :)

vb6 or c#? correct or tags.

Change your this

Dim cbMgr As New CheckBoxList
cbMgr.DataSource = dtMgr
cbMgr.DataValueField = "EMPID_T"
cbMgr.DataTextField = "NAME_T"
cbMgr.DataBind()


to this

Dim cbMgr As New CheckBoxList
For Each dr As DataRow In dtMgr.Rows
cbMgr.Items.Add(New ListItem("NAME_T", "EMPID_T"))
Next

is this a web form or an app? complete your information.

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string Sql = "SELECT * FROM Reg WHERE UserName = @UserName";
SqlCommand myCommand = new SqlCommand(Sql, myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@UserName",Label1.Text);

DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = myCommand;
myConnection.Open();
ad.Fill(ds, "a");
DataTable dt = DataSet.Tables[0];

foreach (DataRow dr in dt.Rows)
{
TextBoxdob.Text = dr["DateOfBirth"].ToString();
}

MultiDropDown1.DataSource = dt;
MultiDropdown1.DataTextField = "Column_Name"; //column you want to display
MultiDropdown1.DataValueField = "Column_ID"; //id of that column

myConnection.Close();

what is your problem?

see this.

http://dbaspot.com/sqlserver-programming/393269-how-add-identity-existing-column.html#post1447749^

what is your goal? count the industry? you can do that but need more details.

your problem is in the binding.

your code:

Dim cbSh As New CheckBoxList
cbSh.DataSource = dtShophead
cbSh.DataValueField = "EMPID_T"
cbSh.DataTextField = "NAME_T"
cbSh.DataBind()

for checkboxlist, it should be like:

ListItemCollection itemsCollection = CheckBoxList1.Items;
itemsCollection.Add(new ListItem("item 1", "1"));
itemsCollection.Add(new ListItem("item 2", "2"));

or


ListItemCollection itemsCollection = CheckBoxList1.Items;
itemsCollection.Add(new ListItem("item 1", "1"));
itemsCollection.Add(new ListItem("item 2", "2"));

use for what delete/update/redirect? what code vb.net/c#?
complete your question so we can help you.

same time? post your codes.

get the id of the insertion of Queue_Type, Reference_ID.
get the result and insert into QID,QNo,QID_No fields. For me you can easily do that using stored proc. Goodluck!

post your code.

then select only the columns in the datasource that you want to show in the details view. what have you done so far? show your code.

With all the parameters and declarations you wrote here. I suggest you need to create a stored procedure not a trigger.

what is your question?

you want to select the customers that can still be assigned to a specific project? is that it?

show us the table's columns.

urgent to you. not to us.

i use a function in vb.net a encrypter and decrypter in one. just sharing.

well then place this code on the 1st dropdown,

strPwd = ConfigurationManager.AppSettings("Value1")

and depending on the selected value of the user, fill the 2nd dropdown.

where will the user select Gre or Phi?

winforms

i cant find a working code..

how did you see that is doesn't concat the second statement?

you mean inside a label? when you hover the label control?

why did you assign the column as varchar if you'll calculate it later?

post your connection string.

what progress have you done so far? have you able to make a child popup window and pass a value to the parent window? have you got any codes already?

On the page where only logged in members are allowed to access. :)

on page load event so you can track that he is on the site.
And if it is more than 30 days since he changed the password, you'll redirect him to the change password page.

Hope this helps. Good luck!

why did you downvoted my answer?

you have this OnClick="lnkAddNewQues_Click" but in your code you are missing handles lnkAddNewQues.Click

double click your link button in the design page to make sure it is pointing you to the right event in the code-behind.

Goodluck!

i just want to clarify the name of the table is DateofBirth?

post your code so we can see.

what is the error?

You will get that using the commentID.

SELECT * FROM SII_Replies WHERE Rep.SII_Comment_Id = ''

Ok. If you have other questions just comment and if this is helpful, mark as answer.

Best Regards,
@iamsupergrasya

Hi Necron!

Im sorry I wasn't able to answer you fast. Im on leave. Anyways, try this query and tell if it is right.

SELECT SUM(a.att_duration as 'Total Class Hours'), min(sa.studentName) as 'studentName', SUM(CASE WHEN sa.sa_type = 'P' THEN att_duration end) AS 'Total Hours Attended'
FROM attendance AS a
LEFT OUTER JOIN student_attendance AS sa ON sa.attendanceID = a.attID
LEFT OUTER JOIN periods AS p ON p.perioID = a.attID
LEFT OUTER JOIN students AS s on s.studentID = sa.studentID
WHERE NOT sa.sa_type = 'N/A' AND a.att_courseID = '' AND a.att_periodID = ''
GROUP BY sa.studentID

If you have questions just comemnt and if this is helpful, mark as answer.

Best Regards,
@iamsupergrasya

check the datatype of the column. is it in the right datatype? thanks.

you wanted a view attendance query where after you selected the date, the result would be like:

Required Hours Student Name Attended Hours
30 hours Nancy Ping 15

is that like that?

what database? please complete your question so we can help you faster. :)

thanks anuja. :)

i suggest do it as a button and not as check box. if done as a button. all you need is to do tricks like unhiding the question you would like the applicant to answer. maybe in a placeholder like a panel.

you can do it dude. :)

try this one.
radData is the radiobuttonlist

Dim dt As DataTable
Dim con As New OdbcConnection(ConnStr)
Dim da As New OdbcDataAdapter("select * from phonebook limit 5", con)
con.Open()
Dim ds As New DataSet()
da.Fill(ds)
dt = ds.Tables(0)


radData.DataSource = ds
radData.DataTextField = "name"
radData.DataValueField = "idphonebook"
radData.DataBind()

just add the column on the SELECT statement
SELECT column>, column2, column3 FROM ...

you're welcome ;)

you just used a comma to join the tables.
it's the same.

try this one.

SELECT d.depID, count(e.ID)
FROM tblDep AS d
LEFT OUTER JOIN tblEmp AS e
GROUP BY e.depID
HAVING count(e.ID) > 5