Comments by mukesh mourya (Top 85 by date)

I improved My question over there

After carefully examine i Have Solved Its...:)

Also i tried this but i got error ...




var getch = dm.Challan_Totals.Where(m => m.Challan_No == "2014CH 10002")
.Join(dm.Challans, c => c.Challan_No, d => d.Challan_No, (c, d) => new { c, d })
.Join(dm.Rates,
r => new { r.c.Type , r.d.Own_Comany, r.d.Parti_Name },
s => new { s.Meterial_type, s.Company_Id, s.Parti_Id },
(r, s) => new {r,s.Rate1 }).ToList();



I got this type of error.

Error 1 The type arguments for method 'System.Linq.Queryable.Join<touter,tinner,tkey,tresult>(System.Linq.IQueryable<touter>, System.Collections.Generic.IEnumerable<tinner>, System.Linq.Expressions.Expression<system.func<touter,tkey>>, System.Linq.Expressions.Expression<system.func<tinner,tkey>>, System.Linq.Expressions.Expression<system.func<touter,tinner,tresult>>)' cannot be inferred from the usage. Try specifying the type arguments explicitly. G:\$WORKS\Iqbal Silks\Iqbal Silks\Billing_Control\Genbill.xaml.cs 59 21 Iqbal Silks

help me.....

i m new for lambda so i don't Know how does use and condition in inner joining like in My code

INNER JOIN [dbo].[Rate] AS [t2] ON [t0].[Type] = [t2].[Meterial_type]
AND [t1].Own_Comany = [t2].Company_Id
AND [t1].Parti_Name=[t2].Parti_Id

--repost--

This code I tried in C#

var getch = dm.Challan_Totals
.Join(dm.Challans,
c => c.Challan_No, d => d.Challan_No,
(c, d) => new { c, d }).Select(b => b)
.Join(dm.Rates,
r => r.c.Type, s => s.Meterial_type &&
q => q.c., sq => sq.Meterial_type,
(r, s) => new { r, s.Rate1 })
.Where(m => m.r.c.Challan_No == "2014CH 10002");

yas Mr. Maciej Los

then problem is that how can i collect cell (id) of selected row in Array list
here my code is not worked

please help me...

k....
i have data grid in my wpf application which are bind from sql database

datagrid also have chechbox as to select row .

i saw many solution but no any solution was worked Properly

i has bind data grid bind from database using linq
here problem is that how can i check which data row are checked (checkbox) and how can i select this particular cell of that row

Mrs. BillWoodruff, i have a question to you, does it necessary to be installed ms sql server management software on user computer system to access database or any other way is possible

Thanks allot Mrs. BillWoodruff...... i hope This Atrial help me to Understandable ans help to learn it.

thaks to suggest me...

i luring linq lambda expression and this is my first application on it so i confused here to collect data using loop in list to grouping it
sorry.
hv gd dy :)

sorry all ....

solved it my self....

sorry for all that.

first is.. "DDl" means Drop down list or ComboBox .
Second.. "Category" means -products which are belong then
third is Code are not work at all

var items= myList .GroupBy(g => g) .Select(t => new {ctgry= t.Sum(), key= t.Key });
foreach (var group in items)
Console.WriteLine ( group.key + " " + group.ctgry);

please explain me from frist

please

sorry sir all code are Deleted by irritated that........... :|
sorry.

thank you sir

sir....


here i got error in if (getdata.Any())

sir...

here in yr solu. you Contain item in StringBuilder and use foreach loop.

if i want to print this are item on diffrent -diffrent Label like Cloth_Name on lblCloth_Name (Label) and Cloth_Type (Label) on lblCloth_Type without make foreach loop ,then how can i do that.

sorry is not "getdate", both are "getdata"

sorry is not "getdate", both are getdata

is this possible to know which textbox textchanged event fire using this keyword in using same function

here , my project have 16 textboxes ,does all textbox has textchanged Event to print item name on label ...?

Not worked

It's not work

It's not work :(

that my Improve question

sr here in my application i have option to create backup of database as button event then how can i do this please guide me ....help me

sir... wont to know about, how to manage session of user with security ..
when user logout from his profile then no body can access his profile

ya sr about my code is describe .... please help me

sir its execute event no. of rows

please help me sooooooonn please :(

sir may you guide me for create this

here in gv , when i clicked row its collect Student roll no . and then goes to database and collect info. of student whis are describe in below code .

here this all code is executed around n around equal to no. of column have gv

public void GridViewstdntrerd_click(object sender, DataGridViewCellEventArgs e)
{
{
while
(panelmarkSubjectname.Controls.Count > 0)
panelmarkSubjectname.Controls[0].Dispose();
while
(pnlmarksubjecttype.Controls.Count > 0)
pnlmarksubjecttype.Controls[0].Dispose();

while
(pnlmarkfillmarks.Controls.Count > 0)
pnlmarkfillmarks.Controls[0].Dispose();

for (int j = panelmarkSubjectname.Controls.Count; j > 0; j++)
panelmarkSubjectname.Controls[j].Dispose();

for (int j = pnlmarksubjecttype.Controls.Count; j > 0; j++)
pnlmarksubjecttype.Controls[j].Dispose();

for (int j = pnlmarkfillmarks.Controls.Count; j > 0; j++)
pnlmarkfillmarks.Controls[j].Dispose();

pictureBox1.Image = null;
}

if (e.RowIndex < 0)
{
return;
}
else
{
if ((string)GridViewstdntrerd[0, e.RowIndex].Value.ToString() != DBNull.Value.ToString())
{
Subneme = (string)GridViewstdntrerd[0, e.RowIndex].Value;
string value = "SELECT [Student Rollno],[Student Name], [Student Last Name],[Student Class], [Student Section],[Student DOB],cetagory,[Student_Image] FROM dbo.Student_profile WHERE [Student Rollno]='" + Subneme + "'";

DataTable tableinfo = Class1.Datatablebind(value);

if (tableinfo.Rows.Count > 0)
{
string collectSubject = "collectSubject";
DataTable tablesubject = Class1.Datasetbindfromstrprocdr(Subneme, collectSubject);

count = tablesubject.Rows.Count;
for (int i = 0; i < count; i++)
{
Label label = new Label();
int count1 = (panelmarkSubjectname.Controls.OfType<Label>().ToList().Count) + 1;
label.Location = new Point(40, (45 * count1) + 2);
label.Size = new Size(60, 20);
label.Name = tablesubject.Rows[i][0].ToString();
label.Text = (tablesubject.Rows[i][0]).ToString();
panelmarkSubjectname.Controls.Add(label);

// Subject type

Label label1 = new Label();
// int count2 = (pnlmarksubjecttype.Controls.OfType<Label>().ToList().Count)+1;
label1.Location = new Point(0, (45 * count1) + 2);
label1.Size = new Size(60, 20);
label1.Name = tablesubject.Rows[i][1].ToString();
label1.Text = (tablesubject.Rows[i][1]).ToString();
pnlmarksubjecttype.Controls.Add(label1);

// Generate Text box For Collect Marks

TextBox textbox = new TextBox();
// count = groupmarks.Controls.OfType<textbox>().ToList().Count;
textbox.Location = new Point(30, 45 * count1);
textbox.Size = new Size(80, 20);
textbox.Name = "Txt" + tablesubject.Rows[i][0].ToString();
//textbox.TextChanged += new System.EventHandler(this.TextBox_Changed);
pnlmarkfillmarks.Controls.Add(textbox);
}

{
rollno = tableinfo.Rows[0][0].ToString();

string shortDate = DateTime.Now.ToString("yyyy");
txtsession.Text = " " + shortDa

ya sir off-course

ok...

but this type problem is occur when i generate dynamic label from loop on click grid-view row ,

here problem is loop executed no of rows of gridview

do i post code here you wont to check that

sir, when i checked "rdodate" radio button its execute "private void rdodate_CheckedChanged(object sender, EventArgs e)"


and also execute " private void rdomonth_CheckedChanged(object sender, EventArgs e)"

sir i have put there .... :(

ya sir i am using radio button to determine

also this type of problem is generating when i generate dynamic label on condition (if else)

sir, win form have a date picker and a combobox in win Application

i wont when datepicker is enable then at this time conbobox be disable

thank to nice article ..
sir i have one more question to you,
in my application, i have database (MySQL server) for insert and retrieve record then
how can make data base when i install this setup on client pc, and what i do for make this type of exe file.
actually sir , i m new for win application so please guide me .... please help me

ya BillWoodruff, i fully accept ravi post, but this was my one more Question. please guide me ...

sir i am new for win application so i have no idea for make a .exe file with database(Sql server) attachment, and how can i run script of database with installation this exe

above Show My Code.... i have no idea what i do for it please any one help me ...its urgent

//here i m bind grid view from database in window form


private void Subjectseup()
{
gvsubjectsetup.DataSource = null;
try
{
string querystring = "SELECT * FROM dbo.Subjects";
DataTable datatable = Class1.Datatablebind(querystring);

gvsubjectsetup.AutoGenerateColumns = false;

//Set Columns Count
gvsubjectsetup.ColumnCount = 8;

//Add Columns
gvsubjectsetup.Columns[0].Name = "Subjectid";
gvsubjectsetup.Columns[0].HeaderText = "Subject Id";
gvsubjectsetup.Columns[0].DataPropertyName = "Subject_id";

gvsubjectsetup.Columns[1].HeaderText = "Subject Name";
gvsubjectsetup.Columns[1].Name = "Subject";
gvsubjectsetup.Columns[1].DataPropertyName = "Subject Name";

gvsubjectsetup.Columns[2].HeaderText = "Allow Class";
gvsubjectsetup.Columns[2].Name = "AllowClass";
gvsubjectsetup.Columns[2].DataPropertyName = "Allow Class";

gvsubjectsetup.Columns[3].Name = "SubjectType";
gvsubjectsetup.Columns[3].HeaderText = "Subject Type";
gvsubjectsetup.Columns[3].DataPropertyName = "Subject Type";

gvsubjectsetup.Columns[4].HeaderText = "Subject Valuation";
gvsubjectsetup.Columns[4].DataPropertyName = "Subject valuation";

gvsubjectsetup.Columns[5].HeaderText = "Create Date";
gvsubjectsetup.Columns[5].DataPropertyName = "Create date";

gvsubjectsetup.Columns[6].HeaderText = "Category";
gvsubjectsetup.Columns[6].DataPropertyName = "category";

// add a button column.
DataGridViewButtonColumn updatebutton = new DataGridViewButtonColumn();
// DataGridViewButtonColumn addsectionbutton = new DataGridViewButtonColumn();
DataGridViewButtonColumn deletbutton = new DataGridViewButtonColumn();

updatebutton.HeaderText = "Update Classes";
updatebutton.Text = "Update";
updatebutton.Name = "btnUpdate";

// addsectionbutton.HeaderText = "Add Section";
// addsectionbutton.Text = "Add Section";
// addsectionbutton.Name = "btnaddsection";

deletbutton.HeaderText = "Delete Classes";
deletbutton.Text = "Delete";
deletbutton.Name = "btnDelete";

updatebutton.UseColumnTextForButtonValue = true;
deletbutton.UseColumnTextForButtonValue = true;
// addsectionbutton.UseColumnTextForButtonValue = true;

gvsubjectsetup.Columns.Add(updatebutton);
// gvsubjectsetup.Columns.Add(addsectionbutton);
gvsubjectsetup.Columns.Add(deletbutton);

// ADD click event on button

gvsubjectsetup.CellClick += new DataGridViewCellEventHandler(gvsubjectsetup_click);
// gvsubjectsetup.DataSource = datatable;
gvsubjectsetup.DataSource = new BindingSource(datatable, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}








// here i m call this mathod on click "showdata " Button



void gvsubjectsetup_click(object sender, DataGridViewCellEventArgs e)
{
if ((e.RowIndex > 0) || (e.ColumnIndex == gvsubjectsetup.Columns["btnUpdate"].Index) || (e.ColumnIndex == gvsubjectsetup.Columns["btnDelete"].Index))
{
if (e.ColumnIndex == gvsubjectsetup.Columns["btnUpdate"].Index)
// MessageBox.Show("hi this is section"+ taskID);
{
int id ;
id = (Int32)gvsubjectsetup[0, e.RowIndex].Value;
string s =

ok, i explane you ...
in my win form , have a text box and a grideview(which are bind from db )
I wont, when i change text box value (for searching in gridviwe those value) then highlighted text (or words in yellow color) in grid view

ya sir, this is win form.

ok. i explain it.

in my win forms, i have a ribbon menu in above and a panel in below.
ribbon menu have 3 button (add record, update Record, View Record )

and i wont, when user clicked on add record button(which are in ribbon menu) then

for add new Record , some text-boxes (which are make by me ) show in below panel .

and when user are clicked on Update Record then

some element are show those panel( also on those place) and hide previous panel content (add record button content)

(just like tab control type )

sorry for bad English....


please help me
Improve solution Permalink

OK ... sir how can i show form in mainform panel (like iframe in web html ).

sir this method (code) is not working as i wont.

no sr i don't wont to show any controls show in panel all time .

i wont to like m s office type . in which, when clicked on any menu controls then in below panel element are change according element
please guide me how can i do

sr i am new for it show just difficulty with me to make as please help me ...

you can try this

you can pest this code in class(.cs)page and coll its on button click

ok .. you can collect all information about user registered from database(which are add recently register ) and send on your email id ,as msgbody.
you can do as

sir,

my code is -

if (uploadfile.HasFile)
{
string Filename = uploadfile.PostedFile.FileName;
MailAttachment mailattechment=new MailAttachment(Filename,MailEncoding.Base64);
confirmationmail.Sendmailadmintouser(txtadress, txtmassege, txtSubject,mailattechment);

}
and in .Cs (Class) Page-



public static string Sendmailadmintouser(string emailidlist, string msgbody, string msgSubject,______________ mailattechment)
{
string res ="";




string mailid = string.Empty;
MailMessage msg = new MailMessage();
SmtpClient smtp = new SmtpClient();
mailid = emailidlist[j].ToString();
msg.From = new MailAddress("admin@gmail.com");
msg.To.Add(mailid);

msg.Subject = msgSubject.ToString();
msg.Body = msgbody.ToString();
msg.IsBodyHtml = true;
msg.Priority = MailPriority.Normal;
smtp.Credentials = new NetworkCredential("mukesh@gmail.com", "Password");
smtp.Port = 587;
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;

smtp.Send(msg);
return res="Send";





//
How can Handel mailattechment File in class

sir this article is not work properly as i wont

here i have class (.cs page) which are used mor then one pages...

and i wont to call each pages according my declaration

Thanks its working .....:)

no not that auto completed type value which r remembered by text box

ok ... in simple word, how can i Remove those text box cookies which r remember by this textbox after Submission value of textbox.....

i mean , in vs control,its give us as file uploder Like choose file and show path of file txtbox (like that)....

and in google mail, when we compose a mail and attached a file in popup of google mail then a icon (just like as show pin style) just i wont that type.....

Thanks A lot .........

ok..
i have value in column like -
1,
2,
-5,
10,
20,
-10,
-23,
-24,
24,
...etc

and i wont show as 'Expired' where value in negative just like as-
1,
2,
Expired,
10,
20,
Expired,
Expired,
Expired,
24,
...etc

ok..

I am unable to do.
can you take my screen form team-viwer.?

ok..

i have column 'remain_day' which has some remain days of membership of user, some remain days and some expired days(days is not more yet). and i get from this command


select *, Time_duration-DATEDIFF(d, Start_date, GETDATE())as SUBS_LEFT,
--(case when DATEADD(d, Time_duration, Start_date)>GETDATE() THEN '' else 'Expired' end) IS_ENDED
FROM dbo.User_profile1


sorry for bad english

no not in column IS_ENDED i wont in column SUBS_LEFT where we get negative value only, in positive value as it is have

@Vedat Ozan Oner, thanks to suggest me
but i wont to write "Expired" where i get negative value in column SUBS_LEFT, in grid-view .....please help me