Comments by IndrajitDasgupat (Top 135 by date)

in sql server i m getting my datetime format as 'yyyy-mm-dd' but in c# i m getting as 'dd-mm-yyyy', so i need to change the format according to sql server datetime

Yes I am working like that but service is not started

actually my design in C:/ in Code 128 now if I select a row in excel sheet then click print button it should print the bar-code from Bar-code printer .

Hi
My project is showing report fine but if i diploy in IIS then report is not showing

I am doing the same but create shortcut is not comming

I am trying that but showing error

yes it something like that or may be situation like
Karthik (Red Color),(Bangalore, Majestic (Yellow Color))
in the same line 50% word is red and others is yellow.

It should show in ASP.Net TextBox like below -
Karthik (Red Color)
Bangalore, Majestic (Yellow Color)

here my question is to display multiple color of text in the same text box in ASP.Net

but it is windowsCE application

can you please show me the process how to put IP address / name of the machine with the URL(http://localhost:4894/TestWebService_Hello/)

but here I am not getting value in a particular cell of a column because that column has no alphabet only numeric value
when I bind it with data table then it not come from excel sheet So what should I do

Thanks for Precious help
Indrajit Dasgupta

Here the column in the excel is general format and I loaded it on GridView now my Intention is modify the particular column in GridView so it should display 2 digit after decimal

suppose I have 3 Rows
1 x A
2 Y B
3 Z C
Now I am deleting row No 2 then it should display like below
1 x A
2 Z C

the data is not coming from Data Base it is coming through scan data from RFID Tag

I had given the same "SortOrder" but same error is comming

I am getting the following error
"the type or namespace 'sortOrder' could not be found are you missing a using directive or assembly reference"

here sort property is not there in Listview control so any alternative to display listView in sort

But in Device application
// Sort the items in the list in ascending order.
listView1.Sorting = SortOrder.Ascending;

These property is not there

I mean in C# windows application we are using time_Tick event below is code

private void timer1_Tick(object sender, EventArgs e)
{
label1.Location = new Point(label1.Location.X + 5, label1.Location.Y);

if(label1.Location.X > this.Width)
{
label1.Location = new Point(0 - label1.Width, label1.Location.Y);
}
}
Now how can I do same thing in WPF

In this STR I have 10 field so what ever new string I am going to input it should check is there 10 fields or not

can u show me little code about that if u don't mind

gvSchedules what is this in your code please define

If Data Grid View generating in Run Time Auto generated it is showing error in your code in the below line
else
{
MergeCells(RowsToMerge[0], RowsToMerge[1], dataGrid.Columns["Rack"].Index, isSelectedCell(RowsToMerge, dataGrid.Columns["Rack"].Index) ? true : false);
CollectMergedRowsInFirstColumn(RowsToMerge[0], RowsToMerge[1]);
RowsToMerge[0] = -1;
}

No I will SOLVE the issue.I could not catch the issue immediately because I don't have master that is my problem you just point it I will definitely fix the issue by my self.
Please keep your helping attitude ALIVE

as soon as it is entering there it shows error even it is not going to merge function also i.e.
private void MergeCells(int RowId1, int RowId2, int Column, bool isSelected)
{
}
if you want I can give you enter code with my database backup

http://www.codeproject.com/Questions/152113/How-can-i-merge-DataGridView-Rows-Cells-with-Equal

if I fetch the data from SQL Server and creating Data Grid View in run time
then error in the following area error is coming
Error is : "Object reference not set to an instance of an object."
But Why Reference object here

private void Merge()
{
else
{
MergeCells(RowsToMerge[0], RowsToMerge[1], dataGrid.Columns["rack"].Index, isSelectedCell(RowsToMerge, dataGrid.Columns["rack"].Index) ? true : false);
CollectMergedRowsInFirstColumn(RowsToMerge[0], RowsToMerge[1]);
RowsToMerge[0] = -1;
}
}

if you are .Net developer then I can send you a link where I got the same article
but small doubt is there
Please response

Yes I tried same in C# windows form Data Grid View control but there is also same problem that is group making same table is not possible.

Thanks

Yes it is coming like below
Rackgrp Rack
a a1
a a2
b b1

But My requirement Like below
Rackgrp Rack
a1
a a2
a3

b1
b b2

Thanks for your helping attitude

Hi
I am little new in SQL if give little more information about your code then it will help me lot to solve the issue
Thanks

Yes Sir, it is working now but data grid view is coming very small size I want to make it bigger in run time is it possible

I tried but it is Not comming

Here I post the code please check this

private void Form1_Load(object sender, EventArgs e)
{
string str = "SP_TestForAccess";
OleDbCommand cmd = new OleDbCommand();
cmd = new OleDbCommand(str, conn);
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
this.dataGridView1.DataSource = dt;

}
private void dataGridView1_CellFormatting_1(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value != null)
{
if (e.Value.Equals(string.Empty))
e.CellStyle.BackColor = Color.Green;
else
e.CellStyle.BackColor = Color.Blue;
}
}

Your new update is showing all same colour except first cell
But I need blue colour only in 20,40,60,45,35,...,23 and 40 and blank box green colour and A1,A2,B1,C1 should be default data grid view colour
Thanks for your support

Your new update is showing all same colour except first cell
But I need blue colour only in 20,40,60,45,35,...,23 and 40 and blank box green colour and A1,A2,B1,C1 should be default data grid view colour
Thanks for your support

I am using windows application under which event I should I put this code

But I am using windows application in this case what should I do

Thank you Sir It is working fine for SQL 2005

in query analyser following errors getting I tried but abject point I am not getting

Server: Msg 170, Level 15, State 1, Line 65
Line 65: Incorrect syntax near '+'.

If possible please help

but in SQL2000 pivot not support any alternative please

Yes Sir your code is working fine
here Rack i.e. A1,B1,C1 if I add another one D1 in database table it takes automatically
But in the case cell i.e X,Y,Z if I add another cells in table like M,N,...,O,P then it is not adding automatically what should for that

Thanks for your Great help

Yes it is working but C1 rack is not able to add
C1 Z 34
c1 z 22
and not able to display like below

C1 Null Null 56
it shows error

Thanks

Currently it is giving like below
Rack X Y Z
A1 20 30 40
A1 20 30 40
A1 20 30 40
B1 70 60 Null
B1 70 60 Null

So A1 it should come one line and B1 also should also in one line
and moreover C1 should display like below
C1 Null Null 56
Thanks

My original table is like below
Rack cell qty
A1 X 20
A1 Y 30
A1 Z 40
B1 X 70
B1 Y 60
C1 Z 34
C1 z 22

Now my table should display like below
Rack X Y Z
A1 20 30 40
B1 70 60 Null
C1 Null Null 56

Thanks

Yes Sir it is working but if A1 has x,y,z three value then it shows three rows but I need in one row and if you little explain how it works then it will help me lot in future.
Thanks a Lot

But all button comes in same location how to change the location of every button in different location in the panel

Still I have doubt I am not able to fetch the output statement to my application

But in this case if I am separating the strings and each string should enter to each column in the data table but I can not enter line by line in the data table

private void btnReadFile_Click(object sender, EventArgs e)
{
string[] lines = File.ReadAllLines(txtFilePath.Text); // Here I got all the 10 lines of the file
Hashtable ht = new Hashtable();
foreach(string line in lines)
{
//here I want to enter every line in the hash table with each column
//Is it possible? if it is possible please help
}
}

Here I put the code but not able to insert in hash table can you please help me

each line contain string data type with TAB space for every column
if you want more please let me know

I put the code please check

Here I got the all the array string of the text file Now I want to put every line in the hash table

Sir I got it by using IndexOf
if(line.IndexOf(match)!=-1)
{
}
thanks for giving valuable hints

if it is selecting with first name which is unique then how can I do

Data table is not empty but it is not coming filter data which I mentioned above

That form has logo and some command button & panel if I select command button then the panel will change the color so the entire modified form should give the print

Yes It is working fine but how to make the same size of every image to that picture box

Yes it is working fine

I remove system.Data again added now it is working fine
Can u give me the connection string format for that
Thanks

I added but it is not coming

Thank U sir it is working fine

DSN=BillingCtl;UID=sa;PWD=sa

It is System DSN

Yes I am using System DSN

connPrt=new OdbcConnection(pObj.connection());
The Error is Below---
Format of the initialization string does not conform to specification starting at index 0.

connPrt=new OdbcConnection(pObj.connection());
The Error is Below---
Format of the initialization string does not conform to specification starting at index 0.

What is the use of "\d+" in this method? I did not understand

partnumber type is number for me the problem is unitprice which type is currency and I want to store it in a variable so further I can go for other calculation with this

public string connection()
{
string p;
p = Application.StartupPath.ToString() + @"\conn.ini";
string str;
FileStream fs;
str = "";
try
{
fs = new FileStream(p, FileMode.Open, FileAccess.Read);// error from here it is going to catch block

yes you are write splite[i] is contain junk character but the last one is showing junk character in the concatenation.How can I remove that can u give me some idea Sir ji

Below I m giving code please check
string allData = str;
string[] splite = allData.Split('\n');
string FstArray = splite[3];
string SndArray = splite[4];
string ThrdArray = splite[7];
textBox2.Text = FstArray + Environment.NewLine + SndArray + Environment.NewLine + ThrdArray;
r.Close();
fs.Close();

how can I remove the junk character

yes it is working but last one is taking a junk character

It shows all line But I need only third,fourth and seventh line how can I do that please help

it is working fine.
Thanks

its like a string not file name because my client will get it as string only

What about .DAT because I don't need .DAT so how to remove that from the string

Thank U it is working now.
I m new in this field how can I learn all this can u please suggest me if u don't mind

here I give the code Please check
private void grid()
{
//AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;
//the DataGridView
DataGridView dgv = new DataGridView();

dgv.Columns.Clear();
DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
string str;
str = "SELECT * FROM excess";
OdbcCommand cmd = new OdbcCommand(str,con);
OdbcDataAdapter da = new OdbcDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds, "ExcessGView");

dgv.Columns["excess"].Width = 270;

//set the DataGridView DataSource
dgv.DataSource = ds.Tables["ExcessGView"];

}

now it is showing error----
//the DataGridView
DataGridView dgv = new DataGridView();

dgv.Columns["excess"].Width = 270;
"Object reference not set to an instance of an object."

Yes I had done like below
//the DataGridView
DataGridView dgv = new DataGridView();
dgv.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;

dgv.Columns("excess").Width = 270;
dgv.Columns("excess").DisplayIndex = 1;
dgv.Columns("excess").ReadOnly = True;
dgv.Columns("excess").HeaderText = "Excess";
but in column it is showing error that it is looks like method
what should i do?
please help!

how I can make the size of every column of data grid view according to user, please help

Thanks it is working

Thank U Sir it is working

How can I check the path of DB from my project
Please help

Yes my DB contain table "admin"
How can I check the path of DB from my project
Please help

how can I check the connection string please help

Yes I try with this also but same problem

private OleDbConnection conn; //SqlConnection conn = new SqlConnection();
private string conStr = @"Provider=Microsoft.ACE.OLEDB.8.0;Data Source=C:\Documents and Settings\horton\Desktop\TestExcel.xlsx;Excel;Extended Properties=Excel 8.0";

it is showing error on " conn.Open();" code

Error is : The 'Microsoft.ACE.OLEDB.8.0' provider is not registered on the local machine.

it is showing error on " conn.Open();" code

Error is : The 'Microsoft.ACE.OLEDB.8.0' provider is not registered on the local machine.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
using System.Drawing.Printing;
using Excel = Microsoft.Office.Interop.Excel;
using System.Data.OleDb;


namespace WindowsApplication1
{
public partial class Form1 : Form
{
private OleDbConnection conn; //SqlConnection conn = new SqlConnection();
private string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\horton\Desktop\TestExcel.xlsx";
//@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\horton\Desktop;Extended Properties=TestExcel";
//@"Data Source=HORTON-2A5CB16E\SQLEXPRESS;Initial Catalog=Temp;Integrated Security=SSPI;Max Pool Size=100;Connect Timeout=1000";
public Form1()
{
InitializeComponent();
conn = new OleDbConnection(conStr);
conn.Open();
}
private void Form1_Load(object sender, EventArgs e)
{
clr();
txtRollNumber.Focus();
label1.Enabled = false;
label2.Enabled = false;
}

Now it is showing "Format of the initialization string does not conform to specification starting at index 101." in following code
conn = new OleDbConnection(conStr);
I m not able to understand what should i have to do

I had given but it is showing connection error

I m using that
using Excel = Microsoft.Office.Interop.Excel;
using System.Data.OleDb;

now I m giving
private string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\horton\Desktop\TestExcel;Extended Properties=""text;HDR=Yes;FMT=Delimited"

then also showing connection error

after enter data to the text box and press enter key it should retrieve record for that particular data from table

Now it is showing "implicitly convert type bool to int"

if(txtRollNumber.Text==" ")
it shows
Cannot implicitly convert type 'string' to 'bool'

I m new to sql but I know that we r using sql 2008 that is why I wrote here SQL 2008 but below I m giving more clarity---
No I m not getting LoginName field and other. it is showing LoginName field and other my sytem name that from my system some one send mail to a particular client but it has done by some other person from Remote Desktop Connection through my system so how can I get that system name or any clue Please help

No I m not getting LoginName field and other. it is showing LoginName field and other my sytem name that from my system some one send mail to a particular client but it has done by some other person from Remote Desktop Connection through my system so how can I get that system name or any clue Please help

replace(fieldname, '#CNA', 'CNB') in this scenario it is not always #CNA it may be different so I have to select field name and in the place CNB it may be different character so I have to pass it from front end, then what will be the function?

no this is not working for me

Thanks for help I had done what u told

Hi
If U don't mind can U give me little more details because I m new to this, so it will help me to go ahead
Thanks for help

it is urgent true but not for others it only for me even my intention is not to break other head for my problem I apologizes for that.

I m using OpenFileDialog code is below
Private Sub btnBrowse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBrowse.Click
Try
ofdDocToUpload.Filter = "All files (*.*)|*.*"
If ofdDocToUpload.ShowDialog() = Windows.Forms.DialogResult.Cancel Then
Exit Sub
End If
txtDocPath.Text = ofdDocToUpload.FileName
Catch ex As Exception
LogApplicationsErrors(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, Me.Name)
End Try
End Sub

Back space

and back space

But it is not allowing paste

But it is not allowing paste

But does not allow to paste

No it disallow only two punctuation character that is "," and "."

Windows Forms

Dear Abdul Quader Mamun,
If U don't mind can u give coding so it will help me how to write bcz I m new to this

Thanks it is working fine

There is a button where I click for uploading file it will pop up windows where I have to select the file and click then It should display the file name in my search grid view table where I selected the record to upload file against the particular record.Uploading files can be any kind of file.

There is a button where I click for uploading file it will pop up windows where I have to select the file and click then It should display the file name in my search grid view table where I selected the record to upload file against the particular record.Uploading files can be any kind of file, Yes it should be

If any other information please feel free to write

I commented this line'dgvSearch.Columns.Add("MDS_RecNum", "Customer_ID")
and in bellow i change
dgvSearch.Columns(0).DisplayIndex = 1
'dgvSearch.Columns(0).ReadOnly = True


dgvSearch.Columns(1).Width = 25
dgvSearch.Columns(1).DisplayIndex = 0
dgvSearch.Columns(1).HeaderText = ""
dgvSearch.Columns(0).ReadOnly = True

Thanks for try

Thanks

sorry I didn't understand plz describe

Thanks it is working now

now I had given all the details please check

Thanks I got it in Table

every thing is right but problem is started when I m trying same in group box bcz I have 3 group box in every group box there are 2 radio button in first tab page
so plz help